GET https://sierra-cantabria.dracoder.com/api/admin/brand/

Query Metrics

3 Database Queries
3 Different statements
8.09 ms Query time
0 Invalid entities
33 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.24 ms
(64.78%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.category AS category_3, b0_.image_path AS image_path_4, b0_.embedding AS embedding_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, w1_.id AS id_8, w1_.name AS name_9, w1_.description AS description_10, w1_.image_path AS image_path_11, w1_.abbreviation AS abbreviation_12, w1_.banner_path AS banner_path_13, w1_.video_path AS video_path_14, w1_.calado_image_path AS calado_image_path_15, w1_.founding_year AS founding_year_16, w1_.embedding AS embedding_17, w1_.created_at AS created_at_18, w1_.updated_at AS updated_at_19, b0_.winery_id AS winery_id_20 FROM brand b0_ LEFT JOIN winery w1_ ON b0_.winery_id = w1_.id
Parameters:
[]
1.92 ms
(23.80%)
1
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
  "2c5a4ddda4e779d016cb01cfafad2110c25f85446b2771d404512cd7247e489b62da28c694945a7d"
]
0.92 ms
(11.42%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.nif AS nif_6, t0.address1 AS address1_7, t0.address2 AS address2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.state AS state_11, t0.country AS country_12, t0.phone AS phone_13, t0.points AS points_14, t0.roles AS roles_15, t0.verified_at AS verified_at_16, t0.authentication_token AS authentication_token_17, t0.time_expiration AS time_expiration_18, t0.image_path AS image_path_19, t0.is_exclusive AS is_exclusive_20, t0.username AS username_21, t0.nfc_id AS nfc_id_22, t0.refresh_token AS refresh_token_23, t0.preferred_language AS preferred_language_24, t0.marketing_consent AS marketing_consent_25, t0.birth_date AS birth_date_26, t0.favorite_wine AS favorite_wine_27, t0.wine_type_preferences AS wine_type_preferences_28, t0.suggestions AS suggestions_29, t0.preferred_form_of_address AS preferred_form_of_address_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t33.id AS id_34, t33.endpoint AS endpoint_35, t33.public_key AS public_key_36, t33.auth_token AS auth_token_37, t33.created_at AS created_at_38, t33.updated_at AS updated_at_39, t33.user_id AS user_id_40, t0.email_group_id AS email_group_id_41 FROM users t0 LEFT JOIN user_subscription t33 ON t33.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "gonzalo@dracoder.com"
]

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\Entity\Brand 25
App\Entity\Winery 5
League\Bundle\OAuth2ServerBundle\Model\AccessToken 1
League\Bundle\OAuth2ServerBundle\Model\Client 1
App\Entity\User 1