https://dev.pholios.net/MM_PHOTOGRAPHER/portfolio/photo/3e3d030b0837098a1d8d7f4365d01f22?type=tags

Query Metrics

10 Database Queries
8 Different statements
9.94 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.24 ms
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"
]
2 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3 FROM language t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
  "en_US"
]
3 0.23 ms
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:
[
  "core_default_language"
]
4 0.17 ms
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
]
5 4.49 ms
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:
[
  "3e3d030b0837098a1d8d7f4365d01f22"
]
6 0.82 ms
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:
[
  134
]
7 1.02 ms
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:
[
  134
]
8 0.46 ms
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:
[
  134
]
9 0.67 ms
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:
[
  "MM_PHOTOGRAPHER"
]
10 0.45 ms
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"
]

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\SEOTranslation No errors.
App\Entity\User\Notification No errors.
App\Entity\UserGroup No errors.
App\Entity\Wallet No errors.
App\Entity\Money\Payout No errors.
App\Entity\Money\Currency No errors.
App\Entity\Media\CreditType No errors.
App\Entity\ProfileTypeTranslation No errors.