SELECT * FROM ecs_nav WHERE `type` = 'top' and ifshow = '1' ORDER BY type, vieworder [ RunTime:0.000531s ]
SELECT * FROM ecs_article_cat WHERE show_in_nav =1 ORDER BY sort_order ASC [ RunTime:0.000380s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=118 [ RunTime:0.000341s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=119 [ RunTime:0.000255s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=148 [ RunTime:0.000240s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=27 [ RunTime:0.000275s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=28 [ RunTime:0.000232s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=226 [ RunTime:0.000406s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=232 [ RunTime:0.000261s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=185 [ RunTime:0.000230s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=177 [ RunTime:0.000324s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=178 [ RunTime:0.000368s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=179 [ RunTime:0.000286s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=186 [ RunTime:0.000244s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=187 [ RunTime:0.000220s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=188 [ RunTime:0.000304s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=206 [ RunTime:0.000288s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=207 [ RunTime:0.000242s ]
select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=211 [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `ecs_article` [ RunTime:0.000764s ]
SELECT `content` FROM `ecs_article` WHERE `article_id` = 289 LIMIT 1 [ RunTime:0.000347s ]
SELECT SUM(goods_number) AS number, SUM(goods_price * goods_number) AS amount FROM ecs_cart WHERE user_id = '0' AND rec_type = '0' [ RunTime:0.000361s ]
SELECT a.*, IFNULL(AVG(r.comment_rank), 0) AS comment_rank
FROM ecs_article AS a
LEFT JOIN ecs_comment AS r ON r.id_value = a.article_id AND comment_type = 1
WHERE a.is_open = 1 AND a.article_id = '317'
GROUP BY a.article_id [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `ecs_article_cat` [ RunTime:0.000642s ]
SELECT `parent_id` FROM `ecs_article_cat` WHERE `cat_id` = 317 LIMIT 1 [ RunTime:0.000432s ]
SELECT COUNT(*) AS think_count FROM `ecs_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000296s ]
select a.cat_id, a.cat_name, b.cat_id as child_id, b.cat_name as child_name, b.sort_order as child_order from ecs_article_cat as a left join ecs_article_cat as b on b.parent_id = a.cat_id where a.parent_id = '0' AND a.cat_type = 1 ORDER BY a.sort_order ASC, a.cat_id ASC, child_order ASC [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `ecs_category` [ RunTime:0.000752s ]
SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 0 AND `is_show` = 1 [ RunTime:0.000299s ]
SELECT cat_id,cat_name ,parent_id,is_show FROM ecs_category WHERE parent_id = '0' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 50 AND `is_show` = 1 [ RunTime:0.000338s ]
SELECT cat_id, cat_name, parent_id, is_show FROM ecs_category WHERE parent_id = '50' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000274s ]
SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 52 AND `is_show` = 1 [ RunTime:0.000341s ]
SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 47 AND `is_show` = 1 [ RunTime:0.000252s ]
SELECT cat_id, cat_name, parent_id, is_show FROM ecs_category WHERE parent_id = '47' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000238s ]
SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 48 AND `is_show` = 1 [ RunTime:0.000250s ]
SELECT c.cat_id, c.cat_name, c.sort_order, a.article_id, a.title, a.file_url, a.open_type FROM ecs_article AS a LEFT JOIN ecs_article_cat AS c ON a.cat_id = c.cat_id WHERE c.cat_type = 5 AND a.is_open = 1 ORDER BY c.sort_order ASC, a.article_id [ RunTime:0.000239s ]
SELECT c.cat_id, c.cat_name, c.measure_unit, c.parent_id, c.is_show, c.show_in_nav, c.grade, c.sort_order, COUNT(s.cat_id) AS has_children
FROM ecs_category AS c
LEFT JOIN ecs_category AS s ON s.parent_id = c.cat_id
GROUP BY c.cat_id
ORDER BY c.parent_id, c.sort_order ASC [ RunTime:0.000374s ]
SELECT cat_id, COUNT(*) AS goods_num FROM ecs_goods WHERE is_delete = 0 AND is_on_sale = 1 GROUP BY cat_id [ RunTime:0.000313s ]
SELECT gc.cat_id, COUNT(*) AS goods_num FROM ecs_goods_cat AS gc ,ecs_goods AS g
WHERE g.goods_id = gc.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 GROUP BY gc.cat_id [ RunTime:0.000360s ]
SELECT goods_id FROM ecs_goods_cat AS g WHERE g.cat_id IN ('50','52','39','46','40','41','42','43','44','45','47','48','35','38','31','32','33','34','30','51','54','57','58','59','60','55','56','61','62','63','36','37','49','20','17','18','19','16','25','27','53','64','65','69','70','67','68','73','66','71','72','74') [ RunTime:0.000344s ]
SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM ecs_goods AS g,ecs_order_info AS o,ecs_order_goods AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('50','52','39','46','40','41','42','43','44','45','47','48','35','38','31','32','33','34','30','51','54','57','58','59','60','55','56','61','62','63','36','37','49','20','17','18','19','16','25','27','53','64','65','69','70','67','68','73','66','71','72','74') OR g.goods_id IN ('53') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 10 [ RunTime:0.000623s ]
SELECT g.goods_id, g.is_best, g.is_new, g.is_hot, g.is_promote, b.brand_name,g.sort_order FROM ecs_goods AS g LEFT JOIN ecs_brand AS b ON b.brand_id = g.brand_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.is_best = 1 OR g.is_new =1 OR g.is_hot = 1) ORDER BY g.sort_order, g.last_update DESC [ RunTime:0.000480s ]
SELECT library, number FROM ecs_template WHERE theme = 'default' AND filename = 'index' AND remarks='' [ RunTime:0.000322s ]
SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, g.show_img, RAND() AS rnd FROM ecs_goods AS g LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.goods_id IN ('185','151','181') ORDER BY g.sort_order, g.last_update DESC [ RunTime:0.000588s ]
SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name, g.is_best, g.is_new, g.is_hot, g.is_promote, RAND() AS rnd FROM ecs_goods AS g LEFT JOIN ecs_brand AS b ON b.brand_id = g.brand_id LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.is_promote = 1 AND promote_start_date <= '1670065608' AND promote_end_date >= '1670065608' ORDER BY g.sort_order, g.last_update DESC LIMIT 4 [ RunTime:0.000510s ]
SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img,IFNULL(mp.user_price, g.shop_price * '1') AS shop_price,
g.shop_price AS org_price, g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date
FROM ecs_goods_article ga
LEFT JOIN ecs_goods AS g ON g.goods_id = ga.goods_id
LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0'
WHERE ga.article_id = '317' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 [ RunTime:0.000501s ]
SELECT act_id, act_name, act_type, start_time, end_time FROM ecs_goods_activity WHERE is_finished = 0 AND start_time <= '1670065608' AND end_time >= '1670065608' [ RunTime:0.000397s ]
SELECT act_id, act_range, act_range_ext, act_name, start_time, end_time FROM ecs_favourable_activity WHERE start_time <= '1670065608' AND end_time >= '1670065608' [ RunTime:0.000498s ]
select cat_id,parent_id,show_in_nav,is_nav,url from ecs_article_cat where cat_id = 209 [ RunTime:0.000400s ]
select cat_id,parent_id,show_in_nav,is_nav,url from ecs_article_cat where cat_id = 208 [ RunTime:0.000288s ]
select add_time from ecs_article where article_id = '317' [ RunTime:0.000451s ]
select article_id,title from ecs_article where add_time > '1599552000' AND is_open = 1 AND cat_id=209 order by add_time asc LIMIT 1 [ RunTime:0.000426s ]
select article_id,title from ecs_article where add_time < '1599552000' AND is_open = 1 AND cat_id=209 order by add_time desc LIMIT 1 [ RunTime:0.000388s ]
SELECT id, number, type FROM ecs_template WHERE filename = 'article' AND type > 0 AND remarks ='' AND theme='default' [ RunTime:0.000319s ]
SELECT * FROM ecs_ad where position_id=31 and enabled = 1 and start_time <= '1670065608' AND end_time >= '1670065608' ORDER BY ad_id desc [ RunTime:0.000486s ]
select * from ecs_article_cat where tag = 1 and parent_id = 208 order by sort_order limit 6 [ RunTime:0.000568s ]
