GET https://dev.ryukoch.com/it/ricette/Onigiri-al-tonno-e-maionese

Query Metrics

46 Database Queries
19 Different statements
21.38 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.55 ms
(30.64%)
2
SELECT r0_.id AS id_0, r0_.last_modification AS last_modification_1, r0_.date_published AS date_published_2, r0_.comment AS comment_3, r0_.content_top AS content_top_4, r0_.active AS active_5, r0_.type AS type_6, r0_.keywords AS keywords_7, r0_.original_characters AS original_characters_8, r0_.ai_translation AS ai_translation_9, r0_.media_id AS media_id_10, r0_.audio_id AS audio_id_11 FROM rk_sites r0_ INNER JOIN rk_sites_translation r1_ ON r0_.id = r1_.translatable_id WHERE r1_.locale = ? AND r1_.name = ?
Parameters:
[
  "it"
  "Onigiri-al-tonno-e-maionese"
]
2.71 ms
(12.68%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.title AS title_5, t0.title_2 AS title_2_6, t0.description AS description_7, t0.description_cms AS description_cms_8, t0.video AS video_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM rk_sites_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  139
]
1.70 ms
(7.96%)
1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.changing AS changing_3, t0.rk_sites_id AS rk_sites_id_4, t0.rk_tools_id AS rk_tools_id_5, t0.rk_units_id AS rk_units_id_6 FROM rk_recipe_tools t0 WHERE t0.rk_sites_id = ?
Parameters:
[
  139
]
1.51 ms
(7.06%)
5
SELECT t0.id AS id_1, t0.last_modification AS last_modification_2, t0.date_published AS date_published_3, t0.comment AS comment_4, t0.content_top AS content_top_5, t0.active AS active_6, t0.type AS type_7, t0.keywords AS keywords_8, t0.original_characters AS original_characters_9, t0.ai_translation AS ai_translation_10, t0.media_id AS media_id_11, t0.audio_id AS audio_id_12 FROM rk_sites t0 WHERE t0.id = ?
Parameters:
[
  "75"
]
1.49 ms
(6.99%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.email AS email_2, r0_.date AS date_3, r0_.content AS content_4, r0_.rate AS rate_5, r0_.verification AS verification_6, r0_.rk_sites_id AS rk_sites_id_7 FROM rk_ratings r0_ WHERE r0_.name <> ? AND r0_.rk_sites_id = ?
Parameters:
[
  "only rate"
  139
]
1.32 ms
(6.17%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM rk_ingredients_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  63
]
0.97 ms
(4.53%)
5
SELECT t0.id AS id_1, t0.vegan AS vegan_2, t0.vegetarian AS vegetarian_3, t0.gluten AS gluten_4, t0.lactose AS lactose_5, t0.ai_translated AS ai_translated_6 FROM rk_ingredients t0 WHERE t0.id = ?
Parameters:
[
  63
]
0.96 ms
(4.51%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM rk_units_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
0.77 ms
(3.58%)
4
SELECT t0.id AS id_1, t0.ai_translated AS ai_translated_2 FROM rk_units t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.60 ms
(2.79%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM rk_tools_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
0.44 ms
(2.08%)
2
SELECT t0.id AS id_1, t0.ai_translated AS ai_translated_2 FROM rk_tools t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.42 ms
(1.95%)
2
SELECT t0.id AS id_1, t0.file AS file_2, t0.type AS type_3, t0.created_at AS created_at_4 FROM rk_media t0 WHERE t0.id = ?
Parameters:
[
  75
]
0.40 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.changing AS changing_3, t0.rk_sites_id AS rk_sites_id_4, t0.rk_ingredients_id AS rk_ingredients_id_5, t0.rk_units_id AS rk_units_id_6 FROM rk_recipe_ingredients t0 WHERE t0.rk_sites_id = ?
Parameters:
[
  139
]
0.29 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.verification AS verification_3, t0.rk_sites_id AS rk_sites_id_4 FROM rk_cooked t0 WHERE t0.rk_sites_id = ? AND t0.verification = ?
Parameters:
[
  139
  1
]
0.27 ms
(1.28%)
1
SELECT AVG(r0_.rate) AS sclr_0 FROM rk_ratings r0_ WHERE r0_.rk_sites_id = ?
Parameters:
[
  139
]
0.27 ms
(1.24%)
1
SELECT COUNT(r0_.id) AS sclr_0 FROM rk_ratings r0_ WHERE r0_.rk_sites_id = ?
Parameters:
[
  139
]
0.26 ms
(1.23%)
1
SELECT t0.id AS id_1, t0.calories AS calories_2, t0.difficulty AS difficulty_3, t0.type AS type_4, t0.spicy AS spicy_5, t0.category AS category_6, t0.preparation_time AS preparation_time_7, t0.cooking_time AS cooking_time_8, t0.total_time AS total_time_9, t0.default_servings AS default_servings_10, t0.ai_translated AS ai_translated_11, t0.site_id AS site_id_12 FROM rk_recipes t0 WHERE t0.site_id = ? LIMIT 1
Parameters:
[
  139
]
0.23 ms
(1.08%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.identifier AS identifier_3, t0.title AS title_4, t0.title_slug AS title_slug_5, t0.description AS description_6, t0.price AS price_7, t0.small_image AS small_image_8, t0.medium_image AS medium_image_9, t0.large_image AS large_image_10, t0.link AS link_11, t0.feature AS feature_12, t0.platform_description AS platform_description_13 FROM rk_shop t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "B08P55CJB3"
]
0.22 ms
(1.04%)
1
SELECT t0.id AS id_1, t0.preparation AS preparation_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM rk_recipes_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]

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.

Entities Mapping

Class Mapping errors
App\Entity\RkSites
  • The association App\Entity\RkSites#rkCookeds refers to the owning side field App\Entity\RkCooked#rk_site which does not exist.
App\Entity\RkSitesTranslation No errors.
App\Entity\RkMedia No errors.
App\Entity\RkCategory No errors.
App\Entity\RkRecipeIngredients No errors.
App\Entity\RkRecipeTools No errors.
App\Entity\RkRatings No errors.
App\Entity\RkCooked
  • The mappings App\Entity\RkCooked#rk_sites and App\Entity\RkSites#rkCookeds are inconsistent with each other.
App\Entity\RkCmf
  • The association App\Entity\RkCmf#user refers to the inverse side field App\Entity\User#rkCmfs which does not exist.
App\Entity\RkIngredients No errors.
App\Entity\RkUnits No errors.
App\Entity\RkTools No errors.
App\Entity\RkRecipes No errors.
App\Entity\RkRecipesTranslation No errors.
App\Entity\RkIngredientsTranslation No errors.
App\Entity\RkShop No errors.
App\Entity\RkUnitsTranslation No errors.
App\Entity\RkToolsTranslation No errors.