SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007188s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.665182s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611711 LIMIT 5 [ RunTime:0.001580s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611711 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611711 ORDER BY `unit` DESC [ RunTime:0.001970s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611711 LIMIT 2 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611711 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
select * from pdf where partno='M80-0130005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.011999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611712 LIMIT 5 [ RunTime:0.004327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611712 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611712 ORDER BY `unit` DESC [ RunTime:0.001056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611712 LIMIT 2 [ RunTime:0.021609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611712 ORDER BY `minOrder` ASC [ RunTime:0.010809s ]
select * from pdf where partno='M80-0110005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.002620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483269 LIMIT 5 [ RunTime:0.004857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483269 ORDER BY `minOrder` ASC [ RunTime:0.009849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483269 ORDER BY `unit` DESC [ RunTime:0.007370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483269 LIMIT 2 [ RunTime:0.007451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483269 ORDER BY `minOrder` ASC [ RunTime:0.007248s ]
select * from pdf where partno='M80-0190005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484728 LIMIT 5 [ RunTime:0.014890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484728 ORDER BY `minOrder` ASC [ RunTime:0.010743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484728 ORDER BY `unit` DESC [ RunTime:0.007297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484728 LIMIT 2 [ RunTime:0.007373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484728 ORDER BY `minOrder` ASC [ RunTime:0.007356s ]
select * from pdf where partno='M80-0030006' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612244 LIMIT 5 [ RunTime:0.007869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612244 ORDER BY `minOrder` ASC [ RunTime:0.005278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612244 ORDER BY `unit` DESC [ RunTime:0.003533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612244 LIMIT 2 [ RunTime:0.001709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612244 ORDER BY `minOrder` ASC [ RunTime:0.003174s ]
select * from pdf where partno='M80-2060005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.003268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483746 LIMIT 5 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483746 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483746 ORDER BY `unit` DESC [ RunTime:0.003570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483746 LIMIT 2 [ RunTime:0.002011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483746 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
select * from pdf where partno='M80-023' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615510 LIMIT 5 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615510 ORDER BY `minOrder` ASC [ RunTime:0.001471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615510 ORDER BY `unit` DESC [ RunTime:0.001214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615510 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615510 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='M80-8880405' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.005555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794748 LIMIT 5 [ RunTime:0.004548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794748 ORDER BY `minOrder` ASC [ RunTime:0.003549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794748 ORDER BY `unit` DESC [ RunTime:0.001623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794748 LIMIT 2 [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794748 ORDER BY `minOrder` ASC [ RunTime:0.006082s ]
select * from pdf where partno='M80-8980205' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.002527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626614 LIMIT 5 [ RunTime:0.010922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626614 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12626614 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12626614 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626614 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='M80-1010298S' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.000982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13491 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13491 ORDER BY `minOrder` ASC [ RunTime:0.002662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13491 ORDER BY `unit` DESC [ RunTime:0.000880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13491 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13491 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-0130005' OR `brand` LIKE 'HARWIN%' ) ) LIMIT 1 [ RunTime:0.001250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19258798 LIMIT 5 [ RunTime:0.001763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19258798 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19258798 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19258798 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19258798 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774044 LIMIT 5 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774044 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774044 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774044 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774044 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
select * from pdf where partno='M80-8820442' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11485064 LIMIT 5 [ RunTime:0.003941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11485064 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11485064 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11485064 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11485064 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='M80-2270000B' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.002166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774060 LIMIT 5 [ RunTime:0.003234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774060 ORDER BY `minOrder` ASC [ RunTime:0.000993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774060 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774060 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774060 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
select * from pdf where partno='M80-8420442' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.004926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609641 LIMIT 5 [ RunTime:0.016712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609641 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609641 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609641 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609641 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='M80-0130001' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11485070 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11485070 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11485070 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11485070 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11485070 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='M80-2260000B' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774086 LIMIT 5 [ RunTime:0.001626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774086 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774086 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774086 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774086 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='M80-8670822' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.004090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628671 LIMIT 5 [ RunTime:0.004481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628671 ORDER BY `minOrder` ASC [ RunTime:0.000886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628671 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628671 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628671 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='M80-1031898S' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.000980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483279 LIMIT 5 [ RunTime:0.002177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483279 ORDER BY `minOrder` ASC [ RunTime:0.010831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483279 ORDER BY `unit` DESC [ RunTime:0.007384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483279 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483279 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='M80-1950005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19789565 LIMIT 5 [ RunTime:0.005929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19789565 ORDER BY `minOrder` ASC [ RunTime:0.000942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19789565 ORDER BY `unit` DESC [ RunTime:0.001090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19789565 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19789565 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='M80-5401042' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.002172s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071307 LIMIT 5 [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071307 ORDER BY `minOrder` ASC [ RunTime:0.003944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071307 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071307 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071307 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
select * from pdf where partno='m80-2130000b' and brandshort='harwin' limit 1 [ RunTime:0.000913s ]
select foldpath,foldpath2,filename from pdf_file where id=2137523 limit 1 [ RunTime:0.000575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-2130000b' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071366 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071366 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071366 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071366 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071366 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='m80-2430000b' and brandshort='harwin' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-2430000b' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071306 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071306 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071306 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071306 LIMIT 2 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071306 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
select * from pdf where partno='m80-2260000b' and brandshort='harwin' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-2260000b' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275835 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275835 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275835 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275835 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275835 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
select * from pdf where partno='m80-8130405' and brandshort='harwin' limit 1 [ RunTime:0.001976s ]
select foldpath,foldpath2,filename from pdf_file where id=2023786 limit 1 [ RunTime:0.000984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-8130405' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.001933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277177 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277177 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277177 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277177 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277177 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='m80-001' and brandshort='harwin' limit 1 [ RunTime:0.001911s ]
select foldpath,foldpath2,filename from pdf_file where id=2141955 limit 1 [ RunTime:0.016356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-001' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.003360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276741 LIMIT 5 [ RunTime:0.001466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276741 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276741 ORDER BY `unit` DESC [ RunTime:0.001279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276741 LIMIT 2 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276741 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
select * from pdf where partno='m80-1032698s' and brandshort='harwin' limit 1 [ RunTime:0.000979s ]
select foldpath,foldpath2,filename from pdf_file where id=2178632 limit 1 [ RunTime:0.022601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-1032698s' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.010381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32262895 LIMIT 5 [ RunTime:0.010887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262895 ORDER BY `minOrder` ASC [ RunTime:0.005651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32262895 ORDER BY `unit` DESC [ RunTime:0.004503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32262895 LIMIT 2 [ RunTime:0.005444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262895 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
select * from pdf where partno='m80-5620805' and brandshort='harwin' limit 1 [ RunTime:0.004466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-5620805' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.003013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263658 LIMIT 5 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263658 ORDER BY `minOrder` ASC [ RunTime:0.005133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263658 ORDER BY `unit` DESC [ RunTime:0.000996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263658 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263658 ORDER BY `minOrder` ASC [ RunTime:0.001094s ]
select * from pdf where partno='m80-8970205' and brandshort='harwin' limit 1 [ RunTime:0.001375s ]
select foldpath,foldpath2,filename from pdf_file where id=1002164 limit 1 [ RunTime:0.002015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-8970205' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.001565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071451 LIMIT 5 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071451 ORDER BY `minOrder` ASC [ RunTime:0.001383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071451 ORDER BY `unit` DESC [ RunTime:0.010463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071451 LIMIT 2 [ RunTime:0.007511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071451 ORDER BY `minOrder` ASC [ RunTime:0.007525s ]
select * from pdf where partno='m80-2270000b' and brandshort='harwin' limit 1 [ RunTime:0.009878s ]
select foldpath,foldpath2,filename from pdf_file where id=2137522 limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-2270000b' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275736 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275736 ORDER BY `minOrder` ASC [ RunTime:0.002191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275736 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275736 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275736 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='m80-5120442' and brandshort='harwin' limit 1 [ RunTime:0.001011s ]
select foldpath,foldpath2,filename from pdf_file where id=2020209 limit 1 [ RunTime:0.000561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-5120442' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275647 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275647 ORDER BY `minOrder` ASC [ RunTime:0.002104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275647 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275647 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275647 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='m80-4811042' and brandshort='harwin' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-4811042' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277385 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277385 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277385 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277385 LIMIT 2 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277385 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='m80-6661442' and brandshort='harwin' limit 1 [ RunTime:0.003318s ]
select foldpath,foldpath2,filename from pdf_file where id=2175400 limit 1 [ RunTime:0.001932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-6661442' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.001141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277384 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277384 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277384 ORDER BY `unit` DESC [ RunTime:0.002935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277384 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277384 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
select * from pdf where partno='m80-6660842' and brandshort='harwin' limit 1 [ RunTime:0.001095s ]
select foldpath,foldpath2,filename from pdf_file where id=2175400 limit 1 [ RunTime:0.000383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-6660842' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276952 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276952 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276952 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276952 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276952 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
select * from pdf where partno='m80-8420445' and brandshort='harwin' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-8420445' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.001171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275747 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275747 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275747 ORDER BY `unit` DESC [ RunTime:0.001285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275747 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275747 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
select * from pdf where partno='m80-4611442' and brandshort='harwin' limit 1 [ RunTime:0.000934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-4611442' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275834 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275834 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275834 ORDER BY `unit` DESC [ RunTime:0.000608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275834 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275834 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
select * from pdf where partno='m80-4600842' and brandshort='harwin' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-4600842' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276744 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276744 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276744 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276744 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276744 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
select * from pdf where partno='m80-8770405' and brandshort='harwin' limit 1 [ RunTime:0.000977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-8770405' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276743 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276743 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276743 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276743 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276743 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
select * from pdf where partno='m80-7710442' and brandshort='harwin' limit 1 [ RunTime:0.001448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-7710442' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277387 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277387 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277387 ORDER BY `unit` DESC [ RunTime:0.004756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277387 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277387 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
select * from pdf where partno='m80-7530442' and brandshort='harwin' limit 1 [ RunTime:0.000768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-7530442' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277388 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277388 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277388 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277388 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277388 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='m80-7531242' and brandshort='harwin' limit 1 [ RunTime:0.000772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm80-7531242' OR `brand` LIKE 'harwin%' ) ) LIMIT 1 [ RunTime:0.000894s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.428682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154638 LIMIT 5 [ RunTime:0.001431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154638 ORDER BY `minOrder` ASC [ RunTime:0.007637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154638 ORDER BY `unit` DESC [ RunTime:0.001182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154638 LIMIT 2 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154638 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
select * from pdf where partno='M80-0130005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-0130005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001762s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154638 AND `partno` = 'M80-0130005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.007514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611711 [ RunTime:0.010932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67173169 LIMIT 5 [ RunTime:0.007383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67173169 ORDER BY `minOrder` ASC [ RunTime:0.006498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67173169 ORDER BY `unit` DESC [ RunTime:0.011146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67173169 LIMIT 2 [ RunTime:0.007625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67173169 ORDER BY `minOrder` ASC [ RunTime:0.010951s ]
select * from pdf where partno='M80-2130000B' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-2130000B' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001339s ]
SELECT `id` FROM `stock` WHERE `id` <> 67173169 AND `partno` = 'M80-2130000B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154711 LIMIT 5 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154711 ORDER BY `minOrder` ASC [ RunTime:0.004633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154711 ORDER BY `unit` DESC [ RunTime:0.007568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154711 LIMIT 2 [ RunTime:0.011132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154711 ORDER BY `minOrder` ASC [ RunTime:0.011050s ]
select * from pdf where partno='M80-0190005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.005214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-0190005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001203s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154711 AND `partno` = 'M80-0190005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483269 [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66744202 LIMIT 5 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66744202 ORDER BY `minOrder` ASC [ RunTime:0.028276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66744202 ORDER BY `unit` DESC [ RunTime:0.011089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66744202 LIMIT 2 [ RunTime:0.010976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66744202 ORDER BY `minOrder` ASC [ RunTime:0.010947s ]
select * from pdf where partno='M80-1010298S' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-1010298S' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.010773s ]
SELECT `id` FROM `stock` WHERE `id` <> 66744202 AND `partno` = 'M80-1010298S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.010791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626614 [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67156200 LIMIT 5 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67156200 ORDER BY `minOrder` ASC [ RunTime:0.015874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67156200 ORDER BY `unit` DESC [ RunTime:0.001158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67156200 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67156200 ORDER BY `minOrder` ASC [ RunTime:0.001115s ]
select * from pdf where partno='M80-0410005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-0410005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001057s ]
SELECT `id` FROM `stock` WHERE `id` <> 67156200 AND `partno` = 'M80-0410005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67173059 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67173059 ORDER BY `minOrder` ASC [ RunTime:0.014689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67173059 ORDER BY `unit` DESC [ RunTime:0.007675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67173059 LIMIT 2 [ RunTime:0.011082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67173059 ORDER BY `minOrder` ASC [ RunTime:0.011029s ]
select * from pdf where partno='M80-2270000B' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-2270000B' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.007979s ]
SELECT `id` FROM `stock` WHERE `id` <> 67173059 AND `partno` = 'M80-2270000B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11485064 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711725 LIMIT 5 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711725 ORDER BY `minOrder` ASC [ RunTime:0.006885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711725 ORDER BY `unit` DESC [ RunTime:0.007505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711725 LIMIT 2 [ RunTime:0.011041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711725 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
select * from pdf where partno='M80-8980205' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.007984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8980205' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.010610s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711725 AND `partno` = 'M80-8980205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.010904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794748 [ RunTime:0.043078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154640 LIMIT 5 [ RunTime:0.010784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154640 ORDER BY `minOrder` ASC [ RunTime:0.001142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154640 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154640 LIMIT 2 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154640 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
select * from pdf where partno='M80-0110001' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-0110001' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001204s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154640 AND `partno` = 'M80-0110001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482924 [ RunTime:0.005665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70382408 LIMIT 5 [ RunTime:0.008604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70382408 ORDER BY `minOrder` ASC [ RunTime:0.010991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70382408 ORDER BY `unit` DESC [ RunTime:0.010273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70382408 LIMIT 2 [ RunTime:0.011089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70382408 ORDER BY `minOrder` ASC [ RunTime:0.011062s ]
select * from pdf where partno='M8000LFXI' and brandshort='Cypress Semiconductor Corp' limit 1 [ RunTime:0.014980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M8000LFXI' OR `brand` LIKE 'Cypress Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.010329s ]
SELECT `id` FROM `stock` WHERE `id` <> 70382408 AND `partno` = 'M8000LFXI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cypress semiconductor corp%' ) [ RunTime:0.010733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19258798 [ RunTime:0.010927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243534 LIMIT 5 [ RunTime:0.001444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243534 ORDER BY `minOrder` ASC [ RunTime:0.006259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243534 ORDER BY `unit` DESC [ RunTime:0.013329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243534 LIMIT 2 [ RunTime:0.010998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243534 ORDER BY `minOrder` ASC [ RunTime:0.011038s ]
select * from pdf where partno='M80-5000000M1-02-331-00-000' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.013894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-5000000M1-02-331-00-000' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.007886s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243534 AND `partno` = 'M80-5000000M1-02-331-00-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19789555 [ RunTime:0.001100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711816 LIMIT 5 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711816 ORDER BY `minOrder` ASC [ RunTime:0.006414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711816 ORDER BY `unit` DESC [ RunTime:0.011002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711816 LIMIT 2 [ RunTime:0.007591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711816 ORDER BY `minOrder` ASC [ RunTime:0.011208s ]
select * from pdf where partno='M80-8880805' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8880805' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001240s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711816 AND `partno` = 'M80-8880805' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.006318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800192 [ RunTime:0.015040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243363 LIMIT 5 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243363 ORDER BY `minOrder` ASC [ RunTime:0.004403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243363 ORDER BY `unit` DESC [ RunTime:0.003536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243363 LIMIT 2 [ RunTime:0.003054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243363 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
select * from pdf where partno='M80-6660842' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.005390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-6660842' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.003037s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243363 AND `partno` = 'M80-6660842' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.014265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191206 [ RunTime:0.010780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154771 LIMIT 5 [ RunTime:0.010498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154771 ORDER BY `minOrder` ASC [ RunTime:0.010820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154771 ORDER BY `unit` DESC [ RunTime:0.010774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154771 LIMIT 2 [ RunTime:0.011050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154771 ORDER BY `minOrder` ASC [ RunTime:0.009783s ]
select * from pdf where partno='M80-325' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.004293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-325' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001345s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154771 AND `partno` = 'M80-325' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243116 LIMIT 5 [ RunTime:0.000964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243116 ORDER BY `minOrder` ASC [ RunTime:0.001879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243116 ORDER BY `unit` DESC [ RunTime:0.001399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243116 LIMIT 2 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243116 ORDER BY `minOrder` ASC [ RunTime:0.001707s ]
select * from pdf where partno='M80-8820442' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.002293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8820442' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.002432s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243116 AND `partno` = 'M80-8820442' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774044 [ RunTime:0.001458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154733 LIMIT 5 [ RunTime:0.001089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154733 ORDER BY `minOrder` ASC [ RunTime:0.001149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154733 ORDER BY `unit` DESC [ RunTime:0.001055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154733 LIMIT 2 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154733 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
select * from pdf where partno='M80-2060005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-2060005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001251s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154733 AND `partno` = 'M80-2060005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612244 [ RunTime:0.000967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66248875 LIMIT 5 [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66248875 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66248875 ORDER BY `unit` DESC [ RunTime:0.001170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66248875 LIMIT 2 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66248875 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
select * from pdf where partno='M80-8420442' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8420442' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.013774s ]
SELECT `id` FROM `stock` WHERE `id` <> 66248875 AND `partno` = 'M80-8420442' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.004247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774060 [ RunTime:0.006116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154746 LIMIT 5 [ RunTime:0.001020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154746 ORDER BY `minOrder` ASC [ RunTime:0.001305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154746 ORDER BY `unit` DESC [ RunTime:0.000896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154746 LIMIT 2 [ RunTime:0.001333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154746 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
select * from pdf where partno='M80-1940005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-1940005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001167s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154746 AND `partno` = 'M80-1940005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482265 [ RunTime:0.002423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243061 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243061 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243061 ORDER BY `unit` DESC [ RunTime:0.000885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243061 LIMIT 2 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243061 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
select * from pdf where partno='M80-8820642' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.001399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8820642' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001131s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243061 AND `partno` = 'M80-8820642' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16230216 [ RunTime:0.021024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243157 LIMIT 5 [ RunTime:0.010483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243157 ORDER BY `minOrder` ASC [ RunTime:0.006278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243157 ORDER BY `unit` DESC [ RunTime:0.001055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243157 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243157 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
select * from pdf where partno='M80-8530642' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.006327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8530642' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.001296s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243157 AND `partno` = 'M80-8530642' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478161 [ RunTime:0.011609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711828 LIMIT 5 [ RunTime:0.007770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711828 ORDER BY `minOrder` ASC [ RunTime:0.001374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711828 ORDER BY `unit` DESC [ RunTime:0.001075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711828 LIMIT 2 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711828 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
select * from pdf where partno='M80-8881005' and brandshort='Harwin Inc.' limit 1 [ RunTime:0.006992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-8881005' OR `brand` LIKE 'Harwin Inc.%' ) ) LIMIT 1 [ RunTime:0.010582s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711828 AND `partno` = 'M80-8881005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harwin inc.%' ) [ RunTime:0.010843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615534 [ RunTime:0.010815s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008307s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009302s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009429s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013305s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011287s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009493s ]
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 'M80%' OR `brand` LIKE 'M80%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008055s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M80%' OR `brand` LIKE 'M80%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.202239s ]