SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002256s ]
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=10&srecordnum=10000' [ RunTime:0.003669s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001388s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003784s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001880s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002585s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001389s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004321s ]
UPDATE `stock_search` SET `count` = 106 , `updatetime` = '2026-06-11 00:55:15' WHERE `partno` = '228' [ RunTime:0.005581s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000873s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002591s ]
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.002775s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001257s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.285319s ]
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 180,20 [ RunTime:0.105808s ]
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 ('34279455','39238164','12496658','13565185','32269880','32254779','32254762','36451868','35267835','16433393','19775579','32270805','14890133','32912033','33446949','32270249','35267988','39244407','33479661','32255728') ORDER BY FIELD(s.id, 34279455,39238164,12496658,13565185,32269880,32254779,32254762,36451868,35267835,16433393,19775579,32270805,14890133,32912033,33446949,32270249,35267988,39244407,33479661,32255728) [ RunTime:0.011665s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279455 LIMIT 4 [ RunTime:0.018898s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279455 ORDER BY `minOrder` ASC [ RunTime:0.040642s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279455 ORDER BY `unit` DESC [ RunTime:0.007289s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279455 LIMIT 2 [ RunTime:0.012679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279455 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='2286250-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.014235s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2286250-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.032547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39238164 LIMIT 4 [ RunTime:0.002120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39238164 ORDER BY `minOrder` ASC [ RunTime:0.020360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39238164 ORDER BY `unit` DESC [ RunTime:0.019536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39238164 LIMIT 2 [ RunTime:0.016280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39238164 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
select * from pdf where partno='228CKH035M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.028240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CKH035M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.019212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12496658 LIMIT 4 [ RunTime:0.015726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12496658 ORDER BY `minOrder` ASC [ RunTime:0.062549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12496658 ORDER BY `unit` DESC [ RunTime:0.014908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12496658 LIMIT 2 [ RunTime:0.010439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12496658 ORDER BY `minOrder` ASC [ RunTime:0.025603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13565185 LIMIT 4 [ RunTime:0.026364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13565185 ORDER BY `minOrder` ASC [ RunTime:0.037874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13565185 ORDER BY `unit` DESC [ RunTime:0.011260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13565185 LIMIT 2 [ RunTime:0.019197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13565185 ORDER BY `minOrder` ASC [ RunTime:0.018291s ]
select * from pdf where partno='228003-01' and brandshort='Qualtek' limit 1 [ RunTime:0.032536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269880 LIMIT 4 [ RunTime:0.037705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269880 ORDER BY `minOrder` ASC [ RunTime:0.050928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269880 ORDER BY `unit` DESC [ RunTime:0.035400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269880 LIMIT 2 [ RunTime:0.144036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269880 ORDER BY `minOrder` ASC [ RunTime:0.031682s ]
select * from pdf where partno='2286118-1' and brandshort='te connectivity' limit 1 [ RunTime:0.084076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2286118-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.082071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254779 LIMIT 4 [ RunTime:0.031164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254779 ORDER BY `minOrder` ASC [ RunTime:0.053376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254779 ORDER BY `unit` DESC [ RunTime:0.056076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254779 LIMIT 2 [ RunTime:0.030846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254779 ORDER BY `minOrder` ASC [ RunTime:0.060105s ]
select * from pdf where partno='2288220-2' and brandshort='te connectivity' limit 1 [ RunTime:0.036370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288220-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.046201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254762 LIMIT 4 [ RunTime:0.033776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254762 ORDER BY `minOrder` ASC [ RunTime:0.035564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254762 ORDER BY `unit` DESC [ RunTime:0.051405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254762 LIMIT 2 [ RunTime:0.036961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254762 ORDER BY `minOrder` ASC [ RunTime:0.009763s ]
select * from pdf where partno='2288218-6' and brandshort='te connectivity' limit 1 [ RunTime:0.055209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288218-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.064968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36451868 LIMIT 4 [ RunTime:0.044552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36451868 ORDER BY `minOrder` ASC [ RunTime:0.017568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36451868 ORDER BY `unit` DESC [ RunTime:0.030419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36451868 LIMIT 2 [ RunTime:0.012509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36451868 ORDER BY `minOrder` ASC [ RunTime:0.026866s ]
select * from pdf where partno='22812.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.013384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22812.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.031625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267835 LIMIT 4 [ RunTime:0.053678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267835 ORDER BY `minOrder` ASC [ RunTime:0.058334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267835 ORDER BY `unit` DESC [ RunTime:0.021633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267835 LIMIT 2 [ RunTime:0.087564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267835 ORDER BY `minOrder` ASC [ RunTime:0.035302s ]
select * from pdf where partno='228A-P0Z00' and brandshort='ATTEND Technology' limit 1 [ RunTime:0.053352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228A-P0Z00' OR `brand` LIKE 'ATTEND Technology%' ) ) LIMIT 1 [ RunTime:0.024505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433393 LIMIT 4 [ RunTime:0.032110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433393 ORDER BY `minOrder` ASC [ RunTime:0.040434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433393 ORDER BY `unit` DESC [ RunTime:0.010648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433393 LIMIT 2 [ RunTime:0.089819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433393 ORDER BY `minOrder` ASC [ RunTime:0.021608s ]
select * from pdf where partno='22812.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.014171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775579 LIMIT 4 [ RunTime:0.040656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775579 ORDER BY `minOrder` ASC [ RunTime:0.053098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775579 ORDER BY `unit` DESC [ RunTime:0.027117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775579 LIMIT 2 [ RunTime:0.020412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775579 ORDER BY `minOrder` ASC [ RunTime:0.027680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270805 LIMIT 4 [ RunTime:0.027105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270805 ORDER BY `minOrder` ASC [ RunTime:0.019144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270805 ORDER BY `unit` DESC [ RunTime:0.031831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270805 LIMIT 2 [ RunTime:0.019544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270805 ORDER BY `minOrder` ASC [ RunTime:0.036601s ]
select * from pdf where partno='2286250-1' and brandshort='te connectivity' limit 1 [ RunTime:0.025899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2286250-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.067762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14890133 LIMIT 4 [ RunTime:0.047256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890133 ORDER BY `minOrder` ASC [ RunTime:0.065141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14890133 ORDER BY `unit` DESC [ RunTime:0.039996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14890133 LIMIT 2 [ RunTime:0.056714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890133 ORDER BY `minOrder` ASC [ RunTime:0.028726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32912033 LIMIT 4 [ RunTime:0.090286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912033 ORDER BY `minOrder` ASC [ RunTime:0.082628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32912033 ORDER BY `unit` DESC [ RunTime:0.182182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32912033 LIMIT 2 [ RunTime:0.136747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32912033 ORDER BY `minOrder` ASC [ RunTime:0.023120s ]
select * from pdf where partno='228FDVAWBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.045271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228FDVAWBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.039311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33446949 LIMIT 4 [ RunTime:0.063988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33446949 ORDER BY `minOrder` ASC [ RunTime:0.058624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33446949 ORDER BY `unit` DESC [ RunTime:0.016346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33446949 LIMIT 2 [ RunTime:0.169855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33446949 ORDER BY `minOrder` ASC [ RunTime:0.012868s ]
select * from pdf where partno='228596-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.106537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228596-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.044357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270249 LIMIT 4 [ RunTime:0.044563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270249 ORDER BY `minOrder` ASC [ RunTime:0.076511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270249 ORDER BY `unit` DESC [ RunTime:0.015389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270249 LIMIT 2 [ RunTime:0.015925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270249 ORDER BY `minOrder` ASC [ RunTime:0.008533s ]
select * from pdf where partno='2286123-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2286123-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.056941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267988 LIMIT 4 [ RunTime:0.025592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267988 ORDER BY `minOrder` ASC [ RunTime:0.015869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267988 ORDER BY `unit` DESC [ RunTime:0.011098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267988 LIMIT 2 [ RunTime:0.011917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267988 ORDER BY `minOrder` ASC [ RunTime:0.004875s ]
select * from pdf where partno='228A-PSZ00' and brandshort='ATTEND Technology' limit 1 [ RunTime:0.050923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228A-PSZ00' OR `brand` LIKE 'ATTEND Technology%' ) ) LIMIT 1 [ RunTime:0.019206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39244407 LIMIT 4 [ RunTime:0.005142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244407 ORDER BY `minOrder` ASC [ RunTime:0.049638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39244407 ORDER BY `unit` DESC [ RunTime:0.016533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39244407 LIMIT 2 [ RunTime:0.020964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39244407 ORDER BY `minOrder` ASC [ RunTime:0.006822s ]
select * from pdf where partno='228KXM050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.012018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228KXM050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.010608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33479661 LIMIT 4 [ RunTime:0.023368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479661 ORDER BY `minOrder` ASC [ RunTime:0.008583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33479661 ORDER BY `unit` DESC [ RunTime:0.018088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33479661 LIMIT 2 [ RunTime:0.032130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479661 ORDER BY `minOrder` ASC [ RunTime:0.027221s ]
select * from pdf where partno='2288221-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288221-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.025815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255728 LIMIT 4 [ RunTime:0.058389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255728 ORDER BY `minOrder` ASC [ RunTime:0.045111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255728 ORDER BY `unit` DESC [ RunTime:0.011492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255728 LIMIT 2 [ RunTime:0.002967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255728 ORDER BY `minOrder` ASC [ RunTime:0.005188s ]
select * from pdf where partno='2288221-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.011232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288221-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.006462s ]
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.019403s ]