SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001680s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.009473s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001336s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.041854s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003343s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.010823s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001473s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012295s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001462s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003635s ]
UPDATE `stock_search` SET `count` = 4101 , `updatetime` = '2026-06-08 16:34:25' WHERE `partno` = '210' [ RunTime:0.024144s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.055055s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005118s ]
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.007007s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002720s ]
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.006904s ]
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 60,20 [ RunTime:0.100990s ]
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 ('32304220','32296094','36766130','33462771','12630513','19593483','19668538','35483961','36766054','35484103','32277470','32162968','19667794','11688842','35483744','36766780','32277583','32163081','33462759','33390411') ORDER BY FIELD(s.id, 32304220,32296094,36766130,33462771,12630513,19593483,19668538,35483961,36766054,35484103,32277470,32162968,19667794,11688842,35483744,36766780,32277583,32163081,33462759,33390411) [ RunTime:0.021409s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304220 LIMIT 4 [ RunTime:0.083875s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.046511s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304220 ORDER BY `unit` DESC [ RunTime:0.019224s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304220 LIMIT 2 [ RunTime:0.024904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.036991s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.020835s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.041818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296094 LIMIT 4 [ RunTime:0.020081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.065725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296094 ORDER BY `unit` DESC [ RunTime:0.102243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296094 LIMIT 2 [ RunTime:0.027322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.007726s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.037464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.022533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766130 LIMIT 4 [ RunTime:0.055891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766130 ORDER BY `minOrder` ASC [ RunTime:0.103635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766130 ORDER BY `unit` DESC [ RunTime:0.032750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766130 LIMIT 2 [ RunTime:0.018493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766130 ORDER BY `minOrder` ASC [ RunTime:0.050512s ]
select * from pdf where partno='2102-632-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.032120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-632-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.034984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462771 LIMIT 4 [ RunTime:0.032231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.088378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462771 ORDER BY `unit` DESC [ RunTime:0.000836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462771 LIMIT 2 [ RunTime:0.042131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.092092s ]
select * from pdf where partno='2103155-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.079412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.051726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630513 LIMIT 4 [ RunTime:0.043919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.070635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630513 ORDER BY `unit` DESC [ RunTime:0.051329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630513 LIMIT 2 [ RunTime:0.022808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.016585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593483 LIMIT 4 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.033948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593483 ORDER BY `unit` DESC [ RunTime:0.032704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593483 LIMIT 2 [ RunTime:0.031849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.023854s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.022338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668538 LIMIT 4 [ RunTime:0.016422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.080773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668538 ORDER BY `unit` DESC [ RunTime:0.061233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668538 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.016344s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35483961 LIMIT 4 [ RunTime:0.010108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.054292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35483961 ORDER BY `unit` DESC [ RunTime:0.032774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35483961 LIMIT 2 [ RunTime:0.018046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.051301s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766054 LIMIT 4 [ RunTime:0.015205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766054 ORDER BY `minOrder` ASC [ RunTime:0.058360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766054 ORDER BY `unit` DESC [ RunTime:0.037202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766054 LIMIT 2 [ RunTime:0.045428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766054 ORDER BY `minOrder` ASC [ RunTime:0.026149s ]
select * from pdf where partno='2100-632-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.013402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-632-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.022296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35484103 LIMIT 4 [ RunTime:0.045146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.060140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35484103 ORDER BY `unit` DESC [ RunTime:0.001997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35484103 LIMIT 2 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.025910s ]
select * from pdf where partno='2106123-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.040457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.036474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277470 LIMIT 4 [ RunTime:0.022078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.032305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277470 ORDER BY `unit` DESC [ RunTime:0.026770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277470 LIMIT 2 [ RunTime:0.018300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162968 LIMIT 4 [ RunTime:0.012471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.150830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162968 ORDER BY `unit` DESC [ RunTime:0.034032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162968 LIMIT 2 [ RunTime:0.026554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.017630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.020051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667794 LIMIT 4 [ RunTime:0.018791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.063932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667794 ORDER BY `unit` DESC [ RunTime:0.014424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667794 LIMIT 2 [ RunTime:0.008320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
select * from pdf where partno='2106124-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.040250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11688842 LIMIT 4 [ RunTime:0.014164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11688842 ORDER BY `minOrder` ASC [ RunTime:0.085833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11688842 ORDER BY `unit` DESC [ RunTime:0.021845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11688842 LIMIT 2 [ RunTime:0.020776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11688842 ORDER BY `minOrder` ASC [ RunTime:0.027532s ]
select * from pdf where partno='21010000003' and brandshort='HARTING' limit 1 [ RunTime:0.029997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35483744 LIMIT 4 [ RunTime:0.065408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483744 ORDER BY `minOrder` ASC [ RunTime:0.096411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35483744 ORDER BY `unit` DESC [ RunTime:0.051854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35483744 LIMIT 2 [ RunTime:0.017412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483744 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
select * from pdf where partno='2106136-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766780 LIMIT 4 [ RunTime:0.017701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766780 ORDER BY `minOrder` ASC [ RunTime:0.095584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766780 ORDER BY `unit` DESC [ RunTime:0.013382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766780 LIMIT 2 [ RunTime:0.004646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766780 ORDER BY `minOrder` ASC [ RunTime:0.009245s ]
select * from pdf where partno='2104-632-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-632-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.010619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277583 LIMIT 4 [ RunTime:0.021714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277583 ORDER BY `minOrder` ASC [ RunTime:0.070119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277583 ORDER BY `unit` DESC [ RunTime:0.024403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277583 LIMIT 2 [ RunTime:0.008915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277583 ORDER BY `minOrder` ASC [ RunTime:0.006478s ]
select * from pdf where partno='2106091-5' and brandshort='te connectivity' limit 1 [ RunTime:0.011133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.002930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163081 LIMIT 4 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163081 ORDER BY `minOrder` ASC [ RunTime:0.005318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163081 ORDER BY `unit` DESC [ RunTime:0.002305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163081 LIMIT 2 [ RunTime:0.009612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163081 ORDER BY `minOrder` ASC [ RunTime:0.008605s ]
select * from pdf where partno='2106091-5' and brandshort='te connectivity' limit 1 [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462759 LIMIT 4 [ RunTime:0.010966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462759 ORDER BY `minOrder` ASC [ RunTime:0.010785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462759 ORDER BY `unit` DESC [ RunTime:0.008704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462759 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462759 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='2103155-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33390411 LIMIT 4 [ RunTime:0.008598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33390411 ORDER BY `minOrder` ASC [ RunTime:0.015418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33390411 ORDER BY `unit` DESC [ RunTime:0.008028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33390411 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33390411 ORDER BY `minOrder` ASC [ RunTime:0.006109s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.010109s ]
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.011388s ]
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.002187s ]