SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002440s ]
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.001828s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003142s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003226s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.011119s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003050s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000987s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002887s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.017368s ]
UPDATE `stock_search` SET `count` = 1707 , `updatetime` = '2026-06-06 19:52:39' WHERE `partno` = '210' [ RunTime:0.008959s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003957s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000581s ]
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.005487s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002523s ]
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.100443s ]
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 3380,20 [ RunTime:0.080667s ]
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 ('19592518','19592516','19592515','19592477','19592474','19592460','19592447','19592446','19592436','19592435','19592434','19592429','19592428','19592424','19592423','19592422','19592344','19592343','19592320','19592314') ORDER BY FIELD(s.id, 19592518,19592516,19592515,19592477,19592474,19592460,19592447,19592446,19592436,19592435,19592434,19592429,19592428,19592424,19592423,19592422,19592344,19592343,19592320,19592314) [ RunTime:0.025175s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592518 LIMIT 4 [ RunTime:0.027361s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592518 ORDER BY `minOrder` ASC [ RunTime:0.011540s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592518 ORDER BY `unit` DESC [ RunTime:0.021250s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592518 LIMIT 2 [ RunTime:0.023111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592518 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
select * from pdf where partno='2104-4-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.029646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592516 LIMIT 4 [ RunTime:0.036168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592516 ORDER BY `minOrder` ASC [ RunTime:0.005618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592516 ORDER BY `unit` DESC [ RunTime:0.038113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592516 LIMIT 2 [ RunTime:0.022269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592516 ORDER BY `minOrder` ASC [ RunTime:0.013409s ]
select * from pdf where partno='2103-1-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.021272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592515 LIMIT 4 [ RunTime:0.039084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592515 ORDER BY `minOrder` ASC [ RunTime:0.004446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592515 ORDER BY `unit` DESC [ RunTime:0.018262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592515 LIMIT 2 [ RunTime:0.034230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592515 ORDER BY `minOrder` ASC [ RunTime:0.003372s ]
select * from pdf where partno='2103-1-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592477 LIMIT 4 [ RunTime:0.007232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592477 ORDER BY `minOrder` ASC [ RunTime:0.014882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592477 ORDER BY `unit` DESC [ RunTime:0.025767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592477 LIMIT 2 [ RunTime:0.013345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592477 ORDER BY `minOrder` ASC [ RunTime:0.022124s ]
select * from pdf where partno='2105-4-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.041779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592474 LIMIT 4 [ RunTime:0.060084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592474 ORDER BY `minOrder` ASC [ RunTime:0.028975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592474 ORDER BY `unit` DESC [ RunTime:0.046900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592474 LIMIT 2 [ RunTime:0.033607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592474 ORDER BY `minOrder` ASC [ RunTime:0.014261s ]
select * from pdf where partno='2105-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.023482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592460 LIMIT 4 [ RunTime:0.065061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592460 ORDER BY `minOrder` ASC [ RunTime:0.049750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592460 ORDER BY `unit` DESC [ RunTime:0.043549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592460 LIMIT 2 [ RunTime:0.038126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592460 ORDER BY `minOrder` ASC [ RunTime:0.048256s ]
select * from pdf where partno='2105-1-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.062801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592447 LIMIT 4 [ RunTime:0.040657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592447 ORDER BY `minOrder` ASC [ RunTime:0.041129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592447 ORDER BY `unit` DESC [ RunTime:0.037650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592447 LIMIT 2 [ RunTime:0.046047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592447 ORDER BY `minOrder` ASC [ RunTime:0.016115s ]
select * from pdf where partno='2104-4-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.039465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592446 LIMIT 4 [ RunTime:0.028416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592446 ORDER BY `minOrder` ASC [ RunTime:0.049053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592446 ORDER BY `unit` DESC [ RunTime:0.027709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592446 LIMIT 2 [ RunTime:0.034148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592446 ORDER BY `minOrder` ASC [ RunTime:0.013095s ]
select * from pdf where partno='2104-4-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.060888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592436 LIMIT 4 [ RunTime:0.059073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592436 ORDER BY `minOrder` ASC [ RunTime:0.032680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592436 ORDER BY `unit` DESC [ RunTime:0.037328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592436 LIMIT 2 [ RunTime:0.085513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592436 ORDER BY `minOrder` ASC [ RunTime:0.004831s ]
select * from pdf where partno='2104-3-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.039579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592435 LIMIT 4 [ RunTime:0.036815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592435 ORDER BY `minOrder` ASC [ RunTime:0.039897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592435 ORDER BY `unit` DESC [ RunTime:0.021848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592435 LIMIT 2 [ RunTime:0.027322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592435 ORDER BY `minOrder` ASC [ RunTime:0.057050s ]
select * from pdf where partno='2104-3-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.035279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592434 LIMIT 4 [ RunTime:0.028315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592434 ORDER BY `minOrder` ASC [ RunTime:0.023783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592434 ORDER BY `unit` DESC [ RunTime:0.042446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592434 LIMIT 2 [ RunTime:0.026285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592434 ORDER BY `minOrder` ASC [ RunTime:0.024429s ]
select * from pdf where partno='2104-3-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.033695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592429 LIMIT 4 [ RunTime:0.036412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592429 ORDER BY `minOrder` ASC [ RunTime:0.034014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592429 ORDER BY `unit` DESC [ RunTime:0.042381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592429 LIMIT 2 [ RunTime:0.063763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592429 ORDER BY `minOrder` ASC [ RunTime:0.022589s ]
select * from pdf where partno='2106-2-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.014754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592428 LIMIT 4 [ RunTime:0.046615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592428 ORDER BY `minOrder` ASC [ RunTime:0.058386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592428 ORDER BY `unit` DESC [ RunTime:0.084916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592428 LIMIT 2 [ RunTime:0.055437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592428 ORDER BY `minOrder` ASC [ RunTime:0.065496s ]
select * from pdf where partno='2106-2-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.023192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592424 LIMIT 4 [ RunTime:0.037614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592424 ORDER BY `minOrder` ASC [ RunTime:0.059996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592424 ORDER BY `unit` DESC [ RunTime:0.015940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592424 LIMIT 2 [ RunTime:0.039502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592424 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
select * from pdf where partno='2104-1-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.038541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592423 LIMIT 4 [ RunTime:0.037728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592423 ORDER BY `minOrder` ASC [ RunTime:0.017842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592423 ORDER BY `unit` DESC [ RunTime:0.054135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592423 LIMIT 2 [ RunTime:0.023751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592423 ORDER BY `minOrder` ASC [ RunTime:0.007919s ]
select * from pdf where partno='2104-1-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592422 LIMIT 4 [ RunTime:0.055650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592422 ORDER BY `minOrder` ASC [ RunTime:0.060334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592422 ORDER BY `unit` DESC [ RunTime:0.039669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592422 LIMIT 2 [ RunTime:0.023833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592422 ORDER BY `minOrder` ASC [ RunTime:0.010548s ]
select * from pdf where partno='2104-1-01-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592344 LIMIT 4 [ RunTime:0.015151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592344 ORDER BY `minOrder` ASC [ RunTime:0.012227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592344 ORDER BY `unit` DESC [ RunTime:0.002988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592344 LIMIT 2 [ RunTime:0.012887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592344 ORDER BY `minOrder` ASC [ RunTime:0.007757s ]
select * from pdf where partno='2106-1-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.007964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592343 LIMIT 4 [ RunTime:0.011533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592343 ORDER BY `minOrder` ASC [ RunTime:0.042916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592343 ORDER BY `unit` DESC [ RunTime:0.025193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592343 LIMIT 2 [ RunTime:0.008230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592343 ORDER BY `minOrder` ASC [ RunTime:0.006885s ]
select * from pdf where partno='2106-1-01-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592320 LIMIT 4 [ RunTime:0.007339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592320 ORDER BY `minOrder` ASC [ RunTime:0.014976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592320 ORDER BY `unit` DESC [ RunTime:0.043431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592320 LIMIT 2 [ RunTime:0.005395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592320 ORDER BY `minOrder` ASC [ RunTime:0.003590s ]
select * from pdf where partno='2105-2-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.010085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19592314 LIMIT 4 [ RunTime:0.018909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592314 ORDER BY `minOrder` ASC [ RunTime:0.010015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19592314 ORDER BY `unit` DESC [ RunTime:0.025986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19592314 LIMIT 2 [ RunTime:0.028490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19592314 ORDER BY `minOrder` ASC [ RunTime:0.018569s ]
select * from pdf where partno='2105-4-01-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003209s ]
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.005769s ]