SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001591s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005962s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17061422 LIMIT 5 [ RunTime:0.005462s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17061422 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17061422 ORDER BY `unit` DESC [ RunTime:0.011749s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17061422 LIMIT 2 [ RunTime:0.006498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17061422 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19050623 LIMIT 5 [ RunTime:0.023815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19050623 ORDER BY `minOrder` ASC [ RunTime:0.032943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19050623 ORDER BY `unit` DESC [ RunTime:0.022527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19050623 LIMIT 2 [ RunTime:0.031361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19050623 ORDER BY `minOrder` ASC [ RunTime:0.018245s ]
select * from pdf where partno='71V67603S133BQGI' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.013300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16018896 LIMIT 5 [ RunTime:0.016209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16018896 ORDER BY `minOrder` ASC [ RunTime:0.006792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16018896 ORDER BY `unit` DESC [ RunTime:0.013333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16018896 LIMIT 2 [ RunTime:0.024634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16018896 ORDER BY `minOrder` ASC [ RunTime:0.019191s ]
select * from pdf where partno='71V67603S133BQGI8' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.015357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15282381 LIMIT 5 [ RunTime:0.038910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15282381 ORDER BY `minOrder` ASC [ RunTime:0.019536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15282381 ORDER BY `unit` DESC [ RunTime:0.029234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15282381 LIMIT 2 [ RunTime:0.027510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15282381 ORDER BY `minOrder` ASC [ RunTime:0.009662s ]
select * from pdf where partno='71V67603S133BQG' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.021823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14208114 LIMIT 5 [ RunTime:0.034921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14208114 ORDER BY `minOrder` ASC [ RunTime:0.045700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14208114 ORDER BY `unit` DESC [ RunTime:0.026817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14208114 LIMIT 2 [ RunTime:0.017620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14208114 ORDER BY `minOrder` ASC [ RunTime:0.008834s ]
select * from pdf where partno='71V67603S133BQG8' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.028886s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029634s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63977159 LIMIT 5 [ RunTime:0.013800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63977159 ORDER BY `minOrder` ASC [ RunTime:0.038223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63977159 ORDER BY `unit` DESC [ RunTime:0.037906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63977159 LIMIT 2 [ RunTime:0.008000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63977159 ORDER BY `minOrder` ASC [ RunTime:0.007447s ]
select * from pdf where partno='71V67603S133BQGI' and brandshort='IDT, Integrated Device Technology Inc' limit 1 [ RunTime:0.023714s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71V67603S133BQGI' OR `brand` LIKE 'IDT, Integrated Device Technology Inc%' ) ) LIMIT 1 [ RunTime:0.051090s ]
SELECT `id` FROM `stock` WHERE `id` <> 63977159 AND `partno` = '71V67603S133BQGI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%idt, integrated device technology inc%' ) [ RunTime:0.014134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17061422 [ RunTime:0.023103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63995634 LIMIT 5 [ RunTime:0.019970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63995634 ORDER BY `minOrder` ASC [ RunTime:0.013238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63995634 ORDER BY `unit` DESC [ RunTime:0.017804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63995634 LIMIT 2 [ RunTime:0.006651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63995634 ORDER BY `minOrder` ASC [ RunTime:0.025049s ]
select * from pdf where partno='71V67603S133BQG' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.004098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71V67603S133BQG' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.024290s ]
SELECT `id` FROM `stock` WHERE `id` <> 63995634 AND `partno` = '71V67603S133BQG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.021839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15282381 [ RunTime:0.025062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63995306 LIMIT 5 [ RunTime:0.071920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63995306 ORDER BY `minOrder` ASC [ RunTime:0.014549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63995306 ORDER BY `unit` DESC [ RunTime:0.006583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63995306 LIMIT 2 [ RunTime:0.017793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63995306 ORDER BY `minOrder` ASC [ RunTime:0.020313s ]
select * from pdf where partno='71V67603S133BQG8' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71V67603S133BQG8' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.007870s ]
SELECT `id` FROM `stock` WHERE `id` <> 63995306 AND `partno` = '71V67603S133BQG8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.004586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14208114 [ RunTime:0.011354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63993853 LIMIT 5 [ RunTime:0.022722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63993853 ORDER BY `minOrder` ASC [ RunTime:0.015913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63993853 ORDER BY `unit` DESC [ RunTime:0.010621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63993853 LIMIT 2 [ RunTime:0.031881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63993853 ORDER BY `minOrder` ASC [ RunTime:0.014769s ]
select * from pdf where partno='71V67603S133BQGI' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71V67603S133BQGI' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.011425s ]
SELECT `id` FROM `stock` WHERE `id` <> 63993853 AND `partno` = '71V67603S133BQGI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.003171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19050623 [ RunTime:0.013475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63993354 LIMIT 5 [ RunTime:0.019472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63993354 ORDER BY `minOrder` ASC [ RunTime:0.017888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63993354 ORDER BY `unit` DESC [ RunTime:0.036966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63993354 LIMIT 2 [ RunTime:0.031662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63993354 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
select * from pdf where partno='71V67603S133BQGI8' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71V67603S133BQGI8' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.010730s ]
SELECT `id` FROM `stock` WHERE `id` <> 63993354 AND `partno` = '71V67603S133BQGI8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.007836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16018896 [ RunTime:0.014191s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016895s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026849s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022765s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025545s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014174s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018060s ]
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 '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005209s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '71V67603S133BQG%' OR `brand` LIKE '71V67603S133BQG%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017890s ]