ylrz_saas_his_scrm/sql/find_qw_dup.py

# -*- coding: utf-8 -*-
import pymysql

conn = pymysql.connect(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com', port=27220,
    user='root', password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas', charset='utf8mb4',
)
cur = conn.cursor()
cur.execute("""
SELECT parent_id, path, GROUP_CONCAT(menu_id) ids, COUNT(*) cnt
FROM tenant_sys_menu
WHERE parent_id IN (35001,35002,35003,35004,35005,35006,35007)
  AND menu_type <> 'F' AND visible='0'
GROUP BY parent_id, path HAVING COUNT(*)>1
""")
rows = cur.fetchall()
print('qw_dup:', rows)
for r in rows:
    ids = [int(x) for x in r[2].split(',')]
    cur.execute('SELECT menu_id, menu_name, path, component FROM tenant_sys_menu WHERE menu_id IN (%s)' % ','.join(map(str, ids)))
    for row in cur.fetchall():
        print(' ', row)

cur.close()
conn.close()