SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002374s ]
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.001629s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001272s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001675s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002241s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002161s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001557s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000737s ]
UPDATE `stock_search` SET `count` = 1924 , `updatetime` = '2026-06-06 21:02:13' WHERE `partno` = '210' [ RunTime:0.001597s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000239s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000241s ]
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.000434s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001694s ]
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.103592s ]
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 5020,20 [ RunTime:0.064717s ]
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 ('12029731','12029526','12029458','12029326','12029180','12029179','12029149','12028914','12028789','12028162','12027891','12027386','12027152','12026953','12026914','12026826','12026587','12026538','12025713','12025288') ORDER BY FIELD(s.id, 12029731,12029526,12029458,12029326,12029180,12029179,12029149,12028914,12028789,12028162,12027891,12027386,12027152,12026953,12026914,12026826,12026587,12026538,12025713,12025288) [ RunTime:0.007691s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029731 LIMIT 4 [ RunTime:0.002365s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029731 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029731 ORDER BY `unit` DESC [ RunTime:0.019949s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029731 LIMIT 2 [ RunTime:0.009089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029731 ORDER BY `minOrder` ASC [ RunTime:0.002554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029526 LIMIT 4 [ RunTime:0.002416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029526 ORDER BY `minOrder` ASC [ RunTime:0.004898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029526 ORDER BY `unit` DESC [ RunTime:0.009511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029526 LIMIT 2 [ RunTime:0.004495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029526 ORDER BY `minOrder` ASC [ RunTime:0.007710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029458 LIMIT 4 [ RunTime:0.006935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029458 ORDER BY `minOrder` ASC [ RunTime:0.007224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029458 ORDER BY `unit` DESC [ RunTime:0.005611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029458 LIMIT 2 [ RunTime:0.009331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029458 ORDER BY `minOrder` ASC [ RunTime:0.007886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029326 LIMIT 4 [ RunTime:0.010787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029326 ORDER BY `minOrder` ASC [ RunTime:0.009650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029326 ORDER BY `unit` DESC [ RunTime:0.016228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029326 LIMIT 2 [ RunTime:0.014284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029326 ORDER BY `minOrder` ASC [ RunTime:0.021332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029180 LIMIT 4 [ RunTime:0.015253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029180 ORDER BY `minOrder` ASC [ RunTime:0.012188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029180 ORDER BY `unit` DESC [ RunTime:0.040775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029180 LIMIT 2 [ RunTime:0.008464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029180 ORDER BY `minOrder` ASC [ RunTime:0.020643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029179 LIMIT 4 [ RunTime:0.015786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029179 ORDER BY `minOrder` ASC [ RunTime:0.034795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029179 ORDER BY `unit` DESC [ RunTime:0.011576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029179 LIMIT 2 [ RunTime:0.033644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029179 ORDER BY `minOrder` ASC [ RunTime:0.008197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029149 LIMIT 4 [ RunTime:0.008715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029149 ORDER BY `minOrder` ASC [ RunTime:0.041148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029149 ORDER BY `unit` DESC [ RunTime:0.033087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029149 LIMIT 2 [ RunTime:0.010573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029149 ORDER BY `minOrder` ASC [ RunTime:0.008813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028914 LIMIT 4 [ RunTime:0.021470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028914 ORDER BY `minOrder` ASC [ RunTime:0.017470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028914 ORDER BY `unit` DESC [ RunTime:0.018872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028914 LIMIT 2 [ RunTime:0.062364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028914 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028789 LIMIT 4 [ RunTime:0.020736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028789 ORDER BY `minOrder` ASC [ RunTime:0.008708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028789 ORDER BY `unit` DESC [ RunTime:0.017990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028789 LIMIT 2 [ RunTime:0.017596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028789 ORDER BY `minOrder` ASC [ RunTime:0.019762s ]
select * from pdf where partno='2109452-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028162 LIMIT 4 [ RunTime:0.027238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028162 ORDER BY `minOrder` ASC [ RunTime:0.006400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028162 ORDER BY `unit` DESC [ RunTime:0.002078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028162 LIMIT 2 [ RunTime:0.010297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028162 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027891 LIMIT 4 [ RunTime:0.008523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027891 ORDER BY `minOrder` ASC [ RunTime:0.008130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027891 ORDER BY `unit` DESC [ RunTime:0.013645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027891 LIMIT 2 [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027891 ORDER BY `minOrder` ASC [ RunTime:0.001615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027386 LIMIT 4 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027386 ORDER BY `minOrder` ASC [ RunTime:0.020016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027386 ORDER BY `unit` DESC [ RunTime:0.022141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027386 LIMIT 2 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027386 ORDER BY `minOrder` ASC [ RunTime:0.013596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027152 LIMIT 4 [ RunTime:0.011319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027152 ORDER BY `minOrder` ASC [ RunTime:0.019775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027152 ORDER BY `unit` DESC [ RunTime:0.020840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027152 LIMIT 2 [ RunTime:0.012933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027152 ORDER BY `minOrder` ASC [ RunTime:0.005717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026953 LIMIT 4 [ RunTime:0.010779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026953 ORDER BY `minOrder` ASC [ RunTime:0.043885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026953 ORDER BY `unit` DESC [ RunTime:0.039838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026953 LIMIT 2 [ RunTime:0.020110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026953 ORDER BY `minOrder` ASC [ RunTime:0.014932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026914 LIMIT 4 [ RunTime:0.025802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026914 ORDER BY `minOrder` ASC [ RunTime:0.038508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026914 ORDER BY `unit` DESC [ RunTime:0.009128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026914 LIMIT 2 [ RunTime:0.040471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026914 ORDER BY `minOrder` ASC [ RunTime:0.017842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026826 LIMIT 4 [ RunTime:0.022174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026826 ORDER BY `minOrder` ASC [ RunTime:0.022620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026826 ORDER BY `unit` DESC [ RunTime:0.032028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026826 LIMIT 2 [ RunTime:0.032042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026826 ORDER BY `minOrder` ASC [ RunTime:0.005180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026587 LIMIT 4 [ RunTime:0.015458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026587 ORDER BY `minOrder` ASC [ RunTime:0.028565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026587 ORDER BY `unit` DESC [ RunTime:0.003701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026587 LIMIT 2 [ RunTime:0.056779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026587 ORDER BY `minOrder` ASC [ RunTime:0.027577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026538 LIMIT 4 [ RunTime:0.050403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026538 ORDER BY `minOrder` ASC [ RunTime:0.031966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026538 ORDER BY `unit` DESC [ RunTime:0.018694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026538 LIMIT 2 [ RunTime:0.021995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026538 ORDER BY `minOrder` ASC [ RunTime:0.020728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12025713 LIMIT 4 [ RunTime:0.038629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025713 ORDER BY `minOrder` ASC [ RunTime:0.018452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12025713 ORDER BY `unit` DESC [ RunTime:0.039843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12025713 LIMIT 2 [ RunTime:0.022894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025713 ORDER BY `minOrder` ASC [ RunTime:0.008850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12025288 LIMIT 4 [ RunTime:0.012719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025288 ORDER BY `minOrder` ASC [ RunTime:0.040745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12025288 ORDER BY `unit` DESC [ RunTime:0.068688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12025288 LIMIT 2 [ RunTime:0.031360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025288 ORDER BY `minOrder` ASC [ RunTime:0.014185s ]
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.016033s ]