SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001522s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=60605&search=1' [ RunTime:0.008418s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003284s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007589s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002571s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.003504s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001939s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001995s ]
SELECT * FROM `stock_search` WHERE `partno` = '60605' LIMIT 1 [ RunTime:0.006732s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:11' WHERE `partno` = '60605' [ RunTime:0.005718s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002423s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012013s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417508 LIMIT 5 [ RunTime:0.086714s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.036860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417508 ORDER BY `minOrder` ASC [ RunTime:0.027661s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417508 ORDER BY `unit` DESC [ RunTime:0.050305s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417508 LIMIT 2 [ RunTime:0.039565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417508 ORDER BY `minOrder` ASC [ RunTime:0.049338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179608 LIMIT 5 [ RunTime:0.031249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179608 ORDER BY `minOrder` ASC [ RunTime:0.074164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11179608 ORDER BY `unit` DESC [ RunTime:0.050109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11179608 LIMIT 2 [ RunTime:0.054241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179608 ORDER BY `minOrder` ASC [ RunTime:0.064450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820727 LIMIT 5 [ RunTime:0.045815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820727 ORDER BY `minOrder` ASC [ RunTime:0.009925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18820727 ORDER BY `unit` DESC [ RunTime:0.026323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18820727 LIMIT 2 [ RunTime:0.035596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820727 ORDER BY `minOrder` ASC [ RunTime:0.046581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819223 LIMIT 5 [ RunTime:0.058209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819223 ORDER BY `minOrder` ASC [ RunTime:0.030094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18819223 ORDER BY `unit` DESC [ RunTime:0.047207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18819223 LIMIT 2 [ RunTime:0.078183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819223 ORDER BY `minOrder` ASC [ RunTime:0.015159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818982 LIMIT 5 [ RunTime:0.056943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818982 ORDER BY `minOrder` ASC [ RunTime:0.006350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18818982 ORDER BY `unit` DESC [ RunTime:0.016383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18818982 LIMIT 2 [ RunTime:0.042621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818982 ORDER BY `minOrder` ASC [ RunTime:0.029044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816902 LIMIT 5 [ RunTime:0.059321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816902 ORDER BY `minOrder` ASC [ RunTime:0.078797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816902 ORDER BY `unit` DESC [ RunTime:0.052164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816902 LIMIT 2 [ RunTime:0.030699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816902 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777805 LIMIT 5 [ RunTime:0.032318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777805 ORDER BY `minOrder` ASC [ RunTime:0.005292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777805 ORDER BY `unit` DESC [ RunTime:0.008502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777805 LIMIT 2 [ RunTime:0.014018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777805 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777778 LIMIT 5 [ RunTime:0.024992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777778 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777778 ORDER BY `unit` DESC [ RunTime:0.002222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777778 LIMIT 2 [ RunTime:0.012027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777778 ORDER BY `minOrder` ASC [ RunTime:0.001696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777766 LIMIT 5 [ RunTime:0.012879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777766 ORDER BY `minOrder` ASC [ RunTime:0.002965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777766 ORDER BY `unit` DESC [ RunTime:0.010308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777766 LIMIT 2 [ RunTime:0.015095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777766 ORDER BY `minOrder` ASC [ RunTime:0.018434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777764 LIMIT 5 [ RunTime:0.013058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777764 ORDER BY `minOrder` ASC [ RunTime:0.009556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777764 ORDER BY `unit` DESC [ RunTime:0.027682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777764 LIMIT 2 [ RunTime:0.027075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777764 ORDER BY `minOrder` ASC [ RunTime:0.031444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777757 LIMIT 5 [ RunTime:0.025079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777757 ORDER BY `minOrder` ASC [ RunTime:0.013165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777757 ORDER BY `unit` DESC [ RunTime:0.009257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777757 LIMIT 2 [ RunTime:0.009300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777757 ORDER BY `minOrder` ASC [ RunTime:0.014205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777737 LIMIT 5 [ RunTime:0.026548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777737 ORDER BY `minOrder` ASC [ RunTime:0.023971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777737 ORDER BY `unit` DESC [ RunTime:0.010359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777737 LIMIT 2 [ RunTime:0.021053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777737 ORDER BY `minOrder` ASC [ RunTime:0.012142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777382 LIMIT 5 [ RunTime:0.011895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777382 ORDER BY `minOrder` ASC [ RunTime:0.002458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777382 ORDER BY `unit` DESC [ RunTime:0.013452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777382 LIMIT 2 [ RunTime:0.005558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777382 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777320 LIMIT 5 [ RunTime:0.004384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777320 ORDER BY `minOrder` ASC [ RunTime:0.020629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777320 ORDER BY `unit` DESC [ RunTime:0.008879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777320 LIMIT 2 [ RunTime:0.006591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777320 ORDER BY `minOrder` ASC [ RunTime:0.017582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777179 LIMIT 5 [ RunTime:0.010852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777179 ORDER BY `minOrder` ASC [ RunTime:0.007275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777179 ORDER BY `unit` DESC [ RunTime:0.012342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777179 LIMIT 2 [ RunTime:0.005472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777179 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777167 LIMIT 5 [ RunTime:0.015525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777167 ORDER BY `minOrder` ASC [ RunTime:0.007659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777167 ORDER BY `unit` DESC [ RunTime:0.002295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777167 LIMIT 2 [ RunTime:0.011819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777167 ORDER BY `minOrder` ASC [ RunTime:0.011198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777116 LIMIT 5 [ RunTime:0.020209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777116 ORDER BY `minOrder` ASC [ RunTime:0.007710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777116 ORDER BY `unit` DESC [ RunTime:0.001910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777116 LIMIT 2 [ RunTime:0.011374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777116 ORDER BY `minOrder` ASC [ RunTime:0.025409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776867 LIMIT 5 [ RunTime:0.017023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776867 ORDER BY `minOrder` ASC [ RunTime:0.046471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776867 ORDER BY `unit` DESC [ RunTime:0.018223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776867 LIMIT 2 [ RunTime:0.018395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776867 ORDER BY `minOrder` ASC [ RunTime:0.005239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017866 LIMIT 5 [ RunTime:0.020728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017866 ORDER BY `minOrder` ASC [ RunTime:0.007996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017866 ORDER BY `unit` DESC [ RunTime:0.015452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017866 LIMIT 2 [ RunTime:0.016360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017866 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011239 LIMIT 5 [ RunTime:0.021814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011239 ORDER BY `minOrder` ASC [ RunTime:0.008067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011239 ORDER BY `unit` DESC [ RunTime:0.026521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011239 LIMIT 2 [ RunTime:0.063277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011239 ORDER BY `minOrder` ASC [ RunTime:0.013274s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133107 LIMIT 5 [ RunTime:0.037455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133107 ORDER BY `minOrder` ASC [ RunTime:0.029867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133107 ORDER BY `unit` DESC [ RunTime:0.064172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133107 LIMIT 2 [ RunTime:0.024396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133107 ORDER BY `minOrder` ASC [ RunTime:0.009356s ]
select * from pdf where partno='606053' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.047605s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '606053' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.135383s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133107 AND `partno` = '606053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.022829s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51722660 LIMIT 5 [ RunTime:0.030828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722660 ORDER BY `minOrder` ASC [ RunTime:0.046123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51722660 ORDER BY `unit` DESC [ RunTime:0.036319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51722660 LIMIT 2 [ RunTime:0.066199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722660 ORDER BY `minOrder` ASC [ RunTime:0.015929s ]
select * from pdf where partno='60605' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.010777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60605' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.045713s ]
SELECT `id` FROM `stock` WHERE `id` <> 51722660 AND `partno` = '60605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.035882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179608 [ RunTime:0.014980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56454001 LIMIT 5 [ RunTime:0.019026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56454001 ORDER BY `minOrder` ASC [ RunTime:0.006750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56454001 ORDER BY `unit` DESC [ RunTime:0.009637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56454001 LIMIT 2 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56454001 ORDER BY `minOrder` ASC [ RunTime:0.033089s ]
select * from pdf where partno='6060584' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060584' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012634s ]
SELECT `id` FROM `stock` WHERE `id` <> 56454001 AND `partno` = '6060584' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266304 [ RunTime:0.082601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56453968 LIMIT 5 [ RunTime:0.037235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453968 ORDER BY `minOrder` ASC [ RunTime:0.116272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56453968 ORDER BY `unit` DESC [ RunTime:0.070139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56453968 LIMIT 2 [ RunTime:0.123710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453968 ORDER BY `minOrder` ASC [ RunTime:0.063422s ]
select * from pdf where partno='6060583' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060583' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035978s ]
SELECT `id` FROM `stock` WHERE `id` <> 56453968 AND `partno` = '6060583' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.051884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992441 [ RunTime:0.054867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56453816 LIMIT 5 [ RunTime:0.033932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453816 ORDER BY `minOrder` ASC [ RunTime:0.076810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56453816 ORDER BY `unit` DESC [ RunTime:0.046923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56453816 LIMIT 2 [ RunTime:0.041772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453816 ORDER BY `minOrder` ASC [ RunTime:0.016601s ]
select * from pdf where partno='6060582' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060582' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021294s ]
SELECT `id` FROM `stock` WHERE `id` <> 56453816 AND `partno` = '6060582' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56453651 LIMIT 5 [ RunTime:0.040540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453651 ORDER BY `minOrder` ASC [ RunTime:0.016430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56453651 ORDER BY `unit` DESC [ RunTime:0.024172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56453651 LIMIT 2 [ RunTime:0.024738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453651 ORDER BY `minOrder` ASC [ RunTime:0.019980s ]
select * from pdf where partno='6060578' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.071235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060578' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.090876s ]
SELECT `id` FROM `stock` WHERE `id` <> 56453651 AND `partno` = '6060578' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56453016 LIMIT 5 [ RunTime:0.013679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453016 ORDER BY `minOrder` ASC [ RunTime:0.009225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56453016 ORDER BY `unit` DESC [ RunTime:0.020403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56453016 LIMIT 2 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56453016 ORDER BY `minOrder` ASC [ RunTime:0.031764s ]
select * from pdf where partno='6060579' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.113126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060579' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035285s ]
SELECT `id` FROM `stock` WHERE `id` <> 56453016 AND `partno` = '6060579' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265942 [ RunTime:0.018762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53819136 LIMIT 5 [ RunTime:0.046697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819136 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53819136 ORDER BY `unit` DESC [ RunTime:0.008069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53819136 LIMIT 2 [ RunTime:0.043049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819136 ORDER BY `minOrder` ASC [ RunTime:0.012664s ]
select * from pdf where partno='60605-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60605-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.121947s ]
SELECT `id` FROM `stock` WHERE `id` <> 53819136 AND `partno` = '60605-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417508 [ RunTime:0.039830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51317325 LIMIT 5 [ RunTime:0.027576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317325 ORDER BY `minOrder` ASC [ RunTime:0.014018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51317325 ORDER BY `unit` DESC [ RunTime:0.011869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51317325 LIMIT 2 [ RunTime:0.008709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317325 ORDER BY `minOrder` ASC [ RunTime:0.021056s ]
select * from pdf where partno='60605' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.030743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60605' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.035210s ]
SELECT `id` FROM `stock` WHERE `id` <> 51317325 AND `partno` = '60605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.027940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51317324 LIMIT 5 [ RunTime:0.027182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317324 ORDER BY `minOrder` ASC [ RunTime:0.093389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51317324 ORDER BY `unit` DESC [ RunTime:0.050933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51317324 LIMIT 2 [ RunTime:0.051242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317324 ORDER BY `minOrder` ASC [ RunTime:0.033407s ]
select * from pdf where partno='60605R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.088632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60605R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.067671s ]
SELECT `id` FROM `stock` WHERE `id` <> 51317324 AND `partno` = '60605R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.036374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708049 [ RunTime:0.031623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51317010 LIMIT 5 [ RunTime:0.049690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317010 ORDER BY `minOrder` ASC [ RunTime:0.037421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51317010 ORDER BY `unit` DESC [ RunTime:0.037700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51317010 LIMIT 2 [ RunTime:0.024911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51317010 ORDER BY `minOrder` ASC [ RunTime:0.008465s ]
select * from pdf where partno='60605T' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.030601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60605T' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.098383s ]
SELECT `id` FROM `stock` WHERE `id` <> 51317010 AND `partno` = '60605T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.032540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14707911 [ RunTime:0.022736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50898502 LIMIT 5 [ RunTime:0.050155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50898502 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50898502 ORDER BY `unit` DESC [ RunTime:0.017059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50898502 LIMIT 2 [ RunTime:0.016867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50898502 ORDER BY `minOrder` ASC [ RunTime:0.016661s ]
select * from pdf where partno='6060563' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060563' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014516s ]
SELECT `id` FROM `stock` WHERE `id` <> 50898502 AND `partno` = '6060563' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820727 [ RunTime:0.005405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50895491 LIMIT 5 [ RunTime:0.014730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50895491 ORDER BY `minOrder` ASC [ RunTime:0.010243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50895491 ORDER BY `unit` DESC [ RunTime:0.007664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50895491 LIMIT 2 [ RunTime:0.007863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50895491 ORDER BY `minOrder` ASC [ RunTime:0.007460s ]
select * from pdf where partno='6060576' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060576' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021503s ]
SELECT `id` FROM `stock` WHERE `id` <> 50895491 AND `partno` = '6060576' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183084 [ RunTime:0.048313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50894905 LIMIT 5 [ RunTime:0.024282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50894905 ORDER BY `minOrder` ASC [ RunTime:0.028627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50894905 ORDER BY `unit` DESC [ RunTime:0.056250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50894905 LIMIT 2 [ RunTime:0.025458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50894905 ORDER BY `minOrder` ASC [ RunTime:0.011928s ]
select * from pdf where partno='6060577' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060577' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008962s ]
SELECT `id` FROM `stock` WHERE `id` <> 50894905 AND `partno` = '6060577' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232567 [ RunTime:0.013033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50892071 LIMIT 5 [ RunTime:0.034510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50892071 ORDER BY `minOrder` ASC [ RunTime:0.021529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50892071 ORDER BY `unit` DESC [ RunTime:0.019823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50892071 LIMIT 2 [ RunTime:0.044839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50892071 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
select * from pdf where partno='6060510' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060510' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012581s ]
SELECT `id` FROM `stock` WHERE `id` <> 50892071 AND `partno` = '6060510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182973 [ RunTime:0.025808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50891171 LIMIT 5 [ RunTime:0.021001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50891171 ORDER BY `minOrder` ASC [ RunTime:0.041560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50891171 ORDER BY `unit` DESC [ RunTime:0.033043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50891171 LIMIT 2 [ RunTime:0.036848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50891171 ORDER BY `minOrder` ASC [ RunTime:0.013172s ]
select * from pdf where partno='6060599' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.090487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060599' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007574s ]
SELECT `id` FROM `stock` WHERE `id` <> 50891171 AND `partno` = '6060599' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819223 [ RunTime:0.019767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50890528 LIMIT 5 [ RunTime:0.020400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50890528 ORDER BY `minOrder` ASC [ RunTime:0.011786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50890528 ORDER BY `unit` DESC [ RunTime:0.033840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50890528 LIMIT 2 [ RunTime:0.028429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50890528 ORDER BY `minOrder` ASC [ RunTime:0.026556s ]
select * from pdf where partno='6060598' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060598' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020215s ]
SELECT `id` FROM `stock` WHERE `id` <> 50890528 AND `partno` = '6060598' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818982 [ RunTime:0.010621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50889307 LIMIT 5 [ RunTime:0.037455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50889307 ORDER BY `minOrder` ASC [ RunTime:0.018088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50889307 ORDER BY `unit` DESC [ RunTime:0.038130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50889307 LIMIT 2 [ RunTime:0.042947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50889307 ORDER BY `minOrder` ASC [ RunTime:0.038744s ]
select * from pdf where partno='6060574' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060574' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.057510s ]
SELECT `id` FROM `stock` WHERE `id` <> 50889307 AND `partno` = '6060574' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017866 [ RunTime:0.029394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50888291 LIMIT 5 [ RunTime:0.017374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50888291 ORDER BY `minOrder` ASC [ RunTime:0.006258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50888291 ORDER BY `unit` DESC [ RunTime:0.008799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50888291 LIMIT 2 [ RunTime:0.006729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50888291 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
select * from pdf where partno='6060575' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060575' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.041042s ]
SELECT `id` FROM `stock` WHERE `id` <> 50888291 AND `partno` = '6060575' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182864 [ RunTime:0.008631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50886596 LIMIT 5 [ RunTime:0.039736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50886596 ORDER BY `minOrder` ASC [ RunTime:0.010700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50886596 ORDER BY `unit` DESC [ RunTime:0.018417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50886596 LIMIT 2 [ RunTime:0.076005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50886596 ORDER BY `minOrder` ASC [ RunTime:0.071745s ]
select * from pdf where partno='6060552' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060552' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025069s ]
SELECT `id` FROM `stock` WHERE `id` <> 50886596 AND `partno` = '6060552' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816902 [ RunTime:0.008306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50818790 LIMIT 5 [ RunTime:0.011555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50818790 ORDER BY `minOrder` ASC [ RunTime:0.005086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50818790 ORDER BY `unit` DESC [ RunTime:0.016317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50818790 LIMIT 2 [ RunTime:0.005050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50818790 ORDER BY `minOrder` ASC [ RunTime:0.017017s ]
select * from pdf where partno='6060559' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.054641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6060559' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.078612s ]
SELECT `id` FROM `stock` WHERE `id` <> 50818790 AND `partno` = '6060559' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.053960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777382 [ RunTime:0.047452s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081442s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008494s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013956s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023713s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028249s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012394s ]
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 '60605%' OR `brand` LIKE '60605%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036240s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60605%' OR `brand` LIKE '60605%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008243s ]