SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001308s ]
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=SMAJ12A&page=3&srecordnum=98' [ RunTime:0.014442s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001455s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.021747s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002436s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.011565s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002280s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001518s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002125s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ12A' LIMIT 1 [ RunTime:0.004228s ]
UPDATE `stock_search` SET `count` = 20553 , `updatetime` = '2026-06-12 22:29:15' WHERE `partno` = 'SMAJ12A' [ RunTime:0.004369s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002751s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ12A%' OR `brand` LIKE 'SMAJ12A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.045516s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159142 LIMIT 4 [ RunTime:0.051857s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159142 ORDER BY `minOrder` ASC [ RunTime:0.040778s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159142 ORDER BY `unit` DESC [ RunTime:0.042489s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.030028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159142 LIMIT 2 [ RunTime:0.002386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159142 ORDER BY `minOrder` ASC [ RunTime:0.003451s ]
select * from pdf where partno='SMAJ12A' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.051843s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.056337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801644 LIMIT 4 [ RunTime:0.013253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801644 ORDER BY `minOrder` ASC [ RunTime:0.054017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801644 ORDER BY `unit` DESC [ RunTime:0.017592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801644 LIMIT 2 [ RunTime:0.012749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801644 ORDER BY `minOrder` ASC [ RunTime:0.013033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150925 LIMIT 4 [ RunTime:0.036034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150925 ORDER BY `minOrder` ASC [ RunTime:0.018694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150925 ORDER BY `unit` DESC [ RunTime:0.012313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150925 LIMIT 2 [ RunTime:0.006439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150925 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
select * from pdf where partno='SMAJ12AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.024059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.006677s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150925 AND `partno` = 'SMAJ12AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.006002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928543 [ RunTime:0.013825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42110698 LIMIT 4 [ RunTime:0.039723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110698 ORDER BY `minOrder` ASC [ RunTime:0.008770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42110698 ORDER BY `unit` DESC [ RunTime:0.013997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42110698 LIMIT 2 [ RunTime:0.014218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110698 ORDER BY `minOrder` ASC [ RunTime:0.009946s ]
select * from pdf where partno='SMAJ12A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.009323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.010262s ]
SELECT `id` FROM `stock` WHERE `id` <> 42110698 AND `partno` = 'SMAJ12A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.053254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812715 [ RunTime:0.051976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802251 LIMIT 4 [ RunTime:0.029120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802251 ORDER BY `minOrder` ASC [ RunTime:0.019954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802251 ORDER BY `unit` DESC [ RunTime:0.036629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802251 LIMIT 2 [ RunTime:0.030592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802251 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42098381 LIMIT 4 [ RunTime:0.032602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42098381 ORDER BY `minOrder` ASC [ RunTime:0.032282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42098381 ORDER BY `unit` DESC [ RunTime:0.144788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42098381 LIMIT 2 [ RunTime:0.023668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42098381 ORDER BY `minOrder` ASC [ RunTime:0.061767s ]
select * from pdf where partno='SMAJ12A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.080307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.114378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159935 LIMIT 4 [ RunTime:0.076410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159935 ORDER BY `minOrder` ASC [ RunTime:0.103001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159935 ORDER BY `unit` DESC [ RunTime:0.098444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159935 LIMIT 2 [ RunTime:0.033277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159935 ORDER BY `minOrder` ASC [ RunTime:0.004766s ]
select * from pdf where partno='SMAJ12A' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.056816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.099951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803997 LIMIT 4 [ RunTime:0.091069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803997 ORDER BY `minOrder` ASC [ RunTime:0.039057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803997 ORDER BY `unit` DESC [ RunTime:0.065130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803997 LIMIT 2 [ RunTime:0.085454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803997 ORDER BY `minOrder` ASC [ RunTime:0.106560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668079 LIMIT 4 [ RunTime:0.029844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668079 ORDER BY `minOrder` ASC [ RunTime:0.034757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668079 ORDER BY `unit` DESC [ RunTime:0.045715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668079 LIMIT 2 [ RunTime:0.073341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668079 ORDER BY `minOrder` ASC [ RunTime:0.119668s ]
select * from pdf where partno='SMAJ12AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.044792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800316 LIMIT 4 [ RunTime:0.054929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800316 ORDER BY `minOrder` ASC [ RunTime:0.105880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800316 ORDER BY `unit` DESC [ RunTime:0.166232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800316 LIMIT 2 [ RunTime:0.062222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800316 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928548 LIMIT 4 [ RunTime:0.071771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928548 ORDER BY `minOrder` ASC [ RunTime:0.054234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928548 ORDER BY `unit` DESC [ RunTime:0.055704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928548 LIMIT 2 [ RunTime:0.068156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928548 ORDER BY `minOrder` ASC [ RunTime:0.010230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42125367 LIMIT 4 [ RunTime:0.066456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125367 ORDER BY `minOrder` ASC [ RunTime:0.042816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42125367 ORDER BY `unit` DESC [ RunTime:0.104663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42125367 LIMIT 2 [ RunTime:0.049930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125367 ORDER BY `minOrder` ASC [ RunTime:0.055711s ]
select * from pdf where partno='SMAJ12AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.033564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.030313s ]
SELECT `id` FROM `stock` WHERE `id` <> 42125367 AND `partno` = 'SMAJ12AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.038659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928548 [ RunTime:0.015370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800641 LIMIT 4 [ RunTime:0.008430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800641 ORDER BY `minOrder` ASC [ RunTime:0.014701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800641 ORDER BY `unit` DESC [ RunTime:0.015824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800641 LIMIT 2 [ RunTime:0.013322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800641 ORDER BY `minOrder` ASC [ RunTime:0.007249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662876 LIMIT 4 [ RunTime:0.002734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662876 ORDER BY `minOrder` ASC [ RunTime:0.016826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662876 ORDER BY `unit` DESC [ RunTime:0.012905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662876 LIMIT 2 [ RunTime:0.003181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662876 ORDER BY `minOrder` ASC [ RunTime:0.001385s ]
select * from pdf where partno='SMAJ12AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169474 LIMIT 4 [ RunTime:0.009395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169474 ORDER BY `minOrder` ASC [ RunTime:0.012194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169474 ORDER BY `unit` DESC [ RunTime:0.009645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169474 LIMIT 2 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169474 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='SMAJ12A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.005458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153857 LIMIT 4 [ RunTime:0.017443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153857 ORDER BY `minOrder` ASC [ RunTime:0.025504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153857 ORDER BY `unit` DESC [ RunTime:0.018855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153857 LIMIT 2 [ RunTime:0.020834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153857 ORDER BY `minOrder` ASC [ RunTime:0.008662s ]
select * from pdf where partno='SMAJ12AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002672s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153857 AND `partno` = 'SMAJ12AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.007832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662876 [ RunTime:0.008561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42171482 LIMIT 4 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171482 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42171482 ORDER BY `unit` DESC [ RunTime:0.018683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42171482 LIMIT 2 [ RunTime:0.020482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171482 ORDER BY `minOrder` ASC [ RunTime:0.042366s ]
select * from pdf where partno='SMAJ12A-HP6/7' and brandshort='YAGEO' limit 1 [ RunTime:0.028267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-HP6/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815148 LIMIT 4 [ RunTime:0.026299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815148 ORDER BY `minOrder` ASC [ RunTime:0.009094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815148 ORDER BY `unit` DESC [ RunTime:0.012427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815148 LIMIT 2 [ RunTime:0.005541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815148 ORDER BY `minOrder` ASC [ RunTime:0.003919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803305 LIMIT 4 [ RunTime:0.009086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803305 ORDER BY `minOrder` ASC [ RunTime:0.012353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803305 ORDER BY `unit` DESC [ RunTime:0.013709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803305 LIMIT 2 [ RunTime:0.027364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803305 ORDER BY `minOrder` ASC [ RunTime:0.008552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907786 LIMIT 4 [ RunTime:0.006568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907786 ORDER BY `minOrder` ASC [ RunTime:0.001307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907786 ORDER BY `unit` DESC [ RunTime:0.002797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907786 LIMIT 2 [ RunTime:0.029732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907786 ORDER BY `minOrder` ASC [ RunTime:0.006320s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ12A%' OR `brand` LIKE 'SMAJ12A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.004248s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ12A%' OR `brand` LIKE 'SMAJ12A%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.000564s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ12A%' OR `brand` LIKE 'SMAJ12A%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.000385s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (25,21) [ RunTime:0.000978s ]