SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001221s ]
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://ic118.com/stock&keyword=SM15&page=6&srecordnum=548' [ RunTime:0.007611s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002337s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003352s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001560s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001480s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001578s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006999s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001290s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SM15' LIMIT 1 [ RunTime:0.017078s ]
UPDATE `stock_search` SET `count` = 3213 , `updatetime` = '2026-06-10 17:54:22' WHERE `partno` = 'SM15' [ RunTime:0.006928s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009999s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004079s ]
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.005191s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002577s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'SM15%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.027351s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'SM15%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.015011s ]
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 ('16664900','16664670','16679679','13907612','16664899','14802878','13907340','32700808','13364550','16681379','16664913','13364533','38728519','16664926','13907636','14802691','32700854','14803079','13364559','11169707') ORDER BY FIELD(s.id, 16664900,16664670,16679679,13907612,16664899,14802878,13907340,32700808,13364550,16681379,16664913,13364533,38728519,16664926,13907636,14802691,32700854,14803079,13364559,11169707) [ RunTime:0.032591s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664900 LIMIT 4 [ RunTime:0.029765s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664900 ORDER BY `minOrder` ASC [ RunTime:0.022786s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664900 ORDER BY `unit` DESC [ RunTime:0.043012s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664900 LIMIT 2 [ RunTime:0.024741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664900 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
select * from pdf where partno='SM15T36A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664670 LIMIT 4 [ RunTime:0.024467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664670 ORDER BY `minOrder` ASC [ RunTime:0.029571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664670 ORDER BY `unit` DESC [ RunTime:0.039986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664670 LIMIT 2 [ RunTime:0.044102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664670 ORDER BY `minOrder` ASC [ RunTime:0.001645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679679 LIMIT 4 [ RunTime:0.019000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679679 ORDER BY `minOrder` ASC [ RunTime:0.044783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679679 ORDER BY `unit` DESC [ RunTime:0.033005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679679 LIMIT 2 [ RunTime:0.053417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679679 ORDER BY `minOrder` ASC [ RunTime:0.026528s ]
select * from pdf where partno='SM15T27CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907612 LIMIT 4 [ RunTime:0.032729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907612 ORDER BY `minOrder` ASC [ RunTime:0.010457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907612 ORDER BY `unit` DESC [ RunTime:0.032387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907612 LIMIT 2 [ RunTime:0.049282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907612 ORDER BY `minOrder` ASC [ RunTime:0.021329s ]
select * from pdf where partno='SM15T150A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.053671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664899 LIMIT 4 [ RunTime:0.007184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664899 ORDER BY `minOrder` ASC [ RunTime:0.048648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664899 ORDER BY `unit` DESC [ RunTime:0.048083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664899 LIMIT 2 [ RunTime:0.032931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664899 ORDER BY `minOrder` ASC [ RunTime:0.018723s ]
select * from pdf where partno='SM15T10A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802878 LIMIT 4 [ RunTime:0.020250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802878 ORDER BY `minOrder` ASC [ RunTime:0.017636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802878 ORDER BY `unit` DESC [ RunTime:0.061657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802878 LIMIT 2 [ RunTime:0.038355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802878 ORDER BY `minOrder` ASC [ RunTime:0.010180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907340 LIMIT 4 [ RunTime:0.052023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907340 ORDER BY `minOrder` ASC [ RunTime:0.028479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907340 ORDER BY `unit` DESC [ RunTime:0.063895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907340 LIMIT 2 [ RunTime:0.014042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907340 ORDER BY `minOrder` ASC [ RunTime:0.002560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32700808 LIMIT 4 [ RunTime:0.016458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32700808 ORDER BY `minOrder` ASC [ RunTime:0.021526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32700808 ORDER BY `unit` DESC [ RunTime:0.010110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32700808 LIMIT 2 [ RunTime:0.035349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32700808 ORDER BY `minOrder` ASC [ RunTime:0.014920s ]
select * from pdf where partno='SM150508-7' and brandshort='DB Unlimited' limit 1 [ RunTime:0.017891s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM150508-7' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.041073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13364550 LIMIT 4 [ RunTime:0.028981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364550 ORDER BY `minOrder` ASC [ RunTime:0.012799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13364550 ORDER BY `unit` DESC [ RunTime:0.016079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13364550 LIMIT 2 [ RunTime:0.029916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364550 ORDER BY `minOrder` ASC [ RunTime:0.011560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681379 LIMIT 4 [ RunTime:0.033363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681379 ORDER BY `minOrder` ASC [ RunTime:0.056943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681379 ORDER BY `unit` DESC [ RunTime:0.030086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681379 LIMIT 2 [ RunTime:0.046281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681379 ORDER BY `minOrder` ASC [ RunTime:0.025371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664913 LIMIT 4 [ RunTime:0.052811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664913 ORDER BY `minOrder` ASC [ RunTime:0.017353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664913 ORDER BY `unit` DESC [ RunTime:0.027133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664913 LIMIT 2 [ RunTime:0.040687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664913 ORDER BY `minOrder` ASC [ RunTime:0.013925s ]
select * from pdf where partno='SM15T15A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13364533 LIMIT 4 [ RunTime:0.007252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364533 ORDER BY `minOrder` ASC [ RunTime:0.026737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13364533 ORDER BY `unit` DESC [ RunTime:0.015777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13364533 LIMIT 2 [ RunTime:0.008188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364533 ORDER BY `minOrder` ASC [ RunTime:0.011591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38728519 LIMIT 4 [ RunTime:0.013238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38728519 ORDER BY `minOrder` ASC [ RunTime:0.015940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38728519 ORDER BY `unit` DESC [ RunTime:0.043360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38728519 LIMIT 2 [ RunTime:0.019783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38728519 ORDER BY `minOrder` ASC [ RunTime:0.008713s ]
select * from pdf where partno='SM15-350RX' and brandshort='Riedon products by Bourns' limit 1 [ RunTime:0.026060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM15-350RX' OR `brand` LIKE 'Riedon products by Bourns%' ) ) LIMIT 1 [ RunTime:0.015528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664926 LIMIT 4 [ RunTime:0.027707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664926 ORDER BY `minOrder` ASC [ RunTime:0.029801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664926 ORDER BY `unit` DESC [ RunTime:0.030645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664926 LIMIT 2 [ RunTime:0.010743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664926 ORDER BY `minOrder` ASC [ RunTime:0.033967s ]
select * from pdf where partno='SM15T22CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.024978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907636 LIMIT 4 [ RunTime:0.031397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907636 ORDER BY `minOrder` ASC [ RunTime:0.041035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907636 ORDER BY `unit` DESC [ RunTime:0.052740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907636 LIMIT 2 [ RunTime:0.024569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907636 ORDER BY `minOrder` ASC [ RunTime:0.020194s ]
select * from pdf where partno='SM15T15CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.034575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802691 LIMIT 4 [ RunTime:0.028330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802691 ORDER BY `minOrder` ASC [ RunTime:0.032366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802691 ORDER BY `unit` DESC [ RunTime:0.029312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802691 LIMIT 2 [ RunTime:0.020241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802691 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
select * from pdf where partno='SM15-02HTG' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32700854 LIMIT 4 [ RunTime:0.024248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32700854 ORDER BY `minOrder` ASC [ RunTime:0.046346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32700854 ORDER BY `unit` DESC [ RunTime:0.025613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32700854 LIMIT 2 [ RunTime:0.036638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32700854 ORDER BY `minOrder` ASC [ RunTime:0.011606s ]
select * from pdf where partno='SM151708-1' and brandshort='DB Unlimited' limit 1 [ RunTime:0.022140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM151708-1' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.010160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803079 LIMIT 4 [ RunTime:0.005238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803079 ORDER BY `minOrder` ASC [ RunTime:0.015063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803079 ORDER BY `unit` DESC [ RunTime:0.043992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803079 LIMIT 2 [ RunTime:0.021598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803079 ORDER BY `minOrder` ASC [ RunTime:0.016121s ]
select * from pdf where partno='SM15T30A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.032932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13364559 LIMIT 4 [ RunTime:0.030319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364559 ORDER BY `minOrder` ASC [ RunTime:0.008814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13364559 ORDER BY `unit` DESC [ RunTime:0.026535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13364559 LIMIT 2 [ RunTime:0.086797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13364559 ORDER BY `minOrder` ASC [ RunTime:0.010186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11169707 LIMIT 4 [ RunTime:0.031191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11169707 ORDER BY `minOrder` ASC [ RunTime:0.019560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11169707 ORDER BY `unit` DESC [ RunTime:0.045563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11169707 LIMIT 2 [ RunTime:0.035103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11169707 ORDER BY `minOrder` ASC [ RunTime:0.025898s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SM15%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.010333s ]