SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001646s ]
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=25&srecordnum=548' [ RunTime:0.001872s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001701s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003002s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.004448s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001006s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001025s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SM15' LIMIT 1 [ RunTime:0.000438s ]
UPDATE `stock_search` SET `count` = 3221 , `updatetime` = '2026-06-10 19:03:51' WHERE `partno` = 'SM15' [ RunTime:0.001577s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000245s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000233s ]
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.002079s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001431s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'SM15%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.008190s ]
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 480,20 [ RunTime:0.013396s ]
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 ('13919037','13919036','13918993','13918518','13918517','13918514','13918513','13918512','13918470','13918469','13918468','13918467','13918466','13918462','13918461','13917967','13917966','13917965','13917964','13917963') ORDER BY FIELD(s.id, 13919037,13919036,13918993,13918518,13918517,13918514,13918513,13918512,13918470,13918469,13918468,13918467,13918466,13918462,13918461,13917967,13917966,13917965,13917964,13917963) [ RunTime:0.030452s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919037 LIMIT 4 [ RunTime:0.033736s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919037 ORDER BY `minOrder` ASC [ RunTime:0.016541s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919037 ORDER BY `unit` DESC [ RunTime:0.019061s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919037 LIMIT 2 [ RunTime:0.010360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919037 ORDER BY `minOrder` ASC [ RunTime:0.012687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919036 LIMIT 4 [ RunTime:0.007046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919036 ORDER BY `minOrder` ASC [ RunTime:0.011744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919036 ORDER BY `unit` DESC [ RunTime:0.024104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919036 LIMIT 2 [ RunTime:0.056875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919036 ORDER BY `minOrder` ASC [ RunTime:0.020348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918993 LIMIT 4 [ RunTime:0.029706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918993 ORDER BY `minOrder` ASC [ RunTime:0.018692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918993 ORDER BY `unit` DESC [ RunTime:0.009106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918993 LIMIT 2 [ RunTime:0.020933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918993 ORDER BY `minOrder` ASC [ RunTime:0.033790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918518 LIMIT 4 [ RunTime:0.022710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918518 ORDER BY `minOrder` ASC [ RunTime:0.015971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918518 ORDER BY `unit` DESC [ RunTime:0.039261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918518 LIMIT 2 [ RunTime:0.031343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918518 ORDER BY `minOrder` ASC [ RunTime:0.018315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918517 LIMIT 4 [ RunTime:0.041749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918517 ORDER BY `minOrder` ASC [ RunTime:0.034705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918517 ORDER BY `unit` DESC [ RunTime:0.049856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918517 LIMIT 2 [ RunTime:0.024870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918517 ORDER BY `minOrder` ASC [ RunTime:0.028194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918514 LIMIT 4 [ RunTime:0.025679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918514 ORDER BY `minOrder` ASC [ RunTime:0.032298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918514 ORDER BY `unit` DESC [ RunTime:0.029370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918514 LIMIT 2 [ RunTime:0.049846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918514 ORDER BY `minOrder` ASC [ RunTime:0.039870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918513 LIMIT 4 [ RunTime:0.074949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918513 ORDER BY `minOrder` ASC [ RunTime:0.017651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918513 ORDER BY `unit` DESC [ RunTime:0.093800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918513 LIMIT 2 [ RunTime:0.033186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918513 ORDER BY `minOrder` ASC [ RunTime:0.040356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918512 LIMIT 4 [ RunTime:0.012470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918512 ORDER BY `minOrder` ASC [ RunTime:0.086531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918512 ORDER BY `unit` DESC [ RunTime:0.077740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918512 LIMIT 2 [ RunTime:0.111910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918512 ORDER BY `minOrder` ASC [ RunTime:0.012472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918470 LIMIT 4 [ RunTime:0.043733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918470 ORDER BY `minOrder` ASC [ RunTime:0.023738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918470 ORDER BY `unit` DESC [ RunTime:0.013770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918470 LIMIT 2 [ RunTime:0.006583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918470 ORDER BY `minOrder` ASC [ RunTime:0.015927s ]
select * from pdf where partno='SM15T33CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918469 LIMIT 4 [ RunTime:0.018546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918469 ORDER BY `minOrder` ASC [ RunTime:0.018872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918469 ORDER BY `unit` DESC [ RunTime:0.016384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918469 LIMIT 2 [ RunTime:0.008706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918469 ORDER BY `minOrder` ASC [ RunTime:0.015123s ]
select * from pdf where partno='SM15T24CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.030401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918468 LIMIT 4 [ RunTime:0.026414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918468 ORDER BY `minOrder` ASC [ RunTime:0.026425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918468 ORDER BY `unit` DESC [ RunTime:0.072853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918468 LIMIT 2 [ RunTime:0.037802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918468 ORDER BY `minOrder` ASC [ RunTime:0.017691s ]
select * from pdf where partno='SM15T220CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918467 LIMIT 4 [ RunTime:0.003014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918467 ORDER BY `minOrder` ASC [ RunTime:0.025454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918467 ORDER BY `unit` DESC [ RunTime:0.043926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918467 LIMIT 2 [ RunTime:0.053381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918467 ORDER BY `minOrder` ASC [ RunTime:0.018782s ]
select * from pdf where partno='SM15T200CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918466 LIMIT 4 [ RunTime:0.049117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918466 ORDER BY `minOrder` ASC [ RunTime:0.018087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918466 ORDER BY `unit` DESC [ RunTime:0.019305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918466 LIMIT 2 [ RunTime:0.018302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918466 ORDER BY `minOrder` ASC [ RunTime:0.016725s ]
select * from pdf where partno='SM15T150CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.030933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918462 LIMIT 4 [ RunTime:0.018926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918462 ORDER BY `minOrder` ASC [ RunTime:0.026187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918462 ORDER BY `unit` DESC [ RunTime:0.007174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918462 LIMIT 2 [ RunTime:0.043463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918462 ORDER BY `minOrder` ASC [ RunTime:0.008522s ]
select * from pdf where partno='SM15T39CA-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918461 LIMIT 4 [ RunTime:0.012570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918461 ORDER BY `minOrder` ASC [ RunTime:0.047675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918461 ORDER BY `unit` DESC [ RunTime:0.033737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918461 LIMIT 2 [ RunTime:0.036918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918461 ORDER BY `minOrder` ASC [ RunTime:0.018935s ]
select * from pdf where partno='SM15T200CA-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.021575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917967 LIMIT 4 [ RunTime:0.026110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917967 ORDER BY `minOrder` ASC [ RunTime:0.007982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917967 ORDER BY `unit` DESC [ RunTime:0.034332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917967 LIMIT 2 [ RunTime:0.011136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917967 ORDER BY `minOrder` ASC [ RunTime:0.020324s ]
select * from pdf where partno='SM15T6V8CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.040118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917966 LIMIT 4 [ RunTime:0.046833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917966 ORDER BY `minOrder` ASC [ RunTime:0.011465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917966 ORDER BY `unit` DESC [ RunTime:0.024991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917966 LIMIT 2 [ RunTime:0.010325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917966 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
select * from pdf where partno='SM15T27CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917965 LIMIT 4 [ RunTime:0.036753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917965 ORDER BY `minOrder` ASC [ RunTime:0.020713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917965 ORDER BY `unit` DESC [ RunTime:0.039266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917965 LIMIT 2 [ RunTime:0.011119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917965 ORDER BY `minOrder` ASC [ RunTime:0.002298s ]
select * from pdf where partno='SM15T24CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.064798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917964 LIMIT 4 [ RunTime:0.008776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917964 ORDER BY `minOrder` ASC [ RunTime:0.031000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917964 ORDER BY `unit` DESC [ RunTime:0.051870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917964 LIMIT 2 [ RunTime:0.027252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917964 ORDER BY `minOrder` ASC [ RunTime:0.019937s ]
select * from pdf where partno='SM15T15CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917963 LIMIT 4 [ RunTime:0.010523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917963 ORDER BY `minOrder` ASC [ RunTime:0.023373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917963 ORDER BY `unit` DESC [ RunTime:0.057835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917963 LIMIT 2 [ RunTime:0.051966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917963 ORDER BY `minOrder` ASC [ RunTime:0.023983s ]
select * from pdf where partno='SM15T150CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.035137s ]
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.006709s ]