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.