Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.locale AS locale_13,
  t0.firstname AS firstname_14,
  t0.lastname AS lastname_15,
  t0.phone_number AS phone_number_16,
  t0.flotte_phone_number AS flotte_phone_number_17,
  t0.login AS login_18,
  t0.set_avatar AS set_avatar_19,
  t0.is_sync AS is_sync_20,
  t0.date_creation AS date_creation_21,
  t0.active AS active_22,
  t0.enable_offline_mode AS enable_offline_mode_23,
  t0.last_date_synchro_api AS last_date_synchro_api_24,
  t0.registration_token AS registration_token_25,
  t0.data_of_birth AS data_of_birth_26,
  t0.nationality AS nationality_27,
  t0.profile_picture AS profile_picture_28,
  t0.attached_document AS attached_document_29,
  t0.default_entrepreneur AS default_entrepreneur_30,
  t0.investigator_code AS investigator_code_31,
  t0.offline_id_min AS offline_id_min_32,
  t0.offline_id_max AS offline_id_max_33,
  t0.agence_id AS agence_id_34
FROM
  users t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.locale AS locale_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.phone_number AS phone_number_16, t0.flotte_phone_number AS flotte_phone_number_17, t0.login AS login_18, t0.set_avatar AS set_avatar_19, t0.is_sync AS is_sync_20, t0.date_creation AS date_creation_21, t0.active AS active_22, t0.enable_offline_mode AS enable_offline_mode_23, t0.last_date_synchro_api AS last_date_synchro_api_24, t0.registration_token AS registration_token_25, t0.data_of_birth AS data_of_birth_26, t0.nationality AS nationality_27, t0.profile_picture AS profile_picture_28, t0.attached_document AS attached_document_29, t0.default_entrepreneur AS default_entrepreneur_30, t0.investigator_code AS investigator_code_31, t0.offline_id_min AS offline_id_min_32, t0.offline_id_max AS offline_id_max_33, t0.agence_id AS agence_id_34 FROM users t0 WHERE t0.id = 171 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.localization_long AS localization_long_5,
  t0.localization_lat AS localization_lat_6,
  t0.address AS address_7,
  t0.quarter AS quarter_8,
  t0.zip AS zip_9,
  t0.city AS city_10,
  t0.date_start_construction AS date_start_construction_11,
  t0.date_start_service AS date_start_service_12,
  t0.date_end_service AS date_end_service_13,
  t0.date_creation AS date_creation_14,
  t0.date_update AS date_update_15,
  t0.active AS active_16,
  t0.check_updated AS check_updated_17,
  t0.ash_key AS ash_key_18,
  t0.permutation_key AS permutation_key_19,
  t0.workflow_state AS workflow_state_20,
  t0.project_number AS project_number_21,
  t0.prospect_number AS prospect_number_22,
  t0.network_number AS network_number_23,
  t0.stake_localization_long AS stake_localization_long_24,
  t0.stake_localization_lat AS stake_localization_lat_25,
  t0.total_power AS total_power_26,
  t0.total_storage_capacity AS total_storage_capacity_27,
  t0.total_voltage AS total_voltage_28,
  t0.total_cost AS total_cost_29,
  t0.total_wire_length AS total_wire_length_30,
  t0.total_max_power_consumption AS total_max_power_consumption_31,
  t0.total_consumption_day AS total_consumption_day_32,
  t0.commission_percentage AS commission_percentage_33,
  t0.commissions AS commissions_34,
  t0.nano_entrepreneur AS nano_entrepreneur_35,
  t0.comment AS comment_36,
  t0.cryptage AS cryptage_37,
  t0.deleted_at AS deleted_at_38,
  t0.zone_id AS zone_id_39,
  t0.owner_id AS owner_id_40,
  t0.country AS country_41
FROM
  network t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.localization_long AS localization_long_5, t0.localization_lat AS localization_lat_6, t0.address AS address_7, t0.quarter AS quarter_8, t0.zip AS zip_9, t0.city AS city_10, t0.date_start_construction AS date_start_construction_11, t0.date_start_service AS date_start_service_12, t0.date_end_service AS date_end_service_13, t0.date_creation AS date_creation_14, t0.date_update AS date_update_15, t0.active AS active_16, t0.check_updated AS check_updated_17, t0.ash_key AS ash_key_18, t0.permutation_key AS permutation_key_19, t0.workflow_state AS workflow_state_20, t0.project_number AS project_number_21, t0.prospect_number AS prospect_number_22, t0.network_number AS network_number_23, t0.stake_localization_long AS stake_localization_long_24, t0.stake_localization_lat AS stake_localization_lat_25, t0.total_power AS total_power_26, t0.total_storage_capacity AS total_storage_capacity_27, t0.total_voltage AS total_voltage_28, t0.total_cost AS total_cost_29, t0.total_wire_length AS total_wire_length_30, t0.total_max_power_consumption AS total_max_power_consumption_31, t0.total_consumption_day AS total_consumption_day_32, t0.commission_percentage AS commission_percentage_33, t0.commissions AS commissions_34, t0.nano_entrepreneur AS nano_entrepreneur_35, t0.comment AS comment_36, t0.cryptage AS cryptage_37, t0.deleted_at AS deleted_at_38, t0.zone_id AS zone_id_39, t0.owner_id AS owner_id_40, t0.country AS country_41 FROM network t0 WHERE t0.id = '60' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.device_count AS device_count_2,
  t0.date_creation AS date_creation_3,
  t0.date_deletion AS date_deletion_4,
  t0.position AS position_5,
  t0.date_real_deletion AS date_real_deletion_6,
  t0.motif_deletion AS motif_deletion_7,
  t0.date_check AS date_check_8,
  t0.date_updated AS date_updated_9,
  t0.date_update_motif AS date_update_motif_10,
  t0.panel AS panel_11,
  t0.is_check AS is_check_12,
  t0.states AS states_13,
  t0.verification_date AS verification_date_14,
  t0.user_updated AS user_updated_15,
  t0.device_old AS device_old_16,
  t0.device_count_old AS device_count_old_17,
  t0.network_id AS network_id_18,
  t0.device_id AS device_id_19,
  t0.usercreate_id AS usercreate_id_20,
  t0.userdelete_id AS userdelete_id_21,
  t0.motif_id AS motif_id_22
FROM
  network_device t0
WHERE
  t0.network_id = ?

SELECT t0.id AS id_1, t0.device_count AS device_count_2, t0.date_creation AS date_creation_3, t0.date_deletion AS date_deletion_4, t0.position AS position_5, t0.date_real_deletion AS date_real_deletion_6, t0.motif_deletion AS motif_deletion_7, t0.date_check AS date_check_8, t0.date_updated AS date_updated_9, t0.date_update_motif AS date_update_motif_10, t0.panel AS panel_11, t0.is_check AS is_check_12, t0.states AS states_13, t0.verification_date AS verification_date_14, t0.user_updated AS user_updated_15, t0.device_old AS device_old_16, t0.device_count_old AS device_count_old_17, t0.network_id AS network_id_18, t0.device_id AS device_id_19, t0.usercreate_id AS usercreate_id_20, t0.userdelete_id AS userdelete_id_21, t0.motif_id AS motif_id_22 FROM network_device t0 WHERE t0.network_id = 60;

SELECT
  t0.id AS id_1,
  t0.custom_number AS custom_number_2,
  t0.secret_key AS secret_key_3,
  t0.localization_long AS localization_long_4,
  t0.localization_lat AS localization_lat_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.city AS city_8,
  t0.picture_path AS picture_path_9,
  t0.date_creation AS date_creation_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.date_update AS date_update_13,
  t0.prospect_number AS prospect_number_14,
  t0.workflow_state AS workflow_state_15,
  t0.date_survey AS date_survey_16,
  t0.date_door_to_door AS date_door_to_door_17,
  t0.date_join_network AS date_join_network_18,
  t0.recalculate_balance AS recalculate_balance_19,
  t0.electric_production_equipment AS electric_production_equipment_20,
  t0.electric_equipment AS electric_equipment_21,
  t0.operator AS operator_22,
  t0.survey_interest AS survey_interest_23,
  t0.occupant_status AS occupant_status_24,
  t0.nb_adults AS nb_adults_25,
  t0.nb_children AS nb_children_26,
  t0.occupation_rate AS occupation_rate_27,
  t0.job AS job_28,
  t0.monthly_household_income AS monthly_household_income_29,
  t0.phone_number AS phone_number_30,
  t0.admin_comment AS admin_comment_31,
  t0.total_price_estimation AS total_price_estimation_32,
  t0.can_refund AS can_refund_33,
  t0.distance_from_stake AS distance_from_stake_34,
  t0.distance_from_box AS distance_from_box_35,
  t0.contract_file_name AS contract_file_name_36,
  t0.status AS status_37,
  t0.balance AS balance_38,
  t0.date_start_service AS date_start_service_39,
  t0.slot_number AS slot_number_40,
  t0.kobo_devis_id AS kobo_devis_id_41,
  t0.kobo_survey_id AS kobo_survey_id_42,
  t0.minimum_cost_estimation AS minimum_cost_estimation_43,
  t0.has_battery AS has_battery_44,
  t0.regularized AS regularized_45,
  t0.date_remove_from_network AS date_remove_from_network_46,
  t0.total_paye AS total_paye_47,
  t0.remaining_days AS remaining_days_48,
  t0.country AS country_49,
  t0.building AS building_50,
  t0.zone AS zone_51,
  t0.activity AS activity_52,
  t0.offer AS offer_53,
  t0.network_id AS network_id_54,
  t0.creator_id AS creator_id_55,
  t0.orange_money_customer_id AS orange_money_customer_id_56,
  t0.mobile_money_customer_id AS mobile_money_customer_id_57,
  t0.investigator_id AS investigator_id_58,
  t0.userdeletefromnetwork_id AS userdeletefromnetwork_id_59,
  t0.offre_caisse_id AS offre_caisse_id_60,
  t0.offer_new AS offer_new_61
FROM
  customer t0
WHERE
  t0.network_id = ?

SELECT t0.id AS id_1, t0.custom_number AS custom_number_2, t0.secret_key AS secret_key_3, t0.localization_long AS localization_long_4, t0.localization_lat AS localization_lat_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.picture_path AS picture_path_9, t0.date_creation AS date_creation_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.date_update AS date_update_13, t0.prospect_number AS prospect_number_14, t0.workflow_state AS workflow_state_15, t0.date_survey AS date_survey_16, t0.date_door_to_door AS date_door_to_door_17, t0.date_join_network AS date_join_network_18, t0.recalculate_balance AS recalculate_balance_19, t0.electric_production_equipment AS electric_production_equipment_20, t0.electric_equipment AS electric_equipment_21, t0.operator AS operator_22, t0.survey_interest AS survey_interest_23, t0.occupant_status AS occupant_status_24, t0.nb_adults AS nb_adults_25, t0.nb_children AS nb_children_26, t0.occupation_rate AS occupation_rate_27, t0.job AS job_28, t0.monthly_household_income AS monthly_household_income_29, t0.phone_number AS phone_number_30, t0.admin_comment AS admin_comment_31, t0.total_price_estimation AS total_price_estimation_32, t0.can_refund AS can_refund_33, t0.distance_from_stake AS distance_from_stake_34, t0.distance_from_box AS distance_from_box_35, t0.contract_file_name AS contract_file_name_36, t0.status AS status_37, t0.balance AS balance_38, t0.date_start_service AS date_start_service_39, t0.slot_number AS slot_number_40, t0.kobo_devis_id AS kobo_devis_id_41, t0.kobo_survey_id AS kobo_survey_id_42, t0.minimum_cost_estimation AS minimum_cost_estimation_43, t0.has_battery AS has_battery_44, t0.regularized AS regularized_45, t0.date_remove_from_network AS date_remove_from_network_46, t0.total_paye AS total_paye_47, t0.remaining_days AS remaining_days_48, t0.country AS country_49, t0.building AS building_50, t0.zone AS zone_51, t0.activity AS activity_52, t0.offer AS offer_53, t0.network_id AS network_id_54, t0.creator_id AS creator_id_55, t0.orange_money_customer_id AS orange_money_customer_id_56, t0.mobile_money_customer_id AS mobile_money_customer_id_57, t0.investigator_id AS investigator_id_58, t0.userdeletefromnetwork_id AS userdeletefromnetwork_id_59, t0.offre_caisse_id AS offre_caisse_id_60, t0.offer_new AS offer_new_61 FROM customer t0 WHERE t0.network_id = 60;

SELECT
  t0.id AS id_1,
  t0.custom_number AS custom_number_2,
  t0.secret_key AS secret_key_3,
  t0.localization_long AS localization_long_4,
  t0.localization_lat AS localization_lat_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.city AS city_8,
  t0.picture_path AS picture_path_9,
  t0.date_creation AS date_creation_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.date_update AS date_update_13,
  t0.prospect_number AS prospect_number_14,
  t0.workflow_state AS workflow_state_15,
  t0.date_survey AS date_survey_16,
  t0.date_door_to_door AS date_door_to_door_17,
  t0.date_join_network AS date_join_network_18,
  t0.recalculate_balance AS recalculate_balance_19,
  t0.electric_production_equipment AS electric_production_equipment_20,
  t0.electric_equipment AS electric_equipment_21,
  t0.operator AS operator_22,
  t0.survey_interest AS survey_interest_23,
  t0.occupant_status AS occupant_status_24,
  t0.nb_adults AS nb_adults_25,
  t0.nb_children AS nb_children_26,
  t0.occupation_rate AS occupation_rate_27,
  t0.job AS job_28,
  t0.monthly_household_income AS monthly_household_income_29,
  t0.phone_number AS phone_number_30,
  t0.admin_comment AS admin_comment_31,
  t0.total_price_estimation AS total_price_estimation_32,
  t0.can_refund AS can_refund_33,
  t0.distance_from_stake AS distance_from_stake_34,
  t0.distance_from_box AS distance_from_box_35,
  t0.contract_file_name AS contract_file_name_36,
  t0.status AS status_37,
  t0.balance AS balance_38,
  t0.date_start_service AS date_start_service_39,
  t0.slot_number AS slot_number_40,
  t0.kobo_devis_id AS kobo_devis_id_41,
  t0.kobo_survey_id AS kobo_survey_id_42,
  t0.minimum_cost_estimation AS minimum_cost_estimation_43,
  t0.has_battery AS has_battery_44,
  t0.regularized AS regularized_45,
  t0.date_remove_from_network AS date_remove_from_network_46,
  t0.total_paye AS total_paye_47,
  t0.remaining_days AS remaining_days_48,
  t0.country AS country_49,
  t0.building AS building_50,
  t0.zone AS zone_51,
  t0.activity AS activity_52,
  t0.offer AS offer_53,
  t0.network_id AS network_id_54,
  t0.creator_id AS creator_id_55,
  t0.orange_money_customer_id AS orange_money_customer_id_56,
  t0.mobile_money_customer_id AS mobile_money_customer_id_57,
  t0.investigator_id AS investigator_id_58,
  t0.userdeletefromnetwork_id AS userdeletefromnetwork_id_59,
  t0.offre_caisse_id AS offre_caisse_id_60,
  t0.offer_new AS offer_new_61
FROM
  customer t0
WHERE
  t0.network_id = ?
ORDER BY
  t0.slot_number ASC

SELECT t0.id AS id_1, t0.custom_number AS custom_number_2, t0.secret_key AS secret_key_3, t0.localization_long AS localization_long_4, t0.localization_lat AS localization_lat_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.picture_path AS picture_path_9, t0.date_creation AS date_creation_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.date_update AS date_update_13, t0.prospect_number AS prospect_number_14, t0.workflow_state AS workflow_state_15, t0.date_survey AS date_survey_16, t0.date_door_to_door AS date_door_to_door_17, t0.date_join_network AS date_join_network_18, t0.recalculate_balance AS recalculate_balance_19, t0.electric_production_equipment AS electric_production_equipment_20, t0.electric_equipment AS electric_equipment_21, t0.operator AS operator_22, t0.survey_interest AS survey_interest_23, t0.occupant_status AS occupant_status_24, t0.nb_adults AS nb_adults_25, t0.nb_children AS nb_children_26, t0.occupation_rate AS occupation_rate_27, t0.job AS job_28, t0.monthly_household_income AS monthly_household_income_29, t0.phone_number AS phone_number_30, t0.admin_comment AS admin_comment_31, t0.total_price_estimation AS total_price_estimation_32, t0.can_refund AS can_refund_33, t0.distance_from_stake AS distance_from_stake_34, t0.distance_from_box AS distance_from_box_35, t0.contract_file_name AS contract_file_name_36, t0.status AS status_37, t0.balance AS balance_38, t0.date_start_service AS date_start_service_39, t0.slot_number AS slot_number_40, t0.kobo_devis_id AS kobo_devis_id_41, t0.kobo_survey_id AS kobo_survey_id_42, t0.minimum_cost_estimation AS minimum_cost_estimation_43, t0.has_battery AS has_battery_44, t0.regularized AS regularized_45, t0.date_remove_from_network AS date_remove_from_network_46, t0.total_paye AS total_paye_47, t0.remaining_days AS remaining_days_48, t0.country AS country_49, t0.building AS building_50, t0.zone AS zone_51, t0.activity AS activity_52, t0.offer AS offer_53, t0.network_id AS network_id_54, t0.creator_id AS creator_id_55, t0.orange_money_customer_id AS orange_money_customer_id_56, t0.mobile_money_customer_id AS mobile_money_customer_id_57, t0.investigator_id AS investigator_id_58, t0.userdeletefromnetwork_id AS userdeletefromnetwork_id_59, t0.offre_caisse_id AS offre_caisse_id_60, t0.offer_new AS offer_new_61 FROM customer t0 WHERE t0.network_id = 60 ORDER BY t0.slot_number ASC;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.locale AS locale_13,
  t0.firstname AS firstname_14,
  t0.lastname AS lastname_15,
  t0.phone_number AS phone_number_16,
  t0.flotte_phone_number AS flotte_phone_number_17,
  t0.login AS login_18,
  t0.set_avatar AS set_avatar_19,
  t0.is_sync AS is_sync_20,
  t0.date_creation AS date_creation_21,
  t0.active AS active_22,
  t0.enable_offline_mode AS enable_offline_mode_23,
  t0.last_date_synchro_api AS last_date_synchro_api_24,
  t0.registration_token AS registration_token_25,
  t0.data_of_birth AS data_of_birth_26,
  t0.nationality AS nationality_27,
  t0.profile_picture AS profile_picture_28,
  t0.attached_document AS attached_document_29,
  t0.default_entrepreneur AS default_entrepreneur_30,
  t0.investigator_code AS investigator_code_31,
  t0.offline_id_min AS offline_id_min_32,
  t0.offline_id_max AS offline_id_max_33,
  t0.agence_id AS agence_id_34
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.locale AS locale_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.phone_number AS phone_number_16, t0.flotte_phone_number AS flotte_phone_number_17, t0.login AS login_18, t0.set_avatar AS set_avatar_19, t0.is_sync AS is_sync_20, t0.date_creation AS date_creation_21, t0.active AS active_22, t0.enable_offline_mode AS enable_offline_mode_23, t0.last_date_synchro_api AS last_date_synchro_api_24, t0.registration_token AS registration_token_25, t0.data_of_birth AS data_of_birth_26, t0.nationality AS nationality_27, t0.profile_picture AS profile_picture_28, t0.attached_document AS attached_document_29, t0.default_entrepreneur AS default_entrepreneur_30, t0.investigator_code AS investigator_code_31, t0.offline_id_min AS offline_id_min_32, t0.offline_id_max AS offline_id_max_33, t0.agence_id AS agence_id_34 FROM users t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.lft AS lft_4,
  t0.rgt AS rgt_5,
  t0.root_id AS root_id_6,
  t0.level AS level_7,
  t0.deleted_at AS deleted_at_8,
  t0.type AS type_9,
  t0.parent_id AS parent_id_10,
  t0.agence_id AS agence_id_11
FROM
  zone t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lft AS lft_4, t0.rgt AS rgt_5, t0.root_id AS root_id_6, t0.level AS level_7, t0.deleted_at AS deleted_at_8, t0.type AS type_9, t0.parent_id AS parent_id_10, t0.agence_id AS agence_id_11 FROM zone t0 WHERE t0.id = 100 AND ((t0.deleted_at IS NULL));