Query Metrics
                5453
                Database Queries
            
            
                12
                Different statements
            
            
                682.10 ms
                Query time
            
            
                2
                Invalid entities
            
        Grouped Statements
default connection
| Time▼ | Count | Info | 
|---|---|---|
| 
                                                
                                                621.95 ms (91.18%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                51.06 ms (7.49%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                2.00 ms (0.29%)  | 
                                            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.16 ms (0.17%)  | 
                                            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.15 ms (0.17%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                0.82 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
]
                                             | 
                                    
| 
                                                
                                                0.80 ms (0.12%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                0.77 ms (0.11%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                0.77 ms (0.11%)  | 
                                            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
]
                                             | 
                                    
| 
                                                
                                                0.74 ms (0.11%)  | 
                                            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.44 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
]
                                             | 
                                    
| 
                                                
                                                0.42 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, t0.base64_code AS base64_code_7 FROM level t0 WHERE t0.id = ? 
                                                Parameters:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  3
]
                                             | 
                                    
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.