SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002544s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037177s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14534809 LIMIT 5 [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14534809 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14534809 ORDER BY `unit` DESC [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14534809 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14534809 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='0502128000-10-B6-D' and brandshort='Molex' limit 1 [ RunTime:0.009477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14531182 LIMIT 5 [ RunTime:0.002168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14531182 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14531182 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14531182 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14531182 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='0502128000-12-R4' and brandshort='Molex' limit 1 [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14531183 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14531183 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14531183 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14531183 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14531183 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='0502128000-12-B4' and brandshort='Molex' limit 1 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13662998 LIMIT 5 [ RunTime:0.002248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13662998 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13662998 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13662998 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13662998 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='0502128000-12-W4-D' and brandshort='Molex' limit 1 [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13666208 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666208 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13666208 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13666208 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666208 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='0502128000-12-B6-D' and brandshort='Molex' limit 1 [ RunTime:0.000564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14530338 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14530338 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14530338 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14530338 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14530338 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='0502128000-03-W6-D' and brandshort='Molex' limit 1 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13663411 LIMIT 5 [ RunTime:0.006185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13663411 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13663411 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13663411 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13663411 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='0502128000-03-W6' and brandshort='Molex' limit 1 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13664198 LIMIT 5 [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13664198 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13664198 ORDER BY `unit` DESC [ RunTime:0.000447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13664198 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13664198 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
select * from pdf where partno='0502128000-04-B6-D' and brandshort='Molex' limit 1 [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13666184 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666184 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13666184 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13666184 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666184 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='0502128000-10-B6' and brandshort='Molex' limit 1 [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13665550 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665550 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13665550 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13665550 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665550 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='0502128000-12-R6' and brandshort='Molex' limit 1 [ RunTime:0.000605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13665560 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665560 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13665560 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13665560 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665560 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='0502128000-10-R6-D' and brandshort='Molex' limit 1 [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13665551 LIMIT 5 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665551 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13665551 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13665551 LIMIT 2 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13665551 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='0502128000-12-L6' and brandshort='Molex' limit 1 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14529991 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14529991 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14529991 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14529991 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14529991 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='0502128000-04-B4' and brandshort='Molex' limit 1 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13666186 LIMIT 5 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666186 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13666186 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13666186 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666186 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='0502128000-10-R6' and brandshort='Molex' limit 1 [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13666214 LIMIT 5 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666214 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13666214 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13666214 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666214 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='0502128000-12-B4-D' and brandshort='Molex' limit 1 [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13666217 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666217 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13666217 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13666217 LIMIT 2 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13666217 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='0502128000-12-V6' and brandshort='Molex' limit 1 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14533809 LIMIT 5 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14533809 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14533809 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14533809 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14533809 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='0502128000-03-N4' and brandshort='Molex' limit 1 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14533808 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14533808 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14533808 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14533808 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14533808 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='0502128000-03-L4' and brandshort='Molex' limit 1 [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13672795 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13672795 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13672795 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13672795 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13672795 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='0502128000-03-B4' and brandshort='Molex' limit 1 [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13671148 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13671148 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13671148 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13671148 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13671148 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='0502128000-03-R4' and brandshort='Molex' limit 1 [ RunTime:0.000431s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001304s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154021 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154021 ORDER BY `minOrder` ASC [ RunTime:0.001141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154021 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154021 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154021 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='0502128000' and brandshort='Molex' limit 1 [ RunTime:0.002136s ]
select foldpath,foldpath2,filename from pdf_file where id=752519 limit 1 [ RunTime:0.000663s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62426949 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62426949 ORDER BY `minOrder` ASC [ RunTime:0.003445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62426949 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62426949 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62426949 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='0502128000-12-R4' and brandshort='Molex' limit 1 [ RunTime:0.001051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-R4' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62426998 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62426998 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62426998 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62426998 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62426998 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='0502128000-12-R4-D' and brandshort='Molex' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-R4-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69238602 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69238602 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69238602 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69238602 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69238602 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
select * from pdf where partno='0502128000-10-B6' and brandshort='Molex' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-10-B6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62436977 LIMIT 5 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62436977 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62436977 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62436977 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62436977 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='0502128000-12-B6-D' and brandshort='Molex' limit 1 [ RunTime:0.000768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-B6-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69238603 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69238603 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69238603 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69238603 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69238603 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='0502128000-10-R6' and brandshort='Molex' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-10-R6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69239358 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69239358 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69239358 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69239358 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69239358 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='0502128000-12-L8' and brandshort='Molex' limit 1 [ RunTime:0.000886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-L8' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69239357 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69239357 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69239357 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69239357 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69239357 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='0502128000-12-B8' and brandshort='Molex' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-B8' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69233779 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69233779 ORDER BY `minOrder` ASC [ RunTime:0.001282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69233779 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69233779 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69233779 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='0502128000-06-W8' and brandshort='Molex' limit 1 [ RunTime:0.001154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-06-W8' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69242996 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242996 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69242996 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69242996 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242996 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='0502128000-12-B4-D' and brandshort='Molex' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-B4-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69242068 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242068 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69242068 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69242068 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242068 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='0502128000-12-W4' and brandshort='Molex' limit 1 [ RunTime:0.001248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-W4' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69242067 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242067 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69242067 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69242067 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69242067 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='0502128000-12-B4' and brandshort='Molex' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-B4' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69241823 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241823 ORDER BY `minOrder` ASC [ RunTime:0.002597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69241823 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69241823 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241823 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='0502128000-10-R6-D' and brandshort='Molex' limit 1 [ RunTime:0.001139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-10-R6-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69241822 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241822 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69241822 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69241822 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241822 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='0502128000-10-B6-D' and brandshort='Molex' limit 1 [ RunTime:0.001138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-10-B6-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69241731 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241731 ORDER BY `minOrder` ASC [ RunTime:0.004138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69241731 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69241731 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241731 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='0502128000-12-R6' and brandshort='Molex' limit 1 [ RunTime:0.001010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-R6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69241730 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241730 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69241730 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69241730 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241730 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='0502128000-12-G6' and brandshort='Molex' limit 1 [ RunTime:0.001151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-G6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69241729 LIMIT 5 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241729 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69241729 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69241729 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69241729 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='0502128000-12-L6' and brandshort='Molex' limit 1 [ RunTime:0.001117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-L6' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69240879 LIMIT 5 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240879 ORDER BY `minOrder` ASC [ RunTime:0.000905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69240879 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69240879 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240879 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='0502128000-12-S4-D' and brandshort='Molex' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-S4-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69240609 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240609 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69240609 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69240609 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240609 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='0502128000-12-S6-D' and brandshort='Molex' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-S6-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69240608 LIMIT 5 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240608 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69240608 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69240608 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69240608 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='0502128000-12-N6-D' and brandshort='Molex' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0502128000-12-N6-D' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006117s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000927s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000775s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000734s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000725s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000752s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000790s ]
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 '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000841s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0502128000%' OR `brand` LIKE '0502128000%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005660s ]