SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001688s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.13' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/category_517/1.html' [ RunTime:0.017330s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002317s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.019056s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001340s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.13' ) [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001530s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000347s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 517 [ RunTime:0.003397s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 517 LIMIT 1 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001605s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '517' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027062s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4592 LIMIT 5 [ RunTime:0.002939s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4592 ORDER BY `minOrder` ASC [ RunTime:0.009623s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4592 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4592 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4592 ORDER BY `minOrder` ASC [ RunTime:0.006833s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP6541T-I/LT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.002499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9367 LIMIT 5 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9367 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9367 ORDER BY `unit` DESC [ RunTime:0.029499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9367 LIMIT 2 [ RunTime:0.018597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9367 ORDER BY `minOrder` ASC [ RunTime:0.016309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX9647AUK+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.017719s ]
SELECT `id` FROM `stock` WHERE `id` <> 9367 AND `partno` = 'MAX9647AUK+T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices%' ) [ RunTime:0.009007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255001 [ RunTime:0.016203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6770 LIMIT 5 [ RunTime:0.010705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6770 ORDER BY `minOrder` ASC [ RunTime:0.004767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6770 ORDER BY `unit` DESC [ RunTime:0.038879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6770 LIMIT 2 [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6770 ORDER BY `minOrder` ASC [ RunTime:0.008718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM239DT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.019659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11432 LIMIT 5 [ RunTime:0.041468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11432 ORDER BY `minOrder` ASC [ RunTime:0.009994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11432 ORDER BY `unit` DESC [ RunTime:0.052251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11432 LIMIT 2 [ RunTime:0.037271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11432 ORDER BY `minOrder` ASC [ RunTime:0.006011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM239QT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.019855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6772 LIMIT 5 [ RunTime:0.018884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6772 ORDER BY `minOrder` ASC [ RunTime:0.018894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6772 ORDER BY `unit` DESC [ RunTime:0.047389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6772 LIMIT 2 [ RunTime:0.014924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6772 ORDER BY `minOrder` ASC [ RunTime:0.026803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM339DT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.036602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7500 LIMIT 5 [ RunTime:0.022596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7500 ORDER BY `minOrder` ASC [ RunTime:0.010865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7500 ORDER BY `unit` DESC [ RunTime:0.044958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7500 LIMIT 2 [ RunTime:0.037147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7500 ORDER BY `minOrder` ASC [ RunTime:0.014587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TS3702IDT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.029225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16481 LIMIT 5 [ RunTime:0.023189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16481 ORDER BY `minOrder` ASC [ RunTime:0.025263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16481 ORDER BY `unit` DESC [ RunTime:0.019763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16481 LIMIT 2 [ RunTime:0.024525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16481 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
select * from pdf where partno='LM2903QS-13' and brandshort='DIODES INC.' limit 1 [ RunTime:0.077203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM2903QS-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.027534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15461 LIMIT 5 [ RunTime:0.043803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.032488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15461 ORDER BY `unit` DESC [ RunTime:0.039423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15461 LIMIT 2 [ RunTime:0.042885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15461 ORDER BY `minOrder` ASC [ RunTime:0.022591s ]
select * from pdf where partno='LM2903QS-13' and brandshort='DIODES INC.' limit 1 [ RunTime:0.008072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM2903QS-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.013548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9960 LIMIT 5 [ RunTime:0.020799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9960 ORDER BY `minOrder` ASC [ RunTime:0.049641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9960 ORDER BY `unit` DESC [ RunTime:0.074696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9960 LIMIT 2 [ RunTime:0.059287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9960 ORDER BY `minOrder` ASC [ RunTime:0.016601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCX2202GW,125' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.081842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11493 LIMIT 5 [ RunTime:0.051671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493 ORDER BY `minOrder` ASC [ RunTime:0.090074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11493 ORDER BY `unit` DESC [ RunTime:0.009977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11493 LIMIT 2 [ RunTime:0.005201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493 ORDER BY `minOrder` ASC [ RunTime:0.024318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM2903QS-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.041115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4431 LIMIT 5 [ RunTime:0.076078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4431 ORDER BY `minOrder` ASC [ RunTime:0.232553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4431 ORDER BY `unit` DESC [ RunTime:0.027888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4431 LIMIT 2 [ RunTime:0.017347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4431 ORDER BY `minOrder` ASC [ RunTime:0.011979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP6562-E/MS' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.040959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8034 LIMIT 5 [ RunTime:0.060687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8034 ORDER BY `minOrder` ASC [ RunTime:0.088654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8034 ORDER BY `unit` DESC [ RunTime:0.015798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8034 LIMIT 2 [ RunTime:0.076717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8034 ORDER BY `minOrder` ASC [ RunTime:0.062186s ]
select * from pdf where partno='MAX942ESA+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.043612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX942ESA+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.063526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11492 LIMIT 5 [ RunTime:0.117478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492 ORDER BY `minOrder` ASC [ RunTime:0.058821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11492 ORDER BY `unit` DESC [ RunTime:0.026766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11492 LIMIT 2 [ RunTime:0.093349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492 ORDER BY `minOrder` ASC [ RunTime:0.010619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP331AWRG-7' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.100553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6771 LIMIT 5 [ RunTime:0.012254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6771 ORDER BY `minOrder` ASC [ RunTime:0.051426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6771 ORDER BY `unit` DESC [ RunTime:0.051171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6771 LIMIT 2 [ RunTime:0.051442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6771 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM293DT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.047777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4281 LIMIT 5 [ RunTime:0.057693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4281 ORDER BY `minOrder` ASC [ RunTime:0.022907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4281 ORDER BY `unit` DESC [ RunTime:0.039603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4281 LIMIT 2 [ RunTime:0.051492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4281 ORDER BY `minOrder` ASC [ RunTime:0.003389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP6541T-I/OT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.057599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7892 LIMIT 5 [ RunTime:0.038219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7892 ORDER BY `minOrder` ASC [ RunTime:0.018309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7892 ORDER BY `unit` DESC [ RunTime:0.058630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7892 LIMIT 2 [ RunTime:0.032244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7892 ORDER BY `minOrder` ASC [ RunTime:0.016602s ]
select * from pdf where partno='MIC842HYC5-TR' and brandshort='MICROCHIP' limit 1 [ RunTime:0.042701s ]
select foldpath,foldpath2,filename from pdf_file where id=1514213 limit 1 [ RunTime:0.024589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC842HYC5-TR' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.076633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8065 LIMIT 5 [ RunTime:0.057445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8065 ORDER BY `minOrder` ASC [ RunTime:0.074325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8065 ORDER BY `unit` DESC [ RunTime:0.061360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8065 LIMIT 2 [ RunTime:0.138754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8065 ORDER BY `minOrder` ASC [ RunTime:0.223006s ]
select * from pdf where partno='MAX931CSA+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.043857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX931CSA+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.020036s ]
SELECT `id` FROM `stock` WHERE `id` <> 8065 AND `partno` = 'MAX931CSA+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices%' ) [ RunTime:0.068178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17137608 [ RunTime:0.069834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450 LIMIT 5 [ RunTime:0.030383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450 ORDER BY `minOrder` ASC [ RunTime:0.036014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11450 ORDER BY `unit` DESC [ RunTime:0.032307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11450 LIMIT 2 [ RunTime:0.038126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450 ORDER BY `minOrder` ASC [ RunTime:0.087788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LMV393DR2G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.051765s ]
SELECT `id` FROM `stock` WHERE `id` <> 11450 AND `partno` = 'LMV393DR2G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.026301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15356945 [ RunTime:0.162491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4593 LIMIT 5 [ RunTime:0.086781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4593 ORDER BY `minOrder` ASC [ RunTime:0.067021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4593 ORDER BY `unit` DESC [ RunTime:0.060992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4593 LIMIT 2 [ RunTime:0.034054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4593 ORDER BY `minOrder` ASC [ RunTime:0.025552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP6546UT-E/OT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.063596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7980 LIMIT 5 [ RunTime:0.015469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7980 ORDER BY `minOrder` ASC [ RunTime:0.005154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7980 ORDER BY `unit` DESC [ RunTime:0.001277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7980 LIMIT 2 [ RunTime:0.006758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7980 ORDER BY `minOrder` ASC [ RunTime:0.004853s ]
select * from pdf where partno='MAX987EXK+T' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.039430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX987EXK+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.049913s ]
SELECT `id` FROM `stock` WHERE `id` <> 7980 AND `partno` = 'MAX987EXK+T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices%' ) [ RunTime:0.027349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255870 [ RunTime:0.005136s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '517' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019386s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '517' ) LIMIT 26 ) tmp GROUP BY `brand` [ RunTime:0.057654s ]