SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001045s ]
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=99&srecordnum=7365' [ RunTime:0.009994s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001174s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003474s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001822s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.061547s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001912s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016470s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002864s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.015607s ]
UPDATE `stock_search` SET `count` = 4407 , `updatetime` = '2026-06-08 18:25:20' WHERE `partno` = '210' [ RunTime:0.004884s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006359s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.008145s ]
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.010278s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002602s ]
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:0.505052s ]
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 1960,20 [ RunTime:0.117600s ]
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 ('35495697','34448436','34448422','34448314','34448258','34402509','33837427','33619019','33618977','33618622','33618432','33411962','33154302','33129880','32850618','32310147','32174205','19509571','18702880','14672664') ORDER BY FIELD(s.id, 35495697,34448436,34448422,34448314,34448258,34402509,33837427,33619019,33618977,33618622,33618432,33411962,33154302,33129880,32850618,32310147,32174205,19509571,18702880,14672664) [ RunTime:0.033630s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35495697 LIMIT 4 [ RunTime:0.011476s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495697 ORDER BY `minOrder` ASC [ RunTime:0.012637s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35495697 ORDER BY `unit` DESC [ RunTime:0.020119s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35495697 LIMIT 2 [ RunTime:0.004032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495697 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
select * from pdf where partno='21035492301' and brandshort='HARTING' limit 1 [ RunTime:0.029333s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035492301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448436 LIMIT 4 [ RunTime:0.004307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448436 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448436 ORDER BY `unit` DESC [ RunTime:0.000938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448436 LIMIT 2 [ RunTime:0.005117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448436 ORDER BY `minOrder` ASC [ RunTime:0.006731s ]
select * from pdf where partno='21021851405' and brandshort='HARTING' limit 1 [ RunTime:0.013970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021851405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448422 LIMIT 4 [ RunTime:0.009634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448422 ORDER BY `minOrder` ASC [ RunTime:0.007051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448422 ORDER BY `unit` DESC [ RunTime:0.020404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448422 LIMIT 2 [ RunTime:0.008356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448422 ORDER BY `minOrder` ASC [ RunTime:0.003312s ]
select * from pdf where partno='21033892402' and brandshort='HARTING' limit 1 [ RunTime:0.019595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033892402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448314 LIMIT 4 [ RunTime:0.026684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448314 ORDER BY `minOrder` ASC [ RunTime:0.044537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448314 ORDER BY `unit` DESC [ RunTime:0.036710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448314 LIMIT 2 [ RunTime:0.024212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448314 ORDER BY `minOrder` ASC [ RunTime:0.038273s ]
select * from pdf where partno='21032122306' and brandshort='HARTING' limit 1 [ RunTime:0.035022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032122306' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.029173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448258 LIMIT 4 [ RunTime:0.075524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448258 ORDER BY `minOrder` ASC [ RunTime:0.011372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448258 ORDER BY `unit` DESC [ RunTime:0.030917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448258 LIMIT 2 [ RunTime:0.059424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448258 ORDER BY `minOrder` ASC [ RunTime:0.011824s ]
select * from pdf where partno='21032121407' and brandshort='HARTING' limit 1 [ RunTime:0.007063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032121407' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.013965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402509 LIMIT 4 [ RunTime:0.013015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402509 ORDER BY `minOrder` ASC [ RunTime:0.021691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402509 ORDER BY `unit` DESC [ RunTime:0.005314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402509 LIMIT 2 [ RunTime:0.021394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402509 ORDER BY `minOrder` ASC [ RunTime:0.004744s ]
select * from pdf where partno='21033814810' and brandshort='HARTING' limit 1 [ RunTime:0.013278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814810' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.040545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33837427 LIMIT 4 [ RunTime:0.033722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837427 ORDER BY `minOrder` ASC [ RunTime:0.043997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33837427 ORDER BY `unit` DESC [ RunTime:0.016659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33837427 LIMIT 2 [ RunTime:0.058489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837427 ORDER BY `minOrder` ASC [ RunTime:0.014725s ]
select * from pdf where partno='21033816403' and brandshort='HARTING' limit 1 [ RunTime:0.008778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033816403' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33619019 LIMIT 4 [ RunTime:0.026325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619019 ORDER BY `minOrder` ASC [ RunTime:0.027219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33619019 ORDER BY `unit` DESC [ RunTime:0.022006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33619019 LIMIT 2 [ RunTime:0.012977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619019 ORDER BY `minOrder` ASC [ RunTime:0.025017s ]
select * from pdf where partno='2106-1307' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-1307' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.046618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618977 LIMIT 4 [ RunTime:0.032030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618977 ORDER BY `minOrder` ASC [ RunTime:0.022661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618977 ORDER BY `unit` DESC [ RunTime:0.041817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618977 LIMIT 2 [ RunTime:0.032697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618977 ORDER BY `minOrder` ASC [ RunTime:0.017211s ]
select * from pdf where partno='2104-1207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.133435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.041457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618622 LIMIT 4 [ RunTime:0.085856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618622 ORDER BY `minOrder` ASC [ RunTime:0.088070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618622 ORDER BY `unit` DESC [ RunTime:0.068807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618622 LIMIT 2 [ RunTime:0.077357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618622 ORDER BY `minOrder` ASC [ RunTime:0.063301s ]
select * from pdf where partno='2104-1201' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.073812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1201' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.056690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618432 LIMIT 4 [ RunTime:0.083099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618432 ORDER BY `minOrder` ASC [ RunTime:0.066068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618432 ORDER BY `unit` DESC [ RunTime:0.065457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618432 LIMIT 2 [ RunTime:0.102055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618432 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
select * from pdf where partno='2102-5306' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.060287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5306' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.061724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33411962 LIMIT 4 [ RunTime:0.049918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33411962 ORDER BY `minOrder` ASC [ RunTime:0.034901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33411962 ORDER BY `unit` DESC [ RunTime:0.111277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33411962 LIMIT 2 [ RunTime:0.043286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33411962 ORDER BY `minOrder` ASC [ RunTime:0.012736s ]
select * from pdf where partno='21010000018' and brandshort='HARTING' limit 1 [ RunTime:0.026094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010000018' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.027299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33154302 LIMIT 4 [ RunTime:0.112487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33154302 ORDER BY `minOrder` ASC [ RunTime:0.161676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33154302 ORDER BY `unit` DESC [ RunTime:0.036287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33154302 LIMIT 2 [ RunTime:0.055854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33154302 ORDER BY `minOrder` ASC [ RunTime:0.013904s ]
select * from pdf where partno='2100FO' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.117498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100FO' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.021001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33129880 LIMIT 4 [ RunTime:0.055628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33129880 ORDER BY `minOrder` ASC [ RunTime:0.063323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33129880 ORDER BY `unit` DESC [ RunTime:0.120181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33129880 LIMIT 2 [ RunTime:0.070531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33129880 ORDER BY `minOrder` ASC [ RunTime:0.027087s ]
select * from pdf where partno='210-141' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.023120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-141' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.058361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32850618 LIMIT 4 [ RunTime:0.063921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32850618 ORDER BY `minOrder` ASC [ RunTime:0.061961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32850618 ORDER BY `unit` DESC [ RunTime:0.188228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32850618 LIMIT 2 [ RunTime:0.115583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32850618 ORDER BY `minOrder` ASC [ RunTime:0.024195s ]
select * from pdf where partno='210-852' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.049934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-852' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.048672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310147 LIMIT 4 [ RunTime:0.025571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310147 ORDER BY `minOrder` ASC [ RunTime:0.091331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310147 ORDER BY `unit` DESC [ RunTime:0.051773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310147 LIMIT 2 [ RunTime:0.094862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310147 ORDER BY `minOrder` ASC [ RunTime:0.011387s ]
select * from pdf where partno='21050-pc-serial-lp' and brandshort='startech' limit 1 [ RunTime:0.020044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21050-pc-serial-lp' OR `brand` LIKE 'startech%' ) ) LIMIT 1 [ RunTime:0.034520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32174205 LIMIT 4 [ RunTime:0.036265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32174205 ORDER BY `minOrder` ASC [ RunTime:0.025887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32174205 ORDER BY `unit` DESC [ RunTime:0.007446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32174205 LIMIT 2 [ RunTime:0.014866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32174205 ORDER BY `minOrder` ASC [ RunTime:0.008375s ]
select * from pdf where partno='21050-pc-serial-lp' and brandshort='startech' limit 1 [ RunTime:0.002197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21050-pc-serial-lp' OR `brand` LIKE 'startech%' ) ) LIMIT 1 [ RunTime:0.007246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509571 LIMIT 4 [ RunTime:0.011158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509571 ORDER BY `minOrder` ASC [ RunTime:0.061816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509571 ORDER BY `unit` DESC [ RunTime:0.016471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509571 LIMIT 2 [ RunTime:0.078083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509571 ORDER BY `minOrder` ASC [ RunTime:0.001843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702880 LIMIT 4 [ RunTime:0.038437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702880 ORDER BY `minOrder` ASC [ RunTime:0.066297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702880 ORDER BY `unit` DESC [ RunTime:0.099615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702880 LIMIT 2 [ RunTime:0.069252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702880 ORDER BY `minOrder` ASC [ RunTime:0.031948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14672664 LIMIT 4 [ RunTime:0.120139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672664 ORDER BY `minOrder` ASC [ RunTime:0.033369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14672664 ORDER BY `unit` DESC [ RunTime:0.035762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14672664 LIMIT 2 [ RunTime:0.062346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672664 ORDER BY `minOrder` ASC [ RunTime:0.076955s ]
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.026089s ]