Query Metrics
6
Database Queries
6
Different statements
3.93 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.email AS email_5, t0.login AS login_6, t0.roles AS roles_7, t0.password AS password_8, t0.creation_date AS creation_date_9, t0.can_share AS can_share_10, t0.max_account AS max_account_11, t0.active AS active_12, t0.is_verified AS is_verified_13, t0.allow_multi_account AS allow_multi_account_14 FROM user t0 WHERE t0.login = ? LIMIT 1
Parameters:
[
"admin"
]
|
| 2 | 1.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.postal AS postal_5, t0.siret AS siret_6, t0.insee AS insee_7, t0.phone AS phone_8, t0.email AS email_9, t0.comment AS comment_10, t0.nb_employee AS nb_employee_11, t0.nb_seats AS nb_seats_12, t0.establishment_type AS establishment_type_13, t0.kitchen_type AS kitchen_type_14, t0.central_producer_siret AS central_producer_siret_15, t0.satellite_canteens_count AS satellite_canteens_count_16, t0.sectors AS sectors_17, t0.management_type AS management_type_18, t0.economic_model AS economic_model_19, t0.nb_guest_lunch AS nb_guest_lunch_20, t0.nb_guest_dinner AS nb_guest_dinner_21, t0.yearly_meal_count AS yearly_meal_count_22, t0.group_name AS group_name_23, t0.group_slug AS group_slug_24, t0.group_img AS group_img_25, t0.agrilocal AS agrilocal_26, t0.agrilocal_key AS agrilocal_key_27, t0.agrilocal_dptm AS agrilocal_dptm_28, t0.macantine AS macantine_29, t0.macantine_id AS macantine_id_30, t0.macantine_senddata AS macantine_senddata_31, t0.macantine_senddiag AS macantine_senddiag_32, t0.next_order_sheet AS next_order_sheet_33, t0.can_share AS can_share_34, t0.hash AS hash_35, t0.login_failure AS login_failure_36, t0.lock_time AS lock_time_37, t0.active AS active_38, t0.responsable_id AS responsable_id_39, t0.gerant_id AS gerant_id_40, t41.id AS id_42, t41.libelle AS libelle_43, t41.quantity AS quantity_44, t41.budget AS budget_45, t41.packing AS packing_46, t41.provider AS provider_47, t41.old AS old_48, t41.dlc AS dlc_49, t41.pu_ht AS pu_ht_50, t41.pu_ttc AS pu_ttc_51, t41.area AS area_52, t41.family AS family_53, t41.lot AS lot_54, t41.restaurant_id AS restaurant_id_55, t56.id AS id_57, t56.pagination AS pagination_58, t56.restaurant_id AS restaurant_id_59, t60.id AS id_61, t60.libelle AS libelle_62, t60.quantity AS quantity_63, t60.budget AS budget_64, t60.label AS label_65, t60.packing AS packing_66, t60.provider AS provider_67, t60.pu_ht AS pu_ht_68, t60.pu_ttc AS pu_ttc_69, t60.montant_ht AS montant_ht_70, t60.montant_ttc AS montant_ttc_71, t60.lot AS lot_72, t60.temperature AS temperature_73, t60.dlc AS dlc_74, t60.comment AS comment_75, t60.restaurant_id AS restaurant_id_76, t77.id AS id_78, t77.entete_1 AS entete_1_79, t77.entete_2 AS entete_2_80, t77.entete_3 AS entete_3_81, t77.entete_4 AS entete_4_82, t77.restaurant_id AS restaurant_id_83, t84.id AS id_85, t84.bud_stock_current_value_ht AS bud_stock_current_value_ht_86, t84.bud_stock_current_value_ttc AS bud_stock_current_value_ttc_87, t84.bud_stock_last_year_value_ht AS bud_stock_last_year_value_ht_88, t84.bud_stock_last_year_value_ttc AS bud_stock_last_year_value_ttc_89, t84.bud_in_ht AS bud_in_ht_90, t84.bud_in_ttc AS bud_in_ttc_91, t84.bud_out_ht AS bud_out_ht_92, t84.bud_out_ttc AS bud_out_ttc_93, t84.bud_meal AS bud_meal_94, t84.bud_meal_cost_ht AS bud_meal_cost_ht_95, t84.bud_meal_cost_ttc AS bud_meal_cost_ttc_96, t84.bud_left AS bud_left_97, t84.bunit_stock_current_value_ht AS bunit_stock_current_value_ht_98, t84.bunit_stock_current_value_ttc AS bunit_stock_current_value_ttc_99, t84.bunit_stock_last_year_value_ht AS bunit_stock_last_year_value_ht_100, t84.bunit_stock_last_year_value_ttc AS bunit_stock_last_year_value_ttc_101, t84.bunit_in_ht AS bunit_in_ht_102, t84.bunit_in_ttc AS bunit_in_ttc_103, t84.bunit_out_ht AS bunit_out_ht_104, t84.bunit_out_ttc AS bunit_out_ttc_105, t84.bunit_meal AS bunit_meal_106, t84.bunit_meal_cost_ht AS bunit_meal_cost_ht_107, t84.bunit_meal_cost_ttc AS bunit_meal_cost_ttc_108, t84.bunit_left AS bunit_left_109, t84.restaurant_id AS restaurant_id_110, t111.id AS id_112, t111.food_plan AS food_plan_113, t111.menu_plan AS menu_plan_114, t111.waste AS waste_115, t111.stock AS stock_116, t111.stock_admin AS stock_admin_117, t111.stock_trial AS stock_trial_118, t111.recipe AS recipe_119, t111.my_food AS my_food_120, t111.notification AS notification_121, t111.food AS food_122, t111.assist AS assist_123, t111.shopping_list AS shopping_list_124, t111.provider_suggest AS provider_suggest_125, t111.restaurant_id AS restaurant_id_126 FROM restaurant t0 LEFT JOIN column_stock_etat t41 ON t41.restaurant_id = t0.id LEFT JOIN pagination_stock t56 ON t56.restaurant_id = t0.id LEFT JOIN column_stock_input t60 ON t60.restaurant_id = t0.id LEFT JOIN print_stock_in t77 ON t77.restaurant_id = t0.id LEFT JOIN dashboard t84 ON t84.restaurant_id = t0.id LEFT JOIN access_restaurant t111 ON t111.restaurant_id = t0.id WHERE t0.gerant_id = ? LIMIT 1
Parameters:
[
16
]
|
| 3 | 0.40 ms |
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.user_id AS user_id_3, t0.notif_id AS notif_id_4 FROM user_notif t0 WHERE t0.user_id = ? AND t0.is_read = ?
Parameters:
[ 16 0 ] |
| 4 | 0.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.postal AS postal_5, t0.siret AS siret_6, t0.insee AS insee_7, t0.phone AS phone_8, t0.email AS email_9, t0.comment AS comment_10, t0.nb_employee AS nb_employee_11, t0.nb_seats AS nb_seats_12, t0.establishment_type AS establishment_type_13, t0.kitchen_type AS kitchen_type_14, t0.central_producer_siret AS central_producer_siret_15, t0.satellite_canteens_count AS satellite_canteens_count_16, t0.sectors AS sectors_17, t0.management_type AS management_type_18, t0.economic_model AS economic_model_19, t0.nb_guest_lunch AS nb_guest_lunch_20, t0.nb_guest_dinner AS nb_guest_dinner_21, t0.yearly_meal_count AS yearly_meal_count_22, t0.group_name AS group_name_23, t0.group_slug AS group_slug_24, t0.group_img AS group_img_25, t0.agrilocal AS agrilocal_26, t0.agrilocal_key AS agrilocal_key_27, t0.agrilocal_dptm AS agrilocal_dptm_28, t0.macantine AS macantine_29, t0.macantine_id AS macantine_id_30, t0.macantine_senddata AS macantine_senddata_31, t0.macantine_senddiag AS macantine_senddiag_32, t0.next_order_sheet AS next_order_sheet_33, t0.can_share AS can_share_34, t0.hash AS hash_35, t0.login_failure AS login_failure_36, t0.lock_time AS lock_time_37, t0.active AS active_38, t0.responsable_id AS responsable_id_39, t0.gerant_id AS gerant_id_40, t41.id AS id_42, t41.libelle AS libelle_43, t41.quantity AS quantity_44, t41.budget AS budget_45, t41.packing AS packing_46, t41.provider AS provider_47, t41.old AS old_48, t41.dlc AS dlc_49, t41.pu_ht AS pu_ht_50, t41.pu_ttc AS pu_ttc_51, t41.area AS area_52, t41.family AS family_53, t41.lot AS lot_54, t41.restaurant_id AS restaurant_id_55, t56.id AS id_57, t56.pagination AS pagination_58, t56.restaurant_id AS restaurant_id_59, t60.id AS id_61, t60.libelle AS libelle_62, t60.quantity AS quantity_63, t60.budget AS budget_64, t60.label AS label_65, t60.packing AS packing_66, t60.provider AS provider_67, t60.pu_ht AS pu_ht_68, t60.pu_ttc AS pu_ttc_69, t60.montant_ht AS montant_ht_70, t60.montant_ttc AS montant_ttc_71, t60.lot AS lot_72, t60.temperature AS temperature_73, t60.dlc AS dlc_74, t60.comment AS comment_75, t60.restaurant_id AS restaurant_id_76, t77.id AS id_78, t77.entete_1 AS entete_1_79, t77.entete_2 AS entete_2_80, t77.entete_3 AS entete_3_81, t77.entete_4 AS entete_4_82, t77.restaurant_id AS restaurant_id_83, t84.id AS id_85, t84.bud_stock_current_value_ht AS bud_stock_current_value_ht_86, t84.bud_stock_current_value_ttc AS bud_stock_current_value_ttc_87, t84.bud_stock_last_year_value_ht AS bud_stock_last_year_value_ht_88, t84.bud_stock_last_year_value_ttc AS bud_stock_last_year_value_ttc_89, t84.bud_in_ht AS bud_in_ht_90, t84.bud_in_ttc AS bud_in_ttc_91, t84.bud_out_ht AS bud_out_ht_92, t84.bud_out_ttc AS bud_out_ttc_93, t84.bud_meal AS bud_meal_94, t84.bud_meal_cost_ht AS bud_meal_cost_ht_95, t84.bud_meal_cost_ttc AS bud_meal_cost_ttc_96, t84.bud_left AS bud_left_97, t84.bunit_stock_current_value_ht AS bunit_stock_current_value_ht_98, t84.bunit_stock_current_value_ttc AS bunit_stock_current_value_ttc_99, t84.bunit_stock_last_year_value_ht AS bunit_stock_last_year_value_ht_100, t84.bunit_stock_last_year_value_ttc AS bunit_stock_last_year_value_ttc_101, t84.bunit_in_ht AS bunit_in_ht_102, t84.bunit_in_ttc AS bunit_in_ttc_103, t84.bunit_out_ht AS bunit_out_ht_104, t84.bunit_out_ttc AS bunit_out_ttc_105, t84.bunit_meal AS bunit_meal_106, t84.bunit_meal_cost_ht AS bunit_meal_cost_ht_107, t84.bunit_meal_cost_ttc AS bunit_meal_cost_ttc_108, t84.bunit_left AS bunit_left_109, t84.restaurant_id AS restaurant_id_110, t111.id AS id_112, t111.food_plan AS food_plan_113, t111.menu_plan AS menu_plan_114, t111.waste AS waste_115, t111.stock AS stock_116, t111.stock_admin AS stock_admin_117, t111.stock_trial AS stock_trial_118, t111.recipe AS recipe_119, t111.my_food AS my_food_120, t111.notification AS notification_121, t111.food AS food_122, t111.assist AS assist_123, t111.shopping_list AS shopping_list_124, t111.provider_suggest AS provider_suggest_125, t111.restaurant_id AS restaurant_id_126 FROM restaurant t0 LEFT JOIN column_stock_etat t41 ON t41.restaurant_id = t0.id LEFT JOIN pagination_stock t56 ON t56.restaurant_id = t0.id LEFT JOIN column_stock_input t60 ON t60.restaurant_id = t0.id LEFT JOIN print_stock_in t77 ON t77.restaurant_id = t0.id LEFT JOIN dashboard t84 ON t84.restaurant_id = t0.id LEFT JOIN access_restaurant t111 ON t111.restaurant_id = t0.id WHERE t0.responsable_id = ? AND t0.active = ? LIMIT 1
Parameters:
[ 16 1 ] |
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.food_plan_read AS food_plan_read_2, t0.food_plan_write AS food_plan_write_3, t0.menu_plan_read AS menu_plan_read_4, t0.menu_plan_write AS menu_plan_write_5, t0.waste_read AS waste_read_6, t0.waste_write AS waste_write_7, t0.stock_read AS stock_read_8, t0.stock_write AS stock_write_9, t0.recipe_read AS recipe_read_10, t0.recipe_write AS recipe_write_11, t0.my_food_read AS my_food_read_12, t0.my_food_write AS my_food_write_13, t0.notification_read AS notification_read_14, t0.notification_write AS notification_write_15, t0.food AS food_16, t0.assist AS assist_17, t0.shopping_list AS shopping_list_18, t0.user_id AS user_id_19, t0.restaurant_id AS restaurant_id_20 FROM access_user t0 WHERE t0.user_id = ? AND t0.restaurant_id = ? LIMIT 1
Parameters:
[ 16 18 ] |
| 6 | 0.25 ms |
SELECT b0_.id AS id_0, b0_.libelle AS libelle_1, b0_.val AS val_2, b0_.tva1 AS tva1_3, b0_.tva2 AS tva2_4, b0_.tva3 AS tva3_5, b0_.tva4 AS tva4_6, b0_.ttc AS ttc_7, b0_.year AS year_8, b0_.currency AS currency_9, b0_.inc_not_food AS inc_not_food_10, b0_.inc_not_convive AS inc_not_convive_11, b0_.type_valorisation AS type_valorisation_12, b0_.creation_date AS creation_date_13, b0_.start_date AS start_date_14, b0_.end_date AS end_date_15, b0_.close AS close_16, b0_.restaurant_id AS restaurant_id_17 FROM budget b0_ WHERE b0_.restaurant_id = ? ORDER BY b0_.id DESC LIMIT 1
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 2 |
| App\Entity\Restaurant | 2 |
| App\Entity\Parametrage\ColumnStockEtat | 2 |
| App\Entity\Parametrage\PaginationStock | 2 |
| App\Entity\Parametrage\ColumnStockInput | 2 |
| App\Entity\Stock\Dashboard | 2 |
| App\Entity\AccessRestaurant | 2 |
| App\Entity\AccessUser | 1 |
| App\Entity\Stock\Budget | 1 |