SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002433s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=85241&search=1' [ RunTime:0.002869s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002133s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002479s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002292s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002462s ]
SELECT * FROM `stock_search` WHERE `partno` = '85241' LIMIT 1 [ RunTime:0.001443s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-09 03:44:46' WHERE `partno` = '85241' [ RunTime:0.009475s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002564s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007810s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584030 LIMIT 5 [ RunTime:0.001275s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584030 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16584030 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16584030 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584030 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14388338 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388338 ORDER BY `minOrder` ASC [ RunTime:0.003010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14388338 ORDER BY `unit` DESC [ RunTime:0.001044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14388338 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388338 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
select * from pdf where partno='852410CY BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515769 LIMIT 5 [ RunTime:0.002381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515769 ORDER BY `minOrder` ASC [ RunTime:0.006587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515769 ORDER BY `unit` DESC [ RunTime:0.003737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515769 LIMIT 2 [ RunTime:0.001548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515769 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='852410CY BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752568 LIMIT 5 [ RunTime:0.001292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752568 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752568 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752568 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752568 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752546 LIMIT 5 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752546 ORDER BY `minOrder` ASC [ RunTime:0.011363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752546 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752546 LIMIT 2 [ RunTime:0.004643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752546 ORDER BY `minOrder` ASC [ RunTime:0.002088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714397 LIMIT 5 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714397 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18714397 ORDER BY `unit` DESC [ RunTime:0.004453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18714397 LIMIT 2 [ RunTime:0.007122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714397 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
select * from pdf where partno='852410' and brandshort='3M' limit 1 [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16994150 LIMIT 5 [ RunTime:0.005436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16994150 ORDER BY `minOrder` ASC [ RunTime:0.005276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16994150 ORDER BY `unit` DESC [ RunTime:0.002357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16994150 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16994150 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15209765 LIMIT 5 [ RunTime:0.005820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209765 ORDER BY `minOrder` ASC [ RunTime:0.003200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15209765 ORDER BY `unit` DESC [ RunTime:0.010104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15209765 LIMIT 2 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15209765 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382350 LIMIT 5 [ RunTime:0.001454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382350 ORDER BY `minOrder` ASC [ RunTime:0.007645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382350 ORDER BY `unit` DESC [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382350 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382350 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
select * from pdf where partno='852410 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380204 LIMIT 5 [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380204 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380204 ORDER BY `unit` DESC [ RunTime:0.014184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380204 LIMIT 2 [ RunTime:0.019977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380204 ORDER BY `minOrder` ASC [ RunTime:0.022403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376657 LIMIT 5 [ RunTime:0.007239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376657 ORDER BY `minOrder` ASC [ RunTime:0.013394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376657 ORDER BY `unit` DESC [ RunTime:0.006273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376657 LIMIT 2 [ RunTime:0.004294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376657 ORDER BY `minOrder` ASC [ RunTime:0.003168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522573 LIMIT 5 [ RunTime:0.014215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522573 ORDER BY `minOrder` ASC [ RunTime:0.028890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522573 ORDER BY `unit` DESC [ RunTime:0.010519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522573 LIMIT 2 [ RunTime:0.013129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522573 ORDER BY `minOrder` ASC [ RunTime:0.001623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508389 LIMIT 5 [ RunTime:0.019523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508389 ORDER BY `minOrder` ASC [ RunTime:0.017223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508389 ORDER BY `unit` DESC [ RunTime:0.021067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508389 LIMIT 2 [ RunTime:0.010290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508389 ORDER BY `minOrder` ASC [ RunTime:0.020117s ]
select * from pdf where partno='85241 3681000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.014440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505397 LIMIT 5 [ RunTime:0.013023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505397 ORDER BY `minOrder` ASC [ RunTime:0.007492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505397 ORDER BY `unit` DESC [ RunTime:0.031806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505397 LIMIT 2 [ RunTime:0.021550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505397 ORDER BY `minOrder` ASC [ RunTime:0.018135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504869 LIMIT 5 [ RunTime:0.020821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504869 ORDER BY `minOrder` ASC [ RunTime:0.031302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13504869 ORDER BY `unit` DESC [ RunTime:0.026392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13504869 LIMIT 2 [ RunTime:0.013608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504869 ORDER BY `minOrder` ASC [ RunTime:0.014345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504343 LIMIT 5 [ RunTime:0.064996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504343 ORDER BY `minOrder` ASC [ RunTime:0.054080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13504343 ORDER BY `unit` DESC [ RunTime:0.005928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13504343 LIMIT 2 [ RunTime:0.046031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504343 ORDER BY `minOrder` ASC [ RunTime:0.023630s ]
select * from pdf where partno='852410 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503650 LIMIT 5 [ RunTime:0.013675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503650 ORDER BY `minOrder` ASC [ RunTime:0.010721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503650 ORDER BY `unit` DESC [ RunTime:0.028701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503650 LIMIT 2 [ RunTime:0.001593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503650 ORDER BY `minOrder` ASC [ RunTime:0.008560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502975 LIMIT 5 [ RunTime:0.025939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502975 ORDER BY `minOrder` ASC [ RunTime:0.012783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13502975 ORDER BY `unit` DESC [ RunTime:0.038960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13502975 LIMIT 2 [ RunTime:0.018002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13502975 ORDER BY `minOrder` ASC [ RunTime:0.006823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11188650 LIMIT 5 [ RunTime:0.012568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188650 ORDER BY `minOrder` ASC [ RunTime:0.020800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11188650 ORDER BY `unit` DESC [ RunTime:0.007532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11188650 LIMIT 2 [ RunTime:0.009062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188650 ORDER BY `minOrder` ASC [ RunTime:0.001049s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011843s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62840216 LIMIT 5 [ RunTime:0.024920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62840216 ORDER BY `minOrder` ASC [ RunTime:0.032569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62840216 ORDER BY `unit` DESC [ RunTime:0.019934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62840216 LIMIT 2 [ RunTime:0.012037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62840216 ORDER BY `minOrder` ASC [ RunTime:0.013071s ]
select * from pdf where partno='85241288' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.025205s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.011961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '85241288' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.029763s ]
SELECT `id` FROM `stock` WHERE `id` <> 62840216 AND `partno` = '85241288' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.038490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584030 [ RunTime:0.019667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63008761 LIMIT 5 [ RunTime:0.028403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63008761 ORDER BY `minOrder` ASC [ RunTime:0.049622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63008761 ORDER BY `unit` DESC [ RunTime:0.052161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63008761 LIMIT 2 [ RunTime:0.043516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63008761 ORDER BY `minOrder` ASC [ RunTime:0.036542s ]
select * from pdf where partno='852410CY BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.013094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410CY BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.044595s ]
SELECT `id` FROM `stock` WHERE `id` <> 63008761 AND `partno` = '852410CY BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.101561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515769 [ RunTime:0.011152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64511020 LIMIT 5 [ RunTime:0.040911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511020 ORDER BY `minOrder` ASC [ RunTime:0.047356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64511020 ORDER BY `unit` DESC [ RunTime:0.027513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64511020 LIMIT 2 [ RunTime:0.054613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511020 ORDER BY `minOrder` ASC [ RunTime:0.088375s ]
select * from pdf where partno='85241' and brandshort='Brady Corporation' limit 1 [ RunTime:0.050736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '85241' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020595s ]
SELECT `id` FROM `stock` WHERE `id` <> 64511020 AND `partno` = '85241' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522573 [ RunTime:0.065712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64425057 LIMIT 5 [ RunTime:0.030840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64425057 ORDER BY `minOrder` ASC [ RunTime:0.051614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64425057 ORDER BY `unit` DESC [ RunTime:0.011968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64425057 LIMIT 2 [ RunTime:0.012534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64425057 ORDER BY `minOrder` ASC [ RunTime:0.037450s ]
select * from pdf where partno='852413' and brandshort='3M' limit 1 [ RunTime:0.024693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852413' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.040064s ]
SELECT `id` FROM `stock` WHERE `id` <> 64425057 AND `partno` = '852413' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.025978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15209765 [ RunTime:0.034431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64425038 LIMIT 5 [ RunTime:0.011234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64425038 ORDER BY `minOrder` ASC [ RunTime:0.060269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64425038 ORDER BY `unit` DESC [ RunTime:0.047547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64425038 LIMIT 2 [ RunTime:0.027320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64425038 ORDER BY `minOrder` ASC [ RunTime:0.021546s ]
select * from pdf where partno='852410' and brandshort='3M' limit 1 [ RunTime:0.030842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.021970s ]
SELECT `id` FROM `stock` WHERE `id` <> 64425038 AND `partno` = '852410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.033268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714397 [ RunTime:0.044908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63028644 LIMIT 5 [ RunTime:0.025987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63028644 ORDER BY `minOrder` ASC [ RunTime:0.041201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63028644 ORDER BY `unit` DESC [ RunTime:0.051844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63028644 LIMIT 2 [ RunTime:0.025648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63028644 ORDER BY `minOrder` ASC [ RunTime:0.027511s ]
select * from pdf where partno='85241 3681000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.024923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '85241 3681000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.033503s ]
SELECT `id` FROM `stock` WHERE `id` <> 63028644 AND `partno` = '85241 3681000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.020510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508389 [ RunTime:0.031289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63026082 LIMIT 5 [ RunTime:0.014862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63026082 ORDER BY `minOrder` ASC [ RunTime:0.036631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63026082 ORDER BY `unit` DESC [ RunTime:0.028294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63026082 LIMIT 2 [ RunTime:0.046594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63026082 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
select * from pdf where partno='852410CY BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410CY BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.044044s ]
SELECT `id` FROM `stock` WHERE `id` <> 63026082 AND `partno` = '852410CY BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.032250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380204 [ RunTime:0.060227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63023877 LIMIT 5 [ RunTime:0.052903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023877 ORDER BY `minOrder` ASC [ RunTime:0.067965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63023877 ORDER BY `unit` DESC [ RunTime:0.085906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63023877 LIMIT 2 [ RunTime:0.052505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023877 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
select * from pdf where partno='852410CY BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.020387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410CY BK002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.024769s ]
SELECT `id` FROM `stock` WHERE `id` <> 63023877 AND `partno` = '852410CY BK002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.079163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505397 [ RunTime:0.011098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63023017 LIMIT 5 [ RunTime:0.018338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023017 ORDER BY `minOrder` ASC [ RunTime:0.020382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63023017 ORDER BY `unit` DESC [ RunTime:0.035329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63023017 LIMIT 2 [ RunTime:0.016925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023017 ORDER BY `minOrder` ASC [ RunTime:0.009605s ]
select * from pdf where partno='852410 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002800s ]
SELECT `id` FROM `stock` WHERE `id` <> 63023017 AND `partno` = '852410 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504869 [ RunTime:0.021885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63022338 LIMIT 5 [ RunTime:0.020989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63022338 ORDER BY `minOrder` ASC [ RunTime:0.041152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63022338 ORDER BY `unit` DESC [ RunTime:0.024469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63022338 LIMIT 2 [ RunTime:0.066139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63022338 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
select * from pdf where partno='852410 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.041136s ]
SELECT `id` FROM `stock` WHERE `id` <> 63022338 AND `partno` = '852410 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.036422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504343 [ RunTime:0.018658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021306 LIMIT 5 [ RunTime:0.023639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021306 ORDER BY `minOrder` ASC [ RunTime:0.018782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021306 ORDER BY `unit` DESC [ RunTime:0.013631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021306 LIMIT 2 [ RunTime:0.015892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021306 ORDER BY `minOrder` ASC [ RunTime:0.016770s ]
select * from pdf where partno='852410CY BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.028539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410CY BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007959s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021306 AND `partno` = '852410CY BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503650 [ RunTime:0.013161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63019088 LIMIT 5 [ RunTime:0.021162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019088 ORDER BY `minOrder` ASC [ RunTime:0.048087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63019088 ORDER BY `unit` DESC [ RunTime:0.019816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63019088 LIMIT 2 [ RunTime:0.002659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63019088 ORDER BY `minOrder` ASC [ RunTime:0.038327s ]
select * from pdf where partno='852410 BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410 BK002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.008250s ]
SELECT `id` FROM `stock` WHERE `id` <> 63019088 AND `partno` = '852410 BK002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.017836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502975 [ RunTime:0.013087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63017857 LIMIT 5 [ RunTime:0.026615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63017857 ORDER BY `minOrder` ASC [ RunTime:0.051685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63017857 ORDER BY `unit` DESC [ RunTime:0.028909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63017857 LIMIT 2 [ RunTime:0.019436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63017857 ORDER BY `minOrder` ASC [ RunTime:0.010542s ]
select * from pdf where partno='852410 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '852410 BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.028360s ]
SELECT `id` FROM `stock` WHERE `id` <> 63017857 AND `partno` = '852410 BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.023172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376657 [ RunTime:0.006082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58516946 LIMIT 5 [ RunTime:0.015257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516946 ORDER BY `minOrder` ASC [ RunTime:0.010211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58516946 ORDER BY `unit` DESC [ RunTime:0.026374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58516946 LIMIT 2 [ RunTime:0.018157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516946 ORDER BY `minOrder` ASC [ RunTime:0.011305s ]
select * from pdf where partno='85241M' and brandshort='Dremel' limit 1 [ RunTime:0.005381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '85241M' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.020584s ]
SELECT `id` FROM `stock` WHERE `id` <> 58516946 AND `partno` = '85241M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.007845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11188650 [ RunTime:0.028204s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019102s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036722s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037127s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025959s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069373s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062229s ]
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 '85241%' OR `brand` LIKE '85241%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018628s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '85241%' OR `brand` LIKE '85241%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016281s ]