SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002648s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030838s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16971091 LIMIT 5 [ RunTime:0.020181s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16971091 ORDER BY `minOrder` ASC [ RunTime:0.015885s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16971091 ORDER BY `unit` DESC [ RunTime:0.041889s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16971091 LIMIT 2 [ RunTime:0.018738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16971091 ORDER BY `minOrder` ASC [ RunTime:0.015833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343612 LIMIT 5 [ RunTime:0.024492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343612 ORDER BY `minOrder` ASC [ RunTime:0.033633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343612 ORDER BY `unit` DESC [ RunTime:0.019398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343612 LIMIT 2 [ RunTime:0.030063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343612 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15193404 LIMIT 5 [ RunTime:0.018126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15193404 ORDER BY `minOrder` ASC [ RunTime:0.030373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15193404 ORDER BY `unit` DESC [ RunTime:0.027859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15193404 LIMIT 2 [ RunTime:0.021598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15193404 ORDER BY `minOrder` ASC [ RunTime:0.015703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012722 LIMIT 5 [ RunTime:0.014366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012722 ORDER BY `minOrder` ASC [ RunTime:0.005415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012722 ORDER BY `unit` DESC [ RunTime:0.011845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012722 LIMIT 2 [ RunTime:0.044513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012722 ORDER BY `minOrder` ASC [ RunTime:0.031730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14388495 LIMIT 5 [ RunTime:0.026603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388495 ORDER BY `minOrder` ASC [ RunTime:0.041326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14388495 ORDER BY `unit` DESC [ RunTime:0.014388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14388495 LIMIT 2 [ RunTime:0.011923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388495 ORDER BY `minOrder` ASC [ RunTime:0.007423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11978674 LIMIT 5 [ RunTime:0.011612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978674 ORDER BY `minOrder` ASC [ RunTime:0.022144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11978674 ORDER BY `unit` DESC [ RunTime:0.007603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11978674 LIMIT 2 [ RunTime:0.013459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978674 ORDER BY `minOrder` ASC [ RunTime:0.002105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13249419 LIMIT 5 [ RunTime:0.014883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13249419 ORDER BY `minOrder` ASC [ RunTime:0.003701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13249419 ORDER BY `unit` DESC [ RunTime:0.024828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13249419 LIMIT 2 [ RunTime:0.020345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13249419 ORDER BY `minOrder` ASC [ RunTime:0.001943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200130 LIMIT 5 [ RunTime:0.017551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200130 ORDER BY `minOrder` ASC [ RunTime:0.019850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200130 ORDER BY `unit` DESC [ RunTime:0.011565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200130 LIMIT 2 [ RunTime:0.016680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200130 ORDER BY `minOrder` ASC [ RunTime:0.030798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337072 LIMIT 5 [ RunTime:0.014002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337072 ORDER BY `minOrder` ASC [ RunTime:0.004005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13337072 ORDER BY `unit` DESC [ RunTime:0.013928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13337072 LIMIT 2 [ RunTime:0.011924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337072 ORDER BY `minOrder` ASC [ RunTime:0.006364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13816434 LIMIT 5 [ RunTime:0.006467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13816434 ORDER BY `minOrder` ASC [ RunTime:0.004007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13816434 ORDER BY `unit` DESC [ RunTime:0.009896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13816434 LIMIT 2 [ RunTime:0.027699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13816434 ORDER BY `minOrder` ASC [ RunTime:0.007501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11201058 LIMIT 5 [ RunTime:0.002494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11201058 ORDER BY `minOrder` ASC [ RunTime:0.021032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11201058 ORDER BY `unit` DESC [ RunTime:0.019467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11201058 LIMIT 2 [ RunTime:0.015574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11201058 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11978673 LIMIT 5 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978673 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11978673 ORDER BY `unit` DESC [ RunTime:0.017953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11978673 LIMIT 2 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978673 ORDER BY `minOrder` ASC [ RunTime:0.004248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19094579 LIMIT 5 [ RunTime:0.017776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094579 ORDER BY `minOrder` ASC [ RunTime:0.009657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19094579 ORDER BY `unit` DESC [ RunTime:0.006241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19094579 LIMIT 2 [ RunTime:0.015936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094579 ORDER BY `minOrder` ASC [ RunTime:0.016265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19094578 LIMIT 5 [ RunTime:0.025610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094578 ORDER BY `minOrder` ASC [ RunTime:0.014522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19094578 ORDER BY `unit` DESC [ RunTime:0.004113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19094578 LIMIT 2 [ RunTime:0.001439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19094578 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15298145 LIMIT 5 [ RunTime:0.010545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298145 ORDER BY `minOrder` ASC [ RunTime:0.013100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15298145 ORDER BY `unit` DESC [ RunTime:0.020912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15298145 LIMIT 2 [ RunTime:0.006221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298145 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706903 LIMIT 5 [ RunTime:0.030848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706903 ORDER BY `minOrder` ASC [ RunTime:0.013397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706903 ORDER BY `unit` DESC [ RunTime:0.010842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706903 LIMIT 2 [ RunTime:0.012420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706903 ORDER BY `minOrder` ASC [ RunTime:0.009396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13816109 LIMIT 5 [ RunTime:0.010237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13816109 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13816109 ORDER BY `unit` DESC [ RunTime:0.014612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13816109 LIMIT 2 [ RunTime:0.018108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13816109 ORDER BY `minOrder` ASC [ RunTime:0.017729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190460 LIMIT 5 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190460 ORDER BY `minOrder` ASC [ RunTime:0.011748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190460 ORDER BY `unit` DESC [ RunTime:0.001015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190460 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190460 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190459 LIMIT 5 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190459 ORDER BY `minOrder` ASC [ RunTime:0.003081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190459 ORDER BY `unit` DESC [ RunTime:0.006663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190459 LIMIT 2 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190459 ORDER BY `minOrder` ASC [ RunTime:0.002279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190403 LIMIT 5 [ RunTime:0.001855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190403 ORDER BY `minOrder` ASC [ RunTime:0.003160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190403 ORDER BY `unit` DESC [ RunTime:0.006867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190403 LIMIT 2 [ RunTime:0.003047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190403 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290366 LIMIT 5 [ RunTime:0.002406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290366 ORDER BY `minOrder` ASC [ RunTime:0.009343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290366 ORDER BY `unit` DESC [ RunTime:0.001814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290366 LIMIT 2 [ RunTime:0.015385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290366 ORDER BY `minOrder` ASC [ RunTime:0.000880s ]
select * from pdf where partno='6030b-ttg' and brandshort='aavid' limit 1 [ RunTime:0.025990s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030b-ttg' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.005856s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290366 AND `partno` = '6030b-ttg' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.006432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266695 LIMIT 5 [ RunTime:0.024024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266695 ORDER BY `minOrder` ASC [ RunTime:0.004145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32266695 ORDER BY `unit` DESC [ RunTime:0.001003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32266695 LIMIT 2 [ RunTime:0.008088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266695 ORDER BY `minOrder` ASC [ RunTime:0.009864s ]
select * from pdf where partno='603072' and brandshort='amphenol socapex' limit 1 [ RunTime:0.016704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603072' OR `brand` LIKE 'amphenol socapex%' ) ) LIMIT 1 [ RunTime:0.006546s ]
SELECT `id` FROM `stock` WHERE `id` <> 32266695 AND `partno` = '603072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol socapex%' ) [ RunTime:0.018991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339828 [ RunTime:0.003676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097115 LIMIT 5 [ RunTime:0.011586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097115 ORDER BY `minOrder` ASC [ RunTime:0.030361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097115 ORDER BY `unit` DESC [ RunTime:0.013524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097115 LIMIT 2 [ RunTime:0.027250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097115 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='6030' and brandshort='adafruit' limit 1 [ RunTime:0.011621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.005327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089773 LIMIT 5 [ RunTime:0.011199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089773 ORDER BY `minOrder` ASC [ RunTime:0.001268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089773 ORDER BY `unit` DESC [ RunTime:0.003357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089773 LIMIT 2 [ RunTime:0.008809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089773 ORDER BY `minOrder` ASC [ RunTime:0.001664s ]
select * from pdf where partno='60306t' and brandshort='mersen' limit 1 [ RunTime:0.001786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60306t' OR `brand` LIKE 'mersen%' ) ) LIMIT 1 [ RunTime:0.007040s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884279 LIMIT 5 [ RunTime:0.020325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884279 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884279 ORDER BY `unit` DESC [ RunTime:0.003245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884279 LIMIT 2 [ RunTime:0.003761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884279 ORDER BY `minOrder` ASC [ RunTime:0.002118s ]
select * from pdf where partno='6030B-TTG' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.007825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030B-TTG' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.023032s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884279 AND `partno` = '6030B-TTG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.007825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16971091 [ RunTime:0.017452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885006 LIMIT 5 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885006 ORDER BY `minOrder` ASC [ RunTime:0.006014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43885006 ORDER BY `unit` DESC [ RunTime:0.006533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43885006 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885006 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='6030D(COPPER)G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.001505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030D(COPPER)G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.004653s ]
SELECT `id` FROM `stock` WHERE `id` <> 43885006 AND `partno` = '6030D(COPPER)G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.005182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15193404 [ RunTime:0.000639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64574526 LIMIT 5 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574526 ORDER BY `minOrder` ASC [ RunTime:0.007493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64574526 ORDER BY `unit` DESC [ RunTime:0.003730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64574526 LIMIT 2 [ RunTime:0.004637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574526 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='6030CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002337s ]
SELECT `id` FROM `stock` WHERE `id` <> 64574526 AND `partno` = '6030CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343612 [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60605623 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60605623 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60605623 ORDER BY `unit` DESC [ RunTime:0.007573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60605623 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60605623 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='6030' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.002119s ]
SELECT `id` FROM `stock` WHERE `id` <> 60605623 AND `partno` = '6030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64784349 LIMIT 5 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784349 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64784349 ORDER BY `unit` DESC [ RunTime:0.002072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64784349 LIMIT 2 [ RunTime:0.003324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784349 ORDER BY `minOrder` ASC [ RunTime:0.007604s ]
select * from pdf where partno='6030132' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030132' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005246s ]
SELECT `id` FROM `stock` WHERE `id` <> 64784349 AND `partno` = '6030132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012722 [ RunTime:0.005571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007213 LIMIT 5 [ RunTime:0.021473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007213 ORDER BY `minOrder` ASC [ RunTime:0.022886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007213 ORDER BY `unit` DESC [ RunTime:0.012877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007213 LIMIT 2 [ RunTime:0.011581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007213 ORDER BY `minOrder` ASC [ RunTime:0.003400s ]
select * from pdf where partno='6030921' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030921' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008088s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007213 AND `partno` = '6030921' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14388495 [ RunTime:0.009119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339828 LIMIT 5 [ RunTime:0.002345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339828 ORDER BY `minOrder` ASC [ RunTime:0.026158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339828 ORDER BY `unit` DESC [ RunTime:0.018304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339828 LIMIT 2 [ RunTime:0.013866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339828 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='603072' and brandshort='Amphenol Socapex' limit 1 [ RunTime:0.006592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603072' OR `brand` LIKE 'Amphenol Socapex%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT `id` FROM `stock` WHERE `id` <> 60339828 AND `partno` = '603072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol socapex%' ) [ RunTime:0.003473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266695 [ RunTime:0.010986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58200546 LIMIT 5 [ RunTime:0.011196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58200546 ORDER BY `minOrder` ASC [ RunTime:0.019018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58200546 ORDER BY `unit` DESC [ RunTime:0.012581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58200546 LIMIT 2 [ RunTime:0.005596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58200546 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
select * from pdf where partno='60308T' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.008082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60308T' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.004060s ]
SELECT `id` FROM `stock` WHERE `id` <> 58200546 AND `partno` = '60308T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.052532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333664 LIMIT 5 [ RunTime:0.020011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333664 ORDER BY `minOrder` ASC [ RunTime:0.017463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333664 ORDER BY `unit` DESC [ RunTime:0.013943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333664 LIMIT 2 [ RunTime:0.025701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333664 ORDER BY `minOrder` ASC [ RunTime:0.023424s ]
select * from pdf where partno='6030710' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030710' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004657s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333664 AND `partno` = '6030710' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200130 [ RunTime:0.008412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63272496 LIMIT 5 [ RunTime:0.015350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63272496 ORDER BY `minOrder` ASC [ RunTime:0.007505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63272496 ORDER BY `unit` DESC [ RunTime:0.013258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63272496 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63272496 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='603048' and brandshort='Dracal Technologies' limit 1 [ RunTime:0.007417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603048' OR `brand` LIKE 'Dracal Technologies%' ) ) LIMIT 1 [ RunTime:0.003837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63230662 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63230662 ORDER BY `minOrder` ASC [ RunTime:0.002127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63230662 ORDER BY `unit` DESC [ RunTime:0.015414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63230662 LIMIT 2 [ RunTime:0.010169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63230662 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
select * from pdf where partno='603009' and brandshort='Dracal Technologies' limit 1 [ RunTime:0.024161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603009' OR `brand` LIKE 'Dracal Technologies%' ) ) LIMIT 1 [ RunTime:0.017544s ]
SELECT `id` FROM `stock` WHERE `id` <> 63230662 AND `partno` = '603009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dracal technologies%' ) [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337072 [ RunTime:0.017879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60616860 LIMIT 5 [ RunTime:0.013334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60616860 ORDER BY `minOrder` ASC [ RunTime:0.043578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60616860 ORDER BY `unit` DESC [ RunTime:0.021769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60616860 LIMIT 2 [ RunTime:0.016401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60616860 ORDER BY `minOrder` ASC [ RunTime:0.010252s ]
select * from pdf where partno='6030664' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030664' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014176s ]
SELECT `id` FROM `stock` WHERE `id` <> 60616860 AND `partno` = '6030664' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692673 [ RunTime:0.011474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434085 LIMIT 5 [ RunTime:0.021087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434085 ORDER BY `minOrder` ASC [ RunTime:0.020794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434085 ORDER BY `unit` DESC [ RunTime:0.005829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434085 LIMIT 2 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434085 ORDER BY `minOrder` ASC [ RunTime:0.017709s ]
select * from pdf where partno='6030217' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030217' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017667s ]
SELECT `id` FROM `stock` WHERE `id` <> 64434085 AND `partno` = '6030217' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15298145 [ RunTime:0.010793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335113 LIMIT 5 [ RunTime:0.024695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335113 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335113 ORDER BY `unit` DESC [ RunTime:0.017239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335113 LIMIT 2 [ RunTime:0.017372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335113 ORDER BY `minOrder` ASC [ RunTime:0.006455s ]
select * from pdf where partno='6030709' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030709' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009289s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335113 AND `partno` = '6030709' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200618 [ RunTime:0.029031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64434087 LIMIT 5 [ RunTime:0.006873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434087 ORDER BY `minOrder` ASC [ RunTime:0.003434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64434087 ORDER BY `unit` DESC [ RunTime:0.017243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64434087 LIMIT 2 [ RunTime:0.004901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64434087 ORDER BY `minOrder` ASC [ RunTime:0.018271s ]
select * from pdf where partno='6030219' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030219' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019007s ]
SELECT `id` FROM `stock` WHERE `id` <> 64434087 AND `partno` = '6030219' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19094579 [ RunTime:0.014708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63530689 LIMIT 5 [ RunTime:0.016899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63530689 ORDER BY `minOrder` ASC [ RunTime:0.017320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63530689 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63530689 LIMIT 2 [ RunTime:0.019410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63530689 ORDER BY `minOrder` ASC [ RunTime:0.003748s ]
select * from pdf where partno='603001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002815s ]
SELECT `id` FROM `stock` WHERE `id` <> 63530689 AND `partno` = '603001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.028188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13272447 [ RunTime:0.030653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335199 LIMIT 5 [ RunTime:0.042522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335199 ORDER BY `minOrder` ASC [ RunTime:0.016258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335199 ORDER BY `unit` DESC [ RunTime:0.020183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335199 LIMIT 2 [ RunTime:0.020565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335199 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
select * from pdf where partno='6030716' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030716' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019533s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335199 AND `partno` = '6030716' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.038156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190460 [ RunTime:0.014440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335198 LIMIT 5 [ RunTime:0.014297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335198 ORDER BY `minOrder` ASC [ RunTime:0.012578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335198 ORDER BY `unit` DESC [ RunTime:0.016217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335198 LIMIT 2 [ RunTime:0.025236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335198 ORDER BY `minOrder` ASC [ RunTime:0.016403s ]
select * from pdf where partno='6030715' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030715' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024765s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335198 AND `partno` = '6030715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190459 [ RunTime:0.022703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335143 LIMIT 5 [ RunTime:0.045180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335143 ORDER BY `minOrder` ASC [ RunTime:0.071617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335143 ORDER BY `unit` DESC [ RunTime:0.017438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335143 LIMIT 2 [ RunTime:0.032084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335143 ORDER BY `minOrder` ASC [ RunTime:0.015292s ]
select * from pdf where partno='6030570' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030570' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047609s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335143 AND `partno` = '6030570' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335119 LIMIT 5 [ RunTime:0.029154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335119 ORDER BY `minOrder` ASC [ RunTime:0.019480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335119 ORDER BY `unit` DESC [ RunTime:0.018682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335119 LIMIT 2 [ RunTime:0.043971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335119 ORDER BY `minOrder` ASC [ RunTime:0.014576s ]
select * from pdf where partno='6030708' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6030708' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006610s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335119 AND `partno` = '6030708' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190403 [ RunTime:0.006283s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008232s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020128s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014948s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010395s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009977s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004671s ]
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 '6030%' OR `brand` LIKE '6030%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009904s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6030%' OR `brand` LIKE '6030%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016913s ]