SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002190s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?typeid=377' [ RunTime:0.024428s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002732s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.017610s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002236s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.033606s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002506s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.036660s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 377 [ RunTime:0.039560s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 377 LIMIT 1 [ RunTime:0.013202s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002688s ]
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` = '377' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.163380s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.122218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9658 LIMIT 5 [ RunTime:0.085167s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9658 ORDER BY `minOrder` ASC [ RunTime:0.069868s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.085792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9658 ORDER BY `unit` DESC [ RunTime:0.028009s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9658 LIMIT 2 [ RunTime:0.051832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9658 ORDER BY `minOrder` ASC [ RunTime:0.027322s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZEMI2121MTTAG' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.020561s ]
SELECT `id` FROM `stock` WHERE `id` <> 9658 AND `partno` = 'SZEMI2121MTTAG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.053018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393970 [ RunTime:0.083104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8524 LIMIT 5 [ RunTime:0.070866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8524 ORDER BY `minOrder` ASC [ RunTime:0.067694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8524 ORDER BY `unit` DESC [ RunTime:0.083360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8524 LIMIT 2 [ RunTime:0.064447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8524 ORDER BY `minOrder` ASC [ RunTime:0.052722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECMF02-4CMX8' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.071993s ]
SELECT `id` FROM `stock` WHERE `id` <> 8524 AND `partno` = 'ECMF02-4CMX8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.117559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939312 [ RunTime:0.096924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12583 LIMIT 5 [ RunTime:0.051268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12583 ORDER BY `minOrder` ASC [ RunTime:0.083866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12583 ORDER BY `unit` DESC [ RunTime:0.046618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12583 LIMIT 2 [ RunTime:0.040154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12583 ORDER BY `minOrder` ASC [ RunTime:0.007424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCZ1210AH900L2TA0G' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.041538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685 ORDER BY `minOrder` ASC [ RunTime:0.041012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11685 ORDER BY `unit` DESC [ RunTime:0.017675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11685 LIMIT 2 [ RunTime:0.012383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685 ORDER BY `minOrder` ASC [ RunTime:0.013559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACM4520-142-2P-T000' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.045622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17125 LIMIT 5 [ RunTime:0.033603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17125 ORDER BY `minOrder` ASC [ RunTime:0.033078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17125 ORDER BY `unit` DESC [ RunTime:0.014849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17125 LIMIT 2 [ RunTime:0.043102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17125 ORDER BY `minOrder` ASC [ RunTime:0.017449s ]
select * from pdf where partno='PA4339.101NLT' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.009057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4339.101NLT' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.021840s ]
SELECT `id` FROM `stock` WHERE `id` <> 17125 AND `partno` = 'PA4339.101NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.008621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13283 [ RunTime:0.006401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16107 [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204283 [ RunTime:0.002649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16302 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16302 ORDER BY `minOrder` ASC [ RunTime:0.002969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16302 ORDER BY `unit` DESC [ RunTime:0.009872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16302 LIMIT 2 [ RunTime:0.020677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16302 ORDER BY `minOrder` ASC [ RunTime:0.002809s ]
select * from pdf where partno='ECMF4-20A42N10' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.053672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECMF4-20A42N10' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.006458s ]
SELECT `id` FROM `stock` WHERE `id` <> 16302 AND `partno` = 'ECMF4-20A42N10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.044424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8823 [ RunTime:0.022039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15282 [ RunTime:0.034593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393606 [ RunTime:0.024621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16107 LIMIT 5 [ RunTime:0.033030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16107 ORDER BY `minOrder` ASC [ RunTime:0.010735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16107 ORDER BY `unit` DESC [ RunTime:0.000759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16107 LIMIT 2 [ RunTime:0.008563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16107 ORDER BY `minOrder` ASC [ RunTime:0.001317s ]
select * from pdf where partno='PA4339.101NLT' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.009155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4339.101NLT' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.007265s ]
SELECT `id` FROM `stock` WHERE `id` <> 16107 AND `partno` = 'PA4339.101NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.037027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13283 [ RunTime:0.010270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17125 [ RunTime:0.008345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204283 [ RunTime:0.005913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15282 LIMIT 5 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15282 ORDER BY `minOrder` ASC [ RunTime:0.011502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15282 ORDER BY `unit` DESC [ RunTime:0.009128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15282 LIMIT 2 [ RunTime:0.017965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15282 ORDER BY `minOrder` ASC [ RunTime:0.016079s ]
select * from pdf where partno='ECMF4-20A42N10' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.010235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECMF4-20A42N10' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.003656s ]
SELECT `id` FROM `stock` WHERE `id` <> 15282 AND `partno` = 'ECMF4-20A42N10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.001398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8823 [ RunTime:0.007469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16302 [ RunTime:0.010102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393606 [ RunTime:0.003917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413 LIMIT 5 [ RunTime:0.013824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413 ORDER BY `minOrder` ASC [ RunTime:0.025550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11413 ORDER BY `unit` DESC [ RunTime:0.020974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11413 LIMIT 2 [ RunTime:0.016980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413 ORDER BY `minOrder` ASC [ RunTime:0.007957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECMF02-2BF3' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.004671s ]
SELECT `id` FROM `stock` WHERE `id` <> 11413 AND `partno` = 'ECMF02-2BF3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.006312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204080 [ RunTime:0.018257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673 LIMIT 5 [ RunTime:0.022624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673 ORDER BY `minOrder` ASC [ RunTime:0.010084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11673 ORDER BY `unit` DESC [ RunTime:0.017519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11673 LIMIT 2 [ RunTime:0.003224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673 ORDER BY `minOrder` ASC [ RunTime:0.001013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACM2012H-381-2P-T05' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.030609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7089 LIMIT 5 [ RunTime:0.009762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7089 ORDER BY `minOrder` ASC [ RunTime:0.024472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7089 ORDER BY `unit` DESC [ RunTime:0.012975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7089 LIMIT 2 [ RunTime:0.014563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7089 ORDER BY `minOrder` ASC [ RunTime:0.020161s ]
select * from pdf where partno='ACM2012-121-2P-T001' and brandshort='TDK' limit 1 [ RunTime:0.011211s ]
select foldpath,foldpath2,filename from pdf_file where id=1118495 limit 1 [ RunTime:0.025185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACM2012-121-2P-T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.034070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13283 LIMIT 5 [ RunTime:0.021086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13283 ORDER BY `minOrder` ASC [ RunTime:0.017393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13283 ORDER BY `unit` DESC [ RunTime:0.005413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13283 LIMIT 2 [ RunTime:0.005460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13283 ORDER BY `minOrder` ASC [ RunTime:0.013120s ]
select * from pdf where partno='PA4339.101NLT' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.001808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4339.101NLT' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000480s ]
SELECT `id` FROM `stock` WHERE `id` <> 13283 AND `partno` = 'PA4339.101NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.006157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16107 [ RunTime:0.005590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17125 [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204283 [ RunTime:0.001248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8823 LIMIT 5 [ RunTime:0.012588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8823 ORDER BY `minOrder` ASC [ RunTime:0.009101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8823 ORDER BY `unit` DESC [ RunTime:0.013732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8823 LIMIT 2 [ RunTime:0.007347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8823 ORDER BY `minOrder` ASC [ RunTime:0.003875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECMF4-20A42N10' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000457s ]
SELECT `id` FROM `stock` WHERE `id` <> 8823 AND `partno` = 'ECMF4-20A42N10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15282 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16302 [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393606 [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11809 LIMIT 5 [ RunTime:0.007211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11809 ORDER BY `minOrder` ASC [ RunTime:0.010531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11809 ORDER BY `unit` DESC [ RunTime:0.026230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11809 LIMIT 2 [ RunTime:0.011735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11809 ORDER BY `minOrder` ASC [ RunTime:0.016352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PLT10HH1026R0PNL' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.032979s ]
SELECT `id` FROM `stock` WHERE `id` <> 11809 AND `partno` = 'PLT10HH1026R0PNL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.020639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204909 [ RunTime:0.014005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13282 LIMIT 5 [ RunTime:0.010581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13282 ORDER BY `minOrder` ASC [ RunTime:0.018810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13282 ORDER BY `unit` DESC [ RunTime:0.007074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13282 LIMIT 2 [ RunTime:0.008104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13282 ORDER BY `minOrder` ASC [ RunTime:0.017499s ]
select * from pdf where partno='PA3927NLT' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.017641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA3927NLT' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.030517s ]
SELECT `id` FROM `stock` WHERE `id` <> 13282 AND `partno` = 'PA3927NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.017892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11941140 [ RunTime:0.012262s ]
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` = '377' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031767s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '377' ) LIMIT 15 ) tmp GROUP BY `brand` [ RunTime:0.031034s ]