SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001921s ]
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=11&srecordnum=10000' [ RunTime:0.003709s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003121s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000821s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001324s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001618s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003700s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001968s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000651s ]
UPDATE `stock_search` SET `count` = 103 , `updatetime` = '2026-06-11 00:55:15' WHERE `partno` = '228' [ RunTime:0.002795s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000989s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000381s ]
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.002383s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001718s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.309471s ]
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 200,20 [ RunTime:0.100853s ]
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 ('12504357','11403823','35478787','35267427','37435752','33479861','11334959','11409527','19264975','12504718','32270203','35617874','35617865','35617855','35617842','35617833','35617832','35617829','35617824','35617817') ORDER BY FIELD(s.id, 12504357,11403823,35478787,35267427,37435752,33479861,11334959,11409527,19264975,12504718,32270203,35617874,35617865,35617855,35617842,35617833,35617832,35617829,35617824,35617817) [ RunTime:0.006770s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504357 LIMIT 4 [ RunTime:0.002434s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504357 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504357 ORDER BY `unit` DESC [ RunTime:0.021515s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504357 LIMIT 2 [ RunTime:0.012292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504357 ORDER BY `minOrder` ASC [ RunTime:0.005257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11403823 LIMIT 4 [ RunTime:0.030045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11403823 ORDER BY `minOrder` ASC [ RunTime:0.011919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11403823 ORDER BY `unit` DESC [ RunTime:0.009633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11403823 LIMIT 2 [ RunTime:0.012730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11403823 ORDER BY `minOrder` ASC [ RunTime:0.007925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35478787 LIMIT 4 [ RunTime:0.030804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35478787 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35478787 ORDER BY `unit` DESC [ RunTime:0.041464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35478787 LIMIT 2 [ RunTime:0.010556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35478787 ORDER BY `minOrder` ASC [ RunTime:0.006463s ]
select * from pdf where partno='2287075-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010821s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2287075-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267427 LIMIT 4 [ RunTime:0.037155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267427 ORDER BY `minOrder` ASC [ RunTime:0.053827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267427 ORDER BY `unit` DESC [ RunTime:0.026149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267427 LIMIT 2 [ RunTime:0.034071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267427 ORDER BY `minOrder` ASC [ RunTime:0.032787s ]
select * from pdf where partno='228583-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.025179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228583-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.023070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37435752 LIMIT 4 [ RunTime:0.004697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37435752 ORDER BY `minOrder` ASC [ RunTime:0.055701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37435752 ORDER BY `unit` DESC [ RunTime:0.025764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37435752 LIMIT 2 [ RunTime:0.029339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37435752 ORDER BY `minOrder` ASC [ RunTime:0.003343s ]
select * from pdf where partno='22858' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.058211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22858' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.068563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33479861 LIMIT 4 [ RunTime:0.053234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479861 ORDER BY `minOrder` ASC [ RunTime:0.053207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33479861 ORDER BY `unit` DESC [ RunTime:0.088931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33479861 LIMIT 2 [ RunTime:0.092612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33479861 ORDER BY `minOrder` ASC [ RunTime:0.034392s ]
select * from pdf where partno='2288220-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.056609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2288220-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11334959 LIMIT 4 [ RunTime:0.109277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11334959 ORDER BY `minOrder` ASC [ RunTime:0.014414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11334959 ORDER BY `unit` DESC [ RunTime:0.020588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11334959 LIMIT 2 [ RunTime:0.003698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11334959 ORDER BY `minOrder` ASC [ RunTime:0.013810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409527 LIMIT 4 [ RunTime:0.073930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409527 ORDER BY `minOrder` ASC [ RunTime:0.026735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409527 ORDER BY `unit` DESC [ RunTime:0.065793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409527 LIMIT 2 [ RunTime:0.011259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409527 ORDER BY `minOrder` ASC [ RunTime:0.032480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264975 LIMIT 4 [ RunTime:0.039777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264975 ORDER BY `minOrder` ASC [ RunTime:0.044503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264975 ORDER BY `unit` DESC [ RunTime:0.018612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264975 LIMIT 2 [ RunTime:0.029901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264975 ORDER BY `minOrder` ASC [ RunTime:0.011467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504718 LIMIT 4 [ RunTime:0.036117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504718 ORDER BY `minOrder` ASC [ RunTime:0.017526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504718 ORDER BY `unit` DESC [ RunTime:0.017676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504718 LIMIT 2 [ RunTime:0.022305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504718 ORDER BY `minOrder` ASC [ RunTime:0.017494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270203 LIMIT 4 [ RunTime:0.009433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270203 ORDER BY `minOrder` ASC [ RunTime:0.027806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270203 ORDER BY `unit` DESC [ RunTime:0.095526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270203 LIMIT 2 [ RunTime:0.040337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270203 ORDER BY `minOrder` ASC [ RunTime:0.022000s ]
select * from pdf where partno='2287288-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.061048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2287288-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.044124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617874 LIMIT 4 [ RunTime:0.008350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617874 ORDER BY `minOrder` ASC [ RunTime:0.076647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617874 ORDER BY `unit` DESC [ RunTime:0.051870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617874 LIMIT 2 [ RunTime:0.067631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617874 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
select * from pdf where partno='2283671084' and brandshort='Molex' limit 1 [ RunTime:0.020907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2283671084' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.055126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617865 LIMIT 4 [ RunTime:0.053623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617865 ORDER BY `minOrder` ASC [ RunTime:0.016273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617865 ORDER BY `unit` DESC [ RunTime:0.039279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617865 LIMIT 2 [ RunTime:0.030431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617865 ORDER BY `minOrder` ASC [ RunTime:0.012392s ]
select * from pdf where partno='2284101042' and brandshort='Molex' limit 1 [ RunTime:0.039538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284101042' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617855 LIMIT 4 [ RunTime:0.024837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617855 ORDER BY `minOrder` ASC [ RunTime:0.055965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617855 ORDER BY `unit` DESC [ RunTime:0.025186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617855 LIMIT 2 [ RunTime:0.011585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617855 ORDER BY `minOrder` ASC [ RunTime:0.031065s ]
select * from pdf where partno='2284252064' and brandshort='Molex' limit 1 [ RunTime:0.011579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284252064' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.061866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617842 LIMIT 4 [ RunTime:0.104333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617842 ORDER BY `minOrder` ASC [ RunTime:0.055508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617842 ORDER BY `unit` DESC [ RunTime:0.112910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617842 LIMIT 2 [ RunTime:0.048661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617842 ORDER BY `minOrder` ASC [ RunTime:0.089795s ]
select * from pdf where partno='2283671082' and brandshort='Molex' limit 1 [ RunTime:0.052367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2283671082' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.172557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617833 LIMIT 4 [ RunTime:0.058169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617833 ORDER BY `minOrder` ASC [ RunTime:0.076838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617833 ORDER BY `unit` DESC [ RunTime:0.041940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617833 LIMIT 2 [ RunTime:0.048539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617833 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2284101022' and brandshort='Molex' limit 1 [ RunTime:0.048890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284101022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.108978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617832 LIMIT 4 [ RunTime:0.071239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617832 ORDER BY `minOrder` ASC [ RunTime:0.067894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617832 ORDER BY `unit` DESC [ RunTime:0.055579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617832 LIMIT 2 [ RunTime:0.027603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617832 ORDER BY `minOrder` ASC [ RunTime:0.070833s ]
select * from pdf where partno='2283631022' and brandshort='Molex' limit 1 [ RunTime:0.035292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2283631022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.038821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617829 LIMIT 4 [ RunTime:0.035730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617829 ORDER BY `minOrder` ASC [ RunTime:0.062497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617829 ORDER BY `unit` DESC [ RunTime:0.032531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617829 LIMIT 2 [ RunTime:0.051374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617829 ORDER BY `minOrder` ASC [ RunTime:0.016199s ]
select * from pdf where partno='2284262083' and brandshort='Molex' limit 1 [ RunTime:0.031838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2284262083' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617824 LIMIT 4 [ RunTime:0.012401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617824 ORDER BY `minOrder` ASC [ RunTime:0.011188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617824 ORDER BY `unit` DESC [ RunTime:0.018872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617824 LIMIT 2 [ RunTime:0.007143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617824 ORDER BY `minOrder` ASC [ RunTime:0.003978s ]
select * from pdf where partno='2283681083' and brandshort='Molex' limit 1 [ RunTime:0.008121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2283681083' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.035916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35617817 LIMIT 4 [ RunTime:0.017648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617817 ORDER BY `minOrder` ASC [ RunTime:0.021543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35617817 ORDER BY `unit` DESC [ RunTime:0.027058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35617817 LIMIT 2 [ RunTime:0.017280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35617817 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
select * from pdf where partno='2283671062' and brandshort='Molex' limit 1 [ RunTime:0.023454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2283671062' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.096643s ]
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.019286s ]