POST https://v2.menu-co.com/login

Query Metrics

6 Database Queries
6 Different statements
3.93 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# 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

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Notif\Notif No errors.
App\Entity\Notif\UserNotif No errors.
App\Entity\Restaurant No errors.
App\Entity\Stock\ProviderSuggest No errors.
App\Entity\AccessUser No errors.
App\Entity\Parametrage\ColumnStockEtat No errors.
App\Entity\Parametrage\PaginationStock No errors.
App\Entity\Parametrage\ColumnStockInput No errors.
App\Entity\Print\StockIn No errors.
App\Entity\Stock\Dashboard No errors.
App\Entity\AccessRestaurant No errors.
App\Entity\Stock\Area No errors.
App\Entity\Stock\Provider No errors.
App\Entity\Stock\ArticleFamily No errors.
App\Entity\Stock\Article No errors.
App\Entity\Stock\Label No errors.
App\Entity\Stock\Packing No errors.
App\Entity\Stock\Budget No errors.
App\Entity\Stock\StockOrder No errors.
App\Entity\Archive\ArchiveStockOrder No errors.
App\Entity\Stock\StockProduct No errors.
App\Entity\Convive\Convive No errors.
App\Entity\Convive\Effectif No errors.
App\Entity\Print\Footer No errors.
App\Entity\Recipe\Recipe No errors.
App\Entity\Convive\ConviveDocument No errors.
App\Entity\Parametrage\AgrilocalHide No errors.
App\Entity\Weigh\WeighSessionSetting No errors.
App\Entity\Weigh\WeighStep No errors.
App\Entity\MenuPlan\MenuPlan No errors.
App\Entity\MenuPlan\Folder No errors.
App\Entity\Food\FoodRestaurant No errors.
App\Entity\Stock\MaCantine No errors.
App\Entity\Print\Bc No errors.
App\Entity\Print\Menu No errors.
App\Entity\Stock\ProductFamily No errors.
App\Entity\Shopping\Shopping No errors.
App\Entity\Food\FoodPlan No errors.
App\Entity\Stock\BudgetUnit No errors.
App\Entity\Stock\StockOrderProduct No errors.
App\Entity\Archive\ArchiveStockOrderProduct No errors.