SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002139s ]
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.001821s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002314s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000690s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001896s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001672s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001337s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006520s ]
UPDATE `stock_search` SET `count` = 906 , `updatetime` = '2026-06-05 15:44:26' WHERE `partno` = '210' [ RunTime:0.002882s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000232s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000214s ]
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.000378s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001829s ]
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.089427s ]
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 3780,20 [ RunTime:0.046115s ]
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 ('12978691','12978548','12978518','12978421','12978359','12978272','12978156','12978155','12978036','12978035','12977938','12977327','12977326','12977283','12977231','12977230','12977164','12976749','12976748','12976536') ORDER BY FIELD(s.id, 12978691,12978548,12978518,12978421,12978359,12978272,12978156,12978155,12978036,12978035,12977938,12977327,12977326,12977283,12977231,12977230,12977164,12976749,12976748,12976536) [ RunTime:0.002366s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978691 LIMIT 4 [ RunTime:0.000990s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978691 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978691 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978691 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978691 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
select * from pdf where partno='21038813807' and brandshort='HARTING' limit 1 [ RunTime:0.001541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978548 LIMIT 4 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978548 ORDER BY `minOrder` ASC [ RunTime:0.007138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978548 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978548 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978548 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
select * from pdf where partno='21038821405' and brandshort='HARTING' limit 1 [ RunTime:0.002796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978518 LIMIT 4 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978518 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978518 ORDER BY `unit` DESC [ RunTime:0.008795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978518 LIMIT 2 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978518 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978421 LIMIT 4 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978421 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978421 ORDER BY `unit` DESC [ RunTime:0.007008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978421 LIMIT 2 [ RunTime:0.005534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978421 ORDER BY `minOrder` ASC [ RunTime:0.002718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978359 LIMIT 4 [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978359 ORDER BY `minOrder` ASC [ RunTime:0.008279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978359 ORDER BY `unit` DESC [ RunTime:0.003948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978359 LIMIT 2 [ RunTime:0.005224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978359 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
select * from pdf where partno='21038211833' and brandshort='HARTING' limit 1 [ RunTime:0.001316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978272 LIMIT 4 [ RunTime:0.008332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978272 ORDER BY `minOrder` ASC [ RunTime:0.001405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978272 ORDER BY `unit` DESC [ RunTime:0.006545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978272 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978272 ORDER BY `minOrder` ASC [ RunTime:0.002091s ]
select * from pdf where partno='21038961510' and brandshort='HARTING' limit 1 [ RunTime:0.006685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978156 LIMIT 4 [ RunTime:0.002067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978156 ORDER BY `minOrder` ASC [ RunTime:0.009205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978156 ORDER BY `unit` DESC [ RunTime:0.003517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978156 LIMIT 2 [ RunTime:0.005624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978156 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
select * from pdf where partno='21038213533' and brandshort='HARTING' limit 1 [ RunTime:0.006878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978155 LIMIT 4 [ RunTime:0.006124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978155 ORDER BY `minOrder` ASC [ RunTime:0.002412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978155 ORDER BY `unit` DESC [ RunTime:0.006981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978155 LIMIT 2 [ RunTime:0.006285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978155 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
select * from pdf where partno='21038213833' and brandshort='HARTING' limit 1 [ RunTime:0.008230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978036 LIMIT 4 [ RunTime:0.003417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978036 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978036 ORDER BY `unit` DESC [ RunTime:0.002247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978036 LIMIT 2 [ RunTime:0.002064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978036 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12978035 LIMIT 4 [ RunTime:0.004684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978035 ORDER BY `minOrder` ASC [ RunTime:0.002459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12978035 ORDER BY `unit` DESC [ RunTime:0.007776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12978035 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12978035 ORDER BY `minOrder` ASC [ RunTime:0.003978s ]
select * from pdf where partno='21038813433' and brandshort='HARTING' limit 1 [ RunTime:0.001316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977938 LIMIT 4 [ RunTime:0.006199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977938 ORDER BY `minOrder` ASC [ RunTime:0.001124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977938 ORDER BY `unit` DESC [ RunTime:0.003361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977938 LIMIT 2 [ RunTime:0.003115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977938 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
select * from pdf where partno='21038812413' and brandshort='HARTING' limit 1 [ RunTime:0.003937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977327 LIMIT 4 [ RunTime:0.002468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977327 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977327 ORDER BY `unit` DESC [ RunTime:0.005656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977327 LIMIT 2 [ RunTime:0.017425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977327 ORDER BY `minOrder` ASC [ RunTime:0.005878s ]
select * from pdf where partno='21038214507' and brandshort='HARTING' limit 1 [ RunTime:0.011645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977326 LIMIT 4 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977326 ORDER BY `minOrder` ASC [ RunTime:0.003410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977326 ORDER BY `unit` DESC [ RunTime:0.005772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977326 LIMIT 2 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977326 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
select * from pdf where partno='21038213807' and brandshort='HARTING' limit 1 [ RunTime:0.003709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977283 LIMIT 4 [ RunTime:0.009574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977283 ORDER BY `minOrder` ASC [ RunTime:0.007570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977283 ORDER BY `unit` DESC [ RunTime:0.002141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977283 LIMIT 2 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977283 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977231 LIMIT 4 [ RunTime:0.007206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977231 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977231 ORDER BY `unit` DESC [ RunTime:0.002984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977231 LIMIT 2 [ RunTime:0.005105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977231 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
select * from pdf where partno='21038811433' and brandshort='HARTING' limit 1 [ RunTime:0.009240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977230 LIMIT 4 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977230 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977230 ORDER BY `unit` DESC [ RunTime:0.010661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977230 LIMIT 2 [ RunTime:0.021869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977230 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
select * from pdf where partno='21038814407' and brandshort='HARTING' limit 1 [ RunTime:0.010542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12977164 LIMIT 4 [ RunTime:0.022015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977164 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12977164 ORDER BY `unit` DESC [ RunTime:0.008494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12977164 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12977164 ORDER BY `minOrder` ASC [ RunTime:0.013367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12976749 LIMIT 4 [ RunTime:0.023769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976749 ORDER BY `minOrder` ASC [ RunTime:0.004478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12976749 ORDER BY `unit` DESC [ RunTime:0.007839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12976749 LIMIT 2 [ RunTime:0.025334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976749 ORDER BY `minOrder` ASC [ RunTime:0.003436s ]
select * from pdf where partno='21038212527' and brandshort='HARTING' limit 1 [ RunTime:0.020024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12976748 LIMIT 4 [ RunTime:0.007054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976748 ORDER BY `minOrder` ASC [ RunTime:0.001108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12976748 ORDER BY `unit` DESC [ RunTime:0.011078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12976748 LIMIT 2 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976748 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='21038212827' and brandshort='HARTING' limit 1 [ RunTime:0.005965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12976536 LIMIT 4 [ RunTime:0.004505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976536 ORDER BY `minOrder` ASC [ RunTime:0.010385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12976536 ORDER BY `unit` DESC [ RunTime:0.002591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12976536 LIMIT 2 [ RunTime:0.014273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12976536 ORDER BY `minOrder` ASC [ RunTime:0.003169s ]
select * from pdf where partno='21038211507' and brandshort='HARTING' limit 1 [ RunTime:0.004796s ]
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.006109s ]