SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003695s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.015088s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002775s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003921s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002647s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.012333s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002188s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.021468s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002277s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.024467s ]
UPDATE `stock_search` SET `count` = 917 , `updatetime` = '2026-06-05 15:44:40' WHERE `partno` = '210' [ RunTime:0.031408s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005887s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004824s ]
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.010195s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002521s ]
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.003987s ]
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 40,20 [ RunTime:0.073570s ]
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 ('11985897','32267840','11987439','15473454','32446506','32304220','32296094','33462771','12630513','19593483','19668538','32277470','32162968','19667794','11688842','32277583','32163081','33462759','33390411','11497269') ORDER BY FIELD(s.id, 11985897,32267840,11987439,15473454,32446506,32304220,32296094,33462771,12630513,19593483,19668538,32277470,32162968,19667794,11688842,32277583,32163081,33462759,33390411,11497269) [ RunTime:0.046198s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985897 LIMIT 4 [ RunTime:0.008115s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.024515s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985897 ORDER BY `unit` DESC [ RunTime:0.003477s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985897 LIMIT 2 [ RunTime:0.023258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.019363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267840 LIMIT 4 [ RunTime:0.001749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.021044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267840 ORDER BY `unit` DESC [ RunTime:0.023877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267840 LIMIT 2 [ RunTime:0.038465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.013866s ]
select * from pdf where partno='2103155-2' and brandshort='te connectivity' limit 1 [ RunTime:0.016573s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.030004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987439 LIMIT 4 [ RunTime:0.023062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.022642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987439 ORDER BY `unit` DESC [ RunTime:0.024116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987439 LIMIT 2 [ RunTime:0.020089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.007875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473454 LIMIT 4 [ RunTime:0.032954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.003966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473454 ORDER BY `unit` DESC [ RunTime:0.002266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473454 LIMIT 2 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.014463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32446506 LIMIT 4 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.013594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32446506 ORDER BY `unit` DESC [ RunTime:0.006986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32446506 LIMIT 2 [ RunTime:0.020188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.009593s ]
select * from pdf where partno='210' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.010006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.019471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304220 LIMIT 4 [ RunTime:0.007305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.002511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304220 ORDER BY `unit` DESC [ RunTime:0.015446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304220 LIMIT 2 [ RunTime:0.003962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.004380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.027837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296094 LIMIT 4 [ RunTime:0.012440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.005738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296094 ORDER BY `unit` DESC [ RunTime:0.032710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296094 LIMIT 2 [ RunTime:0.023434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.016122s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.006566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.008683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462771 LIMIT 4 [ RunTime:0.009700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.017333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462771 ORDER BY `unit` DESC [ RunTime:0.014277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462771 LIMIT 2 [ RunTime:0.008822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.017038s ]
select * from pdf where partno='2103155-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630513 LIMIT 4 [ RunTime:0.019505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.027226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630513 ORDER BY `unit` DESC [ RunTime:0.021440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630513 LIMIT 2 [ RunTime:0.037031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593483 LIMIT 4 [ RunTime:0.015852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.027286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593483 ORDER BY `unit` DESC [ RunTime:0.029538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593483 LIMIT 2 [ RunTime:0.034007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.014889s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668538 LIMIT 4 [ RunTime:0.023146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.038568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668538 ORDER BY `unit` DESC [ RunTime:0.055717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668538 LIMIT 2 [ RunTime:0.072498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.016774s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277470 LIMIT 4 [ RunTime:0.013266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.009950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277470 ORDER BY `unit` DESC [ RunTime:0.021007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277470 LIMIT 2 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.009060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.029715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162968 LIMIT 4 [ RunTime:0.005510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162968 ORDER BY `unit` DESC [ RunTime:0.004347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162968 LIMIT 2 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.003238s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.006497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667794 LIMIT 4 [ RunTime:0.007962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.007332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667794 ORDER BY `unit` DESC [ RunTime:0.002682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667794 LIMIT 2 [ RunTime:0.005215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.010896s ]
select * from pdf where partno='2106124-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11688842 LIMIT 4 [ RunTime:0.008934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11688842 ORDER BY `minOrder` ASC [ RunTime:0.006827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11688842 ORDER BY `unit` DESC [ RunTime:0.015791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11688842 LIMIT 2 [ RunTime:0.013008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11688842 ORDER BY `minOrder` ASC [ RunTime:0.008100s ]
select * from pdf where partno='21010000003' and brandshort='HARTING' limit 1 [ RunTime:0.007872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277583 LIMIT 4 [ RunTime:0.008899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277583 ORDER BY `minOrder` ASC [ RunTime:0.011926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277583 ORDER BY `unit` DESC [ RunTime:0.054033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277583 LIMIT 2 [ RunTime:0.027184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277583 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='2106091-5' and brandshort='te connectivity' limit 1 [ RunTime:0.009681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.046783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163081 LIMIT 4 [ RunTime:0.012016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163081 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163081 ORDER BY `unit` DESC [ RunTime:0.018822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163081 LIMIT 2 [ RunTime:0.024551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163081 ORDER BY `minOrder` ASC [ RunTime:0.008453s ]
select * from pdf where partno='2106091-5' and brandshort='te connectivity' limit 1 [ RunTime:0.001933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.003832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462759 LIMIT 4 [ RunTime:0.015278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462759 ORDER BY `minOrder` ASC [ RunTime:0.002506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462759 ORDER BY `unit` DESC [ RunTime:0.007230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462759 LIMIT 2 [ RunTime:0.022788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462759 ORDER BY `minOrder` ASC [ RunTime:0.006607s ]
select * from pdf where partno='2103155-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33390411 LIMIT 4 [ RunTime:0.012836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33390411 ORDER BY `minOrder` ASC [ RunTime:0.023429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33390411 ORDER BY `unit` DESC [ RunTime:0.003535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33390411 LIMIT 2 [ RunTime:0.008647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33390411 ORDER BY `minOrder` ASC [ RunTime:0.002636s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.007752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-3-01-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.011342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11497269 LIMIT 4 [ RunTime:0.015637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497269 ORDER BY `minOrder` ASC [ RunTime:0.017021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11497269 ORDER BY `unit` DESC [ RunTime:0.008181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11497269 LIMIT 2 [ RunTime:0.016965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497269 ORDER BY `minOrder` ASC [ RunTime:0.013648s ]
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.010413s ]