SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001586s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001999s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001396s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001061s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001783s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.002394s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001382s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001602s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003623s ]
UPDATE `stock_search` SET `count` = 2490 , `updatetime` = '2026-06-08 05:08:58' WHERE `partno` = '210' [ RunTime:0.004585s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000282s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000338s ]
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.001367s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002084s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000425s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059376s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('33464425','13262271','13261701','32267705','11989281','11989273','19667770','19667787','35484997','35484989','19668107','19842514','35483855','11931808','11985203','37613248','32277443','32162941','33480403','32277580') ORDER BY FIELD(s.id, 33464425,13262271,13261701,32267705,11989281,11989273,19667770,19667787,35484997,35484989,19668107,19842514,35483855,11931808,11985203,37613248,32277443,32162941,33480403,32277580) [ RunTime:0.006120s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33464425 LIMIT 4 [ RunTime:0.001406s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33464425 ORDER BY `minOrder` ASC [ RunTime:0.002340s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33464425 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33464425 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33464425 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='2109258-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006109s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109258-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262271 LIMIT 4 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262271 ORDER BY `minOrder` ASC [ RunTime:0.004907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13262271 ORDER BY `unit` DESC [ RunTime:0.013491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13262271 LIMIT 2 [ RunTime:0.003819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262271 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13261701 LIMIT 4 [ RunTime:0.003858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13261701 ORDER BY `minOrder` ASC [ RunTime:0.011645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13261701 ORDER BY `unit` DESC [ RunTime:0.007894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13261701 LIMIT 2 [ RunTime:0.006639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13261701 ORDER BY `minOrder` ASC [ RunTime:0.010290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267705 LIMIT 4 [ RunTime:0.004572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267705 ORDER BY `minOrder` ASC [ RunTime:0.009088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267705 ORDER BY `unit` DESC [ RunTime:0.001798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267705 LIMIT 2 [ RunTime:0.011841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267705 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
select * from pdf where partno='2109006-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.010595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109006-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.009464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989281 LIMIT 4 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989281 ORDER BY `minOrder` ASC [ RunTime:0.026495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989281 ORDER BY `unit` DESC [ RunTime:0.012777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989281 LIMIT 2 [ RunTime:0.005563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989281 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989273 LIMIT 4 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989273 ORDER BY `minOrder` ASC [ RunTime:0.013014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989273 ORDER BY `unit` DESC [ RunTime:0.026607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989273 LIMIT 2 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989273 ORDER BY `minOrder` ASC [ RunTime:0.019158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667770 LIMIT 4 [ RunTime:0.002282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667770 ORDER BY `minOrder` ASC [ RunTime:0.015763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667770 ORDER BY `unit` DESC [ RunTime:0.024681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667770 LIMIT 2 [ RunTime:0.003742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667770 ORDER BY `minOrder` ASC [ RunTime:0.021601s ]
select * from pdf where partno='2106124-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667787 LIMIT 4 [ RunTime:0.008618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667787 ORDER BY `minOrder` ASC [ RunTime:0.018954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667787 ORDER BY `unit` DESC [ RunTime:0.009979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667787 LIMIT 2 [ RunTime:0.008392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667787 ORDER BY `minOrder` ASC [ RunTime:0.011196s ]
select * from pdf where partno='2106123-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35484997 LIMIT 4 [ RunTime:0.004786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484997 ORDER BY `minOrder` ASC [ RunTime:0.019579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35484997 ORDER BY `unit` DESC [ RunTime:0.007177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35484997 LIMIT 2 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484997 ORDER BY `minOrder` ASC [ RunTime:0.014680s ]
select * from pdf where partno='2106124-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35484989 LIMIT 4 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484989 ORDER BY `minOrder` ASC [ RunTime:0.031356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35484989 ORDER BY `unit` DESC [ RunTime:0.003396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35484989 LIMIT 2 [ RunTime:0.020247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484989 ORDER BY `minOrder` ASC [ RunTime:0.011706s ]
select * from pdf where partno='2106123-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668107 LIMIT 4 [ RunTime:0.037457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668107 ORDER BY `minOrder` ASC [ RunTime:0.069210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668107 ORDER BY `unit` DESC [ RunTime:0.019694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668107 LIMIT 2 [ RunTime:0.017573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668107 ORDER BY `minOrder` ASC [ RunTime:0.020164s ]
select * from pdf where partno='2106136-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.037233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19842514 LIMIT 4 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19842514 ORDER BY `minOrder` ASC [ RunTime:0.029542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19842514 ORDER BY `unit` DESC [ RunTime:0.016998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19842514 LIMIT 2 [ RunTime:0.005222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19842514 ORDER BY `minOrder` ASC [ RunTime:0.010858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35483855 LIMIT 4 [ RunTime:0.024373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483855 ORDER BY `minOrder` ASC [ RunTime:0.026188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35483855 ORDER BY `unit` DESC [ RunTime:0.015336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35483855 LIMIT 2 [ RunTime:0.009804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483855 ORDER BY `minOrder` ASC [ RunTime:0.025958s ]
select * from pdf where partno='2106136-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11931808 LIMIT 4 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11931808 ORDER BY `minOrder` ASC [ RunTime:0.007925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11931808 ORDER BY `unit` DESC [ RunTime:0.001506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11931808 LIMIT 2 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11931808 ORDER BY `minOrder` ASC [ RunTime:0.018502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985203 LIMIT 4 [ RunTime:0.016004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985203 ORDER BY `minOrder` ASC [ RunTime:0.012025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985203 ORDER BY `unit` DESC [ RunTime:0.012792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985203 LIMIT 2 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985203 ORDER BY `minOrder` ASC [ RunTime:0.015705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37613248 LIMIT 4 [ RunTime:0.027020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613248 ORDER BY `minOrder` ASC [ RunTime:0.021217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37613248 ORDER BY `unit` DESC [ RunTime:0.021941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37613248 LIMIT 2 [ RunTime:0.016210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37613248 ORDER BY `minOrder` ASC [ RunTime:0.016244s ]
select * from pdf where partno='2108838-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108838-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277443 LIMIT 4 [ RunTime:0.004408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277443 ORDER BY `minOrder` ASC [ RunTime:0.034016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277443 ORDER BY `unit` DESC [ RunTime:0.011235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277443 LIMIT 2 [ RunTime:0.010668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277443 ORDER BY `minOrder` ASC [ RunTime:0.005561s ]
select * from pdf where partno='2106123-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.027406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.003533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162941 LIMIT 4 [ RunTime:0.012621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162941 ORDER BY `minOrder` ASC [ RunTime:0.030518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162941 ORDER BY `unit` DESC [ RunTime:0.004568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162941 LIMIT 2 [ RunTime:0.027714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162941 ORDER BY `minOrder` ASC [ RunTime:0.018758s ]
select * from pdf where partno='2106123-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.016457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.003538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33480403 LIMIT 4 [ RunTime:0.008951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33480403 ORDER BY `minOrder` ASC [ RunTime:0.017286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33480403 ORDER BY `unit` DESC [ RunTime:0.008009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33480403 LIMIT 2 [ RunTime:0.018063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33480403 ORDER BY `minOrder` ASC [ RunTime:0.044931s ]
select * from pdf where partno='2108883-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108883-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277580 LIMIT 4 [ RunTime:0.012453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277580 ORDER BY `minOrder` ASC [ RunTime:0.007988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277580 ORDER BY `unit` DESC [ RunTime:0.009294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277580 LIMIT 2 [ RunTime:0.003958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277580 ORDER BY `minOrder` ASC [ RunTime:0.008079s ]
select * from pdf where partno='2106091-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.008420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.000804s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002475s ]