https://dev.pholios.net/mikamatto/portfolio/photo/d5a9144f7beedac26a52a7846ac692c5?type=tags

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.42 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.49 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.54 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.19 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 0.95 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:
[
  "d5a9144f7beedac26a52a7846ac692c5"
]
6 0.76 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:
[
  5
]
7 0.41 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:
[
  5
]
8 0.37 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:
[
  5
]
9 0.40 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:
[
  "mikamatto"
]
10 0.26 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.