SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002972s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009250s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034837 LIMIT 5 [ RunTime:0.001078s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034837 ORDER BY `minOrder` ASC [ RunTime:0.010787s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034837 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034837 LIMIT 2 [ RunTime:0.004119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034837 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15378502 LIMIT 5 [ RunTime:0.006228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15378502 ORDER BY `minOrder` ASC [ RunTime:0.014560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15378502 ORDER BY `unit` DESC [ RunTime:0.006075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15378502 LIMIT 2 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15378502 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421006 LIMIT 5 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421006 ORDER BY `minOrder` ASC [ RunTime:0.006256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14421006 ORDER BY `unit` DESC [ RunTime:0.000906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14421006 LIMIT 2 [ RunTime:0.028984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421006 ORDER BY `minOrder` ASC [ RunTime:0.005044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396252 LIMIT 5 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396252 ORDER BY `minOrder` ASC [ RunTime:0.015501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396252 ORDER BY `unit` DESC [ RunTime:0.010094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396252 LIMIT 2 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396252 ORDER BY `minOrder` ASC [ RunTime:0.003467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550606 LIMIT 5 [ RunTime:0.009960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550606 ORDER BY `minOrder` ASC [ RunTime:0.007915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550606 ORDER BY `unit` DESC [ RunTime:0.007002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550606 LIMIT 2 [ RunTime:0.030045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550606 ORDER BY `minOrder` ASC [ RunTime:0.013972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550599 LIMIT 5 [ RunTime:0.010042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550599 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550599 ORDER BY `unit` DESC [ RunTime:0.002477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550599 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550599 ORDER BY `minOrder` ASC [ RunTime:0.002410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524011 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524011 ORDER BY `minOrder` ASC [ RunTime:0.005063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524011 ORDER BY `unit` DESC [ RunTime:0.012663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524011 LIMIT 2 [ RunTime:0.004875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524011 ORDER BY `minOrder` ASC [ RunTime:0.004369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523926 LIMIT 5 [ RunTime:0.011792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523926 ORDER BY `minOrder` ASC [ RunTime:0.008848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523926 ORDER BY `unit` DESC [ RunTime:0.013600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523926 LIMIT 2 [ RunTime:0.009364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523926 ORDER BY `minOrder` ASC [ RunTime:0.011796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523761 LIMIT 5 [ RunTime:0.011196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523761 ORDER BY `minOrder` ASC [ RunTime:0.022399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523761 ORDER BY `unit` DESC [ RunTime:0.043413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523761 LIMIT 2 [ RunTime:0.018279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523761 ORDER BY `minOrder` ASC [ RunTime:0.014572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252719 LIMIT 5 [ RunTime:0.022537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252719 ORDER BY `minOrder` ASC [ RunTime:0.023081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252719 ORDER BY `unit` DESC [ RunTime:0.012029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252719 LIMIT 2 [ RunTime:0.018339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252719 ORDER BY `minOrder` ASC [ RunTime:0.014936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12262087 LIMIT 5 [ RunTime:0.011907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262087 ORDER BY `minOrder` ASC [ RunTime:0.005198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12262087 ORDER BY `unit` DESC [ RunTime:0.040806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12262087 LIMIT 2 [ RunTime:0.009933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12262087 ORDER BY `minOrder` ASC [ RunTime:0.028473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11251646 LIMIT 5 [ RunTime:0.012786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11251646 ORDER BY `minOrder` ASC [ RunTime:0.046174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11251646 ORDER BY `unit` DESC [ RunTime:0.005859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11251646 LIMIT 2 [ RunTime:0.010621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11251646 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012382s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58123014 LIMIT 5 [ RunTime:0.020393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123014 ORDER BY `minOrder` ASC [ RunTime:0.012403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58123014 ORDER BY `unit` DESC [ RunTime:0.051127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58123014 LIMIT 2 [ RunTime:0.015602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123014 ORDER BY `minOrder` ASC [ RunTime:0.036895s ]
select * from pdf where partno='7379' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.017893s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.023182s ]
SELECT `id` FROM `stock` WHERE `id` <> 58123014 AND `partno` = '7379' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.026677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034837 [ RunTime:0.021824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64828685 LIMIT 5 [ RunTime:0.026861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64828685 ORDER BY `minOrder` ASC [ RunTime:0.023415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64828685 ORDER BY `unit` DESC [ RunTime:0.012215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64828685 LIMIT 2 [ RunTime:0.004335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64828685 ORDER BY `minOrder` ASC [ RunTime:0.010689s ]
select * from pdf where partno='7379' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.005049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.006665s ]
SELECT `id` FROM `stock` WHERE `id` <> 64828685 AND `partno` = '7379' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.016752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536142 LIMIT 5 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536142 ORDER BY `minOrder` ASC [ RunTime:0.027755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536142 ORDER BY `unit` DESC [ RunTime:0.004898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536142 LIMIT 2 [ RunTime:0.020205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536142 ORDER BY `minOrder` ASC [ RunTime:0.006509s ]
select * from pdf where partno='73796' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73796' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013594s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536142 AND `partno` = '73796' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421006 [ RunTime:0.005296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536139 LIMIT 5 [ RunTime:0.012263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536139 ORDER BY `minOrder` ASC [ RunTime:0.013302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536139 ORDER BY `unit` DESC [ RunTime:0.009057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536139 LIMIT 2 [ RunTime:0.020687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536139 ORDER BY `minOrder` ASC [ RunTime:0.010365s ]
select * from pdf where partno='73793' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73793' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008282s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536139 AND `partno` = '73793' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550606 [ RunTime:0.004904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536132 LIMIT 5 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536132 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536132 ORDER BY `unit` DESC [ RunTime:0.001065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536132 LIMIT 2 [ RunTime:0.004869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536132 ORDER BY `minOrder` ASC [ RunTime:0.001534s ]
select * from pdf where partno='73797' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73797' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014266s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536132 AND `partno` = '73797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550599 [ RunTime:0.001907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64515314 LIMIT 5 [ RunTime:0.001801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64515314 ORDER BY `minOrder` ASC [ RunTime:0.002888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64515314 ORDER BY `unit` DESC [ RunTime:0.006688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64515314 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64515314 ORDER BY `minOrder` ASC [ RunTime:0.002561s ]
select * from pdf where partno='7379-1HV-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-1HV-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010285s ]
SELECT `id` FROM `stock` WHERE `id` <> 64515314 AND `partno` = '7379-1HV-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396252 [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64513268 LIMIT 5 [ RunTime:0.008577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513268 ORDER BY `minOrder` ASC [ RunTime:0.002826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64513268 ORDER BY `unit` DESC [ RunTime:0.002642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64513268 LIMIT 2 [ RunTime:0.009368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513268 ORDER BY `minOrder` ASC [ RunTime:0.003419s ]
select * from pdf where partno='7379-1-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-1-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005176s ]
SELECT `id` FROM `stock` WHERE `id` <> 64513268 AND `partno` = '7379-1-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.027570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524011 [ RunTime:0.016791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64513132 LIMIT 5 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513132 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64513132 ORDER BY `unit` DESC [ RunTime:0.003081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64513132 LIMIT 2 [ RunTime:0.011997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513132 ORDER BY `minOrder` ASC [ RunTime:0.009805s ]
select * from pdf where partno='7379-4-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.021867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-4-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007945s ]
SELECT `id` FROM `stock` WHERE `id` <> 64513132 AND `partno` = '7379-4-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523926 [ RunTime:0.022528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64512844 LIMIT 5 [ RunTime:0.009972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64512844 ORDER BY `minOrder` ASC [ RunTime:0.021240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64512844 ORDER BY `unit` DESC [ RunTime:0.025217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64512844 LIMIT 2 [ RunTime:0.038836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64512844 ORDER BY `minOrder` ASC [ RunTime:0.007087s ]
select * from pdf where partno='7379-3C-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.023362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-3C-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007184s ]
SELECT `id` FROM `stock` WHERE `id` <> 64512844 AND `partno` = '7379-3C-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523761 [ RunTime:0.016531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288275 LIMIT 5 [ RunTime:0.015645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288275 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288275 ORDER BY `unit` DESC [ RunTime:0.008274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288275 LIMIT 2 [ RunTime:0.002342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288275 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='7379-ACF-2.0MMX50M' and brandshort='3M' limit 1 [ RunTime:0.012323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-ACF-2.0MMX50M' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.009112s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288275 AND `partno` = '7379-ACF-2.0MMX50M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.034735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15378502 [ RunTime:0.014924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288083 LIMIT 5 [ RunTime:0.016288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288083 ORDER BY `minOrder` ASC [ RunTime:0.037118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288083 ORDER BY `unit` DESC [ RunTime:0.027083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288083 LIMIT 2 [ RunTime:0.014283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288083 ORDER BY `minOrder` ASC [ RunTime:0.018116s ]
select * from pdf where partno='7379-2MMX10M' and brandshort='3M' limit 1 [ RunTime:0.015616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-2MMX10M' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.023433s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288083 AND `partno` = '7379-2MMX10M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.027070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12262087 [ RunTime:0.044970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64288041 LIMIT 5 [ RunTime:0.010632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288041 ORDER BY `minOrder` ASC [ RunTime:0.021734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64288041 ORDER BY `unit` DESC [ RunTime:0.027875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64288041 LIMIT 2 [ RunTime:0.031199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64288041 ORDER BY `minOrder` ASC [ RunTime:0.014729s ]
select * from pdf where partno='7379-1.5MMX10M' and brandshort='3M' limit 1 [ RunTime:0.029754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379-1.5MMX10M' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.038751s ]
SELECT `id` FROM `stock` WHERE `id` <> 64288041 AND `partno` = '7379-1.5MMX10M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.053269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11251646 [ RunTime:0.009333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64195114 LIMIT 5 [ RunTime:0.053891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64195114 ORDER BY `minOrder` ASC [ RunTime:0.034863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64195114 ORDER BY `unit` DESC [ RunTime:0.030181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64195114 LIMIT 2 [ RunTime:0.011862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64195114 ORDER BY `minOrder` ASC [ RunTime:0.021412s ]
select * from pdf where partno='737978' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.032534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '737978' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.026667s ]
SELECT `id` FROM `stock` WHERE `id` <> 64195114 AND `partno` = '737978' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.027410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252719 [ RunTime:0.028490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355672 LIMIT 5 [ RunTime:0.023887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355672 ORDER BY `minOrder` ASC [ RunTime:0.018492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355672 ORDER BY `unit` DESC [ RunTime:0.003569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355672 LIMIT 2 [ RunTime:0.005575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355672 ORDER BY `minOrder` ASC [ RunTime:0.011955s ]
select * from pdf where partno='7379' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.023554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7379' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.011991s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355672 AND `partno` = '7379' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012965s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022693s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033430s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030585s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035804s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011675s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019669s ]
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 '7379%' OR `brand` LIKE '7379%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041554s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7379%' OR `brand` LIKE '7379%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021640s ]