SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002295s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013833s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12413721 LIMIT 5 [ RunTime:0.004969s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413721 ORDER BY `minOrder` ASC [ RunTime:0.006379s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12413721 ORDER BY `unit` DESC [ RunTime:0.003351s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12413721 LIMIT 2 [ RunTime:0.007665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413721 ORDER BY `minOrder` ASC [ RunTime:0.017233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17284911 LIMIT 5 [ RunTime:0.004466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17284911 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17284911 ORDER BY `unit` DESC [ RunTime:0.001283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17284911 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17284911 ORDER BY `minOrder` ASC [ RunTime:0.005415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12441960 LIMIT 5 [ RunTime:0.011070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441960 ORDER BY `minOrder` ASC [ RunTime:0.020845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12441960 ORDER BY `unit` DESC [ RunTime:0.008543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12441960 LIMIT 2 [ RunTime:0.001341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441960 ORDER BY `minOrder` ASC [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12413497 LIMIT 5 [ RunTime:0.004339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413497 ORDER BY `minOrder` ASC [ RunTime:0.001920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12413497 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12413497 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413497 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12413504 LIMIT 5 [ RunTime:0.010931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413504 ORDER BY `minOrder` ASC [ RunTime:0.007192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12413504 ORDER BY `unit` DESC [ RunTime:0.005105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12413504 LIMIT 2 [ RunTime:0.005210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12413504 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11361264 LIMIT 5 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361264 ORDER BY `minOrder` ASC [ RunTime:0.012756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11361264 ORDER BY `unit` DESC [ RunTime:0.006241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11361264 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361264 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11361371 LIMIT 5 [ RunTime:0.001225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361371 ORDER BY `minOrder` ASC [ RunTime:0.006440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11361371 ORDER BY `unit` DESC [ RunTime:0.001157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11361371 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361371 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11361372 LIMIT 5 [ RunTime:0.007965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361372 ORDER BY `minOrder` ASC [ RunTime:0.013104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11361372 ORDER BY `unit` DESC [ RunTime:0.009107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11361372 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11361372 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12417107 LIMIT 5 [ RunTime:0.003743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12417107 ORDER BY `minOrder` ASC [ RunTime:0.020771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12417107 ORDER BY `unit` DESC [ RunTime:0.010099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12417107 LIMIT 2 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12417107 ORDER BY `minOrder` ASC [ RunTime:0.005275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416745 LIMIT 5 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416745 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416745 ORDER BY `unit` DESC [ RunTime:0.000840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416745 LIMIT 2 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416745 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416502 LIMIT 5 [ RunTime:0.002899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416502 ORDER BY `minOrder` ASC [ RunTime:0.001643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416502 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416502 LIMIT 2 [ RunTime:0.001492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416502 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416500 LIMIT 5 [ RunTime:0.004423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416500 ORDER BY `minOrder` ASC [ RunTime:0.007497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416500 ORDER BY `unit` DESC [ RunTime:0.000834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416500 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416500 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416499 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416499 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416499 ORDER BY `unit` DESC [ RunTime:0.011768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416499 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416499 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12415783 LIMIT 5 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415783 ORDER BY `minOrder` ASC [ RunTime:0.002336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12415783 ORDER BY `unit` DESC [ RunTime:0.001830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12415783 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415783 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12412684 LIMIT 5 [ RunTime:0.001947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12412684 ORDER BY `minOrder` ASC [ RunTime:0.001748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12412684 ORDER BY `unit` DESC [ RunTime:0.002633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12412684 LIMIT 2 [ RunTime:0.011792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12412684 ORDER BY `minOrder` ASC [ RunTime:0.014095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12412683 LIMIT 5 [ RunTime:0.005976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12412683 ORDER BY `minOrder` ASC [ RunTime:0.019357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12412683 ORDER BY `unit` DESC [ RunTime:0.002376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12412683 LIMIT 2 [ RunTime:0.003696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12412683 ORDER BY `minOrder` ASC [ RunTime:0.002936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11362104 LIMIT 5 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11362104 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11362104 ORDER BY `unit` DESC [ RunTime:0.002305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11362104 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11362104 ORDER BY `minOrder` ASC [ RunTime:0.001569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11349469 LIMIT 5 [ RunTime:0.018481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349469 ORDER BY `minOrder` ASC [ RunTime:0.017531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11349469 ORDER BY `unit` DESC [ RunTime:0.013596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11349469 LIMIT 2 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349469 ORDER BY `minOrder` ASC [ RunTime:0.011653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11349440 LIMIT 5 [ RunTime:0.014841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349440 ORDER BY `minOrder` ASC [ RunTime:0.010353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11349440 ORDER BY `unit` DESC [ RunTime:0.012893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11349440 LIMIT 2 [ RunTime:0.008493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349440 ORDER BY `minOrder` ASC [ RunTime:0.006430s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014978s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825312 LIMIT 5 [ RunTime:0.003257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825312 ORDER BY `minOrder` ASC [ RunTime:0.003968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825312 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825312 LIMIT 2 [ RunTime:0.010172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825312 ORDER BY `minOrder` ASC [ RunTime:0.003428s ]
select * from pdf where partno='EB2011G-G-J23ACF' and brandshort='NKK Switches' limit 1 [ RunTime:0.005510s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-G-J23ACF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.001631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43831566 LIMIT 5 [ RunTime:0.004728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831566 ORDER BY `minOrder` ASC [ RunTime:0.020240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43831566 ORDER BY `unit` DESC [ RunTime:0.010466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43831566 LIMIT 2 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831566 ORDER BY `minOrder` ASC [ RunTime:0.002005s ]
select * from pdf where partno='EB2011G-B-J23AFE' and brandshort='NKK Switches' limit 1 [ RunTime:0.004807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-B-J23AFE' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.010214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825285 LIMIT 5 [ RunTime:0.005805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825285 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825285 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825285 LIMIT 2 [ RunTime:0.008912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825285 ORDER BY `minOrder` ASC [ RunTime:0.003958s ]
select * from pdf where partno='EB2011G-G-J41H' and brandshort='NKK Switches' limit 1 [ RunTime:0.001498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-G-J41H' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.002437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43836005 LIMIT 5 [ RunTime:0.007719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43836005 ORDER BY `minOrder` ASC [ RunTime:0.009622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43836005 ORDER BY `unit` DESC [ RunTime:0.004064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43836005 LIMIT 2 [ RunTime:0.004576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43836005 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='EB2011G' and brandshort='NKK Switches' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43831297 LIMIT 5 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831297 ORDER BY `minOrder` ASC [ RunTime:0.001390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43831297 ORDER BY `unit` DESC [ RunTime:0.001689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43831297 LIMIT 2 [ RunTime:0.001398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831297 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='EB2011G-BA' and brandshort='NKK Switches' limit 1 [ RunTime:0.002306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-BA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.001030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825284 LIMIT 5 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825284 ORDER BY `minOrder` ASC [ RunTime:0.011745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825284 ORDER BY `unit` DESC [ RunTime:0.000777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825284 LIMIT 2 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825284 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='EB2011G-F-J21A' and brandshort='NKK Switches' limit 1 [ RunTime:0.002401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-F-J21A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.005965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43831299 LIMIT 5 [ RunTime:0.006830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831299 ORDER BY `minOrder` ASC [ RunTime:0.001996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43831299 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43831299 LIMIT 2 [ RunTime:0.016885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831299 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
select * from pdf where partno='EB2011G-CC' and brandshort='NKK Switches' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-CC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.002651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824756 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824756 ORDER BY `minOrder` ASC [ RunTime:0.007858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824756 ORDER BY `unit` DESC [ RunTime:0.004252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824756 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824756 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='EB2011G-BC' and brandshort='NKK Switches' limit 1 [ RunTime:0.001977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-BC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.008479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43842262 LIMIT 5 [ RunTime:0.004427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43842262 ORDER BY `minOrder` ASC [ RunTime:0.014914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43842262 ORDER BY `unit` DESC [ RunTime:0.005880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43842262 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43842262 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='EB2011G-B-J23ACF' and brandshort='NKK Switches' limit 1 [ RunTime:0.006571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-B-J23ACF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.007501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43840537 LIMIT 5 [ RunTime:0.013198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43840537 ORDER BY `minOrder` ASC [ RunTime:0.017706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43840537 ORDER BY `unit` DESC [ RunTime:0.020467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43840537 LIMIT 2 [ RunTime:0.015614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43840537 ORDER BY `minOrder` ASC [ RunTime:0.007158s ]
select * from pdf where partno='EB2011G-B-J21A' and brandshort='NKK Switches' limit 1 [ RunTime:0.012470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-B-J21A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.008787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43840406 LIMIT 5 [ RunTime:0.024182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43840406 ORDER BY `minOrder` ASC [ RunTime:0.007712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43840406 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43840406 LIMIT 2 [ RunTime:0.016148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43840406 ORDER BY `minOrder` ASC [ RunTime:0.010779s ]
select * from pdf where partno='EB2011G-B-J24ACF' and brandshort='NKK Switches' limit 1 [ RunTime:0.001293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-B-J24ACF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.003988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834437 LIMIT 5 [ RunTime:0.015589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834437 ORDER BY `minOrder` ASC [ RunTime:0.017868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834437 ORDER BY `unit` DESC [ RunTime:0.012636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834437 LIMIT 2 [ RunTime:0.025134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834437 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='EB2011G-C-J21A' and brandshort='NKK Switches' limit 1 [ RunTime:0.001123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-C-J21A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.013474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834436 LIMIT 5 [ RunTime:0.009605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834436 ORDER BY `minOrder` ASC [ RunTime:0.011393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834436 ORDER BY `unit` DESC [ RunTime:0.002797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834436 LIMIT 2 [ RunTime:0.002578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834436 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='EB2011G-H-J21A' and brandshort='NKK Switches' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-H-J21A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.027786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834435 LIMIT 5 [ RunTime:0.029365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834435 ORDER BY `minOrder` ASC [ RunTime:0.045062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834435 ORDER BY `unit` DESC [ RunTime:0.036199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834435 LIMIT 2 [ RunTime:0.033240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834435 ORDER BY `minOrder` ASC [ RunTime:0.022175s ]
select * from pdf where partno='EB2011G-B-J41B' and brandshort='NKK Switches' limit 1 [ RunTime:0.035279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-B-J41B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.063786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834274 LIMIT 5 [ RunTime:0.077332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834274 ORDER BY `minOrder` ASC [ RunTime:0.068130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834274 ORDER BY `unit` DESC [ RunTime:0.012462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834274 LIMIT 2 [ RunTime:0.027272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834274 ORDER BY `minOrder` ASC [ RunTime:0.010972s ]
select * from pdf where partno='EB2011G-CA' and brandshort='NKK Switches' limit 1 [ RunTime:0.010300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-CA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.040345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834273 LIMIT 5 [ RunTime:0.070434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834273 ORDER BY `minOrder` ASC [ RunTime:0.025078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834273 ORDER BY `unit` DESC [ RunTime:0.044903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834273 LIMIT 2 [ RunTime:0.074868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834273 ORDER BY `minOrder` ASC [ RunTime:0.010291s ]
select * from pdf where partno='EB2011G-BF' and brandshort='NKK Switches' limit 1 [ RunTime:0.056055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-BF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.014386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834272 LIMIT 5 [ RunTime:0.009246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834272 ORDER BY `minOrder` ASC [ RunTime:0.016706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834272 ORDER BY `unit` DESC [ RunTime:0.016522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834272 LIMIT 2 [ RunTime:0.018754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834272 ORDER BY `minOrder` ASC [ RunTime:0.008716s ]
select * from pdf where partno='EB2011G-BH' and brandshort='NKK Switches' limit 1 [ RunTime:0.006475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-BH' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.002099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43826066 LIMIT 5 [ RunTime:0.013511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826066 ORDER BY `minOrder` ASC [ RunTime:0.015092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43826066 ORDER BY `unit` DESC [ RunTime:0.011089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43826066 LIMIT 2 [ RunTime:0.006108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43826066 ORDER BY `minOrder` ASC [ RunTime:0.012936s ]
select * from pdf where partno='EB2011G-A-J23ACF' and brandshort='NKK Switches' limit 1 [ RunTime:0.015726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-A-J23ACF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.010389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825987 LIMIT 5 [ RunTime:0.011089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825987 ORDER BY `minOrder` ASC [ RunTime:0.018409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825987 ORDER BY `unit` DESC [ RunTime:0.015723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825987 LIMIT 2 [ RunTime:0.023700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825987 ORDER BY `minOrder` ASC [ RunTime:0.003335s ]
select * from pdf where partno='EB2011G-G-J21A' and brandshort='NKK Switches' limit 1 [ RunTime:0.019087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-G-J21A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.016929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825986 LIMIT 5 [ RunTime:0.007849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825986 ORDER BY `minOrder` ASC [ RunTime:0.005807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825986 ORDER BY `unit` DESC [ RunTime:0.004475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825986 LIMIT 2 [ RunTime:0.007232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825986 ORDER BY `minOrder` ASC [ RunTime:0.006180s ]
select * from pdf where partno='EB2011G-A-J41A' and brandshort='NKK Switches' limit 1 [ RunTime:0.003388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2011G-A-J41A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.005608s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019638s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003173s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '6' 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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006264s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003754s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001780s ]
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 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003508s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EB2011G%' OR `brand` LIKE 'EB2011G%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003506s ]