Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

24.83 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	24.83 ms	SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.validate AS validate_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.original_file_name AS original_file_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discr, t0.width AS width_10, t0.height AS height_11, t0.duration AS duration_12 FROM media t0 WHERE t0.id = ? AND t0.discr IN ('media', 'image', 'video') Parameters: [`"796ec8f4-f228-4f36-b99e-0e0f74c539b9"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.validate AS validate_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.original_file_name AS original_file_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discr, t0.width AS width_10, t0.height AS height_11, t0.duration AS duration_12 FROM media t0 WHERE t0.id = ? AND t0.discr IN ('media', 'image', 'video') SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.validate AS validate_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.original_file_name AS original_file_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discr, t0.width AS width_10, t0.height AS height_11, t0.duration AS duration_12 FROM media t0 WHERE t0.id = '796ec8f4-f228-4f36-b99e-0e0f74c539b9' AND t0.discr IN ('media', 'image', 'video');

#▲

Time

Info

24.83 ms

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.validate AS validate_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.original_file_name AS original_file_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discr, t0.width AS width_10, t0.height AS height_11, t0.duration AS duration_12 FROM media t0 WHERE t0.id = ? AND t0.discr IN ('media', 'image', 'video')

Parameters:

[
  "796ec8f4-f228-4f36-b99e-0e0f74c539b9"
]

View formatted query View runnable query Explain query

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.validate AS validate_3,
  t0.file_name AS file_name_4,
  t0.mime_type AS mime_type_5,
  t0.original_file_name AS original_file_name_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.discr,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.duration AS duration_12
FROM
  media t0
WHERE
  t0.id = ?
  AND t0.discr IN ('media', 'image', 'video')

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.validate AS validate_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.original_file_name AS original_file_name_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discr, t0.width AS width_10, t0.height AS height_11, t0.duration AS duration_12 FROM media t0 WHERE t0.id = '796ec8f4-f228-4f36-b99e-0e0f74c539b9' AND t0.discr IN ('media', 'image', 'video');

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\Media\Media	No errors.
App\Entity\User\User	No errors.
App\Entity\Company\Company	The association App\Entity\Company\Company#organizer refers to the inverse side field App\Entity\User\Organizer#Company which does not exist.
App\Entity\Notification\Notification	No errors.
App\Entity\Media\Image	No errors.
App\Entity\Media\Video	No errors.

Symfony Profiler

https://bikingman.bees-solution.com/en/back/media/796ec8f4-f228-4f36-b99e-0e0f74c539b9

Configuration Settings

Theme