SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001326s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=KL-0045-70&search=1' [ RunTime:0.009091s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001688s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005502s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001466s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.019693s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002836s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010987s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002044s ]
SELECT * FROM `stock_search` WHERE `partno` = 'KL-0045-70' LIMIT 1 [ RunTime:0.021705s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:35:55' WHERE `partno` = 'KL-0045-70' [ RunTime:0.029418s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002215s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061124s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186729 LIMIT 5 [ RunTime:0.034937s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186729 ORDER BY `minOrder` ASC [ RunTime:0.026429s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186729 ORDER BY `unit` DESC [ RunTime:0.013406s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186729 LIMIT 2 [ RunTime:0.018494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186729 ORDER BY `minOrder` ASC [ RunTime:0.019631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186718 LIMIT 5 [ RunTime:0.036071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186718 ORDER BY `minOrder` ASC [ RunTime:0.125541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186718 ORDER BY `unit` DESC [ RunTime:0.031859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186718 LIMIT 2 [ RunTime:0.021412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186718 ORDER BY `minOrder` ASC [ RunTime:0.028734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175504 LIMIT 5 [ RunTime:0.074666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175504 ORDER BY `minOrder` ASC [ RunTime:0.046173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175504 ORDER BY `unit` DESC [ RunTime:0.020823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175504 LIMIT 2 [ RunTime:0.024279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175504 ORDER BY `minOrder` ASC [ RunTime:0.014759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175312 LIMIT 5 [ RunTime:0.011453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175312 ORDER BY `minOrder` ASC [ RunTime:0.017506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175312 ORDER BY `unit` DESC [ RunTime:0.030508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175312 LIMIT 2 [ RunTime:0.021915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175312 ORDER BY `minOrder` ASC [ RunTime:0.052225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175311 LIMIT 5 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175311 ORDER BY `minOrder` ASC [ RunTime:0.005841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175311 ORDER BY `unit` DESC [ RunTime:0.032741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175311 LIMIT 2 [ RunTime:0.006394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175311 ORDER BY `minOrder` ASC [ RunTime:0.014834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174178 LIMIT 5 [ RunTime:0.033245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174178 ORDER BY `minOrder` ASC [ RunTime:0.006027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174178 ORDER BY `unit` DESC [ RunTime:0.020272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174178 LIMIT 2 [ RunTime:0.014463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174178 ORDER BY `minOrder` ASC [ RunTime:0.018334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173577 LIMIT 5 [ RunTime:0.028782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173577 ORDER BY `minOrder` ASC [ RunTime:0.044374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12173577 ORDER BY `unit` DESC [ RunTime:0.041564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12173577 LIMIT 2 [ RunTime:0.012173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173577 ORDER BY `minOrder` ASC [ RunTime:0.009996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171695 LIMIT 5 [ RunTime:0.023150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171695 ORDER BY `minOrder` ASC [ RunTime:0.006071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12171695 ORDER BY `unit` DESC [ RunTime:0.005631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12171695 LIMIT 2 [ RunTime:0.035409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171695 ORDER BY `minOrder` ASC [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170179 LIMIT 5 [ RunTime:0.016795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170179 ORDER BY `minOrder` ASC [ RunTime:0.011971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12170179 ORDER BY `unit` DESC [ RunTime:0.009702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12170179 LIMIT 2 [ RunTime:0.017702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170179 ORDER BY `minOrder` ASC [ RunTime:0.010552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196155 LIMIT 5 [ RunTime:0.030124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196155 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196155 ORDER BY `unit` DESC [ RunTime:0.011497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196155 LIMIT 2 [ RunTime:0.013184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196155 ORDER BY `minOrder` ASC [ RunTime:0.012821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190223 LIMIT 5 [ RunTime:0.004278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190223 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190223 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190223 LIMIT 2 [ RunTime:0.004339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190223 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189943 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189943 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189943 ORDER BY `unit` DESC [ RunTime:0.000361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189943 LIMIT 2 [ RunTime:0.002500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189943 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189934 LIMIT 5 [ RunTime:0.001135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189934 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189934 ORDER BY `unit` DESC [ RunTime:0.004751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189934 LIMIT 2 [ RunTime:0.009778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189934 ORDER BY `minOrder` ASC [ RunTime:0.006229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189675 LIMIT 5 [ RunTime:0.011576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189675 ORDER BY `minOrder` ASC [ RunTime:0.032414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189675 ORDER BY `unit` DESC [ RunTime:0.004070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189675 LIMIT 2 [ RunTime:0.002280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189675 ORDER BY `minOrder` ASC [ RunTime:0.006392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189536 LIMIT 5 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189536 ORDER BY `minOrder` ASC [ RunTime:0.005967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189536 ORDER BY `unit` DESC [ RunTime:0.004861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189536 LIMIT 2 [ RunTime:0.013656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189536 ORDER BY `minOrder` ASC [ RunTime:0.004940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11188072 LIMIT 5 [ RunTime:0.005640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188072 ORDER BY `minOrder` ASC [ RunTime:0.016248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11188072 ORDER BY `unit` DESC [ RunTime:0.008229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11188072 LIMIT 2 [ RunTime:0.006900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188072 ORDER BY `minOrder` ASC [ RunTime:0.005873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186379 LIMIT 5 [ RunTime:0.020968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186379 ORDER BY `minOrder` ASC [ RunTime:0.006723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186379 ORDER BY `unit` DESC [ RunTime:0.012340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186379 LIMIT 2 [ RunTime:0.017358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186379 ORDER BY `minOrder` ASC [ RunTime:0.003653s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004363s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555550 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555550 ORDER BY `minOrder` ASC [ RunTime:0.001905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555550 ORDER BY `unit` DESC [ RunTime:0.003275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555550 LIMIT 2 [ RunTime:0.006568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555550 ORDER BY `minOrder` ASC [ RunTime:0.002196s ]
select * from pdf where partno='KL-0045-70 A' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.004104s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-70 A' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.003853s ]
SELECT `id` FROM `stock` WHERE `id` <> 58555550 AND `partno` = 'KL-0045-70 A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186729 [ RunTime:0.002093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555531 LIMIT 5 [ RunTime:0.007839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555531 ORDER BY `minOrder` ASC [ RunTime:0.003153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555531 ORDER BY `unit` DESC [ RunTime:0.014838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555531 LIMIT 2 [ RunTime:0.013481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555531 ORDER BY `minOrder` ASC [ RunTime:0.016507s ]
select * from pdf where partno='KL-0045-70' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.035972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-70' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.009380s ]
SELECT `id` FROM `stock` WHERE `id` <> 58555531 AND `partno` = 'KL-0045-70' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.023668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186718 [ RunTime:0.033632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550848 LIMIT 5 [ RunTime:0.033422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550848 ORDER BY `minOrder` ASC [ RunTime:0.032270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550848 ORDER BY `unit` DESC [ RunTime:0.004365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550848 LIMIT 2 [ RunTime:0.006181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550848 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
select * from pdf where partno='KL-0045-7019' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7019' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.023431s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550848 AND `partno` = 'KL-0045-7019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.130876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196155 [ RunTime:0.104172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525459 LIMIT 5 [ RunTime:0.014796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525459 ORDER BY `minOrder` ASC [ RunTime:0.028760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525459 ORDER BY `unit` DESC [ RunTime:0.037059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525459 LIMIT 2 [ RunTime:0.051220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525459 ORDER BY `minOrder` ASC [ RunTime:0.042901s ]
select * from pdf where partno='KL-0045-700' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.089449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-700' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.009267s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525459 AND `partno` = 'KL-0045-700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171695 [ RunTime:0.014680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58524266 LIMIT 5 [ RunTime:0.011128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524266 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58524266 ORDER BY `unit` DESC [ RunTime:0.030190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58524266 LIMIT 2 [ RunTime:0.005305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524266 ORDER BY `minOrder` ASC [ RunTime:0.020418s ]
select * from pdf where partno='KL-0045-7001' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.042468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7001' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 58524266 AND `partno` = 'KL-0045-7001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.046811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58523619 LIMIT 5 [ RunTime:0.090841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523619 ORDER BY `minOrder` ASC [ RunTime:0.081408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58523619 ORDER BY `unit` DESC [ RunTime:0.070918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58523619 LIMIT 2 [ RunTime:0.133281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523619 ORDER BY `minOrder` ASC [ RunTime:0.070545s ]
select * from pdf where partno='KL-0045-7016' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.051036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7016' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.058136s ]
SELECT `id` FROM `stock` WHERE `id` <> 58523619 AND `partno` = 'KL-0045-7016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.071900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186379 [ RunTime:0.071023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58522833 LIMIT 5 [ RunTime:0.079329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522833 ORDER BY `minOrder` ASC [ RunTime:0.081329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58522833 ORDER BY `unit` DESC [ RunTime:0.034149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58522833 LIMIT 2 [ RunTime:0.061779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522833 ORDER BY `minOrder` ASC [ RunTime:0.035072s ]
select * from pdf where partno='KL-0045-7018' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.056241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7018' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013041s ]
SELECT `id` FROM `stock` WHERE `id` <> 58522833 AND `partno` = 'KL-0045-7018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.094908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170179 [ RunTime:0.081292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58521942 LIMIT 5 [ RunTime:0.034328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521942 ORDER BY `minOrder` ASC [ RunTime:0.083905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58521942 ORDER BY `unit` DESC [ RunTime:0.033904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58521942 LIMIT 2 [ RunTime:0.071470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521942 ORDER BY `minOrder` ASC [ RunTime:0.170883s ]
select * from pdf where partno='KL-0045-7015' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.037620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7015' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.093624s ]
SELECT `id` FROM `stock` WHERE `id` <> 58521942 AND `partno` = 'KL-0045-7015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.027178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58521484 LIMIT 5 [ RunTime:0.019754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521484 ORDER BY `minOrder` ASC [ RunTime:0.003395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58521484 ORDER BY `unit` DESC [ RunTime:0.003964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58521484 LIMIT 2 [ RunTime:0.019504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521484 ORDER BY `minOrder` ASC [ RunTime:0.012081s ]
select * from pdf where partno='KL-0045-7004' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.005944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7004' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.019280s ]
SELECT `id` FROM `stock` WHERE `id` <> 58521484 AND `partno` = 'KL-0045-7004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.012065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190223 [ RunTime:0.000188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58520653 LIMIT 5 [ RunTime:0.011491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520653 ORDER BY `minOrder` ASC [ RunTime:0.011295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58520653 ORDER BY `unit` DESC [ RunTime:0.012770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58520653 LIMIT 2 [ RunTime:0.013752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520653 ORDER BY `minOrder` ASC [ RunTime:0.049253s ]
select * from pdf where partno='KL-0045-7002' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7002' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001415s ]
SELECT `id` FROM `stock` WHERE `id` <> 58520653 AND `partno` = 'KL-0045-7002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189943 [ RunTime:0.003449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58520634 LIMIT 5 [ RunTime:0.015450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520634 ORDER BY `minOrder` ASC [ RunTime:0.011515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58520634 ORDER BY `unit` DESC [ RunTime:0.020233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58520634 LIMIT 2 [ RunTime:0.033599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520634 ORDER BY `minOrder` ASC [ RunTime:0.032718s ]
select * from pdf where partno='KL-0045-7020' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.030906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7020' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.025436s ]
SELECT `id` FROM `stock` WHERE `id` <> 58520634 AND `partno` = 'KL-0045-7020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.015582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189934 [ RunTime:0.013504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519910 LIMIT 5 [ RunTime:0.001213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519910 ORDER BY `minOrder` ASC [ RunTime:0.004054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519910 ORDER BY `unit` DESC [ RunTime:0.011426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519910 LIMIT 2 [ RunTime:0.006523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519910 ORDER BY `minOrder` ASC [ RunTime:0.009669s ]
select * from pdf where partno='KL-0045-7021' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7021' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000846s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519910 AND `partno` = 'KL-0045-7021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.004348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189675 [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519630 LIMIT 5 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519630 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519630 ORDER BY `unit` DESC [ RunTime:0.002639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519630 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519630 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='KL-0045-7007' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7007' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000422s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519630 AND `partno` = 'KL-0045-7007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.007495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175504 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519584 LIMIT 5 [ RunTime:0.001902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519584 ORDER BY `minOrder` ASC [ RunTime:0.003619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519584 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519584 LIMIT 2 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519584 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='KL-0045-7009' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.005513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7009' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000675s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519584 AND `partno` = 'KL-0045-7009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189536 [ RunTime:0.001841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519261 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519261 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519261 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519261 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519261 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='KL-0045-7006' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7006' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519261 AND `partno` = 'KL-0045-7006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175312 [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519260 LIMIT 5 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519260 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519260 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519260 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519260 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='KL-0045-7005' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7005' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000380s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519260 AND `partno` = 'KL-0045-7005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175311 [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58517535 LIMIT 5 [ RunTime:0.012570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58517535 ORDER BY `minOrder` ASC [ RunTime:0.001407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58517535 ORDER BY `unit` DESC [ RunTime:0.001838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58517535 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58517535 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='KL-0045-7010' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7010' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.008141s ]
SELECT `id` FROM `stock` WHERE `id` <> 58517535 AND `partno` = 'KL-0045-7010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58516917 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516917 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58516917 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58516917 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516917 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='KL-0045-7003' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7003' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000415s ]
SELECT `id` FROM `stock` WHERE `id` <> 58516917 AND `partno` = 'KL-0045-7003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174178 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58515849 LIMIT 5 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515849 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58515849 ORDER BY `unit` DESC [ RunTime:0.002431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58515849 LIMIT 2 [ RunTime:0.006703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515849 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='KL-0045-7012' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7012' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001051s ]
SELECT `id` FROM `stock` WHERE `id` <> 58515849 AND `partno` = 'KL-0045-7012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173577 [ RunTime:0.007547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58515243 LIMIT 5 [ RunTime:0.004878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515243 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58515243 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58515243 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515243 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='KL-0045-7008' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7008' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000351s ]
SELECT `id` FROM `stock` WHERE `id` <> 58515243 AND `partno` = 'KL-0045-7008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11188072 [ RunTime:0.002398s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001298s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012326s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009178s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013961s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012120s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010992s ]
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 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019885s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'KL-0045-70%' OR `brand` LIKE 'KL-0045-70%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015829s ]