Query Metrics
76
Database Queries
12
Different statements
10.55 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.31 ms (69.27%) |
62 |
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:
[
844
]
|
0.97 ms (9.23%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.nickname AS nickname_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.zip_code AS zip_code_10, t0.city AS city_11, t0.country_iso AS country_iso_12, t0.phone AS phone_13, t0.mobile AS mobile_14, t0.profile AS profile_15, t0.date_created AS date_created_16, t0.is_public AS is_public_17, t0.public_profile_hash AS public_profile_hash_18, t0.login_count AS login_count_19, t0.about_me AS about_me_20, t0.date_last_login AS date_last_login_21, t0.date_disabled AS date_disabled_22, t0.date_opt_in_confirmed AS date_opt_in_confirmed_23, t0.geo_lat AS geo_lat_24, t0.geo_lon AS geo_lon_25, t0.reset_hash AS reset_hash_26, t0.date_reset_created AS date_reset_created_27, t0.settings AS settings_28, t0.is_active AS is_active_29, t0.opt_in_hash AS opt_in_hash_30, t0.account_type AS account_type_31, t0.payment_data AS payment_data_32, t0.locale AS locale_33, t0.v_referral_code AS v_referral_code_34, t0.v_source AS v_source_35, t0.v_mention_tag AS v_mention_tag_36, t0.v_social_login_user_id AS v_social_login_user_id_37, t0.climate_settings AS climate_settings_38, t0.units AS units_39 FROM user t0 WHERE t0.id = ?
Parameters:
[
657
]
|
0.96 ms (9.07%) |
3 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.nickname AS nickname_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.zip_code AS zip_code_10, t0.city AS city_11, t0.country_iso AS country_iso_12, t0.phone AS phone_13, t0.mobile AS mobile_14, t0.profile AS profile_15, t0.date_created AS date_created_16, t0.is_public AS is_public_17, t0.public_profile_hash AS public_profile_hash_18, t0.login_count AS login_count_19, t0.about_me AS about_me_20, t0.date_last_login AS date_last_login_21, t0.date_disabled AS date_disabled_22, t0.date_opt_in_confirmed AS date_opt_in_confirmed_23, t0.geo_lat AS geo_lat_24, t0.geo_lon AS geo_lon_25, t0.reset_hash AS reset_hash_26, t0.date_reset_created AS date_reset_created_27, t0.settings AS settings_28, t0.is_active AS is_active_29, t0.opt_in_hash AS opt_in_hash_30, t0.account_type AS account_type_31, t0.payment_data AS payment_data_32, t0.locale AS locale_33, t0.v_referral_code AS v_referral_code_34, t0.v_source AS v_source_35, t0.v_mention_tag AS v_mention_tag_36, t0.v_social_login_user_id AS v_social_login_user_id_37, t0.climate_settings AS climate_settings_38, t0.units AS units_39 FROM user t0 WHERE t0.public_profile_hash = ? LIMIT 1
Parameters:
[
"77e416a302ef7e272b7c2ecc4da81e74"
]
|
0.35 ms (3.30%) |
2 |
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:
[
"327941c28b751e332847751145b908d5"
]
|
0.22 ms (2.09%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.user_id AS user_id_3, t0.crop_id AS crop_id_4, t0.croplist_id AS croplist_id_5 FROM favoritecrop t0 WHERE t0.user_id = ?
Parameters:
[
657
]
|
0.18 ms (1.71%) |
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.user_id = ?
Parameters:
[
657
]
|
0.15 ms (1.47%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM login_log l0_ WHERE (l0_.user_id = ? AND l0_.date_login > ?) AND l0_.v_user_agent = ?
Parameters:
[ 657 "2025-08-07 18:01:04" "axios/0.27.2" ] |
0.10 ms (0.92%) |
1 |
SELECT COUNT(u0_.id) AS sclr_0 FROM user_connection u0_ WHERE u0_.following_user_id = ?
Parameters:
[
657
]
|
0.09 ms (0.88%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM post_comment p0_ WHERE p0_.user_id = ?
Parameters:
[
657
]
|
0.09 ms (0.84%) |
1 |
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.user_id = ? AND t0.type = ?
Parameters:
[ 657 "profile_garden" ] |
0.08 ms (0.73%) |
1 |
SELECT COUNT(u0_.id) AS sclr_0 FROM user_connection u0_ WHERE u0_.user_id = ?
Parameters:
[
657
]
|
0.05 ms (0.48%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.user_id = ?
Parameters:
[
657
]
|
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 |
|
App\Entity\Crop |
|
App\Entity\SupportRequest | No errors. |
App\Entity\Emaillog | No errors. |
App\Entity\Patch | No errors. |
App\Entity\Cropaction | No errors. |
App\Entity\Todo | No errors. |
App\Entity\Shoporder | No errors. |
App\Entity\FavoriteCrop | No errors. |
App\Entity\FavoriteContent | No errors. |
App\Entity\Invoice |
|
App\Entity\Payment |
|
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\Image | No errors. |
App\Entity\CropEdit | No errors. |
App\Entity\CropRating | 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 |
|
App\Entity\Nps | No errors. |
App\Entity\UserConnection | No errors. |
App\Entity\Reminder | No errors. |
App\Entity\ProfitwellUser | No errors. |
App\Entity\Template |
|
App\Entity\FavoriteTemplate | No errors. |
App\Entity\TemplateUsage | No errors. |
App\Entity\ObjectComment | No errors. |
App\Entity\PreferencesToken |
|
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\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\PlanCrop | No errors. |
App\Entity\ShoparticleCrop | No errors. |
App\Entity\CropSynonym | No errors. |
App\Entity\CropProperty | No errors. |
App\Entity\CropTranslation | No errors. |
App\Entity\ShoparticleBlockentry | No errors. |
App\Entity\CropImage | No errors. |