2026-04-13 16:43:00 [http-nio-8095-exec-7] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1193 millis. SELECT count(0) FROM biz_tag_info obj RIGHT OUTER JOIN (SELECT o.model_id AS modelId, COUNT(o.model_id) AS repeatCount FROM biz_relateship_info o WHERE o.content_id IN (SELECT r.content_id FROM biz_relateship_info r WHERE r.tag_info_id = ? AND r.exegesis_id = o.exegesis_id AND r.del_flag = '0') AND o.type IN ('CEM') AND o.del_flag = '0' GROUP BY o.model_id) t ON t.modelId = obj.id LEFT JOIN (SELECT COUNT(DISTINCT bri.id) AS relate_count, bri.model_id FROM biz_relateship_info bri JOIN (SELECT DISTINCT content_id, model_id FROM biz_relateship_info WHERE TYPE = 'EMA' AND author_id = ?) a ON a.content_id = bri.content_id AND a.model_id = bri.model_id WHERE bri.type = 'LCM' GROUP BY bri.model_id) c ON obj.id = c.model_id LEFT JOIN (SELECT model_id, id AS relateId, weight AS modelWeight FROM biz_relateship_info WHERE TYPE = 'MA' AND author_id = ? AND del_flag = '0') d ON obj.id = d.model_id WHERE obj.tag_type = '2'[1744628074877579265,1744628074877579265,1744628074877579265]
2026-04-13 16:43:02 [http-nio-8095-exec-7] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1221 millis. SELECT obj.*,t.repeatCount,c.relate_count,d.modelWeight,d.relateId FROM biz_tag_info obj
        RIGHT OUTER JOIN (
                    SELECT o.model_id AS modelId,COUNT(o.model_id) AS repeatCount FROM  biz_relateship_info o
                     WHERE o.content_id IN
                     (
                         SELECT  r.content_id FROM biz_relateship_info r WHERE r.tag_info_id=?  AND r.exegesis_id=o.exegesis_id AND r.del_flag='0'
                     )
                    AND o.type IN ('CEM') AND o.del_flag='0'
                    GROUP BY o.model_id
            ) t ON t.modelId=obj.id
        LEFT JOIN (
        select  COUNT(DISTINCT bri.id) AS relate_count,bri.model_id
        FROM
        biz_relateship_info bri
        JOIN (SELECT DISTINCT content_id,model_id FROM biz_relateship_info WHERE TYPE='EMA' AND author_id=?  ) a ON a.content_id=bri.content_id  AND a.model_id=bri.model_id
        WHERE
        bri.type = 'LCM'
        GROUP BY bri.model_id
        ) c ON obj.id = c.model_id

        LEFT JOIN ( SELECT model_id,id as relateId,weight as modelWeight
        FROM  biz_relateship_info WHERE
        TYPE = 'MA'
        AND author_id = ?
        AND del_flag = '0')d on obj.id = d.model_id
        WHERE
            obj.tag_type='2'
             
             
        ORDER BY d.modelWeight DESC,c.relate_count DESC
 LIMIT ? [1744628074877579265,1744628074877579265,1744628074877579265,999]
2026-04-13 16:43:09 [http-nio-8095-exec-10] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1184 millis. SELECT count(0) FROM biz_tag_info obj RIGHT OUTER JOIN (SELECT o.model_id AS modelId, COUNT(o.model_id) AS repeatCount FROM biz_relateship_info o WHERE o.content_id IN (SELECT r.content_id FROM biz_relateship_info r WHERE r.tag_info_id = ? AND r.exegesis_id = o.exegesis_id AND r.del_flag = '0') AND o.type IN ('CEM') AND o.del_flag = '0' GROUP BY o.model_id) t ON t.modelId = obj.id LEFT JOIN (SELECT COUNT(DISTINCT bri.id) AS relate_count, bri.model_id FROM biz_relateship_info bri JOIN (SELECT DISTINCT content_id, model_id FROM biz_relateship_info WHERE TYPE = 'EMA' AND author_id = ?) a ON a.content_id = bri.content_id AND a.model_id = bri.model_id WHERE bri.type = 'LCM' GROUP BY bri.model_id) c ON obj.id = c.model_id LEFT JOIN (SELECT model_id, id AS relateId, weight AS modelWeight FROM biz_relateship_info WHERE TYPE = 'MA' AND author_id = ? AND del_flag = '0') d ON obj.id = d.model_id WHERE obj.tag_type = '2'[1744628074877579265,1744628074877579265,1744628074877579265]
2026-04-13 16:43:10 [http-nio-8095-exec-10] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1253 millis. SELECT obj.*,t.repeatCount,c.relate_count,d.modelWeight,d.relateId FROM biz_tag_info obj
        RIGHT OUTER JOIN (
                    SELECT o.model_id AS modelId,COUNT(o.model_id) AS repeatCount FROM  biz_relateship_info o
                     WHERE o.content_id IN
                     (
                         SELECT  r.content_id FROM biz_relateship_info r WHERE r.tag_info_id=?  AND r.exegesis_id=o.exegesis_id AND r.del_flag='0'
                     )
                    AND o.type IN ('CEM') AND o.del_flag='0'
                    GROUP BY o.model_id
            ) t ON t.modelId=obj.id
        LEFT JOIN (
        select  COUNT(DISTINCT bri.id) AS relate_count,bri.model_id
        FROM
        biz_relateship_info bri
        JOIN (SELECT DISTINCT content_id,model_id FROM biz_relateship_info WHERE TYPE='EMA' AND author_id=?  ) a ON a.content_id=bri.content_id  AND a.model_id=bri.model_id
        WHERE
        bri.type = 'LCM'
        GROUP BY bri.model_id
        ) c ON obj.id = c.model_id

        LEFT JOIN ( SELECT model_id,id as relateId,weight as modelWeight
        FROM  biz_relateship_info WHERE
        TYPE = 'MA'
        AND author_id = ?
        AND del_flag = '0')d on obj.id = d.model_id
        WHERE
            obj.tag_type='2'
             
             
        ORDER BY d.modelWeight DESC,c.relate_count DESC
 LIMIT ? [1744628074877579265,1744628074877579265,1744628074877579265,999]
2026-04-13 16:43:18 [http-nio-8095-exec-9] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1219 millis. SELECT count(0) FROM biz_tag_info obj RIGHT OUTER JOIN (SELECT o.model_id AS modelId, COUNT(o.model_id) AS repeatCount FROM biz_relateship_info o WHERE o.content_id IN (SELECT r.content_id FROM biz_relateship_info r WHERE r.tag_info_id = ? AND r.exegesis_id = o.exegesis_id AND r.del_flag = '0') AND o.type IN ('CEM') AND o.del_flag = '0' GROUP BY o.model_id) t ON t.modelId = obj.id LEFT JOIN (SELECT COUNT(DISTINCT bri.id) AS relate_count, bri.model_id FROM biz_relateship_info bri JOIN (SELECT DISTINCT content_id, model_id FROM biz_relateship_info WHERE TYPE = 'EMA' AND author_id = ?) a ON a.content_id = bri.content_id AND a.model_id = bri.model_id WHERE bri.type = 'LCM' GROUP BY bri.model_id) c ON obj.id = c.model_id LEFT JOIN (SELECT model_id, id AS relateId, weight AS modelWeight FROM biz_relateship_info WHERE TYPE = 'MA' AND author_id = ? AND del_flag = '0') d ON obj.id = d.model_id WHERE obj.tag_type = '2'[1744628074877579265,1744628074877579265,1744628074877579265]
2026-04-13 16:43:19 [http-nio-8095-exec-9] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1158 millis. SELECT obj.*,t.repeatCount,c.relate_count,d.modelWeight,d.relateId FROM biz_tag_info obj
        RIGHT OUTER JOIN (
                    SELECT o.model_id AS modelId,COUNT(o.model_id) AS repeatCount FROM  biz_relateship_info o
                     WHERE o.content_id IN
                     (
                         SELECT  r.content_id FROM biz_relateship_info r WHERE r.tag_info_id=?  AND r.exegesis_id=o.exegesis_id AND r.del_flag='0'
                     )
                    AND o.type IN ('CEM') AND o.del_flag='0'
                    GROUP BY o.model_id
            ) t ON t.modelId=obj.id
        LEFT JOIN (
        select  COUNT(DISTINCT bri.id) AS relate_count,bri.model_id
        FROM
        biz_relateship_info bri
        JOIN (SELECT DISTINCT content_id,model_id FROM biz_relateship_info WHERE TYPE='EMA' AND author_id=?  ) a ON a.content_id=bri.content_id  AND a.model_id=bri.model_id
        WHERE
        bri.type = 'LCM'
        GROUP BY bri.model_id
        ) c ON obj.id = c.model_id

        LEFT JOIN ( SELECT model_id,id as relateId,weight as modelWeight
        FROM  biz_relateship_info WHERE
        TYPE = 'MA'
        AND author_id = ?
        AND del_flag = '0')d on obj.id = d.model_id
        WHERE
            obj.tag_type='2'
             
             
        ORDER BY d.modelWeight DESC,c.relate_count DESC
 LIMIT ? [1744628074877579265,1744628074877579265,1744628074877579265,999]
2026-04-13 16:43:22 [http-nio-8095-exec-8] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1289 millis. SELECT count(0) FROM biz_tag_info obj RIGHT OUTER JOIN (SELECT o.model_id AS modelId, COUNT(o.model_id) AS repeatCount FROM biz_relateship_info o WHERE o.content_id IN (SELECT r.content_id FROM biz_relateship_info r WHERE r.tag_info_id = ? AND r.exegesis_id = o.exegesis_id AND r.del_flag = '0') AND o.type IN ('CEM') AND o.del_flag = '0' GROUP BY o.model_id) t ON t.modelId = obj.id LEFT JOIN (SELECT COUNT(DISTINCT bri.id) AS relate_count, bri.model_id FROM biz_relateship_info bri JOIN (SELECT DISTINCT content_id, model_id FROM biz_relateship_info WHERE TYPE = 'EMA' AND author_id = ?) a ON a.content_id = bri.content_id AND a.model_id = bri.model_id WHERE bri.type = 'LCM' GROUP BY bri.model_id) c ON obj.id = c.model_id LEFT JOIN (SELECT model_id, id AS relateId, weight AS modelWeight FROM biz_relateship_info WHERE TYPE = 'MA' AND author_id = ? AND del_flag = '0') d ON obj.id = d.model_id WHERE obj.tag_type = '2'[1744628074877579265,1744628074877579265,1744628074877579265]
2026-04-13 16:43:22 [http-nio-8095-exec-4] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1357 millis. SELECT count(0) FROM biz_tag_info obj RIGHT OUTER JOIN (SELECT o.model_id AS modelId, COUNT(o.model_id) AS repeatCount FROM biz_relateship_info o WHERE o.content_id IN (SELECT r.content_id FROM biz_relateship_info r WHERE r.tag_info_id = ? AND r.exegesis_id = o.exegesis_id AND r.del_flag = '0') AND o.type IN ('CEM') AND o.del_flag = '0' GROUP BY o.model_id) t ON t.modelId = obj.id LEFT JOIN (SELECT COUNT(DISTINCT bri.id) AS relate_count, bri.model_id FROM biz_relateship_info bri JOIN (SELECT DISTINCT content_id, model_id FROM biz_relateship_info WHERE TYPE = 'EMA' AND author_id = ?) a ON a.content_id = bri.content_id AND a.model_id = bri.model_id WHERE bri.type = 'LCM' GROUP BY bri.model_id) c ON obj.id = c.model_id LEFT JOIN (SELECT model_id, id AS relateId, weight AS modelWeight FROM biz_relateship_info WHERE TYPE = 'MA' AND author_id = ? AND del_flag = '0') d ON obj.id = d.model_id WHERE obj.tag_type = '2'[1744628074877579265,1744628074877579265,1744628074877579265]
2026-04-13 16:43:23 [http-nio-8095-exec-8] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1304 millis. SELECT obj.*,t.repeatCount,c.relate_count,d.modelWeight,d.relateId FROM biz_tag_info obj
        RIGHT OUTER JOIN (
                    SELECT o.model_id AS modelId,COUNT(o.model_id) AS repeatCount FROM  biz_relateship_info o
                     WHERE o.content_id IN
                     (
                         SELECT  r.content_id FROM biz_relateship_info r WHERE r.tag_info_id=?  AND r.exegesis_id=o.exegesis_id AND r.del_flag='0'
                     )
                    AND o.type IN ('CEM') AND o.del_flag='0'
                    GROUP BY o.model_id
            ) t ON t.modelId=obj.id
        LEFT JOIN (
        select  COUNT(DISTINCT bri.id) AS relate_count,bri.model_id
        FROM
        biz_relateship_info bri
        JOIN (SELECT DISTINCT content_id,model_id FROM biz_relateship_info WHERE TYPE='EMA' AND author_id=?  ) a ON a.content_id=bri.content_id  AND a.model_id=bri.model_id
        WHERE
        bri.type = 'LCM'
        GROUP BY bri.model_id
        ) c ON obj.id = c.model_id

        LEFT JOIN ( SELECT model_id,id as relateId,weight as modelWeight
        FROM  biz_relateship_info WHERE
        TYPE = 'MA'
        AND author_id = ?
        AND del_flag = '0')d on obj.id = d.model_id
        WHERE
            obj.tag_type='2'
             
             
        ORDER BY d.modelWeight DESC,c.relate_count DESC
 LIMIT ? [1744628074877579265,1744628074877579265,1744628074877579265,999]
2026-04-13 16:43:24 [http-nio-8095-exec-4] ERROR c.a.druid.filter.stat.StatFilter - slow sql 1214 millis. SELECT obj.*,t.repeatCount,c.relate_count,d.modelWeight,d.relateId FROM biz_tag_info obj
        RIGHT OUTER JOIN (
                    SELECT o.model_id AS modelId,COUNT(o.model_id) AS repeatCount FROM  biz_relateship_info o
                     WHERE o.content_id IN
                     (
                         SELECT  r.content_id FROM biz_relateship_info r WHERE r.tag_info_id=?  AND r.exegesis_id=o.exegesis_id AND r.del_flag='0'
                     )
                    AND o.type IN ('CEM') AND o.del_flag='0'
                    GROUP BY o.model_id
            ) t ON t.modelId=obj.id
        LEFT JOIN (
        select  COUNT(DISTINCT bri.id) AS relate_count,bri.model_id
        FROM
        biz_relateship_info bri
        JOIN (SELECT DISTINCT content_id,model_id FROM biz_relateship_info WHERE TYPE='EMA' AND author_id=?  ) a ON a.content_id=bri.content_id  AND a.model_id=bri.model_id
        WHERE
        bri.type = 'LCM'
        GROUP BY bri.model_id
        ) c ON obj.id = c.model_id

        LEFT JOIN ( SELECT model_id,id as relateId,weight as modelWeight
        FROM  biz_relateship_info WHERE
        TYPE = 'MA'
        AND author_id = ?
        AND del_flag = '0')d on obj.id = d.model_id
        WHERE
            obj.tag_type='2'
             
             
        ORDER BY d.modelWeight DESC,c.relate_count DESC
 LIMIT ? [1744628074877579265,1744628074877579265,1744628074877579265,999]