SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002529s ]
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.003142s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002502s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007815s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001579s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.008678s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001315s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.028392s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001343s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.015925s ]
UPDATE `stock_search` SET `count` = 1087 , `updatetime` = '2026-06-06 08:37:39' WHERE `partno` = '210' [ RunTime:0.001726s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001969s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.021465s ]
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.003523s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002486s ]
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.048866s ]
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 700,20 [ RunTime:0.047115s ]
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 ('12680511','11928574','34360616','34358012','33837131','33316798','33316050','32233147','32165219','18749202','10898688','10898681','34359243','34279236','13315067','13314932','12042190','12563842','11797092','33761104') ORDER BY FIELD(s.id, 12680511,11928574,34360616,34358012,33837131,33316798,33316050,32233147,32165219,18749202,10898688,10898681,34359243,34279236,13315067,13314932,12042190,12563842,11797092,33761104) [ RunTime:0.020511s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.041856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680511 LIMIT 4 [ RunTime:0.062193s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680511 ORDER BY `minOrder` ASC [ RunTime:0.001740s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680511 ORDER BY `unit` DESC [ RunTime:0.020614s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.029630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680511 LIMIT 2 [ RunTime:0.023243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680511 ORDER BY `minOrder` ASC [ RunTime:0.033057s ]
select * from pdf where partno='2102061-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.028521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11928574 LIMIT 4 [ RunTime:0.026076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928574 ORDER BY `minOrder` ASC [ RunTime:0.064869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11928574 ORDER BY `unit` DESC [ RunTime:0.049611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11928574 LIMIT 2 [ RunTime:0.052546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928574 ORDER BY `minOrder` ASC [ RunTime:0.026255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360616 LIMIT 4 [ RunTime:0.050440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360616 ORDER BY `minOrder` ASC [ RunTime:0.034458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360616 ORDER BY `unit` DESC [ RunTime:0.060213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360616 LIMIT 2 [ RunTime:0.021475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360616 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
select * from pdf where partno='21032121306' and brandshort='HARTING' limit 1 [ RunTime:0.043473s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032121306' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.032110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34358012 LIMIT 4 [ RunTime:0.017872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358012 ORDER BY `minOrder` ASC [ RunTime:0.036973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34358012 ORDER BY `unit` DESC [ RunTime:0.066674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34358012 LIMIT 2 [ RunTime:0.007594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358012 ORDER BY `minOrder` ASC [ RunTime:0.037436s ]
select * from pdf where partno='21032811405' and brandshort='HARTING' limit 1 [ RunTime:0.033551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032811405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.030805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33837131 LIMIT 4 [ RunTime:0.021341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837131 ORDER BY `minOrder` ASC [ RunTime:0.027484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33837131 ORDER BY `unit` DESC [ RunTime:0.008165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33837131 LIMIT 2 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33837131 ORDER BY `minOrder` ASC [ RunTime:0.057865s ]
select * from pdf where partno='21033816401' and brandshort='HARTING' limit 1 [ RunTime:0.035599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033816401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33316798 LIMIT 4 [ RunTime:0.043669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33316798 ORDER BY `minOrder` ASC [ RunTime:0.021400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33316798 ORDER BY `unit` DESC [ RunTime:0.024161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33316798 LIMIT 2 [ RunTime:0.031306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33316798 ORDER BY `minOrder` ASC [ RunTime:0.008213s ]
select * from pdf where partno='210-10214-03' and brandshort='Aces Connectors' limit 1 [ RunTime:0.047142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10214-03' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.014351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33316050 LIMIT 4 [ RunTime:0.044595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33316050 ORDER BY `minOrder` ASC [ RunTime:0.044129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33316050 ORDER BY `unit` DESC [ RunTime:0.027438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33316050 LIMIT 2 [ RunTime:0.044960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33316050 ORDER BY `minOrder` ASC [ RunTime:0.025157s ]
select * from pdf where partno='210-10214-03' and brandshort='Aces Connectors' limit 1 [ RunTime:0.004614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-10214-03' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.015255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32233147 LIMIT 4 [ RunTime:0.041029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233147 ORDER BY `minOrder` ASC [ RunTime:0.059009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32233147 ORDER BY `unit` DESC [ RunTime:0.056232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32233147 LIMIT 2 [ RunTime:0.051312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233147 ORDER BY `minOrder` ASC [ RunTime:0.053476s ]
select * from pdf where partno='2102' and brandshort='jkl components' limit 1 [ RunTime:0.029094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.014446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32165219 LIMIT 4 [ RunTime:0.021735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32165219 ORDER BY `minOrder` ASC [ RunTime:0.041504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32165219 ORDER BY `unit` DESC [ RunTime:0.106777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32165219 LIMIT 2 [ RunTime:0.026224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32165219 ORDER BY `minOrder` ASC [ RunTime:0.087032s ]
select * from pdf where partno='21023-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.051740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.092446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749202 LIMIT 4 [ RunTime:0.066945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749202 ORDER BY `minOrder` ASC [ RunTime:0.099977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18749202 ORDER BY `unit` DESC [ RunTime:0.055536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18749202 LIMIT 2 [ RunTime:0.035179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749202 ORDER BY `minOrder` ASC [ RunTime:0.010834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898688 LIMIT 4 [ RunTime:0.030067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898688 ORDER BY `minOrder` ASC [ RunTime:0.068984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10898688 ORDER BY `unit` DESC [ RunTime:0.088622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10898688 LIMIT 2 [ RunTime:0.046491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898688 ORDER BY `minOrder` ASC [ RunTime:0.020712s ]
select * from pdf where partno='21032121306' and brandshort='HARTING' limit 1 [ RunTime:0.013950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898681 LIMIT 4 [ RunTime:0.023191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898681 ORDER BY `minOrder` ASC [ RunTime:0.057039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10898681 ORDER BY `unit` DESC [ RunTime:0.037688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10898681 LIMIT 2 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898681 ORDER BY `minOrder` ASC [ RunTime:0.010302s ]
select * from pdf where partno='21033211818' and brandshort='HARTING' limit 1 [ RunTime:0.042322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34359243 LIMIT 4 [ RunTime:0.037602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34359243 ORDER BY `minOrder` ASC [ RunTime:0.017351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34359243 ORDER BY `unit` DESC [ RunTime:0.032865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34359243 LIMIT 2 [ RunTime:0.021202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34359243 ORDER BY `minOrder` ASC [ RunTime:0.016553s ]
select * from pdf where partno='21033814410' and brandshort='HARTING' limit 1 [ RunTime:0.024951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.044934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279236 LIMIT 4 [ RunTime:0.029855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279236 ORDER BY `minOrder` ASC [ RunTime:0.015028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279236 ORDER BY `unit` DESC [ RunTime:0.023055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279236 LIMIT 2 [ RunTime:0.029674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279236 ORDER BY `minOrder` ASC [ RunTime:0.025012s ]
select * from pdf where partno='2102736-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.026996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102736-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.058604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315067 LIMIT 4 [ RunTime:0.074588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315067 ORDER BY `minOrder` ASC [ RunTime:0.089257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315067 ORDER BY `unit` DESC [ RunTime:0.043241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315067 LIMIT 2 [ RunTime:0.047718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315067 ORDER BY `minOrder` ASC [ RunTime:0.021251s ]
select * from pdf where partno='2104-832-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.038947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314932 LIMIT 4 [ RunTime:0.090663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314932 ORDER BY `minOrder` ASC [ RunTime:0.047148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314932 ORDER BY `unit` DESC [ RunTime:0.066795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314932 LIMIT 2 [ RunTime:0.049425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314932 ORDER BY `minOrder` ASC [ RunTime:0.050071s ]
select * from pdf where partno='2103-440-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.022505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042190 LIMIT 4 [ RunTime:0.025658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042190 ORDER BY `minOrder` ASC [ RunTime:0.008672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042190 ORDER BY `unit` DESC [ RunTime:0.020999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042190 LIMIT 2 [ RunTime:0.009063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042190 ORDER BY `minOrder` ASC [ RunTime:0.012910s ]
select * from pdf where partno='2104-632-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.012325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563842 LIMIT 4 [ RunTime:0.014086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563842 ORDER BY `minOrder` ASC [ RunTime:0.014050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563842 ORDER BY `unit` DESC [ RunTime:0.012019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563842 LIMIT 2 [ RunTime:0.015195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563842 ORDER BY `minOrder` ASC [ RunTime:0.013474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11797092 LIMIT 4 [ RunTime:0.007698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11797092 ORDER BY `minOrder` ASC [ RunTime:0.009150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11797092 ORDER BY `unit` DESC [ RunTime:0.036135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11797092 LIMIT 2 [ RunTime:0.022899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11797092 ORDER BY `minOrder` ASC [ RunTime:0.022747s ]
select * from pdf where partno='21023591301' and brandshort='HARTING' limit 1 [ RunTime:0.025761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33761104 LIMIT 4 [ RunTime:0.029878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33761104 ORDER BY `minOrder` ASC [ RunTime:0.038682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33761104 ORDER BY `unit` DESC [ RunTime:0.007145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33761104 LIMIT 2 [ RunTime:0.054212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33761104 ORDER BY `minOrder` ASC [ RunTime:0.016024s ]
select * from pdf where partno='210-A-111/15' and brandshort='WECO Electrical Connectors Inc.' limit 1 [ RunTime:0.019680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-A-111/15' OR `brand` LIKE 'WECO Electrical Connectors Inc.%' ) ) LIMIT 1 [ RunTime:0.027160s ]
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.090517s ]