| 1 |
0.33 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.id = ?
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.id = 16;
|
| 2 |
0.59 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 = ?
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 = ?
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 = 16;
|
| 3 |
0.62 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 = ?
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 = ?
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 = 16;
|
| 4 |
0.46 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 INNER JOIN restaurant_guest ON t0.id = restaurant_guest.restaurant_id WHERE restaurant_guest.user_id = ?
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
INNER JOIN restaurant_guest ON t0.id = restaurant_guest.restaurant_id
WHERE
restaurant_guest.user_id = ?
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 INNER JOIN restaurant_guest ON t0.id = restaurant_guest.restaurant_id WHERE restaurant_guest.user_id = 16;
|
| 5 |
0.20 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.val AS val_3, t0.tva1 AS tva1_4, t0.tva2 AS tva2_5, t0.tva3 AS tva3_6, t0.tva4 AS tva4_7, t0.ttc AS ttc_8, t0.year AS year_9, t0.currency AS currency_10, t0.inc_not_food AS inc_not_food_11, t0.inc_not_convive AS inc_not_convive_12, t0.type_valorisation AS type_valorisation_13, t0.creation_date AS creation_date_14, t0.start_date AS start_date_15, t0.end_date AS end_date_16, t0.close AS close_17, t0.restaurant_id AS restaurant_id_18 FROM budget t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.val AS val_3, t0.tva1 AS tva1_4, t0.tva2 AS tva2_5, t0.tva3 AS tva3_6, t0.tva4 AS tva4_7, t0.ttc AS ttc_8, t0.year AS year_9, t0.currency AS currency_10, t0.inc_not_food AS inc_not_food_11, t0.inc_not_convive AS inc_not_convive_12, t0.type_valorisation AS type_valorisation_13, t0.creation_date AS creation_date_14, t0.start_date AS start_date_15, t0.end_date AS end_date_16, t0.close AS close_17, t0.restaurant_id AS restaurant_id_18 FROM budget t0 WHERE t0.id = 25;
|
| 6 |
0.20 ms |
SELECT b0_.id AS id_0, b0_.libelle AS libelle_1, b0_.val AS val_2, b0_.val_current AS val_current_3, b0_.manage_convive AS manage_convive_4, b0_.budget_id AS budget_id_5 FROM budget_unit b0_ WHERE b0_.budget_id = ?
SELECT b0_.id AS id_0, b0_.libelle AS libelle_1, b0_.val AS val_2, b0_.val_current AS val_current_3, b0_.manage_convive AS manage_convive_4, b0_.budget_id AS budget_id_5 FROM budget_unit b0_ WHERE b0_.budget_id = 25;
|
| 7 |
0.29 ms |
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.writable AS writable_2, f0_.created_date AS created_date_3, f0_.draft AS draft_4, f0_.validated AS validated_5, f0_.meal_type AS meal_type_6, f0_.length AS length_7, f1_.id AS id_8, f1_.color AS color_9, f1_.libelle AS libelle_10 FROM food_plan f0_ LEFT JOIN food_plan_folder f2_ ON f0_.id = f2_.food_plan_id LEFT JOIN folder f1_ ON f1_.id = f2_.folder_id WHERE f0_.restaurant_id = ? AND f0_.active = 1 ORDER BY f0_.created_date DESC
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.writable AS writable_2, f0_.created_date AS created_date_3, f0_.draft AS draft_4, f0_.validated AS validated_5, f0_.meal_type AS meal_type_6, f0_.length AS length_7, f1_.id AS id_8, f1_.color AS color_9, f1_.libelle AS libelle_10 FROM food_plan f0_ LEFT JOIN food_plan_folder f2_ ON f0_.id = f2_.food_plan_id LEFT JOIN folder f1_ ON f1_.id = f2_.folder_id WHERE f0_.restaurant_id = 18 AND f0_.active = 1 ORDER BY f0_.created_date DESC;
|