SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001153s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003191s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001189s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.001282s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001257s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000953s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ15CA' LIMIT 1 [ RunTime:0.013031s ]
UPDATE `stock_search` SET `count` = 10737 , `updatetime` = '2026-04-25 22:10:32' WHERE `partno` = 'SMBJ15CA' [ RunTime:0.007207s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001983s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000194s ]
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.000450s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001312s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ15CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.011695s ]
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 'SMBJ15CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.008153s ]
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 ('16669249','16665792','14833549','14832869','14832125','14818929','14814872','14814788','14813474','14813464','14812939','14812058','13932790','13930191','13928252','13924749','13921728','13917120','13916175','13915682') ORDER BY FIELD(s.id, 16669249,16665792,14833549,14832869,14832125,14818929,14814872,14814788,14813474,14813464,14812939,14812058,13932790,13930191,13928252,13924749,13921728,13917120,13916175,13915682) [ RunTime:0.005042s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669249 LIMIT 4 [ RunTime:0.016283s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669249 ORDER BY `minOrder` ASC [ RunTime:0.020503s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669249 ORDER BY `unit` DESC [ RunTime:0.000809s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669249 LIMIT 2 [ RunTime:0.011367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669249 ORDER BY `minOrder` ASC [ RunTime:0.007059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665792 LIMIT 4 [ RunTime:0.001067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665792 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665792 ORDER BY `unit` DESC [ RunTime:0.003348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665792 LIMIT 2 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665792 ORDER BY `minOrder` ASC [ RunTime:0.007532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833549 LIMIT 4 [ RunTime:0.016632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833549 ORDER BY `minOrder` ASC [ RunTime:0.005802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833549 ORDER BY `unit` DESC [ RunTime:0.006513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833549 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833549 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832869 LIMIT 4 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832869 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832869 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832869 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832869 ORDER BY `minOrder` ASC [ RunTime:0.000190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832125 LIMIT 4 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832125 ORDER BY `minOrder` ASC [ RunTime:0.008230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832125 ORDER BY `unit` DESC [ RunTime:0.007895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832125 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832125 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818929 LIMIT 4 [ RunTime:0.004389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818929 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818929 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818929 LIMIT 2 [ RunTime:0.007885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818929 ORDER BY `minOrder` ASC [ RunTime:0.005445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814872 LIMIT 4 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814872 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814872 ORDER BY `unit` DESC [ RunTime:0.003144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814872 LIMIT 2 [ RunTime:0.010058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814872 ORDER BY `minOrder` ASC [ RunTime:0.004838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814788 LIMIT 4 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814788 ORDER BY `minOrder` ASC [ RunTime:0.002410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814788 ORDER BY `unit` DESC [ RunTime:0.006212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814788 LIMIT 2 [ RunTime:0.001005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814788 ORDER BY `minOrder` ASC [ RunTime:0.000196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813474 LIMIT 4 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813474 ORDER BY `minOrder` ASC [ RunTime:0.001202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813474 ORDER BY `unit` DESC [ RunTime:0.001446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813474 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813474 ORDER BY `minOrder` ASC [ RunTime:0.000191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813464 LIMIT 4 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813464 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813464 ORDER BY `unit` DESC [ RunTime:0.002399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813464 LIMIT 2 [ RunTime:0.006190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813464 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812939 LIMIT 4 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812939 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812939 ORDER BY `unit` DESC [ RunTime:0.000335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812939 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812939 ORDER BY `minOrder` ASC [ RunTime:0.000189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812058 LIMIT 4 [ RunTime:0.002658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812058 ORDER BY `minOrder` ASC [ RunTime:0.001976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812058 ORDER BY `unit` DESC [ RunTime:0.005103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812058 LIMIT 2 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812058 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932790 LIMIT 4 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932790 ORDER BY `minOrder` ASC [ RunTime:0.005846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932790 ORDER BY `unit` DESC [ RunTime:0.001451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932790 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932790 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930191 LIMIT 4 [ RunTime:0.001106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930191 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930191 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930191 LIMIT 2 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930191 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928252 LIMIT 4 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928252 ORDER BY `minOrder` ASC [ RunTime:0.004613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928252 ORDER BY `unit` DESC [ RunTime:0.004311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928252 LIMIT 2 [ RunTime:0.014982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928252 ORDER BY `minOrder` ASC [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924749 LIMIT 4 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924749 ORDER BY `minOrder` ASC [ RunTime:0.013501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924749 ORDER BY `unit` DESC [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924749 LIMIT 2 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924749 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921728 LIMIT 4 [ RunTime:0.002884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921728 ORDER BY `minOrder` ASC [ RunTime:0.002060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921728 ORDER BY `unit` DESC [ RunTime:0.000920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921728 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921728 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917120 LIMIT 4 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917120 ORDER BY `minOrder` ASC [ RunTime:0.008297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917120 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917120 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917120 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916175 LIMIT 4 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916175 ORDER BY `minOrder` ASC [ RunTime:0.015442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916175 ORDER BY `unit` DESC [ RunTime:0.006912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916175 LIMIT 2 [ RunTime:0.002819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916175 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915682 LIMIT 4 [ RunTime:0.011016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915682 ORDER BY `minOrder` ASC [ RunTime:0.015463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915682 ORDER BY `unit` DESC [ RunTime:0.016435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915682 LIMIT 2 [ RunTime:0.011649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915682 ORDER BY `minOrder` ASC [ RunTime:0.015305s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ15CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002254s ]