SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001579s ]
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-7&search=1' [ RunTime:0.028103s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002145s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012051s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001834s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.019328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001349s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004127s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001124s ]
SELECT * FROM `stock_search` WHERE `partno` = 'KL-0045-7' LIMIT 1 [ RunTime:0.010409s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 18:26:13' WHERE `partno` = 'KL-0045-7' [ RunTime:0.017620s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001342s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079347s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186729 LIMIT 5 [ RunTime:0.059382s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186729 ORDER BY `minOrder` ASC [ RunTime:0.093289s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.027350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186729 ORDER BY `unit` DESC [ RunTime:0.084007s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186729 LIMIT 2 [ RunTime:0.023930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186729 ORDER BY `minOrder` ASC [ RunTime:0.022327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186718 LIMIT 5 [ RunTime:0.048873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186718 ORDER BY `minOrder` ASC [ RunTime:0.022444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186718 ORDER BY `unit` DESC [ RunTime:0.009691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186718 LIMIT 2 [ RunTime:0.015064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186718 ORDER BY `minOrder` ASC [ RunTime:0.005850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175504 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175504 ORDER BY `minOrder` ASC [ RunTime:0.009852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175504 ORDER BY `unit` DESC [ RunTime:0.003847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175504 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175504 ORDER BY `minOrder` ASC [ RunTime:0.001216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175312 LIMIT 5 [ RunTime:0.008486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175312 ORDER BY `minOrder` ASC [ RunTime:0.011889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175312 ORDER BY `unit` DESC [ RunTime:0.005239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175312 LIMIT 2 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175312 ORDER BY `minOrder` ASC [ RunTime:0.003437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175311 LIMIT 5 [ RunTime:0.016590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175311 ORDER BY `minOrder` ASC [ RunTime:0.024749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175311 ORDER BY `unit` DESC [ RunTime:0.014027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175311 LIMIT 2 [ RunTime:0.005740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175311 ORDER BY `minOrder` ASC [ RunTime:0.008288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174178 LIMIT 5 [ RunTime:0.006044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174178 ORDER BY `minOrder` ASC [ RunTime:0.011430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174178 ORDER BY `unit` DESC [ RunTime:0.027745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174178 LIMIT 2 [ RunTime:0.010621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174178 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173577 LIMIT 5 [ RunTime:0.002469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173577 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12173577 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12173577 LIMIT 2 [ RunTime:0.008932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173577 ORDER BY `minOrder` ASC [ RunTime:0.008425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171695 LIMIT 5 [ RunTime:0.016916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171695 ORDER BY `minOrder` ASC [ RunTime:0.028488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12171695 ORDER BY `unit` DESC [ RunTime:0.025229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12171695 LIMIT 2 [ RunTime:0.003735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171695 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170179 LIMIT 5 [ RunTime:0.003386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170179 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12170179 ORDER BY `unit` DESC [ RunTime:0.011233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12170179 LIMIT 2 [ RunTime:0.010354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170179 ORDER BY `minOrder` ASC [ RunTime:0.014848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196155 LIMIT 5 [ RunTime:0.030055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196155 ORDER BY `minOrder` ASC [ RunTime:0.007690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196155 ORDER BY `unit` DESC [ RunTime:0.006174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196155 LIMIT 2 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196155 ORDER BY `minOrder` ASC [ RunTime:0.012688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190223 LIMIT 5 [ RunTime:0.009368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190223 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190223 ORDER BY `unit` DESC [ RunTime:0.008252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190223 LIMIT 2 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190223 ORDER BY `minOrder` ASC [ RunTime:0.001591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189943 LIMIT 5 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189943 ORDER BY `minOrder` ASC [ RunTime:0.006876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189943 ORDER BY `unit` DESC [ RunTime:0.019042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189943 LIMIT 2 [ RunTime:0.003168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189943 ORDER BY `minOrder` ASC [ RunTime:0.006245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189934 LIMIT 5 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189934 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189934 ORDER BY `unit` DESC [ RunTime:0.000868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189934 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189934 ORDER BY `minOrder` ASC [ RunTime:0.001452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189675 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189675 ORDER BY `minOrder` ASC [ RunTime:0.017909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189675 ORDER BY `unit` DESC [ RunTime:0.021280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189675 LIMIT 2 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189675 ORDER BY `minOrder` ASC [ RunTime:0.006531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189536 LIMIT 5 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189536 ORDER BY `minOrder` ASC [ RunTime:0.006302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189536 ORDER BY `unit` DESC [ RunTime:0.017428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189536 LIMIT 2 [ RunTime:0.020970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189536 ORDER BY `minOrder` ASC [ RunTime:0.006647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11188072 LIMIT 5 [ RunTime:0.005293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188072 ORDER BY `minOrder` ASC [ RunTime:0.013866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11188072 ORDER BY `unit` DESC [ RunTime:0.008766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11188072 LIMIT 2 [ RunTime:0.023732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11188072 ORDER BY `minOrder` ASC [ RunTime:0.020049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11187121 LIMIT 5 [ RunTime:0.035897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11187121 ORDER BY `minOrder` ASC [ RunTime:0.007665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11187121 ORDER BY `unit` DESC [ RunTime:0.003299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11187121 LIMIT 2 [ RunTime:0.009522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11187121 ORDER BY `minOrder` ASC [ RunTime:0.005737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186379 LIMIT 5 [ RunTime:0.001776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186379 ORDER BY `minOrder` ASC [ RunTime:0.004209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186379 ORDER BY `unit` DESC [ RunTime:0.004253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186379 LIMIT 2 [ RunTime:0.029922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186379 ORDER BY `minOrder` ASC [ RunTime:0.003152s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007462s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555550 LIMIT 5 [ RunTime:0.012383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555550 ORDER BY `minOrder` ASC [ RunTime:0.009225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555550 ORDER BY `unit` DESC [ RunTime:0.006862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555550 LIMIT 2 [ RunTime:0.005662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555550 ORDER BY `minOrder` ASC [ RunTime:0.013890s ]
select * from pdf where partno='KL-0045-70 A' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.003906s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-70 A' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.012530s ]
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.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186729 [ RunTime:0.005856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555531 LIMIT 5 [ RunTime:0.003426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555531 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555531 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555531 LIMIT 2 [ RunTime:0.009407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555531 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='KL-0045-70' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-70' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.017988s ]
SELECT `id` FROM `stock` WHERE `id` <> 58555531 AND `partno` = 'KL-0045-70' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.011218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186718 [ RunTime:0.006069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550848 LIMIT 5 [ RunTime:0.016273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550848 ORDER BY `minOrder` ASC [ RunTime:0.012268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550848 ORDER BY `unit` DESC [ RunTime:0.012727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550848 LIMIT 2 [ RunTime:0.010177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550848 ORDER BY `minOrder` ASC [ RunTime:0.025443s ]
select * from pdf where partno='KL-0045-7019' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.037472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7019' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.018221s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550848 AND `partno` = 'KL-0045-7019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.003419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196155 [ RunTime:0.002520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525574 LIMIT 5 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525574 ORDER BY `minOrder` ASC [ RunTime:0.031699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525574 ORDER BY `unit` DESC [ RunTime:0.012269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525574 LIMIT 2 [ RunTime:0.008633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525574 ORDER BY `minOrder` ASC [ RunTime:0.003103s ]
select * from pdf where partno='KL-0045-7' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.015343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013393s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525574 AND `partno` = 'KL-0045-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.048526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11187121 [ RunTime:0.041166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525459 LIMIT 5 [ RunTime:0.032463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525459 ORDER BY `minOrder` ASC [ RunTime:0.014036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525459 ORDER BY `unit` DESC [ RunTime:0.000742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525459 LIMIT 2 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525459 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='KL-0045-700' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.015510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-700' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.009951s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525459 AND `partno` = 'KL-0045-700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.018673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171695 [ RunTime:0.015813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58524266 LIMIT 5 [ RunTime:0.019256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524266 ORDER BY `minOrder` ASC [ RunTime:0.049193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58524266 ORDER BY `unit` DESC [ RunTime:0.001833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58524266 LIMIT 2 [ RunTime:0.005585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524266 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
select * from pdf where partno='KL-0045-7001' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.021837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7001' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.024806s ]
SELECT `id` FROM `stock` WHERE `id` <> 58524266 AND `partno` = 'KL-0045-7001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.039816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58523619 LIMIT 5 [ RunTime:0.021548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523619 ORDER BY `minOrder` ASC [ RunTime:0.054380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58523619 ORDER BY `unit` DESC [ RunTime:0.066530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58523619 LIMIT 2 [ RunTime:0.058037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523619 ORDER BY `minOrder` ASC [ RunTime:0.042377s ]
select * from pdf where partno='KL-0045-7016' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.021830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7016' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.043765s ]
SELECT `id` FROM `stock` WHERE `id` <> 58523619 AND `partno` = 'KL-0045-7016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.017802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186379 [ RunTime:0.030624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58522833 LIMIT 5 [ RunTime:0.042809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522833 ORDER BY `minOrder` ASC [ RunTime:0.041974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58522833 ORDER BY `unit` DESC [ RunTime:0.047483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58522833 LIMIT 2 [ RunTime:0.023793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522833 ORDER BY `minOrder` ASC [ RunTime:0.006509s ]
select * from pdf where partno='KL-0045-7018' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.008042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7018' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.033243s ]
SELECT `id` FROM `stock` WHERE `id` <> 58522833 AND `partno` = 'KL-0045-7018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.019455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170179 [ RunTime:0.016242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58521942 LIMIT 5 [ RunTime:0.008147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521942 ORDER BY `minOrder` ASC [ RunTime:0.012511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58521942 ORDER BY `unit` DESC [ RunTime:0.025725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58521942 LIMIT 2 [ RunTime:0.033828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521942 ORDER BY `minOrder` ASC [ RunTime:0.027362s ]
select * from pdf where partno='KL-0045-7015' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.023827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7015' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.028858s ]
SELECT `id` FROM `stock` WHERE `id` <> 58521942 AND `partno` = 'KL-0045-7015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.024152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58521484 LIMIT 5 [ RunTime:0.011030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521484 ORDER BY `minOrder` ASC [ RunTime:0.027447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58521484 ORDER BY `unit` DESC [ RunTime:0.063239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58521484 LIMIT 2 [ RunTime:0.064652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521484 ORDER BY `minOrder` ASC [ RunTime:0.016040s ]
select * from pdf where partno='KL-0045-7004' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.007188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7004' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005863s ]
SELECT `id` FROM `stock` WHERE `id` <> 58521484 AND `partno` = 'KL-0045-7004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.009651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190223 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58520653 LIMIT 5 [ RunTime:0.016243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520653 ORDER BY `minOrder` ASC [ RunTime:0.060999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58520653 ORDER BY `unit` DESC [ RunTime:0.024226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58520653 LIMIT 2 [ RunTime:0.005296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520653 ORDER BY `minOrder` ASC [ RunTime:0.017871s ]
select * from pdf where partno='KL-0045-7002' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.027251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7002' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.024368s ]
SELECT `id` FROM `stock` WHERE `id` <> 58520653 AND `partno` = 'KL-0045-7002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189943 [ RunTime:0.020032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58520634 LIMIT 5 [ RunTime:0.020452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520634 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58520634 ORDER BY `unit` DESC [ RunTime:0.005632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58520634 LIMIT 2 [ RunTime:0.008809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520634 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
select * from pdf where partno='KL-0045-7020' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.017484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7020' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.009053s ]
SELECT `id` FROM `stock` WHERE `id` <> 58520634 AND `partno` = 'KL-0045-7020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.016256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189934 [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519910 LIMIT 5 [ RunTime:0.014025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519910 ORDER BY `minOrder` ASC [ RunTime:0.014955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519910 ORDER BY `unit` DESC [ RunTime:0.020870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519910 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519910 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
select * from pdf where partno='KL-0045-7021' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.015374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7021' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.030139s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519910 AND `partno` = 'KL-0045-7021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.020764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189675 [ RunTime:0.046984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519630 LIMIT 5 [ RunTime:0.008804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519630 ORDER BY `minOrder` ASC [ RunTime:0.013482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519630 ORDER BY `unit` DESC [ RunTime:0.003012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519630 LIMIT 2 [ RunTime:0.012010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519630 ORDER BY `minOrder` ASC [ RunTime:0.019184s ]
select * from pdf where partno='KL-0045-7007' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.039410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7007' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.031134s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519630 AND `partno` = 'KL-0045-7007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.019584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175504 [ RunTime:0.011586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519584 LIMIT 5 [ RunTime:0.010011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519584 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519584 ORDER BY `unit` DESC [ RunTime:0.013667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519584 LIMIT 2 [ RunTime:0.005159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519584 ORDER BY `minOrder` ASC [ RunTime:0.005720s ]
select * from pdf where partno='KL-0045-7009' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7009' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.004625s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519584 AND `partno` = 'KL-0045-7009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.005730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189536 [ RunTime:0.004055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519261 LIMIT 5 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519261 ORDER BY `minOrder` ASC [ RunTime:0.007046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519261 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519261 LIMIT 2 [ RunTime:0.006756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519261 ORDER BY `minOrder` ASC [ RunTime:0.002322s ]
select * from pdf where partno='KL-0045-7006' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7006' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.010348s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519261 AND `partno` = 'KL-0045-7006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.006094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175312 [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519260 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519260 ORDER BY `minOrder` ASC [ RunTime:0.009476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519260 ORDER BY `unit` DESC [ RunTime:0.000787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519260 LIMIT 2 [ RunTime:0.006450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519260 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='KL-0045-7005' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7005' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.015916s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519260 AND `partno` = 'KL-0045-7005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.012622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175311 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58517535 LIMIT 5 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58517535 ORDER BY `minOrder` ASC [ RunTime:0.002149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58517535 ORDER BY `unit` DESC [ RunTime:0.003687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58517535 LIMIT 2 [ RunTime:0.014885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58517535 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='KL-0045-7010' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7010' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.002052s ]
SELECT `id` FROM `stock` WHERE `id` <> 58517535 AND `partno` = 'KL-0045-7010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58516917 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516917 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58516917 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58516917 LIMIT 2 [ RunTime:0.004473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58516917 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='KL-0045-7003' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.003523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7003' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 58516917 AND `partno` = 'KL-0045-7003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174178 [ RunTime:0.004394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58515849 LIMIT 5 [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515849 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58515849 ORDER BY `unit` DESC [ RunTime:0.000689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58515849 LIMIT 2 [ RunTime:0.002194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58515849 ORDER BY `minOrder` ASC [ RunTime:0.007188s ]
select * from pdf where partno='KL-0045-7012' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.004506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0045-7012' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.007251s ]
SELECT `id` FROM `stock` WHERE `id` <> 58515849 AND `partno` = 'KL-0045-7012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.020426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173577 [ RunTime:0.000824s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006502s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001270s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007703s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005658s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028677s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004763s ]
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-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008179s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'KL-0045-7%' OR `brand` LIKE 'KL-0045-7%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001178s ]