SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002837s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.020640s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002231s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.034409s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001898s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.050957s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001956s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ8.0A' LIMIT 1 [ RunTime:0.120433s ]
UPDATE `stock_search` SET `count` = 12065 , `updatetime` = '2026-04-26 10:31:21' WHERE `partno` = 'SMCJ8.0A' [ RunTime:0.006563s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005634s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000602s ]
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.004565s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003595s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMCJ8.0A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.047857s ]
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 'SMCJ8.0A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.011692s ]
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 ('14833022','14831931','14829914','14815672','14812095','14810031','13929924','13925082','13924917','13924916','13917506','13917494','13917202','13916739','13916314','13913277') ORDER BY FIELD(s.id, 14833022,14831931,14829914,14815672,14812095,14810031,13929924,13925082,13924917,13924916,13917506,13917494,13917202,13916739,13916314,13913277) [ RunTime:0.017854s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833022 LIMIT 4 [ RunTime:0.010687s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833022 ORDER BY `minOrder` ASC [ RunTime:0.006355s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833022 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833022 LIMIT 2 [ RunTime:0.003805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833022 ORDER BY `minOrder` ASC [ RunTime:0.004457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831931 LIMIT 4 [ RunTime:0.021734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831931 ORDER BY `minOrder` ASC [ RunTime:0.068162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831931 ORDER BY `unit` DESC [ RunTime:0.103960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831931 LIMIT 2 [ RunTime:0.050908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831931 ORDER BY `minOrder` ASC [ RunTime:0.050812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829914 LIMIT 4 [ RunTime:0.055995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829914 ORDER BY `minOrder` ASC [ RunTime:0.020519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829914 ORDER BY `unit` DESC [ RunTime:0.022070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829914 LIMIT 2 [ RunTime:0.032979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829914 ORDER BY `minOrder` ASC [ RunTime:0.005231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815672 LIMIT 4 [ RunTime:0.011527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815672 ORDER BY `minOrder` ASC [ RunTime:0.006914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815672 ORDER BY `unit` DESC [ RunTime:0.024307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815672 LIMIT 2 [ RunTime:0.003546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815672 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812095 LIMIT 4 [ RunTime:0.018506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812095 ORDER BY `minOrder` ASC [ RunTime:0.010069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812095 ORDER BY `unit` DESC [ RunTime:0.028753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812095 LIMIT 2 [ RunTime:0.004334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812095 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810031 LIMIT 4 [ RunTime:0.007969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810031 ORDER BY `minOrder` ASC [ RunTime:0.004421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810031 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810031 LIMIT 2 [ RunTime:0.004216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810031 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929924 LIMIT 4 [ RunTime:0.003113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929924 ORDER BY `minOrder` ASC [ RunTime:0.009544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929924 ORDER BY `unit` DESC [ RunTime:0.025271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929924 LIMIT 2 [ RunTime:0.727966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929924 ORDER BY `minOrder` ASC [ RunTime:0.004969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925082 LIMIT 4 [ RunTime:0.020718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925082 ORDER BY `minOrder` ASC [ RunTime:0.058460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925082 ORDER BY `unit` DESC [ RunTime:0.023997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925082 LIMIT 2 [ RunTime:0.024904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925082 ORDER BY `minOrder` ASC [ RunTime:0.064414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924917 LIMIT 4 [ RunTime:0.017562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924917 ORDER BY `minOrder` ASC [ RunTime:0.017980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924917 ORDER BY `unit` DESC [ RunTime:0.042458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924917 LIMIT 2 [ RunTime:0.506861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924917 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924916 LIMIT 4 [ RunTime:0.093208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924916 ORDER BY `minOrder` ASC [ RunTime:0.033442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924916 ORDER BY `unit` DESC [ RunTime:0.028413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924916 LIMIT 2 [ RunTime:0.011302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924916 ORDER BY `minOrder` ASC [ RunTime:0.006276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917506 LIMIT 4 [ RunTime:0.027173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917506 ORDER BY `minOrder` ASC [ RunTime:0.010187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917506 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917506 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917506 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917494 LIMIT 4 [ RunTime:0.003802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917494 ORDER BY `minOrder` ASC [ RunTime:0.002874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917494 ORDER BY `unit` DESC [ RunTime:0.010412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917494 LIMIT 2 [ RunTime:0.011133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917494 ORDER BY `minOrder` ASC [ RunTime:0.001644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917202 LIMIT 4 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917202 ORDER BY `minOrder` ASC [ RunTime:0.006925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917202 ORDER BY `unit` DESC [ RunTime:0.001373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917202 LIMIT 2 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917202 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916739 LIMIT 4 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916739 ORDER BY `minOrder` ASC [ RunTime:0.005926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916739 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916739 LIMIT 2 [ RunTime:0.017649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916739 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916314 LIMIT 4 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916314 ORDER BY `minOrder` ASC [ RunTime:0.005076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916314 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916314 LIMIT 2 [ RunTime:0.260196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916314 ORDER BY `minOrder` ASC [ RunTime:0.046146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913277 LIMIT 4 [ RunTime:0.014708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913277 ORDER BY `minOrder` ASC [ RunTime:0.028060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913277 ORDER BY `unit` DESC [ RunTime:0.034513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913277 LIMIT 2 [ RunTime:0.020215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913277 ORDER BY `minOrder` ASC [ RunTime:0.001905s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMCJ8.0A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007970s ]