SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001397s ]
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.003506s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002311s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002474s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.013182s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001960s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003812s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001998s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.008208s ]
UPDATE `stock_search` SET `count` = 1056 , `updatetime` = '2026-06-05 20:08:04' WHERE `partno` = '210' [ RunTime:0.001008s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003769s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006129s ]
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.022501s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002865s ]
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.234122s ]
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 3180,20 [ RunTime:0.054878s ]
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 ('14280361','14280360','14280359','14280358','14280357','14280356','14280355','14280354','14280353','14280352','14279862','14279861','14279860','14279859','14279858','14279857','14279856','14279855','14279854','14279853') ORDER BY FIELD(s.id, 14280361,14280360,14280359,14280358,14280357,14280356,14280355,14280354,14280353,14280352,14279862,14279861,14279860,14279859,14279858,14279857,14279856,14279855,14279854,14279853) [ RunTime:0.002615s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280361 LIMIT 4 [ RunTime:0.006277s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280361 ORDER BY `minOrder` ASC [ RunTime:0.021414s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280361 ORDER BY `unit` DESC [ RunTime:0.019728s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280361 LIMIT 2 [ RunTime:0.046728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280361 ORDER BY `minOrder` ASC [ RunTime:0.011221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280360 LIMIT 4 [ RunTime:0.046992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280360 ORDER BY `minOrder` ASC [ RunTime:0.025400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280360 ORDER BY `unit` DESC [ RunTime:0.032795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280360 LIMIT 2 [ RunTime:0.072412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280360 ORDER BY `minOrder` ASC [ RunTime:0.007907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280359 LIMIT 4 [ RunTime:0.016141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280359 ORDER BY `minOrder` ASC [ RunTime:0.009969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280359 ORDER BY `unit` DESC [ RunTime:0.023120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280359 LIMIT 2 [ RunTime:0.021971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280359 ORDER BY `minOrder` ASC [ RunTime:0.014738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280358 LIMIT 4 [ RunTime:0.022966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280358 ORDER BY `minOrder` ASC [ RunTime:0.012835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280358 ORDER BY `unit` DESC [ RunTime:0.015732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280358 LIMIT 2 [ RunTime:0.055076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280358 ORDER BY `minOrder` ASC [ RunTime:0.015435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280357 LIMIT 4 [ RunTime:0.056423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280357 ORDER BY `minOrder` ASC [ RunTime:0.034684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280357 ORDER BY `unit` DESC [ RunTime:0.011924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280357 LIMIT 2 [ RunTime:0.016010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280357 ORDER BY `minOrder` ASC [ RunTime:0.005550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280356 LIMIT 4 [ RunTime:0.008827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280356 ORDER BY `minOrder` ASC [ RunTime:0.009512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280356 ORDER BY `unit` DESC [ RunTime:0.008196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280356 LIMIT 2 [ RunTime:0.012184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280356 ORDER BY `minOrder` ASC [ RunTime:0.005405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280355 LIMIT 4 [ RunTime:0.007104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280355 ORDER BY `minOrder` ASC [ RunTime:0.004684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280355 ORDER BY `unit` DESC [ RunTime:0.017065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280355 LIMIT 2 [ RunTime:0.016717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280355 ORDER BY `minOrder` ASC [ RunTime:0.016932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280354 LIMIT 4 [ RunTime:0.006154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280354 ORDER BY `minOrder` ASC [ RunTime:0.002719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280354 ORDER BY `unit` DESC [ RunTime:0.005944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280354 LIMIT 2 [ RunTime:0.009175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280354 ORDER BY `minOrder` ASC [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280353 LIMIT 4 [ RunTime:0.006635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280353 ORDER BY `minOrder` ASC [ RunTime:0.005347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280353 ORDER BY `unit` DESC [ RunTime:0.004005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280353 LIMIT 2 [ RunTime:0.006095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280353 ORDER BY `minOrder` ASC [ RunTime:0.001734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280352 LIMIT 4 [ RunTime:0.007179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280352 ORDER BY `minOrder` ASC [ RunTime:0.002865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280352 ORDER BY `unit` DESC [ RunTime:0.001811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280352 LIMIT 2 [ RunTime:0.002233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280352 ORDER BY `minOrder` ASC [ RunTime:0.007089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279862 LIMIT 4 [ RunTime:0.003134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279862 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279862 ORDER BY `unit` DESC [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279862 LIMIT 2 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279862 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279861 LIMIT 4 [ RunTime:0.004743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279861 ORDER BY `minOrder` ASC [ RunTime:0.005135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279861 ORDER BY `unit` DESC [ RunTime:0.003928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279861 LIMIT 2 [ RunTime:0.006147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279861 ORDER BY `minOrder` ASC [ RunTime:0.005041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279860 LIMIT 4 [ RunTime:0.005585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279860 ORDER BY `minOrder` ASC [ RunTime:0.002034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279860 ORDER BY `unit` DESC [ RunTime:0.001155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279860 LIMIT 2 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279860 ORDER BY `minOrder` ASC [ RunTime:0.016777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279859 LIMIT 4 [ RunTime:0.039383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279859 ORDER BY `minOrder` ASC [ RunTime:0.004793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279859 ORDER BY `unit` DESC [ RunTime:0.041262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279859 LIMIT 2 [ RunTime:0.032996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279859 ORDER BY `minOrder` ASC [ RunTime:0.032819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279858 LIMIT 4 [ RunTime:0.076178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279858 ORDER BY `minOrder` ASC [ RunTime:0.039119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279858 ORDER BY `unit` DESC [ RunTime:0.014573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279858 LIMIT 2 [ RunTime:0.040176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279858 ORDER BY `minOrder` ASC [ RunTime:0.038317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279857 LIMIT 4 [ RunTime:0.039106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279857 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279857 ORDER BY `unit` DESC [ RunTime:0.039009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279857 LIMIT 2 [ RunTime:0.067715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279857 ORDER BY `minOrder` ASC [ RunTime:0.005683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279856 LIMIT 4 [ RunTime:0.004814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279856 ORDER BY `minOrder` ASC [ RunTime:0.009253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279856 ORDER BY `unit` DESC [ RunTime:0.008045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279856 LIMIT 2 [ RunTime:0.002561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279856 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279855 LIMIT 4 [ RunTime:0.004716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279855 ORDER BY `minOrder` ASC [ RunTime:0.007095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279855 ORDER BY `unit` DESC [ RunTime:0.022744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279855 LIMIT 2 [ RunTime:0.003108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279855 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279854 LIMIT 4 [ RunTime:0.001880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279854 ORDER BY `minOrder` ASC [ RunTime:0.006393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279854 ORDER BY `unit` DESC [ RunTime:0.006697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279854 LIMIT 2 [ RunTime:0.002168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279854 ORDER BY `minOrder` ASC [ RunTime:0.002072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279853 LIMIT 4 [ RunTime:0.001526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279853 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279853 ORDER BY `unit` DESC [ RunTime:0.006433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279853 LIMIT 2 [ RunTime:0.006586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279853 ORDER BY `minOrder` ASC [ RunTime:0.007850s ]
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.050085s ]