Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 768
• Events
• Routing
• Cache
• Translation 246
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 9
• Migrations
• Debug
• Messages
• Emails
• Workflow
• Notifications
• VichUploader
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created AS created_4, t0.active AS active_5, t0.type AS type_6, t0.access AS access_7, t0.description AS description_8, t0.limit_max_member AS limit_max_member_9, t0.limit_max_engineer AS limit_max_engineer_10, t0.limit_max_admin AS limit_max_admin_11, t0.limit_min_member AS limit_min_member_12, t0.limit_min_engineer AS limit_min_engineer_13, t0.limit_min_admin AS limit_min_admin_14, t0.cgu AS cgu_15, t0.data_access AS data_access_16, t0.rocket_room AS rocket_room_17, t0.community AS community_18, t0.color AS color_19, t0.default_route AS default_route_20, t0.subtitle AS subtitle_21, t0.iframe_url AS iframe_url_22, t0.iframe_name AS iframe_name_23, t0.parent_service_list AS parent_service_list_24, t0.siret AS siret_25, t0.address AS address_26, t0.phone_number AS phone_number_27, t0.mattermost_id AS mattermost_id_28, t0.custom_fields AS custom_fields_29, t0.base_template AS base_template_30, t0.custom_script AS custom_script_31, t0.wiuz_api_url AS wiuz_api_url_32, t0.wiuz_api_key AS wiuz_api_key_33, t0.geofo_link_connection AS geofo_link_connection_34, t0.domain AS domain_35, t0.smtp_conf AS smtp_conf_36, t0.country AS country_37, t0.logo_id AS logo_id_38, t39.id AS id_40, t39.updated_date AS updated_date_41, t39.path AS path_42, t0.creator_id AS creator_id_43, t44.id AS id_45, t44.title AS title_46, t44.description AS description_47, t44.start_date AS start_date_48, t44.end_date AS end_date_49, t44.active AS active_50, t44.slug AS slug_51, t44.identifier AS identifier_52, t44.type_id AS type_id_53, t44.company_id AS company_id_54 FROM company t0 LEFT JOIN company_logo t39 ON t0.logo_id = t39.id LEFT JOIN tips t44 ON t44.company_id = t0.id WHERE t0.slug = ? LIMIT 1

[
  ""
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created AS created_4,
  t0.active AS active_5,
  t0.type AS type_6,
  t0.access AS access_7,
  t0.description AS description_8,
  t0.limit_max_member AS limit_max_member_9,
  t0.limit_max_engineer AS limit_max_engineer_10,
  t0.limit_max_admin AS limit_max_admin_11,
  t0.limit_min_member AS limit_min_member_12,
  t0.limit_min_engineer AS limit_min_engineer_13,
  t0.limit_min_admin AS limit_min_admin_14,
  t0.cgu AS cgu_15,
  t0.data_access AS data_access_16,
  t0.rocket_room AS rocket_room_17,
  t0.community AS community_18,
  t0.color AS color_19,
  t0.default_route AS default_route_20,
  t0.subtitle AS subtitle_21,
  t0.iframe_url AS iframe_url_22,
  t0.iframe_name AS iframe_name_23,
  t0.parent_service_list AS parent_service_list_24,
  t0.siret AS siret_25,
  t0.address AS address_26,
  t0.phone_number AS phone_number_27,
  t0.mattermost_id AS mattermost_id_28,
  t0.custom_fields AS custom_fields_29,
  t0.base_template AS base_template_30,
  t0.custom_script AS custom_script_31,
  t0.wiuz_api_url AS wiuz_api_url_32,
  t0.wiuz_api_key AS wiuz_api_key_33,
  t0.geofo_link_connection AS geofo_link_connection_34,
  t0.domain AS domain_35,
  t0.smtp_conf AS smtp_conf_36,
  t0.country AS country_37,
  t0.logo_id AS logo_id_38,
  t39.id AS id_40,
  t39.updated_date AS updated_date_41,
  t39.path AS path_42,
  t0.creator_id AS creator_id_43,
  t44.id AS id_45,
  t44.title AS title_46,
  t44.description AS description_47,
  t44.start_date AS start_date_48,
  t44.end_date AS end_date_49,
  t44.active AS active_50,
  t44.slug AS slug_51,
  t44.identifier AS identifier_52,
  t44.type_id AS type_id_53,
  t44.company_id AS company_id_54
FROM
  company t0
  LEFT JOIN company_logo t39 ON t0.logo_id = t39.id
  LEFT JOIN tips t44 ON t44.company_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created AS created_4, t0.active AS active_5, t0.type AS type_6, t0.access AS access_7, t0.description AS description_8, t0.limit_max_member AS limit_max_member_9, t0.limit_max_engineer AS limit_max_engineer_10, t0.limit_max_admin AS limit_max_admin_11, t0.limit_min_member AS limit_min_member_12, t0.limit_min_engineer AS limit_min_engineer_13, t0.limit_min_admin AS limit_min_admin_14, t0.cgu AS cgu_15, t0.data_access AS data_access_16, t0.rocket_room AS rocket_room_17, t0.community AS community_18, t0.color AS color_19, t0.default_route AS default_route_20, t0.subtitle AS subtitle_21, t0.iframe_url AS iframe_url_22, t0.iframe_name AS iframe_name_23, t0.parent_service_list AS parent_service_list_24, t0.siret AS siret_25, t0.address AS address_26, t0.phone_number AS phone_number_27, t0.mattermost_id AS mattermost_id_28, t0.custom_fields AS custom_fields_29, t0.base_template AS base_template_30, t0.custom_script AS custom_script_31, t0.wiuz_api_url AS wiuz_api_url_32, t0.wiuz_api_key AS wiuz_api_key_33, t0.geofo_link_connection AS geofo_link_connection_34, t0.domain AS domain_35, t0.smtp_conf AS smtp_conf_36, t0.country AS country_37, t0.logo_id AS logo_id_38, t39.id AS id_40, t39.updated_date AS updated_date_41, t39.path AS path_42, t0.creator_id AS creator_id_43, t44.id AS id_45, t44.title AS title_46, t44.description AS description_47, t44.start_date AS start_date_48, t44.end_date AS end_date_49, t44.active AS active_50, t44.slug AS slug_51, t44.identifier AS identifier_52, t44.type_id AS type_id_53, t44.company_id AS company_id_54 FROM company t0 LEFT JOIN company_logo t39 ON t0.logo_id = t39.id LEFT JOIN tips t44 ON t44.company_id = t0.id WHERE t0.slug = '' LIMIT 1;

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'

[
  "realDemoV5"
]

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'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'realDemoV5'
  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';

SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso IN (?, ?, ?, ?)

[
  "FR"
  "DE"
  "ES"
  "IT"
]

SELECT
  t0.iso AS iso_1,
  t0.name_fr AS name_fr_2,
  t0.name_en AS name_en_3
FROM
  country t0
WHERE
  t0.iso IN (?, ?, ?, ?)

SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso IN ('FR', 'DE', 'ES', 'IT');

SELECT CURRENT_DATABASE()

[]

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'

[]

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SELECT c0_.iso AS iso_0, c0_.name_fr AS name_fr_1, c0_.name_en AS name_en_2 FROM country c0_

[]

SELECT
  c0_.iso AS iso_0,
  c0_.name_fr AS name_fr_1,
  c0_.name_en AS name_en_2
FROM
  country c0_

SELECT c0_.iso AS iso_0, c0_.name_fr AS name_fr_1, c0_.name_en AS name_en_2 FROM country c0_;

SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso = ? LIMIT 1

[
  "FR"
]

SELECT
  t0.iso AS iso_1,
  t0.name_fr AS name_fr_2,
  t0.name_en AS name_en_3
FROM
  country t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.iso AS iso_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM country t0 WHERE t0.iso = 'FR' LIMIT 1;

SHOW search_path

[]

SHOW search_path

SHOW search_path;