SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002124s ]
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.014078s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001968s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000525s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002092s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002577s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001817s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000701s ]
UPDATE `stock_search` SET `count` = 1194 , `updatetime` = '2026-06-06 17:28:03' WHERE `partno` = '210' [ RunTime:0.010890s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000288s ]
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.000390s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002312s ]
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.212698s ]
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.047579s ]
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 ('12511571','19668156','32277582','32163080','11985897','32267840','11987439','15473454','32446506','32304220','32296094','33462771','12630513','19593483','19668538','35483961','35484103','32277470','32162968','19667794') ORDER BY FIELD(s.id, 12511571,19668156,32277582,32163080,11985897,32267840,11987439,15473454,32446506,32304220,32296094,33462771,12630513,19593483,19668538,35483961,35484103,32277470,32162968,19667794) [ RunTime:0.006629s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511571 LIMIT 4 [ RunTime:0.006247s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511571 ORDER BY `minOrder` ASC [ RunTime:0.012803s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511571 ORDER BY `unit` DESC [ RunTime:0.009625s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511571 LIMIT 2 [ RunTime:0.040960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511571 ORDER BY `minOrder` ASC [ RunTime:0.029162s ]
select * from pdf where partno='2108074-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668156 LIMIT 4 [ RunTime:0.043498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668156 ORDER BY `minOrder` ASC [ RunTime:0.028807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668156 ORDER BY `unit` DESC [ RunTime:0.050769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668156 LIMIT 2 [ RunTime:0.023940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668156 ORDER BY `minOrder` ASC [ RunTime:0.019591s ]
select * from pdf where partno='2106136-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277582 LIMIT 4 [ RunTime:0.021117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277582 ORDER BY `minOrder` ASC [ RunTime:0.009677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277582 ORDER BY `unit` DESC [ RunTime:0.025792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277582 LIMIT 2 [ RunTime:0.029145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277582 ORDER BY `minOrder` ASC [ RunTime:0.009640s ]
select * from pdf where partno='2106091-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.010230s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.009381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163080 LIMIT 4 [ RunTime:0.045131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163080 ORDER BY `minOrder` ASC [ RunTime:0.032440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163080 ORDER BY `unit` DESC [ RunTime:0.015561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163080 LIMIT 2 [ RunTime:0.006839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163080 ORDER BY `minOrder` ASC [ RunTime:0.019765s ]
select * from pdf where partno='2106091-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.015209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.002203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985897 LIMIT 4 [ RunTime:0.041058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.029689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985897 ORDER BY `unit` DESC [ RunTime:0.137349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985897 LIMIT 2 [ RunTime:0.044472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.094982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267840 LIMIT 4 [ RunTime:0.027655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.039454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267840 ORDER BY `unit` DESC [ RunTime:0.026030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267840 LIMIT 2 [ RunTime:0.004706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.001386s ]
select * from pdf where partno='2103155-2' and brandshort='te connectivity' limit 1 [ RunTime:0.006714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987439 LIMIT 4 [ RunTime:0.013445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.019532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987439 ORDER BY `unit` DESC [ RunTime:0.008816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987439 LIMIT 2 [ RunTime:0.006528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473454 LIMIT 4 [ RunTime:0.017248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.009403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473454 ORDER BY `unit` DESC [ RunTime:0.004070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473454 LIMIT 2 [ RunTime:0.013249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.008538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32446506 LIMIT 4 [ RunTime:0.014561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.011043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32446506 ORDER BY `unit` DESC [ RunTime:0.007954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32446506 LIMIT 2 [ RunTime:0.022352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.014565s ]
select * from pdf where partno='210' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.011432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.053143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304220 LIMIT 4 [ RunTime:0.071504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.009933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304220 ORDER BY `unit` DESC [ RunTime:0.046539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304220 LIMIT 2 [ RunTime:0.028020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.054936s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.013527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.033508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296094 LIMIT 4 [ RunTime:0.039413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.039632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296094 ORDER BY `unit` DESC [ RunTime:0.133450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296094 LIMIT 2 [ RunTime:0.051041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.014606s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.018362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.014355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462771 LIMIT 4 [ RunTime:0.010261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.004235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462771 ORDER BY `unit` DESC [ RunTime:0.001524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462771 LIMIT 2 [ RunTime:0.003991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.010288s ]
select * from pdf where partno='2103155-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630513 LIMIT 4 [ RunTime:0.020201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.045266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630513 ORDER BY `unit` DESC [ RunTime:0.020494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630513 LIMIT 2 [ RunTime:0.030200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.028251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593483 LIMIT 4 [ RunTime:0.022595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.040964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593483 ORDER BY `unit` DESC [ RunTime:0.010275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593483 LIMIT 2 [ RunTime:0.013238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.013184s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668538 LIMIT 4 [ RunTime:0.035710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.005825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668538 ORDER BY `unit` DESC [ RunTime:0.003798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668538 LIMIT 2 [ RunTime:0.009760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.012362s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35483961 LIMIT 4 [ RunTime:0.029287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.009853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35483961 ORDER BY `unit` DESC [ RunTime:0.022956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35483961 LIMIT 2 [ RunTime:0.026195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.044816s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35484103 LIMIT 4 [ RunTime:0.009825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35484103 ORDER BY `unit` DESC [ RunTime:0.007610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35484103 LIMIT 2 [ RunTime:0.019178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.001278s ]
select * from pdf where partno='2106123-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.012558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.038849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277470 LIMIT 4 [ RunTime:0.012353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.002028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277470 ORDER BY `unit` DESC [ RunTime:0.015224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277470 LIMIT 2 [ RunTime:0.043274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.008426s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.010300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.037222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162968 LIMIT 4 [ RunTime:0.012008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.005475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162968 ORDER BY `unit` DESC [ RunTime:0.010469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162968 LIMIT 2 [ RunTime:0.016496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.004697s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.007874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667794 LIMIT 4 [ RunTime:0.018817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.009101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667794 ORDER BY `unit` DESC [ RunTime:0.002893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667794 LIMIT 2 [ RunTime:0.008327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.006096s ]
select * from pdf where partno='2106124-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002627s ]
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.070389s ]