SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003622s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037178s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063599 LIMIT 5 [ RunTime:0.048345s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063599 ORDER BY `minOrder` ASC [ RunTime:0.047803s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063599 ORDER BY `unit` DESC [ RunTime:0.015164s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063599 LIMIT 2 [ RunTime:0.025999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063599 ORDER BY `minOrder` ASC [ RunTime:0.011327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13326267 LIMIT 5 [ RunTime:0.042221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13326267 ORDER BY `minOrder` ASC [ RunTime:0.037691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13326267 ORDER BY `unit` DESC [ RunTime:0.005307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13326267 LIMIT 2 [ RunTime:0.024219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13326267 ORDER BY `minOrder` ASC [ RunTime:0.010824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684349 LIMIT 5 [ RunTime:0.034845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684349 ORDER BY `minOrder` ASC [ RunTime:0.051844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684349 ORDER BY `unit` DESC [ RunTime:0.016340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684349 LIMIT 2 [ RunTime:0.027589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684349 ORDER BY `minOrder` ASC [ RunTime:0.013513s ]
select * from pdf where partno='6007' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.063279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13564961 LIMIT 5 [ RunTime:0.023112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13564961 ORDER BY `minOrder` ASC [ RunTime:0.015243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13564961 ORDER BY `unit` DESC [ RunTime:0.045815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13564961 LIMIT 2 [ RunTime:0.052987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13564961 ORDER BY `minOrder` ASC [ RunTime:0.030151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19038057 LIMIT 5 [ RunTime:0.031946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19038057 ORDER BY `minOrder` ASC [ RunTime:0.032931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19038057 ORDER BY `unit` DESC [ RunTime:0.033421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19038057 LIMIT 2 [ RunTime:0.051034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19038057 ORDER BY `minOrder` ASC [ RunTime:0.033840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037803 LIMIT 5 [ RunTime:0.037306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037803 ORDER BY `minOrder` ASC [ RunTime:0.028229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037803 ORDER BY `unit` DESC [ RunTime:0.024616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037803 LIMIT 2 [ RunTime:0.031667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037803 ORDER BY `minOrder` ASC [ RunTime:0.030066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037802 LIMIT 5 [ RunTime:0.024232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037802 ORDER BY `minOrder` ASC [ RunTime:0.011954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037802 ORDER BY `unit` DESC [ RunTime:0.020749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037802 LIMIT 2 [ RunTime:0.007274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037802 ORDER BY `minOrder` ASC [ RunTime:0.002664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037443 LIMIT 5 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037443 ORDER BY `minOrder` ASC [ RunTime:0.017702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037443 ORDER BY `unit` DESC [ RunTime:0.010981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037443 LIMIT 2 [ RunTime:0.004685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037443 ORDER BY `minOrder` ASC [ RunTime:0.011314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277837 LIMIT 5 [ RunTime:0.036618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277837 ORDER BY `minOrder` ASC [ RunTime:0.004257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277837 ORDER BY `unit` DESC [ RunTime:0.007836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277837 LIMIT 2 [ RunTime:0.012979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277837 ORDER BY `minOrder` ASC [ RunTime:0.011145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277805 LIMIT 5 [ RunTime:0.003388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277805 ORDER BY `minOrder` ASC [ RunTime:0.008399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277805 ORDER BY `unit` DESC [ RunTime:0.002564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277805 LIMIT 2 [ RunTime:0.035797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277805 ORDER BY `minOrder` ASC [ RunTime:0.012378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14680334 LIMIT 5 [ RunTime:0.030617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14680334 ORDER BY `minOrder` ASC [ RunTime:0.020090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14680334 ORDER BY `unit` DESC [ RunTime:0.011284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14680334 LIMIT 2 [ RunTime:0.008879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14680334 ORDER BY `minOrder` ASC [ RunTime:0.018240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433744 LIMIT 5 [ RunTime:0.014992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433744 ORDER BY `minOrder` ASC [ RunTime:0.021556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14433744 ORDER BY `unit` DESC [ RunTime:0.004489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14433744 LIMIT 2 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433744 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433695 LIMIT 5 [ RunTime:0.016509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433695 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14433695 ORDER BY `unit` DESC [ RunTime:0.007103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14433695 LIMIT 2 [ RunTime:0.012207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14433695 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307958 LIMIT 5 [ RunTime:0.012966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307958 ORDER BY `minOrder` ASC [ RunTime:0.017168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13307958 ORDER BY `unit` DESC [ RunTime:0.007865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13307958 LIMIT 2 [ RunTime:0.013728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307958 ORDER BY `minOrder` ASC [ RunTime:0.005291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307944 LIMIT 5 [ RunTime:0.006670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307944 ORDER BY `minOrder` ASC [ RunTime:0.016323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13307944 ORDER BY `unit` DESC [ RunTime:0.020155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13307944 LIMIT 2 [ RunTime:0.014215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307944 ORDER BY `minOrder` ASC [ RunTime:0.015436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305919 LIMIT 5 [ RunTime:0.034909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305919 ORDER BY `minOrder` ASC [ RunTime:0.043500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305919 ORDER BY `unit` DESC [ RunTime:0.007519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305919 LIMIT 2 [ RunTime:0.008300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305919 ORDER BY `minOrder` ASC [ RunTime:0.036038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305906 LIMIT 5 [ RunTime:0.042611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305906 ORDER BY `minOrder` ASC [ RunTime:0.021658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305906 ORDER BY `unit` DESC [ RunTime:0.031063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305906 LIMIT 2 [ RunTime:0.034565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305906 ORDER BY `minOrder` ASC [ RunTime:0.011866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305897 LIMIT 5 [ RunTime:0.012397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305897 ORDER BY `minOrder` ASC [ RunTime:0.026173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305897 ORDER BY `unit` DESC [ RunTime:0.056457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305897 LIMIT 2 [ RunTime:0.031178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305897 ORDER BY `minOrder` ASC [ RunTime:0.017972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305876 LIMIT 5 [ RunTime:0.025145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305876 ORDER BY `minOrder` ASC [ RunTime:0.079930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305876 ORDER BY `unit` DESC [ RunTime:0.056168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305876 LIMIT 2 [ RunTime:0.082746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305876 ORDER BY `minOrder` ASC [ RunTime:0.047751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286704 LIMIT 5 [ RunTime:0.054229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286704 ORDER BY `minOrder` ASC [ RunTime:0.064808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286704 ORDER BY `unit` DESC [ RunTime:0.026555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286704 LIMIT 2 [ RunTime:0.091714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286704 ORDER BY `minOrder` ASC [ RunTime:0.048818s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023279s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56553868 LIMIT 5 [ RunTime:0.009318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56553868 ORDER BY `minOrder` ASC [ RunTime:0.015863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56553868 ORDER BY `unit` DESC [ RunTime:0.015656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56553868 LIMIT 2 [ RunTime:0.030400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56553868 ORDER BY `minOrder` ASC [ RunTime:0.006646s ]
select * from pdf where partno='6007' and brandshort='Serpac' limit 1 [ RunTime:0.034735s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.012434s ]
SELECT `id` FROM `stock` WHERE `id` <> 56553868 AND `partno` = '6007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.005381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13326267 [ RunTime:0.028792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55599809 LIMIT 5 [ RunTime:0.017751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55599809 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55599809 ORDER BY `unit` DESC [ RunTime:0.017855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55599809 LIMIT 2 [ RunTime:0.022901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55599809 ORDER BY `minOrder` ASC [ RunTime:0.006646s ]
select * from pdf where partno='6007.0214' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.008145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007.0214' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.023470s ]
SELECT `id` FROM `stock` WHERE `id` <> 55599809 AND `partno` = '6007.0214' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.014049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433695 [ RunTime:0.009941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57754892 LIMIT 5 [ RunTime:0.004629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57754892 ORDER BY `minOrder` ASC [ RunTime:0.010653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57754892 ORDER BY `unit` DESC [ RunTime:0.016863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57754892 LIMIT 2 [ RunTime:0.021134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57754892 ORDER BY `minOrder` ASC [ RunTime:0.006473s ]
select * from pdf where partno='6007CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.035485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.021983s ]
SELECT `id` FROM `stock` WHERE `id` <> 57754892 AND `partno` = '6007CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063599 [ RunTime:0.017547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55599844 LIMIT 5 [ RunTime:0.013376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55599844 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55599844 ORDER BY `unit` DESC [ RunTime:0.018976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55599844 LIMIT 2 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55599844 ORDER BY `minOrder` ASC [ RunTime:0.021230s ]
select * from pdf where partno='6007.0204' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.020424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007.0204' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.001168s ]
SELECT `id` FROM `stock` WHERE `id` <> 55599844 AND `partno` = '6007.0204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.008944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14433744 [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51867035 LIMIT 5 [ RunTime:0.002729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51867035 ORDER BY `minOrder` ASC [ RunTime:0.006557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51867035 ORDER BY `unit` DESC [ RunTime:0.011242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51867035 LIMIT 2 [ RunTime:0.012683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51867035 ORDER BY `minOrder` ASC [ RunTime:0.003826s ]
select * from pdf where partno='6007' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001460s ]
SELECT `id` FROM `stock` WHERE `id` <> 51867035 AND `partno` = '6007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684349 [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55600815 LIMIT 5 [ RunTime:0.000976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55600815 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55600815 ORDER BY `unit` DESC [ RunTime:0.003746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55600815 LIMIT 2 [ RunTime:0.012947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55600815 ORDER BY `minOrder` ASC [ RunTime:0.010608s ]
select * from pdf where partno='6007.0212' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.001765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007.0212' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.006609s ]
SELECT `id` FROM `stock` WHERE `id` <> 55600815 AND `partno` = '6007.0212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.028119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13564961 [ RunTime:0.007688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54389487 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54389487 ORDER BY `minOrder` ASC [ RunTime:0.009138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54389487 ORDER BY `unit` DESC [ RunTime:0.016923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54389487 LIMIT 2 [ RunTime:0.002340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54389487 ORDER BY `minOrder` ASC [ RunTime:0.011552s ]
select * from pdf where partno='6007303' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007303' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005736s ]
SELECT `id` FROM `stock` WHERE `id` <> 54389487 AND `partno` = '6007303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51700046 LIMIT 5 [ RunTime:0.010258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51700046 ORDER BY `minOrder` ASC [ RunTime:0.001587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51700046 ORDER BY `unit` DESC [ RunTime:0.005321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51700046 LIMIT 2 [ RunTime:0.002556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51700046 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
select * from pdf where partno='6007DD' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.012911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007DD' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.008491s ]
SELECT `id` FROM `stock` WHERE `id` <> 51700046 AND `partno` = '6007DD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.003537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54389488 LIMIT 5 [ RunTime:0.005173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54389488 ORDER BY `minOrder` ASC [ RunTime:0.008750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54389488 ORDER BY `unit` DESC [ RunTime:0.003445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54389488 LIMIT 2 [ RunTime:0.005133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54389488 ORDER BY `minOrder` ASC [ RunTime:0.006440s ]
select * from pdf where partno='6007302' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007302' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000681s ]
SELECT `id` FROM `stock` WHERE `id` <> 54389488 AND `partno` = '6007302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56622757 LIMIT 5 [ RunTime:0.003224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622757 ORDER BY `minOrder` ASC [ RunTime:0.005068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56622757 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56622757 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622757 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='600709210' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.009410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600709210' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.006472s ]
SELECT `id` FROM `stock` WHERE `id` <> 56622757 AND `partno` = '600709210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.005353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19038057 [ RunTime:0.004604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56622439 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622439 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56622439 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56622439 LIMIT 2 [ RunTime:0.004388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622439 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='600709110' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600709110' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.008403s ]
SELECT `id` FROM `stock` WHERE `id` <> 56622439 AND `partno` = '600709110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.006218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037803 [ RunTime:0.011113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56622438 LIMIT 5 [ RunTime:0.028646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622438 ORDER BY `minOrder` ASC [ RunTime:0.014372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56622438 ORDER BY `unit` DESC [ RunTime:0.004995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56622438 LIMIT 2 [ RunTime:0.016145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56622438 ORDER BY `minOrder` ASC [ RunTime:0.002836s ]
select * from pdf where partno='600707210' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.011845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600707210' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.007296s ]
SELECT `id` FROM `stock` WHERE `id` <> 56622438 AND `partno` = '600707210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.007989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037802 [ RunTime:0.007807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56621966 LIMIT 5 [ RunTime:0.010220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621966 ORDER BY `minOrder` ASC [ RunTime:0.001067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56621966 ORDER BY `unit` DESC [ RunTime:0.015977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56621966 LIMIT 2 [ RunTime:0.006619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621966 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='600707110' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.007645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600707110' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.004509s ]
SELECT `id` FROM `stock` WHERE `id` <> 56621966 AND `partno` = '600707110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.016374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277837 [ RunTime:0.026021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56621955 LIMIT 5 [ RunTime:0.019157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621955 ORDER BY `minOrder` ASC [ RunTime:0.012464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56621955 ORDER BY `unit` DESC [ RunTime:0.021250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56621955 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621955 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
select * from pdf where partno='600709150' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.007414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600709150' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.006816s ]
SELECT `id` FROM `stock` WHERE `id` <> 56621955 AND `partno` = '600709150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.055689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277805 [ RunTime:0.020519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56621522 LIMIT 5 [ RunTime:0.011816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621522 ORDER BY `minOrder` ASC [ RunTime:0.012993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56621522 ORDER BY `unit` DESC [ RunTime:0.061819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56621522 LIMIT 2 [ RunTime:0.031382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56621522 ORDER BY `minOrder` ASC [ RunTime:0.006745s ]
select * from pdf where partno='600707150' and brandshort='Rose Enclosures' limit 1 [ RunTime:0.006629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600707150' OR `brand` LIKE 'Rose Enclosures%' ) ) LIMIT 1 [ RunTime:0.024214s ]
SELECT `id` FROM `stock` WHERE `id` <> 56621522 AND `partno` = '600707150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rose enclosures%' ) [ RunTime:0.017619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037443 [ RunTime:0.004202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56325311 LIMIT 5 [ RunTime:0.018089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325311 ORDER BY `minOrder` ASC [ RunTime:0.015495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56325311 ORDER BY `unit` DESC [ RunTime:0.018126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56325311 LIMIT 2 [ RunTime:0.004698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325311 ORDER BY `minOrder` ASC [ RunTime:0.010322s ]
select * from pdf where partno='6007-5-12.5-001' and brandshort='CNC Tech' limit 1 [ RunTime:0.027956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007-5-12.5-001' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.018357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56325310 LIMIT 5 [ RunTime:0.016352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325310 ORDER BY `minOrder` ASC [ RunTime:0.005098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56325310 ORDER BY `unit` DESC [ RunTime:0.015023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56325310 LIMIT 2 [ RunTime:0.004987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325310 ORDER BY `minOrder` ASC [ RunTime:0.006800s ]
select * from pdf where partno='6007-8-12.5-012' and brandshort='CNC Tech' limit 1 [ RunTime:0.032441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007-8-12.5-012' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.036951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56325309 LIMIT 5 [ RunTime:0.040132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325309 ORDER BY `minOrder` ASC [ RunTime:0.034262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56325309 ORDER BY `unit` DESC [ RunTime:0.012456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56325309 LIMIT 2 [ RunTime:0.024945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325309 ORDER BY `minOrder` ASC [ RunTime:0.007962s ]
select * from pdf where partno='6007S-6-12.5-001' and brandshort='CNC Tech' limit 1 [ RunTime:0.012653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007S-6-12.5-001' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.025269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56325308 LIMIT 5 [ RunTime:0.017328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325308 ORDER BY `minOrder` ASC [ RunTime:0.018223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56325308 ORDER BY `unit` DESC [ RunTime:0.015664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56325308 LIMIT 2 [ RunTime:0.013389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325308 ORDER BY `minOrder` ASC [ RunTime:0.015095s ]
select * from pdf where partno='6007-8-12.5-001' and brandshort='CNC Tech' limit 1 [ RunTime:0.010011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007-8-12.5-001' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.020256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56325307 LIMIT 5 [ RunTime:0.022891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325307 ORDER BY `minOrder` ASC [ RunTime:0.007978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56325307 ORDER BY `unit` DESC [ RunTime:0.037819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56325307 LIMIT 2 [ RunTime:0.006939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56325307 ORDER BY `minOrder` ASC [ RunTime:0.017131s ]
select * from pdf where partno='6007S-6-12.5-012' and brandshort='CNC Tech' limit 1 [ RunTime:0.018174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6007S-6-12.5-012' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.039515s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034835s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007851s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019604s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013432s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013585s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013079s ]
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 '6007%' OR `brand` LIKE '6007%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005413s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6007%' OR `brand` LIKE '6007%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021927s ]