GET https://admin.dev.rippla.com/api/private/dictionaries/location_types

Query Metrics

17 Database Queries
6 Different statements
47.77 ms Query time
6 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 5.40 ms
SELECT u0_.id AS id_0, u0_.is_active AS is_active_1, u0_.is_blocked AS is_blocked_2, u0_.email AS email_3, u0_.full_name AS full_name_4, u0_.phone AS phone_5, u0_.description AS description_6, u0_.query_params AS query_params_7, u0_.messengers AS messengers_8, u0_.preferred_locale AS preferred_locale_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.firebase_uid AS firebase_uid_11, u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12, u0_.notification_settings AS notification_settings_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.accounts AS accounts_17, u0_.role AS role_18 FROM users u0_ WHERE (LOWER(u0_.email) = ? AND u0_.deleted_at IS NULL) AND u0_.role IN (1, 2)
Parameters:
[
  "dk@redstart.pro"
]
2 1.69 ms
SELECT t0.id AS id_1, t0.business_role AS business_role_2, t0.business_id AS business_id_3, t0.user_id AS user_id_4 FROM business_representatives t0 WHERE t0.user_id = ?
Parameters:
[
  158
]
3 3.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.billing_country_code AS billing_country_code_4, t0.is_campaign_creatable AS is_campaign_creatable_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.registrator_id AS registrator_id_8 FROM businesses t0 WHERE t0.id = ?
Parameters:
[
  "93"
]
4 7.62 ms
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.is_active AS is_active_2, l0_.icon_id AS icon_id_3, l0_.placeholder_id AS placeholder_id_4 FROM location_types l0_ WHERE l0_.is_active = ? ORDER BY l0_.id ASC
Parameters:
[
  1
]
5 3.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "1782"
]
6 6.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2562"
]
7 9.96 ms
SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?
Parameters:
[
  "cloudflare_file_variant"
]
8 5.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "1783"
]
9 0.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2559"
]
10 1.09 ms
SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?
Parameters:
[
  "cloudflare_file_variant"
]
11 0.56 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "1784"
]
12 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2563"
]
13 0.44 ms
SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?
Parameters:
[
  "cloudflare_file_variant"
]
14 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2565"
]
15 0.29 ms
SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?
Parameters:
[
  "cloudflare_file_variant"
]
16 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.cloudflare_file_id AS cloudflare_file_id_4, t0.type AS type_5, t0.created_at AS created_at_6 FROM files t0 WHERE t0.id = ?
Parameters:
[
  "2561"
]
17 0.30 ms
SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?
Parameters:
[
  "cloudflare_file_variant"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Domain\File\File 8
App\Domain\Location\Entity\LocationType 4
App\Domain\User\Entity\User 1
App\Domain\Business\Entity\BusinessRepresentative 1
App\Domain\Business\Entity\Business 1
App\Domain\Shared\Settings\Settings 1

Entities Mapping

Class Mapping errors
App\Domain\User\Entity\User No errors.
App\Domain\User\Entity\InfluencerUser No errors.
App\Domain\User\Entity\BusinessRepresentativeUser
  • The association App\Domain\User\Entity\BusinessRepresentativeUser#collaborationViews refers to the owning side field App\Domain\Campaign\Entity\Collaboration\CollaborationView#userrr which does not exist.
App\Domain\User\Entity\RefreshToken No errors.
App\Domain\Notification\Entity\Notification No errors.
App\Domain\Notification\Entity\NotificationContact No errors.
App\Domain\Subscription\Entity\UserSubscription
  • The association App\Domain\Subscription\Entity\UserSubscription#subscriptionChanges refers to the owning side field App\Domain\Subscription\Entity\UserSubscriptionChange#userSubscription which does not exist.
App\Domain\AIAssistant\Entity\AssistantChatMessage
  • The field App\Domain\AIAssistant\Entity\AssistantChatMessage#requests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\AIAssistant\Entity\AssistantChatMessage#response does not contain the required 'inversedBy: "requests"' attribute.
App\Domain\Subscription\Entity\UserNotificationSubscription No errors.
App\Domain\Business\Entity\Business
  • The field App\Domain\Business\Entity\Business#personalMaxActiveLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Business\Entity\PersonalMaxActiveLocations#business does not contain the required 'inversedBy: "personalMaxActiveLocations"' attribute.
  • The field App\Domain\Business\Entity\Business#subscriptionBusinessAccess is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Subscription\Entity\SubscriptionBusinessAccess#business does not contain the required 'inversedBy: "subscriptionBusinessAccess"' attribute.
App\Domain\Business\Entity\BusinessRepresentative No errors.
App\Domain\Campaign\Entity\Campaign No errors.
App\Domain\Campaign\Entity\Collaboration\CollaborationView
  • The mappings App\Domain\Campaign\Entity\Collaboration\CollaborationView#user and App\Domain\User\Entity\BusinessRepresentativeUser#collaborationViews are inconsistent with each other.
App\Domain\Business\Entity\PersonalMaxActiveLocations No errors.
App\Domain\Location\Entity\Location No errors.
App\Domain\Subscription\Entity\SubscriptionBusinessAccess No errors.
App\Domain\Location\Entity\LocationType
  • The field App\Domain\Location\Entity\LocationType#campaignTemplates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Campaign\Entity\Template\CampaignTemplate#locationType does not contain the required 'inversedBy: "campaignTemplates"' attribute.
App\Domain\File\File No errors.
App\Domain\Location\Entity\Amenity No errors.
App\Domain\Campaign\Entity\Template\CampaignTemplate No errors.
App\Domain\Shared\Settings\Settings No errors.