SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002385s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=724&page=9&srecordnum=1068' [ RunTime:0.002941s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002281s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004479s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001511s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001383s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001177s ]
SELECT * FROM `stock_search` WHERE `partno` = '724' LIMIT 1 [ RunTime:0.000448s ]
UPDATE `stock_search` SET `count` = 1326 , `updatetime` = '2026-06-13 10:33:58' WHERE `partno` = '724' [ RunTime:0.002038s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001485s ]
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 '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 160,20 [ RunTime:0.051770s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068810 LIMIT 4 [ RunTime:0.024384s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068810 ORDER BY `minOrder` ASC [ RunTime:0.024425s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068810 ORDER BY `unit` DESC [ RunTime:0.008224s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068810 LIMIT 2 [ RunTime:0.072883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068810 ORDER BY `minOrder` ASC [ RunTime:0.035015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35485601 LIMIT 4 [ RunTime:0.018670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485601 ORDER BY `minOrder` ASC [ RunTime:0.056793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35485601 ORDER BY `unit` DESC [ RunTime:0.016349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35485601 LIMIT 2 [ RunTime:0.011111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485601 ORDER BY `minOrder` ASC [ RunTime:0.014626s ]
select * from pdf where partno='7242' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.028946s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7242' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.104214s ]
SELECT `id` FROM `stock` WHERE `id` <> 35485601 AND `partno` = '7242' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.071800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147275 LIMIT 4 [ RunTime:0.075693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147275 ORDER BY `minOrder` ASC [ RunTime:0.039975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147275 ORDER BY `unit` DESC [ RunTime:0.076046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147275 LIMIT 2 [ RunTime:0.010367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147275 ORDER BY `minOrder` ASC [ RunTime:0.003551s ]
select * from pdf where partno='72416SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.055762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72416SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.055237s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147275 AND `partno` = '72416SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.023690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346931 [ RunTime:0.042466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346119 LIMIT 4 [ RunTime:0.023652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346119 ORDER BY `minOrder` ASC [ RunTime:0.047068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346119 ORDER BY `unit` DESC [ RunTime:0.027699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346119 LIMIT 2 [ RunTime:0.025676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346119 ORDER BY `minOrder` ASC [ RunTime:0.012912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065146 LIMIT 4 [ RunTime:0.009669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065146 ORDER BY `minOrder` ASC [ RunTime:0.057542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065146 ORDER BY `unit` DESC [ RunTime:0.070912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065146 LIMIT 2 [ RunTime:0.065274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065146 ORDER BY `minOrder` ASC [ RunTime:0.077344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346147 LIMIT 4 [ RunTime:0.012597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346147 ORDER BY `minOrder` ASC [ RunTime:0.031311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346147 ORDER BY `unit` DESC [ RunTime:0.038812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346147 LIMIT 2 [ RunTime:0.045194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346147 ORDER BY `minOrder` ASC [ RunTime:0.028981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147842 LIMIT 4 [ RunTime:0.064362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147842 ORDER BY `minOrder` ASC [ RunTime:0.027645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147842 ORDER BY `unit` DESC [ RunTime:0.047872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147842 LIMIT 2 [ RunTime:0.095364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147842 ORDER BY `minOrder` ASC [ RunTime:0.036858s ]
select * from pdf where partno='72462SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72462SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.027663s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147842 AND `partno` = '72462SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.032640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346324 [ RunTime:0.029969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38148032 LIMIT 4 [ RunTime:0.054159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148032 ORDER BY `minOrder` ASC [ RunTime:0.035830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38148032 ORDER BY `unit` DESC [ RunTime:0.040728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38148032 LIMIT 2 [ RunTime:0.057060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148032 ORDER BY `minOrder` ASC [ RunTime:0.008186s ]
select * from pdf where partno='72474SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.052221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72474SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.045719s ]
SELECT `id` FROM `stock` WHERE `id` <> 38148032 AND `partno` = '72474SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.034724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065332 [ RunTime:0.028575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065317 LIMIT 4 [ RunTime:0.040003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065317 ORDER BY `minOrder` ASC [ RunTime:0.018136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065317 ORDER BY `unit` DESC [ RunTime:0.029946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065317 LIMIT 2 [ RunTime:0.022115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065317 ORDER BY `minOrder` ASC [ RunTime:0.027553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146400 LIMIT 4 [ RunTime:0.021654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146400 ORDER BY `minOrder` ASC [ RunTime:0.029033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146400 ORDER BY `unit` DESC [ RunTime:0.042496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146400 LIMIT 2 [ RunTime:0.007494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146400 ORDER BY `minOrder` ASC [ RunTime:0.028040s ]
select * from pdf where partno='72405CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.028641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72405CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010870s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146400 AND `partno` = '72405CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.065619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352201 [ RunTime:0.011916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352230 LIMIT 4 [ RunTime:0.021893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352230 ORDER BY `minOrder` ASC [ RunTime:0.051456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352230 ORDER BY `unit` DESC [ RunTime:0.052263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352230 LIMIT 2 [ RunTime:0.035737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352230 ORDER BY `minOrder` ASC [ RunTime:0.018029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346154 LIMIT 4 [ RunTime:0.038397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346154 ORDER BY `minOrder` ASC [ RunTime:0.023193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346154 ORDER BY `unit` DESC [ RunTime:0.038975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346154 LIMIT 2 [ RunTime:0.051823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346154 ORDER BY `minOrder` ASC [ RunTime:0.016708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346027 LIMIT 4 [ RunTime:0.018432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346027 ORDER BY `minOrder` ASC [ RunTime:0.013964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346027 ORDER BY `unit` DESC [ RunTime:0.075790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346027 LIMIT 2 [ RunTime:0.052315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346027 ORDER BY `minOrder` ASC [ RunTime:0.047722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346003 LIMIT 4 [ RunTime:0.030731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346003 ORDER BY `minOrder` ASC [ RunTime:0.062433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346003 ORDER BY `unit` DESC [ RunTime:0.017608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346003 LIMIT 2 [ RunTime:0.039045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346003 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346160 LIMIT 4 [ RunTime:0.038046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346160 ORDER BY `minOrder` ASC [ RunTime:0.052229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346160 ORDER BY `unit` DESC [ RunTime:0.053647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346160 LIMIT 2 [ RunTime:0.042957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346160 ORDER BY `minOrder` ASC [ RunTime:0.079658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147563 LIMIT 4 [ RunTime:0.038223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147563 ORDER BY `minOrder` ASC [ RunTime:0.065861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147563 ORDER BY `unit` DESC [ RunTime:0.028453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147563 LIMIT 2 [ RunTime:0.071882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147563 ORDER BY `minOrder` ASC [ RunTime:0.047037s ]
select * from pdf where partno='72420SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.043092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72420SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.045541s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147563 AND `partno` = '72420SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.035470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346214 [ RunTime:0.047355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346214 LIMIT 4 [ RunTime:0.028395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346214 ORDER BY `minOrder` ASC [ RunTime:0.035086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346214 ORDER BY `unit` DESC [ RunTime:0.059232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346214 LIMIT 2 [ RunTime:0.097190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346214 ORDER BY `minOrder` ASC [ RunTime:0.029811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147154 LIMIT 4 [ RunTime:0.048621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147154 ORDER BY `minOrder` ASC [ RunTime:0.080866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147154 ORDER BY `unit` DESC [ RunTime:0.034143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147154 LIMIT 2 [ RunTime:0.062270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147154 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
select * from pdf where partno='72457CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.042303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72457CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.030608s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147154 AND `partno` = '72457CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.056585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346012 LIMIT 4 [ RunTime:0.051133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346012 ORDER BY `minOrder` ASC [ RunTime:0.033536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346012 ORDER BY `unit` DESC [ RunTime:0.023665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346012 LIMIT 2 [ RunTime:0.028839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346012 ORDER BY `minOrder` ASC [ RunTime:0.024767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237 LIMIT 4 [ RunTime:0.030995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237 ORDER BY `minOrder` ASC [ RunTime:0.019216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16237 ORDER BY `unit` DESC [ RunTime:0.023880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16237 LIMIT 2 [ RunTime:0.012057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237 ORDER BY `minOrder` ASC [ RunTime:0.004338s ]
select * from pdf where partno='724' and brandshort='SCS' limit 1 [ RunTime:0.007590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '724' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.015815s ]
SELECT `id` FROM `stock` WHERE `id` <> 16237 AND `partno` = '724' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.020108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10088 [ RunTime:0.005934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19507664 [ RunTime:0.019227s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 160,20 [ RunTime:0.031592s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.012708s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.000569s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 127 [ RunTime:0.022811s ]