SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001447s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017055s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420529 LIMIT 5 [ RunTime:0.045552s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420529 ORDER BY `minOrder` ASC [ RunTime:0.075353s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16420529 ORDER BY `unit` DESC [ RunTime:0.026436s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16420529 LIMIT 2 [ RunTime:0.092004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16420529 ORDER BY `minOrder` ASC [ RunTime:0.045777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19616788 LIMIT 5 [ RunTime:0.032805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19616788 ORDER BY `minOrder` ASC [ RunTime:0.040091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19616788 ORDER BY `unit` DESC [ RunTime:0.073157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19616788 LIMIT 2 [ RunTime:0.064625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19616788 ORDER BY `minOrder` ASC [ RunTime:0.012317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17312752 LIMIT 5 [ RunTime:0.090351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312752 ORDER BY `minOrder` ASC [ RunTime:0.114605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17312752 ORDER BY `unit` DESC [ RunTime:0.052740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17312752 LIMIT 2 [ RunTime:0.069544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312752 ORDER BY `minOrder` ASC [ RunTime:0.006517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311726 LIMIT 5 [ RunTime:0.064282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311726 ORDER BY `minOrder` ASC [ RunTime:0.078900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17311726 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17311726 LIMIT 2 [ RunTime:0.021000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311726 ORDER BY `minOrder` ASC [ RunTime:0.028121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425792 LIMIT 5 [ RunTime:0.052701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425792 ORDER BY `minOrder` ASC [ RunTime:0.021017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425792 ORDER BY `unit` DESC [ RunTime:0.043301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425792 LIMIT 2 [ RunTime:0.016758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425792 ORDER BY `minOrder` ASC [ RunTime:0.004953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14246146 LIMIT 5 [ RunTime:0.016010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246146 ORDER BY `minOrder` ASC [ RunTime:0.018320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14246146 ORDER BY `unit` DESC [ RunTime:0.024972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14246146 LIMIT 2 [ RunTime:0.014020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246146 ORDER BY `minOrder` ASC [ RunTime:0.030692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555420 LIMIT 5 [ RunTime:0.011093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555420 ORDER BY `minOrder` ASC [ RunTime:0.009737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555420 ORDER BY `unit` DESC [ RunTime:0.060475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555420 LIMIT 2 [ RunTime:0.008593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555420 ORDER BY `minOrder` ASC [ RunTime:0.015502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554522 LIMIT 5 [ RunTime:0.024819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554522 ORDER BY `minOrder` ASC [ RunTime:0.050055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554522 ORDER BY `unit` DESC [ RunTime:0.011373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554522 LIMIT 2 [ RunTime:0.003252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554522 ORDER BY `minOrder` ASC [ RunTime:0.014758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553738 LIMIT 5 [ RunTime:0.007917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553738 ORDER BY `minOrder` ASC [ RunTime:0.016512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553738 ORDER BY `unit` DESC [ RunTime:0.006978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553738 LIMIT 2 [ RunTime:0.018269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553738 ORDER BY `minOrder` ASC [ RunTime:0.013144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553125 LIMIT 5 [ RunTime:0.020782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553125 ORDER BY `minOrder` ASC [ RunTime:0.006911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553125 ORDER BY `unit` DESC [ RunTime:0.050704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553125 LIMIT 2 [ RunTime:0.005454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553125 ORDER BY `minOrder` ASC [ RunTime:0.008309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552650 LIMIT 5 [ RunTime:0.026386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552650 ORDER BY `minOrder` ASC [ RunTime:0.043480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552650 ORDER BY `unit` DESC [ RunTime:0.026947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552650 LIMIT 2 [ RunTime:0.032660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552650 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550712 LIMIT 5 [ RunTime:0.008519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550712 ORDER BY `minOrder` ASC [ RunTime:0.015604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550712 ORDER BY `unit` DESC [ RunTime:0.017494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550712 LIMIT 2 [ RunTime:0.110190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550712 ORDER BY `minOrder` ASC [ RunTime:0.025558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12399148 LIMIT 5 [ RunTime:0.033898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12399148 ORDER BY `minOrder` ASC [ RunTime:0.062447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12399148 ORDER BY `unit` DESC [ RunTime:0.059917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12399148 LIMIT 2 [ RunTime:0.087499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12399148 ORDER BY `minOrder` ASC [ RunTime:0.027658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12262505 LIMIT 5 [ RunTime:0.059224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262505 ORDER BY `minOrder` ASC [ RunTime:0.030632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12262505 ORDER BY `unit` DESC [ RunTime:0.053636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12262505 LIMIT 2 [ RunTime:0.033376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262505 ORDER BY `minOrder` ASC [ RunTime:0.016287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439050 LIMIT 5 [ RunTime:0.003757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439050 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11439050 ORDER BY `unit` DESC [ RunTime:0.009437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11439050 LIMIT 2 [ RunTime:0.005998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439050 ORDER BY `minOrder` ASC [ RunTime:0.002718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11338934 LIMIT 5 [ RunTime:0.002688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11338934 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11338934 ORDER BY `unit` DESC [ RunTime:0.003021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11338934 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11338934 ORDER BY `minOrder` ASC [ RunTime:0.001013s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001298s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36500360 LIMIT 5 [ RunTime:0.004603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36500360 ORDER BY `minOrder` ASC [ RunTime:0.017091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36500360 ORDER BY `unit` DESC [ RunTime:0.014104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36500360 LIMIT 2 [ RunTime:0.007081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36500360 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
select * from pdf where partno='1289200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007520s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005542s ]
SELECT `id` FROM `stock` WHERE `id` <> 36500360 AND `partno` = '1289200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.061860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420529 [ RunTime:0.026996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49305222 LIMIT 5 [ RunTime:0.019555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49305222 ORDER BY `minOrder` ASC [ RunTime:0.037270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49305222 ORDER BY `unit` DESC [ RunTime:0.023536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49305222 LIMIT 2 [ RunTime:0.046395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49305222 ORDER BY `minOrder` ASC [ RunTime:0.022920s ]
select * from pdf where partno='1289200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008027s ]
SELECT `id` FROM `stock` WHERE `id` <> 49305222 AND `partno` = '1289200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.038494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420529 [ RunTime:0.012315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53658731 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53658731 ORDER BY `minOrder` ASC [ RunTime:0.011901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53658731 ORDER BY `unit` DESC [ RunTime:0.010707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53658731 LIMIT 2 [ RunTime:0.012088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53658731 ORDER BY `minOrder` ASC [ RunTime:0.023789s ]
select * from pdf where partno='1289270000' and brandshort='Weidmüller' limit 1 [ RunTime:0.052099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289270000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.025274s ]
SELECT `id` FROM `stock` WHERE `id` <> 53658731 AND `partno` = '1289270000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.036163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19616788 [ RunTime:0.022625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663638 LIMIT 5 [ RunTime:0.022112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663638 ORDER BY `minOrder` ASC [ RunTime:0.028029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663638 ORDER BY `unit` DESC [ RunTime:0.005447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663638 LIMIT 2 [ RunTime:0.032921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663638 ORDER BY `minOrder` ASC [ RunTime:0.017594s ]
select * from pdf where partno='1289280000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289280000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005873s ]
SELECT `id` FROM `stock` WHERE `id` <> 53663638 AND `partno` = '1289280000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.021063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17312752 [ RunTime:0.073132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53767517 LIMIT 5 [ RunTime:0.089335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767517 ORDER BY `minOrder` ASC [ RunTime:0.056463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53767517 ORDER BY `unit` DESC [ RunTime:0.073614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53767517 LIMIT 2 [ RunTime:0.033441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53767517 ORDER BY `minOrder` ASC [ RunTime:0.023284s ]
select * from pdf where partno='12892.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.037478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12892.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.037403s ]
SELECT `id` FROM `stock` WHERE `id` <> 53767517 AND `partno` = '12892.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.081560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439050 [ RunTime:0.039622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53700548 LIMIT 5 [ RunTime:0.041586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700548 ORDER BY `minOrder` ASC [ RunTime:0.068194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53700548 ORDER BY `unit` DESC [ RunTime:0.038619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53700548 LIMIT 2 [ RunTime:0.056934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700548 ORDER BY `minOrder` ASC [ RunTime:0.009534s ]
select * from pdf where partno='1289290000' and brandshort='Weidmüller' limit 1 [ RunTime:0.051692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289290000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.068430s ]
SELECT `id` FROM `stock` WHERE `id` <> 53700548 AND `partno` = '1289290000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14246146 [ RunTime:0.034186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50746843 LIMIT 5 [ RunTime:0.006757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746843 ORDER BY `minOrder` ASC [ RunTime:0.024514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50746843 ORDER BY `unit` DESC [ RunTime:0.005930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50746843 LIMIT 2 [ RunTime:0.049071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746843 ORDER BY `minOrder` ASC [ RunTime:0.012080s ]
select * from pdf where partno='12892' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.004399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12892' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.002625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713155 LIMIT 5 [ RunTime:0.014810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713155 ORDER BY `minOrder` ASC [ RunTime:0.028042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713155 ORDER BY `unit` DESC [ RunTime:0.021817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713155 LIMIT 2 [ RunTime:0.037319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713155 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
select * from pdf where partno='128925' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128925' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010283s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713155 AND `partno` = '128925' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425792 [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710732 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710732 ORDER BY `minOrder` ASC [ RunTime:0.006228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710732 ORDER BY `unit` DESC [ RunTime:0.001952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710732 LIMIT 2 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710732 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='128922' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128922' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004055s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710732 AND `partno` = '128922' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555420 [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50709272 LIMIT 5 [ RunTime:0.008451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709272 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50709272 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50709272 LIMIT 2 [ RunTime:0.002302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709272 ORDER BY `minOrder` ASC [ RunTime:0.003318s ]
select * from pdf where partno='128926' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128926' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003069s ]
SELECT `id` FROM `stock` WHERE `id` <> 50709272 AND `partno` = '128926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554522 [ RunTime:0.001667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50707993 LIMIT 5 [ RunTime:0.002396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707993 ORDER BY `minOrder` ASC [ RunTime:0.004326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50707993 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50707993 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707993 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='128927' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128927' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002233s ]
SELECT `id` FROM `stock` WHERE `id` <> 50707993 AND `partno` = '128927' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553738 [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50707127 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707127 ORDER BY `minOrder` ASC [ RunTime:0.010492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50707127 ORDER BY `unit` DESC [ RunTime:0.006718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50707127 LIMIT 2 [ RunTime:0.001251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707127 ORDER BY `minOrder` ASC [ RunTime:0.006741s ]
select * from pdf where partno='128929' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128929' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003146s ]
SELECT `id` FROM `stock` WHERE `id` <> 50707127 AND `partno` = '128929' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553125 [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50706362 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706362 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50706362 ORDER BY `unit` DESC [ RunTime:0.006676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50706362 LIMIT 2 [ RunTime:0.003366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706362 ORDER BY `minOrder` ASC [ RunTime:0.001823s ]
select * from pdf where partno='128923' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128923' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 50706362 AND `partno` = '128923' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552650 [ RunTime:0.001833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705216 LIMIT 5 [ RunTime:0.003801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705216 ORDER BY `minOrder` ASC [ RunTime:0.003862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705216 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705216 LIMIT 2 [ RunTime:0.002787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705216 ORDER BY `minOrder` ASC [ RunTime:0.007967s ]
select * from pdf where partno='128924' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128924' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000943s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705216 AND `partno` = '128924' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550712 [ RunTime:0.002882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38152331 LIMIT 5 [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38152331 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38152331 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38152331 LIMIT 2 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38152331 ORDER BY `minOrder` ASC [ RunTime:0.004295s ]
select * from pdf where partno='12892' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.000614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12892' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38102056 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38102056 ORDER BY `minOrder` ASC [ RunTime:0.008136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38102056 ORDER BY `unit` DESC [ RunTime:0.003846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38102056 LIMIT 2 [ RunTime:0.002281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38102056 ORDER BY `minOrder` ASC [ RunTime:0.004132s ]
select * from pdf where partno='128925' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128925' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000559s ]
SELECT `id` FROM `stock` WHERE `id` <> 38102056 AND `partno` = '128925' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425792 [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38098590 LIMIT 5 [ RunTime:0.003190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098590 ORDER BY `minOrder` ASC [ RunTime:0.003264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38098590 ORDER BY `unit` DESC [ RunTime:0.001016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38098590 LIMIT 2 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098590 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='128922' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128922' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `id` FROM `stock` WHERE `id` <> 38098590 AND `partno` = '128922' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555420 [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38096330 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38096330 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38096330 ORDER BY `unit` DESC [ RunTime:0.012356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38096330 LIMIT 2 [ RunTime:0.001801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38096330 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='128926' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128926' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 38096330 AND `partno` = '128926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554522 [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38094251 LIMIT 5 [ RunTime:0.001307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38094251 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38094251 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38094251 LIMIT 2 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38094251 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='128927' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128927' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 38094251 AND `partno` = '128927' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553738 [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38092885 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092885 ORDER BY `minOrder` ASC [ RunTime:0.001221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38092885 ORDER BY `unit` DESC [ RunTime:0.011808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38092885 LIMIT 2 [ RunTime:0.001931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38092885 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='128929' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128929' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000422s ]
SELECT `id` FROM `stock` WHERE `id` <> 38092885 AND `partno` = '128929' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553125 [ RunTime:0.000498s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002362s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001163s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002143s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007607s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002299s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001135s ]
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 '12892%' OR `brand` LIKE '12892%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001996s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12892%' OR `brand` LIKE '12892%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003293s ]