SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002469s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037325s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19060740 LIMIT 5 [ RunTime:0.079581s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19060740 ORDER BY `minOrder` ASC [ RunTime:0.009658s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19060740 ORDER BY `unit` DESC [ RunTime:0.026154s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19060740 LIMIT 2 [ RunTime:0.051613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19060740 ORDER BY `minOrder` ASC [ RunTime:0.050669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19060685 LIMIT 5 [ RunTime:0.044792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19060685 ORDER BY `minOrder` ASC [ RunTime:0.034739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19060685 ORDER BY `unit` DESC [ RunTime:0.025728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19060685 LIMIT 2 [ RunTime:0.033707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19060685 ORDER BY `minOrder` ASC [ RunTime:0.007414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19040199 LIMIT 5 [ RunTime:0.018375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19040199 ORDER BY `minOrder` ASC [ RunTime:0.023677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19040199 ORDER BY `unit` DESC [ RunTime:0.040491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19040199 LIMIT 2 [ RunTime:0.016603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19040199 ORDER BY `minOrder` ASC [ RunTime:0.017276s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51036037 LIMIT 5 [ RunTime:0.042723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51036037 ORDER BY `minOrder` ASC [ RunTime:0.048820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51036037 ORDER BY `unit` DESC [ RunTime:0.034271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51036037 LIMIT 2 [ RunTime:0.069334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51036037 ORDER BY `minOrder` ASC [ RunTime:0.024487s ]
select * from pdf where partno='cy7c109d-10zxi' and brandshort='infineon technologies' limit 1 [ RunTime:0.046839s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'cy7c109d-10zxi' OR `brand` LIKE 'infineon technologies%' ) ) LIMIT 1 [ RunTime:0.021538s ]
SELECT `id` FROM `stock` WHERE `id` <> 51036037 AND `partno` = 'cy7c109d-10zxi' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.044780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19060685 [ RunTime:0.052170s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50161688 LIMIT 5 [ RunTime:0.033015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50161688 ORDER BY `minOrder` ASC [ RunTime:0.033555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50161688 ORDER BY `unit` DESC [ RunTime:0.056934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50161688 LIMIT 2 [ RunTime:0.026706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50161688 ORDER BY `minOrder` ASC [ RunTime:0.008850s ]
select * from pdf where partno='CY7C109D-10ZXI' and brandshort='Cypress Semiconductor Corp' limit 1 [ RunTime:0.031314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C109D-10ZXI' OR `brand` LIKE 'Cypress Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.028978s ]
SELECT `id` FROM `stock` WHERE `id` <> 50161688 AND `partno` = 'CY7C109D-10ZXI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cypress semiconductor corp%' ) [ RunTime:0.044141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19040199 [ RunTime:0.040316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37358735 LIMIT 5 [ RunTime:0.030393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37358735 ORDER BY `minOrder` ASC [ RunTime:0.063701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37358735 ORDER BY `unit` DESC [ RunTime:0.040305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37358735 LIMIT 2 [ RunTime:0.032264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37358735 ORDER BY `minOrder` ASC [ RunTime:0.016596s ]
select * from pdf where partno='CY7C109D-10ZXI' and brandshort='Cypress Semiconductor Corp' limit 1 [ RunTime:0.007432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C109D-10ZXI' OR `brand` LIKE 'Cypress Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.004233s ]
SELECT `id` FROM `stock` WHERE `id` <> 37358735 AND `partno` = 'CY7C109D-10ZXI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cypress semiconductor corp%' ) [ RunTime:0.011478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19040199 [ RunTime:0.019153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37371036 LIMIT 5 [ RunTime:0.033325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37371036 ORDER BY `minOrder` ASC [ RunTime:0.048140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37371036 ORDER BY `unit` DESC [ RunTime:0.037606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37371036 LIMIT 2 [ RunTime:0.094683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37371036 ORDER BY `minOrder` ASC [ RunTime:0.050777s ]
select * from pdf where partno='CY7C109D-10ZXIT' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.053559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C109D-10ZXIT' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.051101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37370075 LIMIT 5 [ RunTime:0.051394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37370075 ORDER BY `minOrder` ASC [ RunTime:0.021583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37370075 ORDER BY `unit` DESC [ RunTime:0.012167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37370075 LIMIT 2 [ RunTime:0.018081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37370075 ORDER BY `minOrder` ASC [ RunTime:0.022101s ]
select * from pdf where partno='CY7C109D-10ZXI' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.040740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C109D-10ZXI' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.034009s ]
SELECT `id` FROM `stock` WHERE `id` <> 37370075 AND `partno` = 'CY7C109D-10ZXI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.055458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19060685 [ RunTime:0.047688s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019344s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042489s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016747s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037815s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012872s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007031s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021367s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CY7C109D-10ZXI%' OR `brand` LIKE 'CY7C109D-10ZXI%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009046s ]