SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001767s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048116s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13888624 LIMIT 5 [ RunTime:0.039575s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13888624 ORDER BY `minOrder` ASC [ RunTime:0.004939s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13888624 ORDER BY `unit` DESC [ RunTime:0.013448s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.037311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13888624 LIMIT 2 [ RunTime:0.024026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13888624 ORDER BY `minOrder` ASC [ RunTime:0.009556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15213376 LIMIT 5 [ RunTime:0.017441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213376 ORDER BY `minOrder` ASC [ RunTime:0.045968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15213376 ORDER BY `unit` DESC [ RunTime:0.037506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15213376 LIMIT 2 [ RunTime:0.011721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15213376 ORDER BY `minOrder` ASC [ RunTime:0.015860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884457 LIMIT 5 [ RunTime:0.032307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884457 ORDER BY `minOrder` ASC [ RunTime:0.062869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12884457 ORDER BY `unit` DESC [ RunTime:0.017121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12884457 LIMIT 2 [ RunTime:0.071766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884457 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18798311 LIMIT 5 [ RunTime:0.079098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798311 ORDER BY `minOrder` ASC [ RunTime:0.057973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18798311 ORDER BY `unit` DESC [ RunTime:0.019536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18798311 LIMIT 2 [ RunTime:0.049835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798311 ORDER BY `minOrder` ASC [ RunTime:0.044796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750894 LIMIT 5 [ RunTime:0.018310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750894 ORDER BY `minOrder` ASC [ RunTime:0.017872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750894 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750894 LIMIT 2 [ RunTime:0.026584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750894 ORDER BY `minOrder` ASC [ RunTime:0.023928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734469 LIMIT 5 [ RunTime:0.014650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734469 ORDER BY `minOrder` ASC [ RunTime:0.014527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734469 ORDER BY `unit` DESC [ RunTime:0.044614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734469 LIMIT 2 [ RunTime:0.054511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734469 ORDER BY `minOrder` ASC [ RunTime:0.008778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734468 LIMIT 5 [ RunTime:0.071809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734468 ORDER BY `minOrder` ASC [ RunTime:0.036653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734468 ORDER BY `unit` DESC [ RunTime:0.010312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734468 LIMIT 2 [ RunTime:0.042151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734468 ORDER BY `minOrder` ASC [ RunTime:0.028148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734467 LIMIT 5 [ RunTime:0.013988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734467 ORDER BY `minOrder` ASC [ RunTime:0.068299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734467 ORDER BY `unit` DESC [ RunTime:0.045227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734467 LIMIT 2 [ RunTime:0.029843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734467 ORDER BY `minOrder` ASC [ RunTime:0.025072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18732501 LIMIT 5 [ RunTime:0.046982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18732501 ORDER BY `minOrder` ASC [ RunTime:0.032823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18732501 ORDER BY `unit` DESC [ RunTime:0.018385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18732501 LIMIT 2 [ RunTime:0.013441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18732501 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731552 LIMIT 5 [ RunTime:0.008074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731552 ORDER BY `minOrder` ASC [ RunTime:0.009299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731552 ORDER BY `unit` DESC [ RunTime:0.032253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731552 LIMIT 2 [ RunTime:0.006034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731552 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003756 LIMIT 5 [ RunTime:0.010501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003756 ORDER BY `minOrder` ASC [ RunTime:0.004043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003756 ORDER BY `unit` DESC [ RunTime:0.013992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003756 LIMIT 2 [ RunTime:0.005745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003756 ORDER BY `minOrder` ASC [ RunTime:0.009513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003755 LIMIT 5 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003755 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003755 ORDER BY `unit` DESC [ RunTime:0.007130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003755 LIMIT 2 [ RunTime:0.019403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003755 ORDER BY `minOrder` ASC [ RunTime:0.011150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15228716 LIMIT 5 [ RunTime:0.002609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228716 ORDER BY `minOrder` ASC [ RunTime:0.009769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15228716 ORDER BY `unit` DESC [ RunTime:0.011947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15228716 LIMIT 2 [ RunTime:0.032904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15228716 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15220925 LIMIT 5 [ RunTime:0.019741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220925 ORDER BY `minOrder` ASC [ RunTime:0.014618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15220925 ORDER BY `unit` DESC [ RunTime:0.004995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15220925 LIMIT 2 [ RunTime:0.007993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220925 ORDER BY `minOrder` ASC [ RunTime:0.001700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218215 LIMIT 5 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218215 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218215 ORDER BY `unit` DESC [ RunTime:0.018801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218215 LIMIT 2 [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218215 ORDER BY `minOrder` ASC [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216537 LIMIT 5 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216537 ORDER BY `minOrder` ASC [ RunTime:0.009507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216537 ORDER BY `unit` DESC [ RunTime:0.010991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216537 LIMIT 2 [ RunTime:0.010807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216537 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216046 LIMIT 5 [ RunTime:0.017185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216046 ORDER BY `minOrder` ASC [ RunTime:0.022007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216046 ORDER BY `unit` DESC [ RunTime:0.015076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216046 LIMIT 2 [ RunTime:0.013051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216046 ORDER BY `minOrder` ASC [ RunTime:0.005324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424715 LIMIT 5 [ RunTime:0.016171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424715 ORDER BY `minOrder` ASC [ RunTime:0.046663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424715 ORDER BY `unit` DESC [ RunTime:0.056681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424715 LIMIT 2 [ RunTime:0.042695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424715 ORDER BY `minOrder` ASC [ RunTime:0.030273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345547 LIMIT 5 [ RunTime:0.013123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345547 ORDER BY `minOrder` ASC [ RunTime:0.043394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345547 ORDER BY `unit` DESC [ RunTime:0.038664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345547 LIMIT 2 [ RunTime:0.014137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345547 ORDER BY `minOrder` ASC [ RunTime:0.022495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175439 LIMIT 5 [ RunTime:0.038521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175439 ORDER BY `minOrder` ASC [ RunTime:0.014032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14175439 ORDER BY `unit` DESC [ RunTime:0.028743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14175439 LIMIT 2 [ RunTime:0.011497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175439 ORDER BY `minOrder` ASC [ RunTime:0.020336s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047415s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37686713 LIMIT 5 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37686713 ORDER BY `minOrder` ASC [ RunTime:0.018365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37686713 ORDER BY `unit` DESC [ RunTime:0.002280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37686713 LIMIT 2 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37686713 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
select * from pdf where partno='4092' and brandshort='Pololu' limit 1 [ RunTime:0.028048s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.012592s ]
SELECT `id` FROM `stock` WHERE `id` <> 37686713 AND `partno` = '4092' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.010065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13888624 [ RunTime:0.025213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50489293 LIMIT 5 [ RunTime:0.021340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50489293 ORDER BY `minOrder` ASC [ RunTime:0.007570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50489293 ORDER BY `unit` DESC [ RunTime:0.010815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50489293 LIMIT 2 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50489293 ORDER BY `minOrder` ASC [ RunTime:0.006657s ]
select * from pdf where partno='4092' and brandshort='Pololu' limit 1 [ RunTime:0.014097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.002480s ]
SELECT `id` FROM `stock` WHERE `id` <> 50489293 AND `partno` = '4092' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.016740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13888624 [ RunTime:0.007239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52531269 LIMIT 5 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52531269 ORDER BY `minOrder` ASC [ RunTime:0.004032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52531269 ORDER BY `unit` DESC [ RunTime:0.002566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52531269 LIMIT 2 [ RunTime:0.044964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52531269 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
select * from pdf where partno='4092' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.031496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.019993s ]
SELECT `id` FROM `stock` WHERE `id` <> 52531269 AND `partno` = '4092' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884457 [ RunTime:0.003757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44007282 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007282 ORDER BY `minOrder` ASC [ RunTime:0.006834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44007282 ORDER BY `unit` DESC [ RunTime:0.017054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44007282 LIMIT 2 [ RunTime:0.002543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007282 ORDER BY `minOrder` ASC [ RunTime:0.003616s ]
select * from pdf where partno='409284-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '409284-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000658s ]
SELECT `id` FROM `stock` WHERE `id` <> 44007282 AND `partno` = '409284-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.011985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15213376 [ RunTime:0.017020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713714 LIMIT 5 [ RunTime:0.011327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713714 ORDER BY `minOrder` ASC [ RunTime:0.010422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713714 ORDER BY `unit` DESC [ RunTime:0.004090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713714 LIMIT 2 [ RunTime:0.020057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713714 ORDER BY `minOrder` ASC [ RunTime:0.020472s ]
select * from pdf where partno='40928' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40928' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010621s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713714 AND `partno` = '40928' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557177 [ RunTime:0.012615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713701 LIMIT 5 [ RunTime:0.006590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713701 ORDER BY `minOrder` ASC [ RunTime:0.017833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713701 ORDER BY `unit` DESC [ RunTime:0.028067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713701 LIMIT 2 [ RunTime:0.006305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713701 ORDER BY `minOrder` ASC [ RunTime:0.005454s ]
select * from pdf where partno='40920' and brandshort='Brady Corporation' limit 1 [ RunTime:0.024946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40920' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015878s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713701 AND `partno` = '40920' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557170 [ RunTime:0.015507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713666 LIMIT 5 [ RunTime:0.018020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713666 ORDER BY `minOrder` ASC [ RunTime:0.032075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713666 ORDER BY `unit` DESC [ RunTime:0.015190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713666 LIMIT 2 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713666 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='40924' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40924' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001837s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713666 AND `partno` = '40924' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557149 [ RunTime:0.003411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713654 LIMIT 5 [ RunTime:0.007830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713654 ORDER BY `minOrder` ASC [ RunTime:0.012112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713654 ORDER BY `unit` DESC [ RunTime:0.001360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713654 LIMIT 2 [ RunTime:0.004360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713654 ORDER BY `minOrder` ASC [ RunTime:0.004966s ]
select * from pdf where partno='40926' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40926' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001972s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713654 AND `partno` = '40926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557143 [ RunTime:0.005540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50711251 LIMIT 5 [ RunTime:0.005307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711251 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50711251 ORDER BY `unit` DESC [ RunTime:0.003342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50711251 LIMIT 2 [ RunTime:0.001519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711251 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='40923' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40923' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009216s ]
SELECT `id` FROM `stock` WHERE `id` <> 50711251 AND `partno` = '40923' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555770 [ RunTime:0.009095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50711213 LIMIT 5 [ RunTime:0.003265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711213 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50711213 ORDER BY `unit` DESC [ RunTime:0.001626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50711213 LIMIT 2 [ RunTime:0.003376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711213 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
select * from pdf where partno='40927' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40927' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001868s ]
SELECT `id` FROM `stock` WHERE `id` <> 50711213 AND `partno` = '40927' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424715 [ RunTime:0.001674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50711185 LIMIT 5 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711185 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50711185 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50711185 LIMIT 2 [ RunTime:0.002800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711185 ORDER BY `minOrder` ASC [ RunTime:0.005124s ]
select * from pdf where partno='40925' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40925' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003653s ]
SELECT `id` FROM `stock` WHERE `id` <> 50711185 AND `partno` = '40925' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555736 [ RunTime:0.005964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50702712 LIMIT 5 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702712 ORDER BY `minOrder` ASC [ RunTime:0.003529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50702712 ORDER BY `unit` DESC [ RunTime:0.003852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50702712 LIMIT 2 [ RunTime:0.001703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702712 ORDER BY `minOrder` ASC [ RunTime:0.001341s ]
select * from pdf where partno='4092-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001475s ]
SELECT `id` FROM `stock` WHERE `id` <> 50702712 AND `partno` = '4092-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458029 [ RunTime:0.001801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50702423 LIMIT 5 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702423 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50702423 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50702423 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702423 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
select * from pdf where partno='4092-G' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-G' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005067s ]
SELECT `id` FROM `stock` WHERE `id` <> 50702423 AND `partno` = '4092-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457845 [ RunTime:0.002138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50702278 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702278 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50702278 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50702278 LIMIT 2 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702278 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='4092-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000716s ]
SELECT `id` FROM `stock` WHERE `id` <> 50702278 AND `partno` = '4092-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457675 [ RunTime:0.003130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50702031 LIMIT 5 [ RunTime:0.006388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702031 ORDER BY `minOrder` ASC [ RunTime:0.006953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50702031 ORDER BY `unit` DESC [ RunTime:0.008733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50702031 LIMIT 2 [ RunTime:0.002958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50702031 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='4092-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016421s ]
SELECT `id` FROM `stock` WHERE `id` <> 50702031 AND `partno` = '4092-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457678 [ RunTime:0.010894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50701889 LIMIT 5 [ RunTime:0.006359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701889 ORDER BY `minOrder` ASC [ RunTime:0.004716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50701889 ORDER BY `unit` DESC [ RunTime:0.001015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50701889 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701889 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='4092-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001967s ]
SELECT `id` FROM `stock` WHERE `id` <> 50701889 AND `partno` = '4092-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345547 [ RunTime:0.001881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50701614 LIMIT 5 [ RunTime:0.003384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701614 ORDER BY `minOrder` ASC [ RunTime:0.001982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50701614 ORDER BY `unit` DESC [ RunTime:0.003807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50701614 LIMIT 2 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701614 ORDER BY `minOrder` ASC [ RunTime:0.002748s ]
select * from pdf where partno='4092-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000966s ]
SELECT `id` FROM `stock` WHERE `id` <> 50701614 AND `partno` = '4092-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459686 [ RunTime:0.001125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50701485 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701485 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50701485 ORDER BY `unit` DESC [ RunTime:0.001216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50701485 LIMIT 2 [ RunTime:0.004663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50701485 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='4092-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005224s ]
SELECT `id` FROM `stock` WHERE `id` <> 50701485 AND `partno` = '4092-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459510 [ RunTime:0.006746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50478421 LIMIT 5 [ RunTime:0.002934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478421 ORDER BY `minOrder` ASC [ RunTime:0.014763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50478421 ORDER BY `unit` DESC [ RunTime:0.004035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50478421 LIMIT 2 [ RunTime:0.012321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478421 ORDER BY `minOrder` ASC [ RunTime:0.002322s ]
select * from pdf where partno='4092 RED 36"X50YD' and brandshort='3M' limit 1 [ RunTime:0.001113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092 RED 36\"X50YD' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004757s ]
SELECT `id` FROM `stock` WHERE `id` <> 50478421 AND `partno` = '4092 RED 36\"X50YD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12264208 [ RunTime:0.011383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50478260 LIMIT 5 [ RunTime:0.010045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478260 ORDER BY `minOrder` ASC [ RunTime:0.012532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50478260 ORDER BY `unit` DESC [ RunTime:0.003336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50478260 LIMIT 2 [ RunTime:0.002591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478260 ORDER BY `minOrder` ASC [ RunTime:0.005921s ]
select * from pdf where partno='4092 RED 24"X50YD' and brandshort='3M' limit 1 [ RunTime:0.003417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4092 RED 24\"X50YD' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004168s ]
SELECT `id` FROM `stock` WHERE `id` <> 50478260 AND `partno` = '4092 RED 24\"X50YD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12264125 [ RunTime:0.002654s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001390s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022687s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003044s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004020s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005167s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001362s ]
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 '4092%' OR `brand` LIKE '4092%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007265s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4092%' OR `brand` LIKE '4092%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006983s ]