SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001539s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001103s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001809s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002072s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002410s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001424s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ13A' LIMIT 1 [ RunTime:0.002822s ]
UPDATE `stock_search` SET `count` = 9047 , `updatetime` = '2026-04-26 10:11:49' WHERE `partno` = 'SMCJ13A' [ RunTime:0.006025s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001374s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000211s ]
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.001042s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001717s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMCJ13A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000370s ]
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 'SMCJ13A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.006747s ]
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 ('16672142','16671974','14832951','14832950','14829371','14819528','14817959','14815666','14815437','14815163','14814002','14813216','14812814','14810022','14804616','13932110','13931945','13931944','13924876','13918228') ORDER BY FIELD(s.id, 16672142,16671974,14832951,14832950,14829371,14819528,14817959,14815666,14815437,14815163,14814002,14813216,14812814,14810022,14804616,13932110,13931945,13931944,13924876,13918228) [ RunTime:0.007725s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672142 LIMIT 4 [ RunTime:0.006102s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672142 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672142 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672142 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672142 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671974 LIMIT 4 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671974 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671974 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671974 LIMIT 2 [ RunTime:0.002085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671974 ORDER BY `minOrder` ASC [ RunTime:0.001339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832951 LIMIT 4 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832951 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832951 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832951 LIMIT 2 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832951 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832950 LIMIT 4 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832950 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832950 ORDER BY `unit` DESC [ RunTime:0.002158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832950 LIMIT 2 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832950 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829371 LIMIT 4 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829371 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829371 ORDER BY `unit` DESC [ RunTime:0.001034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829371 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829371 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819528 LIMIT 4 [ RunTime:0.004310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819528 ORDER BY `minOrder` ASC [ RunTime:0.003232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819528 ORDER BY `unit` DESC [ RunTime:0.001653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819528 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819528 ORDER BY `minOrder` ASC [ RunTime:0.002389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817959 LIMIT 4 [ RunTime:0.001356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817959 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817959 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817959 LIMIT 2 [ RunTime:0.007246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817959 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815666 LIMIT 4 [ RunTime:0.002470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815666 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815666 ORDER BY `unit` DESC [ RunTime:0.002689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815666 LIMIT 2 [ RunTime:0.001057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815666 ORDER BY `minOrder` ASC [ RunTime:0.020709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815437 LIMIT 4 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815437 ORDER BY `minOrder` ASC [ RunTime:0.002221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815437 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815437 LIMIT 2 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815437 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815163 LIMIT 4 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815163 ORDER BY `minOrder` ASC [ RunTime:0.001965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815163 ORDER BY `unit` DESC [ RunTime:0.002413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815163 LIMIT 2 [ RunTime:0.005378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815163 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814002 LIMIT 4 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814002 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814002 ORDER BY `unit` DESC [ RunTime:0.004783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814002 LIMIT 2 [ RunTime:0.005501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814002 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813216 LIMIT 4 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813216 ORDER BY `minOrder` ASC [ RunTime:0.002384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813216 ORDER BY `unit` DESC [ RunTime:0.005743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813216 LIMIT 2 [ RunTime:0.008100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813216 ORDER BY `minOrder` ASC [ RunTime:0.002591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812814 LIMIT 4 [ RunTime:0.002049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812814 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812814 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812814 LIMIT 2 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812814 ORDER BY `minOrder` ASC [ RunTime:0.004041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810022 LIMIT 4 [ RunTime:0.003381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810022 ORDER BY `minOrder` ASC [ RunTime:0.005235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810022 ORDER BY `unit` DESC [ RunTime:0.001366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810022 LIMIT 2 [ RunTime:0.020323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810022 ORDER BY `minOrder` ASC [ RunTime:0.003613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804616 LIMIT 4 [ RunTime:0.001385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804616 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804616 ORDER BY `unit` DESC [ RunTime:0.002955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804616 LIMIT 2 [ RunTime:0.004845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804616 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932110 LIMIT 4 [ RunTime:0.010694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932110 ORDER BY `minOrder` ASC [ RunTime:0.004506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932110 ORDER BY `unit` DESC [ RunTime:0.003114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932110 LIMIT 2 [ RunTime:0.002540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932110 ORDER BY `minOrder` ASC [ RunTime:0.004034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931945 LIMIT 4 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931945 ORDER BY `minOrder` ASC [ RunTime:0.007101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931945 ORDER BY `unit` DESC [ RunTime:0.003163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931945 LIMIT 2 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931945 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931944 LIMIT 4 [ RunTime:0.001492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931944 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931944 ORDER BY `unit` DESC [ RunTime:0.000602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931944 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931944 ORDER BY `minOrder` ASC [ RunTime:0.003985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924876 LIMIT 4 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924876 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924876 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924876 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924876 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918228 LIMIT 4 [ RunTime:0.001048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918228 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918228 ORDER BY `unit` DESC [ RunTime:0.009446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918228 LIMIT 2 [ RunTime:0.003502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918228 ORDER BY `minOrder` ASC [ RunTime:0.002794s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMCJ13A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000681s ]