SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002188s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039924s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512337 LIMIT 5 [ RunTime:0.012938s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512337 ORDER BY `minOrder` ASC [ RunTime:0.012435s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512337 ORDER BY `unit` DESC [ RunTime:0.013119s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512337 LIMIT 2 [ RunTime:0.011826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512337 ORDER BY `minOrder` ASC [ RunTime:0.023143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583125 LIMIT 5 [ RunTime:0.023576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583125 ORDER BY `minOrder` ASC [ RunTime:0.012663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583125 ORDER BY `unit` DESC [ RunTime:0.022506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583125 LIMIT 2 [ RunTime:0.017775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583125 ORDER BY `minOrder` ASC [ RunTime:0.003793s ]
select * from pdf where partno='94785' and brandshort='3M' limit 1 [ RunTime:0.020738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512338 LIMIT 5 [ RunTime:0.005674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512338 ORDER BY `minOrder` ASC [ RunTime:0.018019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512338 ORDER BY `unit` DESC [ RunTime:0.027455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512338 LIMIT 2 [ RunTime:0.025145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512338 ORDER BY `minOrder` ASC [ RunTime:0.023721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583126 LIMIT 5 [ RunTime:0.022657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583126 ORDER BY `minOrder` ASC [ RunTime:0.046206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583126 ORDER BY `unit` DESC [ RunTime:0.022251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583126 LIMIT 2 [ RunTime:0.024524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583126 ORDER BY `minOrder` ASC [ RunTime:0.028555s ]
select * from pdf where partno='94788' and brandshort='3M' limit 1 [ RunTime:0.023979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416042 LIMIT 5 [ RunTime:0.034051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416042 ORDER BY `minOrder` ASC [ RunTime:0.042249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416042 ORDER BY `unit` DESC [ RunTime:0.037807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416042 LIMIT 2 [ RunTime:0.002282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416042 ORDER BY `minOrder` ASC [ RunTime:0.048865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513909 LIMIT 5 [ RunTime:0.018648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513909 ORDER BY `minOrder` ASC [ RunTime:0.018651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513909 ORDER BY `unit` DESC [ RunTime:0.023341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513909 LIMIT 2 [ RunTime:0.039169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513909 ORDER BY `minOrder` ASC [ RunTime:0.008148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441662 LIMIT 5 [ RunTime:0.031265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441662 ORDER BY `minOrder` ASC [ RunTime:0.029623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441662 ORDER BY `unit` DESC [ RunTime:0.019179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441662 LIMIT 2 [ RunTime:0.019336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441662 ORDER BY `minOrder` ASC [ RunTime:0.032770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12515507 LIMIT 5 [ RunTime:0.022641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12515507 ORDER BY `minOrder` ASC [ RunTime:0.044862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12515507 ORDER BY `unit` DESC [ RunTime:0.026414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12515507 LIMIT 2 [ RunTime:0.015303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12515507 ORDER BY `minOrder` ASC [ RunTime:0.008561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260485 LIMIT 5 [ RunTime:0.011968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260485 ORDER BY `minOrder` ASC [ RunTime:0.050614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260485 ORDER BY `unit` DESC [ RunTime:0.031260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260485 LIMIT 2 [ RunTime:0.037903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260485 ORDER BY `minOrder` ASC [ RunTime:0.018127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514418 LIMIT 5 [ RunTime:0.040290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514418 ORDER BY `minOrder` ASC [ RunTime:0.012244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12514418 ORDER BY `unit` DESC [ RunTime:0.039649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12514418 LIMIT 2 [ RunTime:0.065198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514418 ORDER BY `minOrder` ASC [ RunTime:0.016021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534090 LIMIT 5 [ RunTime:0.040714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534090 ORDER BY `minOrder` ASC [ RunTime:0.083399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19534090 ORDER BY `unit` DESC [ RunTime:0.021790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19534090 LIMIT 2 [ RunTime:0.025391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534090 ORDER BY `minOrder` ASC [ RunTime:0.016612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531445 LIMIT 5 [ RunTime:0.016191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531445 ORDER BY `minOrder` ASC [ RunTime:0.031345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19531445 ORDER BY `unit` DESC [ RunTime:0.015181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19531445 LIMIT 2 [ RunTime:0.023877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531445 ORDER BY `minOrder` ASC [ RunTime:0.017061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416424 LIMIT 5 [ RunTime:0.035718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416424 ORDER BY `minOrder` ASC [ RunTime:0.038201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416424 ORDER BY `unit` DESC [ RunTime:0.043768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416424 LIMIT 2 [ RunTime:0.049598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416424 ORDER BY `minOrder` ASC [ RunTime:0.022977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377028 LIMIT 5 [ RunTime:0.054754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377028 ORDER BY `minOrder` ASC [ RunTime:0.044631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377028 ORDER BY `unit` DESC [ RunTime:0.036502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377028 LIMIT 2 [ RunTime:0.023957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377028 ORDER BY `minOrder` ASC [ RunTime:0.005136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512693 LIMIT 5 [ RunTime:0.034320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512693 ORDER BY `minOrder` ASC [ RunTime:0.070199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512693 ORDER BY `unit` DESC [ RunTime:0.048430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512693 LIMIT 2 [ RunTime:0.029726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512693 ORDER BY `minOrder` ASC [ RunTime:0.028580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514983 LIMIT 5 [ RunTime:0.027861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514983 ORDER BY `minOrder` ASC [ RunTime:0.006197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12514983 ORDER BY `unit` DESC [ RunTime:0.030493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12514983 LIMIT 2 [ RunTime:0.039786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514983 ORDER BY `minOrder` ASC [ RunTime:0.026160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377020 LIMIT 5 [ RunTime:0.009276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377020 ORDER BY `minOrder` ASC [ RunTime:0.041620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377020 ORDER BY `unit` DESC [ RunTime:0.017003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377020 LIMIT 2 [ RunTime:0.013582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377020 ORDER BY `minOrder` ASC [ RunTime:0.027139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260688 LIMIT 5 [ RunTime:0.018839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260688 ORDER BY `minOrder` ASC [ RunTime:0.024115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260688 ORDER BY `unit` DESC [ RunTime:0.013880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260688 LIMIT 2 [ RunTime:0.022224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260688 ORDER BY `minOrder` ASC [ RunTime:0.002947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441667 LIMIT 5 [ RunTime:0.005023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441667 ORDER BY `minOrder` ASC [ RunTime:0.007936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441667 ORDER BY `unit` DESC [ RunTime:0.014934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441667 LIMIT 2 [ RunTime:0.014263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441667 ORDER BY `minOrder` ASC [ RunTime:0.012098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416049 LIMIT 5 [ RunTime:0.003823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416049 ORDER BY `minOrder` ASC [ RunTime:0.002225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416049 ORDER BY `unit` DESC [ RunTime:0.006270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416049 LIMIT 2 [ RunTime:0.001950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416049 ORDER BY `minOrder` ASC [ RunTime:0.004819s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212485 LIMIT 5 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212485 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212485 ORDER BY `unit` DESC [ RunTime:0.012159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212485 LIMIT 2 [ RunTime:0.009725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212485 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='947705-001' and brandshort='grayhill' limit 1 [ RunTime:0.015491s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.008026s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-001' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.004487s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212485 AND `partno` = '947705-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.011393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531445 [ RunTime:0.003540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212893 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212893 ORDER BY `minOrder` ASC [ RunTime:0.010241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212893 ORDER BY `unit` DESC [ RunTime:0.011907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212893 LIMIT 2 [ RunTime:0.009982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212893 ORDER BY `minOrder` ASC [ RunTime:0.007678s ]
select * from pdf where partno='947705-019' and brandshort='grayhill' limit 1 [ RunTime:0.001833s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.000829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-019' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.005167s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212893 AND `partno` = '947705-019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.009454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15433574 [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127490 LIMIT 5 [ RunTime:0.004630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127490 ORDER BY `minOrder` ASC [ RunTime:0.007713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127490 ORDER BY `unit` DESC [ RunTime:0.015423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127490 LIMIT 2 [ RunTime:0.006736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127490 ORDER BY `minOrder` ASC [ RunTime:0.002924s ]
select * from pdf where partno='9478104002' and brandshort='fair-rite' limit 1 [ RunTime:0.010916s ]
select foldpath,foldpath2,filename from pdf_file where id=2020585 limit 1 [ RunTime:0.009895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9478104002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.022741s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127490 AND `partno` = '9478104002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.014178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260493 [ RunTime:0.007123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083942 LIMIT 5 [ RunTime:0.001739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083942 ORDER BY `minOrder` ASC [ RunTime:0.002068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083942 ORDER BY `unit` DESC [ RunTime:0.006858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083942 LIMIT 2 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083942 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
select * from pdf where partno='947706-001' and brandshort='grayhill' limit 1 [ RunTime:0.006202s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.020035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947706-001' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.011800s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083942 AND `partno` = '947706-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.022493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534090 [ RunTime:0.011001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212561 LIMIT 5 [ RunTime:0.004290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212561 ORDER BY `minOrder` ASC [ RunTime:0.004090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212561 ORDER BY `unit` DESC [ RunTime:0.017239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212561 LIMIT 2 [ RunTime:0.012935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212561 ORDER BY `minOrder` ASC [ RunTime:0.016865s ]
select * from pdf where partno='947705-012' and brandshort='grayhill' limit 1 [ RunTime:0.028734s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.002718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-012' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.005776s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212561 AND `partno` = '947705-012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.037486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15432184 [ RunTime:0.008307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212562 LIMIT 5 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212562 ORDER BY `minOrder` ASC [ RunTime:0.033843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212562 ORDER BY `unit` DESC [ RunTime:0.014211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212562 LIMIT 2 [ RunTime:0.010162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212562 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='947705-017' and brandshort='grayhill' limit 1 [ RunTime:0.018706s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.008895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-017' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.007696s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212562 AND `partno` = '947705-017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.009056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15433190 [ RunTime:0.009453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098407 LIMIT 5 [ RunTime:0.007517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098407 ORDER BY `minOrder` ASC [ RunTime:0.020162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098407 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098407 LIMIT 2 [ RunTime:0.019787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098407 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
select * from pdf where partno='9472le (12.5mm x 55m)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.013710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9472le (12.5mm x 55m)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.002787s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098407 AND `partno` = '9472le (12.5mm x 55m)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.005109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287968 LIMIT 5 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287968 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287968 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287968 LIMIT 2 [ RunTime:0.001927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287968 ORDER BY `minOrder` ASC [ RunTime:0.001319s ]
select * from pdf where partno='9471le (1/2 in x 60 yd)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.009394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9471le (1/2 in x 60 yd)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.000970s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287968 AND `partno` = '9471le (1/2 in x 60 yd)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.002427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127785 LIMIT 5 [ RunTime:0.003398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127785 ORDER BY `minOrder` ASC [ RunTime:0.006514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127785 ORDER BY `unit` DESC [ RunTime:0.005204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127785 LIMIT 2 [ RunTime:0.009853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127785 ORDER BY `minOrder` ASC [ RunTime:0.003355s ]
select * from pdf where partno='9478116002' and brandshort='fair-rite' limit 1 [ RunTime:0.011501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9478116002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.001404s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127785 AND `partno` = '9478116002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.011981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13380033 [ RunTime:0.002846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126445 LIMIT 5 [ RunTime:0.001674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126445 ORDER BY `minOrder` ASC [ RunTime:0.008795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126445 ORDER BY `unit` DESC [ RunTime:0.008722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126445 LIMIT 2 [ RunTime:0.010359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126445 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
select * from pdf where partno='9479222002' and brandshort='fair-rite' limit 1 [ RunTime:0.003360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9479222002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.005972s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126445 AND `partno` = '9479222002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.002394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113743 [ RunTime:0.002525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402708 [ RunTime:0.003582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113743 LIMIT 5 [ RunTime:0.006451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113743 ORDER BY `minOrder` ASC [ RunTime:0.021548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113743 ORDER BY `unit` DESC [ RunTime:0.001154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113743 LIMIT 2 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113743 ORDER BY `minOrder` ASC [ RunTime:0.008146s ]
select * from pdf where partno='9479222002' and brandshort='fair-rite' limit 1 [ RunTime:0.000387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9479222002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113743 AND `partno` = '9479222002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.009891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126445 [ RunTime:0.004040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402708 [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126584 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126584 ORDER BY `minOrder` ASC [ RunTime:0.001038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126584 ORDER BY `unit` DESC [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126584 LIMIT 2 [ RunTime:0.001985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126584 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='9479221002' and brandshort='fair-rite' limit 1 [ RunTime:0.001600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9479221002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.002629s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126584 AND `partno` = '9479221002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.007543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113986 [ RunTime:0.000659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13378250 [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113986 LIMIT 5 [ RunTime:0.009732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113986 ORDER BY `minOrder` ASC [ RunTime:0.002485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113986 ORDER BY `unit` DESC [ RunTime:0.002497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113986 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113986 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='9479221002' and brandshort='fair-rite' limit 1 [ RunTime:0.000427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9479221002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000345s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113986 AND `partno` = '9479221002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126584 [ RunTime:0.002793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13378250 [ RunTime:0.004023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126661 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126661 ORDER BY `minOrder` ASC [ RunTime:0.014150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126661 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126661 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126661 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='9479223002' and brandshort='fair-rite' limit 1 [ RunTime:0.009323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9479223002' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.008795s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126661 AND `partno` = '9479223002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.004998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64403406 [ RunTime:0.003477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098646 LIMIT 5 [ RunTime:0.005707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098646 ORDER BY `minOrder` ASC [ RunTime:0.005607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098646 ORDER BY `unit` DESC [ RunTime:0.007998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098646 LIMIT 2 [ RunTime:0.004961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098646 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='9472le' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.006972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9472le' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.004770s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098646 AND `partno` = '9472le' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.008607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212560 LIMIT 5 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212560 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212560 ORDER BY `unit` DESC [ RunTime:0.003218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212560 LIMIT 2 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212560 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
select * from pdf where partno='947705-010' and brandshort='grayhill' limit 1 [ RunTime:0.002562s ]
select foldpath,foldpath2,filename from pdf_file where id=2000398 limit 1 [ RunTime:0.000417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-010' OR `brand` LIKE 'grayhill%' ) ) LIMIT 1 [ RunTime:0.007151s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212560 AND `partno` = '947705-010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill%' ) [ RunTime:0.011491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17289851 [ RunTime:0.012029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32288041 LIMIT 5 [ RunTime:0.009236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288041 ORDER BY `minOrder` ASC [ RunTime:0.005370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32288041 ORDER BY `unit` DESC [ RunTime:0.003125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32288041 LIMIT 2 [ RunTime:0.006022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288041 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
select * from pdf where partno='9471le (50.8mm x 55m)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.001046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9471le (50.8mm x 55m)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.008729s ]
SELECT `id` FROM `stock` WHERE `id` <> 32288041 AND `partno` = '9471le (50.8mm x 55m)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.001990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098449 LIMIT 5 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098449 ORDER BY `minOrder` ASC [ RunTime:0.004777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098449 ORDER BY `unit` DESC [ RunTime:0.001603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098449 LIMIT 2 [ RunTime:0.001797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098449 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='9472le (2 in x 60 yd)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.000954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9472le (2 in x 60 yd)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.003886s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098449 AND `partno` = '9472le (2 in x 60 yd)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.006389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32288040 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288040 ORDER BY `minOrder` ASC [ RunTime:0.006422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32288040 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32288040 LIMIT 2 [ RunTime:0.002244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288040 ORDER BY `minOrder` ASC [ RunTime:0.001391s ]
select * from pdf where partno='9471le (1 in x 60 yd)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.003944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9471le (1 in x 60 yd)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.004843s ]
SELECT `id` FROM `stock` WHERE `id` <> 32288040 AND `partno` = '9471le (1 in x 60 yd)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.002882s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644019 LIMIT 5 [ RunTime:0.009957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644019 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644019 ORDER BY `unit` DESC [ RunTime:0.002006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644019 LIMIT 2 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644019 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='94727' and brandshort='3M' limit 1 [ RunTime:0.002336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94727' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003103s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644019 AND `partno` = '94727' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.014028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512337 [ RunTime:0.002726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644371 LIMIT 5 [ RunTime:0.001711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644371 ORDER BY `minOrder` ASC [ RunTime:0.001776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644371 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644371 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644371 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='94729' and brandshort='3M' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94729' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005088s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644371 AND `partno` = '94729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513909 [ RunTime:0.009702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348067 LIMIT 5 [ RunTime:0.002703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348067 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348067 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348067 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348067 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
select * from pdf where partno='94785' and brandshort='3M' limit 1 [ RunTime:0.000704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94785' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002820s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348067 AND `partno` = '94785' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.009870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583125 [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348068 LIMIT 5 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348068 ORDER BY `minOrder` ASC [ RunTime:0.002197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348068 ORDER BY `unit` DESC [ RunTime:0.003576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348068 LIMIT 2 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348068 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
select * from pdf where partno='94788' and brandshort='3M' limit 1 [ RunTime:0.000587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94788' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004127s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348068 AND `partno` = '94788' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583126 [ RunTime:0.005920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348419 LIMIT 5 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348419 ORDER BY `minOrder` ASC [ RunTime:0.002585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348419 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348419 LIMIT 2 [ RunTime:0.002388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348419 ORDER BY `minOrder` ASC [ RunTime:0.002439s ]
select * from pdf where partno='94789-A' and brandshort='3M' limit 1 [ RunTime:0.011145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94789-A' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.006532s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348419 AND `partno` = '94789-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.013694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441662 [ RunTime:0.004161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639762 LIMIT 5 [ RunTime:0.008285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639762 ORDER BY `minOrder` ASC [ RunTime:0.012171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639762 ORDER BY `unit` DESC [ RunTime:0.002316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639762 LIMIT 2 [ RunTime:0.004053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639762 ORDER BY `minOrder` ASC [ RunTime:0.005039s ]
select * from pdf where partno='94799' and brandshort='3M' limit 1 [ RunTime:0.015403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94799' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.009292s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639762 AND `partno` = '94799' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.021071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417602 [ RunTime:0.013046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644380 LIMIT 5 [ RunTime:0.002048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644380 ORDER BY `minOrder` ASC [ RunTime:0.003710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644380 ORDER BY `unit` DESC [ RunTime:0.002085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644380 LIMIT 2 [ RunTime:0.000976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644380 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='94717' and brandshort='3M' limit 1 [ RunTime:0.003296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94717' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005081s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644380 AND `partno` = '94717' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.004197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512338 [ RunTime:0.018400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644381 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644381 ORDER BY `minOrder` ASC [ RunTime:0.017801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644381 ORDER BY `unit` DESC [ RunTime:0.000827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644381 LIMIT 2 [ RunTime:0.001734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644381 ORDER BY `minOrder` ASC [ RunTime:0.002719s ]
select * from pdf where partno='94739' and brandshort='3M' limit 1 [ RunTime:0.008017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94739' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.007059s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644381 AND `partno` = '94739' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.005389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514418 [ RunTime:0.000755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644484 LIMIT 5 [ RunTime:0.006676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644484 ORDER BY `minOrder` ASC [ RunTime:0.018577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644484 ORDER BY `unit` DESC [ RunTime:0.008856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644484 LIMIT 2 [ RunTime:0.007739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644484 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='94719' and brandshort='3M' limit 1 [ RunTime:0.001346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94719' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.021191s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644484 AND `partno` = '94719' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416042 [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644382 LIMIT 5 [ RunTime:0.004505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644382 ORDER BY `minOrder` ASC [ RunTime:0.006653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644382 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644382 LIMIT 2 [ RunTime:0.004937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644382 ORDER BY `minOrder` ASC [ RunTime:0.004375s ]
select * from pdf where partno='94725' and brandshort='3M' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94725' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.008666s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644382 AND `partno` = '94725' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.002802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348218 LIMIT 5 [ RunTime:0.003938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348218 ORDER BY `minOrder` ASC [ RunTime:0.015573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348218 ORDER BY `unit` DESC [ RunTime:0.003237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348218 LIMIT 2 [ RunTime:0.007172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348218 ORDER BY `minOrder` ASC [ RunTime:0.005813s ]
select * from pdf where partno='94791' and brandshort='3M' limit 1 [ RunTime:0.001062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94791' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.006449s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348218 AND `partno` = '94791' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584063 [ RunTime:0.009859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644589 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644589 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644589 ORDER BY `unit` DESC [ RunTime:0.007167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644589 LIMIT 2 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644589 ORDER BY `minOrder` ASC [ RunTime:0.005954s ]
select * from pdf where partno='94745' and brandshort='3M' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94745' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003082s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644589 AND `partno` = '94745' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58340788 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58340788 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58340788 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58340788 LIMIT 2 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58340788 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='947705-001' and brandshort='Grayhill Inc.' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '947705-001' OR `brand` LIKE 'Grayhill Inc.%' ) ) LIMIT 1 [ RunTime:0.001268s ]
SELECT `id` FROM `stock` WHERE `id` <> 58340788 AND `partno` = '947705-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%grayhill inc.%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531445 [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644591 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644591 ORDER BY `minOrder` ASC [ RunTime:0.004253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644591 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644591 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644591 ORDER BY `minOrder` ASC [ RunTime:0.004044s ]
select * from pdf where partno='94749' and brandshort='3M' limit 1 [ RunTime:0.009801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94749' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.008962s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644591 AND `partno` = '94749' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12515509 [ RunTime:0.002248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348276 LIMIT 5 [ RunTime:0.022620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348276 ORDER BY `minOrder` ASC [ RunTime:0.022917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348276 ORDER BY `unit` DESC [ RunTime:0.001806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348276 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348276 ORDER BY `minOrder` ASC [ RunTime:0.011153s ]
select * from pdf where partno='94790' and brandshort='3M' limit 1 [ RunTime:0.011648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94790' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.006116s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348276 AND `partno` = '94790' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.004073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441356 [ RunTime:0.002297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644593 LIMIT 5 [ RunTime:0.006613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644593 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644593 ORDER BY `unit` DESC [ RunTime:0.001218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644593 LIMIT 2 [ RunTime:0.016157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644593 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
select * from pdf where partno='94743' and brandshort='3M' limit 1 [ RunTime:0.023635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94743' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.020849s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644593 AND `partno` = '94743' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.005916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12515507 [ RunTime:0.016575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644564 LIMIT 5 [ RunTime:0.006723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644564 ORDER BY `minOrder` ASC [ RunTime:0.005929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644564 ORDER BY `unit` DESC [ RunTime:0.001423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644564 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644564 ORDER BY `minOrder` ASC [ RunTime:0.002740s ]
select * from pdf where partno='94751' and brandshort='3M' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94751' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.015571s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644564 AND `partno` = '94751' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.003211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514983 [ RunTime:0.012117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644386 LIMIT 5 [ RunTime:0.003928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644386 ORDER BY `minOrder` ASC [ RunTime:0.011547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644386 ORDER BY `unit` DESC [ RunTime:0.009168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644386 LIMIT 2 [ RunTime:0.003405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644386 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='94736' and brandshort='3M' limit 1 [ RunTime:0.005214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94736' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004678s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644386 AND `partno` = '94736' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.008493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514419 [ RunTime:0.004917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644575 LIMIT 5 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644575 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644575 ORDER BY `unit` DESC [ RunTime:0.004497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644575 LIMIT 2 [ RunTime:0.013297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644575 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
select * from pdf where partno='94753' and brandshort='3M' limit 1 [ RunTime:0.005686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94753' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004899s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644575 AND `partno` = '94753' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416075 [ RunTime:0.003677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402450 LIMIT 5 [ RunTime:0.001901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402450 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402450 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402450 LIMIT 2 [ RunTime:0.002802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402450 ORDER BY `minOrder` ASC [ RunTime:0.004020s ]
select * from pdf where partno='9478103002' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9478103002' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002500s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402450 AND `partno` = '9478103002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260688 [ RunTime:0.000485s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002990s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002387s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001000s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000642s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009727s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003160s ]
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 '947%' OR `brand` LIKE '947%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009337s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '947%' OR `brand` LIKE '947%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003171s ]