GET https://admin-projets.preprod.maforet.fr/assessment/working-state-table

Query Metrics

29 Database Queries
5 Different statements
17.30 ms Query time
0 Invalid entities
73 Managed entities

Queries

Group similar statements

# Time Info
1 1.46 ms
SELECT f0_.comment AS comment_0, f0_.email AS email_1, f0_.phone AS phone_2, f0_.registered AS registered_3, f0_.registration_checked_at AS registration_checked_at_4, f0_.title AS title_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.id AS id_8, f0_.email2 AS email2_9, f0_.maf_partner AS maf_partner_10, f0_.maf_user_id AS maf_user_id_11, f0_.person_honorific_prefix AS person_honorific_prefix_12, f0_.person_given_name AS person_given_name_13, f0_.person_family_name AS person_family_name_14, f0_.forestry_organization_id AS forestry_organization_id_15 FROM forester f0_ LEFT JOIN assessment a1_ ON (a1_.forester_id = f0_.id) WHERE a1_.id IS NOT NULL
Parameters:
[]
2 1.66 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_25 FROM (SELECT a0_.uuid AS uuid_0, a0_.aggreed_property_share AS aggreed_property_share_1, a0_.area AS area_2, ST_AsBinary(a0_.bounding) AS bounding_3, a0_.cadastral_parcels AS cadastral_parcels_4, a0_.creator_email AS creator_email_5, a0_.current_situation AS current_situation_6, a0_.discount_rate_fertility_missing AS discount_rate_fertility_missing_7, a0_.discount_rate_fire_risks AS discount_rate_fire_risks_8, a0_.foliage_loss_because_of_health_crisis AS foliage_loss_because_of_health_crisis_9, a0_.forester_can_edit AS forester_can_edit_10, a0_.forester_comment AS forester_comment_11, a0_.forester_validated_at AS forester_validated_at_12, a0_.lbc_method AS lbc_method_13, a0_.locality AS locality_14, a0_.locality_code AS locality_code_15, ST_AsBinary(a0_.locality_centroid) AS locality_centroid_16, a0_.name AS name_17, a0_.origin AS origin_18, a0_.progress AS progress_19, a0_.property_id AS property_id_20, a0_.progress_state AS progress_state_21, a0_.soft_deleted AS soft_deleted_22, a0_.created_at AS created_at_23, a0_.updated_at AS updated_at_24, a0_.id AS id_25, a0_.budget_cost_complementary AS budget_cost_complementary_26, a0_.budget_cost_of_harvest AS budget_cost_of_harvest_27, a0_.budget_cost_of_maintenance AS budget_cost_of_maintenance_28, a0_.budget_cost_of_plantation AS budget_cost_of_plantation_29, a0_.budget_energy_industry_price AS budget_energy_industry_price_30, a0_.budget_price_of_barren AS budget_price_of_barren_31, a0_.budget_public_grant AS budget_public_grant_32, a0_.budget_public_grant_name AS budget_public_grant_name_33, a0_.budget_public_grant_year AS budget_public_grant_year_34, a0_.budget_year_of_barren_harvest AS budget_year_of_barren_harvest_35, a0_.context_afforestation_check AS context_afforestation_check_36, a0_.context_degradation_date AS context_degradation_date_37, a0_.context_emergency_approval AS context_emergency_approval_38, a0_.context_health_crisis AS context_health_crisis_39, a0_.context_expected_wood_income AS context_expected_wood_income_40, a0_.context_fire_occurred_recently AS context_fire_occurred_recently_41, a0_.context_fire_date AS context_fire_date_42, a0_.context_harvest_date AS context_harvest_date_43, a0_.context_low_wood_volume AS context_low_wood_volume_44, a0_.context_plantation_failure_check AS context_plantation_failure_check_45, a0_.context_recent_harvest AS context_recent_harvest_46, a0_.context_significant_tempest_damage AS context_significant_tempest_damage_47, a0_.context_significant_foliage_loss AS context_significant_foliage_loss_48, a0_.context_harvest_occured AS context_harvest_occured_49, a0_.context_tempest_date AS context_tempest_date_50 FROM assessment a0_ WHERE a0_.soft_deleted = ? ORDER BY a0_.updated_at DESC) dctrn_result) dctrn_table
Parameters:
[
  0
]
3 1.47 ms
SELECT DISTINCT id_25 FROM (SELECT DISTINCT id_25, updated_at_24 FROM (SELECT a0_.uuid AS uuid_0, a0_.aggreed_property_share AS aggreed_property_share_1, a0_.area AS area_2, ST_AsBinary(a0_.bounding) AS bounding_3, a0_.cadastral_parcels AS cadastral_parcels_4, a0_.creator_email AS creator_email_5, a0_.current_situation AS current_situation_6, a0_.discount_rate_fertility_missing AS discount_rate_fertility_missing_7, a0_.discount_rate_fire_risks AS discount_rate_fire_risks_8, a0_.foliage_loss_because_of_health_crisis AS foliage_loss_because_of_health_crisis_9, a0_.forester_can_edit AS forester_can_edit_10, a0_.forester_comment AS forester_comment_11, a0_.forester_validated_at AS forester_validated_at_12, a0_.lbc_method AS lbc_method_13, a0_.locality AS locality_14, a0_.locality_code AS locality_code_15, ST_AsBinary(a0_.locality_centroid) AS locality_centroid_16, a0_.name AS name_17, a0_.origin AS origin_18, a0_.progress AS progress_19, a0_.property_id AS property_id_20, a0_.progress_state AS progress_state_21, a0_.soft_deleted AS soft_deleted_22, a0_.created_at AS created_at_23, a0_.updated_at AS updated_at_24, a0_.id AS id_25, a0_.budget_cost_complementary AS budget_cost_complementary_26, a0_.budget_cost_of_harvest AS budget_cost_of_harvest_27, a0_.budget_cost_of_maintenance AS budget_cost_of_maintenance_28, a0_.budget_cost_of_plantation AS budget_cost_of_plantation_29, a0_.budget_energy_industry_price AS budget_energy_industry_price_30, a0_.budget_price_of_barren AS budget_price_of_barren_31, a0_.budget_public_grant AS budget_public_grant_32, a0_.budget_public_grant_name AS budget_public_grant_name_33, a0_.budget_public_grant_year AS budget_public_grant_year_34, a0_.budget_year_of_barren_harvest AS budget_year_of_barren_harvest_35, a0_.context_afforestation_check AS context_afforestation_check_36, a0_.context_degradation_date AS context_degradation_date_37, a0_.context_emergency_approval AS context_emergency_approval_38, a0_.context_health_crisis AS context_health_crisis_39, a0_.context_expected_wood_income AS context_expected_wood_income_40, a0_.context_fire_occurred_recently AS context_fire_occurred_recently_41, a0_.context_fire_date AS context_fire_date_42, a0_.context_harvest_date AS context_harvest_date_43, a0_.context_low_wood_volume AS context_low_wood_volume_44, a0_.context_plantation_failure_check AS context_plantation_failure_check_45, a0_.context_recent_harvest AS context_recent_harvest_46, a0_.context_significant_tempest_damage AS context_significant_tempest_damage_47, a0_.context_significant_foliage_loss AS context_significant_foliage_loss_48, a0_.context_harvest_occured AS context_harvest_occured_49, a0_.context_tempest_date AS context_tempest_date_50 FROM assessment a0_ WHERE a0_.soft_deleted = ?) dctrn_result_inner ORDER BY updated_at_24 DESC) dctrn_result LIMIT 25
Parameters:
[
  0
]
4 1.98 ms
SELECT a0_.uuid AS uuid_0, a0_.aggreed_property_share AS aggreed_property_share_1, a0_.area AS area_2, ST_AsBinary(a0_.bounding) AS bounding_3, a0_.cadastral_parcels AS cadastral_parcels_4, a0_.creator_email AS creator_email_5, a0_.current_situation AS current_situation_6, a0_.discount_rate_fertility_missing AS discount_rate_fertility_missing_7, a0_.discount_rate_fire_risks AS discount_rate_fire_risks_8, a0_.foliage_loss_because_of_health_crisis AS foliage_loss_because_of_health_crisis_9, a0_.forester_can_edit AS forester_can_edit_10, a0_.forester_comment AS forester_comment_11, a0_.forester_validated_at AS forester_validated_at_12, a0_.lbc_method AS lbc_method_13, a0_.locality AS locality_14, a0_.locality_code AS locality_code_15, ST_AsBinary(a0_.locality_centroid) AS locality_centroid_16, a0_.name AS name_17, a0_.origin AS origin_18, a0_.progress AS progress_19, a0_.property_id AS property_id_20, a0_.progress_state AS progress_state_21, a0_.soft_deleted AS soft_deleted_22, a0_.created_at AS created_at_23, a0_.updated_at AS updated_at_24, a0_.id AS id_25, a0_.budget_cost_complementary AS budget_cost_complementary_26, a0_.budget_cost_of_harvest AS budget_cost_of_harvest_27, a0_.budget_cost_of_maintenance AS budget_cost_of_maintenance_28, a0_.budget_cost_of_plantation AS budget_cost_of_plantation_29, a0_.budget_energy_industry_price AS budget_energy_industry_price_30, a0_.budget_price_of_barren AS budget_price_of_barren_31, a0_.budget_public_grant AS budget_public_grant_32, a0_.budget_public_grant_name AS budget_public_grant_name_33, a0_.budget_public_grant_year AS budget_public_grant_year_34, a0_.budget_year_of_barren_harvest AS budget_year_of_barren_harvest_35, a0_.context_afforestation_check AS context_afforestation_check_36, a0_.context_degradation_date AS context_degradation_date_37, a0_.context_emergency_approval AS context_emergency_approval_38, a0_.context_health_crisis AS context_health_crisis_39, a0_.context_expected_wood_income AS context_expected_wood_income_40, a0_.context_fire_occurred_recently AS context_fire_occurred_recently_41, a0_.context_fire_date AS context_fire_date_42, a0_.context_harvest_date AS context_harvest_date_43, a0_.context_low_wood_volume AS context_low_wood_volume_44, a0_.context_plantation_failure_check AS context_plantation_failure_check_45, a0_.context_recent_harvest AS context_recent_harvest_46, a0_.context_significant_tempest_damage AS context_significant_tempest_damage_47, a0_.context_significant_foliage_loss AS context_significant_foliage_loss_48, a0_.context_harvest_occured AS context_harvest_occured_49, a0_.context_tempest_date AS context_tempest_date_50, a0_.ibp_measure_id AS ibp_measure_id_51, a0_.project_id AS project_id_52, a0_.forester_id AS forester_id_53, a0_.forest_owner_id AS forest_owner_id_54, a0_.main_regrowth_species_id AS main_regrowth_species_id_55 FROM assessment a0_ WHERE a0_.soft_deleted = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.updated_at DESC
Parameters:
[
  0
  118
  132
  131
  130
  129
  128
  127
  126
  125
  123
  121
  120
  109
  111
  116
  117
  113
  112
  106
  108
  105
  83
  100
  98
  87
]
5 0.97 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  143
]
6 0.47 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  157
]
7 0.45 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  156
]
8 0.38 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  155
]
9 0.41 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  154
]
10 0.38 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  153
]
11 0.45 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  152
]
12 0.38 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  151
]
13 0.39 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  150
]
14 0.43 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  148
]
15 0.43 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  146
]
16 0.42 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  145
]
17 0.41 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  134
]
18 0.40 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  136
]
19 0.41 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  141
]
20 0.39 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  142
]
21 0.39 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  138
]
22 0.38 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  137
]
23 0.42 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  131
]
24 0.38 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  133
]
25 0.42 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  130
]
26 0.37 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  108
]
27 0.41 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  125
]
28 0.39 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  123
]
29 0.40 ms
SELECT t0.comment AS comment_1, t0.email AS email_2, t0.phone AS phone_3, t0.is_professional AS is_professional_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.address_address1 AS address_address1_8, t0.address_address2 AS address_address2_9, t0.address_postal_code AS address_postal_code_10, t0.address_post_office_box_number AS address_post_office_box_number_11, t0.address_country AS address_country_12, t0.address_areaLevel1 AS address_areaLevel1_13, t0.address_areaLevel2 AS address_areaLevel2_14, t0.address_locality AS address_locality_15, t0.person_honorific_prefix AS person_honorific_prefix_16, t0.person_given_name AS person_given_name_17, t0.person_family_name AS person_family_name_18, t0.orga_activity AS orga_activity_19, t0.orga_name AS orga_name_20, t0.orga_code AS orga_code_21, t0.orga_type AS orga_type_22 FROM forest_owner t0 WHERE t0.id = ?
Parameters:
[
  112
]

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\Assessment\Assessment 25
App\Entity\Project\ForestOwner 25
App\Entity\Contact\Forester 13
App\Entity\Assessment\IbpMeasure 5
App\Entity\Parameters\TreeSpecies 4
App\Entity\Project\Project 1