Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.95 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
0.72 ms (75.43%)	1	SELECT t0.id AS id_1, t0.user_old_id AS user_old_id_2, t0.recette_id AS recette_id_3, t0.hits AS hits_4, t0.image_url AS image_url_5, t0.name AS name_6, t0.slug AS slug_7, t0.user_name AS user_name_8, t0.user_email AS user_email_9, t0.web_site AS web_site_10, t0.country AS country_11, t0.recipe_type AS recipe_type_12, t0.number_of_persons AS number_of_persons_13, t0.total_time AS total_time_14, t0.cooking AS cooking_15, t0.marinade AS marinade_16, t0.level_name AS level_name_17, t0.pricing AS pricing_18, t0.dedicace AS dedicace_19, t0.pref AS pref_20, t0.published_at AS published_at_21, t0.last_updated AS last_updated_22, t0.ip AS ip_23, t0.pe AS pe_24, t0.regime AS regime_25, t0.is_active AS is_active_26, t0.description AS description_27, t0.country_code AS country_code_28, t0.suggestions AS suggestions_29, t0.is_tutorial AS is_tutorial_30, t0.video_url AS video_url_31, t0.ingredient_text AS ingredient_text_32, t0.ustensil_text AS ustensil_text_33, t0.has_multiple_step AS has_multiple_step_34, t0.is_spotlight AS is_spotlight_35, t0.preparation_instructions AS preparation_instructions_36, t0.spot_light_end AS spot_light_end_37, t0.spot_light_start AS spot_light_start_38, t0.is_spot_light_abj AS is_spot_light_abj_39, t0.end_abj_date AS end_abj_date_40, t0.start_abj_date AS start_abj_date_41, t0.origin_country AS origin_country_42, t0.origin_plateform AS origin_plateform_43, t0.preparation_instructions_text AS preparation_instructions_text_44, t0.source AS source_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.base64_code AS base64_code_48, t0.recipe_type_id AS recipe_type_id_49, t0.level_id AS level_id_50, t0.budget_id AS budget_id_51, t0.user_id AS user_id_52 FROM recipe t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"delice-de-spaguetti-4-8"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.user_old_id AS user_old_id_2, t0.recette_id AS recette_id_3, t0.hits AS hits_4, t0.image_url AS image_url_5, t0.name AS name_6, t0.slug AS slug_7, t0.user_name AS user_name_8, t0.user_email AS user_email_9, t0.web_site AS web_site_10, t0.country AS country_11, t0.recipe_type AS recipe_type_12, t0.number_of_persons AS number_of_persons_13, t0.total_time AS total_time_14, t0.cooking AS cooking_15, t0.marinade AS marinade_16, t0.level_name AS level_name_17, t0.pricing AS pricing_18, t0.dedicace AS dedicace_19, t0.pref AS pref_20, t0.published_at AS published_at_21, t0.last_updated AS last_updated_22, t0.ip AS ip_23, t0.pe AS pe_24, t0.regime AS regime_25, t0.is_active AS is_active_26, t0.description AS description_27, t0.country_code AS country_code_28, t0.suggestions AS suggestions_29, t0.is_tutorial AS is_tutorial_30, t0.video_url AS video_url_31, t0.ingredient_text AS ingredient_text_32, t0.ustensil_text AS ustensil_text_33, t0.has_multiple_step AS has_multiple_step_34, t0.is_spotlight AS is_spotlight_35, t0.preparation_instructions AS preparation_instructions_36, t0.spot_light_end AS spot_light_end_37, t0.spot_light_start AS spot_light_start_38, t0.is_spot_light_abj AS is_spot_light_abj_39, t0.end_abj_date AS end_abj_date_40, t0.start_abj_date AS start_abj_date_41, t0.origin_country AS origin_country_42, t0.origin_plateform AS origin_plateform_43, t0.preparation_instructions_text AS preparation_instructions_text_44, t0.source AS source_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.base64_code AS base64_code_48, t0.recipe_type_id AS recipe_type_id_49, t0.level_id AS level_id_50, t0.budget_id AS budget_id_51, t0.user_id AS user_id_52 FROM recipe t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.user_old_id AS user_old_id_2, t0.recette_id AS recette_id_3, t0.hits AS hits_4, t0.image_url AS image_url_5, t0.name AS name_6, t0.slug AS slug_7, t0.user_name AS user_name_8, t0.user_email AS user_email_9, t0.web_site AS web_site_10, t0.country AS country_11, t0.recipe_type AS recipe_type_12, t0.number_of_persons AS number_of_persons_13, t0.total_time AS total_time_14, t0.cooking AS cooking_15, t0.marinade AS marinade_16, t0.level_name AS level_name_17, t0.pricing AS pricing_18, t0.dedicace AS dedicace_19, t0.pref AS pref_20, t0.published_at AS published_at_21, t0.last_updated AS last_updated_22, t0.ip AS ip_23, t0.pe AS pe_24, t0.regime AS regime_25, t0.is_active AS is_active_26, t0.description AS description_27, t0.country_code AS country_code_28, t0.suggestions AS suggestions_29, t0.is_tutorial AS is_tutorial_30, t0.video_url AS video_url_31, t0.ingredient_text AS ingredient_text_32, t0.ustensil_text AS ustensil_text_33, t0.has_multiple_step AS has_multiple_step_34, t0.is_spotlight AS is_spotlight_35, t0.preparation_instructions AS preparation_instructions_36, t0.spot_light_end AS spot_light_end_37, t0.spot_light_start AS spot_light_start_38, t0.is_spot_light_abj AS is_spot_light_abj_39, t0.end_abj_date AS end_abj_date_40, t0.start_abj_date AS start_abj_date_41, t0.origin_country AS origin_country_42, t0.origin_plateform AS origin_plateform_43, t0.preparation_instructions_text AS preparation_instructions_text_44, t0.source AS source_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.base64_code AS base64_code_48, t0.recipe_type_id AS recipe_type_id_49, t0.level_id AS level_id_50, t0.budget_id AS budget_id_51, t0.user_id AS user_id_52 FROM recipe t0 WHERE t0.slug = 'delice-de-spaguetti-4-8' LIMIT 1;
0.23 ms (24.57%)	1	SELECT t0.id AS id_1, t0.number_of_start AS number_of_start_2 FROM rate t0 INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id WHERE rate_recipe.recipe_id = ? Parameters: [`165`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.number_of_start AS number_of_start_2 FROM rate t0 INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id WHERE rate_recipe.recipe_id = ? SELECT t0.id AS id_1, t0.number_of_start AS number_of_start_2 FROM rate t0 INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id WHERE rate_recipe.recipe_id = 165;

Time▼

Count

Info

0.72 ms
(75.43%)

SELECT t0.id AS id_1, t0.user_old_id AS user_old_id_2, t0.recette_id AS recette_id_3, t0.hits AS hits_4, t0.image_url AS image_url_5, t0.name AS name_6, t0.slug AS slug_7, t0.user_name AS user_name_8, t0.user_email AS user_email_9, t0.web_site AS web_site_10, t0.country AS country_11, t0.recipe_type AS recipe_type_12, t0.number_of_persons AS number_of_persons_13, t0.total_time AS total_time_14, t0.cooking AS cooking_15, t0.marinade AS marinade_16, t0.level_name AS level_name_17, t0.pricing AS pricing_18, t0.dedicace AS dedicace_19, t0.pref AS pref_20, t0.published_at AS published_at_21, t0.last_updated AS last_updated_22, t0.ip AS ip_23, t0.pe AS pe_24, t0.regime AS regime_25, t0.is_active AS is_active_26, t0.description AS description_27, t0.country_code AS country_code_28, t0.suggestions AS suggestions_29, t0.is_tutorial AS is_tutorial_30, t0.video_url AS video_url_31, t0.ingredient_text AS ingredient_text_32, t0.ustensil_text AS ustensil_text_33, t0.has_multiple_step AS has_multiple_step_34, t0.is_spotlight AS is_spotlight_35, t0.preparation_instructions AS preparation_instructions_36, t0.spot_light_end AS spot_light_end_37, t0.spot_light_start AS spot_light_start_38, t0.is_spot_light_abj AS is_spot_light_abj_39, t0.end_abj_date AS end_abj_date_40, t0.start_abj_date AS start_abj_date_41, t0.origin_country AS origin_country_42, t0.origin_plateform AS origin_plateform_43, t0.preparation_instructions_text AS preparation_instructions_text_44, t0.source AS source_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.base64_code AS base64_code_48, t0.recipe_type_id AS recipe_type_id_49, t0.level_id AS level_id_50, t0.budget_id AS budget_id_51, t0.user_id AS user_id_52 FROM recipe t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "delice-de-spaguetti-4-8"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.user_old_id AS user_old_id_2,
  t0.recette_id AS recette_id_3,
  t0.hits AS hits_4,
  t0.image_url AS image_url_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.user_name AS user_name_8,
  t0.user_email AS user_email_9,
  t0.web_site AS web_site_10,
  t0.country AS country_11,
  t0.recipe_type AS recipe_type_12,
  t0.number_of_persons AS number_of_persons_13,
  t0.total_time AS total_time_14,
  t0.cooking AS cooking_15,
  t0.marinade AS marinade_16,
  t0.level_name AS level_name_17,
  t0.pricing AS pricing_18,
  t0.dedicace AS dedicace_19,
  t0.pref AS pref_20,
  t0.published_at AS published_at_21,
  t0.last_updated AS last_updated_22,
  t0.ip AS ip_23,
  t0.pe AS pe_24,
  t0.regime AS regime_25,
  t0.is_active AS is_active_26,
  t0.description AS description_27,
  t0.country_code AS country_code_28,
  t0.suggestions AS suggestions_29,
  t0.is_tutorial AS is_tutorial_30,
  t0.video_url AS video_url_31,
  t0.ingredient_text AS ingredient_text_32,
  t0.ustensil_text AS ustensil_text_33,
  t0.has_multiple_step AS has_multiple_step_34,
  t0.is_spotlight AS is_spotlight_35,
  t0.preparation_instructions AS preparation_instructions_36,
  t0.spot_light_end AS spot_light_end_37,
  t0.spot_light_start AS spot_light_start_38,
  t0.is_spot_light_abj AS is_spot_light_abj_39,
  t0.end_abj_date AS end_abj_date_40,
  t0.start_abj_date AS start_abj_date_41,
  t0.origin_country AS origin_country_42,
  t0.origin_plateform AS origin_plateform_43,
  t0.preparation_instructions_text AS preparation_instructions_text_44,
  t0.source AS source_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.base64_code AS base64_code_48,
  t0.recipe_type_id AS recipe_type_id_49,
  t0.level_id AS level_id_50,
  t0.budget_id AS budget_id_51,
  t0.user_id AS user_id_52
FROM
  recipe t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_old_id AS user_old_id_2, t0.recette_id AS recette_id_3, t0.hits AS hits_4, t0.image_url AS image_url_5, t0.name AS name_6, t0.slug AS slug_7, t0.user_name AS user_name_8, t0.user_email AS user_email_9, t0.web_site AS web_site_10, t0.country AS country_11, t0.recipe_type AS recipe_type_12, t0.number_of_persons AS number_of_persons_13, t0.total_time AS total_time_14, t0.cooking AS cooking_15, t0.marinade AS marinade_16, t0.level_name AS level_name_17, t0.pricing AS pricing_18, t0.dedicace AS dedicace_19, t0.pref AS pref_20, t0.published_at AS published_at_21, t0.last_updated AS last_updated_22, t0.ip AS ip_23, t0.pe AS pe_24, t0.regime AS regime_25, t0.is_active AS is_active_26, t0.description AS description_27, t0.country_code AS country_code_28, t0.suggestions AS suggestions_29, t0.is_tutorial AS is_tutorial_30, t0.video_url AS video_url_31, t0.ingredient_text AS ingredient_text_32, t0.ustensil_text AS ustensil_text_33, t0.has_multiple_step AS has_multiple_step_34, t0.is_spotlight AS is_spotlight_35, t0.preparation_instructions AS preparation_instructions_36, t0.spot_light_end AS spot_light_end_37, t0.spot_light_start AS spot_light_start_38, t0.is_spot_light_abj AS is_spot_light_abj_39, t0.end_abj_date AS end_abj_date_40, t0.start_abj_date AS start_abj_date_41, t0.origin_country AS origin_country_42, t0.origin_plateform AS origin_plateform_43, t0.preparation_instructions_text AS preparation_instructions_text_44, t0.source AS source_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.base64_code AS base64_code_48, t0.recipe_type_id AS recipe_type_id_49, t0.level_id AS level_id_50, t0.budget_id AS budget_id_51, t0.user_id AS user_id_52 FROM recipe t0 WHERE t0.slug = 'delice-de-spaguetti-4-8' LIMIT 1;

0.23 ms
(24.57%)

SELECT t0.id AS id_1, t0.number_of_start AS number_of_start_2 FROM rate t0 INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id WHERE rate_recipe.recipe_id = ?

Parameters:

[
  165
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.number_of_start AS number_of_start_2
FROM
  rate t0
  INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id
WHERE
  rate_recipe.recipe_id = ?

SELECT t0.id AS id_1, t0.number_of_start AS number_of_start_2 FROM rate t0 INNER JOIN rate_recipe ON t0.id = rate_recipe.rate_id WHERE rate_recipe.recipe_id = 165;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
unitec	doctrine.dbal.unitec_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
unitec	doctrine.orm.unitec_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Recipe	No errors.
App\Entity\RecipeType	No errors.
App\Entity\Level	No errors.
App\Entity\Budget	No errors.
App\Entity\User	No errors.
App\Entity\RecipeImages	No errors.
App\Entity\CommentRecipe	The association App\Entity\CommentRecipe#user refers to the inverse side field App\Entity\User#commentRecipes which does not exist.
App\Entity\RecipeStep	No errors.
App\Entity\Utensil	No errors.
App\Entity\Ingredient	No errors.
App\Entity\Like	No errors.
App\Entity\BookMaker	No errors.
App\Entity\Rate	No errors.
App\Entity\RecipeCount	No errors.
App\Entity\Course	No errors.
App\Entity\Restaurant	No errors.
App\Entity\Order	No errors.
App\Entity\Shop	No errors.
App\Entity\Subscription	The association App\Entity\Subscription#subscriptionType refers to the inverse side field App\Entity\SubscriptionType#susbcription which does not exist.
App\Entity\CookingTricks	No errors.
App\Entity\RateRestaurant	No errors.
App\Entity\Transactions	No errors.
App\Entity\UserSessions	No errors.
App\Entity\CourseParticipants	No errors.
App\Entity\ProductType	No errors.

unitec entity manager

No loaded entities.