Symfony Profiler

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'ida_refonte'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  t0.ID_USER AS ID_USER_1,
  t0.USER_LOGIN AS USER_LOGIN_2,
  t0.USER_PASS AS USER_PASS_3,
  t0.OLD_USER_PASS AS OLD_USER_PASS_4,
  t0.USER_ROLES AS USER_ROLES_5,
  t0.NAME_USER AS NAME_USER_6,
  t0.FIRST_NAME_USER AS FIRST_NAME_USER_7,
  t0.IDA_LANGUAGE_ID_LANGUAGE AS IDA_LANGUAGE_ID_LANGUAGE_8,
  t0.IDA_SOCIETY_ID_SOCIETY AS IDA_SOCIETY_ID_SOCIETY_9,
  t0.IDA_USER_PROFILE_ID_USER_PROFILE AS IDA_USER_PROFILE_ID_USER_PROFILE_10,
  t0.EMAIL_USER AS EMAIL_USER_11,
  t0.USER_STATUS AS USER_STATUS_12,
  t0.FL_ISAN_MAIL_RECIPIENT AS FL_ISAN_MAIL_RECIPIENT_13,
  t0.FL_ENRICHEMENT_ALERT AS FL_ENRICHEMENT_ALERT_14,
  t0.FL_REPORT_RECIPIENT AS FL_REPORT_RECIPIENT_15,
  t0.FL_DETECT_DUPLICATE_AT_IMPORT AS FL_DETECT_DUPLICATE_AT_IMPORT_16,
  t0.FL_EOD_IN_CSV_FORMAT AS FL_EOD_IN_CSV_FORMAT_17,
  t0.DATE_LAST_UPDATE_PASSWORD AS DATE_LAST_UPDATE_PASSWORD_18,
  t0.DATE_LAST_LOGIN AS DATE_LAST_LOGIN_19,
  t0.FTP_ACCOUNT_STATUS AS FTP_ACCOUNT_STATUS_20,
  t0.FTP_ACCOUNT_ERROR_MESSAGE AS FTP_ACCOUNT_ERROR_MESSAGE_21,
  t0.ftp_account_created_at AS ftp_account_created_at_22,
  t0.ftp_account_updated_at AS ftp_account_updated_at_23,
  t0.ftp_account_deleted_at AS ftp_account_deleted_at_24,
  t0.is_migrated AS is_migrated_25,
  t0.FL_EOD_FORMAT AS FL_EOD_FORMAT_26,
  t0.FL_IS_ML_REF AS FL_IS_ML_REF_27,
  t0.FL_ML_NOTIF AS FL_ML_NOTIF_28,
  t0.FL_IS_ML_ENABLED AS FL_IS_ML_ENABLED_29,
  t0.IDA_SOCIETY_ID_SOCIETY AS IDA_SOCIETY_ID_SOCIETY_30,
  t0.IDA_LANGUAGE_ID_LANGUAGE AS IDA_LANGUAGE_ID_LANGUAGE_31,
  t0.IDA_USER_PROFILE_ID_USER_PROFILE AS IDA_USER_PROFILE_ID_USER_PROFILE_32,
  t33.ID_USER_FILTER AS ID_USER_FILTER_34,
  t33.IDA_USER_ID_USER AS IDA_USER_ID_USER_35,
  t33.WORK_LOGS AS WORK_LOGS_36,
  t33.LINKS AS LINKS_37,
  t33.KEYWORDS AS KEYWORDS_38,
  t33.PROD_COUNTRIES AS PROD_COUNTRIES_39,
  t33.TITLES AS TITLES_40,
  t33.PARTICIPANTS AS PARTICIPANTS_41,
  t33.SHOOT_LANGUAGES AS SHOOT_LANGUAGES_42,
  t33.REAL_EXPLOIT AS REAL_EXPLOIT_43,
  t33.COMMENTS AS COMMENTS_44,
  t33.INT_REF AS INT_REF_45,
  t33.ALL_SHARES AS ALL_SHARES_46,
  t33.CONTROLS AS CONTROLS_47,
  t33.PERSONAL_INFORMATION AS PERSONAL_INFORMATION_48,
  t33.IP_NATIONALITIES AS IP_NATIONALITIES_49,
  t33.IP_USAGES AS IP_USAGES_50,
  t33.AGREEMENT AS AGREEMENT_51,
  t33.REMARKS AS REMARKS_52,
  t33.IP_STATUS_HISTORY AS IP_STATUS_HISTORY_53,
  t33.MEMBERSHIP AS MEMBERSHIP_54,
  t33.WORK_LOGS_PRINT AS WORK_LOGS_PRINT_55,
  t33.LINKS_PRINT AS LINKS_PRINT_56,
  t33.PERSONAL_INFORMATION_PRINT AS PERSONAL_INFORMATION_PRINT_57,
  t33.IP_NATIONALITIES_PRINT AS IP_NATIONALITIES_PRINT_58,
  t33.IP_USAGES_PRINT AS IP_USAGES_PRINT_59,
  t33.AGREEMENT_PRINT AS AGREEMENT_PRINT_60,
  t33.REMARKS_PRINT AS REMARKS_PRINT_61,
  t33.IP_STATUS_HISTORY_PRINT AS IP_STATUS_HISTORY_PRINT_62,
  t33.MEMBERSHIP_PRINT AS MEMBERSHIP_PRINT_63,
  t33.IPI_DATA AS IPI_DATA_64,
  t33.IP_ONE_DISPLAY_RESTRICTION AS IP_ONE_DISPLAY_RESTRICTION_65,
  t33.TITLES_CSV AS TITLES_CSV_66,
  t33.PARTICIPANTS_CSV AS PARTICIPANTS_CSV_67,
  t33.NOTIFICATION_FOR_IMPORT AS NOTIFICATION_FOR_IMPORT_68,
  t33.NOTIFICATION_FOR_EXPORT AS NOTIFICATION_FOR_EXPORT_69,
  t33.NOTIFICATION_FOR_MONITORING_LIST AS NOTIFICATION_FOR_MONITORING_LIST_70,
  t33.IDA_USER_ID_USER AS IDA_USER_ID_USER_71,
  t72.ID_MONITORING_JOB_NAME AS ID_MONITORING_JOB_NAME_73,
  t72.PERIOD AS PERIOD_74,
  t72.FORMAT AS FORMAT_75,
  t72.DATE_LAST_EXECUTION AS DATE_LAST_EXECUTION_76,
  t72.IDA_USER_ID_USER AS IDA_USER_ID_USER_77,
  t78.ID_MONITORING_EXPORT_FIELDS AS ID_MONITORING_EXPORT_FIELDS_79,
  t78.IDA_USER_ID_USER AS IDA_USER_ID_USER_80,
  t78.TITLES AS TITLES_81,
  t78.KEYWORDS AS KEYWORDS_82,
  t78.PARTICIPANTS AS PARTICIPANTS_83,
  t78.REAL_EXPLOIT AS REAL_EXPLOIT_84,
  t78.SHOOT_LANGUAGES AS SHOOT_LANGUAGES_85,
  t78.PROD_COUNTRIES AS PROD_COUNTRIES_86,
  t78.WORK_LOGS AS WORK_LOGS_87,
  t78.LINKS AS LINKS_88,
  t78.CONTROLS AS CONTROLS_89,
  t78.COMMENTS AS COMMENTS_90,
  t78.INT_REF AS INT_REF_91,
  t78.ALL_SHARES AS ALL_SHARES_92,
  t78.IPI_DATA AS IPI_DATA_93,
  t78.PERSONAL_INFORMATION AS PERSONAL_INFORMATION_94,
  t78.IP_NATIONALITIES AS IP_NATIONALITIES_95,
  t78.IP_USAGES AS IP_USAGES_96,
  t78.AGREEMENT AS AGREEMENT_97,
  t78.REMARKS AS REMARKS_98,
  t78.IP_STATUS_HISTORY AS IP_STATUS_HISTORY_99,
  t78.IP_ONE_DISPLAY_RESTRICTION AS IP_ONE_DISPLAY_RESTRICTION_100,
  t78.TITLES_CSV AS TITLES_CSV_101,
  t78.PARTICIPANTS_CSV AS PARTICIPANTS_CSV_102,
  t78.IDA_USER_ID_USER AS IDA_USER_ID_USER_103,
  t0.MT_SEARCH_PRESET_ID AS MT_SEARCH_PRESET_ID_104,
  t105.ID_USER_RESULT AS ID_USER_RESULT_106,
  t105.IDA_USER_ID_USER AS IDA_USER_ID_USER_107,
  t105.RL_WORK_PAGE AS RL_WORK_PAGE_108,
  t105.RL_IMPORT_PAGE AS RL_IMPORT_PAGE_109,
  t105.RL_ISAN_PAGE AS RL_ISAN_PAGE_110,
  t105.RL_CART_PAGE AS RL_CART_PAGE_111,
  t105.RL_PODUP_PAGE AS RL_PODUP_PAGE_112,
  t105.IDA_USER_ID_USER AS IDA_USER_ID_USER_113
FROM
  IDA_USER t0
  LEFT JOIN IDA_USER_FILTER t33 ON t33.IDA_USER_ID_USER = t0.ID_USER
  LEFT JOIN IDA_MONITORING_JOB_NAME t72 ON t72.IDA_USER_ID_USER = t0.ID_USER
  LEFT JOIN IDA_MONITORING_EXPORT_FIELDS t78 ON t78.IDA_USER_ID_USER = t0.ID_USER
  LEFT JOIN IDA_USER_RESULT t105 ON t105.IDA_USER_ID_USER = t0.ID_USER
WHERE
  t0.ID_USER = ?

SELECT t0.ID_USER AS ID_USER_1, t0.USER_LOGIN AS USER_LOGIN_2, t0.USER_PASS AS USER_PASS_3, t0.OLD_USER_PASS AS OLD_USER_PASS_4, t0.USER_ROLES AS USER_ROLES_5, t0.NAME_USER AS NAME_USER_6, t0.FIRST_NAME_USER AS FIRST_NAME_USER_7, t0.IDA_LANGUAGE_ID_LANGUAGE AS IDA_LANGUAGE_ID_LANGUAGE_8, t0.IDA_SOCIETY_ID_SOCIETY AS IDA_SOCIETY_ID_SOCIETY_9, t0.IDA_USER_PROFILE_ID_USER_PROFILE AS IDA_USER_PROFILE_ID_USER_PROFILE_10, t0.EMAIL_USER AS EMAIL_USER_11, t0.USER_STATUS AS USER_STATUS_12, t0.FL_ISAN_MAIL_RECIPIENT AS FL_ISAN_MAIL_RECIPIENT_13, t0.FL_ENRICHEMENT_ALERT AS FL_ENRICHEMENT_ALERT_14, t0.FL_REPORT_RECIPIENT AS FL_REPORT_RECIPIENT_15, t0.FL_DETECT_DUPLICATE_AT_IMPORT AS FL_DETECT_DUPLICATE_AT_IMPORT_16, t0.FL_EOD_IN_CSV_FORMAT AS FL_EOD_IN_CSV_FORMAT_17, t0.DATE_LAST_UPDATE_PASSWORD AS DATE_LAST_UPDATE_PASSWORD_18, t0.DATE_LAST_LOGIN AS DATE_LAST_LOGIN_19, t0.FTP_ACCOUNT_STATUS AS FTP_ACCOUNT_STATUS_20, t0.FTP_ACCOUNT_ERROR_MESSAGE AS FTP_ACCOUNT_ERROR_MESSAGE_21, t0.ftp_account_created_at AS ftp_account_created_at_22, t0.ftp_account_updated_at AS ftp_account_updated_at_23, t0.ftp_account_deleted_at AS ftp_account_deleted_at_24, t0.is_migrated AS is_migrated_25, t0.FL_EOD_FORMAT AS FL_EOD_FORMAT_26, t0.FL_IS_ML_REF AS FL_IS_ML_REF_27, t0.FL_ML_NOTIF AS FL_ML_NOTIF_28, t0.FL_IS_ML_ENABLED AS FL_IS_ML_ENABLED_29, t0.IDA_SOCIETY_ID_SOCIETY AS IDA_SOCIETY_ID_SOCIETY_30, t0.IDA_LANGUAGE_ID_LANGUAGE AS IDA_LANGUAGE_ID_LANGUAGE_31, t0.IDA_USER_PROFILE_ID_USER_PROFILE AS IDA_USER_PROFILE_ID_USER_PROFILE_32, t33.ID_USER_FILTER AS ID_USER_FILTER_34, t33.IDA_USER_ID_USER AS IDA_USER_ID_USER_35, t33.WORK_LOGS AS WORK_LOGS_36, t33.LINKS AS LINKS_37, t33.KEYWORDS AS KEYWORDS_38, t33.PROD_COUNTRIES AS PROD_COUNTRIES_39, t33.TITLES AS TITLES_40, t33.PARTICIPANTS AS PARTICIPANTS_41, t33.SHOOT_LANGUAGES AS SHOOT_LANGUAGES_42, t33.REAL_EXPLOIT AS REAL_EXPLOIT_43, t33.COMMENTS AS COMMENTS_44, t33.INT_REF AS INT_REF_45, t33.ALL_SHARES AS ALL_SHARES_46, t33.CONTROLS AS CONTROLS_47, t33.PERSONAL_INFORMATION AS PERSONAL_INFORMATION_48, t33.IP_NATIONALITIES AS IP_NATIONALITIES_49, t33.IP_USAGES AS IP_USAGES_50, t33.AGREEMENT AS AGREEMENT_51, t33.REMARKS AS REMARKS_52, t33.IP_STATUS_HISTORY AS IP_STATUS_HISTORY_53, t33.MEMBERSHIP AS MEMBERSHIP_54, t33.WORK_LOGS_PRINT AS WORK_LOGS_PRINT_55, t33.LINKS_PRINT AS LINKS_PRINT_56, t33.PERSONAL_INFORMATION_PRINT AS PERSONAL_INFORMATION_PRINT_57, t33.IP_NATIONALITIES_PRINT AS IP_NATIONALITIES_PRINT_58, t33.IP_USAGES_PRINT AS IP_USAGES_PRINT_59, t33.AGREEMENT_PRINT AS AGREEMENT_PRINT_60, t33.REMARKS_PRINT AS REMARKS_PRINT_61, t33.IP_STATUS_HISTORY_PRINT AS IP_STATUS_HISTORY_PRINT_62, t33.MEMBERSHIP_PRINT AS MEMBERSHIP_PRINT_63, t33.IPI_DATA AS IPI_DATA_64, t33.IP_ONE_DISPLAY_RESTRICTION AS IP_ONE_DISPLAY_RESTRICTION_65, t33.TITLES_CSV AS TITLES_CSV_66, t33.PARTICIPANTS_CSV AS PARTICIPANTS_CSV_67, t33.NOTIFICATION_FOR_IMPORT AS NOTIFICATION_FOR_IMPORT_68, t33.NOTIFICATION_FOR_EXPORT AS NOTIFICATION_FOR_EXPORT_69, t33.NOTIFICATION_FOR_MONITORING_LIST AS NOTIFICATION_FOR_MONITORING_LIST_70, t33.IDA_USER_ID_USER AS IDA_USER_ID_USER_71, t72.ID_MONITORING_JOB_NAME AS ID_MONITORING_JOB_NAME_73, t72.PERIOD AS PERIOD_74, t72.FORMAT AS FORMAT_75, t72.DATE_LAST_EXECUTION AS DATE_LAST_EXECUTION_76, t72.IDA_USER_ID_USER AS IDA_USER_ID_USER_77, t78.ID_MONITORING_EXPORT_FIELDS AS ID_MONITORING_EXPORT_FIELDS_79, t78.IDA_USER_ID_USER AS IDA_USER_ID_USER_80, t78.TITLES AS TITLES_81, t78.KEYWORDS AS KEYWORDS_82, t78.PARTICIPANTS AS PARTICIPANTS_83, t78.REAL_EXPLOIT AS REAL_EXPLOIT_84, t78.SHOOT_LANGUAGES AS SHOOT_LANGUAGES_85, t78.PROD_COUNTRIES AS PROD_COUNTRIES_86, t78.WORK_LOGS AS WORK_LOGS_87, t78.LINKS AS LINKS_88, t78.CONTROLS AS CONTROLS_89, t78.COMMENTS AS COMMENTS_90, t78.INT_REF AS INT_REF_91, t78.ALL_SHARES AS ALL_SHARES_92, t78.IPI_DATA AS IPI_DATA_93, t78.PERSONAL_INFORMATION AS PERSONAL_INFORMATION_94, t78.IP_NATIONALITIES AS IP_NATIONALITIES_95, t78.IP_USAGES AS IP_USAGES_96, t78.AGREEMENT AS AGREEMENT_97, t78.REMARKS AS REMARKS_98, t78.IP_STATUS_HISTORY AS IP_STATUS_HISTORY_99, t78.IP_ONE_DISPLAY_RESTRICTION AS IP_ONE_DISPLAY_RESTRICTION_100, t78.TITLES_CSV AS TITLES_CSV_101, t78.PARTICIPANTS_CSV AS PARTICIPANTS_CSV_102, t78.IDA_USER_ID_USER AS IDA_USER_ID_USER_103, t0.MT_SEARCH_PRESET_ID AS MT_SEARCH_PRESET_ID_104, t105.ID_USER_RESULT AS ID_USER_RESULT_106, t105.IDA_USER_ID_USER AS IDA_USER_ID_USER_107, t105.RL_WORK_PAGE AS RL_WORK_PAGE_108, t105.RL_IMPORT_PAGE AS RL_IMPORT_PAGE_109, t105.RL_ISAN_PAGE AS RL_ISAN_PAGE_110, t105.RL_CART_PAGE AS RL_CART_PAGE_111, t105.RL_PODUP_PAGE AS RL_PODUP_PAGE_112, t105.IDA_USER_ID_USER AS IDA_USER_ID_USER_113 FROM IDA_USER t0 LEFT JOIN IDA_USER_FILTER t33 ON t33.IDA_USER_ID_USER = t0.ID_USER LEFT JOIN IDA_MONITORING_JOB_NAME t72 ON t72.IDA_USER_ID_USER = t0.ID_USER LEFT JOIN IDA_MONITORING_EXPORT_FIELDS t78 ON t78.IDA_USER_ID_USER = t0.ID_USER LEFT JOIN IDA_USER_RESULT t105 ON t105.IDA_USER_ID_USER = t0.ID_USER WHERE t0.ID_USER = 869;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  i0_.ID_SOCIETY AS ID_SOCIETY_0,
  i0_.IDA_COUNTRY_ID_COUNTRY AS IDA_COUNTRY_ID_COUNTRY_1,
  i0_.STD_SOCIETY AS STD_SOCIETY_2,
  i0_.LABEL_SOCIETY AS LABEL_SOCIETY_3,
  i0_.FL_VALID_SOCIETY AS FL_VALID_SOCIETY_4,
  i0_.FL_CISAC AS FL_CISAC_5,
  i0_.REGISTRANT_LOGIN AS REGISTRANT_LOGIN_6,
  i0_.IDA_COUNTRY_ID_COUNTRY AS IDA_COUNTRY_ID_COUNTRY_7
FROM
  IDA_SOCIETY i0_
WHERE
  i0_.FL_VALID_SOCIETY = 1
ORDER BY
  i0_.LABEL_SOCIETY ASC

SELECT i0_.ID_SOCIETY AS ID_SOCIETY_0, i0_.IDA_COUNTRY_ID_COUNTRY AS IDA_COUNTRY_ID_COUNTRY_1, i0_.STD_SOCIETY AS STD_SOCIETY_2, i0_.LABEL_SOCIETY AS LABEL_SOCIETY_3, i0_.FL_VALID_SOCIETY AS FL_VALID_SOCIETY_4, i0_.FL_CISAC AS FL_CISAC_5, i0_.REGISTRANT_LOGIN AS REGISTRANT_LOGIN_6, i0_.IDA_COUNTRY_ID_COUNTRY AS IDA_COUNTRY_ID_COUNTRY_7 FROM IDA_SOCIETY i0_ WHERE i0_.FL_VALID_SOCIETY = 1 ORDER BY i0_.LABEL_SOCIETY ASC;

SELECT
  b0_.ID AS ID_0,
  b0_.IP AS IP_1,
  b0_.date AS date_2,
  b0_.username AS username_3
FROM
  BannedIps b0_
WHERE
  b0_.IP = ?
  AND b0_.date > ?

SELECT b0_.ID AS ID_0, b0_.IP AS IP_1, b0_.date AS date_2, b0_.username AS username_3 FROM BannedIps b0_ WHERE b0_.IP = '77.158.253.7' AND b0_.date > '2026-07-03 10:15:49';

select
  LABEL_SOCIETY
from
  IDA_SYS_LOCK,
  IDA_SOCIETY
where
  IDA_SOCIETY_ID_SOCIETY = ID_SOCIETY

select LABEL_SOCIETY from IDA_SYS_LOCK, IDA_SOCIETY where IDA_SOCIETY_ID_SOCIETY = ID_SOCIETY;