SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001890s ]
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.001777s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001881s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.030366s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001318s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.007801s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001323s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007830s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002134s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.018314s ]
UPDATE `stock_search` SET `count` = 1991 , `updatetime` = '2026-06-06 21:08:28' WHERE `partno` = '210' [ RunTime:0.007882s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.007174s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.007986s ]
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.011304s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001898s ]
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.038072s ]
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 5340,20 [ RunTime:0.112597s ]
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 ('11419134','11419133','11419132','11419131','11419130','11419125','11419124','11419123','11419122','11419121','11412601','11406857','11406814','11406811','11406800','11406797','11405899','11405893','11405890','11405889') ORDER BY FIELD(s.id, 11419134,11419133,11419132,11419131,11419130,11419125,11419124,11419123,11419122,11419121,11412601,11406857,11406814,11406811,11406800,11406797,11405899,11405893,11405890,11405889) [ RunTime:0.069183s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.068858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419134 LIMIT 4 [ RunTime:0.073902s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419134 ORDER BY `minOrder` ASC [ RunTime:0.075651s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419134 ORDER BY `unit` DESC [ RunTime:0.059880s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419134 LIMIT 2 [ RunTime:0.066774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419134 ORDER BY `minOrder` ASC [ RunTime:0.139415s ]
select * from pdf where partno='2108-3-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.044252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419133 LIMIT 4 [ RunTime:0.020722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419133 ORDER BY `minOrder` ASC [ RunTime:0.052776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419133 ORDER BY `unit` DESC [ RunTime:0.068983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419133 LIMIT 2 [ RunTime:0.050165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419133 ORDER BY `minOrder` ASC [ RunTime:0.016096s ]
select * from pdf where partno='2108-2-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.017493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419132 LIMIT 4 [ RunTime:0.012249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419132 ORDER BY `minOrder` ASC [ RunTime:0.019904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419132 ORDER BY `unit` DESC [ RunTime:0.034433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419132 LIMIT 2 [ RunTime:0.035719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419132 ORDER BY `minOrder` ASC [ RunTime:0.026488s ]
select * from pdf where partno='2108-1-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419131 LIMIT 4 [ RunTime:0.022606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419131 ORDER BY `minOrder` ASC [ RunTime:0.005651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419131 ORDER BY `unit` DESC [ RunTime:0.010334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419131 LIMIT 2 [ RunTime:0.005607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419131 ORDER BY `minOrder` ASC [ RunTime:0.013854s ]
select * from pdf where partno='2102-3-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.014275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419130 LIMIT 4 [ RunTime:0.013005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419130 ORDER BY `minOrder` ASC [ RunTime:0.004129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419130 ORDER BY `unit` DESC [ RunTime:0.013432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419130 LIMIT 2 [ RunTime:0.029018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419130 ORDER BY `minOrder` ASC [ RunTime:0.002936s ]
select * from pdf where partno='2102-2-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419125 LIMIT 4 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419125 ORDER BY `minOrder` ASC [ RunTime:0.019290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419125 ORDER BY `unit` DESC [ RunTime:0.019713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419125 LIMIT 2 [ RunTime:0.007790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419125 ORDER BY `minOrder` ASC [ RunTime:0.005052s ]
select * from pdf where partno='2109-1-00-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.005071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419124 LIMIT 4 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419124 ORDER BY `minOrder` ASC [ RunTime:0.004915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419124 ORDER BY `unit` DESC [ RunTime:0.003946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419124 LIMIT 2 [ RunTime:0.003790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419124 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
select * from pdf where partno='2102-4-00-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419123 LIMIT 4 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419123 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419123 ORDER BY `unit` DESC [ RunTime:0.003773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419123 LIMIT 2 [ RunTime:0.038289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419123 ORDER BY `minOrder` ASC [ RunTime:0.006346s ]
select * from pdf where partno='2102-3-00-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.009939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419122 LIMIT 4 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419122 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419122 ORDER BY `unit` DESC [ RunTime:0.017313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419122 LIMIT 2 [ RunTime:0.008620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419122 ORDER BY `minOrder` ASC [ RunTime:0.006458s ]
select * from pdf where partno='2102-2-00-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.020610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419121 LIMIT 4 [ RunTime:0.013898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419121 ORDER BY `minOrder` ASC [ RunTime:0.017677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419121 ORDER BY `unit` DESC [ RunTime:0.004572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419121 LIMIT 2 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419121 ORDER BY `minOrder` ASC [ RunTime:0.002697s ]
select * from pdf where partno='2102-1-00-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412601 LIMIT 4 [ RunTime:0.006802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412601 ORDER BY `minOrder` ASC [ RunTime:0.017425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412601 ORDER BY `unit` DESC [ RunTime:0.013912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412601 LIMIT 2 [ RunTime:0.039484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412601 ORDER BY `minOrder` ASC [ RunTime:0.006986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406857 LIMIT 4 [ RunTime:0.020391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406857 ORDER BY `minOrder` ASC [ RunTime:0.062387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406857 ORDER BY `unit` DESC [ RunTime:0.013584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406857 LIMIT 2 [ RunTime:0.033390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406857 ORDER BY `minOrder` ASC [ RunTime:0.017401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406814 LIMIT 4 [ RunTime:0.022384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406814 ORDER BY `minOrder` ASC [ RunTime:0.003404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406814 ORDER BY `unit` DESC [ RunTime:0.020533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406814 LIMIT 2 [ RunTime:0.047384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406814 ORDER BY `minOrder` ASC [ RunTime:0.016189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406811 LIMIT 4 [ RunTime:0.013500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406811 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406811 ORDER BY `unit` DESC [ RunTime:0.003879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406811 LIMIT 2 [ RunTime:0.021743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406811 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406800 LIMIT 4 [ RunTime:0.010454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406800 ORDER BY `minOrder` ASC [ RunTime:0.037673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406800 ORDER BY `unit` DESC [ RunTime:0.066390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406800 LIMIT 2 [ RunTime:0.050426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406800 ORDER BY `minOrder` ASC [ RunTime:0.008187s ]
select * from pdf where partno='2101650-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.068672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406797 LIMIT 4 [ RunTime:0.034762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406797 ORDER BY `minOrder` ASC [ RunTime:0.068587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406797 ORDER BY `unit` DESC [ RunTime:0.012213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406797 LIMIT 2 [ RunTime:0.037727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406797 ORDER BY `minOrder` ASC [ RunTime:0.047007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405899 LIMIT 4 [ RunTime:0.046559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405899 ORDER BY `minOrder` ASC [ RunTime:0.130854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405899 ORDER BY `unit` DESC [ RunTime:0.033941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405899 LIMIT 2 [ RunTime:0.083857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405899 ORDER BY `minOrder` ASC [ RunTime:0.023430s ]
select * from pdf where partno='2102318-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405893 LIMIT 4 [ RunTime:0.082344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405893 ORDER BY `minOrder` ASC [ RunTime:0.061537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405893 ORDER BY `unit` DESC [ RunTime:0.064271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405893 LIMIT 2 [ RunTime:0.030815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405893 ORDER BY `minOrder` ASC [ RunTime:0.005050s ]
select * from pdf where partno='2102157-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.035368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405890 LIMIT 4 [ RunTime:0.053600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405890 ORDER BY `minOrder` ASC [ RunTime:0.050652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405890 ORDER BY `unit` DESC [ RunTime:0.017025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405890 LIMIT 2 [ RunTime:0.009819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405890 ORDER BY `minOrder` ASC [ RunTime:0.003544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11405889 LIMIT 4 [ RunTime:0.024643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405889 ORDER BY `minOrder` ASC [ RunTime:0.084906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11405889 ORDER BY `unit` DESC [ RunTime:0.040318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11405889 LIMIT 2 [ RunTime:0.021387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11405889 ORDER BY `minOrder` ASC [ RunTime:0.022893s ]
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.007431s ]