SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002567s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003450s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420564 LIMIT 5 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14420564 ORDER BY `minOrder` ASC [ RunTime:0.003181s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14420564 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14420564 LIMIT 2 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14420564 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638490 LIMIT 5 [ RunTime:0.005880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638490 ORDER BY `minOrder` ASC [ RunTime:0.011664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638490 ORDER BY `unit` DESC [ RunTime:0.007908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638490 LIMIT 2 [ RunTime:0.003835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638490 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556660 LIMIT 5 [ RunTime:0.006261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556660 ORDER BY `minOrder` ASC [ RunTime:0.007213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556660 ORDER BY `unit` DESC [ RunTime:0.007067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556660 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556660 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556657 LIMIT 5 [ RunTime:0.002754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556657 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556657 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556657 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556657 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555285 LIMIT 5 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555285 ORDER BY `minOrder` ASC [ RunTime:0.004635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555285 ORDER BY `unit` DESC [ RunTime:0.004149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555285 LIMIT 2 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555285 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555281 LIMIT 5 [ RunTime:0.005406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555281 ORDER BY `minOrder` ASC [ RunTime:0.006703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555281 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555281 LIMIT 2 [ RunTime:0.008988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555281 ORDER BY `minOrder` ASC [ RunTime:0.002161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554373 LIMIT 5 [ RunTime:0.000842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554373 ORDER BY `minOrder` ASC [ RunTime:0.004263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554373 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554373 LIMIT 2 [ RunTime:0.003462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554373 ORDER BY `minOrder` ASC [ RunTime:0.006337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553539 LIMIT 5 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553539 ORDER BY `minOrder` ASC [ RunTime:0.006125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553539 ORDER BY `unit` DESC [ RunTime:0.002640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553539 LIMIT 2 [ RunTime:0.005393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553539 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552477 LIMIT 5 [ RunTime:0.002539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552477 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552477 ORDER BY `unit` DESC [ RunTime:0.008541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552477 LIMIT 2 [ RunTime:0.007291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552477 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549996 LIMIT 5 [ RunTime:0.001479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549996 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13549996 ORDER BY `unit` DESC [ RunTime:0.011998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13549996 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549996 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549994 LIMIT 5 [ RunTime:0.006364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549994 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13549994 ORDER BY `unit` DESC [ RunTime:0.006915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13549994 LIMIT 2 [ RunTime:0.000972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549994 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001801s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50704059 LIMIT 5 [ RunTime:0.001287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50704059 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50704059 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50704059 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50704059 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='128221' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128221' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000357s ]
SELECT `id` FROM `stock` WHERE `id` <> 50704059 AND `partno` = '128221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420564 [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38088118 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38088118 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38088118 ORDER BY `unit` DESC [ RunTime:0.002741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38088118 LIMIT 2 [ RunTime:0.004911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38088118 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='128221' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128221' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000423s ]
SELECT `id` FROM `stock` WHERE `id` <> 38088118 AND `partno` = '128221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420564 [ RunTime:0.001648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667661 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667661 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667661 ORDER BY `unit` DESC [ RunTime:0.003373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667661 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667661 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1282260000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1282260000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001177s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667661 AND `partno` = '1282260000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638490 [ RunTime:0.005698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712896 LIMIT 5 [ RunTime:0.003511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712896 ORDER BY `minOrder` ASC [ RunTime:0.002259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712896 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712896 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712896 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='128229' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128229' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003292s ]
SELECT `id` FROM `stock` WHERE `id` <> 50712896 AND `partno` = '128229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556660 [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50712887 LIMIT 5 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712887 ORDER BY `minOrder` ASC [ RunTime:0.000934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50712887 ORDER BY `unit` DESC [ RunTime:0.001379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50712887 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50712887 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='128223' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128223' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000355s ]
SELECT `id` FROM `stock` WHERE `id` <> 50712887 AND `partno` = '128223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556657 [ RunTime:0.002284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710500 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710500 ORDER BY `minOrder` ASC [ RunTime:0.002138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710500 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710500 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710500 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='128226' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128226' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001052s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710500 AND `partno` = '128226' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555285 [ RunTime:0.006762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710492 LIMIT 5 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710492 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710492 ORDER BY `unit` DESC [ RunTime:0.002431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710492 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710492 ORDER BY `minOrder` ASC [ RunTime:0.002152s ]
select * from pdf where partno='128220' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128220' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000226s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710492 AND `partno` = '128220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555281 [ RunTime:0.000216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50709017 LIMIT 5 [ RunTime:0.000222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709017 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50709017 ORDER BY `unit` DESC [ RunTime:0.000233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50709017 LIMIT 2 [ RunTime:0.000228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709017 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='128224' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128224' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002303s ]
SELECT `id` FROM `stock` WHERE `id` <> 50709017 AND `partno` = '128224' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554373 [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50707765 LIMIT 5 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707765 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50707765 ORDER BY `unit` DESC [ RunTime:0.000370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50707765 LIMIT 2 [ RunTime:0.001490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50707765 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='128225' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128225' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006350s ]
SELECT `id` FROM `stock` WHERE `id` <> 50707765 AND `partno` = '128225' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553539 [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50706071 LIMIT 5 [ RunTime:0.002586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706071 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50706071 ORDER BY `unit` DESC [ RunTime:0.001422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50706071 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706071 ORDER BY `minOrder` ASC [ RunTime:0.002869s ]
select * from pdf where partno='128227' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128227' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004267s ]
SELECT `id` FROM `stock` WHERE `id` <> 50706071 AND `partno` = '128227' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552477 [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705025 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705025 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705025 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705025 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705025 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='128222' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128222' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003210s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705025 AND `partno` = '128222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549996 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705023 LIMIT 5 [ RunTime:0.007542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705023 ORDER BY `minOrder` ASC [ RunTime:0.007643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705023 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705023 LIMIT 2 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705023 ORDER BY `minOrder` ASC [ RunTime:0.006424s ]
select * from pdf where partno='128228' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128228' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010587s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705023 AND `partno` = '128228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549994 [ RunTime:0.002812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49268648 LIMIT 5 [ RunTime:0.002230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49268648 ORDER BY `minOrder` ASC [ RunTime:0.003531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49268648 ORDER BY `unit` DESC [ RunTime:0.009195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49268648 LIMIT 2 [ RunTime:0.002520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49268648 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
select * from pdf where partno='12822B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12822B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002390s ]
SELECT `id` FROM `stock` WHERE `id` <> 49268648 AND `partno` = '12822B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.011984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36472098 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49268613 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49268613 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49268613 ORDER BY `unit` DESC [ RunTime:0.002344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49268613 LIMIT 2 [ RunTime:0.002209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49268613 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='12822' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12822' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 49268613 AND `partno` = '12822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36472062 [ RunTime:0.003011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38101697 LIMIT 5 [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38101697 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38101697 ORDER BY `unit` DESC [ RunTime:0.000808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38101697 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38101697 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='128229' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128229' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT `id` FROM `stock` WHERE `id` <> 38101697 AND `partno` = '128229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556660 [ RunTime:0.010284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38101688 LIMIT 5 [ RunTime:0.006640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38101688 ORDER BY `minOrder` ASC [ RunTime:0.003781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38101688 ORDER BY `unit` DESC [ RunTime:0.002006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38101688 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38101688 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='128223' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128223' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT `id` FROM `stock` WHERE `id` <> 38101688 AND `partno` = '128223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556657 [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38098258 LIMIT 5 [ RunTime:0.001638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098258 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38098258 ORDER BY `unit` DESC [ RunTime:0.000733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38098258 LIMIT 2 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098258 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='128226' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128226' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id` FROM `stock` WHERE `id` <> 38098258 AND `partno` = '128226' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555285 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38098250 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098250 ORDER BY `minOrder` ASC [ RunTime:0.015790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38098250 ORDER BY `unit` DESC [ RunTime:0.004017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38098250 LIMIT 2 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098250 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='128220' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128220' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `stock` WHERE `id` <> 38098250 AND `partno` = '128220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555281 [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38095875 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38095875 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38095875 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38095875 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38095875 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='128224' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128224' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 38095875 AND `partno` = '128224' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554373 [ RunTime:0.003241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38093923 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38093923 ORDER BY `minOrder` ASC [ RunTime:0.008079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38093923 ORDER BY `unit` DESC [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38093923 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38093923 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='128225' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128225' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 38093923 AND `partno` = '128225' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553539 [ RunTime:0.000406s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001244s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001123s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004386s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001647s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001170s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004605s ]
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 '12822%' OR `brand` LIKE '12822%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001894s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12822%' OR `brand` LIKE '12822%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001258s ]