https://dev.pholios.net/mikamatto/portfolio/album/test

Query Metrics

15 Database Queries
11 Different statements
53.14 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.74 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.53 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.34 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.25 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 21.89 ms
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.slug = ? LIMIT 1
Parameters:
[
  "test"
]
6 1.05 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:
[
  1
]
7 0.58 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:
[
  1
]
8 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_avatar t0 WHERE t0.profile_id = ?
Parameters:
[
  1
]
9 0.71 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.created_date AS created_date_3, t0.profile_id AS profile_id_4 FROM profile_cover t0 WHERE t0.profile_id = ?
Parameters:
[
  5
]
11 0.25 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
]
12 1.14 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 IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  [
    "media_albums_groups"
  ]
]
13 12.23 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.radius AS radius_4, t0.profile_types AS profile_types_5, t0.password AS password_6, t0.verified AS verified_7, t0.safe_mode AS safe_mode_8, t0.display_name AS display_name_9, t0.real_name AS real_name_10, t0.notes AS notes_11, t0.photo_one_id AS photo_one_id_12, t0.photo_second_id AS photo_second_id_13, t0.address AS address_14, t0.country AS country_15, t0.city AS city_16, t0.location AS location_17, t0.activity AS activity_18, t0.commission AS commission_19, t0.fee AS fee_20, t0.feed_limit AS feed_limit_21, t0.gender AS gender_22, t0.birthdate AS birthdate_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.wallet_id AS wallet_id_27, t0.currency_id AS currency_id_28, t0.language_id AS language_id_29, t0.created_by_id AS created_by_id_30, t0.updated_by_id AS updated_by_id_31 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
14 11.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_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 user_group t0 INNER JOIN user_group_user ON t0.id = user_group_user.user_group_id WHERE user_group_user.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
15 0.51 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\Album 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\Media\Media 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\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\Wallet No errors.
App\Entity\Money\Currency No errors.
App\Entity\User\Notification No errors.
App\Entity\UserGroup No errors.
App\Entity\Money\Payout No errors.
App\Entity\SEOTranslation No errors.
App\Entity\Core\Tag No errors.
App\Entity\Media\CreditType No errors.
App\Entity\ProfileTypeTranslation No errors.