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

Query Metrics

11 Database Queries
9 Different statements
35.25 ms Query time
0 Invalid entities
246 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.92 ms
(28.15%)
1
SELECT p0_.code AS code_0, p0_.fertility AS fertility_1, p0_.greco AS greco_2, p0_.infos_alt AS infos_alt_3, p0_.juvenile_exponential AS juvenile_exponential_4, p0_.juvenile_alpha AS juvenile_alpha_5, p0_.juvenile_beta AS juvenile_beta_6, p0_.static_crown_factor AS static_crown_factor_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.id AS id_10, p0_.publishing_authors AS publishing_authors_11, p0_.publishing_name AS publishing_name_12, p0_.publishing_year AS publishing_year_13, p0_.tree_species_id AS tree_species_id_14 FROM params_yield_model p0_ WHERE p0_.tree_species_id IN (NULL) ORDER BY p0_.publishing_authors ASC, p0_.fertility ASC
Parameters:
[]
7.03 ms
(19.93%)
1
SELECT p0_.biomass_density AS biomass_density_0, p0_.category AS category_1, p0_.climessences_code AS climessences_code_2, p0_.code AS code_3, p0_.crown_factor AS crown_factor_4, p0_.default_timber_price AS default_timber_price_5, p0_.latin_binomial AS latin_binomial_6, p0_.latin_name AS latin_name_7, p0_.name AS name_8, p0_.referenced_in_lbc AS referenced_in_lbc_9, p0_.sawing_performance AS sawing_performance_10, p0_.substitution_factor AS substitution_factor_11, p0_.uuid AS uuid_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15 FROM params_tree_species p0_ WHERE p0_.category = ? OR p0_.category = ? ORDER BY p0_.name ASC
Parameters:
[
  "tree_category_resinous"
  "tree_category_deciduous"
]
4.72 ms
(13.39%)
1
SELECT t0.count AS count_1, t0.timber_price AS timber_price_2, t0.share AS share_3, t0.id AS id_4, t0.assessment_id AS assessment_id_5, t0.tree_species_id AS tree_species_id_6, t0.yield_model_id AS yield_model_id_7 FROM assessment_tree_species_attributes t0 WHERE t0.assessment_id = ? ORDER BY t0.share DESC
Parameters:
[
  118
]
3.94 ms
(11.18%)
1
SELECT p0_.administrative_comment AS administrative_comment_0, p0_.area AS area_1, p0_.area_planted AS area_planted_2, p0_.biodiversity_bonus AS biodiversity_bonus_3, p0_.bounding AS bounding_4, p0_.certifications AS certifications_5, p0_.contract_status AS contract_status_6, p0_.description AS description_7, p0_.description_co_benefits AS description_co_benefits_8, p0_.description_current AS description_current_9, p0_.description_ecology AS description_ecology_10, p0_.description_forestry AS description_forestry_11, p0_.description_funding AS description_funding_12, p0_.finished AS finished_13, p0_.funding_status AS funding_status_14, p0_.funding AS funding_15, p0_.location AS location_16, ST_AsBinary(p0_.locality_centroid) AS locality_centroid_17, p0_.name AS name_18, p0_.name_id AS name_id_19, p0_.operation_state AS operation_state_20, p0_.operation_start_planned AS operation_start_planned_21, p0_.operation_start_real AS operation_start_real_22, p0_.plantation_end AS plantation_end_23, p0_.planned_carbon_sequestration AS planned_carbon_sequestration_24, p0_.planned_operations AS planned_operations_25, p0_.planted_species AS planted_species_26, p0_.price_mini AS price_mini_27, p0_.price_suggested AS price_suggested_28, p0_.publishable AS publishable_29, p0_.recomputed_carbon_sequestration AS recomputed_carbon_sequestration_30, p0_.report_slug AS report_slug_31, p0_.stock_of_carbon AS stock_of_carbon_32, p0_.stock_of_carbon_taken AS stock_of_carbon_taken_33, p0_.stock_of_planted_trees AS stock_of_planted_trees_34, p0_.stock_of_planted_trees_taken AS stock_of_planted_trees_taken_35, p0_.slug AS slug_36, p0_.status AS status_37, p0_.subtitle AS subtitle_38, p0_.unit_price_of_carbon AS unit_price_of_carbon_39, p0_.updated_at AS updated_at_40, p0_.id AS id_41, p0_.property_created_at AS property_created_at_42, p0_.property_id AS property_id_43, p0_.property_name AS property_name_44, p0_.property_area_input AS property_area_input_45, p0_.property_area_geom AS property_area_geom_46, p0_.property_area_admin AS property_area_admin_47, p0_.property_locality_name AS property_locality_name_48, p0_.property_locality_national_code AS property_locality_national_code_49, p0_.lbc_decision_date AS lbc_decision_date_50, p0_.lbc_expected_decision_date AS lbc_expected_decision_date_51, p0_.lbc_file_date AS lbc_file_date_52, p0_.lbc_file_identifier AS lbc_file_identifier_53, p0_.lbc_method AS lbc_method_54, p0_.lbc_notification_date AS lbc_notification_date_55, p0_.lbc_status AS lbc_status_56, p0_.lbc_official_link AS lbc_official_link_57, p0_.assessment_id AS assessment_id_58, p0_.forester_id AS forester_id_59, p0_.forester_owner_id AS forester_owner_id_60 FROM project p0_ WHERE p0_.status IN (?, ?) ORDER BY p0_.updated_at DESC
Parameters:
[
  "assess_progress_working"
  "assess_progress_selected"
]
3.89 ms
(11.04%)
2
SELECT t0.area AS area_1, t0.share_unit AS share_unit_2, t0.stems_per_ha AS stems_per_ha_3, t0.id AS id_4, t0.assessment_id AS assessment_id_5 FROM assessment_operation_area t0 WHERE t0.assessment_id = ?
Parameters:
[
  118
]
1.91 ms
(5.42%)
1
SELECT p0_.administrative_comment AS administrative_comment_0, p0_.area AS area_1, p0_.area_planted AS area_planted_2, p0_.biodiversity_bonus AS biodiversity_bonus_3, p0_.bounding AS bounding_4, p0_.certifications AS certifications_5, p0_.contract_status AS contract_status_6, p0_.description AS description_7, p0_.description_co_benefits AS description_co_benefits_8, p0_.description_current AS description_current_9, p0_.description_ecology AS description_ecology_10, p0_.description_forestry AS description_forestry_11, p0_.description_funding AS description_funding_12, p0_.finished AS finished_13, p0_.funding_status AS funding_status_14, p0_.funding AS funding_15, p0_.location AS location_16, ST_AsBinary(p0_.locality_centroid) AS locality_centroid_17, p0_.name AS name_18, p0_.name_id AS name_id_19, p0_.operation_state AS operation_state_20, p0_.operation_start_planned AS operation_start_planned_21, p0_.operation_start_real AS operation_start_real_22, p0_.plantation_end AS plantation_end_23, p0_.planned_carbon_sequestration AS planned_carbon_sequestration_24, p0_.planned_operations AS planned_operations_25, p0_.planted_species AS planted_species_26, p0_.price_mini AS price_mini_27, p0_.price_suggested AS price_suggested_28, p0_.publishable AS publishable_29, p0_.recomputed_carbon_sequestration AS recomputed_carbon_sequestration_30, p0_.report_slug AS report_slug_31, p0_.stock_of_carbon AS stock_of_carbon_32, p0_.stock_of_carbon_taken AS stock_of_carbon_taken_33, p0_.stock_of_planted_trees AS stock_of_planted_trees_34, p0_.stock_of_planted_trees_taken AS stock_of_planted_trees_taken_35, p0_.slug AS slug_36, p0_.status AS status_37, p0_.subtitle AS subtitle_38, p0_.unit_price_of_carbon AS unit_price_of_carbon_39, p0_.updated_at AS updated_at_40, p0_.id AS id_41, p0_.property_created_at AS property_created_at_42, p0_.property_id AS property_id_43, p0_.property_name AS property_name_44, p0_.property_area_input AS property_area_input_45, p0_.property_area_geom AS property_area_geom_46, p0_.property_area_admin AS property_area_admin_47, p0_.property_locality_name AS property_locality_name_48, p0_.property_locality_national_code AS property_locality_national_code_49, p0_.lbc_decision_date AS lbc_decision_date_50, p0_.lbc_expected_decision_date AS lbc_expected_decision_date_51, p0_.lbc_file_date AS lbc_file_date_52, p0_.lbc_file_identifier AS lbc_file_identifier_53, p0_.lbc_method AS lbc_method_54, p0_.lbc_notification_date AS lbc_notification_date_55, p0_.lbc_status AS lbc_status_56, p0_.lbc_official_link AS lbc_official_link_57, p0_.assessment_id AS assessment_id_58, p0_.forester_id AS forester_id_59, p0_.forester_owner_id AS forester_owner_id_60 FROM project p0_
Parameters:
[]
1.82 ms
(5.16%)
2
SELECT t0.climessences_code AS climessences_code_1, t0.comments AS comments_2, t0.precious_species AS precious_species_3, t0.target_species AS target_species_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.share_value AS share_value_8, t0.share_unit AS share_unit_9, t0.operation_area_id AS operation_area_id_10, t0.tree_species_id AS tree_species_id_11 FROM assessment_operation_measure t0 WHERE t0.operation_area_id = ?
Parameters:
[
  1038
]
1.13 ms
(3.21%)
1
SELECT t0.uuid AS uuid_1, t0.aggreed_property_share AS aggreed_property_share_2, t0.area AS area_3, ST_AsBinary(t0.bounding) AS bounding_4, t0.cadastral_parcels AS cadastral_parcels_5, t0.creator_email AS creator_email_6, t0.current_situation AS current_situation_7, t0.discount_rate_fertility_missing AS discount_rate_fertility_missing_8, t0.discount_rate_fire_risks AS discount_rate_fire_risks_9, t0.foliage_loss_because_of_health_crisis AS foliage_loss_because_of_health_crisis_10, t0.forester_can_edit AS forester_can_edit_11, t0.forester_comment AS forester_comment_12, t0.forester_validated_at AS forester_validated_at_13, t0.lbc_method AS lbc_method_14, t0.locality AS locality_15, t0.locality_code AS locality_code_16, ST_AsBinary(t0.locality_centroid) AS locality_centroid_17, t0.name AS name_18, t0.origin AS origin_19, t0.progress AS progress_20, t0.property_id AS property_id_21, t0.progress_state AS progress_state_22, t0.soft_deleted AS soft_deleted_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.id AS id_26, t0.budget_cost_complementary AS budget_cost_complementary_27, t0.budget_cost_of_harvest AS budget_cost_of_harvest_28, t0.budget_cost_of_maintenance AS budget_cost_of_maintenance_29, t0.budget_cost_of_plantation AS budget_cost_of_plantation_30, t0.budget_energy_industry_price AS budget_energy_industry_price_31, t0.budget_price_of_barren AS budget_price_of_barren_32, t0.budget_public_grant AS budget_public_grant_33, t0.budget_public_grant_name AS budget_public_grant_name_34, t0.budget_public_grant_year AS budget_public_grant_year_35, t0.budget_year_of_barren_harvest AS budget_year_of_barren_harvest_36, t0.context_afforestation_check AS context_afforestation_check_37, t0.context_degradation_date AS context_degradation_date_38, t0.context_emergency_approval AS context_emergency_approval_39, t0.context_health_crisis AS context_health_crisis_40, t0.context_expected_wood_income AS context_expected_wood_income_41, t0.context_fire_occurred_recently AS context_fire_occurred_recently_42, t0.context_fire_date AS context_fire_date_43, t0.context_harvest_date AS context_harvest_date_44, t0.context_low_wood_volume AS context_low_wood_volume_45, t0.context_plantation_failure_check AS context_plantation_failure_check_46, t0.context_recent_harvest AS context_recent_harvest_47, t0.context_significant_tempest_damage AS context_significant_tempest_damage_48, t0.context_significant_foliage_loss AS context_significant_foliage_loss_49, t0.context_harvest_occured AS context_harvest_occured_50, t0.context_tempest_date AS context_tempest_date_51, t0.ibp_measure_id AS ibp_measure_id_52, t0.project_id AS project_id_53, t0.forester_id AS forester_id_54, t0.forest_owner_id AS forest_owner_id_55, t0.main_regrowth_species_id AS main_regrowth_species_id_56 FROM assessment t0 WHERE t0.id = ?
Parameters:
[
  "118"
]
0.89 ms
(2.52%)
1
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
]

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\Parameters\TreeSpecies 126
App\Entity\Project\Project 60
App\Entity\Project\ForestOwner 42
App\Entity\Contact\Forester 14
App\Entity\Assessment\Assessment 3
App\Entity\Assessment\OperationArea 1

Entities Mapping

Class Mapping errors
App\Entity\Assessment\Embeddable\Budget No errors.
App\Entity\Assessment\Embeddable\Context No errors.
App\Entity\Assessment\Assessment No errors.
App\Entity\Assessment\Embeddable\DendroMicroHabitats No errors.
App\Entity\Assessment\Embeddable\IbpScore No errors.
App\Entity\Assessment\IbpMeasure No errors.
App\Entity\Project\Embeddable\Area No errors.
App\Entity\Project\Embeddable\Locality No errors.
App\Entity\Project\Embeddable\Property No errors.
App\Entity\Project\Embeddable\LbcCertification No errors.
App\Entity\Project\Project No errors.
App\Entity\Contact\AbstractContact No errors.
Actiforest\Component\User\Model\Embeddable\Person No errors.
App\Entity\Contact\Forester No errors.
Actiforest\Component\User\Model\Embeddable\PostalAddress No errors.
Actiforest\Component\User\Model\Embeddable\Organization No errors.
App\Entity\Project\ForestOwner No errors.
App\Entity\Parameters\TreeSpecies No errors.
App\Entity\Assessment\OperationArea No errors.
App\Entity\Assessment\TreeSpeciesAttributes No errors.
App\Entity\Parameters\Embeddable\Publishing No errors.
App\Entity\Parameters\YieldModel\YieldModel No errors.
App\Entity\Assessment\Embeddable\AbstractDimension No errors.
App\Entity\Assessment\Embeddable\SpeciesShare No errors.
App\Entity\Assessment\OperationMeasure No errors.
App\Entity\Funding\ProjectFunding No errors.
App\Entity\Project\Embeddable\ExifData No errors.
App\Entity\Project\Embeddable\Parcel No errors.
App\Entity\Project\ProjectImage No errors.
App\Entity\Project\ProjectReport No errors.