SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002819s ]
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=SMCJ15A&page=1&srecordnum=51' [ RunTime:0.008767s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003176s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002575s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003361s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001897s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001184s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ15A' LIMIT 1 [ RunTime:0.000389s ]
UPDATE `stock_search` SET `count` = 18362 , `updatetime` = '2026-06-10 21:23:08' WHERE `partno` = 'SMCJ15A' [ RunTime:0.006633s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000178s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000161s ]
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.000588s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001659s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'SMCJ15A%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.011560s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'SMCJ15A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007440s ]
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 ('16669547','16678854','14808333','16688508','16665046','14820072','13905275','14802175','14816380','14802159','14800085','14832596','16662790','16663798','14833664','16663130','14802728','4824','16692465','16692464') ORDER BY FIELD(s.id, 16669547,16678854,14808333,16688508,16665046,14820072,13905275,14802175,14816380,14802159,14800085,14832596,16662790,16663798,14833664,16663130,14802728,4824,16692465,16692464) [ RunTime:0.010200s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669547 LIMIT 4 [ RunTime:0.020409s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669547 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669547 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669547 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669547 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678854 LIMIT 4 [ RunTime:0.003219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678854 ORDER BY `minOrder` ASC [ RunTime:0.004357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678854 ORDER BY `unit` DESC [ RunTime:0.009643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678854 LIMIT 2 [ RunTime:0.004729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678854 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808333 LIMIT 4 [ RunTime:0.003457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808333 ORDER BY `minOrder` ASC [ RunTime:0.009949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808333 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808333 LIMIT 2 [ RunTime:0.002229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808333 ORDER BY `minOrder` ASC [ RunTime:0.003597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688508 LIMIT 4 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688508 ORDER BY `minOrder` ASC [ RunTime:0.003424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688508 ORDER BY `unit` DESC [ RunTime:0.003090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688508 LIMIT 2 [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688508 ORDER BY `minOrder` ASC [ RunTime:0.002058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665046 LIMIT 4 [ RunTime:0.004144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665046 ORDER BY `minOrder` ASC [ RunTime:0.003152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665046 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665046 LIMIT 2 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665046 ORDER BY `minOrder` ASC [ RunTime:0.002828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820072 LIMIT 4 [ RunTime:0.003543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820072 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820072 ORDER BY `unit` DESC [ RunTime:0.002211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820072 LIMIT 2 [ RunTime:0.001856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820072 ORDER BY `minOrder` ASC [ RunTime:0.007430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905275 LIMIT 4 [ RunTime:0.004476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905275 ORDER BY `minOrder` ASC [ RunTime:0.005708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905275 ORDER BY `unit` DESC [ RunTime:0.003283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905275 LIMIT 2 [ RunTime:0.004407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905275 ORDER BY `minOrder` ASC [ RunTime:0.004715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802175 LIMIT 4 [ RunTime:0.007474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802175 ORDER BY `minOrder` ASC [ RunTime:0.003746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802175 ORDER BY `unit` DESC [ RunTime:0.001567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802175 LIMIT 2 [ RunTime:0.004787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802175 ORDER BY `minOrder` ASC [ RunTime:0.004211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816380 LIMIT 4 [ RunTime:0.005253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816380 ORDER BY `minOrder` ASC [ RunTime:0.007531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816380 ORDER BY `unit` DESC [ RunTime:0.011731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816380 LIMIT 2 [ RunTime:0.004050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816380 ORDER BY `minOrder` ASC [ RunTime:0.002510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802159 LIMIT 4 [ RunTime:0.005489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802159 ORDER BY `minOrder` ASC [ RunTime:0.002720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802159 ORDER BY `unit` DESC [ RunTime:0.001449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802159 LIMIT 2 [ RunTime:0.009264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802159 ORDER BY `minOrder` ASC [ RunTime:0.002075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800085 LIMIT 4 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800085 ORDER BY `minOrder` ASC [ RunTime:0.015320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800085 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800085 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800085 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832596 LIMIT 4 [ RunTime:0.003347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832596 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832596 ORDER BY `unit` DESC [ RunTime:0.012886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832596 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832596 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662790 LIMIT 4 [ RunTime:0.015827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662790 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662790 ORDER BY `unit` DESC [ RunTime:0.002158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662790 LIMIT 2 [ RunTime:0.004875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662790 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='SMCJ15A' and brandshort='EVVO' limit 1 [ RunTime:0.003107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663798 LIMIT 4 [ RunTime:0.006127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663798 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663798 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663798 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663798 ORDER BY `minOrder` ASC [ RunTime:0.001760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833664 LIMIT 4 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833664 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833664 ORDER BY `unit` DESC [ RunTime:0.000886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833664 LIMIT 2 [ RunTime:0.003356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833664 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663130 LIMIT 4 [ RunTime:0.002981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663130 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663130 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663130 LIMIT 2 [ RunTime:0.009201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663130 ORDER BY `minOrder` ASC [ RunTime:0.014175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802728 LIMIT 4 [ RunTime:0.006464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802728 ORDER BY `minOrder` ASC [ RunTime:0.004388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802728 ORDER BY `unit` DESC [ RunTime:0.003580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802728 LIMIT 2 [ RunTime:0.003789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802728 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4824 LIMIT 4 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4824 ORDER BY `minOrder` ASC [ RunTime:0.024089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4824 ORDER BY `unit` DESC [ RunTime:0.001819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4824 LIMIT 2 [ RunTime:0.004370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4824 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='SMCJ15A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.001423s ]
select foldpath,foldpath2,filename from pdf_file where id=447333 limit 1 [ RunTime:0.002890s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ15A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.008685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692465 LIMIT 4 [ RunTime:0.004906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692465 ORDER BY `minOrder` ASC [ RunTime:0.002070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692465 ORDER BY `unit` DESC [ RunTime:0.001893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692465 LIMIT 2 [ RunTime:0.003145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692465 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692464 LIMIT 4 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692464 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692464 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692464 LIMIT 2 [ RunTime:0.002970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692464 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMCJ15A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.005806s ]