SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001495s ]
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=2&srecordnum=98' [ RunTime:0.010959s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001493s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002375s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001812s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.009879s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001307s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003420s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001210s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ12A' LIMIT 1 [ RunTime:0.016796s ]
UPDATE `stock_search` SET `count` = 20552 , `updatetime` = '2026-06-12 22:28:54' WHERE `partno` = 'SMAJ12A' [ RunTime:0.007726s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001674s ]
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 20,20 [ RunTime:0.046044s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095146 LIMIT 4 [ RunTime:0.014894s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095146 ORDER BY `minOrder` ASC [ RunTime:0.028111s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095146 ORDER BY `unit` DESC [ RunTime:0.093625s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095146 LIMIT 2 [ RunTime:0.123931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095146 ORDER BY `minOrder` ASC [ RunTime:0.058559s ]
select * from pdf where partno='SMAJ12A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.208201s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.098267s ]
SELECT `id` FROM `stock` WHERE `id` <> 42095146 AND `partno` = 'SMAJ12A-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.187140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801827 [ RunTime:0.068035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42148362 LIMIT 4 [ RunTime:0.044506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148362 ORDER BY `minOrder` ASC [ RunTime:0.132134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42148362 ORDER BY `unit` DESC [ RunTime:0.090780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42148362 LIMIT 2 [ RunTime:0.050878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148362 ORDER BY `minOrder` ASC [ RunTime:0.024631s ]
select * from pdf where partno='SMAJ12A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.031484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.051458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687367 LIMIT 4 [ RunTime:0.034174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687367 ORDER BY `minOrder` ASC [ RunTime:0.064591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687367 ORDER BY `unit` DESC [ RunTime:0.062938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687367 LIMIT 2 [ RunTime:0.096592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687367 ORDER BY `minOrder` ASC [ RunTime:0.014197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799729 LIMIT 4 [ RunTime:0.104098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799729 ORDER BY `minOrder` ASC [ RunTime:0.082566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799729 ORDER BY `unit` DESC [ RunTime:0.069170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799729 LIMIT 2 [ RunTime:0.101276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799729 ORDER BY `minOrder` ASC [ RunTime:0.043945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113010 LIMIT 4 [ RunTime:0.033986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113010 ORDER BY `minOrder` ASC [ RunTime:0.058196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113010 ORDER BY `unit` DESC [ RunTime:0.073163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113010 LIMIT 2 [ RunTime:0.076262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113010 ORDER BY `minOrder` ASC [ RunTime:0.023407s ]
select * from pdf where partno='SMAJ12AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.064452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12AQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.059137s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113010 AND `partno` = 'SMAJ12AQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.074870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668079 [ RunTime:0.010920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42139625 LIMIT 4 [ RunTime:0.045253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42139625 ORDER BY `minOrder` ASC [ RunTime:0.052948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42139625 ORDER BY `unit` DESC [ RunTime:0.034109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42139625 LIMIT 2 [ RunTime:0.024238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42139625 ORDER BY `minOrder` ASC [ RunTime:0.004775s ]
select * from pdf where partno='SMAJ12A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.012768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.005957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814753 LIMIT 4 [ RunTime:0.028541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814753 ORDER BY `minOrder` ASC [ RunTime:0.066987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814753 ORDER BY `unit` DESC [ RunTime:0.020192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814753 LIMIT 2 [ RunTime:0.033127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814753 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
select * from pdf where partno='SMAJ12A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113013 LIMIT 4 [ RunTime:0.052395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113013 ORDER BY `minOrder` ASC [ RunTime:0.031887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113013 ORDER BY `unit` DESC [ RunTime:0.048129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113013 LIMIT 2 [ RunTime:0.049130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113013 ORDER BY `minOrder` ASC [ RunTime:0.034413s ]
select * from pdf where partno='SMAJ12A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.031938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.041354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927494 LIMIT 4 [ RunTime:0.052562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927494 ORDER BY `minOrder` ASC [ RunTime:0.108029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13927494 ORDER BY `unit` DESC [ RunTime:0.069818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13927494 LIMIT 2 [ RunTime:0.007340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927494 ORDER BY `minOrder` ASC [ RunTime:0.039307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128222 LIMIT 4 [ RunTime:0.013591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128222 ORDER BY `minOrder` ASC [ RunTime:0.107705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128222 ORDER BY `unit` DESC [ RunTime:0.038886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128222 LIMIT 2 [ RunTime:0.021715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128222 ORDER BY `minOrder` ASC [ RunTime:0.056239s ]
select * from pdf where partno='SMAJ12AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019361s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128222 AND `partno` = 'SMAJ12AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.152629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927494 [ RunTime:0.122017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162551 LIMIT 4 [ RunTime:0.107662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162551 ORDER BY `minOrder` ASC [ RunTime:0.055510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162551 ORDER BY `unit` DESC [ RunTime:0.031480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162551 LIMIT 2 [ RunTime:0.116538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162551 ORDER BY `minOrder` ASC [ RunTime:0.127207s ]
select * from pdf where partno='SMAJ12A-A' and brandshort='Yenyo Technology' limit 1 [ RunTime:0.042615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-A' OR `brand` LIKE 'Yenyo Technology%' ) ) LIMIT 1 [ RunTime:0.049298s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162551 AND `partno` = 'SMAJ12A-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yenyo technology%' ) [ RunTime:0.015387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663707 [ RunTime:0.013350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663707 LIMIT 4 [ RunTime:0.087689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663707 ORDER BY `minOrder` ASC [ RunTime:0.185948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663707 ORDER BY `unit` DESC [ RunTime:0.084070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663707 LIMIT 2 [ RunTime:0.078639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663707 ORDER BY `minOrder` ASC [ RunTime:0.046032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905858 LIMIT 4 [ RunTime:0.051263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905858 ORDER BY `minOrder` ASC [ RunTime:0.039873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905858 ORDER BY `unit` DESC [ RunTime:0.043941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905858 LIMIT 2 [ RunTime:0.148428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905858 ORDER BY `minOrder` ASC [ RunTime:0.011486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827907 LIMIT 4 [ RunTime:0.171025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827907 ORDER BY `minOrder` ASC [ RunTime:0.039248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827907 ORDER BY `unit` DESC [ RunTime:0.051370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827907 LIMIT 2 [ RunTime:0.040793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827907 ORDER BY `minOrder` ASC [ RunTime:0.026089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42125395 LIMIT 4 [ RunTime:0.114600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125395 ORDER BY `minOrder` ASC [ RunTime:0.071885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42125395 ORDER BY `unit` DESC [ RunTime:0.037503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42125395 LIMIT 2 [ RunTime:0.058630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125395 ORDER BY `minOrder` ASC [ RunTime:0.014796s ]
select * from pdf where partno='SMAJ12A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.059334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.021741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111557 LIMIT 4 [ RunTime:0.022936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111557 ORDER BY `minOrder` ASC [ RunTime:0.061368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111557 ORDER BY `unit` DESC [ RunTime:0.019437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111557 LIMIT 2 [ RunTime:0.039681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111557 ORDER BY `minOrder` ASC [ RunTime:0.009328s ]
select * from pdf where partno='SMAJ12A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.031298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.017602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42100206 LIMIT 4 [ RunTime:0.043172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100206 ORDER BY `minOrder` ASC [ RunTime:0.042714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42100206 ORDER BY `unit` DESC [ RunTime:0.087306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42100206 LIMIT 2 [ RunTime:0.074640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100206 ORDER BY `minOrder` ASC [ RunTime:0.046859s ]
select * from pdf where partno='SMAJ12A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009924s ]
SELECT `id` FROM `stock` WHERE `id` <> 42100206 AND `partno` = 'SMAJ12A-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.030390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814753 [ RunTime:0.047605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150477 LIMIT 4 [ RunTime:0.015729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150477 ORDER BY `minOrder` ASC [ RunTime:0.096382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150477 ORDER BY `unit` DESC [ RunTime:0.122743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150477 LIMIT 2 [ RunTime:0.021767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150477 ORDER BY `minOrder` ASC [ RunTime:0.011100s ]
select * from pdf where partno='SMAJ12A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.028963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.027309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928543 LIMIT 4 [ RunTime:0.059693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928543 ORDER BY `minOrder` ASC [ RunTime:0.024869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928543 ORDER BY `unit` DESC [ RunTime:0.040904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928543 LIMIT 2 [ RunTime:0.026848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928543 ORDER BY `minOrder` ASC [ RunTime:0.039595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812715 LIMIT 4 [ RunTime:0.037907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812715 ORDER BY `minOrder` ASC [ RunTime:0.060079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812715 ORDER BY `unit` DESC [ RunTime:0.016312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812715 LIMIT 2 [ RunTime:0.023810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812715 ORDER BY `minOrder` ASC [ RunTime:0.022336s ]
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 20,20 [ RunTime:0.034935s ]
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.046523s ]
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.063168s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (25,21) [ RunTime:0.113566s ]