GET https://pepouzin2.devlogiciel.com/mentions-legales

Query Metrics

16 Database Queries
10 Different statements
13.55 ms Query time
0 Invalid entities
64 Managed entities

Queries

Group similar statements

# Time Info
1 2.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "pepouzin2.devlogiciel.com"
]
2 1.49 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = ? AND (d1_.url = ? OR d1_.url = ?)
Parameters:
[
  "pepouzin2"
  "devlogiciel.com"
  ".devlogiciel.com"
]
3 0.86 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  6
  "mentions-legales"
]
4 0.70 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.is_synced AS is_synced_4, t0.page_id AS page_id_5, t0.bloc_id AS bloc_id_6 FROM page_bloc t0 WHERE t0.page_id = ?
Parameters:
[
  23
]
5 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?
Parameters:
[
  114
]
6 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC
Parameters:
[
  114
]
7 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?
Parameters:
[
  69
]
8 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC
Parameters:
[
  69
]
9 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?
Parameters:
[
  70
]
10 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC
Parameters:
[
  70
]
11 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.favicon AS favicon_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.deleted AS deleted_13, t0.owner_id AS owner_id_14, t0.category_id AS category_id_15 FROM site t0 WHERE t0.id = ?
Parameters:
[
  6
]
12 0.98 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.is_subscription_active AS is_subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.subscription_end_date AS subscription_end_date_14, t0.pricing_plan_id AS pricing_plan_id_15 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 1.22 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postale AS code_postale_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.owner_id = ? AND t0.dtype IN ('user_info', 'entreprise', 'autre')
Parameters:
[
  1
]
14 0.69 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC
Parameters:
[
  347
]
15 0.52 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC
Parameters:
[
  144
]
16 0.60 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC
Parameters:
[
  145
]

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\Field 26
App\Entity\PageBlocValue 26
App\Entity\PageBloc 3
App\Entity\Bloc 3
App\Entity\SubDomain 1
App\Entity\Domaine 1
App\Entity\Site 1
App\Entity\User 1
App\Entity\Page 1
App\Entity\UserInformation 1

Entities Mapping

Class Mapping errors
App\Entity\Domaine No errors.
App\Entity\UserInformation No errors.
App\Entity\User No errors.
App\Entity\EntrepriseUserInfo No errors.
App\Entity\AutreUserInfo No errors.
App\Entity\SubDomain No errors.
App\Entity\Site No errors.
App\Entity\Page No errors.
App\Entity\PageBloc No errors.
App\Entity\Bloc No errors.
App\Entity\PageBlocValue No errors.
App\Entity\Field No errors.
App\Entity\FieldOption No errors.
App\Entity\SiteCategory No errors.
App\Entity\NewsletterSubscription No errors.
App\Entity\Newsletter No errors.
App\Entity\Employee No errors.
App\Entity\AppointmentType No errors.
App\Entity\PricingPlan No errors.
App\Entity\AvisUtilisateurs No errors.
App\Entity\Ticket No errors.
App\Entity\NewsletterLog No errors.
App\Entity\Appointment No errors.
App\Entity\PlanFeature No errors.
App\Entity\PromoCode No errors.
App\Entity\TicketReply No errors.
App\Entity\UserPurchasedService No errors.
App\Entity\Functionality No errors.
App\Entity\BoutiqueServiceItem No errors.
App\Entity\Commande No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\CategorieJuridique No errors.
App\Entity\PaymentLog No errors.
App\Entity\Absence No errors.
App\Entity\Contact No errors.
App\Entity\CommandeItem No errors.
App\Entity\Tag No errors.
App\Entity\CommandeFeature No errors.
App\Entity\BoutiqueServiceCategory No errors.
App\Entity\WorkingHour No errors.
App\Entity\BlocSyncLog No errors.
Zhortein\SeoTrackingBundle\Entity\PageCall No errors.
Zhortein\SeoTrackingBundle\Entity\PageCallHit No errors.
Vich\UploaderBundle\Entity\File No errors.