SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002376s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031933s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881292 LIMIT 5 [ RunTime:0.029405s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881292 ORDER BY `minOrder` ASC [ RunTime:0.011396s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881292 ORDER BY `unit` DESC [ RunTime:0.030675s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881292 LIMIT 2 [ RunTime:0.039295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881292 ORDER BY `minOrder` ASC [ RunTime:0.034979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882330 LIMIT 5 [ RunTime:0.033016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882330 ORDER BY `minOrder` ASC [ RunTime:0.053239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12882330 ORDER BY `unit` DESC [ RunTime:0.009997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12882330 LIMIT 2 [ RunTime:0.034191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882330 ORDER BY `minOrder` ASC [ RunTime:0.005207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683150 LIMIT 5 [ RunTime:0.027958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683150 ORDER BY `minOrder` ASC [ RunTime:0.018237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683150 ORDER BY `unit` DESC [ RunTime:0.007328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683150 LIMIT 2 [ RunTime:0.060742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683150 ORDER BY `minOrder` ASC [ RunTime:0.010847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160187 LIMIT 5 [ RunTime:0.053702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160187 ORDER BY `minOrder` ASC [ RunTime:0.007867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160187 ORDER BY `unit` DESC [ RunTime:0.006579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160187 LIMIT 2 [ RunTime:0.018470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160187 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683149 LIMIT 5 [ RunTime:0.033797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683149 ORDER BY `minOrder` ASC [ RunTime:0.015184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683149 ORDER BY `unit` DESC [ RunTime:0.015919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683149 LIMIT 2 [ RunTime:0.004370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683149 ORDER BY `minOrder` ASC [ RunTime:0.008521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793468 LIMIT 5 [ RunTime:0.005638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793468 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793468 ORDER BY `unit` DESC [ RunTime:0.011133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793468 LIMIT 2 [ RunTime:0.002414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793468 ORDER BY `minOrder` ASC [ RunTime:0.009484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849710 LIMIT 5 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849710 ORDER BY `minOrder` ASC [ RunTime:0.004857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18849710 ORDER BY `unit` DESC [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18849710 LIMIT 2 [ RunTime:0.004917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849710 ORDER BY `minOrder` ASC [ RunTime:0.007603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792141 LIMIT 5 [ RunTime:0.012326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792141 ORDER BY `minOrder` ASC [ RunTime:0.004428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792141 ORDER BY `unit` DESC [ RunTime:0.001574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792141 LIMIT 2 [ RunTime:0.013413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792141 ORDER BY `minOrder` ASC [ RunTime:0.002466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849755 LIMIT 5 [ RunTime:0.000924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849755 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18849755 ORDER BY `unit` DESC [ RunTime:0.000974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18849755 LIMIT 2 [ RunTime:0.003447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849755 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849741 LIMIT 5 [ RunTime:0.008382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849741 ORDER BY `minOrder` ASC [ RunTime:0.009812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18849741 ORDER BY `unit` DESC [ RunTime:0.009831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18849741 LIMIT 2 [ RunTime:0.020356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18849741 ORDER BY `minOrder` ASC [ RunTime:0.003657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790463 LIMIT 5 [ RunTime:0.006776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790463 ORDER BY `minOrder` ASC [ RunTime:0.034319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18790463 ORDER BY `unit` DESC [ RunTime:0.003652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18790463 LIMIT 2 [ RunTime:0.005408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790463 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790349 LIMIT 5 [ RunTime:0.026115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790349 ORDER BY `minOrder` ASC [ RunTime:0.022088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18790349 ORDER BY `unit` DESC [ RunTime:0.020710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18790349 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790349 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673137 LIMIT 5 [ RunTime:0.001690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673137 ORDER BY `minOrder` ASC [ RunTime:0.006376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673137 ORDER BY `unit` DESC [ RunTime:0.003566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673137 LIMIT 2 [ RunTime:0.006098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673137 ORDER BY `minOrder` ASC [ RunTime:0.002565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673081 LIMIT 5 [ RunTime:0.003103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673081 ORDER BY `minOrder` ASC [ RunTime:0.003565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673081 ORDER BY `unit` DESC [ RunTime:0.009616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673081 LIMIT 2 [ RunTime:0.011880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673081 ORDER BY `minOrder` ASC [ RunTime:0.002681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508287 LIMIT 5 [ RunTime:0.003282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508287 ORDER BY `minOrder` ASC [ RunTime:0.001378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14508287 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14508287 LIMIT 2 [ RunTime:0.010531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508287 ORDER BY `minOrder` ASC [ RunTime:0.005657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13636432 LIMIT 5 [ RunTime:0.005339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13636432 ORDER BY `minOrder` ASC [ RunTime:0.004195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13636432 ORDER BY `unit` DESC [ RunTime:0.004283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13636432 LIMIT 2 [ RunTime:0.006261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13636432 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294206 LIMIT 5 [ RunTime:0.001858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294206 ORDER BY `minOrder` ASC [ RunTime:0.016716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13294206 ORDER BY `unit` DESC [ RunTime:0.009784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13294206 LIMIT 2 [ RunTime:0.019212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294206 ORDER BY `minOrder` ASC [ RunTime:0.001676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13287309 LIMIT 5 [ RunTime:0.029218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287309 ORDER BY `minOrder` ASC [ RunTime:0.022572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13287309 ORDER BY `unit` DESC [ RunTime:0.009238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13287309 LIMIT 2 [ RunTime:0.029124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287309 ORDER BY `minOrder` ASC [ RunTime:0.001794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029958 LIMIT 5 [ RunTime:0.002565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029958 ORDER BY `minOrder` ASC [ RunTime:0.001462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029958 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029958 LIMIT 2 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029958 ORDER BY `minOrder` ASC [ RunTime:0.001665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029758 LIMIT 5 [ RunTime:0.011469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029758 ORDER BY `minOrder` ASC [ RunTime:0.022308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029758 ORDER BY `unit` DESC [ RunTime:0.015806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029758 LIMIT 2 [ RunTime:0.005510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029758 ORDER BY `minOrder` ASC [ RunTime:0.005975s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003149s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917199 LIMIT 5 [ RunTime:0.007868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917199 ORDER BY `minOrder` ASC [ RunTime:0.010930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917199 ORDER BY `unit` DESC [ RunTime:0.007102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917199 LIMIT 2 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917199 ORDER BY `minOrder` ASC [ RunTime:0.011807s ]
select * from pdf where partno='60346021210420' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017493s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346021210420' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.023238s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917199 AND `partno` = '60346021210420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881292 [ RunTime:0.014020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917200 LIMIT 5 [ RunTime:0.014512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917200 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917200 ORDER BY `unit` DESC [ RunTime:0.010374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917200 LIMIT 2 [ RunTime:0.000992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917200 ORDER BY `minOrder` ASC [ RunTime:0.003401s ]
select * from pdf where partno='60346020212320' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346020212320' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004332s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917200 AND `partno` = '60346020212320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.018375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683149 [ RunTime:0.001191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64784650 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784650 ORDER BY `minOrder` ASC [ RunTime:0.012993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64784650 ORDER BY `unit` DESC [ RunTime:0.035208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64784650 LIMIT 2 [ RunTime:0.015842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784650 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
select * from pdf where partno='6034667' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034667' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014739s ]
SELECT `id` FROM `stock` WHERE `id` <> 64784650 AND `partno` = '6034667' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793468 [ RunTime:0.002369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917201 LIMIT 5 [ RunTime:0.002749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917201 ORDER BY `minOrder` ASC [ RunTime:0.024214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917201 ORDER BY `unit` DESC [ RunTime:0.008507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917201 LIMIT 2 [ RunTime:0.010824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917201 ORDER BY `minOrder` ASC [ RunTime:0.003279s ]
select * from pdf where partno='60346020212220' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346020212220' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008023s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917201 AND `partno` = '60346020212220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882330 [ RunTime:0.012269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586399 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586399 ORDER BY `minOrder` ASC [ RunTime:0.003878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586399 ORDER BY `unit` DESC [ RunTime:0.014671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586399 LIMIT 2 [ RunTime:0.020982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586399 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
select * from pdf where partno='60346' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.013556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.011406s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586399 AND `partno` = '60346' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.027935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160187 [ RunTime:0.018665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64109322 LIMIT 5 [ RunTime:0.013641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109322 ORDER BY `minOrder` ASC [ RunTime:0.012808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64109322 ORDER BY `unit` DESC [ RunTime:0.003752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64109322 LIMIT 2 [ RunTime:0.021990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109322 ORDER BY `minOrder` ASC [ RunTime:0.008433s ]
select * from pdf where partno='6034645' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034645' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009475s ]
SELECT `id` FROM `stock` WHERE `id` <> 64109322 AND `partno` = '6034645' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849710 [ RunTime:0.012652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62143075 LIMIT 5 [ RunTime:0.013141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62143075 ORDER BY `minOrder` ASC [ RunTime:0.026161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62143075 ORDER BY `unit` DESC [ RunTime:0.036429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62143075 LIMIT 2 [ RunTime:0.002415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62143075 ORDER BY `minOrder` ASC [ RunTime:0.009978s ]
select * from pdf where partno='6034605' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034605' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015270s ]
SELECT `id` FROM `stock` WHERE `id` <> 62143075 AND `partno` = '6034605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673137 [ RunTime:0.007537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797162 LIMIT 5 [ RunTime:0.003568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797162 ORDER BY `minOrder` ASC [ RunTime:0.017323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797162 ORDER BY `unit` DESC [ RunTime:0.009469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797162 LIMIT 2 [ RunTime:0.003973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797162 ORDER BY `minOrder` ASC [ RunTime:0.006131s ]
select * from pdf where partno='6034670' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034670' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007380s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797162 AND `partno` = '6034670' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790463 [ RunTime:0.010249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64796989 LIMIT 5 [ RunTime:0.001118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796989 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64796989 ORDER BY `unit` DESC [ RunTime:0.002903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64796989 LIMIT 2 [ RunTime:0.013844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64796989 ORDER BY `minOrder` ASC [ RunTime:0.005002s ]
select * from pdf where partno='6034668' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034668' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000769s ]
SELECT `id` FROM `stock` WHERE `id` <> 64796989 AND `partno` = '6034668' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790349 [ RunTime:0.017231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786590 LIMIT 5 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786590 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786590 ORDER BY `unit` DESC [ RunTime:0.015620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786590 LIMIT 2 [ RunTime:0.003211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786590 ORDER BY `minOrder` ASC [ RunTime:0.003994s ]
select * from pdf where partno='6034669' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034669' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005337s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786590 AND `partno` = '6034669' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792141 [ RunTime:0.003242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64109401 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109401 ORDER BY `minOrder` ASC [ RunTime:0.013070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64109401 ORDER BY `unit` DESC [ RunTime:0.025427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64109401 LIMIT 2 [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109401 ORDER BY `minOrder` ASC [ RunTime:0.004404s ]
select * from pdf where partno='6034646' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034646' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012748s ]
SELECT `id` FROM `stock` WHERE `id` <> 64109401 AND `partno` = '6034646' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849755 [ RunTime:0.005935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64109368 LIMIT 5 [ RunTime:0.013793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109368 ORDER BY `minOrder` ASC [ RunTime:0.010782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64109368 ORDER BY `unit` DESC [ RunTime:0.008442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64109368 LIMIT 2 [ RunTime:0.029827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109368 ORDER BY `minOrder` ASC [ RunTime:0.013594s ]
select * from pdf where partno='6034647' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034647' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005326s ]
SELECT `id` FROM `stock` WHERE `id` <> 64109368 AND `partno` = '6034647' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18849741 [ RunTime:0.036072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62414994 LIMIT 5 [ RunTime:0.010711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62414994 ORDER BY `minOrder` ASC [ RunTime:0.011210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62414994 ORDER BY `unit` DESC [ RunTime:0.025632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62414994 LIMIT 2 [ RunTime:0.023004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62414994 ORDER BY `minOrder` ASC [ RunTime:0.013956s ]
select * from pdf where partno='6034635' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.038099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034635' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018285s ]
SELECT `id` FROM `stock` WHERE `id` <> 62414994 AND `partno` = '6034635' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.038956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13636432 [ RunTime:0.053008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62414399 LIMIT 5 [ RunTime:0.035559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62414399 ORDER BY `minOrder` ASC [ RunTime:0.051650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62414399 ORDER BY `unit` DESC [ RunTime:0.012211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62414399 LIMIT 2 [ RunTime:0.008877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62414399 ORDER BY `minOrder` ASC [ RunTime:0.056876s ]
select * from pdf where partno='6034636' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034636' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.065750s ]
SELECT `id` FROM `stock` WHERE `id` <> 62414399 AND `partno` = '6034636' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.077702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508287 [ RunTime:0.051786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917202 LIMIT 5 [ RunTime:0.071775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917202 ORDER BY `minOrder` ASC [ RunTime:0.091568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917202 ORDER BY `unit` DESC [ RunTime:0.073054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917202 LIMIT 2 [ RunTime:0.075522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917202 ORDER BY `minOrder` ASC [ RunTime:0.023582s ]
select * from pdf where partno='60346020212120' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.039641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346020212120' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.035497s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917202 AND `partno` = '60346020212120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.048074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683150 [ RunTime:0.059376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32762860 LIMIT 5 [ RunTime:0.045846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32762860 ORDER BY `minOrder` ASC [ RunTime:0.087218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32762860 ORDER BY `unit` DESC [ RunTime:0.195340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32762860 LIMIT 2 [ RunTime:0.033501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32762860 ORDER BY `minOrder` ASC [ RunTime:0.069949s ]
select * from pdf where partno='6034673' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.077246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034673' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.114021s ]
SELECT `id` FROM `stock` WHERE `id` <> 32762860 AND `partno` = '6034673' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029758 [ RunTime:0.075199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32658427 LIMIT 5 [ RunTime:0.088992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658427 ORDER BY `minOrder` ASC [ RunTime:0.188789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32658427 ORDER BY `unit` DESC [ RunTime:0.107345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32658427 LIMIT 2 [ RunTime:0.083901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658427 ORDER BY `minOrder` ASC [ RunTime:0.013710s ]
select * from pdf where partno='6034640' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034640' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.063324s ]
SELECT `id` FROM `stock` WHERE `id` <> 32658427 AND `partno` = '6034640' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294206 [ RunTime:0.050694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32610036 LIMIT 5 [ RunTime:0.052296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32610036 ORDER BY `minOrder` ASC [ RunTime:0.045783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32610036 ORDER BY `unit` DESC [ RunTime:0.039246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32610036 LIMIT 2 [ RunTime:0.076636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32610036 ORDER BY `minOrder` ASC [ RunTime:0.019636s ]
select * from pdf where partno='6034672' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034672' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034799s ]
SELECT `id` FROM `stock` WHERE `id` <> 32610036 AND `partno` = '6034672' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023947 [ RunTime:0.039833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32493471 LIMIT 5 [ RunTime:0.045468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32493471 ORDER BY `minOrder` ASC [ RunTime:0.034928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32493471 ORDER BY `unit` DESC [ RunTime:0.027419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32493471 LIMIT 2 [ RunTime:0.017417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32493471 ORDER BY `minOrder` ASC [ RunTime:0.027278s ]
select * from pdf where partno='6034652' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034652' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015391s ]
SELECT `id` FROM `stock` WHERE `id` <> 32493471 AND `partno` = '6034652' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12019153 [ RunTime:0.047616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32463982 LIMIT 5 [ RunTime:0.046189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32463982 ORDER BY `minOrder` ASC [ RunTime:0.058635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32463982 ORDER BY `unit` DESC [ RunTime:0.026603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32463982 LIMIT 2 [ RunTime:0.037562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32463982 ORDER BY `minOrder` ASC [ RunTime:0.015385s ]
select * from pdf where partno='6034671' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034671' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.046203s ]
SELECT `id` FROM `stock` WHERE `id` <> 32463982 AND `partno` = '6034671' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13287309 [ RunTime:0.063234s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032477s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046505s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039554s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030719s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025673s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032454s ]
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 '60346%' OR `brand` LIKE '60346%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015251s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60346%' OR `brand` LIKE '60346%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017379s ]