Symfony Profiler

[
  "route" => "app_api_realisation_list"
  "route_parameters" => [
    "_route" => "app_api_realisation_list"
    "_controller" => "App\Controller\Api\RealisationController::list"
  ]
  "request_uri" => "https://dm-media-api.lebarts.com/api/realisations?dispo_site=1&include_photos=1&page=1&per_page=10&reseau=DMP&type_realisation=piscine-coque"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3314
    "user" => "dm_media_api_usr"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "engine" => "InnoDB"
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "dm_media_api_db"
    "serverVersion" => "10.11.1MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.name AS name_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM api_key t0 WHERE t0.api_key = ? LIMIT 1"
  "params" => [
    1 => "e9cd5bbb94ff23fdd3ef6ff56bc638b87cec1ac66f99c2981957edd9f221f7b2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#674
      +name: "STRING"
    }
  ]
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#702
    -user: App\Security\ApiKeyUser {#710 …}
    -roleNames: [
      "ROLE_API"
    ]
    -attributes: []
    -firewallName: "api"
  }
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

[
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

[
  "sql" => "SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM realisation r0_ INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id WHERE r1_.code = ? AND r0_.type_realisation = ? AND r0_.dispo_site = ?"
  "params" => [
    1 => "DMP"
    2 => "piscine-coque"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#674
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#674}
    3 => Doctrine\DBAL\ParameterType {#1361
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.alphasia_id AS alphasia_id_1, r0_.chantier_id AS chantier_id_2, r0_.title AS title_3, r0_.type AS type_4, r0_.type_realisation AS type_realisation_5, r0_.type_realisation_label AS type_realisation_label_6, r0_.code_entreprise AS code_entreprise_7, r0_.client AS client_8, r0_.selection_dm AS selection_dm_9, r0_.fav AS fav_10, r0_.video_url AS video_url_11, r0_.created_at AS created_at_12, r0_.date_prise AS date_prise_13, r0_.dispo_site AS dispo_site_14, r0_.dispo_appli AS dispo_appli_15, r0_.description AS description_16, r0_.date_realisation AS date_realisation_17, r0_.ville AS ville_18, r0_.code_postal AS code_postal_19, r0_.affichage_franchise_seul AS affichage_franchise_seul_20, r0_.realisation_poussee AS realisation_poussee_21, r0_.slug AS slug_22, r0_.source_modified_at AS source_modified_at_23, r0_.synced_at AS synced_at_24, p1_.id AS id_25, p1_.source_url AS source_url_26, p1_.local_path_big AS local_path_big_27, p1_.local_path_medium AS local_path_medium_28, p1_.width_big AS width_big_29, p1_.height_big AS height_big_30, p1_.width_medium AS width_medium_31, p1_.height_medium AS height_medium_32, p1_.source_timestamp AS source_timestamp_33, p1_.orientation AS orientation_34, p1_.cached AS cached_35, r2_.id AS id_36, r2_.code AS code_37, r2_.label AS label_38, r2_.alphasia_network_id AS alphasia_network_id_39, p3_.id AS id_40, p3_.nom AS nom_41, m4_.id AS id_42, m4_.nom AS nom_43, s5_.id AS id_44, s5_.nom AS nom_45, g6_.id AS id_46, g6_.nom AS nom_47, r7_.id AS id_48, r7_.code AS code_49, r7_.label AS label_50, r7_.alphasia_network_id AS alphasia_network_id_51 FROM realisation r0_ LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id LEFT JOIN realisation_reseau r8_ ON r0_.id = r8_.realisation_id LEFT JOIN reseau r2_ ON r2_.id = r8_.reseau_id LEFT JOIN realisation_produit r9_ ON r0_.id = r9_.realisation_id LEFT JOIN produit p3_ ON p3_.id = r9_.produit_id LEFT JOIN realisation_materiau r10_ ON r0_.id = r10_.realisation_id LEFT JOIN materiau m4_ ON m4_.id = r10_.materiau_id LEFT JOIN realisation_style r11_ ON r0_.id = r11_.realisation_id LEFT JOIN style s5_ ON s5_.id = r11_.style_id LEFT JOIN realisation_geographie r12_ ON r0_.id = r12_.realisation_id LEFT JOIN geographie g6_ ON g6_.id = r12_.geographie_id INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id INNER JOIN reseau r7_ ON r7_.id = r13_.reseau_id WHERE r7_.code = ? AND r0_.type_realisation = ? AND r0_.dispo_site = ?) dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 10"
  "params" => [
    1 => "DMP"
    2 => "piscine-coque"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#674
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#674}
    3 => Doctrine\DBAL\ParameterType {#1361
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.alphasia_id AS alphasia_id_1, r0_.chantier_id AS chantier_id_2, r0_.title AS title_3, r0_.type AS type_4, r0_.type_realisation AS type_realisation_5, r0_.type_realisation_label AS type_realisation_label_6, r0_.code_entreprise AS code_entreprise_7, r0_.client AS client_8, r0_.selection_dm AS selection_dm_9, r0_.fav AS fav_10, r0_.video_url AS video_url_11, r0_.created_at AS created_at_12, r0_.date_prise AS date_prise_13, r0_.dispo_site AS dispo_site_14, r0_.dispo_appli AS dispo_appli_15, r0_.description AS description_16, r0_.date_realisation AS date_realisation_17, r0_.ville AS ville_18, r0_.code_postal AS code_postal_19, r0_.affichage_franchise_seul AS affichage_franchise_seul_20, r0_.realisation_poussee AS realisation_poussee_21, r0_.slug AS slug_22, r0_.source_modified_at AS source_modified_at_23, r0_.synced_at AS synced_at_24, p1_.id AS id_25, p1_.source_url AS source_url_26, p1_.local_path_big AS local_path_big_27, p1_.local_path_medium AS local_path_medium_28, p1_.width_big AS width_big_29, p1_.height_big AS height_big_30, p1_.width_medium AS width_medium_31, p1_.height_medium AS height_medium_32, p1_.source_timestamp AS source_timestamp_33, p1_.orientation AS orientation_34, p1_.cached AS cached_35, r2_.id AS id_36, r2_.code AS code_37, r2_.label AS label_38, r2_.alphasia_network_id AS alphasia_network_id_39, p3_.id AS id_40, p3_.nom AS nom_41, m4_.id AS id_42, m4_.nom AS nom_43, s5_.id AS id_44, s5_.nom AS nom_45, g6_.id AS id_46, g6_.nom AS nom_47, p1_.realisation_id AS realisation_id_48 FROM realisation r0_ LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id LEFT JOIN realisation_reseau r7_ ON r0_.id = r7_.realisation_id LEFT JOIN reseau r2_ ON r2_.id = r7_.reseau_id LEFT JOIN realisation_produit r8_ ON r0_.id = r8_.realisation_id LEFT JOIN produit p3_ ON p3_.id = r8_.produit_id LEFT JOIN realisation_materiau r9_ ON r0_.id = r9_.realisation_id LEFT JOIN materiau m4_ ON m4_.id = r9_.materiau_id LEFT JOIN realisation_style r10_ ON r0_.id = r10_.realisation_id LEFT JOIN style s5_ ON s5_.id = r10_.style_id LEFT JOIN realisation_geographie r11_ ON r0_.id = r11_.realisation_id LEFT JOIN geographie g6_ ON g6_.id = r11_.geographie_id INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id INNER JOIN reseau r12_ ON r12_.id = r13_.reseau_id WHERE r12_.code = ? AND r0_.type_realisation = ? AND r0_.dispo_site = ? AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.created_at DESC"
  "params" => [
    1 => "DMP"
    2 => "piscine-coque"
    3 => 1
    4 => 155
    5 => 4195
    6 => 4197
    7 => 4196
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#674
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#674}
    3 => Doctrine\DBAL\ParameterType {#1361
      +name: "BOOLEAN"
    }
    4 => Doctrine\DBAL\ParameterType {#676
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#676}
    6 => Doctrine\DBAL\ParameterType {#676}
    7 => Doctrine\DBAL\ParameterType {#676}
  ]
]