https://dev.pholios.net/tizianom/portfolio/photo/30be0e54e372aee148157f6e783b51a3?album=175

Query Metrics

44 Database Queries
24 Different statements
73.01 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.48 ms
(0.00%)
1
SELECT t1.id AS id_2, t1.title AS title_3, t1.hash AS hash_4, t1.description AS description_5, t1.active AS active_6, t1.views AS views_7, t1.privacy AS privacy_8, t1.adult AS adult_9, t1.location AS location_10, t1.created_at AS created_at_11, t1.updated_at AS updated_at_12, t1.deleted_at AS deleted_at_13, t0.filename AS filename_14, t1.profile_id AS profile_id_15, t1.created_by_id AS created_by_id_16, t1.updated_by_id AS updated_by_id_17, t1.type FROM media_photo t0 INNER JOIN media t1 ON t0.id = t1.id WHERE t1.hash = ? LIMIT 1
Parameters:
[
  "30be0e54e372aee148157f6e783b51a3"
]
8.73 ms
(0.00%)
1
SELECT t0.id AS id_3, t0.name AS name_4, t0.legal_name AS legal_name_5, t0.email AS email_6, t0.slug AS slug_7, t0.description AS description_8, t0.country AS country_9, t0.city AS city_10, t0.location AS location_11, t0.enable_contact AS enable_contact_12, t0.languages AS languages_13, t0.use_english AS use_english_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.user_id AS user_id_18, t0.profile_type_id AS profile_type_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.type, t1.transport AS transport_22, t2.own_location AS own_location_23, t2.hair_length AS hair_length_24, t2.tattoos AS tattoos_25, t2.hair_color AS hair_color_26, t2.eyes AS eyes_27, t2.ethnicity AS ethnicity_28, t2.height AS height_29, t2.weight AS weight_30, t2.hips AS hips_31, t2.waist AS waist_32, t2.chest AS chest_33 FROM profile t0 LEFT JOIN profile_person t1 ON t0.id = t1.id LEFT JOIN profile_model t2 ON t0.id = t2.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  171
]
4.81 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.portfolio AS portfolio_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.slug AS slug_8, t0.profile_id AS profile_id_9, t10.created_date AS created_date_11, t10.media_id AS media_id_12, t10.album_id AS album_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15 FROM media_album t0 LEFT JOIN media_album_cover t10 ON t10.album_id = t0.id WHERE t0.id = ?
Parameters:
[
  "175"
]
3.45 ms
(0.00%)
9
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.display_name AS display_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM setting t0 WHERE t0.name = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "disclaimer_cookie_toggle"
]
3.04 ms
(0.00%)
1
SELECT t0.created_date AS created_date_1, t0.sort_order AS sort_order_2, t0.media_id AS media_id_3, t0.album_id AS album_id_4 FROM media_album_to_media t0 WHERE t0.album_id = ?
Parameters:
[
  175
]
2.97 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM tags t0 INNER JOIN media_tag ON t0.id = media_tag.tag_id WHERE media_tag.media_id = ? ORDER BY t0.name ASC
Parameters:
[
  484
]
2.91 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM media_credit_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
2.90 ms
(0.00%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
2.78 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM menu t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.72 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.media_id AS media_id_3, t0.profile_id AS profile_id_4, t0.credit_type_id AS credit_type_id_5 FROM media_credit t0 WHERE t0.media_id = ?
Parameters:
[
  484
]
2.69 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.meta_data AS meta_data_2, t0.route AS route_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM seo t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "portfolio_photo"
]
2.52 ms
(0.00%)
2
SELECT t0.id AS id_3, t0.title AS title_4, t0.hash AS hash_5, t0.description AS description_6, t0.active AS active_7, t0.views AS views_8, t0.privacy AS privacy_9, t0.adult AS adult_10, t0.location AS location_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.profile_id AS profile_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.type, t1.filename AS filename_18, t2.embed_code AS embed_code_19, t2.platform AS platform_20 FROM media t0 LEFT JOIN media_photo t1 ON t0.id = t1.id LEFT JOIN media_video t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  485
]
2.46 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM media_credit_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.33 ms
(0.00%)
3
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "3"
]
2.06 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_date AS created_date_3, t0.profile_id AS profile_id_4 FROM profile_avatar t0 WHERE t0.profile_id = ?
Parameters:
[
  171
]
1.96 ms
(0.00%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
1.76 ms
(0.00%)
1
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.path AS path_2, m0_.icon AS icon_3, m0_.privacy AS privacy_4, m0_.groups AS groups_5, m0_.sort_order AS sort_order_6, m0_.options AS options_7, m0_.active AS active_8, m0_.menu_id AS menu_id_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.menu_id = ? AND ((m0_.privacy = ? OR m0_.privacy = ?)) ORDER BY m0_.sort_order ASC
Parameters:
[
  1
  "all"
  "guests"
]
1.68 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
1.66 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_date AS created_date_3, t0.profile_id AS profile_id_4 FROM profile_cover t0 WHERE t0.profile_id = ?
Parameters:
[
  171
]
1.32 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.display_name AS display_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM setting t0 WHERE t0.name IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  [
    "seo_allow_indexing"
    "seo_default_title"
    "seo_default_description"
    "core_site_name"
    "seo_default_keywords"
    "core_site_logo"
  ]
]
0.72 ms
(0.00%)
1
SELECT t0.id AS id_3, t0.name AS name_4, t0.legal_name AS legal_name_5, t0.email AS email_6, t0.slug AS slug_7, t0.description AS description_8, t0.country AS country_9, t0.city AS city_10, t0.location AS location_11, t0.enable_contact AS enable_contact_12, t0.languages AS languages_13, t0.use_english AS use_english_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.user_id AS user_id_18, t0.profile_type_id AS profile_type_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.type, t1.transport AS transport_22, t2.own_location AS own_location_23, t2.hair_length AS hair_length_24, t2.tattoos AS tattoos_25, t2.hair_color AS hair_color_26, t2.eyes AS eyes_27, t2.ethnicity AS ethnicity_28, t2.height AS height_29, t2.weight AS weight_30, t2.hips AS hips_31, t2.waist AS waist_32, t2.chest AS chest_33 FROM profile t0 LEFT JOIN profile_person t1 ON t0.id = t1.id LEFT JOIN profile_model t2 ON t0.id = t2.id WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "tizianom"
]
0.60 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.35 ms
(0.00%)
1
UPDATE media SET views = ?, updated_at = ? WHERE id = ?
Parameters:
[
  16
  "2025-01-19 09:15:07"
  484
]
0.10 ms
(0.00%)
1
"START TRANSACTION"
Parameters:
[]

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\Setting No errors.
App\Entity\SEO No errors.
App\Entity\User
  • The mappings App\Entity\User#profilesNotes and App\Entity\Profile\Note#user are inconsistent with each other.
App\Entity\Core\Language No errors.
App\Entity\Media\Media No errors.
App\Entity\Media\Photo No errors.
App\Entity\Profile
  • The field App\Entity\Profile#travels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Travel#profile does not contain the required 'inversedBy="travels"' attribute.
App\Entity\Media\AlbumCover No errors.
App\Entity\Profile\Type\Person
  • The field App\Entity\Profile\Type\Person#travels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Travel#profile does not contain the required 'inversedBy="travels"' attribute.
App\Entity\Profile\Type\Model
  • The field App\Entity\Profile\Type\Model#travels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Travel#profile does not contain the required 'inversedBy="travels"' attribute.
App\Entity\ProfileType No errors.
App\Entity\Service No errors.
App\Entity\Profile\Mute No errors.
App\Entity\Transaction No errors.
App\Entity\Profile\Cover No errors.
App\Entity\Profile\Avatar No errors.
App\Entity\Profile\Link No errors.
App\Entity\Profile\Note
  • The association App\Entity\Profile\Note#user refers to the inverse side field App\Entity\User#notes which is not defined as association.
  • The association App\Entity\Profile\Note#user refers to the inverse side field App\Entity\User#notes which does not exist.
App\Entity\Profile\Travel No errors.
App\Entity\Media\Credit No errors.
App\Entity\Media\Album No errors.
App\Entity\Profile\Follow
  • The mappings App\Entity\Profile\Follow#profile and App\Entity\Profile#followers are inconsistent with each other.
App\Entity\Media\AlbumMedia No errors.
App\Entity\Core\Tag No errors.
App\Entity\Media\Video No errors.
App\Entity\Wallet No errors.
App\Entity\Money\Currency No errors.
App\Entity\Media\CreditType No errors.
App\Entity\Media\CreditTypeTranslation No errors.
App\Entity\Layout\Menu No errors.
App\Entity\Layout\MenuItem No errors.
App\Entity\Layout\MenuItemTranslation No errors.
App\Entity\Core\Page No errors.
App\Entity\Core\PageTranslation No errors.