SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002083s ]
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.004063s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001835s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007841s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002413s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002219s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002372s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001865s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000927s ]
UPDATE `stock_search` SET `count` = 1048 , `updatetime` = '2026-06-05 16:51:02' WHERE `partno` = '210' [ RunTime:0.004337s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000335s ]
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.000553s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002750s ]
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.114610s ]
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 560,20 [ RunTime:0.037942s ]
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 ('11800436','10892490','13416283','13315985','12553816','11928596','13315062','33613449','13798657','13413473','12497856','33613451','13315847','12679247','10961644','15481975','13403955','12042127','12883199','33613922') ORDER BY FIELD(s.id, 11800436,10892490,13416283,13315985,12553816,11928596,13315062,33613449,13798657,13413473,12497856,33613451,13315847,12679247,10961644,15481975,13403955,12042127,12883199,33613922) [ RunTime:0.006708s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11800436 LIMIT 4 [ RunTime:0.021994s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11800436 ORDER BY `minOrder` ASC [ RunTime:0.035788s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11800436 ORDER BY `unit` DESC [ RunTime:0.023843s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11800436 LIMIT 2 [ RunTime:0.031869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11800436 ORDER BY `minOrder` ASC [ RunTime:0.018560s ]
select * from pdf where partno='21033814430' and brandshort='HARTING' limit 1 [ RunTime:0.022309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10892490 LIMIT 4 [ RunTime:0.017167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892490 ORDER BY `minOrder` ASC [ RunTime:0.031630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10892490 ORDER BY `unit` DESC [ RunTime:0.018897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10892490 LIMIT 2 [ RunTime:0.057312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10892490 ORDER BY `minOrder` ASC [ RunTime:0.035448s ]
select * from pdf where partno='21033213501' and brandshort='HARTING' limit 1 [ RunTime:0.009591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416283 LIMIT 4 [ RunTime:0.021070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416283 ORDER BY `minOrder` ASC [ RunTime:0.040310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13416283 ORDER BY `unit` DESC [ RunTime:0.019374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13416283 LIMIT 2 [ RunTime:0.036619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416283 ORDER BY `minOrder` ASC [ RunTime:0.027682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315985 LIMIT 4 [ RunTime:0.045786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315985 ORDER BY `minOrder` ASC [ RunTime:0.036407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315985 ORDER BY `unit` DESC [ RunTime:0.032618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315985 LIMIT 2 [ RunTime:0.036404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315985 ORDER BY `minOrder` ASC [ RunTime:0.016962s ]
select * from pdf where partno='2103T-440-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.025250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12553816 LIMIT 4 [ RunTime:0.021189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12553816 ORDER BY `minOrder` ASC [ RunTime:0.021720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12553816 ORDER BY `unit` DESC [ RunTime:0.005515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12553816 LIMIT 2 [ RunTime:0.011616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12553816 ORDER BY `minOrder` ASC [ RunTime:0.010964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11928596 LIMIT 4 [ RunTime:0.029623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928596 ORDER BY `minOrder` ASC [ RunTime:0.011239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11928596 ORDER BY `unit` DESC [ RunTime:0.012833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11928596 LIMIT 2 [ RunTime:0.049298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928596 ORDER BY `minOrder` ASC [ RunTime:0.009704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315062 LIMIT 4 [ RunTime:0.023606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315062 ORDER BY `minOrder` ASC [ RunTime:0.009334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315062 ORDER BY `unit` DESC [ RunTime:0.010124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315062 LIMIT 2 [ RunTime:0.029151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315062 ORDER BY `minOrder` ASC [ RunTime:0.012930s ]
select * from pdf where partno='2102-832-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.008400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33613449 LIMIT 4 [ RunTime:0.014694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613449 ORDER BY `minOrder` ASC [ RunTime:0.013902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33613449 ORDER BY `unit` DESC [ RunTime:0.006430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33613449 LIMIT 2 [ RunTime:0.006413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613449 ORDER BY `minOrder` ASC [ RunTime:0.023040s ]
select * from pdf where partno='2106-5201' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003361s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-5201' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13798657 LIMIT 4 [ RunTime:0.022099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13798657 ORDER BY `minOrder` ASC [ RunTime:0.009097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13798657 ORDER BY `unit` DESC [ RunTime:0.003860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13798657 LIMIT 2 [ RunTime:0.020834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13798657 ORDER BY `minOrder` ASC [ RunTime:0.010466s ]
select * from pdf where partno='21033712403' and brandshort='HARTING' limit 1 [ RunTime:0.015778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13413473 LIMIT 4 [ RunTime:0.012455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413473 ORDER BY `minOrder` ASC [ RunTime:0.008029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13413473 ORDER BY `unit` DESC [ RunTime:0.010076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13413473 LIMIT 2 [ RunTime:0.002315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413473 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12497856 LIMIT 4 [ RunTime:0.005861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12497856 ORDER BY `minOrder` ASC [ RunTime:0.007783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12497856 ORDER BY `unit` DESC [ RunTime:0.005606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12497856 LIMIT 2 [ RunTime:0.002943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12497856 ORDER BY `minOrder` ASC [ RunTime:0.002415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33613451 LIMIT 4 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613451 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33613451 ORDER BY `unit` DESC [ RunTime:0.001371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33613451 LIMIT 2 [ RunTime:0.003432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613451 ORDER BY `minOrder` ASC [ RunTime:0.003837s ]
select * from pdf where partno='2106-1201' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-1201' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315847 LIMIT 4 [ RunTime:0.007252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315847 ORDER BY `minOrder` ASC [ RunTime:0.003866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315847 ORDER BY `unit` DESC [ RunTime:0.006222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315847 LIMIT 2 [ RunTime:0.001604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315847 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
select * from pdf where partno='2103-440-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.005931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679247 LIMIT 4 [ RunTime:0.007938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679247 ORDER BY `minOrder` ASC [ RunTime:0.014009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679247 ORDER BY `unit` DESC [ RunTime:0.002191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679247 LIMIT 2 [ RunTime:0.011629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679247 ORDER BY `minOrder` ASC [ RunTime:0.002388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10961644 LIMIT 4 [ RunTime:0.007177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10961644 ORDER BY `minOrder` ASC [ RunTime:0.013581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10961644 ORDER BY `unit` DESC [ RunTime:0.070789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10961644 LIMIT 2 [ RunTime:0.022112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10961644 ORDER BY `minOrder` ASC [ RunTime:0.026405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15481975 LIMIT 4 [ RunTime:0.045860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481975 ORDER BY `minOrder` ASC [ RunTime:0.018985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15481975 ORDER BY `unit` DESC [ RunTime:0.024463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15481975 LIMIT 2 [ RunTime:0.088005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481975 ORDER BY `minOrder` ASC [ RunTime:0.065130s ]
select * from pdf where partno='2102060-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.159825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13403955 LIMIT 4 [ RunTime:0.043873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403955 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13403955 ORDER BY `unit` DESC [ RunTime:0.002764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13403955 LIMIT 2 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403955 ORDER BY `minOrder` ASC [ RunTime:0.003928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042127 LIMIT 4 [ RunTime:0.005339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042127 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042127 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042127 LIMIT 2 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042127 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
select * from pdf where partno='2106-832-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883199 LIMIT 4 [ RunTime:0.006965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883199 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883199 ORDER BY `unit` DESC [ RunTime:0.001247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883199 LIMIT 2 [ RunTime:0.004680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883199 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
select * from pdf where partno='21033812800' and brandshort='HARTING' limit 1 [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33613922 LIMIT 4 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613922 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33613922 ORDER BY `unit` DESC [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33613922 LIMIT 2 [ RunTime:0.003098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33613922 ORDER BY `minOrder` ASC [ RunTime:0.002338s ]
select * from pdf where partno='2104-5204' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-5204' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009860s ]
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.062966s ]