SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002297s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000729s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001317s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.002310s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001161s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001236s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001154s ]
SELECT * FROM `stock_search` WHERE `partno` = '388' LIMIT 1 [ RunTime:0.010516s ]
UPDATE `stock_search` SET `count` = 21 , `updatetime` = '2026-06-04 16:53:49' WHERE `partno` = '388' [ RunTime:0.015473s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001919s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005593s ]
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.003930s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003335s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.010040s ]
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 '388%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 120,20 [ RunTime:0.013209s ]
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 ('15426077','15242413','15242349','15218599','14423883','14423882','14423879','14423855','14422483','14422473','14409194','14174959','13554673','13554644','13554633','13554631','13554628','13554626','13552767','13552753') ORDER BY FIELD(s.id, 15426077,15242413,15242349,15218599,14423883,14423882,14423879,14423855,14422483,14422473,14409194,14174959,13554673,13554644,13554633,13554631,13554628,13554626,13552767,13552753) [ RunTime:0.013094s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15426077 LIMIT 4 [ RunTime:0.012890s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426077 ORDER BY `minOrder` ASC [ RunTime:0.007968s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15426077 ORDER BY `unit` DESC [ RunTime:0.005163s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15426077 LIMIT 2 [ RunTime:0.023633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15426077 ORDER BY `minOrder` ASC [ RunTime:0.007229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15242413 LIMIT 4 [ RunTime:0.013271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242413 ORDER BY `minOrder` ASC [ RunTime:0.013713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15242413 ORDER BY `unit` DESC [ RunTime:0.013275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15242413 LIMIT 2 [ RunTime:0.040501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242413 ORDER BY `minOrder` ASC [ RunTime:0.010183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15242349 LIMIT 4 [ RunTime:0.031542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242349 ORDER BY `minOrder` ASC [ RunTime:0.016934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15242349 ORDER BY `unit` DESC [ RunTime:0.012159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15242349 LIMIT 2 [ RunTime:0.024994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242349 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218599 LIMIT 4 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218599 ORDER BY `minOrder` ASC [ RunTime:0.007967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218599 ORDER BY `unit` DESC [ RunTime:0.009153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218599 LIMIT 2 [ RunTime:0.012489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218599 ORDER BY `minOrder` ASC [ RunTime:0.006592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423883 LIMIT 4 [ RunTime:0.008984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423883 ORDER BY `minOrder` ASC [ RunTime:0.008395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423883 ORDER BY `unit` DESC [ RunTime:0.007977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423883 LIMIT 2 [ RunTime:0.012771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423883 ORDER BY `minOrder` ASC [ RunTime:0.009240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423882 LIMIT 4 [ RunTime:0.010160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423882 ORDER BY `minOrder` ASC [ RunTime:0.016541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423882 ORDER BY `unit` DESC [ RunTime:0.007242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423882 LIMIT 2 [ RunTime:0.014167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423882 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423879 LIMIT 4 [ RunTime:0.007354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423879 ORDER BY `minOrder` ASC [ RunTime:0.010352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423879 ORDER BY `unit` DESC [ RunTime:0.020080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423879 LIMIT 2 [ RunTime:0.008173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423879 ORDER BY `minOrder` ASC [ RunTime:0.014918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423855 LIMIT 4 [ RunTime:0.010561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423855 ORDER BY `minOrder` ASC [ RunTime:0.017435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423855 ORDER BY `unit` DESC [ RunTime:0.011390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423855 LIMIT 2 [ RunTime:0.018863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423855 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422483 LIMIT 4 [ RunTime:0.012378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422483 ORDER BY `minOrder` ASC [ RunTime:0.010292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422483 ORDER BY `unit` DESC [ RunTime:0.015027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422483 LIMIT 2 [ RunTime:0.040259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422483 ORDER BY `minOrder` ASC [ RunTime:0.009012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422473 LIMIT 4 [ RunTime:0.015765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422473 ORDER BY `minOrder` ASC [ RunTime:0.014187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422473 ORDER BY `unit` DESC [ RunTime:0.014092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422473 LIMIT 2 [ RunTime:0.008146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422473 ORDER BY `minOrder` ASC [ RunTime:0.007388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14409194 LIMIT 4 [ RunTime:0.014868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14409194 ORDER BY `minOrder` ASC [ RunTime:0.011315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14409194 ORDER BY `unit` DESC [ RunTime:0.011215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14409194 LIMIT 2 [ RunTime:0.026445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14409194 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14174959 LIMIT 4 [ RunTime:0.009632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14174959 ORDER BY `minOrder` ASC [ RunTime:0.007710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14174959 ORDER BY `unit` DESC [ RunTime:0.011820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14174959 LIMIT 2 [ RunTime:0.004814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14174959 ORDER BY `minOrder` ASC [ RunTime:0.009279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554673 LIMIT 4 [ RunTime:0.004915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554673 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554673 ORDER BY `unit` DESC [ RunTime:0.013735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554673 LIMIT 2 [ RunTime:0.012213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554673 ORDER BY `minOrder` ASC [ RunTime:0.008203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554644 LIMIT 4 [ RunTime:0.010553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554644 ORDER BY `minOrder` ASC [ RunTime:0.009093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554644 ORDER BY `unit` DESC [ RunTime:0.009008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554644 LIMIT 2 [ RunTime:0.011779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554644 ORDER BY `minOrder` ASC [ RunTime:0.011059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554633 LIMIT 4 [ RunTime:0.010500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554633 ORDER BY `minOrder` ASC [ RunTime:0.015430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554633 ORDER BY `unit` DESC [ RunTime:0.011580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554633 LIMIT 2 [ RunTime:0.022240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554633 ORDER BY `minOrder` ASC [ RunTime:0.004886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554631 LIMIT 4 [ RunTime:0.005588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554631 ORDER BY `minOrder` ASC [ RunTime:0.007946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554631 ORDER BY `unit` DESC [ RunTime:0.005595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554631 LIMIT 2 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554631 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554628 LIMIT 4 [ RunTime:0.005720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554628 ORDER BY `minOrder` ASC [ RunTime:0.010762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554628 ORDER BY `unit` DESC [ RunTime:0.008698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554628 LIMIT 2 [ RunTime:0.011618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554628 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554626 LIMIT 4 [ RunTime:0.006476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554626 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554626 ORDER BY `unit` DESC [ RunTime:0.005591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554626 LIMIT 2 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554626 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552767 LIMIT 4 [ RunTime:0.004022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552767 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552767 ORDER BY `unit` DESC [ RunTime:0.002850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552767 LIMIT 2 [ RunTime:0.003589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552767 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552753 LIMIT 4 [ RunTime:0.003062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552753 ORDER BY `minOrder` ASC [ RunTime:0.001561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552753 ORDER BY `unit` DESC [ RunTime:0.007384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552753 LIMIT 2 [ RunTime:0.006822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552753 ORDER BY `minOrder` ASC [ RunTime:0.001145s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001208s ]