Symfony Profiler

[
  "route" => "web_club_one"
  "route_parameters" => [
    "_route" => "web_club_one"
    "_controller" => "App\Controller\ClubController::viewOne"
    "uuid" => "sudouest"
  ]
  "request_uri" => "https://www.dev.ceintureblanche.fr/crm/club/sudouest"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\ApiAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\ApiAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sc2cenacle"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "sc2cenacle_crm_dev"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "sudouest"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT les.club_id AS club_id, loc.* FROM club_lesson les  JOIN club_location loc ON les.club_location_id = loc.id WHERE les.club_id IN (?) GROUP BY 1, 2"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.discipline AS discipline_3, t0.category AS category_4, t0.comment AS comment_5, t0.price_child_1 AS price_child_1_6, t0.price_child_2 AS price_child_2_7, t0.price_child_3 AS price_child_3_8, t0.price_adult AS price_adult_9, t0.club_id AS club_id_10 FROM club_price t0 WHERE t0.club_id IN (?)"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.value AS value_4, t0.club_id AS club_id_5 FROM club_property t0 WHERE t0.club_id IN (?)"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => "SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'sc2cenacle_crm_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC"
]

[
  "sql" => "SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'sc2cenacle_crm_dev' /*!50116 AND c.CONSTRAINT_SCHEMA = 'sc2cenacle_crm_dev' */ORDER BY k.ORDINAL_POSITION"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => "SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'sc2cenacle_crm_dev' ORDER BY SEQ_IN_INDEX ASC"
]

[
  "sql" => """
    SELECT t.ENGINE,\n
           t.AUTO_INCREMENT,\n
           t.TABLE_COMMENT,\n
           t.CREATE_OPTIONS,\n
           t.TABLE_COLLATION,\n
           ccsa.CHARACTER_SET_NAME\n
    FROM information_schema.TABLES t\n
        INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa\n
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION\n
    WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
    """
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "sudouest"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.point AS point_3, t0.discipline AS discipline_4, t0.age_level AS age_level_5, t0.day_of_week AS day_of_week_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.description AS description_9, t0.club_location_id AS club_location_id_10, t0.club_id AS club_id_11 FROM club_lesson t0 WHERE t0.club_id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "sudouest"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.property_key AS property_key_1, c0_.property_value AS property_value_2, c0_.updated_date AS updated_date_3, c0_.updater_user_id AS updater_user_id_4, c0_.previous_value AS previous_value_5 FROM configuration_property c0_ WHERE c0_.property_key LIKE ?"
  "params" => [
    1 => "menu.%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "sudouest"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.property_key AS property_key_1, c0_.property_value AS property_value_2, c0_.updated_date AS updated_date_3, c0_.updater_user_id AS updater_user_id_4, c0_.previous_value AS previous_value_5 FROM configuration_property c0_ WHERE c0_.property_key LIKE ?"
  "params" => [
    1 => "cenacle.%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.property_key AS property_key_1, c0_.property_value AS property_value_2, c0_.updated_date AS updated_date_3, c0_.updater_user_id AS updater_user_id_4, c0_.previous_value AS previous_value_5 FROM configuration_property c0_ WHERE c0_.property_key LIKE ?"
  "params" => [
    1 => "club.%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?"
  "params" => [
    1 => "sudouest"
  ]
  "types" => [
    1 => 2
  ]
]