https://api.abidjan.net/views-counter/riz-au-lait

Query Metrics

2 Database Queries
2 Different statements
5.09 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
4.82 ms
(94.66%)
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:
[
  "riz-au-lait"
]
0.27 ms
(5.34%)
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:
[
  2691
]

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.