SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001920s ]
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.007869s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001383s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001274s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.006030s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001266s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003325s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001440s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008705s ]
UPDATE `stock_search` SET `count` = 1046 , `updatetime` = '2026-06-05 16:51:02' WHERE `partno` = '210' [ RunTime:0.005866s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000287s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000259s ]
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.006614s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001590s ]
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.067362s ]
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 3260,20 [ RunTime:0.094894s ]
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 ('13806538','13806537','13806426','13805209','13804988','13804843','13804676','13804636','13804505','13804353','13803197','13802731','13802549','13802439','13802135','13801800','13800582','13800156','13799777','13799207') ORDER BY FIELD(s.id, 13806538,13806537,13806426,13805209,13804988,13804843,13804676,13804636,13804505,13804353,13803197,13802731,13802549,13802439,13802135,13801800,13800582,13800156,13799777,13799207) [ RunTime:0.017091s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13806538 LIMIT 4 [ RunTime:0.015953s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.042332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806538 ORDER BY `minOrder` ASC [ RunTime:0.020200s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13806538 ORDER BY `unit` DESC [ RunTime:0.025134s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13806538 LIMIT 2 [ RunTime:0.023445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806538 ORDER BY `minOrder` ASC [ RunTime:0.013137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13806537 LIMIT 4 [ RunTime:0.017576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806537 ORDER BY `minOrder` ASC [ RunTime:0.049008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13806537 ORDER BY `unit` DESC [ RunTime:0.028615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13806537 LIMIT 2 [ RunTime:0.064538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806537 ORDER BY `minOrder` ASC [ RunTime:0.009350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13806426 LIMIT 4 [ RunTime:0.021315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806426 ORDER BY `minOrder` ASC [ RunTime:0.055688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13806426 ORDER BY `unit` DESC [ RunTime:0.007628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13806426 LIMIT 2 [ RunTime:0.025609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13806426 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13805209 LIMIT 4 [ RunTime:0.027603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13805209 ORDER BY `minOrder` ASC [ RunTime:0.026961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13805209 ORDER BY `unit` DESC [ RunTime:0.040488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13805209 LIMIT 2 [ RunTime:0.015817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13805209 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804988 LIMIT 4 [ RunTime:0.026510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804988 ORDER BY `minOrder` ASC [ RunTime:0.023309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804988 ORDER BY `unit` DESC [ RunTime:0.043518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804988 LIMIT 2 [ RunTime:0.021337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804988 ORDER BY `minOrder` ASC [ RunTime:0.022220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804843 LIMIT 4 [ RunTime:0.068073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804843 ORDER BY `minOrder` ASC [ RunTime:0.027017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804843 ORDER BY `unit` DESC [ RunTime:0.033733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804843 LIMIT 2 [ RunTime:0.025537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804843 ORDER BY `minOrder` ASC [ RunTime:0.013063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804676 LIMIT 4 [ RunTime:0.017601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804676 ORDER BY `minOrder` ASC [ RunTime:0.024055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804676 ORDER BY `unit` DESC [ RunTime:0.012546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804676 LIMIT 2 [ RunTime:0.028504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804676 ORDER BY `minOrder` ASC [ RunTime:0.010682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804636 LIMIT 4 [ RunTime:0.009358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804636 ORDER BY `minOrder` ASC [ RunTime:0.007558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804636 ORDER BY `unit` DESC [ RunTime:0.004175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804636 LIMIT 2 [ RunTime:0.017869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804636 ORDER BY `minOrder` ASC [ RunTime:0.003564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804505 LIMIT 4 [ RunTime:0.025612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804505 ORDER BY `minOrder` ASC [ RunTime:0.007184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804505 ORDER BY `unit` DESC [ RunTime:0.013254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804505 LIMIT 2 [ RunTime:0.016484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804505 ORDER BY `minOrder` ASC [ RunTime:0.010353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804353 LIMIT 4 [ RunTime:0.010338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804353 ORDER BY `minOrder` ASC [ RunTime:0.002701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804353 ORDER BY `unit` DESC [ RunTime:0.010323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804353 LIMIT 2 [ RunTime:0.017154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804353 ORDER BY `minOrder` ASC [ RunTime:0.001754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803197 LIMIT 4 [ RunTime:0.010192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803197 ORDER BY `minOrder` ASC [ RunTime:0.023418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13803197 ORDER BY `unit` DESC [ RunTime:0.010627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13803197 LIMIT 2 [ RunTime:0.004734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803197 ORDER BY `minOrder` ASC [ RunTime:0.003729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13802731 LIMIT 4 [ RunTime:0.014154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802731 ORDER BY `minOrder` ASC [ RunTime:0.008348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13802731 ORDER BY `unit` DESC [ RunTime:0.008175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13802731 LIMIT 2 [ RunTime:0.002853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802731 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13802549 LIMIT 4 [ RunTime:0.007079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802549 ORDER BY `minOrder` ASC [ RunTime:0.006377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13802549 ORDER BY `unit` DESC [ RunTime:0.006464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13802549 LIMIT 2 [ RunTime:0.003884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802549 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13802439 LIMIT 4 [ RunTime:0.011046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802439 ORDER BY `minOrder` ASC [ RunTime:0.006046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13802439 ORDER BY `unit` DESC [ RunTime:0.001226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13802439 LIMIT 2 [ RunTime:0.004344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802439 ORDER BY `minOrder` ASC [ RunTime:0.008443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13802135 LIMIT 4 [ RunTime:0.014441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802135 ORDER BY `minOrder` ASC [ RunTime:0.001841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13802135 ORDER BY `unit` DESC [ RunTime:0.010110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13802135 LIMIT 2 [ RunTime:0.003970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13802135 ORDER BY `minOrder` ASC [ RunTime:0.007488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13801800 LIMIT 4 [ RunTime:0.070638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13801800 ORDER BY `minOrder` ASC [ RunTime:0.034080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13801800 ORDER BY `unit` DESC [ RunTime:0.026553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13801800 LIMIT 2 [ RunTime:0.045924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13801800 ORDER BY `minOrder` ASC [ RunTime:0.065576s ]
select * from pdf where partno='21034851401' and brandshort='HARTING' limit 1 [ RunTime:0.044726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13800582 LIMIT 4 [ RunTime:0.039876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800582 ORDER BY `minOrder` ASC [ RunTime:0.020114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13800582 ORDER BY `unit` DESC [ RunTime:0.068051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13800582 LIMIT 2 [ RunTime:0.004857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800582 ORDER BY `minOrder` ASC [ RunTime:0.053755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13800156 LIMIT 4 [ RunTime:0.046495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800156 ORDER BY `minOrder` ASC [ RunTime:0.035338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13800156 ORDER BY `unit` DESC [ RunTime:0.013138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13800156 LIMIT 2 [ RunTime:0.003037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800156 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13799777 LIMIT 4 [ RunTime:0.004873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799777 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13799777 ORDER BY `unit` DESC [ RunTime:0.005206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13799777 LIMIT 2 [ RunTime:0.000940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799777 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13799207 LIMIT 4 [ RunTime:0.007265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799207 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13799207 ORDER BY `unit` DESC [ RunTime:0.001804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13799207 LIMIT 2 [ RunTime:0.003794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799207 ORDER BY `minOrder` ASC [ RunTime:0.002052s ]
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.064751s ]