https://cms-oscar-v0.hrz.fr/carport-en-bois-narbonne

Query Metrics

9 Database Queries
6 Different statements
9.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.
App\Entity\ListeMenu No errors.
App\Entity\TextParametrable No errors.
App\Entity\Email No errors.
App\Entity\Media No errors.
App\Entity\ReseauSociaux No errors.
App\Entity\ModulesCookies No errors.
App\Entity\PostAffichage No errors.
App\Entity\Category No errors.
App\Entity\Widget No errors.
App\Entity\PostCategory No errors.
App\Entity\Menu No errors.
App\Entity\CpPostField No errors.
App\Entity\PostBloc No errors.
App\Entity\ProduitsInfo No errors.
App\Entity\ExportTraductions No errors.
App\Entity\ParametrePost No errors.
App\Entity\TypePostTranslation No errors.