SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001246s ]
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=228&page=8&srecordnum=10000' [ RunTime:0.001719s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001283s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001022s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001553s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.005616s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001648s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002828s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001470s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.001196s ]
UPDATE `stock_search` SET `count` = 105 , `updatetime` = '2026-06-11 00:55:15' WHERE `partno` = '228' [ RunTime:0.004988s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001510s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002128s ]
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.000863s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001909s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.292162s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 140,20 [ RunTime:0.094126s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('13976454','36737318','32912035','17285333','36736880','32912480','13973215','36737231','32911436','13973909','19520830','12504347','39244109','19520573','14892819','39228378','33479695','17285206','14908814','15186') ORDER BY FIELD(s.id, 13976454,36737318,32912035,17285333,36736880,32912480,13973215,36737231,32911436,13973909,19520830,12504347,39244109,19520573,14892819,39228378,33479695,17285206,14908814,15186) [ RunTime:0.005801s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976454 LIMIT 4 [ RunTime:0.002951s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976454 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976454 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976454 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976454 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36737318 LIMIT 4 [ RunTime:0.007975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36737318 ORDER BY `minOrder` ASC [ RunTime:0.027050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36737318 ORDER BY `unit` DESC [ RunTime:0.010020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36737318 LIMIT 2 [ RunTime:0.025663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36737318 ORDER BY `minOrder` ASC [ RunTime:0.013794s ]
select * from pdf where partno='2287' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.026453s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2287' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.033430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32912035 LIMIT 4 [ RunTime:0.031792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912035 ORDER BY `minOrder` ASC [ RunTime:0.039178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32912035 ORDER BY `unit` DESC [ RunTime:0.008983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32912035 LIMIT 2 [ RunTime:0.034175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912035 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
select * from pdf where partno='228FMVABBR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.073156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FMVABBR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17285333 LIMIT 4 [ RunTime:0.023091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17285333 ORDER BY `minOrder` ASC [ RunTime:0.038419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17285333 ORDER BY `unit` DESC [ RunTime:0.043680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17285333 LIMIT 2 [ RunTime:0.093202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17285333 ORDER BY `minOrder` ASC [ RunTime:0.037869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36736880 LIMIT 4 [ RunTime:0.025999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36736880 ORDER BY `minOrder` ASC [ RunTime:0.012818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36736880 ORDER BY `unit` DESC [ RunTime:0.047112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36736880 LIMIT 2 [ RunTime:0.075627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36736880 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='22873-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.081355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22873-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.058646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32912480 LIMIT 4 [ RunTime:0.042591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912480 ORDER BY `minOrder` ASC [ RunTime:0.076737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32912480 ORDER BY `unit` DESC [ RunTime:0.070870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32912480 LIMIT 2 [ RunTime:0.060780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912480 ORDER BY `minOrder` ASC [ RunTime:0.016998s ]
select * from pdf where partno='228ADS1AWFCN' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.056057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AWFCN' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13973215 LIMIT 4 [ RunTime:0.025592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973215 ORDER BY `minOrder` ASC [ RunTime:0.019404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13973215 ORDER BY `unit` DESC [ RunTime:0.042752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13973215 LIMIT 2 [ RunTime:0.025290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973215 ORDER BY `minOrder` ASC [ RunTime:0.016587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36737231 LIMIT 4 [ RunTime:0.009732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36737231 ORDER BY `minOrder` ASC [ RunTime:0.037841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36737231 ORDER BY `unit` DESC [ RunTime:0.029005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36737231 LIMIT 2 [ RunTime:0.016555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36737231 ORDER BY `minOrder` ASC [ RunTime:0.004080s ]
select * from pdf where partno='2284' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.006443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.041829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32911436 LIMIT 4 [ RunTime:0.034755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32911436 ORDER BY `minOrder` ASC [ RunTime:0.016490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32911436 ORDER BY `unit` DESC [ RunTime:0.048642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32911436 LIMIT 2 [ RunTime:0.035245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32911436 ORDER BY `minOrder` ASC [ RunTime:0.018998s ]
select * from pdf where partno='228ADS1AYFCN' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCN' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13973909 LIMIT 4 [ RunTime:0.038007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973909 ORDER BY `minOrder` ASC [ RunTime:0.039684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13973909 ORDER BY `unit` DESC [ RunTime:0.042956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13973909 LIMIT 2 [ RunTime:0.032019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973909 ORDER BY `minOrder` ASC [ RunTime:0.034927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19520830 LIMIT 4 [ RunTime:0.039323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520830 ORDER BY `minOrder` ASC [ RunTime:0.083511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19520830 ORDER BY `unit` DESC [ RunTime:0.038607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19520830 LIMIT 2 [ RunTime:0.035265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520830 ORDER BY `minOrder` ASC [ RunTime:0.035365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504347 LIMIT 4 [ RunTime:0.058230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504347 ORDER BY `minOrder` ASC [ RunTime:0.034080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504347 ORDER BY `unit` DESC [ RunTime:0.038103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504347 LIMIT 2 [ RunTime:0.046128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504347 ORDER BY `minOrder` ASC [ RunTime:0.024620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39244109 LIMIT 4 [ RunTime:0.048867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244109 ORDER BY `minOrder` ASC [ RunTime:0.027467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39244109 ORDER BY `unit` DESC [ RunTime:0.012965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39244109 LIMIT 2 [ RunTime:0.027001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244109 ORDER BY `minOrder` ASC [ RunTime:0.009817s ]
select * from pdf where partno='228SAK035M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.014036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228SAK035M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.042395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19520573 LIMIT 4 [ RunTime:0.035565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520573 ORDER BY `minOrder` ASC [ RunTime:0.015733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19520573 ORDER BY `unit` DESC [ RunTime:0.101323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19520573 LIMIT 2 [ RunTime:0.014807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520573 ORDER BY `minOrder` ASC [ RunTime:0.039790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14892819 LIMIT 4 [ RunTime:0.029579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892819 ORDER BY `minOrder` ASC [ RunTime:0.103513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14892819 ORDER BY `unit` DESC [ RunTime:0.068696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14892819 LIMIT 2 [ RunTime:0.071540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892819 ORDER BY `minOrder` ASC [ RunTime:0.013310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228378 LIMIT 4 [ RunTime:0.020081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228378 ORDER BY `minOrder` ASC [ RunTime:0.059679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228378 ORDER BY `unit` DESC [ RunTime:0.038720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228378 LIMIT 2 [ RunTime:0.020487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228378 ORDER BY `minOrder` ASC [ RunTime:0.045362s ]
select * from pdf where partno='228TTA063M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.198214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228TTA063M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.030475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33479695 LIMIT 4 [ RunTime:0.025916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479695 ORDER BY `minOrder` ASC [ RunTime:0.038205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33479695 ORDER BY `unit` DESC [ RunTime:0.055857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33479695 LIMIT 2 [ RunTime:0.100864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479695 ORDER BY `minOrder` ASC [ RunTime:0.009977s ]
select * from pdf where partno='2288218-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.040941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288218-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.067446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17285206 LIMIT 4 [ RunTime:0.009354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17285206 ORDER BY `minOrder` ASC [ RunTime:0.032161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17285206 ORDER BY `unit` DESC [ RunTime:0.047892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17285206 LIMIT 2 [ RunTime:0.057537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17285206 ORDER BY `minOrder` ASC [ RunTime:0.017888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14908814 LIMIT 4 [ RunTime:0.047813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14908814 ORDER BY `minOrder` ASC [ RunTime:0.024267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14908814 ORDER BY `unit` DESC [ RunTime:0.009527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14908814 LIMIT 2 [ RunTime:0.049524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14908814 ORDER BY `minOrder` ASC [ RunTime:0.023617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15186 LIMIT 4 [ RunTime:0.018708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15186 ORDER BY `minOrder` ASC [ RunTime:0.060724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15186 ORDER BY `unit` DESC [ RunTime:0.009043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15186 LIMIT 2 [ RunTime:0.011889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15186 ORDER BY `minOrder` ASC [ RunTime:0.014070s ]
select * from pdf where partno='228' and brandshort='KEYSTONE' limit 1 [ RunTime:0.002318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228' OR `brand` LIKE 'KEYSTONE%' ) ) LIMIT 1 [ RunTime:0.008836s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.016558s ]