Query Metrics
7
Database Queries
6
Different statements
1.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.68 ms |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.name AS name_3, t0.code AS code_4, t0.flag AS flag_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM languages t0
Parameters:
[] |
||||||||||||||||||||||||||||
| 2 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.actif AS actif_1, p0_.alias AS alias_2, p0_.image AS image_3, p0_.image_bandeau AS image_bandeau_4, p0_.meta_title AS meta_title_5, p0_.meta_description AS meta_description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.actif = 1 AND p1_.locale = ? AND p1_.slug = ?
Parameters:
[ "fr" "d4b-portage" ]
|
||||||||||||||||||||||||||||
| 3 | 0.15 ms |
SELECT t0.id AS id_1, t0.full_path AS full_path_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.filesize AS filesize_5, t0.id_page AS id_page_6, t0.titre AS titre_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM media_file t0 WHERE t0.id_page = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
| 4 | 0.12 ms |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image AS image_3, t0.position AS position_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.post_id AS post_id_8 FROM post_bloc t0 WHERE t0.post_id = ? AND t0.actif = ? ORDER BY t0.position ASC
Parameters:
[ 10 1 ]
|
||||||||||||||||||||||||||||
| 5 | 0.12 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titre AS titre_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
| 6 | 0.13 ms |
SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_titre AS actif_titre_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.tel AS tel_6, t0.email_site AS email_site_7, t0.image AS image_8, t0.lien_carte AS lien_carte_9, t0.apercu_image_lien AS apercu_image_lien_10, t0.image_header AS image_header_11, t0.image_footer AS image_footer_12, t0.maintenance AS maintenance_13, t0.htaccess_val AS htaccess_val_14, t0.meta_index AS meta_index_15, t0.meta_follow AS meta_follow_16, t0.robots AS robots_17, t0.analytics AS analytics_18, t0.cle_key AS cle_key_19, t0.cle_secret AS cle_secret_20, t0.tag_managerhead AS tag_managerhead_21, t0.tag_managerbody AS tag_managerbody_22, t0.cle_map AS cle_map_23, t0.active_smtp AS active_smtp_24, t0.email_from AS email_from_25, t0.email_sender AS email_sender_26, t0.host_smtp AS host_smtp_27, t0.type_cryptage AS type_cryptage_28, t0.port_tls AS port_tls_29, t0.port_ssl AS port_ssl_30, t0.smtp_user AS smtp_user_31, t0.smtp_pass AS smtp_pass_32, t0.slug_url AS slug_url_33, t0.lien_facebook AS lien_facebook_34, t0.lien_google_plus AS lien_google_plus_35, t0.lien_youtube AS lien_youtube_36, t0.lien_instegram AS lien_instegram_37 FROM parametre_site t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||
| 7 | 0.12 ms |
SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_titre AS actif_titre_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.tel AS tel_6, t0.email_site AS email_site_7, t0.image AS image_8, t0.lien_carte AS lien_carte_9, t0.apercu_image_lien AS apercu_image_lien_10, t0.image_header AS image_header_11, t0.image_footer AS image_footer_12, t0.maintenance AS maintenance_13, t0.htaccess_val AS htaccess_val_14, t0.meta_index AS meta_index_15, t0.meta_follow AS meta_follow_16, t0.robots AS robots_17, t0.analytics AS analytics_18, t0.cle_key AS cle_key_19, t0.cle_secret AS cle_secret_20, t0.tag_managerhead AS tag_managerhead_21, t0.tag_managerbody AS tag_managerbody_22, t0.cle_map AS cle_map_23, t0.active_smtp AS active_smtp_24, t0.email_from AS email_from_25, t0.email_sender AS email_sender_26, t0.host_smtp AS host_smtp_27, t0.type_cryptage AS type_cryptage_28, t0.port_tls AS port_tls_29, t0.port_ssl AS port_ssl_30, t0.smtp_user AS smtp_user_31, t0.smtp_pass AS smtp_pass_32, t0.slug_url AS slug_url_33, t0.lien_facebook AS lien_facebook_34, t0.lien_google_plus AS lien_google_plus_35, t0.lien_youtube AS lien_youtube_36, t0.lien_instegram AS lien_instegram_37 FROM parametre_site t0 ORDER BY t0.id DESC LIMIT 1
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\Languages | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\PostTranslation | No errors. |
| App\Entity\PostBloc | No errors. |
| App\Entity\MediaFile | No errors. |
| App\Entity\ParametreSite | No errors. |
| App\Entity\ParametreSiteTranslation | No errors. |