Query Metrics
5453
Database Queries
12
Different statements
854.62 ms
Query time
2
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
667.64 ms (78.12%) |
5401 |
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:
[
11038
]
|
105.63 ms (12.36%) |
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.is_active = ? ORDER BY t0.created_at DESC LIMIT 6000
Parameters:
[
1
]
|
60.02 ms (7.02%) |
5 |
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:
[
1
]
|
9.63 ms (1.13%) |
3 |
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
]
|
3.13 ms (0.37%) |
6 |
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:
[
11038
]
|
1.86 ms (0.22%) |
6 |
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:
[
11038
]
|
1.60 ms (0.19%) |
6 |
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:
[
11038
]
|
1.24 ms (0.14%) |
4 |
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:
[
21827
]
|
1.23 ms (0.14%) |
6 |
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:
[
11038
]
|
1.06 ms (0.12%) |
6 |
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:
[
11038
]
|
1.04 ms (0.12%) |
6 |
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:
[
11038
]
|
0.55 ms (0.06%) |
3 |
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:
[
2
]
|
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 |
|
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 |
|
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.