SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002276s ]
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=6&srecordnum=10000' [ RunTime:0.002811s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002068s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000539s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002373s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.007527s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001981s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003706s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002381s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000713s ]
UPDATE `stock_search` SET `count` = 103 , `updatetime` = '2026-06-11 00:55:15' WHERE `partno` = '228' [ RunTime:0.002609s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000290s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000537s ]
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.000587s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002452s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.309592s ]
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 100,20 [ RunTime:0.113193s ]
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 ('12879896','33823774','32302087','32274248','14902150','32912479','36382949','19520284','14388483','35267172','14902972','14908070','13985067','12629984','13982276','35790608','39244573','14892988','35790612','35790594') ORDER BY FIELD(s.id, 12879896,33823774,32302087,32274248,14902150,32912479,36382949,19520284,14388483,35267172,14902972,14908070,13985067,12629984,13982276,35790608,39244573,14892988,35790612,35790594) [ RunTime:0.009413s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879896 LIMIT 4 [ RunTime:0.018672s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879896 ORDER BY `minOrder` ASC [ RunTime:0.030349s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879896 ORDER BY `unit` DESC [ RunTime:0.007076s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879896 LIMIT 2 [ RunTime:0.012694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879896 ORDER BY `minOrder` ASC [ RunTime:0.008684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33823774 LIMIT 4 [ RunTime:0.011077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33823774 ORDER BY `minOrder` ASC [ RunTime:0.033037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33823774 ORDER BY `unit` DESC [ RunTime:0.040925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33823774 LIMIT 2 [ RunTime:0.018536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33823774 ORDER BY `minOrder` ASC [ RunTime:0.009782s ]
select * from pdf where partno='228553-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007552s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228553-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302087 LIMIT 4 [ RunTime:0.077577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302087 ORDER BY `minOrder` ASC [ RunTime:0.014271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302087 ORDER BY `unit` DESC [ RunTime:0.018985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302087 LIMIT 2 [ RunTime:0.069754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302087 ORDER BY `minOrder` ASC [ RunTime:0.012880s ]
select * from pdf where partno='228553-1' and brandshort='te connectivity' limit 1 [ RunTime:0.023347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228553-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.052101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274248 LIMIT 4 [ RunTime:0.045580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274248 ORDER BY `minOrder` ASC [ RunTime:0.040857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274248 ORDER BY `unit` DESC [ RunTime:0.020658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274248 LIMIT 2 [ RunTime:0.035336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274248 ORDER BY `minOrder` ASC [ RunTime:0.030147s ]
select * from pdf where partno='228553-1' and brandshort='te connectivity' limit 1 [ RunTime:0.019386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228553-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14902150 LIMIT 4 [ RunTime:0.066172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902150 ORDER BY `minOrder` ASC [ RunTime:0.091476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14902150 ORDER BY `unit` DESC [ RunTime:0.069343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14902150 LIMIT 2 [ RunTime:0.039959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902150 ORDER BY `minOrder` ASC [ RunTime:0.022023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32912479 LIMIT 4 [ RunTime:0.054456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912479 ORDER BY `minOrder` ASC [ RunTime:0.029972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32912479 ORDER BY `unit` DESC [ RunTime:0.067987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32912479 LIMIT 2 [ RunTime:0.029465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912479 ORDER BY `minOrder` ASC [ RunTime:0.023947s ]
select * from pdf where partno='228EMSAAFR' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228EMSAAFR' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.041392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36382949 LIMIT 4 [ RunTime:0.027868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382949 ORDER BY `minOrder` ASC [ RunTime:0.025420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36382949 ORDER BY `unit` DESC [ RunTime:0.023073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36382949 LIMIT 2 [ RunTime:0.057125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382949 ORDER BY `minOrder` ASC [ RunTime:0.013142s ]
select * from pdf where partno='2285P 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.012657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2285P 0091000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.062229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19520284 LIMIT 4 [ RunTime:0.023442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520284 ORDER BY `minOrder` ASC [ RunTime:0.029530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19520284 ORDER BY `unit` DESC [ RunTime:0.039684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19520284 LIMIT 2 [ RunTime:0.023323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19520284 ORDER BY `minOrder` ASC [ RunTime:0.018712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14388483 LIMIT 4 [ RunTime:0.042977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388483 ORDER BY `minOrder` ASC [ RunTime:0.082208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14388483 ORDER BY `unit` DESC [ RunTime:0.072057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14388483 LIMIT 2 [ RunTime:0.059020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388483 ORDER BY `minOrder` ASC [ RunTime:0.013763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267172 LIMIT 4 [ RunTime:0.042409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267172 ORDER BY `minOrder` ASC [ RunTime:0.075877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267172 ORDER BY `unit` DESC [ RunTime:0.035392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267172 LIMIT 2 [ RunTime:0.032399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267172 ORDER BY `minOrder` ASC [ RunTime:0.018961s ]
select * from pdf where partno='2286546-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.052302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2286546-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.048468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14902972 LIMIT 4 [ RunTime:0.039282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902972 ORDER BY `minOrder` ASC [ RunTime:0.067546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14902972 ORDER BY `unit` DESC [ RunTime:0.044065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14902972 LIMIT 2 [ RunTime:0.044790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902972 ORDER BY `minOrder` ASC [ RunTime:0.008623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14908070 LIMIT 4 [ RunTime:0.021330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14908070 ORDER BY `minOrder` ASC [ RunTime:0.021406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14908070 ORDER BY `unit` DESC [ RunTime:0.030628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14908070 LIMIT 2 [ RunTime:0.014643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14908070 ORDER BY `minOrder` ASC [ RunTime:0.021788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13985067 LIMIT 4 [ RunTime:0.045311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13985067 ORDER BY `minOrder` ASC [ RunTime:0.022142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13985067 ORDER BY `unit` DESC [ RunTime:0.055454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13985067 LIMIT 2 [ RunTime:0.048011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13985067 ORDER BY `minOrder` ASC [ RunTime:0.005967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629984 LIMIT 4 [ RunTime:0.021962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629984 ORDER BY `minOrder` ASC [ RunTime:0.042642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629984 ORDER BY `unit` DESC [ RunTime:0.080269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629984 LIMIT 2 [ RunTime:0.045096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629984 ORDER BY `minOrder` ASC [ RunTime:0.027687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13982276 LIMIT 4 [ RunTime:0.050879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13982276 ORDER BY `minOrder` ASC [ RunTime:0.079972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13982276 ORDER BY `unit` DESC [ RunTime:0.019644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13982276 LIMIT 2 [ RunTime:0.040220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13982276 ORDER BY `minOrder` ASC [ RunTime:0.072916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35790608 LIMIT 4 [ RunTime:0.015379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790608 ORDER BY `minOrder` ASC [ RunTime:0.041379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35790608 ORDER BY `unit` DESC [ RunTime:0.128283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35790608 LIMIT 2 [ RunTime:0.011158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790608 ORDER BY `minOrder` ASC [ RunTime:0.024335s ]
select * from pdf where partno='2284322115' and brandshort='Molex' limit 1 [ RunTime:0.081723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284322115' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.075773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39244573 LIMIT 4 [ RunTime:0.030479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244573 ORDER BY `minOrder` ASC [ RunTime:0.055494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39244573 ORDER BY `unit` DESC [ RunTime:0.055081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39244573 LIMIT 2 [ RunTime:0.040367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244573 ORDER BY `minOrder` ASC [ RunTime:0.011611s ]
select * from pdf where partno='228RZM050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.072806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228RZM050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.045338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14892988 LIMIT 4 [ RunTime:0.071193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892988 ORDER BY `minOrder` ASC [ RunTime:0.035464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14892988 ORDER BY `unit` DESC [ RunTime:0.073244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14892988 LIMIT 2 [ RunTime:0.057062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14892988 ORDER BY `minOrder` ASC [ RunTime:0.019161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35790612 LIMIT 4 [ RunTime:0.010047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790612 ORDER BY `minOrder` ASC [ RunTime:0.039476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35790612 ORDER BY `unit` DESC [ RunTime:0.030174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35790612 LIMIT 2 [ RunTime:0.023926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790612 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
select * from pdf where partno='2284311115' and brandshort='Molex' limit 1 [ RunTime:0.011756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284311115' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.090202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35790594 LIMIT 4 [ RunTime:0.060358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790594 ORDER BY `minOrder` ASC [ RunTime:0.020985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35790594 ORDER BY `unit` DESC [ RunTime:0.018500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35790594 LIMIT 2 [ RunTime:0.001486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35790594 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
select * from pdf where partno='2284322114' and brandshort='Molex' limit 1 [ RunTime:0.022140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284322114' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022031s ]
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.038752s ]