https://test.api.fryd.app/api/v3/crops/12

Query Metrics

34 Database Queries
21 Different statements
4.16 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.12 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.date_created AS date_created_3, t0.expires_at AS expires_at_4, t0.user_id AS user_id_5 FROM token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  false
]
2 0.24 ms
SELECT c0_.id AS id_0, c0_.identifier AS identifier_1, c0_.name AS name_2, c0_.latin_name AS latin_name_3, c0_.description AS description_4, c0_.short_description AS short_description_5, c0_.origin AS origin_6, c0_.growing_tipps AS growing_tipps_7, c0_.cultivation_cycles AS cultivation_cycles_8, c0_.germination_duration AS germination_duration_9, c0_.germination_season AS germination_season_10, c0_.precultivation_duration AS precultivation_duration_11, c0_.precultivation_season AS precultivation_season_12, c0_.has_precultivation AS has_precultivation_13, c0_.growth_duration AS growth_duration_14, c0_.growth_season AS growth_season_15, c0_.harvest_duration AS harvest_duration_16, c0_.harvest_season AS harvest_season_17, c0_.lightscore AS lightscore_18, c0_.grid_length AS grid_length_19, c0_.grid_width AS grid_width_20, c0_.harvest_amount AS harvest_amount_21, c0_.nutrient_demand AS nutrient_demand_22, c0_.lighting_demand AS lighting_demand_23, c0_.water_demand AS water_demand_24, c0_.seeding_depth AS seeding_depth_25, c0_.seeding_distance AS seeding_distance_26, c0_.spread AS spread_27, c0_.compatibility AS compatibility_28, c0_.plant_in_rows AS plant_in_rows_29, c0_.f1_hybrid AS f1_hybrid_30, c0_.row_distance AS row_distance_31, c0_.fertilizer_type AS fertilizer_type_32, c0_.user_crop_settings AS user_crop_settings_33, c0_.ground_type AS ground_type_34, c0_.cold_resistant AS cold_resistant_35, c0_.is_shared AS is_shared_36, c0_.is_approved AS is_approved_37, c0_.date_created AS date_created_38, c0_.date_updated AS date_updated_39, c0_.popularity AS popularity_40, c0_.seasons AS seasons_41, c0_.dynamic_link AS dynamic_link_42, c0_.cultivation_break AS cultivation_break_43, c0_.germination_type AS germination_type_44, c0_.germination_temperature AS germination_temperature_45, c0_.shop_category_url AS shop_category_url_46, c0_.growth_habit AS growth_habit_47, c0_.is_green_manure AS is_green_manure_48, c0_.gtin_barcode AS gtin_barcode_49, c0_.cropcategory_id AS cropcategory_id_50, c0_.parent_crop_id AS parent_crop_id_51, c0_.user_id AS user_id_52, c0_.plantfamily_id AS plantfamily_id_53, c0_.climatezone_id AS climatezone_id_54 FROM crop c0_ WHERE c0_.id = ? AND ((c0_.user_id IS NULL OR c0_.is_shared = 1 OR c0_.user_id = ?))
Parameters:
[
  "12"
  null
]
3 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.growing_tipps AS growing_tipps_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.origin AS origin_7, t0.short_description AS short_description_8, t0.auto_translated_fields AS auto_translated_fields_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM crop_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
4 0.10 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.crop_id AS crop_id_3, t0.disease_id AS disease_id_4 FROM crop_disease t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
5 0.09 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.pest_id AS pest_id_3, t0.crop_id AS crop_id_4 FROM crop_pest t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
6 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latin_name AS latin_name_3, t0.identifier AS identifier_4, t0.category AS category_5, t0.description AS description_6, t0.countermeasure AS countermeasure_7, t0.date_created AS date_created_8, t0.content_blocks AS content_blocks_9, t0.content_options AS content_options_10, t0.external_id AS external_id_11 FROM pest t0 WHERE t0.id = ?
Parameters:
[
  12
]
7 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content_blocks AS content_blocks_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM pest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
8 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latin_name AS latin_name_3, t0.identifier AS identifier_4, t0.category AS category_5, t0.description AS description_6, t0.countermeasure AS countermeasure_7, t0.date_created AS date_created_8, t0.content_blocks AS content_blocks_9, t0.content_options AS content_options_10, t0.external_id AS external_id_11 FROM pest t0 WHERE t0.id = ?
Parameters:
[
  5
]
9 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content_blocks AS content_blocks_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM pest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
10 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latin_name AS latin_name_3, t0.identifier AS identifier_4, t0.category AS category_5, t0.description AS description_6, t0.countermeasure AS countermeasure_7, t0.date_created AS date_created_8, t0.content_blocks AS content_blocks_9, t0.content_options AS content_options_10, t0.external_id AS external_id_11 FROM pest t0 WHERE t0.id = ?
Parameters:
[
  28
]
11 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content_blocks AS content_blocks_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM pest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  28
]
12 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latin_name AS latin_name_3, t0.identifier AS identifier_4, t0.category AS category_5, t0.description AS description_6, t0.countermeasure AS countermeasure_7, t0.date_created AS date_created_8, t0.content_blocks AS content_blocks_9, t0.content_options AS content_options_10, t0.external_id AS external_id_11 FROM pest t0 WHERE t0.id = ?
Parameters:
[
  62
]
13 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content_blocks AS content_blocks_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM pest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  62
]
14 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latin_name AS latin_name_3, t0.identifier AS identifier_4, t0.category AS category_5, t0.description AS description_6, t0.countermeasure AS countermeasure_7, t0.date_created AS date_created_8, t0.content_blocks AS content_blocks_9, t0.content_options AS content_options_10, t0.external_id AS external_id_11 FROM pest t0 WHERE t0.id = ?
Parameters:
[
  56
]
15 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content_blocks AS content_blocks_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM pest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  56
]
16 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.parent_id AS parent_id_4 FROM cropcategory t0 WHERE t0.id = ?
Parameters:
[
  54
]
17 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.auto_translated_fields AS auto_translated_fields_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM cropcategory_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  54
]
18 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.settings AS settings_4, t0.description AS description_5, t0.cultivation_break AS cultivation_break_6, t0.nutrient_demand AS nutrient_demand_7, t0.latin_name AS latin_name_8 FROM plantfamily t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.auto_translated_fields AS auto_translated_fields_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM plantfamily_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
20 0.08 ms
SELECT t0.id AS id_1, t0.days_start AS days_start_2, t0.days_end AS days_end_3, t0.repeat_days AS repeat_days_4, t0.title AS title_5, t0.type AS type_6, t0.text AS text_7, t0.notification_text AS notification_text_8, t0.additional_data AS additional_data_9, t0.date_created AS date_created_10, t0.priority AS priority_11, t0.date_updated AS date_updated_12, t0.crop_id AS crop_id_13, t0.user_id AS user_id_14 FROM cropaction t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
21 0.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  44476
]
22 0.07 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  44477
]
23 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  45572
]
24 0.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  45573
]
25 0.07 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  45574
]
26 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.notification_text AS notification_text_4, t0.additional_data AS additional_data_5, t0.auto_translated_fields AS auto_translated_fields_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM cropaction_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  45575
]
27 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.first_frost_at AS first_frost_at_4, t0.last_frost_at AS last_frost_at_5, t0.created_at AS created_at_6, t0.min_winter_temperature AS min_winter_temperature_7, t0.max_winter_temperature AS max_winter_temperature_8 FROM climatezone t0 WHERE t0.id = ?
Parameters:
[
  15
]
28 0.26 ms
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.path AS path_2, i0_.reference_id AS reference_id_3, i0_.license AS license_4, i0_.date_created AS date_created_5, i0_.use_s3 AS use_s3_6, i0_.hash AS hash_7, i0_.user_id AS user_id_8 FROM image i0_ WHERE i0_.type IN ('crop', 'package')
Parameters:
[]
29 0.19 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.manual AS manual_3, t0.crop_id AS crop_id_4, t0.shoparticle_id AS shoparticle_id_5 FROM shoparticle_crop t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
30 0.12 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.date_created AS date_created_4, t0.crop_id AS crop_id_5, t0.user_id AS user_id_6 FROM crop_rating t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
31 0.09 ms
SELECT t0.id AS id_1, t0.synonym AS synonym_2, t0.date_created AS date_created_3, t0.language AS language_4, t0.crop_id AS crop_id_5 FROM crop_synonym t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
32 0.67 ms
SELECT c0_.id AS id_0, c0_.identifier AS identifier_1, c0_.name AS name_2, c1_.name AS name_3 FROM crop c0_ LEFT JOIN crop_translation c1_ ON (c1_.translatable_id = c0_.id AND c1_.locale = ?) WHERE c0_.parent_crop_id IS NULL
Parameters:
[
  "de"
]
33 0.20 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.crop_id AS crop_id_4, t0.property_id AS property_id_5 FROM crop_property t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]
34 0.14 ms
SELECT t0.id AS id_1, t0.suggested_edit AS suggested_edit_2, t0.date_applied AS date_applied_3, t0.created_by_alphabeet AS created_by_alphabeet_4, t0.needs_moderator AS needs_moderator_5, t0.date_read AS date_read_6, t0.date_created AS date_created_7, t0.feedback AS feedback_8, t0.declined AS declined_9, t0.locale AS locale_10, t0.approved_by AS approved_by_11, t0.declined_by AS declined_by_12, t0.crop_id AS crop_id_13, t0.user_id AS user_id_14 FROM crop_edit t0 WHERE t0.crop_id = ?
Parameters:
[
  12
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Token No errors.
App\Entity\User
  • The field App\Entity\User#postLikes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PostLike#user does not contain the required 'inversedBy="postLikes"' attribute.
App\Entity\Crop
  • The mappings App\Entity\Crop#cropTranslation and App\Entity\CropTranslation#translatable are inconsistent with each other.
App\Entity\Patchfield No errors.
App\Entity\CropPest No errors.
App\Entity\CropDisease No errors.
App\Entity\Cropaction No errors.
App\Entity\PlanCrop No errors.
App\Entity\ShoparticleCrop No errors.
App\Entity\FavoriteCrop No errors.
App\Entity\CropSynonym No errors.
App\Entity\CropEdit No errors.
App\Entity\CropRating No errors.
App\Entity\Cropcategory No errors.
App\Entity\Plantfamily No errors.
App\Entity\CropProperty No errors.
App\Entity\CropTranslation No errors.
App\Entity\ShoparticleBlockentry No errors.
App\Entity\CropImage No errors.
App\Entity\Climatezone No errors.
App\Entity\Disease
  • The mappings App\Entity\Disease#diseaseTranslation and App\Entity\DiseaseTranslation#translatable are inconsistent with each other.
App\Entity\Pest
  • The mappings App\Entity\Pest#pestTranslation and App\Entity\PestTranslation#translatable are inconsistent with each other.
App\Entity\PestTranslation No errors.
App\Entity\CropcategoryTranslation No errors.
App\Entity\PlantfamilyTranslation No errors.
App\Entity\CropactionTranslation No errors.
App\Entity\ClimatezoneRaster No errors.
App\Entity\Image No errors.
App\Entity\Shoparticle No errors.
App\Entity\Property No errors.