SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002847s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=324&srecordnum=7402' [ RunTime:0.038571s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002891s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003880s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002409s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.009956s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003057s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006723s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002379s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008794s ]
UPDATE `stock_search` SET `count` = 4482 , `updatetime` = '2026-06-08 18:30:17' WHERE `partno` = '210' [ RunTime:0.002884s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.013643s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003565s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000890s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003037s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:1.053524s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 6460,20 [ RunTime:0.161891s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('13325773','13325769','13325688','13325658','13325631','13325618','13325595','13325594','13325571','13321024','13321022','13321021','13321020','13321018','13321017','13321016','13320885','13320883','13320836','13318325') ORDER BY FIELD(s.id, 13325773,13325769,13325688,13325658,13325631,13325618,13325595,13325594,13325571,13321024,13321022,13321021,13321020,13321018,13321017,13321016,13320885,13320883,13320836,13318325) [ RunTime:0.022850s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325773 LIMIT 4 [ RunTime:0.019972s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.011216s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325773 ORDER BY `unit` DESC [ RunTime:0.013589s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325773 LIMIT 2 [ RunTime:0.038690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325773 ORDER BY `minOrder` ASC [ RunTime:0.014824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325769 LIMIT 4 [ RunTime:0.018710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.035221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325769 ORDER BY `unit` DESC [ RunTime:0.022001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325769 LIMIT 2 [ RunTime:0.066798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.016170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325688 LIMIT 4 [ RunTime:0.086793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.028939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325688 ORDER BY `unit` DESC [ RunTime:0.059193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325688 LIMIT 2 [ RunTime:0.084318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325688 ORDER BY `minOrder` ASC [ RunTime:0.011006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325658 LIMIT 4 [ RunTime:0.035513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.092355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325658 ORDER BY `unit` DESC [ RunTime:0.060376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325658 LIMIT 2 [ RunTime:0.058692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325658 ORDER BY `minOrder` ASC [ RunTime:0.021005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325631 LIMIT 4 [ RunTime:0.017039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.049899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325631 ORDER BY `unit` DESC [ RunTime:0.065808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325631 LIMIT 2 [ RunTime:0.052804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325631 ORDER BY `minOrder` ASC [ RunTime:0.035635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325618 LIMIT 4 [ RunTime:0.039000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.017241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325618 ORDER BY `unit` DESC [ RunTime:0.061703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325618 LIMIT 2 [ RunTime:0.060977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325618 ORDER BY `minOrder` ASC [ RunTime:0.024351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325595 LIMIT 4 [ RunTime:0.033225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.026253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325595 ORDER BY `unit` DESC [ RunTime:0.043135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325595 LIMIT 2 [ RunTime:0.053455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325595 ORDER BY `minOrder` ASC [ RunTime:0.017615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325594 LIMIT 4 [ RunTime:0.016500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.047066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325594 ORDER BY `unit` DESC [ RunTime:0.051543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325594 LIMIT 2 [ RunTime:0.066132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.008066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 LIMIT 4 [ RunTime:0.007939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.055933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325571 ORDER BY `unit` DESC [ RunTime:0.095394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325571 LIMIT 2 [ RunTime:0.046357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.058858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321024 LIMIT 4 [ RunTime:0.014477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.033400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321024 ORDER BY `unit` DESC [ RunTime:0.039837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321024 LIMIT 2 [ RunTime:0.041807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321024 ORDER BY `minOrder` ASC [ RunTime:0.011850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321022 LIMIT 4 [ RunTime:0.041590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.055248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321022 ORDER BY `unit` DESC [ RunTime:0.098224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321022 LIMIT 2 [ RunTime:0.089200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321022 ORDER BY `minOrder` ASC [ RunTime:0.053952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321021 LIMIT 4 [ RunTime:0.054637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.058171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321021 ORDER BY `unit` DESC [ RunTime:0.053640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321021 LIMIT 2 [ RunTime:0.069943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321021 ORDER BY `minOrder` ASC [ RunTime:0.025427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321020 LIMIT 4 [ RunTime:0.052261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.104677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321020 ORDER BY `unit` DESC [ RunTime:0.090062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321020 LIMIT 2 [ RunTime:0.133097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321020 ORDER BY `minOrder` ASC [ RunTime:0.078373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321018 LIMIT 4 [ RunTime:0.093552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.101057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321018 ORDER BY `unit` DESC [ RunTime:0.079584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321018 LIMIT 2 [ RunTime:0.085749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321018 ORDER BY `minOrder` ASC [ RunTime:0.043117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321017 LIMIT 4 [ RunTime:0.051298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.091531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321017 ORDER BY `unit` DESC [ RunTime:0.111382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321017 LIMIT 2 [ RunTime:0.036196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321017 ORDER BY `minOrder` ASC [ RunTime:0.018073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321016 LIMIT 4 [ RunTime:0.056201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.079217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321016 ORDER BY `unit` DESC [ RunTime:0.032713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321016 LIMIT 2 [ RunTime:0.071763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321016 ORDER BY `minOrder` ASC [ RunTime:0.027846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320885 LIMIT 4 [ RunTime:0.044106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.051568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320885 ORDER BY `unit` DESC [ RunTime:0.025392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320885 LIMIT 2 [ RunTime:0.057880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320885 ORDER BY `minOrder` ASC [ RunTime:0.052424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320883 LIMIT 4 [ RunTime:0.055875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.052568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320883 ORDER BY `unit` DESC [ RunTime:0.024227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320883 LIMIT 2 [ RunTime:0.053162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320883 ORDER BY `minOrder` ASC [ RunTime:0.015291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320836 LIMIT 4 [ RunTime:0.026390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.018583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320836 ORDER BY `unit` DESC [ RunTime:0.077738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320836 LIMIT 2 [ RunTime:0.206294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320836 ORDER BY `minOrder` ASC [ RunTime:0.086132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13318325 LIMIT 4 [ RunTime:0.106457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13318325 ORDER BY `minOrder` ASC [ RunTime:0.039348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13318325 ORDER BY `unit` DESC [ RunTime:0.088613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13318325 LIMIT 2 [ RunTime:0.051743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13318325 ORDER BY `minOrder` ASC [ RunTime:0.058813s ]
select * from pdf where partno='2108-440-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.083094s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.010729s ]