SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001749s ]
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.004756s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001755s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000674s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001396s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002604s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002583s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002940s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001359s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004999s ]
UPDATE `stock_search` SET `count` = 2095 , `updatetime` = '2026-06-07 00:02:46' WHERE `partno` = '210' [ RunTime:0.020805s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008042s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002014s ]
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.012220s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001197s ]
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.104264s ]
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 3800,20 [ RunTime:0.103412s ]
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 ('17300015','17300007','17300006','17300005','17300004','17297123','17295907','17295898','17295897','17295868','17295867','17295866','17295862','17295861','17295859','17295858','17295851','17295850','17295832','17295831') ORDER BY FIELD(s.id, 17300015,17300007,17300006,17300005,17300004,17297123,17295907,17295898,17295897,17295868,17295867,17295866,17295862,17295861,17295859,17295858,17295851,17295850,17295832,17295831) [ RunTime:0.038938s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300015 LIMIT 4 [ RunTime:0.050998s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300015 ORDER BY `minOrder` ASC [ RunTime:0.026493s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300015 ORDER BY `unit` DESC [ RunTime:0.038894s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300015 LIMIT 2 [ RunTime:0.042728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300015 ORDER BY `minOrder` ASC [ RunTime:0.037061s ]
select * from pdf where partno='2107-2-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.037898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300007 LIMIT 4 [ RunTime:0.096878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300007 ORDER BY `minOrder` ASC [ RunTime:0.020472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300007 ORDER BY `unit` DESC [ RunTime:0.072261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300007 LIMIT 2 [ RunTime:0.020286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300007 ORDER BY `minOrder` ASC [ RunTime:0.038778s ]
select * from pdf where partno='2107-1-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.032092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300006 LIMIT 4 [ RunTime:0.023989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300006 ORDER BY `minOrder` ASC [ RunTime:0.046839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300006 ORDER BY `unit` DESC [ RunTime:0.057935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300006 LIMIT 2 [ RunTime:0.026194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300006 ORDER BY `minOrder` ASC [ RunTime:0.027570s ]
select * from pdf where partno='2107-1-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.021920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300005 LIMIT 4 [ RunTime:0.022879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300005 ORDER BY `minOrder` ASC [ RunTime:0.042959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300005 ORDER BY `unit` DESC [ RunTime:0.095679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300005 LIMIT 2 [ RunTime:0.045149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300005 ORDER BY `minOrder` ASC [ RunTime:0.034642s ]
select * from pdf where partno='2107-1-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.029692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300004 LIMIT 4 [ RunTime:0.059008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300004 ORDER BY `minOrder` ASC [ RunTime:0.094337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300004 ORDER BY `unit` DESC [ RunTime:0.050612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300004 LIMIT 2 [ RunTime:0.073742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300004 ORDER BY `minOrder` ASC [ RunTime:0.061335s ]
select * from pdf where partno='2103-1-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.051848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297123 LIMIT 4 [ RunTime:0.030871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297123 ORDER BY `minOrder` ASC [ RunTime:0.063306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297123 ORDER BY `unit` DESC [ RunTime:0.039835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297123 LIMIT 2 [ RunTime:0.042490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297123 ORDER BY `minOrder` ASC [ RunTime:0.038727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295907 LIMIT 4 [ RunTime:0.048501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295907 ORDER BY `minOrder` ASC [ RunTime:0.155516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295907 ORDER BY `unit` DESC [ RunTime:0.062358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295907 LIMIT 2 [ RunTime:0.018690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295907 ORDER BY `minOrder` ASC [ RunTime:0.010307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295898 LIMIT 4 [ RunTime:0.018247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295898 ORDER BY `minOrder` ASC [ RunTime:0.028825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295898 ORDER BY `unit` DESC [ RunTime:0.050451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295898 LIMIT 2 [ RunTime:0.082576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295898 ORDER BY `minOrder` ASC [ RunTime:0.028775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295897 LIMIT 4 [ RunTime:0.022811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295897 ORDER BY `minOrder` ASC [ RunTime:0.023237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295897 ORDER BY `unit` DESC [ RunTime:0.047510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295897 LIMIT 2 [ RunTime:0.026575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295897 ORDER BY `minOrder` ASC [ RunTime:0.028120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295868 LIMIT 4 [ RunTime:0.041044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295868 ORDER BY `minOrder` ASC [ RunTime:0.035846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295868 ORDER BY `unit` DESC [ RunTime:0.065729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295868 LIMIT 2 [ RunTime:0.034979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295868 ORDER BY `minOrder` ASC [ RunTime:0.010571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295867 LIMIT 4 [ RunTime:0.047643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295867 ORDER BY `minOrder` ASC [ RunTime:0.031991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295867 ORDER BY `unit` DESC [ RunTime:0.032437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295867 LIMIT 2 [ RunTime:0.029386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295867 ORDER BY `minOrder` ASC [ RunTime:0.028205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295866 LIMIT 4 [ RunTime:0.005791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295866 ORDER BY `minOrder` ASC [ RunTime:0.040214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295866 ORDER BY `unit` DESC [ RunTime:0.003716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295866 LIMIT 2 [ RunTime:0.041590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295866 ORDER BY `minOrder` ASC [ RunTime:0.010586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295862 LIMIT 4 [ RunTime:0.023209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295862 ORDER BY `minOrder` ASC [ RunTime:0.013691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295862 ORDER BY `unit` DESC [ RunTime:0.033257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295862 LIMIT 2 [ RunTime:0.024005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295862 ORDER BY `minOrder` ASC [ RunTime:0.009408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295861 LIMIT 4 [ RunTime:0.018957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295861 ORDER BY `minOrder` ASC [ RunTime:0.051322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295861 ORDER BY `unit` DESC [ RunTime:0.015854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295861 LIMIT 2 [ RunTime:0.038367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295861 ORDER BY `minOrder` ASC [ RunTime:0.009522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295859 LIMIT 4 [ RunTime:0.017888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295859 ORDER BY `minOrder` ASC [ RunTime:0.016959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295859 ORDER BY `unit` DESC [ RunTime:0.029804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295859 LIMIT 2 [ RunTime:0.014862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295859 ORDER BY `minOrder` ASC [ RunTime:0.004535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295858 LIMIT 4 [ RunTime:0.046326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295858 ORDER BY `minOrder` ASC [ RunTime:0.019844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295858 ORDER BY `unit` DESC [ RunTime:0.045733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295858 LIMIT 2 [ RunTime:0.042113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295858 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295851 LIMIT 4 [ RunTime:0.033931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295851 ORDER BY `minOrder` ASC [ RunTime:0.058852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295851 ORDER BY `unit` DESC [ RunTime:0.065159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295851 LIMIT 2 [ RunTime:0.055275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295851 ORDER BY `minOrder` ASC [ RunTime:0.040818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295850 LIMIT 4 [ RunTime:0.025648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295850 ORDER BY `minOrder` ASC [ RunTime:0.040499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295850 ORDER BY `unit` DESC [ RunTime:0.027935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295850 LIMIT 2 [ RunTime:0.058964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295850 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295832 LIMIT 4 [ RunTime:0.027601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295832 ORDER BY `minOrder` ASC [ RunTime:0.022557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295832 ORDER BY `unit` DESC [ RunTime:0.033741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295832 LIMIT 2 [ RunTime:0.026616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295832 ORDER BY `minOrder` ASC [ RunTime:0.008572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295831 LIMIT 4 [ RunTime:0.010488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295831 ORDER BY `minOrder` ASC [ RunTime:0.021985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295831 ORDER BY `unit` DESC [ RunTime:0.017832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295831 LIMIT 2 [ RunTime:0.019797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295831 ORDER BY `minOrder` ASC [ RunTime:0.009071s ]
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.006184s ]