SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002192s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=221KH20&search=1' [ RunTime:0.002833s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001682s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001172s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001330s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001085s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001574s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001566s ]
SELECT * FROM `stock_search` WHERE `partno` = '221KH20' LIMIT 1 [ RunTime:0.004192s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 01:06:26' WHERE `partno` = '221KH20' [ RunTime:0.008213s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001336s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006837s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838424 LIMIT 5 [ RunTime:0.012088s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838424 ORDER BY `minOrder` ASC [ RunTime:0.003630s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838424 ORDER BY `unit` DESC [ RunTime:0.005952s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838424 LIMIT 2 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838424 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838423 LIMIT 5 [ RunTime:0.002290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838423 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838423 ORDER BY `unit` DESC [ RunTime:0.007132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838423 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838423 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838418 LIMIT 5 [ RunTime:0.004288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838418 ORDER BY `minOrder` ASC [ RunTime:0.001597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838418 ORDER BY `unit` DESC [ RunTime:0.000335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838418 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838418 ORDER BY `minOrder` ASC [ RunTime:0.001840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838416 LIMIT 5 [ RunTime:0.001705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838416 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838416 ORDER BY `unit` DESC [ RunTime:0.008076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838416 LIMIT 2 [ RunTime:0.001536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838416 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838415 LIMIT 5 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838415 ORDER BY `minOrder` ASC [ RunTime:0.005108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838415 ORDER BY `unit` DESC [ RunTime:0.004262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838415 LIMIT 2 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838415 ORDER BY `minOrder` ASC [ RunTime:0.002948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838414 LIMIT 5 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838414 ORDER BY `minOrder` ASC [ RunTime:0.001658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838414 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838414 LIMIT 2 [ RunTime:0.001513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838414 ORDER BY `minOrder` ASC [ RunTime:0.001984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838404 LIMIT 5 [ RunTime:0.005881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838404 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838404 ORDER BY `unit` DESC [ RunTime:0.001961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838404 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838404 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838403 LIMIT 5 [ RunTime:0.003374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838403 ORDER BY `minOrder` ASC [ RunTime:0.002023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838403 ORDER BY `unit` DESC [ RunTime:0.004750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838403 LIMIT 2 [ RunTime:0.004662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838403 ORDER BY `minOrder` ASC [ RunTime:0.010204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838402 LIMIT 5 [ RunTime:0.002918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838402 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838402 ORDER BY `unit` DESC [ RunTime:0.002483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838402 LIMIT 2 [ RunTime:0.004361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838402 ORDER BY `minOrder` ASC [ RunTime:0.001891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838401 LIMIT 5 [ RunTime:0.007779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838401 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838401 ORDER BY `unit` DESC [ RunTime:0.002662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838401 LIMIT 2 [ RunTime:0.007320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838401 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14838399 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838399 ORDER BY `minOrder` ASC [ RunTime:0.002116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14838399 ORDER BY `unit` DESC [ RunTime:0.006991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14838399 LIMIT 2 [ RunTime:0.003046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14838399 ORDER BY `minOrder` ASC [ RunTime:0.005360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837551 LIMIT 5 [ RunTime:0.006575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837551 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837551 ORDER BY `unit` DESC [ RunTime:0.006898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837551 LIMIT 2 [ RunTime:0.005791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837551 ORDER BY `minOrder` ASC [ RunTime:0.001505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837550 LIMIT 5 [ RunTime:0.001183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837550 ORDER BY `minOrder` ASC [ RunTime:0.018677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837550 ORDER BY `unit` DESC [ RunTime:0.001740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837550 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837550 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837549 LIMIT 5 [ RunTime:0.003362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837549 ORDER BY `minOrder` ASC [ RunTime:0.007539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837549 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837549 LIMIT 2 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837549 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837548 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837548 ORDER BY `minOrder` ASC [ RunTime:0.006996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837548 ORDER BY `unit` DESC [ RunTime:0.012212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837548 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837548 ORDER BY `minOrder` ASC [ RunTime:0.003149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837544 LIMIT 5 [ RunTime:0.009242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837544 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837544 ORDER BY `unit` DESC [ RunTime:0.007721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837544 LIMIT 2 [ RunTime:0.008413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837544 ORDER BY `minOrder` ASC [ RunTime:0.007317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837539 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837539 ORDER BY `minOrder` ASC [ RunTime:0.009132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837539 ORDER BY `unit` DESC [ RunTime:0.012020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837539 LIMIT 2 [ RunTime:0.008973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837539 ORDER BY `minOrder` ASC [ RunTime:0.008078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13937359 LIMIT 5 [ RunTime:0.001115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937359 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13937359 ORDER BY `unit` DESC [ RunTime:0.006816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13937359 LIMIT 2 [ RunTime:0.002997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937359 ORDER BY `minOrder` ASC [ RunTime:0.010158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13937356 LIMIT 5 [ RunTime:0.002565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937356 ORDER BY `minOrder` ASC [ RunTime:0.004135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13937356 ORDER BY `unit` DESC [ RunTime:0.003081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13937356 LIMIT 2 [ RunTime:0.011861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937356 ORDER BY `minOrder` ASC [ RunTime:0.005987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13937348 LIMIT 5 [ RunTime:0.007919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937348 ORDER BY `minOrder` ASC [ RunTime:0.007110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13937348 ORDER BY `unit` DESC [ RunTime:0.009940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13937348 LIMIT 2 [ RunTime:0.015808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13937348 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51120468 LIMIT 5 [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120468 ORDER BY `minOrder` ASC [ RunTime:0.023911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51120468 ORDER BY `unit` DESC [ RunTime:0.005085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51120468 LIMIT 2 [ RunTime:0.003183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120468 ORDER BY `minOrder` ASC [ RunTime:0.002490s ]
select * from pdf where partno='221kh20-at' and brandshort='yageo' limit 1 [ RunTime:0.008929s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221kh20-at' OR `brand` LIKE 'yageo%' ) ) LIMIT 1 [ RunTime:0.016566s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847240 LIMIT 5 [ RunTime:0.008464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847240 ORDER BY `minOrder` ASC [ RunTime:0.002420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847240 ORDER BY `unit` DESC [ RunTime:0.001514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847240 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847240 ORDER BY `minOrder` ASC [ RunTime:0.003113s ]
select * from pdf where partno='221KH20J-OP7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.008500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-OP7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847239 LIMIT 5 [ RunTime:0.001156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847239 ORDER BY `minOrder` ASC [ RunTime:0.003849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847239 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847239 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847239 ORDER BY `minOrder` ASC [ RunTime:0.006921s ]
select * from pdf where partno='221KH20J-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.006618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.022705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847235 LIMIT 5 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847235 ORDER BY `minOrder` ASC [ RunTime:0.024584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847235 ORDER BY `unit` DESC [ RunTime:0.018769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847235 LIMIT 2 [ RunTime:0.028424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847235 ORDER BY `minOrder` ASC [ RunTime:0.021421s ]
select * from pdf where partno='221KH20J-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.015860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847234 LIMIT 5 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847234 ORDER BY `minOrder` ASC [ RunTime:0.003572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847234 ORDER BY `unit` DESC [ RunTime:0.013472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847234 LIMIT 2 [ RunTime:0.012191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847234 ORDER BY `minOrder` ASC [ RunTime:0.004441s ]
select * from pdf where partno='221KH20J-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.022747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.014749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847233 LIMIT 5 [ RunTime:0.012316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847233 ORDER BY `minOrder` ASC [ RunTime:0.011691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847233 ORDER BY `unit` DESC [ RunTime:0.012077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847233 LIMIT 2 [ RunTime:0.010743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847233 ORDER BY `minOrder` ASC [ RunTime:0.002730s ]
select * from pdf where partno='221KH20J-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.009342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.023439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847232 LIMIT 5 [ RunTime:0.006865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847232 ORDER BY `minOrder` ASC [ RunTime:0.019471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847232 ORDER BY `unit` DESC [ RunTime:0.014603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847232 LIMIT 2 [ RunTime:0.017116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847232 ORDER BY `minOrder` ASC [ RunTime:0.006998s ]
select * from pdf where partno='221KH20J-FP7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.015906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-FP7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847225 LIMIT 5 [ RunTime:0.066412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847225 ORDER BY `minOrder` ASC [ RunTime:0.048696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847225 ORDER BY `unit` DESC [ RunTime:0.036018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847225 LIMIT 2 [ RunTime:0.029126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847225 ORDER BY `minOrder` ASC [ RunTime:0.012984s ]
select * from pdf where partno='221KH20J-OP7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.028161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-OP7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.032044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847224 LIMIT 5 [ RunTime:0.041903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847224 ORDER BY `minOrder` ASC [ RunTime:0.009032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847224 ORDER BY `unit` DESC [ RunTime:0.064859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847224 LIMIT 2 [ RunTime:0.032409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847224 ORDER BY `minOrder` ASC [ RunTime:0.025106s ]
select * from pdf where partno='221KH20J-FP7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.031441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-FP7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.077470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846245 LIMIT 5 [ RunTime:0.026941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846245 ORDER BY `minOrder` ASC [ RunTime:0.069446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846245 ORDER BY `unit` DESC [ RunTime:0.024815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846245 LIMIT 2 [ RunTime:0.032293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846245 ORDER BY `minOrder` ASC [ RunTime:0.006538s ]
select * from pdf where partno='221KH20J-TB' and brandshort='YAGEO' limit 1 [ RunTime:0.034354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.050026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846043 LIMIT 5 [ RunTime:0.074222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846043 ORDER BY `minOrder` ASC [ RunTime:0.173084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846043 ORDER BY `unit` DESC [ RunTime:0.082461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846043 LIMIT 2 [ RunTime:0.046668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846043 ORDER BY `minOrder` ASC [ RunTime:0.052249s ]
select * from pdf where partno='221KH20J-TR' and brandshort='YAGEO' limit 1 [ RunTime:0.049925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.055023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846042 LIMIT 5 [ RunTime:0.013362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846042 ORDER BY `minOrder` ASC [ RunTime:0.084031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846042 ORDER BY `unit` DESC [ RunTime:0.017924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846042 LIMIT 2 [ RunTime:0.138438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846042 ORDER BY `minOrder` ASC [ RunTime:0.010849s ]
select * from pdf where partno='221KH20J-P7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.056314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-P7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.028404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846041 LIMIT 5 [ RunTime:0.115465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846041 ORDER BY `minOrder` ASC [ RunTime:0.087233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846041 ORDER BY `unit` DESC [ RunTime:0.048256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846041 LIMIT 2 [ RunTime:0.089669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846041 ORDER BY `minOrder` ASC [ RunTime:0.018099s ]
select * from pdf where partno='221KH20J-P7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.090829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20J-P7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.088613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845377 LIMIT 5 [ RunTime:0.079593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845377 ORDER BY `minOrder` ASC [ RunTime:0.075746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845377 ORDER BY `unit` DESC [ RunTime:0.032969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845377 LIMIT 2 [ RunTime:0.084765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845377 ORDER BY `minOrder` ASC [ RunTime:0.004778s ]
select * from pdf where partno='221KH20-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.048368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.058367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845374 LIMIT 5 [ RunTime:0.035863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845374 ORDER BY `minOrder` ASC [ RunTime:0.026505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845374 ORDER BY `unit` DESC [ RunTime:0.006870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845374 LIMIT 2 [ RunTime:0.040723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845374 ORDER BY `minOrder` ASC [ RunTime:0.023946s ]
select * from pdf where partno='221KH20-FP7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.017579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-FP7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.022714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845373 LIMIT 5 [ RunTime:0.021650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845373 ORDER BY `minOrder` ASC [ RunTime:0.049746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845373 ORDER BY `unit` DESC [ RunTime:0.022232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845373 LIMIT 2 [ RunTime:0.020493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845373 ORDER BY `minOrder` ASC [ RunTime:0.071239s ]
select * from pdf where partno='221KH20-OP7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.037026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-OP7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845372 LIMIT 5 [ RunTime:0.058847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845372 ORDER BY `minOrder` ASC [ RunTime:0.034201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845372 ORDER BY `unit` DESC [ RunTime:0.030622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845372 LIMIT 2 [ RunTime:0.028124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845372 ORDER BY `minOrder` ASC [ RunTime:0.037611s ]
select * from pdf where partno='221KH20-OP7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.015590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-OP7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.071725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845370 LIMIT 5 [ RunTime:0.054835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845370 ORDER BY `minOrder` ASC [ RunTime:0.072678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845370 ORDER BY `unit` DESC [ RunTime:0.041073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845370 LIMIT 2 [ RunTime:0.035343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845370 ORDER BY `minOrder` ASC [ RunTime:0.039314s ]
select * from pdf where partno='221KH20-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.018330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.072236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845367 LIMIT 5 [ RunTime:0.097208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845367 ORDER BY `minOrder` ASC [ RunTime:0.054691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845367 ORDER BY `unit` DESC [ RunTime:0.097431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845367 LIMIT 2 [ RunTime:0.038884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845367 ORDER BY `minOrder` ASC [ RunTime:0.027188s ]
select * from pdf where partno='221KH20-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.019522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.049133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845364 LIMIT 5 [ RunTime:0.047583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845364 ORDER BY `minOrder` ASC [ RunTime:0.027291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845364 ORDER BY `unit` DESC [ RunTime:0.043996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845364 LIMIT 2 [ RunTime:0.034441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845364 ORDER BY `minOrder` ASC [ RunTime:0.005026s ]
select * from pdf where partno='221KH20-FP7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.056872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-FP7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.064903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41845362 LIMIT 5 [ RunTime:0.051525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845362 ORDER BY `minOrder` ASC [ RunTime:0.075870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41845362 ORDER BY `unit` DESC [ RunTime:0.032859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41845362 LIMIT 2 [ RunTime:0.086712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41845362 ORDER BY `minOrder` ASC [ RunTime:0.033875s ]
select * from pdf where partno='221KH20-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.023822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KH20-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.046378s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015139s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032932s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029785s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060527s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057328s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042249s ]
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 '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074973s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '221KH20%' OR `brand` LIKE '221KH20%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.044145s ]