Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.51 ms Query time

9 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.13 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`] View formatted query View runnable query Explain query 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 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 = 0 LIMIT 1;
2	0.56 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.reference_id AS reference_id_4, t0.license AS license_5, t0.date_created AS date_created_6, t0.use_s3 AS use_s3_7, t0.hash AS hash_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ? Parameters: [`"310"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.reference_id AS reference_id_4, t0.license AS license_5, t0.date_created AS date_created_6, t0.use_s3 AS use_s3_7, t0.hash AS hash_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.reference_id AS reference_id_4, t0.license AS license_5, t0.date_created AS date_created_6, t0.use_s3 AS use_s3_7, t0.hash AS hash_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = '310';
3	0.82 ms	SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.latin_name AS latin_name_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.origin AS origin_7, t0.growing_tipps AS growing_tipps_8, t0.cultivation_cycles AS cultivation_cycles_9, t0.germination_duration AS germination_duration_10, t0.germination_season AS germination_season_11, t0.precultivation_duration AS precultivation_duration_12, t0.precultivation_season AS precultivation_season_13, t0.has_precultivation AS has_precultivation_14, t0.growth_duration AS growth_duration_15, t0.growth_season AS growth_season_16, t0.harvest_duration AS harvest_duration_17, t0.harvest_season AS harvest_season_18, t0.lightscore AS lightscore_19, t0.grid_length AS grid_length_20, t0.grid_width AS grid_width_21, t0.harvest_amount AS harvest_amount_22, t0.nutrient_demand AS nutrient_demand_23, t0.lighting_demand AS lighting_demand_24, t0.water_demand AS water_demand_25, t0.seeding_depth AS seeding_depth_26, t0.seeding_distance AS seeding_distance_27, t0.spread AS spread_28, t0.compatibility AS compatibility_29, t0.plant_in_rows AS plant_in_rows_30, t0.f1_hybrid AS f1_hybrid_31, t0.row_distance AS row_distance_32, t0.fertilizer_type AS fertilizer_type_33, t0.user_crop_settings AS user_crop_settings_34, t0.ground_type AS ground_type_35, t0.cold_resistant AS cold_resistant_36, t0.is_shared AS is_shared_37, t0.is_approved AS is_approved_38, t0.date_created AS date_created_39, t0.date_updated AS date_updated_40, t0.popularity AS popularity_41, t0.seasons AS seasons_42, t0.dynamic_link AS dynamic_link_43, t0.cultivation_break AS cultivation_break_44, t0.germination_type AS germination_type_45, t0.germination_temperature AS germination_temperature_46, t0.shop_category_url AS shop_category_url_47, t0.growth_habit AS growth_habit_48, t0.is_green_manure AS is_green_manure_49, t0.gtin_barcode AS gtin_barcode_50, t0.cropcategory_id AS cropcategory_id_51, t0.parent_crop_id AS parent_crop_id_52, t0.user_id AS user_id_53, t0.plantfamily_id AS plantfamily_id_54, t0.climatezone_id AS climatezone_id_55 FROM crop t0 WHERE t0.id = ? Parameters: [`457`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.latin_name AS latin_name_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.origin AS origin_7, t0.growing_tipps AS growing_tipps_8, t0.cultivation_cycles AS cultivation_cycles_9, t0.germination_duration AS germination_duration_10, t0.germination_season AS germination_season_11, t0.precultivation_duration AS precultivation_duration_12, t0.precultivation_season AS precultivation_season_13, t0.has_precultivation AS has_precultivation_14, t0.growth_duration AS growth_duration_15, t0.growth_season AS growth_season_16, t0.harvest_duration AS harvest_duration_17, t0.harvest_season AS harvest_season_18, t0.lightscore AS lightscore_19, t0.grid_length AS grid_length_20, t0.grid_width AS grid_width_21, t0.harvest_amount AS harvest_amount_22, t0.nutrient_demand AS nutrient_demand_23, t0.lighting_demand AS lighting_demand_24, t0.water_demand AS water_demand_25, t0.seeding_depth AS seeding_depth_26, t0.seeding_distance AS seeding_distance_27, t0.spread AS spread_28, t0.compatibility AS compatibility_29, t0.plant_in_rows AS plant_in_rows_30, t0.f1_hybrid AS f1_hybrid_31, t0.row_distance AS row_distance_32, t0.fertilizer_type AS fertilizer_type_33, t0.user_crop_settings AS user_crop_settings_34, t0.ground_type AS ground_type_35, t0.cold_resistant AS cold_resistant_36, t0.is_shared AS is_shared_37, t0.is_approved AS is_approved_38, t0.date_created AS date_created_39, t0.date_updated AS date_updated_40, t0.popularity AS popularity_41, t0.seasons AS seasons_42, t0.dynamic_link AS dynamic_link_43, t0.cultivation_break AS cultivation_break_44, t0.germination_type AS germination_type_45, t0.germination_temperature AS germination_temperature_46, t0.shop_category_url AS shop_category_url_47, t0.growth_habit AS growth_habit_48, t0.is_green_manure AS is_green_manure_49, t0.gtin_barcode AS gtin_barcode_50, t0.cropcategory_id AS cropcategory_id_51, t0.parent_crop_id AS parent_crop_id_52, t0.user_id AS user_id_53, t0.plantfamily_id AS plantfamily_id_54, t0.climatezone_id AS climatezone_id_55 FROM crop t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.latin_name AS latin_name_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.origin AS origin_7, t0.growing_tipps AS growing_tipps_8, t0.cultivation_cycles AS cultivation_cycles_9, t0.germination_duration AS germination_duration_10, t0.germination_season AS germination_season_11, t0.precultivation_duration AS precultivation_duration_12, t0.precultivation_season AS precultivation_season_13, t0.has_precultivation AS has_precultivation_14, t0.growth_duration AS growth_duration_15, t0.growth_season AS growth_season_16, t0.harvest_duration AS harvest_duration_17, t0.harvest_season AS harvest_season_18, t0.lightscore AS lightscore_19, t0.grid_length AS grid_length_20, t0.grid_width AS grid_width_21, t0.harvest_amount AS harvest_amount_22, t0.nutrient_demand AS nutrient_demand_23, t0.lighting_demand AS lighting_demand_24, t0.water_demand AS water_demand_25, t0.seeding_depth AS seeding_depth_26, t0.seeding_distance AS seeding_distance_27, t0.spread AS spread_28, t0.compatibility AS compatibility_29, t0.plant_in_rows AS plant_in_rows_30, t0.f1_hybrid AS f1_hybrid_31, t0.row_distance AS row_distance_32, t0.fertilizer_type AS fertilizer_type_33, t0.user_crop_settings AS user_crop_settings_34, t0.ground_type AS ground_type_35, t0.cold_resistant AS cold_resistant_36, t0.is_shared AS is_shared_37, t0.is_approved AS is_approved_38, t0.date_created AS date_created_39, t0.date_updated AS date_updated_40, t0.popularity AS popularity_41, t0.seasons AS seasons_42, t0.dynamic_link AS dynamic_link_43, t0.cultivation_break AS cultivation_break_44, t0.germination_type AS germination_type_45, t0.germination_temperature AS germination_temperature_46, t0.shop_category_url AS shop_category_url_47, t0.growth_habit AS growth_habit_48, t0.is_green_manure AS is_green_manure_49, t0.gtin_barcode AS gtin_barcode_50, t0.cropcategory_id AS cropcategory_id_51, t0.parent_crop_id AS parent_crop_id_52, t0.user_id AS user_id_53, t0.plantfamily_id AS plantfamily_id_54, t0.climatezone_id AS climatezone_id_55 FROM crop t0 WHERE t0.id = 457;

#▲

Time

Info

0.13 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
]

View formatted query View runnable query Explain query

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

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 = 0 LIMIT 1;

0.56 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.reference_id AS reference_id_4, t0.license AS license_5, t0.date_created AS date_created_6, t0.use_s3 AS use_s3_7, t0.hash AS hash_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?

Parameters:

[
  "310"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.reference_id AS reference_id_4,
  t0.license AS license_5,
  t0.date_created AS date_created_6,
  t0.use_s3 AS use_s3_7,
  t0.hash AS hash_8,
  t0.user_id AS user_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.reference_id AS reference_id_4, t0.license AS license_5, t0.date_created AS date_created_6, t0.use_s3 AS use_s3_7, t0.hash AS hash_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = '310';

0.82 ms

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.latin_name AS latin_name_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.origin AS origin_7, t0.growing_tipps AS growing_tipps_8, t0.cultivation_cycles AS cultivation_cycles_9, t0.germination_duration AS germination_duration_10, t0.germination_season AS germination_season_11, t0.precultivation_duration AS precultivation_duration_12, t0.precultivation_season AS precultivation_season_13, t0.has_precultivation AS has_precultivation_14, t0.growth_duration AS growth_duration_15, t0.growth_season AS growth_season_16, t0.harvest_duration AS harvest_duration_17, t0.harvest_season AS harvest_season_18, t0.lightscore AS lightscore_19, t0.grid_length AS grid_length_20, t0.grid_width AS grid_width_21, t0.harvest_amount AS harvest_amount_22, t0.nutrient_demand AS nutrient_demand_23, t0.lighting_demand AS lighting_demand_24, t0.water_demand AS water_demand_25, t0.seeding_depth AS seeding_depth_26, t0.seeding_distance AS seeding_distance_27, t0.spread AS spread_28, t0.compatibility AS compatibility_29, t0.plant_in_rows AS plant_in_rows_30, t0.f1_hybrid AS f1_hybrid_31, t0.row_distance AS row_distance_32, t0.fertilizer_type AS fertilizer_type_33, t0.user_crop_settings AS user_crop_settings_34, t0.ground_type AS ground_type_35, t0.cold_resistant AS cold_resistant_36, t0.is_shared AS is_shared_37, t0.is_approved AS is_approved_38, t0.date_created AS date_created_39, t0.date_updated AS date_updated_40, t0.popularity AS popularity_41, t0.seasons AS seasons_42, t0.dynamic_link AS dynamic_link_43, t0.cultivation_break AS cultivation_break_44, t0.germination_type AS germination_type_45, t0.germination_temperature AS germination_temperature_46, t0.shop_category_url AS shop_category_url_47, t0.growth_habit AS growth_habit_48, t0.is_green_manure AS is_green_manure_49, t0.gtin_barcode AS gtin_barcode_50, t0.cropcategory_id AS cropcategory_id_51, t0.parent_crop_id AS parent_crop_id_52, t0.user_id AS user_id_53, t0.plantfamily_id AS plantfamily_id_54, t0.climatezone_id AS climatezone_id_55 FROM crop t0 WHERE t0.id = ?

Parameters:

[
  457
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.latin_name AS latin_name_4,
  t0.description AS description_5,
  t0.short_description AS short_description_6,
  t0.origin AS origin_7,
  t0.growing_tipps AS growing_tipps_8,
  t0.cultivation_cycles AS cultivation_cycles_9,
  t0.germination_duration AS germination_duration_10,
  t0.germination_season AS germination_season_11,
  t0.precultivation_duration AS precultivation_duration_12,
  t0.precultivation_season AS precultivation_season_13,
  t0.has_precultivation AS has_precultivation_14,
  t0.growth_duration AS growth_duration_15,
  t0.growth_season AS growth_season_16,
  t0.harvest_duration AS harvest_duration_17,
  t0.harvest_season AS harvest_season_18,
  t0.lightscore AS lightscore_19,
  t0.grid_length AS grid_length_20,
  t0.grid_width AS grid_width_21,
  t0.harvest_amount AS harvest_amount_22,
  t0.nutrient_demand AS nutrient_demand_23,
  t0.lighting_demand AS lighting_demand_24,
  t0.water_demand AS water_demand_25,
  t0.seeding_depth AS seeding_depth_26,
  t0.seeding_distance AS seeding_distance_27,
  t0.spread AS spread_28,
  t0.compatibility AS compatibility_29,
  t0.plant_in_rows AS plant_in_rows_30,
  t0.f1_hybrid AS f1_hybrid_31,
  t0.row_distance AS row_distance_32,
  t0.fertilizer_type AS fertilizer_type_33,
  t0.user_crop_settings AS user_crop_settings_34,
  t0.ground_type AS ground_type_35,
  t0.cold_resistant AS cold_resistant_36,
  t0.is_shared AS is_shared_37,
  t0.is_approved AS is_approved_38,
  t0.date_created AS date_created_39,
  t0.date_updated AS date_updated_40,
  t0.popularity AS popularity_41,
  t0.seasons AS seasons_42,
  t0.dynamic_link AS dynamic_link_43,
  t0.cultivation_break AS cultivation_break_44,
  t0.germination_type AS germination_type_45,
  t0.germination_temperature AS germination_temperature_46,
  t0.shop_category_url AS shop_category_url_47,
  t0.growth_habit AS growth_habit_48,
  t0.is_green_manure AS is_green_manure_49,
  t0.gtin_barcode AS gtin_barcode_50,
  t0.cropcategory_id AS cropcategory_id_51,
  t0.parent_crop_id AS parent_crop_id_52,
  t0.user_id AS user_id_53,
  t0.plantfamily_id AS plantfamily_id_54,
  t0.climatezone_id AS climatezone_id_55
FROM
  crop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.latin_name AS latin_name_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.origin AS origin_7, t0.growing_tipps AS growing_tipps_8, t0.cultivation_cycles AS cultivation_cycles_9, t0.germination_duration AS germination_duration_10, t0.germination_season AS germination_season_11, t0.precultivation_duration AS precultivation_duration_12, t0.precultivation_season AS precultivation_season_13, t0.has_precultivation AS has_precultivation_14, t0.growth_duration AS growth_duration_15, t0.growth_season AS growth_season_16, t0.harvest_duration AS harvest_duration_17, t0.harvest_season AS harvest_season_18, t0.lightscore AS lightscore_19, t0.grid_length AS grid_length_20, t0.grid_width AS grid_width_21, t0.harvest_amount AS harvest_amount_22, t0.nutrient_demand AS nutrient_demand_23, t0.lighting_demand AS lighting_demand_24, t0.water_demand AS water_demand_25, t0.seeding_depth AS seeding_depth_26, t0.seeding_distance AS seeding_distance_27, t0.spread AS spread_28, t0.compatibility AS compatibility_29, t0.plant_in_rows AS plant_in_rows_30, t0.f1_hybrid AS f1_hybrid_31, t0.row_distance AS row_distance_32, t0.fertilizer_type AS fertilizer_type_33, t0.user_crop_settings AS user_crop_settings_34, t0.ground_type AS ground_type_35, t0.cold_resistant AS cold_resistant_36, t0.is_shared AS is_shared_37, t0.is_approved AS is_approved_38, t0.date_created AS date_created_39, t0.date_updated AS date_updated_40, t0.popularity AS popularity_41, t0.seasons AS seasons_42, t0.dynamic_link AS dynamic_link_43, t0.cultivation_break AS cultivation_break_44, t0.germination_type AS germination_type_45, t0.germination_temperature AS germination_temperature_46, t0.shop_category_url AS shop_category_url_47, t0.growth_habit AS growth_habit_48, t0.is_green_manure AS is_green_manure_49, t0.gtin_barcode AS gtin_barcode_50, t0.cropcategory_id AS cropcategory_id_51, t0.parent_crop_id AS parent_crop_id_52, t0.user_id AS user_id_53, t0.plantfamily_id AS plantfamily_id_54, t0.climatezone_id AS climatezone_id_55 FROM crop t0 WHERE t0.id = 457;

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\Image	No errors.
App\Entity\Crop	The mappings App\Entity\Crop#cropTranslation and App\Entity\CropTranslation#translatable are inconsistent with each other.
App\Entity\Cropcategory	No errors.
App\Entity\Plantfamily	No errors.
App\Entity\Climatezone	No errors.
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\CropProperty	No errors.
App\Entity\CropTranslation	No errors.
App\Entity\ShoparticleBlockentry	No errors.
App\Entity\CropImage	No errors.
App\Entity\SupportRequest	No errors.
App\Entity\Emaillog	No errors.
App\Entity\Patch	No errors.
App\Entity\Todo	No errors.
App\Entity\Shoporder	No errors.
App\Entity\FavoriteContent	No errors.
App\Entity\Invoice	The mappings App\Entity\Invoice#payments and App\Entity\Payment#invoice are inconsistent with each other.
App\Entity\Payment	The association App\Entity\Payment#invoice refers to the inverse side field App\Entity\Invoice#payment which does not exist.
App\Entity\LoginLog	No errors.
App\Entity\VoucherRedemption	No errors.
App\Entity\Device	No errors.
App\Entity\Survey	No errors.
App\Entity\Post	No errors.
App\Entity\PostComment	No errors.
App\Entity\PostBookmark	No errors.
App\Entity\Rating	No errors.
App\Entity\Appsurvey	No errors.
App\Entity\PushNotification	No errors.
App\Entity\CartItem	No errors.
App\Entity\Garden	No errors.
App\Entity\PostLike	No errors.
App\Entity\CommentLike	No errors.
App\Entity\Notification	The association App\Entity\Notification#post refers to the inverse side field App\Entity\Post#notifications which does not exist.
App\Entity\Nps	No errors.
App\Entity\UserConnection	No errors.
App\Entity\Reminder	No errors.
App\Entity\ProfitwellUser	No errors.
App\Entity\Template	The mappings App\Entity\Template#templateTranslation and App\Entity\TemplateTranslation#translatable are inconsistent with each other.
App\Entity\FavoriteTemplate	No errors.
App\Entity\TemplateUsage	No errors.
App\Entity\ObjectComment	No errors.
App\Entity\PreferencesToken	The mappings App\Entity\PreferencesToken#newsletter_user and App\Entity\NewsletterUser#preferencesTokens are inconsistent with each other.
App\Entity\Usercontent	No errors.
App\Entity\TagConnection	No errors.
App\Entity\Croplist	No errors.
App\Entity\CancellationSurvey	No errors.
App\Entity\ModerationNotification	No errors.
App\Entity\PostReport	No errors.
App\Entity\CropcategoryTranslation	No errors.
App\Entity\PlantfamilyTranslation	No errors.
App\Entity\ClimatezoneRaster	No errors.
App\Entity\PatchfieldGroup	No errors.
App\Entity\Pest	The mappings App\Entity\Pest#pestTranslation and App\Entity\PestTranslation#translatable are inconsistent with each other.
App\Entity\Disease	The mappings App\Entity\Disease#diseaseTranslation and App\Entity\DiseaseTranslation#translatable are inconsistent with each other.
App\Entity\CropactionTranslation	No errors.
App\Entity\Plan	No errors.
App\Entity\Shoparticle	No errors.
App\Entity\Property	No errors.

Symfony Profiler

https://test.api.fryd.app/api/v1/images/310?access_token=&w=160

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping