Symfony Profiler

[
  "route" => "web_club_list-active"
  "route_parameters" => [
    "_route" => "web_club_list-active"
    "_controller" => "App\Controller\ClubController::listActive"
  ]
  "request_uri" => "https://www.dev.ceintureblanche.fr/crm/club?select=clear"
  "method" => "GET"
]

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

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

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

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

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

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

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

[
  "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 cl.* FROM club_location cl  JOIN club_lesson cles ON (cles.club_location_id = cl.id)  JOIN club c ON (c.id = cles.club_id) WHERE  c.active"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.* FROM club c JOIN (SELECT c.*        FROM club c          JOIN club_lesson cles ON c.id = cles.club_id         WHERE cles.club_location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)         GROUP BY c.id) cs ON c.id = cs.id"
  "params" => [
    1 => 1
    2 => 2
    3 => 3
    4 => 4
    5 => 5
    6 => 6
    7 => 7
    8 => 8
    9 => 9
    10 => 10
    11 => 11
    12 => 15
    13 => 16
    14 => 17
    15 => 18
    16 => 19
    17 => 21
    18 => 23
    19 => 24
    20 => 25
    21 => 26
    22 => 28
    23 => 27
    24 => 29
    25 => 30
    26 => 31
    27 => 32
    28 => 33
    29 => 35
    30 => 34
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
  ]
]

[
  "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 => 1
    2 => 2
    3 => 3
    4 => 4
    5 => 6
    6 => 9
    7 => 10
    8 => 13
    9 => 14
    10 => 15
    11 => 17
    12 => 18
    13 => 19
    14 => 21
    15 => 23
    16 => 24
    17 => 29
    18 => 30
    19 => 31
    20 => 32
    21 => 39
    22 => 40
    23 => 41
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 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 => 1
    2 => 2
    3 => 3
    4 => 4
    5 => 6
    6 => 9
    7 => 10
    8 => 13
    9 => 14
    10 => 15
    11 => 17
    12 => 18
    13 => 19
    14 => 21
    15 => 23
    16 => 24
    17 => 29
    18 => 30
    19 => 31
    20 => 32
    21 => 39
    22 => 40
    23 => 41
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 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 => 1
    2 => 2
    3 => 3
    4 => 4
    5 => 6
    6 => 9
    7 => 10
    8 => 13
    9 => 14
    10 => 15
    11 => 17
    12 => 18
    13 => 19
    14 => 21
    15 => 23
    16 => 24
    17 => 29
    18 => 30
    19 => 31
    20 => 32
    21 => 39
    22 => 40
    23 => 41
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
  ]
]

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

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

[
  "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 DATABASE()"
]

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

[
  "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 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 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 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
  ]
]