SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002239s ]
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=8&srecordnum=1068' [ RunTime:0.002857s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002201s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002797s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002275s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003147s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002015s ]
SELECT * FROM `stock_search` WHERE `partno` = '724' LIMIT 1 [ RunTime:0.007122s ]
UPDATE `stock_search` SET `count` = 1324 , `updatetime` = '2026-06-13 10:33:58' WHERE `partno` = '724' [ RunTime:0.002228s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002497s ]
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 140,20 [ RunTime:0.062572s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147274 LIMIT 4 [ RunTime:0.036140s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147274 ORDER BY `minOrder` ASC [ RunTime:0.032516s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147274 ORDER BY `unit` DESC [ RunTime:0.005056s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.031112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147274 LIMIT 2 [ RunTime:0.013787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147274 ORDER BY `minOrder` ASC [ RunTime:0.034246s ]
select * from pdf where partno='72417SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.036547s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72417SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.018102s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147274 AND `partno` = '72417SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.060907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146447 LIMIT 4 [ RunTime:0.020803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146447 ORDER BY `minOrder` ASC [ RunTime:0.024249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146447 ORDER BY `unit` DESC [ RunTime:0.027435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146447 LIMIT 2 [ RunTime:0.008722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146447 ORDER BY `minOrder` ASC [ RunTime:0.024754s ]
select * from pdf where partno='72408CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.024173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72408CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.091950s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146447 AND `partno` = '72408CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.066062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068819 LIMIT 4 [ RunTime:0.043890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068819 ORDER BY `minOrder` ASC [ RunTime:0.047527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068819 ORDER BY `unit` DESC [ RunTime:0.076497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068819 LIMIT 2 [ RunTime:0.034125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068819 ORDER BY `minOrder` ASC [ RunTime:0.038934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065182 LIMIT 4 [ RunTime:0.020264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065182 ORDER BY `minOrder` ASC [ RunTime:0.037378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065182 ORDER BY `unit` DESC [ RunTime:0.041928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065182 LIMIT 2 [ RunTime:0.028753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065182 ORDER BY `minOrder` ASC [ RunTime:0.015822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065225 LIMIT 4 [ RunTime:0.031101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065225 ORDER BY `minOrder` ASC [ RunTime:0.039102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065225 ORDER BY `unit` DESC [ RunTime:0.005209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065225 LIMIT 2 [ RunTime:0.037234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065225 ORDER BY `minOrder` ASC [ RunTime:0.013507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147153 LIMIT 4 [ RunTime:0.055389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147153 ORDER BY `minOrder` ASC [ RunTime:0.043608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147153 ORDER BY `unit` DESC [ RunTime:0.040871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147153 LIMIT 2 [ RunTime:0.017418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147153 ORDER BY `minOrder` ASC [ RunTime:0.023966s ]
select * from pdf where partno='72455CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72455CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.040130s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147153 AND `partno` = '72455CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.028106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346032 [ RunTime:0.021724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146375 LIMIT 4 [ RunTime:0.094709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146375 ORDER BY `minOrder` ASC [ RunTime:0.052282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146375 ORDER BY `unit` DESC [ RunTime:0.045155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146375 LIMIT 2 [ RunTime:0.071024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146375 ORDER BY `minOrder` ASC [ RunTime:0.017970s ]
select * from pdf where partno='72409CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.025861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72409CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.027385s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146375 AND `partno` = '72409CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.067895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068819 [ RunTime:0.022952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346175 LIMIT 4 [ RunTime:0.013659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346175 ORDER BY `minOrder` ASC [ RunTime:0.025046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346175 ORDER BY `unit` DESC [ RunTime:0.022720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346175 LIMIT 2 [ RunTime:0.035704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346175 ORDER BY `minOrder` ASC [ RunTime:0.013596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147339 LIMIT 4 [ RunTime:0.041681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147339 ORDER BY `minOrder` ASC [ RunTime:0.037190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147339 ORDER BY `unit` DESC [ RunTime:0.062535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147339 LIMIT 2 [ RunTime:0.020332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147339 ORDER BY `minOrder` ASC [ RunTime:0.030198s ]
select * from pdf where partno='72428SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.019966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72428SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.027437s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147339 AND `partno` = '72428SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.025762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065182 [ RunTime:0.009517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068855 LIMIT 4 [ RunTime:0.018837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068855 ORDER BY `minOrder` ASC [ RunTime:0.012347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068855 ORDER BY `unit` DESC [ RunTime:0.046264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068855 LIMIT 2 [ RunTime:0.012040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068855 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065221 LIMIT 4 [ RunTime:0.021528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065221 ORDER BY `minOrder` ASC [ RunTime:0.053754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065221 ORDER BY `unit` DESC [ RunTime:0.011073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065221 LIMIT 2 [ RunTime:0.020034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065221 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147184 LIMIT 4 [ RunTime:0.023183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147184 ORDER BY `minOrder` ASC [ RunTime:0.026202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147184 ORDER BY `unit` DESC [ RunTime:0.030215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147184 LIMIT 2 [ RunTime:0.032831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147184 ORDER BY `minOrder` ASC [ RunTime:0.034548s ]
select * from pdf where partno='72426CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.029503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72426CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.028130s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147184 AND `partno` = '72426CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147582 LIMIT 4 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147582 ORDER BY `minOrder` ASC [ RunTime:0.009513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147582 ORDER BY `unit` DESC [ RunTime:0.011909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147582 LIMIT 2 [ RunTime:0.053657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147582 ORDER BY `minOrder` ASC [ RunTime:0.012287s ]
select * from pdf where partno='72472CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.050678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72472CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.033592s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147582 AND `partno` = '72472CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.050929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346223 [ RunTime:0.014445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346035 LIMIT 4 [ RunTime:0.021532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346035 ORDER BY `minOrder` ASC [ RunTime:0.029212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346035 ORDER BY `unit` DESC [ RunTime:0.035495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346035 LIMIT 2 [ RunTime:0.045700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346035 ORDER BY `minOrder` ASC [ RunTime:0.013236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065334 LIMIT 4 [ RunTime:0.054203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065334 ORDER BY `minOrder` ASC [ RunTime:0.050296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065334 ORDER BY `unit` DESC [ RunTime:0.020761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065334 LIMIT 2 [ RunTime:0.028781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065334 ORDER BY `minOrder` ASC [ RunTime:0.033429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346325 LIMIT 4 [ RunTime:0.040716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346325 ORDER BY `minOrder` ASC [ RunTime:0.034171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346325 ORDER BY `unit` DESC [ RunTime:0.029706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346325 LIMIT 2 [ RunTime:0.111365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346325 ORDER BY `minOrder` ASC [ RunTime:0.024347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19755941 LIMIT 4 [ RunTime:0.037986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19755941 ORDER BY `minOrder` ASC [ RunTime:0.056197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19755941 ORDER BY `unit` DESC [ RunTime:0.047520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19755941 LIMIT 2 [ RunTime:0.082960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19755941 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38148161 LIMIT 4 [ RunTime:0.015505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148161 ORDER BY `minOrder` ASC [ RunTime:0.038143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38148161 ORDER BY `unit` DESC [ RunTime:0.029722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38148161 LIMIT 2 [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148161 ORDER BY `minOrder` ASC [ RunTime:0.035300s ]
select * from pdf where partno='72480SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.051044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72480SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.028171s ]
SELECT `id` FROM `stock` WHERE `id` <> 38148161 AND `partno` = '72480SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.047393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065123 LIMIT 4 [ RunTime:0.036577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065123 ORDER BY `minOrder` ASC [ RunTime:0.044031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065123 ORDER BY `unit` DESC [ RunTime:0.060183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065123 LIMIT 2 [ RunTime:0.024679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065123 ORDER BY `minOrder` ASC [ RunTime:0.025316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13345969 LIMIT 4 [ RunTime:0.029038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345969 ORDER BY `minOrder` ASC [ RunTime:0.042344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13345969 ORDER BY `unit` DESC [ RunTime:0.061068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13345969 LIMIT 2 [ RunTime:0.089961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345969 ORDER BY `minOrder` ASC [ RunTime:0.043926s ]
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 140,20 [ RunTime:0.039612s ]
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.012152s ]
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.024166s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 127 [ RunTime:0.011089s ]