SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001568s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001836s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001592s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001361s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.014926s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001466s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001658s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005167s ]
UPDATE `stock_search` SET `count` = 2407 , `updatetime` = '2026-06-07 02:59:02' WHERE `partno` = '210' [ RunTime:0.002161s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000233s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000205s ]
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.000342s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001330s ]
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.384689s ]
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 4000,20 [ RunTime:0.044697s ]
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 ('14696560','14695724','14695723','14695722','14695721','14695720','14695719','14695718','14695717','14695534','14695533','14695532','14695531','14695530','14695529','14695528','14695527','14695410','14694406','14694139') ORDER BY FIELD(s.id, 14696560,14695724,14695723,14695722,14695721,14695720,14695719,14695718,14695717,14695534,14695533,14695532,14695531,14695530,14695529,14695528,14695527,14695410,14694406,14694139) [ RunTime:0.011927s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696560 LIMIT 4 [ RunTime:0.014236s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696560 ORDER BY `minOrder` ASC [ RunTime:0.016264s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696560 ORDER BY `unit` DESC [ RunTime:0.002356s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696560 LIMIT 2 [ RunTime:0.022330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696560 ORDER BY `minOrder` ASC [ RunTime:0.023927s ]
select * from pdf where partno='21044161501' and brandshort='HARTING' limit 1 [ RunTime:0.012802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695724 LIMIT 4 [ RunTime:0.018242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695724 ORDER BY `minOrder` ASC [ RunTime:0.016203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695724 ORDER BY `unit` DESC [ RunTime:0.028556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695724 LIMIT 2 [ RunTime:0.051856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695724 ORDER BY `minOrder` ASC [ RunTime:0.013785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695723 LIMIT 4 [ RunTime:0.024490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695723 ORDER BY `minOrder` ASC [ RunTime:0.048459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695723 ORDER BY `unit` DESC [ RunTime:0.023927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695723 LIMIT 2 [ RunTime:0.035011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695723 ORDER BY `minOrder` ASC [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695722 LIMIT 4 [ RunTime:0.024375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695722 ORDER BY `minOrder` ASC [ RunTime:0.012594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695722 ORDER BY `unit` DESC [ RunTime:0.025745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695722 LIMIT 2 [ RunTime:0.057261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695722 ORDER BY `minOrder` ASC [ RunTime:0.026004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695721 LIMIT 4 [ RunTime:0.006165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695721 ORDER BY `minOrder` ASC [ RunTime:0.013329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695721 ORDER BY `unit` DESC [ RunTime:0.009159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695721 LIMIT 2 [ RunTime:0.025012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695721 ORDER BY `minOrder` ASC [ RunTime:0.010562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695720 LIMIT 4 [ RunTime:0.023845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695720 ORDER BY `minOrder` ASC [ RunTime:0.018530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695720 ORDER BY `unit` DESC [ RunTime:0.005251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695720 LIMIT 2 [ RunTime:0.021699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695720 ORDER BY `minOrder` ASC [ RunTime:0.017151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695719 LIMIT 4 [ RunTime:0.020348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695719 ORDER BY `minOrder` ASC [ RunTime:0.010597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695719 ORDER BY `unit` DESC [ RunTime:0.012669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695719 LIMIT 2 [ RunTime:0.012360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695719 ORDER BY `minOrder` ASC [ RunTime:0.030375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695718 LIMIT 4 [ RunTime:0.014995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695718 ORDER BY `minOrder` ASC [ RunTime:0.016354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695718 ORDER BY `unit` DESC [ RunTime:0.017334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695718 LIMIT 2 [ RunTime:0.001450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695718 ORDER BY `minOrder` ASC [ RunTime:0.005428s ]
select * from pdf where partno='21034851411' and brandshort='HARTING' limit 1 [ RunTime:0.008393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695717 LIMIT 4 [ RunTime:0.010290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695717 ORDER BY `minOrder` ASC [ RunTime:0.006577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695717 ORDER BY `unit` DESC [ RunTime:0.019284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695717 LIMIT 2 [ RunTime:0.009564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695717 ORDER BY `minOrder` ASC [ RunTime:0.018974s ]
select * from pdf where partno='21034851409' and brandshort='HARTING' limit 1 [ RunTime:0.011830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695534 LIMIT 4 [ RunTime:0.022027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695534 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695534 ORDER BY `unit` DESC [ RunTime:0.010899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695534 LIMIT 2 [ RunTime:0.005395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695534 ORDER BY `minOrder` ASC [ RunTime:0.016227s ]
select * from pdf where partno='21035853457' and brandshort='HARTING' limit 1 [ RunTime:0.014159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695533 LIMIT 4 [ RunTime:0.016112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695533 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695533 ORDER BY `unit` DESC [ RunTime:0.003684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695533 LIMIT 2 [ RunTime:0.010526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695533 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695532 LIMIT 4 [ RunTime:0.005286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695532 ORDER BY `minOrder` ASC [ RunTime:0.005926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695532 ORDER BY `unit` DESC [ RunTime:0.004583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695532 LIMIT 2 [ RunTime:0.012455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695532 ORDER BY `minOrder` ASC [ RunTime:0.007354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695531 LIMIT 4 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695531 ORDER BY `minOrder` ASC [ RunTime:0.007849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695531 ORDER BY `unit` DESC [ RunTime:0.007571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695531 LIMIT 2 [ RunTime:0.005829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695531 ORDER BY `minOrder` ASC [ RunTime:0.004768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695530 LIMIT 4 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695530 ORDER BY `minOrder` ASC [ RunTime:0.001455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695530 ORDER BY `unit` DESC [ RunTime:0.003454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695530 LIMIT 2 [ RunTime:0.006401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695530 ORDER BY `minOrder` ASC [ RunTime:0.005768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695529 LIMIT 4 [ RunTime:0.003501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695529 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695529 ORDER BY `unit` DESC [ RunTime:0.001411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695529 LIMIT 2 [ RunTime:0.004642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695529 ORDER BY `minOrder` ASC [ RunTime:0.003191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695528 LIMIT 4 [ RunTime:0.001990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695528 ORDER BY `minOrder` ASC [ RunTime:0.004207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695528 ORDER BY `unit` DESC [ RunTime:0.003356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695528 LIMIT 2 [ RunTime:0.003319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695528 ORDER BY `minOrder` ASC [ RunTime:0.008962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695527 LIMIT 4 [ RunTime:0.003886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695527 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695527 ORDER BY `unit` DESC [ RunTime:0.003958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695527 LIMIT 2 [ RunTime:0.007952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695527 ORDER BY `minOrder` ASC [ RunTime:0.004404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695410 LIMIT 4 [ RunTime:0.003645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695410 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695410 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695410 LIMIT 2 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695410 ORDER BY `minOrder` ASC [ RunTime:0.004677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14694406 LIMIT 4 [ RunTime:0.012235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694406 ORDER BY `minOrder` ASC [ RunTime:0.001171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14694406 ORDER BY `unit` DESC [ RunTime:0.001627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14694406 LIMIT 2 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694406 ORDER BY `minOrder` ASC [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14694139 LIMIT 4 [ RunTime:0.007036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694139 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14694139 ORDER BY `unit` DESC [ RunTime:0.001796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14694139 LIMIT 2 [ RunTime:0.001087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694139 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
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.078743s ]