Symfony Profiler

Query Metrics

25 Database Queries
15 Different statements
12.69 ms Query time
0 Invalid entities
77 Managed entities
Queries


SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.site_name AS site_name_4, s0_.address AS address_5, s0_.address_complement AS address_complement_6, s0_.postal_code AS postal_code_7, s0_.city AS city_8, s0_.country AS country_9, s0_.google_maps_embed_url AS google_maps_embed_url_10, s0_.contact_email AS contact_email_11, s0_.email_contact_gmail AS email_contact_gmail_12, s0_.phone AS phone_13, s0_.website AS website_14, s0_.siret AS siret_15, s0_.sku_company_code AS sku_company_code_16, s0_.logo AS logo_17, s0_.favicon AS favicon_18, s0_.tagline AS tagline_19, s0_.password_change_ttl AS password_change_ttl_20, s0_.email_change_ttl AS email_change_ttl_21, s0_.reset_password_token_ttl AS reset_password_token_ttl_22, s0_.verification_token_ttl AS verification_token_ttl_23, s0_.maintenance_mode AS maintenance_mode_24, s0_.registration_enabled AS registration_enabled_25, s0_.forgot_password_enabled AS forgot_password_enabled_26, s0_.idle_logout_enabled AS idle_logout_enabled_27, s0_.idle_logout_ttl AS idle_logout_ttl_28, s0_.social_networks_enabled AS social_networks_enabled_29, s0_.monday_hours AS monday_hours_30, s0_.tuesday_hours AS tuesday_hours_31, s0_.wednesday_hours AS wednesday_hours_32, s0_.thursday_hours AS thursday_hours_33, s0_.friday_hours AS friday_hours_34, s0_.saturday_hours AS saturday_hours_35, s0_.sunday_hours AS sunday_hours_36, s0_.max_shipping_addresses AS max_shipping_addresses_37, s0_.catalog_page_size AS catalog_page_size_38, s0_.cart_max_items AS cart_max_items_39, s0_.product_images_limit AS product_images_limit_40, s0_.delivery_cutoff_time AS delivery_cutoff_time_41, s0_.click_collect_lead_hours AS click_collect_lead_hours_42, s0_.delivery_max_per_slot AS delivery_max_per_slot_43, s0_.delivery_max_per_day AS delivery_max_per_day_44, s0_.click_collect_max_per_slot AS click_collect_max_per_slot_45, s0_.click_collect_max_per_day AS click_collect_max_per_day_46, s0_.delivery_enabled_weekdays AS delivery_enabled_weekdays_47, s0_.click_collect_enabled_weekdays AS click_collect_enabled_weekdays_48, s0_.delivery_calendar_weeks AS delivery_calendar_weeks_49, s0_.click_collect_same_day_confirm_required AS click_collect_same_day_confirm_required_50, s0_.twitter_handle AS twitter_handle_51, s0_.cookie_consent_enabled AS cookie_consent_enabled_52, s0_.cookie_banner_title AS cookie_banner_title_53, s0_.cookie_banner_text AS cookie_banner_text_54, s0_.cookie_banner_position AS cookie_banner_position_55, s0_.cookie_banner_show_refuse AS cookie_banner_show_refuse_56 FROM site_parameter s0_ LIMIT 1
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.code AS code_6, p0_.price AS price_7, p0_.compare_price AS compare_price_8, p0_.short_description AS short_description_9, p0_.description AS description_10, p0_.is_active AS is_active_11, p0_.is_deleted AS is_deleted_12, p0_.position AS position_13, p0_.is_featured AS is_featured_14, p0_.seo_title AS seo_title_15, p0_.seo_meta_description AS seo_meta_description_16, p0_.seo_canonical_url AS seo_canonical_url_17, p0_.seo_robots AS seo_robots_18, p0_.seo_og_title AS seo_og_title_19, p0_.seo_og_description AS seo_og_description_20, p0_.seo_og_image_url AS seo_og_image_url_21, p0_.seo_og_image_alt AS seo_og_image_alt_22, p0_.seo_og_type AS seo_og_type_23, p0_.seo_og_locale AS seo_og_locale_24, p0_.seo_tw_card AS seo_tw_card_25, p0_.seo_tw_title AS seo_tw_title_26, p0_.seo_tw_description AS seo_tw_description_27, p0_.seo_tw_image_url AS seo_tw_image_url_28, p0_.seo_tw_site AS seo_tw_site_29, p0_.seo_sitemap_include AS seo_sitemap_include_30, p0_.seo_sitemap_priority AS seo_sitemap_priority_31, p0_.seo_sitemap_changefreq AS seo_sitemap_changefreq_32, p0_.category_id AS category_id_33 FROM product p0_ WHERE p0_.slug = ? AND p0_.is_active = 1 AND p0_.is_deleted = 0
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.slug AS slug_6, t0.type AS type_7, t0.code AS code_8, t0.image AS image_9, t0.is_active AS is_active_10, t0.position AS position_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.public_name AS public_name_6, t0.code AS code_7, t0.is_visual AS is_visual_8 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.value AS value_5, t0.name AS name_6, t0.code AS code_7, t0.position AS position_8, t0.attribute_id AS attribute_id_9 FROM attribute_value t0 WHERE t0.attribute_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.is_allergen AS is_allergen_6, t0.position AS position_7, t0.variant_id AS variant_id_8 FROM ingredient t0 WHERE t0.variant_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.is_allergen AS is_allergen_6, t0.position AS position_7, t0.variant_id AS variant_id_8 FROM ingredient t0 WHERE t0.variant_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.is_allergen AS is_allergen_6, t0.position AS position_7, t0.variant_id AS variant_id_8 FROM ingredient t0 WHERE t0.variant_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.sku AS sku_4, p0_.position AS position_5, p0_.price_override AS price_override_6, p0_.compare_override AS compare_override_7, p0_.short_description AS short_description_8, p0_.description AS description_9, p0_.is_deleted AS is_deleted_10, p0_.is_active AS is_active_11, a1_.id AS id_12, a1_.uuid AS uuid_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.value AS value_16, a1_.name AS name_17, a1_.code AS code_18, a1_.position AS position_19, a2_.id AS id_20, a2_.uuid AS uuid_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.name AS name_24, a2_.public_name AS public_name_25, a2_.code AS code_26, a2_.is_visual AS is_visual_27, p0_.product_id AS product_id_28, p0_.main_image_id AS main_image_id_29, a1_.attribute_id AS attribute_id_30 FROM product_variant p0_ LEFT JOIN variant_attribute_value v3_ ON p0_.id = v3_.variant_id LEFT JOIN attribute_value a1_ ON a1_.id = v3_.attribute_value_id LEFT JOIN attribute a2_ ON a1_.attribute_id = a2_.id WHERE p0_.product_id = ? AND p0_.is_deleted = 0 ORDER BY p0_.id ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.path AS path_5, t0.alt AS alt_6, t0.position AS position_7, t0.product_id AS product_id_8, t0.attribute_value_id AS attribute_value_id_9 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.mailer_dsn AS mailer_dsn_4, s0_.mailer_sender_email AS mailer_sender_email_5, s0_.mailer_sender_name AS mailer_sender_name_6, s0_.google_auth_enabled AS google_auth_enabled_7, s0_.google_client_id AS google_client_id_8, s0_.google_client_secret AS google_client_secret_9, s0_.mypos_enabled AS mypos_enabled_10, s0_.mypos_configuration_package AS mypos_configuration_package_11, s0_.mypos_ipc_url AS mypos_ipc_url_12, s0_.mypos_test_mode AS mypos_test_mode_13 FROM site_integration s0_ LIMIT 1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.title AS title_4, s0_.icon AS icon_5, s0_.url AS url_6, s0_.position AS position_7, s0_.is_active AS is_active_8 FROM social_network s0_ WHERE s0_.is_active = 1 ORDER BY s0_.position ASC
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.title AS title_4, c0_.slug AS slug_5, c0_.type AS type_6, c0_.code AS code_7, c0_.image AS image_8, c0_.is_active AS is_active_9, c0_.position AS position_10, c0_.parent_id AS parent_id_11 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1 ORDER BY c0_.position ASC, c0_.id ASC
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.name AS name_4, c0_.slug AS slug_5, c0_.description AS description_6, c0_.is_required AS is_required_7, c0_.is_enabled AS is_enabled_8, c0_.display_order AS display_order_9 FROM cookie_category c0_ WHERE c0_.is_enabled = 1 ORDER BY c0_.display_order ASC
SELECT COUNT(*) FROM contact_message t0 WHERE t0.is_read = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.action AS action_3, t0.category AS category_4, t0.description AS description_5, t0.performed_by AS performed_by_6, t0.created_at AS created_at_7 FROM activity_log t0 ORDER BY t0.created_at DESC LIMIT 5
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.provider AS provider_6, t0.purpose AS purpose_7, t0.duration AS duration_8, t0.duration_seconds AS duration_seconds_9, t0.cookie_type AS cookie_type_10, t0.is_active AS is_active_11, t0.position AS position_12, t0.category_id AS category_id_13 FROM cookie t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.provider AS provider_6, t0.purpose AS purpose_7, t0.duration AS duration_8, t0.duration_seconds AS duration_seconds_9, t0.cookie_type AS cookie_type_10, t0.is_active AS is_active_11, t0.position AS position_12, t0.category_id AS category_id_13 FROM cookie t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.provider AS provider_6, t0.purpose AS purpose_7, t0.duration AS duration_8, t0.duration_seconds AS duration_seconds_9, t0.cookie_type AS cookie_type_10, t0.is_active AS is_active_11, t0.position AS position_12, t0.category_id AS category_id_13 FROM cookie t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.provider AS provider_6, t0.purpose AS purpose_7, t0.duration AS duration_8, t0.duration_seconds AS duration_seconds_9, t0.cookie_type AS cookie_type_10, t0.is_active AS is_active_11, t0.position AS position_12, t0.category_id AS category_id_13 FROM cookie t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
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\Ingredient	41
App\Entity\Cookie	12
App\Entity\ActivityLog	5
App\Entity\CookieCategory	4
App\Entity\Category	3
App\Entity\ProductVariant	3
App\Entity\AttributeValue	3
App\Entity\SocialNetwork	2
App\Entity\SiteParameter	1
App\Entity\Product	1
App\Entity\Attribute	1
App\Entity\SiteIntegration	1
Entities Mapping

Class	Mapping errors
App\Entity\AbstractEntity	No errors.
App\Entity\SiteParameter	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\ProductVariant	No errors.
App\Entity\Attribute	No errors.
App\Entity\ProductImage	No errors.
App\Entity\AttributeValue	No errors.
App\Entity\Ingredient	No errors.
App\Entity\SiteIntegration	No errors.
App\Entity\SocialNetwork	No errors.
App\Entity\CookieCategory	No errors.
App\Entity\Cookie	No errors.
App\Entity\ContactMessage	No errors.
App\Entity\ActivityLog	No errors.
Symfony Profiler

GET https://aperitiu.vultek.fr/nos-planches/tropel/l

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
