SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002584s ]
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.006687s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002976s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003200s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002123s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010886s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001924s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004306s ]
UPDATE `stock_search` SET `count` = 1192 , `updatetime` = '2026-06-06 17:28:03' WHERE `partno` = '210' [ RunTime:0.019750s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002011s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005707s ]
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.004800s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004095s ]
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.256154s ]
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 5140,20 [ RunTime:0.079484s ]
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 ('11402957','11402956','11402955','11401459','11401128','11401122','11400840','11400770','11400636','11400610','11400276','11400231','11400230','11400121','11399844','11399649','11398873','11398451','11398262','11398000') ORDER BY FIELD(s.id, 11402957,11402956,11402955,11401459,11401128,11401122,11400840,11400770,11400636,11400610,11400276,11400231,11400230,11400121,11399844,11399649,11398873,11398451,11398262,11398000) [ RunTime:0.008761s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11402957 LIMIT 4 [ RunTime:0.031085s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402957 ORDER BY `minOrder` ASC [ RunTime:0.014907s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11402957 ORDER BY `unit` DESC [ RunTime:0.027325s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11402957 LIMIT 2 [ RunTime:0.012978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402957 ORDER BY `minOrder` ASC [ RunTime:0.043611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11402956 LIMIT 4 [ RunTime:0.017471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402956 ORDER BY `minOrder` ASC [ RunTime:0.036711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11402956 ORDER BY `unit` DESC [ RunTime:0.032327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11402956 LIMIT 2 [ RunTime:0.034329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402956 ORDER BY `minOrder` ASC [ RunTime:0.033681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11402955 LIMIT 4 [ RunTime:0.026882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402955 ORDER BY `minOrder` ASC [ RunTime:0.013021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11402955 ORDER BY `unit` DESC [ RunTime:0.035887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11402955 LIMIT 2 [ RunTime:0.003636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402955 ORDER BY `minOrder` ASC [ RunTime:0.008773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11401459 LIMIT 4 [ RunTime:0.012674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401459 ORDER BY `minOrder` ASC [ RunTime:0.017994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11401459 ORDER BY `unit` DESC [ RunTime:0.029406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11401459 LIMIT 2 [ RunTime:0.027835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401459 ORDER BY `minOrder` ASC [ RunTime:0.029862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11401128 LIMIT 4 [ RunTime:0.017624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401128 ORDER BY `minOrder` ASC [ RunTime:0.011981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11401128 ORDER BY `unit` DESC [ RunTime:0.007135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11401128 LIMIT 2 [ RunTime:0.015115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401128 ORDER BY `minOrder` ASC [ RunTime:0.027198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11401122 LIMIT 4 [ RunTime:0.060494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401122 ORDER BY `minOrder` ASC [ RunTime:0.082277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11401122 ORDER BY `unit` DESC [ RunTime:0.033704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11401122 LIMIT 2 [ RunTime:0.103213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401122 ORDER BY `minOrder` ASC [ RunTime:0.055364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400840 LIMIT 4 [ RunTime:0.066915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400840 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400840 ORDER BY `unit` DESC [ RunTime:0.002076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400840 LIMIT 2 [ RunTime:0.001861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400840 ORDER BY `minOrder` ASC [ RunTime:0.005118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400770 LIMIT 4 [ RunTime:0.009665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400770 ORDER BY `minOrder` ASC [ RunTime:0.003026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400770 ORDER BY `unit` DESC [ RunTime:0.009962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400770 LIMIT 2 [ RunTime:0.003779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400770 ORDER BY `minOrder` ASC [ RunTime:0.001579s ]
select * from pdf where partno='2102232-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400636 LIMIT 4 [ RunTime:0.019359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400636 ORDER BY `minOrder` ASC [ RunTime:0.010311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400636 ORDER BY `unit` DESC [ RunTime:0.012440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400636 LIMIT 2 [ RunTime:0.017962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400636 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400610 LIMIT 4 [ RunTime:0.010614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400610 ORDER BY `minOrder` ASC [ RunTime:0.006979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400610 ORDER BY `unit` DESC [ RunTime:0.009615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400610 LIMIT 2 [ RunTime:0.006819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400610 ORDER BY `minOrder` ASC [ RunTime:0.009554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400276 LIMIT 4 [ RunTime:0.011140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400276 ORDER BY `minOrder` ASC [ RunTime:0.013718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400276 ORDER BY `unit` DESC [ RunTime:0.012288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400276 LIMIT 2 [ RunTime:0.011817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400276 ORDER BY `minOrder` ASC [ RunTime:0.005302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400231 LIMIT 4 [ RunTime:0.011968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400231 ORDER BY `minOrder` ASC [ RunTime:0.032158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400231 ORDER BY `unit` DESC [ RunTime:0.046255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400231 LIMIT 2 [ RunTime:0.035758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400231 ORDER BY `minOrder` ASC [ RunTime:0.044520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400230 LIMIT 4 [ RunTime:0.026868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400230 ORDER BY `minOrder` ASC [ RunTime:0.016095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400230 ORDER BY `unit` DESC [ RunTime:0.015534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400230 LIMIT 2 [ RunTime:0.063114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400230 ORDER BY `minOrder` ASC [ RunTime:0.032240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400121 LIMIT 4 [ RunTime:0.067686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400121 ORDER BY `minOrder` ASC [ RunTime:0.017572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400121 ORDER BY `unit` DESC [ RunTime:0.086457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400121 LIMIT 2 [ RunTime:0.116859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400121 ORDER BY `minOrder` ASC [ RunTime:0.033097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11399844 LIMIT 4 [ RunTime:0.005998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11399844 ORDER BY `minOrder` ASC [ RunTime:0.005452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11399844 ORDER BY `unit` DESC [ RunTime:0.004020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11399844 LIMIT 2 [ RunTime:0.004173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11399844 ORDER BY `minOrder` ASC [ RunTime:0.003606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11399649 LIMIT 4 [ RunTime:0.010046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11399649 ORDER BY `minOrder` ASC [ RunTime:0.007506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11399649 ORDER BY `unit` DESC [ RunTime:0.019377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11399649 LIMIT 2 [ RunTime:0.025676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11399649 ORDER BY `minOrder` ASC [ RunTime:0.042238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11398873 LIMIT 4 [ RunTime:0.010673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398873 ORDER BY `minOrder` ASC [ RunTime:0.055263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11398873 ORDER BY `unit` DESC [ RunTime:0.028304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11398873 LIMIT 2 [ RunTime:0.023176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398873 ORDER BY `minOrder` ASC [ RunTime:0.023067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11398451 LIMIT 4 [ RunTime:0.036525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398451 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11398451 ORDER BY `unit` DESC [ RunTime:0.003543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11398451 LIMIT 2 [ RunTime:0.031123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398451 ORDER BY `minOrder` ASC [ RunTime:0.006024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11398262 LIMIT 4 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398262 ORDER BY `minOrder` ASC [ RunTime:0.022698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11398262 ORDER BY `unit` DESC [ RunTime:0.017280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11398262 LIMIT 2 [ RunTime:0.023711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398262 ORDER BY `minOrder` ASC [ RunTime:0.011292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11398000 LIMIT 4 [ RunTime:0.062535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398000 ORDER BY `minOrder` ASC [ RunTime:0.042479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11398000 ORDER BY `unit` DESC [ RunTime:0.037669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11398000 LIMIT 2 [ RunTime:0.020210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11398000 ORDER BY `minOrder` ASC [ RunTime:0.005721s ]
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.074983s ]