SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002428s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035505s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750575 LIMIT 5 [ RunTime:0.008217s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750575 ORDER BY `minOrder` ASC [ RunTime:0.011554s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750575 ORDER BY `unit` DESC [ RunTime:0.016152s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750575 LIMIT 2 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750575 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750479 LIMIT 5 [ RunTime:0.014429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750479 ORDER BY `minOrder` ASC [ RunTime:0.015076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750479 ORDER BY `unit` DESC [ RunTime:0.004331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750479 LIMIT 2 [ RunTime:0.013781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750479 ORDER BY `minOrder` ASC [ RunTime:0.013053s ]
select * from pdf where partno='2260451470' and brandshort='Molex' limit 1 [ RunTime:0.008838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750478 LIMIT 5 [ RunTime:0.033847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750478 ORDER BY `minOrder` ASC [ RunTime:0.022137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750478 ORDER BY `unit` DESC [ RunTime:0.017569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750478 LIMIT 2 [ RunTime:0.010365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750478 ORDER BY `minOrder` ASC [ RunTime:0.008764s ]
select * from pdf where partno='2260450470' and brandshort='Molex' limit 1 [ RunTime:0.009507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749913 LIMIT 5 [ RunTime:0.021805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749913 ORDER BY `minOrder` ASC [ RunTime:0.011935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18749913 ORDER BY `unit` DESC [ RunTime:0.021563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18749913 LIMIT 2 [ RunTime:0.010841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749913 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719054 LIMIT 5 [ RunTime:0.005432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719054 ORDER BY `minOrder` ASC [ RunTime:0.007698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719054 ORDER BY `unit` DESC [ RunTime:0.010537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719054 LIMIT 2 [ RunTime:0.004084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719054 ORDER BY `minOrder` ASC [ RunTime:0.004712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719053 LIMIT 5 [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719053 ORDER BY `minOrder` ASC [ RunTime:0.004319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719053 ORDER BY `unit` DESC [ RunTime:0.004003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719053 LIMIT 2 [ RunTime:0.007576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719053 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719052 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719052 ORDER BY `minOrder` ASC [ RunTime:0.003842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719052 ORDER BY `unit` DESC [ RunTime:0.002441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719052 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719052 ORDER BY `minOrder` ASC [ RunTime:0.002928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719014 LIMIT 5 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719014 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719014 ORDER BY `unit` DESC [ RunTime:0.000962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719014 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719014 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719013 LIMIT 5 [ RunTime:0.003211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719013 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719013 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719013 LIMIT 2 [ RunTime:0.003048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719013 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718624 LIMIT 5 [ RunTime:0.001083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718624 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18718624 ORDER BY `unit` DESC [ RunTime:0.002952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18718624 LIMIT 2 [ RunTime:0.003849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718624 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718621 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718621 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18718621 ORDER BY `unit` DESC [ RunTime:0.003963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18718621 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718621 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005317 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005317 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005317 ORDER BY `unit` DESC [ RunTime:0.004065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005317 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005317 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17000090 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000090 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17000090 ORDER BY `unit` DESC [ RunTime:0.003848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17000090 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000090 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997839 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997839 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997839 ORDER BY `unit` DESC [ RunTime:0.003871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997839 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997839 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997838 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997838 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997838 ORDER BY `unit` DESC [ RunTime:0.003061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997838 LIMIT 2 [ RunTime:0.004032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997838 ORDER BY `minOrder` ASC [ RunTime:0.004630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997837 LIMIT 5 [ RunTime:0.003925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997837 ORDER BY `minOrder` ASC [ RunTime:0.000818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997837 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997837 LIMIT 2 [ RunTime:0.003047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997837 ORDER BY `minOrder` ASC [ RunTime:0.004158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997836 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997836 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997836 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997836 LIMIT 2 [ RunTime:0.002543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997836 ORDER BY `minOrder` ASC [ RunTime:0.004038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997767 LIMIT 5 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997767 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997767 ORDER BY `unit` DESC [ RunTime:0.003825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997767 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997767 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218009 LIMIT 5 [ RunTime:0.005273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218009 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218009 ORDER BY `unit` DESC [ RunTime:0.002970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218009 LIMIT 2 [ RunTime:0.005623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218009 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15217827 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217827 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15217827 ORDER BY `unit` DESC [ RunTime:0.005232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15217827 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217827 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002489s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51588422 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51588422 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51588422 ORDER BY `unit` DESC [ RunTime:0.001535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51588422 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51588422 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='22604' and brandshort='C&K' limit 1 [ RunTime:0.002430s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22604' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.008332s ]
SELECT `id` FROM `stock` WHERE `id` <> 51588422 AND `partno` = '22604' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.004171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673269 LIMIT 5 [ RunTime:0.007210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673269 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673269 ORDER BY `unit` DESC [ RunTime:0.007933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673269 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673269 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='2260450400' and brandshort='Molex' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673268 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673268 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673268 ORDER BY `unit` DESC [ RunTime:0.008366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673268 LIMIT 2 [ RunTime:0.003295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673268 ORDER BY `minOrder` ASC [ RunTime:0.015208s ]
select * from pdf where partno='2260450900' and brandshort='Molex' limit 1 [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450900' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673267 LIMIT 5 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673267 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673267 ORDER BY `unit` DESC [ RunTime:0.004057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673267 LIMIT 2 [ RunTime:0.009175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673267 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='2260452000' and brandshort='Molex' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260452000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673266 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673266 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673266 ORDER BY `unit` DESC [ RunTime:0.009377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673266 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673266 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='2260451000' and brandshort='Molex' limit 1 [ RunTime:0.001271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673265 LIMIT 5 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673265 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673265 ORDER BY `unit` DESC [ RunTime:0.010915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673265 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673265 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='2260451300' and brandshort='Molex' limit 1 [ RunTime:0.001115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451300' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673264 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673264 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673264 ORDER BY `unit` DESC [ RunTime:0.004211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673264 LIMIT 2 [ RunTime:0.008575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673264 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='2260450300' and brandshort='Molex' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450300' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673263 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673263 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673263 ORDER BY `unit` DESC [ RunTime:0.003379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673263 LIMIT 2 [ RunTime:0.008839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673263 ORDER BY `minOrder` ASC [ RunTime:0.008700s ]
select * from pdf where partno='2260451400' and brandshort='Molex' limit 1 [ RunTime:0.002592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673262 LIMIT 5 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673262 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673262 ORDER BY `unit` DESC [ RunTime:0.003064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673262 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673262 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
select * from pdf where partno='2260451900' and brandshort='Molex' limit 1 [ RunTime:0.000700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451900' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673215 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673215 ORDER BY `minOrder` ASC [ RunTime:0.004062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673215 ORDER BY `unit` DESC [ RunTime:0.003276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673215 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673215 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
select * from pdf where partno='2260450100' and brandshort='Molex' limit 1 [ RunTime:0.000813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450100' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673214 LIMIT 5 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673214 ORDER BY `minOrder` ASC [ RunTime:0.002795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673214 ORDER BY `unit` DESC [ RunTime:0.004368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673214 LIMIT 2 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673214 ORDER BY `minOrder` ASC [ RunTime:0.002663s ]
select * from pdf where partno='2260451100' and brandshort='Molex' limit 1 [ RunTime:0.003129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451100' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51671002 LIMIT 5 [ RunTime:0.006011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51671002 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51671002 ORDER BY `unit` DESC [ RunTime:0.004313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51671002 LIMIT 2 [ RunTime:0.015627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51671002 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='2260451500' and brandshort='Molex' limit 1 [ RunTime:0.007829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.030321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670785 LIMIT 5 [ RunTime:0.017304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670785 ORDER BY `minOrder` ASC [ RunTime:0.008596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670785 ORDER BY `unit` DESC [ RunTime:0.004052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670785 LIMIT 2 [ RunTime:0.001620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670785 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='2260450600' and brandshort='Molex' limit 1 [ RunTime:0.002762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450600' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670780 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670780 ORDER BY `minOrder` ASC [ RunTime:0.004862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670780 ORDER BY `unit` DESC [ RunTime:0.002053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670780 LIMIT 2 [ RunTime:0.001812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670780 ORDER BY `minOrder` ASC [ RunTime:0.003567s ]
select * from pdf where partno='2260450500' and brandshort='Molex' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670691 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670691 ORDER BY `minOrder` ASC [ RunTime:0.003629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670691 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670691 LIMIT 2 [ RunTime:0.003990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670691 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='2260450200' and brandshort='Molex' limit 1 [ RunTime:0.001628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450200' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670482 LIMIT 5 [ RunTime:0.001265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670482 ORDER BY `minOrder` ASC [ RunTime:0.003111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670482 ORDER BY `unit` DESC [ RunTime:0.003994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670482 LIMIT 2 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670482 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
select * from pdf where partno='2260451800' and brandshort='Molex' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451800' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670455 LIMIT 5 [ RunTime:0.000778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670455 ORDER BY `minOrder` ASC [ RunTime:0.010215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670455 ORDER BY `unit` DESC [ RunTime:0.002681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670455 LIMIT 2 [ RunTime:0.009222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670455 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
select * from pdf where partno='2260450800' and brandshort='Molex' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260450800' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670010 LIMIT 5 [ RunTime:0.001312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670010 ORDER BY `minOrder` ASC [ RunTime:0.004514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670010 ORDER BY `unit` DESC [ RunTime:0.004974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670010 LIMIT 2 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670010 ORDER BY `minOrder` ASC [ RunTime:0.005170s ]
select * from pdf where partno='2260451200' and brandshort='Molex' limit 1 [ RunTime:0.001276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260451200' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670008 LIMIT 5 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670008 ORDER BY `minOrder` ASC [ RunTime:0.011684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670008 ORDER BY `unit` DESC [ RunTime:0.002677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670008 LIMIT 2 [ RunTime:0.020478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670008 ORDER BY `minOrder` ASC [ RunTime:0.006943s ]
select * from pdf where partno='2260452300' and brandshort='Molex' limit 1 [ RunTime:0.001240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260452300' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51668649 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51668649 ORDER BY `minOrder` ASC [ RunTime:0.009088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51668649 ORDER BY `unit` DESC [ RunTime:0.001237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51668649 LIMIT 2 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51668649 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
select * from pdf where partno='2260452500' and brandshort='Molex' limit 1 [ RunTime:0.004084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2260452500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021306s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004472s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005527s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007023s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005990s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003150s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002331s ]
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 '22604%' OR `brand` LIKE '22604%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003608s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '22604%' OR `brand` LIKE '22604%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020726s ]