Query Metrics
11
Database Queries
9
Different statements
35.25 ms
Query time
0
Invalid entities
246
Managed entities
Grouped Statements
| 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 |