Query Metrics
2
Database Queries
2
Different statements
0.29 ms
Query time
0
Invalid entities
4
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.13 ms |
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
Parameters:
[
"e9cd5bbb94ff23fdd3ef6ff56bc638b87cec1ac66f99c2981957edd9f221f7b2"
]
|
||||||||||||||||||||||||||||
| 2 | 0.16 ms |
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 WHERE r0_.id = ?
Parameters:
[
4195
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ApiKey | 1 |
| App\Entity\Realisation | 1 |
| App\Entity\Photo | 1 |
| App\Entity\Reseau | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ApiKey | No errors. |
| App\Entity\Realisation | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Reseau | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Materiau | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\Geographie | No errors. |