SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001150s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030141s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419503 LIMIT 5 [ RunTime:0.001082s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419503 ORDER BY `minOrder` ASC [ RunTime:0.006189s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16419503 ORDER BY `unit` DESC [ RunTime:0.005130s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16419503 LIMIT 2 [ RunTime:0.005499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419503 ORDER BY `minOrder` ASC [ RunTime:0.001297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514407 LIMIT 5 [ RunTime:0.000773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514407 ORDER BY `minOrder` ASC [ RunTime:0.008756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514407 ORDER BY `unit` DESC [ RunTime:0.015223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514407 LIMIT 2 [ RunTime:0.012041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514407 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522912 LIMIT 5 [ RunTime:0.022007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522912 ORDER BY `minOrder` ASC [ RunTime:0.015088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522912 ORDER BY `unit` DESC [ RunTime:0.007299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522912 LIMIT 2 [ RunTime:0.023840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522912 ORDER BY `minOrder` ASC [ RunTime:0.004075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514345 LIMIT 5 [ RunTime:0.014462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514345 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514345 ORDER BY `unit` DESC [ RunTime:0.004202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514345 LIMIT 2 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514345 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983388 LIMIT 5 [ RunTime:0.007057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983388 ORDER BY `minOrder` ASC [ RunTime:0.010381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18983388 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18983388 LIMIT 2 [ RunTime:0.008310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983388 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266747 LIMIT 5 [ RunTime:0.001102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266747 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266747 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266747 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266747 ORDER BY `minOrder` ASC [ RunTime:0.001271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200698 LIMIT 5 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200698 ORDER BY `minOrder` ASC [ RunTime:0.001574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200698 ORDER BY `unit` DESC [ RunTime:0.002963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200698 LIMIT 2 [ RunTime:0.004492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200698 ORDER BY `minOrder` ASC [ RunTime:0.003164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19529410 LIMIT 5 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529410 ORDER BY `minOrder` ASC [ RunTime:0.009046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19529410 ORDER BY `unit` DESC [ RunTime:0.000569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19529410 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529410 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19271057 LIMIT 5 [ RunTime:0.006566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19271057 ORDER BY `minOrder` ASC [ RunTime:0.003460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19271057 ORDER BY `unit` DESC [ RunTime:0.009145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19271057 LIMIT 2 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19271057 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788453 LIMIT 5 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788453 ORDER BY `minOrder` ASC [ RunTime:0.002732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788453 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788453 LIMIT 2 [ RunTime:0.001951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788453 ORDER BY `minOrder` ASC [ RunTime:0.002495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15431623 LIMIT 5 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15431623 ORDER BY `minOrder` ASC [ RunTime:0.007445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15431623 ORDER BY `unit` DESC [ RunTime:0.001803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15431623 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15431623 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14701272 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14701272 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14701272 ORDER BY `unit` DESC [ RunTime:0.008004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14701272 LIMIT 2 [ RunTime:0.001442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14701272 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199585 LIMIT 5 [ RunTime:0.000757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199585 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12199585 ORDER BY `unit` DESC [ RunTime:0.008955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12199585 LIMIT 2 [ RunTime:0.003741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199585 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190313 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190313 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190313 ORDER BY `unit` DESC [ RunTime:0.004930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190313 LIMIT 2 [ RunTime:0.004236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190313 ORDER BY `minOrder` ASC [ RunTime:0.003598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11208213 LIMIT 5 [ RunTime:0.001606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11208213 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11208213 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11208213 LIMIT 2 [ RunTime:0.003970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11208213 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19529535 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529535 ORDER BY `minOrder` ASC [ RunTime:0.002117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19529535 ORDER BY `unit` DESC [ RunTime:0.003257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19529535 LIMIT 2 [ RunTime:0.003836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529535 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19529534 LIMIT 5 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529534 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19529534 ORDER BY `unit` DESC [ RunTime:0.007715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19529534 LIMIT 2 [ RunTime:0.005048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19529534 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983391 LIMIT 5 [ RunTime:0.007235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983391 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18983391 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18983391 LIMIT 2 [ RunTime:0.002107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983391 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18795785 LIMIT 5 [ RunTime:0.041094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18795785 ORDER BY `minOrder` ASC [ RunTime:0.021105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18795785 ORDER BY `unit` DESC [ RunTime:0.013470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18795785 LIMIT 2 [ RunTime:0.008946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18795785 ORDER BY `minOrder` ASC [ RunTime:0.004742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792154 LIMIT 5 [ RunTime:0.003949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792154 ORDER BY `minOrder` ASC [ RunTime:0.007446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792154 ORDER BY `unit` DESC [ RunTime:0.011221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792154 LIMIT 2 [ RunTime:0.015676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792154 ORDER BY `minOrder` ASC [ RunTime:0.006795s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137929 LIMIT 5 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137929 ORDER BY `minOrder` ASC [ RunTime:0.004240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137929 ORDER BY `unit` DESC [ RunTime:0.002839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137929 LIMIT 2 [ RunTime:0.003444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137929 ORDER BY `minOrder` ASC [ RunTime:0.002035s ]
select * from pdf where partno='6036c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.004599s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.004186s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137929 AND `partno` = '6036c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514407 [ RunTime:0.000547s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109053 LIMIT 5 [ RunTime:0.004042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109053 ORDER BY `minOrder` ASC [ RunTime:0.014911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109053 ORDER BY `unit` DESC [ RunTime:0.008642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109053 LIMIT 2 [ RunTime:0.003813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109053 ORDER BY `minOrder` ASC [ RunTime:0.013199s ]
select * from pdf where partno='6036230001' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036230001' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.001503s ]
SELECT `id` FROM `stock` WHERE `id` <> 63109053 AND `partno` = '6036230001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419503 [ RunTime:0.002368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63503882 LIMIT 5 [ RunTime:0.004655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503882 ORDER BY `minOrder` ASC [ RunTime:0.003339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63503882 ORDER BY `unit` DESC [ RunTime:0.002340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63503882 LIMIT 2 [ RunTime:0.005916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503882 ORDER BY `minOrder` ASC [ RunTime:0.003096s ]
select * from pdf where partno='6036' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009639s ]
SELECT `id` FROM `stock` WHERE `id` <> 63503882 AND `partno` = '6036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.011451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13899589 [ RunTime:0.011621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62933216 LIMIT 5 [ RunTime:0.010299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62933216 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62933216 ORDER BY `unit` DESC [ RunTime:0.000569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62933216 LIMIT 2 [ RunTime:0.002605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62933216 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='6036' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.004330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.005862s ]
SELECT `id` FROM `stock` WHERE `id` <> 62933216 AND `partno` = '6036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.001071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522912 [ RunTime:0.003775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63006983 LIMIT 5 [ RunTime:0.008536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006983 ORDER BY `minOrder` ASC [ RunTime:0.007974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63006983 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63006983 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006983 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='6036C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001287s ]
SELECT `id` FROM `stock` WHERE `id` <> 63006983 AND `partno` = '6036C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514407 [ RunTime:0.009247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64609840 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64609840 ORDER BY `minOrder` ASC [ RunTime:0.009633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64609840 ORDER BY `unit` DESC [ RunTime:0.003553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64609840 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64609840 ORDER BY `minOrder` ASC [ RunTime:0.007406s ]
select * from pdf where partno='6036492' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036492' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000592s ]
SELECT `id` FROM `stock` WHERE `id` <> 64609840 AND `partno` = '6036492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19529534 [ RunTime:0.007965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64609754 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64609754 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64609754 ORDER BY `unit` DESC [ RunTime:0.001873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64609754 LIMIT 2 [ RunTime:0.004487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64609754 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='6036148' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036148' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64609754 AND `partno` = '6036148' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19529410 [ RunTime:0.002586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64784659 LIMIT 5 [ RunTime:0.003971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784659 ORDER BY `minOrder` ASC [ RunTime:0.003001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64784659 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64784659 LIMIT 2 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784659 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='6036918' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036918' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002501s ]
SELECT `id` FROM `stock` WHERE `id` <> 64784659 AND `partno` = '6036918' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18795785 [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810992 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810992 ORDER BY `minOrder` ASC [ RunTime:0.001777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810992 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810992 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810992 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='6036723' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036723' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004937s ]
SELECT `id` FROM `stock` WHERE `id` <> 64810992 AND `partno` = '6036723' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983388 [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000424 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000424 ORDER BY `minOrder` ASC [ RunTime:0.009723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000424 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000424 LIMIT 2 [ RunTime:0.011460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000424 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='6036C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005445s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000424 AND `partno` = '6036C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514345 [ RunTime:0.008637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810937 LIMIT 5 [ RunTime:0.006462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810937 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810937 ORDER BY `unit` DESC [ RunTime:0.005523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810937 LIMIT 2 [ RunTime:0.002398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810937 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='6036722' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036722' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002073s ]
SELECT `id` FROM `stock` WHERE `id` <> 64810937 AND `partno` = '6036722' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266747 [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785400 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785400 ORDER BY `minOrder` ASC [ RunTime:0.003837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785400 ORDER BY `unit` DESC [ RunTime:0.010595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785400 LIMIT 2 [ RunTime:0.002341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785400 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='6036922' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036922' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005594s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785400 AND `partno` = '6036922' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788453 [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64115406 LIMIT 5 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115406 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64115406 ORDER BY `unit` DESC [ RunTime:0.001047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64115406 LIMIT 2 [ RunTime:0.008787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115406 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='6036646' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036646' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT `id` FROM `stock` WHERE `id` <> 64115406 AND `partno` = '6036646' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199613 [ RunTime:0.003612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64115405 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115405 ORDER BY `minOrder` ASC [ RunTime:0.002055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64115405 ORDER BY `unit` DESC [ RunTime:0.001547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64115405 LIMIT 2 [ RunTime:0.002560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115405 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
select * from pdf where partno='6036597' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036597' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005520s ]
SELECT `id` FROM `stock` WHERE `id` <> 64115405 AND `partno` = '6036597' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11208213 [ RunTime:0.008779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63274864 LIMIT 5 [ RunTime:0.002389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63274864 ORDER BY `minOrder` ASC [ RunTime:0.001787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63274864 ORDER BY `unit` DESC [ RunTime:0.003557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63274864 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63274864 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='6036366' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036366' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008201s ]
SELECT `id` FROM `stock` WHERE `id` <> 63274864 AND `partno` = '6036366' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270315 [ RunTime:0.003657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63274863 LIMIT 5 [ RunTime:0.004616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63274863 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63274863 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63274863 LIMIT 2 [ RunTime:0.006803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63274863 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
select * from pdf where partno='6036351' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036351' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001929s ]
SELECT `id` FROM `stock` WHERE `id` <> 63274863 AND `partno` = '6036351' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19271057 [ RunTime:0.008223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62450788 LIMIT 5 [ RunTime:0.001803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62450788 ORDER BY `minOrder` ASC [ RunTime:0.001711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62450788 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62450788 LIMIT 2 [ RunTime:0.006916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62450788 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
select * from pdf where partno='6036106' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036106' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001051s ]
SELECT `id` FROM `stock` WHERE `id` <> 62450788 AND `partno` = '6036106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14701272 [ RunTime:0.003411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513798 LIMIT 5 [ RunTime:0.001929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513798 ORDER BY `minOrder` ASC [ RunTime:0.001064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513798 ORDER BY `unit` DESC [ RunTime:0.010615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513798 LIMIT 2 [ RunTime:0.010683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513798 ORDER BY `minOrder` ASC [ RunTime:0.001582s ]
select * from pdf where partno='60368' and brandshort='Wiha' limit 1 [ RunTime:0.007977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60368' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.019538s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513798 AND `partno` = '60368' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.013884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811008 LIMIT 5 [ RunTime:0.002500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811008 ORDER BY `minOrder` ASC [ RunTime:0.002164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811008 ORDER BY `unit` DESC [ RunTime:0.002100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811008 LIMIT 2 [ RunTime:0.009188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811008 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='6036724' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036724' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017132s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811008 AND `partno` = '6036724' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983391 [ RunTime:0.014642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786608 LIMIT 5 [ RunTime:0.009139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786608 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786608 ORDER BY `unit` DESC [ RunTime:0.001205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786608 LIMIT 2 [ RunTime:0.012397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786608 ORDER BY `minOrder` ASC [ RunTime:0.003481s ]
select * from pdf where partno='6036924' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036924' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004605s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786608 AND `partno` = '6036924' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792154 [ RunTime:0.015956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786607 LIMIT 5 [ RunTime:0.005362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786607 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786607 ORDER BY `unit` DESC [ RunTime:0.013850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786607 LIMIT 2 [ RunTime:0.011047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786607 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
select * from pdf where partno='6036916' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6036916' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001052s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786607 AND `partno` = '6036916' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792153 [ RunTime:0.003481s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006123s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010168s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005387s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019392s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007087s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006055s ]
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 '6036%' OR `brand` LIKE '6036%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015470s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6036%' OR `brand` LIKE '6036%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022046s ]