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

Response
200 OK
IP
216.73.216.146
Profiled on
Token
e9061c

Query Metrics

48 Database Queries
17 Different statements
32.58 ms Query time
0 Invalid entities
190 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
8.28 ms
(25.40%) 		15 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7.85 ms
(24.09%) 		15 
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 INNER JOIN variant_attribute_value ON t0.id = variant_attribute_value.attribute_value_id WHERE variant_attribute_value.variant_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3.22 ms
(9.88%) 		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, p1_.id AS id_33, p1_.uuid AS uuid_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.sku AS sku_37, p1_.position AS position_38, p1_.price_override AS price_override_39, p1_.compare_override AS compare_override_40, p1_.short_description AS short_description_41, p1_.description AS description_42, p1_.is_deleted AS is_deleted_43, p1_.is_active AS is_active_44, p2_.id AS id_45, p2_.uuid AS uuid_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.path AS path_49, p2_.alt AS alt_50, p2_.position AS position_51, p3_.id AS id_52, p3_.uuid AS uuid_53, p3_.created_at AS created_at_54, p3_.updated_at AS updated_at_55, p3_.path AS path_56, p3_.alt AS alt_57, p3_.position AS position_58, p0_.category_id AS category_id_59, p1_.product_id AS product_id_60, p1_.main_image_id AS main_image_id_61, p2_.product_id AS product_id_62, p2_.attribute_value_id AS attribute_value_id_63, p3_.product_id AS product_id_64, p3_.attribute_value_id AS attribute_value_id_65 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_image p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p1_.main_image_id = p3_.id WHERE p0_.is_active = 1 AND p0_.is_deleted = 0 AND p0_.category_id IN (?) AND p0_.id IN (?, ?, ?, ?, ?) ORDER BY p0_.position ASC, p0_.id ASC, p1_.position ASC, p1_.id ASC, p2_.position ASC, p2_.id ASC
Parameters: 
[
  1
  1
  2
  3
  4
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
2.30 ms
(7.05%) 		1 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, p1_.id AS id_33, p1_.uuid AS uuid_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.sku AS sku_37, p1_.position AS position_38, p1_.price_override AS price_override_39, p1_.compare_override AS compare_override_40, p1_.short_description AS short_description_41, p1_.description AS description_42, p1_.is_deleted AS is_deleted_43, p1_.is_active AS is_active_44, p2_.id AS id_45, p2_.uuid AS uuid_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.path AS path_49, p2_.alt AS alt_50, p2_.position AS position_51, p3_.id AS id_52, p3_.uuid AS uuid_53, p3_.created_at AS created_at_54, p3_.updated_at AS updated_at_55, p3_.path AS path_56, p3_.alt AS alt_57, p3_.position AS position_58 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_image p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p1_.main_image_id = p3_.id WHERE p0_.is_active = 1 AND p0_.is_deleted = 0 AND p0_.category_id IN (?) ORDER BY p0_.position ASC, p0_.id ASC, p1_.position ASC, p1_.id ASC, p2_.position ASC, p2_.id ASC) dctrn_result) dctrn_table
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2.05 ms
(6.29%) 		4 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.72 ms
(5.29%) 		1 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_13 FROM (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, p1_.id AS id_33, p1_.uuid AS uuid_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.sku AS sku_37, p1_.position AS position_38, p1_.price_override AS price_override_39, p1_.compare_override AS compare_override_40, p1_.short_description AS short_description_41, p1_.description AS description_42, p1_.is_deleted AS is_deleted_43, p1_.is_active AS is_active_44, p2_.id AS id_45, p2_.uuid AS uuid_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.path AS path_49, p2_.alt AS alt_50, p2_.position AS position_51, p3_.id AS id_52, p3_.uuid AS uuid_53, p3_.created_at AS created_at_54, p3_.updated_at AS updated_at_55, p3_.path AS path_56, p3_.alt AS alt_57, p3_.position AS position_58 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_image p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p1_.main_image_id = p3_.id WHERE p0_.is_active = 1 AND p0_.is_deleted = 0 AND p0_.category_id IN (?) ORDER BY p1_.position ASC, p1_.id ASC, p2_.position ASC, p2_.id ASC) dctrn_result_inner ORDER BY position_13 ASC, id_0 ASC) dctrn_result LIMIT 50
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.09 ms
(3.35%) 		1 
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.slug = ? AND t0.is_active = ? LIMIT 1
Parameters: 
[
  "nos-planches"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(3.06%) 		1 
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.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(2.43%) 		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_.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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(2.21%) 		1 
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.route_name AS route_name_5, t0.page_label AS page_label_6, t0.page_category AS page_category_7, t0.title AS title_8, t0.meta_description AS meta_description_9, t0.canonical_url AS canonical_url_10, t0.robots AS robots_11, t0.og_title AS og_title_12, t0.og_description AS og_description_13, t0.og_image_url AS og_image_url_14, t0.og_image_alt AS og_image_alt_15, t0.og_type AS og_type_16, t0.og_locale AS og_locale_17, t0.og_url AS og_url_18, t0.tw_card AS tw_card_19, t0.tw_title AS tw_title_20, t0.tw_description AS tw_description_21, t0.tw_image_url AS tw_image_url_22, t0.tw_site AS tw_site_23, t0.sitemap_include AS sitemap_include_24, t0.sitemap_priority AS sitemap_priority_25, t0.sitemap_changefreq AS sitemap_changefreq_26, t0.sitemap_lastmod AS sitemap_lastmod_27 FROM page_seo t0 WHERE t0.route_name = ? LIMIT 1
Parameters: 
[
  "app_planches"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(2.11%) 		1 
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.is_active = 1 AND p0_.is_deleted = 0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(1.89%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.49%) 		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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.41%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.39%) 		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_.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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(1.35%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(1.30%) 		1 
SELECT COUNT(*) FROM contact_message t0 WHERE t0.is_read = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query    View query backtrace

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 137
App\Entity\ProductVariant 15
App\Entity\Cookie 12
App\Entity\ActivityLog 5
App\Entity\Product 5
App\Entity\CookieCategory 4
App\Entity\Category 3
App\Entity\AttributeValue 3
App\Entity\SocialNetwork 2
App\Entity\SiteParameter 1
App\Entity\SiteIntegration 1
App\Entity\PageSeo 1
App\Entity\Attribute 1

Entities Mapping

Class Mapping errors
App\Entity\AbstractEntity No errors.
App\Entity\SiteParameter No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\ProductVariant No errors.
App\Entity\ProductImage 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.
App\Entity\PageSeo No errors.
App\Entity\AttributeValue No errors.
App\Entity\Attribute No errors.
App\Entity\Ingredient No errors.