http://www.enseigne-pelletier.asb-digital.fr/

Query Metrics

17 Database Queries
9 Different statements
9.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.45 ms
(25.87%)
7
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.product_name AS product_name_4, t0.product_size AS product_size_5, t0.product_file_updated_at AS product_file_updated_at_6, t0.display AS display_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.position AS position_10, t0.slug AS slug_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
1.98 ms
(20.88%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.intro AS intro_4, t0.sub_title_detail AS sub_title_detail_5, t0.description AS description_6, t0.category_name AS category_name_7, t0.category_size AS category_size_8, t0.category_file_updated_at AS category_file_updated_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.position AS position_12, t0.slug AS slug_13 FROM category t0
Parameters:
[]
1.01 ms
(10.69%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3 FROM homepage t0
Parameters:
[]
0.92 ms
(9.67%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.resume AS resume_2, p0_.post_name AS post_name_3, p0_.post_size AS post_size_4, p0_.post_file_updated_at AS post_file_updated_at_5, p0_.intro AS intro_6, p0_.promote AS promote_7, p0_.date AS date_8, p0_.meta_title AS meta_title_9, p0_.meta_description AS meta_description_10, p0_.slug AS slug_11 FROM post p0_ WHERE p0_.promote = ? ORDER BY p0_.date DESC LIMIT 2
Parameters:
[
  1
]
0.80 ms
(8.47%)
1
SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "app_homepage"
]
0.69 ms
(7.30%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.resume AS resume_3, t0.cover_name AS cover_name_4, t0.cover_size AS cover_size_5, t0.cover_updated_at AS cover_updated_at_6, t0.cover_alt AS cover_alt_7, t0.cta_link AS cta_link_8, t0.homepage_id AS homepage_id_9 FROM homepage_diapo t0 WHERE t0.homepage_id = ?
Parameters:
[
  1
]
0.62 ms
(6.48%)
1
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.partner_name AS partner_name_3, t0.partner_size AS partner_size_4, t0.partner_file_updated_at AS partner_file_updated_at_5, t0.position AS position_6 FROM partner t0
Parameters:
[]
0.61 ms
(6.42%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_hp AS title_hp_3, t0.display_homepage AS display_homepage_4, t0.icon_name AS icon_name_5, t0.icon_size AS icon_size_6, t0.icon_updated_at AS icon_updated_at_7, t0.icon_alt AS icon_alt_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.slug AS slug_11 FROM landing_page t0 WHERE t0.display_homepage = ?
Parameters:
[
  1
]
0.40 ms
(4.23%)
1
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:
[]

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
Cofondateur\SocleTechniqueBundle\Entity\SEOPage No errors.
App\Entity\SEOPage No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings No errors.
App\Entity\SiteSettings No errors.
App\Entity\Homepage No errors.
App\Entity\Post No errors.
App\Entity\LandingPage No errors.
App\Entity\HomepageDiapo No errors.
App\Entity\Paragraph No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Achievement No errors.
App\Entity\Partner No errors.