Query Metrics
9
Database Queries
6
Different statements
9.47 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.02 ms (31.84%) |
1 |
SELECT p0_.id AS id_0, p0_.oscar_rocket AS oscar_rocket_1, p0_.id_oscar_rocket AS id_oscar_rocket_2, p0_.alias AS alias_3, p0_.position AS position_4, p0_.authorization_api AS authorization_api_5, p0_.actif_home AS actif_home_6, p0_.post_archive AS post_archive_7, p0_.date_archive AS date_archive_8, p0_.image AS image_9, p0_.url_video AS url_video_10, p0_.image_bandeau AS image_bandeau_11, p0_.image_bandeau_height AS image_bandeau_height_12, p0_.image_couverture AS image_couverture_13, p0_.tag_managerhead AS tag_managerhead_14, p0_.tag_managerbody AS tag_managerbody_15, p0_.default_categorie AS default_categorie_16, p0_.date_publication AS date_publication_17, p0_.date_import AS date_import_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.date_update_ref AS date_update_ref_21, p0_.id_activite AS id_activite_22, p0_.id_sous_activite AS id_sous_activite_23, p0_.id_secteur AS id_secteur_24, p0_.type_page_ref AS type_page_ref_25, p0_.disponibilite_produit AS disponibilite_produit_26, p0_.prix_produit AS prix_produit_27, p0_.referance_produit AS referance_produit_28, p0_.position_image AS position_image_29, p0_.id_import_categorie_old AS id_import_categorie_old_30, p0_.old_id_import AS old_id_import_31, p0_.module_import AS module_import_32, p0_.posts_associes AS posts_associes_33, p0_.posts_associes_autres_types AS posts_associes_autres_types_34, p0_.data_module_biens AS data_module_biens_35, p0_.tags AS tags_36, p0_.custom_style AS custom_style_37, p0_.author_id AS author_id_38, p0_.type_post AS type_post_39, p0_.template_cms_id AS template_cms_id_40, p0_.modele_gallerie_id AS modele_gallerie_id_41 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND (p0_.date_publication IS NULL OR p0_.date_publication <= ?) AND p1_.slug = ?
Parameters:
[ "fr" "2024-09-19 00:32:26" "carport-en-bois-narbonne" ] |
2.12 ms (22.34%) |
2 |
SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/carport-en-bois-narbonne" 1 ] |
1.43 ms (15.04%) |
2 |
SELECT t0.id AS id_1, t0.actif_replace_mot_cle AS actif_replace_mot_cle_2, t0.actif_bar_serach AS actif_bar_serach_3, t0.actif_oscar AS actif_oscar_4, t0.actif_data_hrz AS actif_data_hrz_5, t0.actif_titre AS actif_titre_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.image_bandeau AS image_bandeau_13, t0.tel AS tel_14, t0.image_vide AS image_vide_15, t0.maintenance AS maintenance_16, t0.htaccess_val AS htaccess_val_17, t0.meta_index AS meta_index_18, t0.meta_follow AS meta_follow_19, t0.robots AS robots_20, t0.analytics AS analytics_21, t0.cle_key AS cle_key_22, t0.cle_secret AS cle_secret_23, t0.tag_managerhead AS tag_managerhead_24, t0.meta_keywords AS meta_keywords_25, t0.cle_map AS cle_map_26, t0.active_smtp AS active_smtp_27, t0.email_from AS email_from_28, t0.email_sender AS email_sender_29, t0.host_smtp AS host_smtp_30, t0.type_cryptage AS type_cryptage_31, t0.port_tls AS port_tls_32, t0.port_ssl AS port_ssl_33, t0.smtp_user AS smtp_user_34, t0.smtp_pass AS smtp_pass_35, t0.typeLienErrorPage AS typeLienErrorPage_36, t0.lienExterneErrorPage AS lienExterneErrorPage_37, t0.telephoneErrorPage AS telephoneErrorPage_38, t0.domain_api_hrz AS domain_api_hrz_39, t0.token_api_hrz AS token_api_hrz_40, t0.actif_auth_gmail AS actif_auth_gmail_41, t0.id_client_auth AS id_client_auth_42, t0.secret_client_auth AS secret_client_auth_43, t0.id_matomo AS id_matomo_44, t0.code_head AS code_head_45, t0.code_body AS code_body_46, t0.google_verification AS google_verification_47, t0.type_recaptcha AS type_recaptcha_48, t0.actif_whatsapp AS actif_whatsapp_49, t0.tel_whatsapp AS tel_whatsapp_50, t0.header_color_whatsapp AS header_color_whatsapp_51, t0.generation_static_header_footer AS generation_static_header_footer_52, t0.IdSite AS IdSite_53 FROM parametre_site t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
1.40 ms (14.73%) |
2 |
SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = ? AND u1_.locale = ? LIMIT 1
Parameters:
[ "carport-en-bois-narbonne" "fr" ] |
1.06 ms (11.22%) |
1 |
SELECT l0_.id AS id_0, l0_.active AS active_1, l0_.name AS name_2, l0_.language_code AS language_code_3, l0_.flag AS flag_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6 FROM language l0_ WHERE l0_.active = 1 ORDER BY l0_.id ASC
Parameters:
[] |
0.46 ms (4.82%) |
1 |
SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1
Parameters:
[
"carport-en-bois-narbonne"
]
|
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\User | No errors. |
App\Entity\ParametreSite | No errors. |
App\Entity\Site | No errors. |
App\Entity\ParametreSiteTranslation | No errors. |
App\Entity\Redirection | No errors. |
App\Entity\UrlPost | No errors. |
App\Entity\Language | No errors. |
App\Entity\UrlPostTranslation | No errors. |
App\Entity\Post | No errors. |
App\Entity\PostTranslation | No errors. |
App\Entity\TypePost | No errors. |
App\Entity\CmsAffichage | No errors. |
App\Entity\ModelGallerie | No errors. |