Query Metrics
7
Database Queries
7
Different statements
2.19 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.57 ms (26.03%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.45 ms (20.29%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.document_name AS document_name_3, t0.document_size AS document_size_4, t0.document_updated_at AS document_updated_at_5, t0.youtube_link AS youtube_link_6, t0.updated_at AS updated_at_7, t0.document_update_name AS document_update_name_8, t0.document_update_size AS document_update_size_9, t0.document_update_updated_at AS document_update_updated_at_10, t0.document_update_date AS document_update_date_11, t12.download_number AS download_number_13, t12.created_at AS created_at_14, t12.start_at AS start_at_15, t12.end_at AS end_at_16, t12.ref AS ref_17, t12.first_apparition_at AS first_apparition_at_18, t12.id AS id_19, t12.category_id AS category_id_20, t12.translation_en_id AS translation_en_id_21, t12.translation_fr_id AS translation_fr_id_22, t12.translation_us_id AS translation_us_id_23, t12.translation_es_id AS translation_es_id_24, t12.translation_de_id AS translation_de_id_25, t12.translation_pt_id AS translation_pt_id_26, t27.download_number AS download_number_28, t27.created_at AS created_at_29, t27.start_at AS start_at_30, t27.end_at AS end_at_31, t27.ref AS ref_32, t27.first_apparition_at AS first_apparition_at_33, t27.id AS id_34, t27.category_id AS category_id_35, t27.translation_en_id AS translation_en_id_36, t27.translation_fr_id AS translation_fr_id_37, t27.translation_us_id AS translation_us_id_38, t27.translation_es_id AS translation_es_id_39, t27.translation_de_id AS translation_de_id_40, t27.translation_pt_id AS translation_pt_id_41, t42.download_number AS download_number_43, t42.created_at AS created_at_44, t42.start_at AS start_at_45, t42.end_at AS end_at_46, t42.ref AS ref_47, t42.first_apparition_at AS first_apparition_at_48, t42.id AS id_49, t42.category_id AS category_id_50, t42.translation_en_id AS translation_en_id_51, t42.translation_fr_id AS translation_fr_id_52, t42.translation_us_id AS translation_us_id_53, t42.translation_es_id AS translation_es_id_54, t42.translation_de_id AS translation_de_id_55, t42.translation_pt_id AS translation_pt_id_56, t57.download_number AS download_number_58, t57.created_at AS created_at_59, t57.start_at AS start_at_60, t57.end_at AS end_at_61, t57.ref AS ref_62, t57.first_apparition_at AS first_apparition_at_63, t57.id AS id_64, t57.category_id AS category_id_65, t57.translation_en_id AS translation_en_id_66, t57.translation_fr_id AS translation_fr_id_67, t57.translation_us_id AS translation_us_id_68, t57.translation_es_id AS translation_es_id_69, t57.translation_de_id AS translation_de_id_70, t57.translation_pt_id AS translation_pt_id_71, t72.download_number AS download_number_73, t72.created_at AS created_at_74, t72.start_at AS start_at_75, t72.end_at AS end_at_76, t72.ref AS ref_77, t72.first_apparition_at AS first_apparition_at_78, t72.id AS id_79, t72.category_id AS category_id_80, t72.translation_en_id AS translation_en_id_81, t72.translation_fr_id AS translation_fr_id_82, t72.translation_us_id AS translation_us_id_83, t72.translation_es_id AS translation_es_id_84, t72.translation_de_id AS translation_de_id_85, t72.translation_pt_id AS translation_pt_id_86, t87.download_number AS download_number_88, t87.created_at AS created_at_89, t87.start_at AS start_at_90, t87.end_at AS end_at_91, t87.ref AS ref_92, t87.first_apparition_at AS first_apparition_at_93, t87.id AS id_94, t87.category_id AS category_id_95, t87.translation_en_id AS translation_en_id_96, t87.translation_fr_id AS translation_fr_id_97, t87.translation_us_id AS translation_us_id_98, t87.translation_es_id AS translation_es_id_99, t87.translation_de_id AS translation_de_id_100, t87.translation_pt_id AS translation_pt_id_101 FROM document t0 LEFT JOIN document_global t12 ON t12.translation_en_id = t0.id LEFT JOIN document_global t27 ON t27.translation_fr_id = t0.id LEFT JOIN document_global t42 ON t42.translation_us_id = t0.id LEFT JOIN document_global t57 ON t57.translation_es_id = t0.id LEFT JOIN document_global t72 ON t72.translation_de_id = t0.id LEFT JOIN document_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?
Parameters:
[
179
]
|
||||||||||||||||||||||||||||||
|
0.34 ms (15.45%) |
1 |
SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = ?
Parameters:
[
"app_download_document"
]
|
||||||||||||||||||||||||||||||
|
0.30 ms (13.80%) |
1 |
SELECT t0.download_number AS download_number_1, t0.created_at AS created_at_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.ref AS ref_5, t0.first_apparition_at AS first_apparition_at_6, t0.id AS id_7, t0.category_id AS category_id_8, t0.translation_en_id AS translation_en_id_9, t0.translation_fr_id AS translation_fr_id_10, t0.translation_us_id AS translation_us_id_11, t0.translation_es_id AS translation_es_id_12, t0.translation_de_id AS translation_de_id_13, t0.translation_pt_id AS translation_pt_id_14 FROM document_global t0 WHERE t0.id = ?
Parameters:
[
"97"
]
|
||||||||||||||||||||||||||||||
|
0.22 ms (10.07%) |
1 |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.20 ms (9.12%) |
1 |
UPDATE document_global SET download_number = ? WHERE id = ?
Parameters:
[ 45 97 ]
|
||||||||||||||||||||||||||||||
|
0.11 ms (5.24%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SEOPageGlobal | No errors. |
| App\Entity\SEOPage |
|
| Cofondateur\SocleTechniqueBundle\Entity\SiteSettings | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\Investor\DocumentGlobal | No errors. |
| App\Entity\Investor\DocumentCategoryGlobal | No errors. |
| App\Entity\Investor\Document |
|