Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.level AS level_4,
  t0.db_name AS db_name_5,
  t0.vault_key_id AS vault_key_id_6,
  t0.default_locale AS default_locale_7,
  t0.available_locales AS available_locales_8,
  t0.plan AS plan_9,
  t0.max_families AS max_families_10,
  t0.monthly_sms_budget AS monthly_sms_budget_11,
  t0.payment_gateway AS payment_gateway_12,
  t0.logo_path AS logo_path_13,
  t0.slug AS slug_14,
  t0.primary_color AS primary_color_15,
  t0.president_name AS president_name_16,
  t0.subdomain_enabled AS subdomain_enabled_17,
  t0.custom_domain AS custom_domain_18,
  t0.street_number AS street_number_19,
  t0.address AS address_20,
  t0.city AS city_21,
  t0.zip AS zip_22,
  t0.country AS country_23,
  t0.timezone AS timezone_24,
  t0.latitude AS latitude_25,
  t0.longitude AS longitude_26,
  t0.reference_city AS reference_city_27,
  t0.phone AS phone_28,
  t0.email AS email_29,
  t0.website AS website_30,
  t0.siret AS siret_31,
  t0.stripe_customer_id AS stripe_customer_id_32,
  t0.stripe_subscription_id AS stripe_subscription_id_33,
  t0.is_active AS is_active_34,
  t0.has_cemetery_module AS has_cemetery_module_35,
  t0.has_wordpress_hosting AS has_wordpress_hosting_36,
  t0.consistoire_reverse_percent AS consistoire_reverse_percent_37,
  t0.consistoire_sharing_level AS consistoire_sharing_level_38,
  t0.fundraising_settings AS fundraising_settings_39,
  t0.created_at AS created_at_40,
  t0.trial_ends_at AS trial_ends_at_41,
  t0.parent_id AS parent_id_42
FROM
  organizations t0
WHERE
  t0.custom_domain = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.level AS level_4, t0.db_name AS db_name_5, t0.vault_key_id AS vault_key_id_6, t0.default_locale AS default_locale_7, t0.available_locales AS available_locales_8, t0.plan AS plan_9, t0.max_families AS max_families_10, t0.monthly_sms_budget AS monthly_sms_budget_11, t0.payment_gateway AS payment_gateway_12, t0.logo_path AS logo_path_13, t0.slug AS slug_14, t0.primary_color AS primary_color_15, t0.president_name AS president_name_16, t0.subdomain_enabled AS subdomain_enabled_17, t0.custom_domain AS custom_domain_18, t0.street_number AS street_number_19, t0.address AS address_20, t0.city AS city_21, t0.zip AS zip_22, t0.country AS country_23, t0.timezone AS timezone_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.reference_city AS reference_city_27, t0.phone AS phone_28, t0.email AS email_29, t0.website AS website_30, t0.siret AS siret_31, t0.stripe_customer_id AS stripe_customer_id_32, t0.stripe_subscription_id AS stripe_subscription_id_33, t0.is_active AS is_active_34, t0.has_cemetery_module AS has_cemetery_module_35, t0.has_wordpress_hosting AS has_wordpress_hosting_36, t0.consistoire_reverse_percent AS consistoire_reverse_percent_37, t0.consistoire_sharing_level AS consistoire_sharing_level_38, t0.fundraising_settings AS fundraising_settings_39, t0.created_at AS created_at_40, t0.trial_ends_at AS trial_ends_at_41, t0.parent_id AS parent_id_42 FROM organizations t0 WHERE t0.custom_domain = 'managsyntest.avinconcept.fr' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.preferred_locale AS preferred_locale_7,
  t0.totp_secret AS totp_secret_8,
  t0.totp_enabled AS totp_enabled_9,
  t0.email_auth_code AS email_auth_code_10,
  t0.last_login_at AS last_login_at_11,
  t0.last_login_ip AS last_login_ip_12,
  t0.last_login_country AS last_login_country_13,
  t0.is_active AS is_active_14,
  t0.must_change_password AS must_change_password_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.organization_id AS organization_id_18,
  t0.user_profile_id AS user_profile_id_19
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.preferred_locale AS preferred_locale_7, t0.totp_secret AS totp_secret_8, t0.totp_enabled AS totp_enabled_9, t0.email_auth_code AS email_auth_code_10, t0.last_login_at AS last_login_at_11, t0.last_login_ip AS last_login_ip_12, t0.last_login_country AS last_login_country_13, t0.is_active AS is_active_14, t0.must_change_password AS must_change_password_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.organization_id AS organization_id_18, t0.user_profile_id AS user_profile_id_19 FROM users t0 WHERE t0.id = 8;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'synagogue_manager_central'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name);

SELECT
  current_schema()

SELECT current_schema();

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'synagogue_manager_central'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name);

SELECT
  n.nspname,
  c.relname,
  a.attname,
  t.typname,
  format_type(a.atttypid, a.atttypmod),
  bt.typname,
  format_type(bt.oid, t.typtypmod),
  a.attnotnull,
  a.attidentity,
  (
    SELECT
      CASE WHEN a.attgenerated = 's' THEN
        NULL
      ELSE
        pg_get_expr(adbin, adrelid)
      END
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ),
  dsc.description,
  CASE WHEN coll.collprovider = 'c' THEN
    coll.collcollate
  WHEN coll.collprovider = 'd' THEN
    NULL
  ELSE
    coll.collname
  END
FROM
  pg_attribute a
  JOIN pg_class c ON c.oid = a.attrelid
  JOIN pg_namespace n ON n.oid = c.relnamespace
  JOIN pg_type t ON t.oid = a.atttypid
  LEFT JOIN pg_type bt ON t.typtype = 'd'
  AND bt.oid = t.typbasetype
  LEFT JOIN pg_collation coll ON coll.oid = a.attcollation
  LEFT JOIN pg_depend dep ON dep.objid = c.oid
  AND dep.deptype = 'e'
  AND dep.classid = (
    SELECT
      oid
    FROM
      pg_class
    WHERE
      relname = 'pg_class'
  )
  LEFT JOIN pg_description dsc ON dsc.objoid = c.oid
  AND dsc.objsubid = a.attnum
  LEFT JOIN pg_inherits i ON i.inhrelid = c.oid
  LEFT JOIN pg_class p ON i.inhparent = p.oid
  AND p.relkind = 'p'
WHERE
  n.nspname = ?
  AND c.relname = ?
  AND n.nspname NOT LIKE 'pg\_%'
  AND n.nspname != 'information_schema'
  AND c.relkind IN ('r', 'p')
  AND c.relname NOT IN (
    'geometry_columns', 'spatial_ref_sys'
  )
  AND a.attnum > 0
  AND dep.refobjid IS NULL -- exclude partitions (tables that inherit from partitioned tables)
  AND p.oid IS NULL
ORDER BY
  n.nspname,
  c.relname,
  a.attnum

SELECT n.nspname,
       c.relname,
       a.attname,
       t.typname,
       format_type(a.atttypid, a.atttypmod),
       bt.typname,
       format_type(bt.oid, t.typtypmod),
       a.attnotnull,
       a.attidentity,
       (    SELECT
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     FROM pg_attrdef
     WHERE c.oid = pg_attrdef.adrelid
        AND pg_attrdef.adnum=a.attnum),
       dsc.description,
       CASE
           WHEN coll.collprovider = 'c'
               THEN coll.collcollate
           WHEN coll.collprovider = 'd'
               THEN NULL
           ELSE coll.collname
           END
FROM pg_attribute a
         JOIN pg_class c
              ON c.oid = a.attrelid
         JOIN pg_namespace n
              ON n.oid = c.relnamespace
         JOIN pg_type t
              ON t.oid = a.atttypid
         LEFT JOIN pg_type bt
                   ON t.typtype = 'd'
                       AND bt.oid = t.typbasetype
         LEFT JOIN pg_collation coll
                   ON coll.oid = a.attcollation
         LEFT JOIN pg_depend dep
                   ON dep.objid = c.oid
                       AND dep.deptype = 'e'
                       AND dep.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class')
         LEFT JOIN pg_description dsc
                   ON dsc.objoid = c.oid AND dsc.objsubid = a.attnum
         LEFT JOIN pg_inherits i
                   ON i.inhrelid = c.oid
         LEFT JOIN pg_class p
                   ON i.inhparent = p.oid
                       AND p.relkind = 'p'
WHERE n.nspname = 'public' AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND a.attnum > 0
  AND dep.refobjid IS NULL
  -- exclude partitions (tables that inherit from partitioned tables)
  AND p.oid IS NULL
ORDER BY n.nspname,
         c.relname,
         a.attnum;

SELECT
  n.nspname,
  c.relname,
  CASE c.relpersistence
  WHEN 'u' THEN
    true
  ELSE
    false
  END,
  obj_description(c.oid, 'pg_class')
FROM
  pg_class c
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  n.nspname = ?
  AND c.relname = ?
  AND n.nspname NOT LIKE 'pg\_%'
  AND n.nspname != 'information_schema'
  AND c.relkind IN ('r', 'p')
  AND c.relname NOT IN (
    'geometry_columns', 'spatial_ref_sys'
  )

SELECT n.nspname,
       c.relname,
       CASE c.relpersistence WHEN 'u' THEN true ELSE false END,
       obj_description(c.oid, 'pg_class')
FROM pg_class c
         INNER JOIN pg_namespace n
                    ON n.oid = c.relnamespace
WHERE n.nspname = 'public' AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys');

SELECT
  n.nspname,
  c.relname,
  ct.conname,
  a.attname
FROM
  pg_namespace n
  INNER JOIN pg_class c ON c.relnamespace = n.oid
  INNER JOIN pg_constraint ct ON ct.conrelid = c.oid
  INNER JOIN pg_index i ON i.indrelid = c.oid
  AND i.indexrelid = ct.conindid
  INNER JOIN LATERAL unnest(i.indkey)
WITH
  ORDINALITY AS keys(attnum, ord) ON true
  INNER JOIN pg_attribute a ON a.attrelid = c.oid
  AND a.attnum = keys.attnum
WHERE
  n.nspname = ?
  AND c.relname = ?
  AND n.nspname NOT LIKE 'pg\_%'
  AND n.nspname != 'information_schema'
  AND c.relkind IN ('r', 'p')
  AND c.relname NOT IN (
    'geometry_columns', 'spatial_ref_sys'
  )
  AND ct.contype = 'p'
ORDER BY
  n.nspname,
  c.relname,
  ct.conname,
  keys.ord

SELECT n.nspname,
       c.relname,
       ct.conname,
       a.attname
FROM pg_namespace n
         INNER JOIN pg_class c
                    ON c.relnamespace = n.oid
         INNER JOIN pg_constraint ct
                    ON ct.conrelid = c.oid
         INNER JOIN pg_index i
                    ON i.indrelid = c.oid
                        AND i.indexrelid = ct.conindid
         INNER JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord)
                    ON true
         INNER JOIN
     pg_attribute a
     ON a.attrelid = c.oid
         AND a.attnum = keys.attnum
WHERE n.nspname = 'public' AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND ct.contype = 'p'
ORDER BY n.nspname,
         c.relname,
         ct.conname,
         keys.ord;

SELECT
  n.nspname,
  c.relname,
  ic.relname,
  i.indisunique,
  pg_get_expr(indpred, indrelid),
  attname
FROM
  pg_index i
  JOIN pg_class AS c ON c.oid = i.indrelid
  JOIN pg_namespace n ON n.oid = c.relnamespace
  JOIN pg_class AS ic ON ic.oid = i.indexrelid
  JOIN LATERAL unnest(i.indkey)
WITH
  ORDINALITY AS keys(attnum, ord) ON TRUE
  JOIN pg_attribute a ON a.attrelid = c.oid
  AND a.attnum = keys.attnum
WHERE
  n.nspname = ?
  AND c.relname = ?
  AND n.nspname NOT LIKE 'pg\_%'
  AND n.nspname != 'information_schema'
  AND c.relkind IN ('r', 'p')
  AND c.relname NOT IN (
    'geometry_columns', 'spatial_ref_sys'
  )
  AND i.indisprimary = false
ORDER BY
  n.nspname,
  c.relname,
  ic.relname,
  keys.ord

SELECT n.nspname,
       c.relname,
       ic.relname,
       i.indisunique,
       pg_get_expr(indpred, indrelid),
       attname
FROM pg_index i
         JOIN pg_class AS c ON c.oid = i.indrelid
         JOIN pg_namespace n ON n.oid = c.relnamespace
         JOIN pg_class AS ic ON ic.oid = i.indexrelid
         JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord)
              ON TRUE
         JOIN pg_attribute a
              ON a.attrelid = c.oid
                  AND a.attnum = keys.attnum
WHERE n.nspname = 'public' AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
  AND i.indisprimary = false
ORDER BY n.nspname,
         c.relname,
         ic.relname,
         keys.ord;

SELECT
  pkn.nspname,
  pkc.relname,
  r.conname,
  fkn.nspname,
  fkc.relname,
  r.confupdtype,
  r.confdeltype,
  r.condeferrable,
  r.condeferred,
  pka.attname,
  fka.attname
FROM
  pg_constraint r
  JOIN pg_class fkc ON fkc.oid = r.confrelid
  JOIN pg_namespace fkn ON fkn.oid = fkc.relnamespace
  JOIN unnest(r.confkey)
WITH
  ORDINALITY AS fk_attnum(attnum, ord) ON TRUE
  JOIN pg_attribute fka ON fka.attrelid = fkc.oid
  AND fka.attnum = fk_attnum.attnum
  JOIN pg_class pkc ON pkc.oid = r.conrelid
  JOIN pg_namespace pkn ON pkn.oid = pkc.relnamespace
  JOIN unnest(r.conkey)
WITH
  ORDINALITY AS pk_attnum(attnum, ord) ON pk_attnum.ord = fk_attnum.ord
  JOIN pg_attribute pka ON pka.attrelid = pkc.oid
  AND pka.attnum = pk_attnum.attnum
WHERE
  pkn.nspname = ?
  AND pkc.relname = ?
  AND pkn.nspname NOT LIKE 'pg\_%'
  AND pkn.nspname != 'information_schema'
  AND pkc.relkind IN ('r', 'p')
  AND pkc.relname NOT IN (
    'geometry_columns', 'spatial_ref_sys'
  )
  AND r.contype = 'f'
ORDER BY
  pkn.nspname,
  pkc.relname,
  r.conname

SELECT pkn.nspname,
           pkc.relname,
           r.conname,
           fkn.nspname,
           fkc.relname,
           r.confupdtype,
           r.confdeltype,
           r.condeferrable,
           r.condeferred,
           pka.attname,
           fka.attname
    FROM pg_constraint r
             JOIN pg_class fkc
                  ON fkc.oid = r.confrelid
             JOIN pg_namespace fkn
                  ON fkn.oid = fkc.relnamespace
             JOIN unnest(r.confkey) WITH ORDINALITY AS fk_attnum(attnum, ord)
                  ON TRUE
             JOIN pg_attribute fka
                  ON fka.attrelid = fkc.oid
                      AND fka.attnum = fk_attnum.attnum
             JOIN pg_class pkc
                  ON pkc.oid = r.conrelid
             JOIN pg_namespace pkn
                  ON pkn.oid = pkc.relnamespace
             JOIN unnest(r.conkey) WITH ORDINALITY AS pk_attnum(attnum, ord)
                  ON pk_attnum.ord = fk_attnum.ord
             JOIN pg_attribute pka
                  ON pka.attrelid = pkc.oid
                      AND pka.attnum = pk_attnum.attnum
    WHERE pkn.nspname = 'public' AND pkc.relname = 'doctrine_migration_versions' AND pkn.nspname NOT LIKE 'pg\_%' AND pkn.nspname != 'information_schema' AND pkc.relkind IN ('r', 'p') AND pkc.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
      AND r.contype = 'f'
    ORDER BY pkn.nspname,
             pkc.relname,
             r.conname;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();