SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001434s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=60839&search=1' [ RunTime:0.001959s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001205s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001850s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001049s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001530s ]
SELECT * FROM `stock_search` WHERE `partno` = '60839' LIMIT 1 [ RunTime:0.000831s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-21 15:37:33' WHERE `partno` = '60839' [ RunTime:0.004285s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001351s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003333s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593400 LIMIT 5 [ RunTime:0.000937s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593400 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593400 ORDER BY `unit` DESC [ RunTime:0.014643s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593400 LIMIT 2 [ RunTime:0.002202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593400 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18821725 LIMIT 5 [ RunTime:0.013751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18821725 ORDER BY `minOrder` ASC [ RunTime:0.004685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18821725 ORDER BY `unit` DESC [ RunTime:0.003884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18821725 LIMIT 2 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18821725 ORDER BY `minOrder` ASC [ RunTime:0.000182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818532 LIMIT 5 [ RunTime:0.004334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818532 ORDER BY `minOrder` ASC [ RunTime:0.020937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18818532 ORDER BY `unit` DESC [ RunTime:0.014490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18818532 LIMIT 2 [ RunTime:0.039650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818532 ORDER BY `minOrder` ASC [ RunTime:0.016898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232906 LIMIT 5 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232906 ORDER BY `minOrder` ASC [ RunTime:0.011566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232906 ORDER BY `unit` DESC [ RunTime:0.012842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232906 LIMIT 2 [ RunTime:0.027920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232906 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224493 LIMIT 5 [ RunTime:0.028997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224493 ORDER BY `minOrder` ASC [ RunTime:0.023309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224493 ORDER BY `unit` DESC [ RunTime:0.010195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224493 LIMIT 2 [ RunTime:0.042207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224493 ORDER BY `minOrder` ASC [ RunTime:0.010001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183389 LIMIT 5 [ RunTime:0.035776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14183389 ORDER BY `minOrder` ASC [ RunTime:0.033247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14183389 ORDER BY `unit` DESC [ RunTime:0.031233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14183389 LIMIT 2 [ RunTime:0.050197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14183389 ORDER BY `minOrder` ASC [ RunTime:0.003442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182642 LIMIT 5 [ RunTime:0.040562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182642 ORDER BY `minOrder` ASC [ RunTime:0.055161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14182642 ORDER BY `unit` DESC [ RunTime:0.032824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14182642 LIMIT 2 [ RunTime:0.034564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182642 ORDER BY `minOrder` ASC [ RunTime:0.064830s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046171s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51722682 LIMIT 5 [ RunTime:0.042636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722682 ORDER BY `minOrder` ASC [ RunTime:0.058716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51722682 ORDER BY `unit` DESC [ RunTime:0.037115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51722682 LIMIT 2 [ RunTime:0.033998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722682 ORDER BY `minOrder` ASC [ RunTime:0.006201s ]
select * from pdf where partno='60839' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.009663s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60839' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.002682s ]
SELECT `id` FROM `stock` WHERE `id` <> 51722682 AND `partno` = '60839' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50953191 LIMIT 5 [ RunTime:0.004683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953191 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50953191 ORDER BY `unit` DESC [ RunTime:0.017205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50953191 LIMIT 2 [ RunTime:0.003721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953191 ORDER BY `minOrder` ASC [ RunTime:0.003839s ]
select * from pdf where partno='6083961' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083961' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010496s ]
SELECT `id` FROM `stock` WHERE `id` <> 50953191 AND `partno` = '6083961' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183389 [ RunTime:0.012031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50953189 LIMIT 5 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953189 ORDER BY `minOrder` ASC [ RunTime:0.009384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50953189 ORDER BY `unit` DESC [ RunTime:0.001713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50953189 LIMIT 2 [ RunTime:0.036059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953189 ORDER BY `minOrder` ASC [ RunTime:0.018144s ]
select * from pdf where partno='6083960' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083960' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021597s ]
SELECT `id` FROM `stock` WHERE `id` <> 50953189 AND `partno` = '6083960' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18821725 [ RunTime:0.008307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50953187 LIMIT 5 [ RunTime:0.031305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953187 ORDER BY `minOrder` ASC [ RunTime:0.029672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50953187 ORDER BY `unit` DESC [ RunTime:0.017166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50953187 LIMIT 2 [ RunTime:0.012854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50953187 ORDER BY `minOrder` ASC [ RunTime:0.007857s ]
select * from pdf where partno='6083959' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083959' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002947s ]
SELECT `id` FROM `stock` WHERE `id` <> 50953187 AND `partno` = '6083959' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.034748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232906 [ RunTime:0.010945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50889342 LIMIT 5 [ RunTime:0.040740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50889342 ORDER BY `minOrder` ASC [ RunTime:0.010159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50889342 ORDER BY `unit` DESC [ RunTime:0.013750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50889342 LIMIT 2 [ RunTime:0.007367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50889342 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
select * from pdf where partno='6083987' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083987' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013649s ]
SELECT `id` FROM `stock` WHERE `id` <> 50889342 AND `partno` = '6083987' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818532 [ RunTime:0.058222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50885227 LIMIT 5 [ RunTime:0.018393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50885227 ORDER BY `minOrder` ASC [ RunTime:0.021467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50885227 ORDER BY `unit` DESC [ RunTime:0.016391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50885227 LIMIT 2 [ RunTime:0.033184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50885227 ORDER BY `minOrder` ASC [ RunTime:0.006654s ]
select * from pdf where partno='6083939' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083939' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.046154s ]
SELECT `id` FROM `stock` WHERE `id` <> 50885227 AND `partno` = '6083939' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.059511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182642 [ RunTime:0.034969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38471387 LIMIT 5 [ RunTime:0.027130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471387 ORDER BY `minOrder` ASC [ RunTime:0.037978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38471387 ORDER BY `unit` DESC [ RunTime:0.030227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38471387 LIMIT 2 [ RunTime:0.041624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471387 ORDER BY `minOrder` ASC [ RunTime:0.015353s ]
select * from pdf where partno='6083961' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083961' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011827s ]
SELECT `id` FROM `stock` WHERE `id` <> 38471387 AND `partno` = '6083961' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183389 [ RunTime:0.016821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38471385 LIMIT 5 [ RunTime:0.012742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471385 ORDER BY `minOrder` ASC [ RunTime:0.041943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38471385 ORDER BY `unit` DESC [ RunTime:0.031771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38471385 LIMIT 2 [ RunTime:0.036389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471385 ORDER BY `minOrder` ASC [ RunTime:0.010377s ]
select * from pdf where partno='6083960' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083960' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008075s ]
SELECT `id` FROM `stock` WHERE `id` <> 38471385 AND `partno` = '6083960' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18821725 [ RunTime:0.028970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38471383 LIMIT 5 [ RunTime:0.013262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471383 ORDER BY `minOrder` ASC [ RunTime:0.031808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38471383 ORDER BY `unit` DESC [ RunTime:0.056276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38471383 LIMIT 2 [ RunTime:0.047963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38471383 ORDER BY `minOrder` ASC [ RunTime:0.015779s ]
select * from pdf where partno='6083959' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083959' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021192s ]
SELECT `id` FROM `stock` WHERE `id` <> 38471383 AND `partno` = '6083959' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232906 [ RunTime:0.018411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38370696 LIMIT 5 [ RunTime:0.077447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38370696 ORDER BY `minOrder` ASC [ RunTime:0.090045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38370696 ORDER BY `unit` DESC [ RunTime:0.073285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38370696 LIMIT 2 [ RunTime:0.028156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38370696 ORDER BY `minOrder` ASC [ RunTime:0.036724s ]
select * from pdf where partno='6083987' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083987' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035340s ]
SELECT `id` FROM `stock` WHERE `id` <> 38370696 AND `partno` = '6083987' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818532 [ RunTime:0.021610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38364226 LIMIT 5 [ RunTime:0.036885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38364226 ORDER BY `minOrder` ASC [ RunTime:0.119603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38364226 ORDER BY `unit` DESC [ RunTime:0.019058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38364226 LIMIT 2 [ RunTime:0.067684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38364226 ORDER BY `minOrder` ASC [ RunTime:0.091351s ]
select * from pdf where partno='6083939' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6083939' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008931s ]
SELECT `id` FROM `stock` WHERE `id` <> 38364226 AND `partno` = '6083939' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182642 [ RunTime:0.018739s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012987s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064012s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036664s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013695s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004877s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019013s ]
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 '60839%' OR `brand` LIKE '60839%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056215s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60839%' OR `brand` LIKE '60839%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.072813s ]