Query Metrics
15
Database Queries
9
Different statements
9.22 ms
Query time
3
Invalid entities
20
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.54 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.27 ms |
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 FROM seopage_global s0_ WHERE s0_.route = ?
Parameters:
[
"admin"
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.34 ms |
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:
[]
|
||||||||||||||||||||||||||||||||
| 4 | 0.52 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product_global p0_ ORDER BY p0_.id DESC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 5 | 0.59 ms |
SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.id IN (?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[ 6 5 4 3 2 ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.43 ms |
SELECT count(p0_.id) AS sclr_0 FROM product_global p0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 7 | 0.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.43 ms |
SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||||
| 10 | 1.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||
| 13 | 0.37 ms |
SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 14 | 0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
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\Product\Product | 7 |
| App\Entity\Product\ProductGlobal | 5 |
| App\Entity\Product\ProductCategory | 4 |
| App\Entity\Product\ProductCategoryGlobal | 2 |
| App\Entity\User | 1 |
| App\Entity\SiteSettings | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Cofondateur\SocleTechniqueBundle\Entity\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SEOPageGlobal | No errors. |
| App\Entity\SEOPage |
|
| Cofondateur\SocleTechniqueBundle\Entity\SiteSettings | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\Product\ProductGlobal | No errors. |
| App\Entity\Product\ProductCategoryGlobal | No errors. |
| App\Entity\Product\Product |
|
| App\Entity\Technology\TechnologyGlobal | No errors. |
| App\Entity\Product\ProductAttribute | No errors. |
| App\Entity\Paragraph | No errors. |
| App\Entity\Advantage | No errors. |
| App\Entity\TestimonialGlobal | No errors. |
| App\Entity\Product\ProductMedia | No errors. |
| App\Entity\Product\ProductDataTable | No errors. |
| App\Entity\DocumentGlobal | No errors. |
| App\Entity\Product\ProductCategory |
|