https://api.abidjan.net/show-recipe/du-n-dole-aux-crevettes-pour-six-6-personnes

Query Metrics

13 Database Queries
13 Different statements
30.41 ms Query time
2 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 26.98 ms
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:
[
  "du-n-dole-aux-crevettes-pour-six-6-personnes"
]
2 0.30 ms
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:
[
  11036
]
3 0.44 ms
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.user AS user_3, t0.rf AS rf_4, t0.number AS number_5 FROM recipe_count t0 INNER JOIN recipe_count_recipe ON t0.id = recipe_count_recipe.recipe_count_id WHERE recipe_count_recipe.recipe_id = ?
Parameters:
[
  11036
]
4 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.cattype AS cattype_3, t0.cataff AS cataff_4, t0.slug AS slug_5, t0.description AS description_6, t0.image_url AS image_url_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.base64_code AS base64_code_10 FROM recipe_type t0 WHERE t0.id = ?
Parameters:
[
  9
]
5 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base64_code AS base64_code_7 FROM level t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.17 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.caption AS caption_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.base64_code AS base64_code_8, t0.recipe_id AS recipe_id_9 FROM recipe_images t0 WHERE t0.recipe_id = ?
Parameters:
[
  11036
]
7 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recipe_id AS recipe_id_5, t0.user_id AS user_id_6 FROM comment_recipe t0 WHERE t0.recipe_id = ?
Parameters:
[
  11036
]
8 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM budget t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.image_url AS image_url_4, t0.desription AS desription_5, t0.step_number AS step_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.base64_code AS base64_code_9, t0.recipe_id AS recipe_id_10 FROM recipe_step t0 WHERE t0.recipe_id = ?
Parameters:
[
  11036
]
10 0.31 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.username AS username_7, t0.birthday AS birthday_8, t0.adresse AS adresse_9, t0.ville AS ville_10, t0.dial_code AS dial_code_11, t0.numero AS numero_12, t0.code_pays AS code_pays_13, t0.password_requested_at AS password_requested_at_14, t0.token AS token_15, t0.pays AS pays_16, t0.lien_facebook AS lien_facebook_17, t0.nom_complet AS nom_complet_18, t0.lien_site_web AS lien_site_web_19, t0.type_compte AS type_compte_20, t0.actif AS actif_21, t0.email_verified AS email_verified_22, t0.is_cooker AS is_cooker_23, t0.is_admin AS is_admin_24, t0.has_restaurant AS has_restaurant_25, t0.photo AS photo_26, t0.date_creation AS date_creation_27, t0.date_modification AS date_modification_28, t0.date_suppression AS date_suppression_29 FROM user t0 WHERE t0.id = ?
Parameters:
[
  21903
]
11 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.mesure_unit AS mesure_unit_4, t0.description AS description_5, t0.image_url AS image_url_6, t0.prix AS prix_7, t0.is_buyable AS is_buyable_8, t0.stock AS stock_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.base64_code AS base64_code_13 FROM ingredient t0 INNER JOIN recipe_ingredient ON t0.id = recipe_ingredient.ingredient_id WHERE recipe_ingredient.recipe_id = ?
Parameters:
[
  11036
]
12 0.18 ms
SELECT t0.id AS id_1, t0.recipe_id AS recipe_id_2, t0.liker_id AS liker_id_3 FROM `like` t0 WHERE t0.recipe_id = ?
Parameters:
[
  11036
]
13 0.21 ms
SELECT t0.id AS id_1 FROM book_maker t0 INNER JOIN book_maker_recipe ON t0.id = book_maker_recipe.book_maker_id WHERE book_maker_recipe.recipe_id = ?
Parameters:
[
  11036
]

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.

unitec entity manager

No loaded entities.