Symfony Profiler

Query Metrics

145 Database Queries

15 Different statements

200.88 ms Query time

5 Invalid entities

539 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

72.72 ms
(36.20%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.required AS required_4, t0.default_data AS default_data_5, t0.total_value AS total_value_6, t0.image_file_name AS image_file_name_7, t0.ordinal AS ordinal_8, t0.template_id AS template_id_9 FROM template_fields t0 WHERE t0.template_id = ?

Parameters:

[
  459
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.required AS required_4,
  t0.default_data AS default_data_5,
  t0.total_value AS total_value_6,
  t0.image_file_name AS image_file_name_7,
  t0.ordinal AS ordinal_8,
  t0.template_id AS template_id_9
FROM
  template_fields t0
WHERE
  t0.template_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.required AS required_4, t0.default_data AS default_data_5, t0.total_value AS total_value_6, t0.image_file_name AS image_file_name_7, t0.ordinal AS ordinal_8, t0.template_id AS template_id_9 FROM template_fields t0 WHERE t0.template_id = 459;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	Valt\Template\Domain\Entity\Template->getFields (line 326)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
11	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
12	call_user_func_array (line 50)
13	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
14	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
15	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
16	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
17	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
18	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
19	JMS\Serializer\Serializer->visit (line 256)
20	JMS\Serializer\Serializer->serialize (line 163)
21	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

52.75 ms
(26.26%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.field_id AS field_id_4 FROM template_field_options t0 WHERE t0.field_id = ?

Parameters:

[
  1029
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.value AS value_3,
  t0.field_id AS field_id_4
FROM
  template_field_options t0
WHERE
  t0.field_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.field_id AS field_id_4 FROM template_field_options t0 WHERE t0.field_id = 1029;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	Valt\CamBundle\Serializer\TemplateFieldSerializer->convertTemplateFieldToArray (line 55)
8	Valt\CamBundle\Serializer\TemplateFieldSerializer->serializeField (line 34)
9	call_user_func_array (line 50)
10	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
12	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
13	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
14	call_user_func_array (line 50)
15	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
16	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
17	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
18	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
19	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
20	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
21	call_user_func_array (line 50)
22	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
23	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
24	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
25	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
26	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
27	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
28	JMS\Serializer\Serializer->visit (line 256)
29	JMS\Serializer\Serializer->serialize (line 163)
30	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

51.01 ms
(25.40%)

SELECT t0.id AS id_1, t0.motion_detection_enabled AS motion_detection_enabled_2, t0.room_id AS room_id_3, t0.video_id AS video_id_4, t0.audio_id AS audio_id_5 FROM device_source t0 WHERE t0.room_id = ?

Parameters:

[
  387
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.motion_detection_enabled AS motion_detection_enabled_2,
  t0.room_id AS room_id_3,
  t0.video_id AS video_id_4,
  t0.audio_id AS audio_id_5
FROM
  device_source t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.motion_detection_enabled AS motion_detection_enabled_2, t0.room_id AS room_id_3, t0.video_id AS video_id_4, t0.audio_id AS audio_id_5 FROM device_source t0 WHERE t0.room_id = 387;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	Valt\CamBundle\Entity\Room->getDevices (line 311)
8	Valt\CamBundle\Entity\Room->isOnline (line 496)
9	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
10	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
11	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
12	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
13	call_user_func_array (line 50)
14	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
15	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
16	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
17	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
18	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
19	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
20	JMS\Serializer\Serializer->visit (line 256)
21	JMS\Serializer\Serializer->serialize (line 163)
22	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

5.94 ms
(2.95%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.rtsp_url AS rtsp_url_22, t0.rtsp_url AS rtsp_url_23, t0.linked_user_id AS linked_user_id_24 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = ? AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream')

Parameters:

[
  1475
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.controller AS controller_3,
  t0.io_last_call AS io_last_call_4,
  t0.io_last_port_called AS io_last_port_called_5,
  t0.io_configured AS io_configured_6,
  t0.has_audio AS has_audio_7,
  t0.control_enabled AS control_enabled_8,
  t0.status AS status_9,
  t0.camera_has_been_online AS camera_has_been_online_10,
  t0.pending_alert_token AS pending_alert_token_11,
  t12.device_id AS device_id_13,
  t0.wowza_id AS wowza_id_14,
  t0.type,
  t0.brand AS brand_15,
  t0.ip AS ip_16,
  t0.port AS port_17,
  t0.rtsp_port AS rtsp_port_18,
  t0.use_ssl AS use_ssl_19,
  t0.username AS username_20,
  t0.password AS password_21,
  t0.rtsp_url AS rtsp_url_22,
  t0.rtsp_url AS rtsp_url_23,
  t0.linked_user_id AS linked_user_id_24
FROM
  device t0
  LEFT JOIN device_ocr t12 ON t12.device_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'camera', 'beam', 'roam', 'controller',
    'stream'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.rtsp_url AS rtsp_url_22, t0.rtsp_url AS rtsp_url_23, t0.linked_user_id AS linked_user_id_24 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = 1475 AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Valt\MobileBundle\EventListener\MobileApiListener->__invoke (line 42)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

4.89 ms
(2.44%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = ? AND t0.type IN ('common', 'record')

Parameters:

[
  "37fd3f5a-977e-4a7b-82cc-541a78bc10e0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = '37fd3f5a-977e-4a7b-82cc-541a78bc10e0' AND t0.type IN ('common', 'record');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2531)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1037)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
14	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
15	call_user_func_array (line 50)
16	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
17	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
18	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
19	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
20	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
21	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
22	JMS\Serializer\Serializer->visit (line 256)
23	JMS\Serializer\Serializer->serialize (line 163)
24	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

2.29 ms
(1.14%)

SELECT t0.sampling_frequency AS sampling_frequency_1, t0.sensitivity AS sensitivity_2, t0.camera_id AS camera_id_3, t0.mask_id AS mask_id_4 FROM camera_motion_detection t0 WHERE t0.camera_id = ?

Parameters:

[
  1429
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.sampling_frequency AS sampling_frequency_1,
  t0.sensitivity AS sensitivity_2,
  t0.camera_id AS camera_id_3,
  t0.mask_id AS mask_id_4
FROM
  camera_motion_detection t0
WHERE
  t0.camera_id = ?

SELECT t0.sampling_frequency AS sampling_frequency_1, t0.sensitivity AS sensitivity_2, t0.camera_id AS camera_id_3, t0.mask_id AS mask_id_4 FROM camera_motion_detection t0 WHERE t0.camera_id = 1429;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
10	Doctrine\ORM\UnitOfWork->createEntity (line 2531)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1037)
17	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
18	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
19	Doctrine\ORM\PersistentCollection->initialize (line 186)
20	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
21	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
22	call_user_func_array (line 50)
23	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
24	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
25	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
26	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
27	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
28	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
29	JMS\Serializer\Serializer->visit (line 256)
30	JMS\Serializer\Serializer->serialize (line 163)
31	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

1.99 ms
(0.99%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_shared_audio AS is_shared_audio_3, t0.is_camera_io AS is_camera_io_4, t0.grid AS grid_5, t0.room_type AS room_type_6, t0.camera_sorting_order AS camera_sorting_order_7, t0.priority AS priority_8, t0.schedule_email AS schedule_email_9, t0.master_source_id AS master_source_id_10, t11.id AS id_12, t11.stop_at AS stop_at_13, t11.paused AS paused_14, t11.last_start_time AS last_start_time_15, t11.last_stop_time AS last_stop_time_16, t11.duration_before_last_start AS duration_before_last_start_17, t11.record_id AS record_id_18, t11.schedule_session_id AS schedule_session_id_19, t11.room_id AS room_id_20, t0.sharing_link_id AS sharing_link_id_21, t0.camera_io_id AS camera_io_id_22, t0.wowza_id AS wowza_id_23, t0.user_io_id AS user_io_id_24, t0.user_id AS user_id_25, t0.locked_by_id AS locked_by_id_26, t0.prepared_record_id AS prepared_record_id_27, t28.timeout AS timeout_29, t28.room_id AS room_id_30, t28.enabled_by_id AS enabled_by_id_31, t28.author_id AS author_id_32, t0.container_id AS container_id_33 FROM rooms t0 LEFT JOIN recordings t11 ON t11.room_id = t0.id LEFT JOIN room_motion_detection t28 ON t28.room_id = t0.id INNER JOIN users_groups_rooms ON t0.id = users_groups_rooms.room_id WHERE users_groups_rooms.user_group_id = ? ORDER BY t0.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_shared_audio AS is_shared_audio_3,
  t0.is_camera_io AS is_camera_io_4,
  t0.grid AS grid_5,
  t0.room_type AS room_type_6,
  t0.camera_sorting_order AS camera_sorting_order_7,
  t0.priority AS priority_8,
  t0.schedule_email AS schedule_email_9,
  t0.master_source_id AS master_source_id_10,
  t11.id AS id_12,
  t11.stop_at AS stop_at_13,
  t11.paused AS paused_14,
  t11.last_start_time AS last_start_time_15,
  t11.last_stop_time AS last_stop_time_16,
  t11.duration_before_last_start AS duration_before_last_start_17,
  t11.record_id AS record_id_18,
  t11.schedule_session_id AS schedule_session_id_19,
  t11.room_id AS room_id_20,
  t0.sharing_link_id AS sharing_link_id_21,
  t0.camera_io_id AS camera_io_id_22,
  t0.wowza_id AS wowza_id_23,
  t0.user_io_id AS user_io_id_24,
  t0.user_id AS user_id_25,
  t0.locked_by_id AS locked_by_id_26,
  t0.prepared_record_id AS prepared_record_id_27,
  t28.timeout AS timeout_29,
  t28.room_id AS room_id_30,
  t28.enabled_by_id AS enabled_by_id_31,
  t28.author_id AS author_id_32,
  t0.container_id AS container_id_33
FROM
  rooms t0
  LEFT JOIN recordings t11 ON t11.room_id = t0.id
  LEFT JOIN room_motion_detection t28 ON t28.room_id = t0.id
  INNER JOIN users_groups_rooms ON t0.id = users_groups_rooms.room_id
WHERE
  users_groups_rooms.user_group_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_shared_audio AS is_shared_audio_3, t0.is_camera_io AS is_camera_io_4, t0.grid AS grid_5, t0.room_type AS room_type_6, t0.camera_sorting_order AS camera_sorting_order_7, t0.priority AS priority_8, t0.schedule_email AS schedule_email_9, t0.master_source_id AS master_source_id_10, t11.id AS id_12, t11.stop_at AS stop_at_13, t11.paused AS paused_14, t11.last_start_time AS last_start_time_15, t11.last_stop_time AS last_stop_time_16, t11.duration_before_last_start AS duration_before_last_start_17, t11.record_id AS record_id_18, t11.schedule_session_id AS schedule_session_id_19, t11.room_id AS room_id_20, t0.sharing_link_id AS sharing_link_id_21, t0.camera_io_id AS camera_io_id_22, t0.wowza_id AS wowza_id_23, t0.user_io_id AS user_io_id_24, t0.user_id AS user_id_25, t0.locked_by_id AS locked_by_id_26, t0.prepared_record_id AS prepared_record_id_27, t28.timeout AS timeout_29, t28.room_id AS room_id_30, t28.enabled_by_id AS enabled_by_id_31, t28.author_id AS author_id_32, t0.container_id AS container_id_33 FROM rooms t0 LEFT JOIN recordings t11 ON t11.room_id = t0.id LEFT JOIN room_motion_detection t28 ON t28.room_id = t0.id INNER JOIN users_groups_rooms ON t0.id = users_groups_rooms.room_id WHERE users_groups_rooms.user_group_id = 1 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
8	call_user_func_array (line 50)
9	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
10	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
11	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
12	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
13	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
14	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
15	JMS\Serializer\Serializer->visit (line 256)
16	JMS\Serializer\Serializer->serialize (line 163)
17	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

1.60 ms
(0.79%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id INNER JOIN users_groups_extra_info_templates ON t0.id = users_groups_extra_info_templates.template_id WHERE users_groups_extra_info_templates.user_group_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity_name AS entity_name_3,
  t0.type AS type_4,
  t0.is_hidden AS is_hidden_5,
  t0.duration_type AS duration_type_6,
  t0.duration AS duration_7,
  t0.deleted_at AS deleted_at_8,
  t0.container_id AS container_id_9,
  t10.id AS id_11,
  t10.date_time_format AS date_time_format_12,
  t10.time_format AS time_format_13,
  t10.comment_overlay_font_size AS comment_overlay_font_size_14,
  t10.streaming_method AS streaming_method_15,
  t10.smtp_server_address AS smtp_server_address_16,
  t10.smtp_server_port AS smtp_server_port_17,
  t10.email_encryption AS email_encryption_18,
  t10.email_username AS email_username_19,
  t10.email_password AS email_password_20,
  t10.email_from_name AS email_from_name_21,
  t10.email_bcc_email AS email_bcc_email_22,
  t10.email_from_address AS email_from_address_23,
  t10.login_page_logo AS login_page_logo_24,
  t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25,
  t10.notifications_enabled AS notifications_enabled_26,
  t10.alerts_enabled AS alerts_enabled_27,
  t10.schedule_enabled AS schedule_enabled_28,
  t10.info_template_id AS info_template_id_29
FROM
  templates t0
  LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id
  INNER JOIN users_groups_extra_info_templates ON t0.id = users_groups_extra_info_templates.template_id
WHERE
  users_groups_extra_info_templates.user_group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id INNER JOIN users_groups_extra_info_templates ON t0.id = users_groups_extra_info_templates.template_id WHERE users_groups_extra_info_templates.user_group_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Valt\UserBundle\Entity\UserGroup->getInfoTemplates (line 724)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
12	JMS\Serializer\Serializer->visit (line 256)
13	JMS\Serializer\Serializer->serialize (line 163)
14	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

1.36 ms
(0.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id INNER JOIN users_groups_extra_evaluation_templates ON t0.id = users_groups_extra_evaluation_templates.template_id WHERE users_groups_extra_evaluation_templates.user_group_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity_name AS entity_name_3,
  t0.type AS type_4,
  t0.is_hidden AS is_hidden_5,
  t0.duration_type AS duration_type_6,
  t0.duration AS duration_7,
  t0.deleted_at AS deleted_at_8,
  t0.container_id AS container_id_9,
  t10.id AS id_11,
  t10.date_time_format AS date_time_format_12,
  t10.time_format AS time_format_13,
  t10.comment_overlay_font_size AS comment_overlay_font_size_14,
  t10.streaming_method AS streaming_method_15,
  t10.smtp_server_address AS smtp_server_address_16,
  t10.smtp_server_port AS smtp_server_port_17,
  t10.email_encryption AS email_encryption_18,
  t10.email_username AS email_username_19,
  t10.email_password AS email_password_20,
  t10.email_from_name AS email_from_name_21,
  t10.email_bcc_email AS email_bcc_email_22,
  t10.email_from_address AS email_from_address_23,
  t10.login_page_logo AS login_page_logo_24,
  t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25,
  t10.notifications_enabled AS notifications_enabled_26,
  t10.alerts_enabled AS alerts_enabled_27,
  t10.schedule_enabled AS schedule_enabled_28,
  t10.info_template_id AS info_template_id_29
FROM
  templates t0
  LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id
  INNER JOIN users_groups_extra_evaluation_templates ON t0.id = users_groups_extra_evaluation_templates.template_id
WHERE
  users_groups_extra_evaluation_templates.user_group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id INNER JOIN users_groups_extra_evaluation_templates ON t0.id = users_groups_extra_evaluation_templates.template_id WHERE users_groups_extra_evaluation_templates.user_group_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	Valt\UserBundle\Entity\UserGroup->getEvaluationTemplates (line 703)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
12	JMS\Serializer\Serializer->visit (line 256)
13	JMS\Serializer\Serializer->serialize (line 163)
14	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

1.26 ms
(0.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.has_gpu AS has_gpu_13,
  t0.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	Valt\BasicBundle\EventListener\ConnectSrcToCSPHeaderAdder->addInternalAddressesToCSPHeaders (line 85)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.16 ms
(0.58%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.password AS password_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.roles AS roles_9, t0.userType AS userType_10, t0.ldapScript AS ldapScript_11, t0.ldapDomain AS ldapDomain_12, t0.ldapDN AS ldapDN_13, t0.display_name AS display_name_14, t0.card_number AS card_number_15, t0.pin AS pin_16, t0.control_type AS control_type_17, t0.disabled_access AS disabled_access_18, t0.ldap_extra_data AS ldap_extra_data_19, t0.login_failures AS login_failures_20, t0.login_block_start AS login_block_start_21, t0.last_passwords AS last_passwords_22, t0.last_change_password_date AS last_change_password_date_23, t0.night_mode AS night_mode_24, t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25, t0.auto_play_audio_comments AS auto_play_audio_comments_26, t0.notification_sound AS notification_sound_27, t0.avatar_filename AS avatar_filename_28, t0.avatar_original_filename AS avatar_original_filename_29, t0.emails_alerts_enabled AS emails_alerts_enabled_30, t0.zoom_step AS zoom_step_31, t0.api_token AS api_token_32, t0.deleted_at AS deleted_at_33, t0.group_id AS group_id_34, t0.ldap_sync_id AS ldap_sync_id_35, t0.saml_config_id AS saml_config_id_36, t0.zoom_account_id AS zoom_account_id_37, t38.notifications_enabled AS notifications_enabled_39, t38.notifications_frequency AS notifications_frequency_40, t38.notifications_schedule_enabled AS notifications_schedule_enabled_41, t38.notifications_cron_last_execute AS notifications_cron_last_execute_42, t38.user_id AS user_id_43, t0.expiration_from_id AS expiration_from_id_44, t0.r_access_id AS r_access_id_45 FROM users t0 LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.roles AS roles_9,
  t0.userType AS userType_10,
  t0.ldapScript AS ldapScript_11,
  t0.ldapDomain AS ldapDomain_12,
  t0.ldapDN AS ldapDN_13,
  t0.display_name AS display_name_14,
  t0.card_number AS card_number_15,
  t0.pin AS pin_16,
  t0.control_type AS control_type_17,
  t0.disabled_access AS disabled_access_18,
  t0.ldap_extra_data AS ldap_extra_data_19,
  t0.login_failures AS login_failures_20,
  t0.login_block_start AS login_block_start_21,
  t0.last_passwords AS last_passwords_22,
  t0.last_change_password_date AS last_change_password_date_23,
  t0.night_mode AS night_mode_24,
  t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25,
  t0.auto_play_audio_comments AS auto_play_audio_comments_26,
  t0.notification_sound AS notification_sound_27,
  t0.avatar_filename AS avatar_filename_28,
  t0.avatar_original_filename AS avatar_original_filename_29,
  t0.emails_alerts_enabled AS emails_alerts_enabled_30,
  t0.zoom_step AS zoom_step_31,
  t0.api_token AS api_token_32,
  t0.deleted_at AS deleted_at_33,
  t0.group_id AS group_id_34,
  t0.ldap_sync_id AS ldap_sync_id_35,
  t0.saml_config_id AS saml_config_id_36,
  t0.zoom_account_id AS zoom_account_id_37,
  t38.notifications_enabled AS notifications_enabled_39,
  t38.notifications_frequency AS notifications_frequency_40,
  t38.notifications_schedule_enabled AS notifications_schedule_enabled_41,
  t38.notifications_cron_last_execute AS notifications_cron_last_execute_42,
  t38.user_id AS user_id_43,
  t0.expiration_from_id AS expiration_from_id_44,
  t0.r_access_id AS r_access_id_45
FROM
  users t0
  LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.password AS password_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.roles AS roles_9, t0.userType AS userType_10, t0.ldapScript AS ldapScript_11, t0.ldapDomain AS ldapDomain_12, t0.ldapDN AS ldapDN_13, t0.display_name AS display_name_14, t0.card_number AS card_number_15, t0.pin AS pin_16, t0.control_type AS control_type_17, t0.disabled_access AS disabled_access_18, t0.ldap_extra_data AS ldap_extra_data_19, t0.login_failures AS login_failures_20, t0.login_block_start AS login_block_start_21, t0.last_passwords AS last_passwords_22, t0.last_change_password_date AS last_change_password_date_23, t0.night_mode AS night_mode_24, t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25, t0.auto_play_audio_comments AS auto_play_audio_comments_26, t0.notification_sound AS notification_sound_27, t0.avatar_filename AS avatar_filename_28, t0.avatar_original_filename AS avatar_original_filename_29, t0.emails_alerts_enabled AS emails_alerts_enabled_30, t0.zoom_step AS zoom_step_31, t0.api_token AS api_token_32, t0.deleted_at AS deleted_at_33, t0.group_id AS group_id_34, t0.ldap_sync_id AS ldap_sync_id_35, t0.saml_config_id AS saml_config_id_36, t0.zoom_account_id AS zoom_account_id_37, t38.notifications_enabled AS notifications_enabled_39, t38.notifications_frequency AS notifications_frequency_40, t38.notifications_schedule_enabled AS notifications_schedule_enabled_41, t38.notifications_cron_last_execute AS notifications_cron_last_execute_42, t38.user_id AS user_id_43, t0.expiration_from_id AS expiration_from_id_44, t0.r_access_id AS r_access_id_45 FROM users t0 LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Valt\UserBundle\Entity\User::getGroup (line 657)
5	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
6	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
7	JMS\Serializer\Serializer->visit (line 256)
8	JMS\Serializer\Serializer->serialize (line 163)
9	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

1.12 ms
(0.56%)

SELECT t0.id AS id_1, t0.provider_type, t0.name AS name_2, t0.aws_access_key_id AS aws_access_key_id_3, t0.aws_secret_key AS aws_secret_key_4, t0.aws_s3_bucket_name AS aws_s3_bucket_name_5, t0.aws_region AS aws_region_6, t0.host_wowza_id AS host_wowza_id_7 FROM transcription_service t0 WHERE t0.id = ? AND t0.provider_type IN ('aws', 'local')

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.provider_type,
  t0.name AS name_2,
  t0.aws_access_key_id AS aws_access_key_id_3,
  t0.aws_secret_key AS aws_secret_key_4,
  t0.aws_s3_bucket_name AS aws_s3_bucket_name_5,
  t0.aws_region AS aws_region_6,
  t0.host_wowza_id AS host_wowza_id_7
FROM
  transcription_service t0
WHERE
  t0.id = ?
  AND t0.provider_type IN ('aws', 'local')

SELECT t0.id AS id_1, t0.provider_type, t0.name AS name_2, t0.aws_access_key_id AS aws_access_key_id_3, t0.aws_secret_key AS aws_secret_key_4, t0.aws_s3_bucket_name AS aws_s3_bucket_name_5, t0.aws_region AS aws_region_6, t0.host_wowza_id AS host_wowza_id_7 FROM transcription_service t0 WHERE t0.id = 14 AND t0.provider_type IN ('aws', 'local');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2531)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
9	Doctrine\ORM\EntityRepository->findBy (line 110)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
11	Doctrine\ORM\EntityRepository->findAll (line 96)
12	Valt\BasicBundle\EventListener\ConnectSrcToCSPHeaderAdder->addInternalAddressesToCSPHeaders (line 85)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.96 ms
(0.48%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.enabled AS enabled_2 FROM rights r0_ WHERE r0_.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.enabled AS enabled_2
FROM
  rights r0_
WHERE
  r0_.enabled = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.enabled AS enabled_2 FROM rights r0_ WHERE r0_.enabled = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Valt\UserBundle\Repository\RightRepository->findEnabled (line 39)
7	Valt\UserBundle\DoctrineListener\PredefinedRightsHydrationSubscriber->postLoad (line 36)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
16	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
17	Valt\UserBundle\Entity\User::getGroup (line 657)
18	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
19	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
20	JMS\Serializer\Serializer->visit (line 256)
21	JMS\Serializer\Serializer->serialize (line 163)
22	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.93 ms
(0.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.record_duration AS record_duration_3, t0.record_duration_selection_type AS record_duration_selection_type_4, t0.io_record_name AS io_record_name_5, t0.search_results AS search_results_6, t0.room_sorting_order AS room_sorting_order_7, t0.disabled_access AS disabled_access_8, t0.default_review_view AS default_review_view_9, t0.default_schedule_view AS default_schedule_view_10, t0.default_report_view AS default_report_view_11, t0.default_review_list_period AS default_review_list_period_12, t0.deleted_users_video_access AS deleted_users_video_access_13, t0.without_groups_users_video_access AS without_groups_users_video_access_14, t0.deleted_at AS deleted_at_15, t0.comment_template_id AS comment_template_id_16, t0.marker_template_id AS marker_template_id_17, t0.info_template_id AS info_template_id_18, t0.evaluation_template_id AS evaluation_template_id_19, t0.default_retention_rule_id AS default_retention_rule_id_20, t0.expiration_from_id AS expiration_from_id_21, t0.container_id AS container_id_22, t0.r_access_id AS r_access_id_23 FROM user_groups t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.record_duration AS record_duration_3,
  t0.record_duration_selection_type AS record_duration_selection_type_4,
  t0.io_record_name AS io_record_name_5,
  t0.search_results AS search_results_6,
  t0.room_sorting_order AS room_sorting_order_7,
  t0.disabled_access AS disabled_access_8,
  t0.default_review_view AS default_review_view_9,
  t0.default_schedule_view AS default_schedule_view_10,
  t0.default_report_view AS default_report_view_11,
  t0.default_review_list_period AS default_review_list_period_12,
  t0.deleted_users_video_access AS deleted_users_video_access_13,
  t0.without_groups_users_video_access AS without_groups_users_video_access_14,
  t0.deleted_at AS deleted_at_15,
  t0.comment_template_id AS comment_template_id_16,
  t0.marker_template_id AS marker_template_id_17,
  t0.info_template_id AS info_template_id_18,
  t0.evaluation_template_id AS evaluation_template_id_19,
  t0.default_retention_rule_id AS default_retention_rule_id_20,
  t0.expiration_from_id AS expiration_from_id_21,
  t0.container_id AS container_id_22,
  t0.r_access_id AS r_access_id_23
FROM
  user_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.record_duration AS record_duration_3, t0.record_duration_selection_type AS record_duration_selection_type_4, t0.io_record_name AS io_record_name_5, t0.search_results AS search_results_6, t0.room_sorting_order AS room_sorting_order_7, t0.disabled_access AS disabled_access_8, t0.default_review_view AS default_review_view_9, t0.default_schedule_view AS default_schedule_view_10, t0.default_report_view AS default_report_view_11, t0.default_review_list_period AS default_review_list_period_12, t0.deleted_users_video_access AS deleted_users_video_access_13, t0.without_groups_users_video_access AS without_groups_users_video_access_14, t0.deleted_at AS deleted_at_15, t0.comment_template_id AS comment_template_id_16, t0.marker_template_id AS marker_template_id_17, t0.info_template_id AS info_template_id_18, t0.evaluation_template_id AS evaluation_template_id_19, t0.default_retention_rule_id AS default_retention_rule_id_20, t0.expiration_from_id AS expiration_from_id_21, t0.container_id AS container_id_22, t0.r_access_id AS r_access_id_23 FROM user_groups t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Valt\UserBundle\Entity\UserGroup::getName (line 376)
5	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
6	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
7	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
8	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
9	JMS\Serializer\Serializer->visit (line 256)
10	JMS\Serializer\Serializer->serialize (line 163)
11	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.92 ms
(0.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id WHERE t0.id = ?

Parameters:

[
  666
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity_name AS entity_name_3,
  t0.type AS type_4,
  t0.is_hidden AS is_hidden_5,
  t0.duration_type AS duration_type_6,
  t0.duration AS duration_7,
  t0.deleted_at AS deleted_at_8,
  t0.container_id AS container_id_9,
  t10.id AS id_11,
  t10.date_time_format AS date_time_format_12,
  t10.time_format AS time_format_13,
  t10.comment_overlay_font_size AS comment_overlay_font_size_14,
  t10.streaming_method AS streaming_method_15,
  t10.smtp_server_address AS smtp_server_address_16,
  t10.smtp_server_port AS smtp_server_port_17,
  t10.email_encryption AS email_encryption_18,
  t10.email_username AS email_username_19,
  t10.email_password AS email_password_20,
  t10.email_from_name AS email_from_name_21,
  t10.email_bcc_email AS email_bcc_email_22,
  t10.email_from_address AS email_from_address_23,
  t10.login_page_logo AS login_page_logo_24,
  t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25,
  t10.notifications_enabled AS notifications_enabled_26,
  t10.alerts_enabled AS alerts_enabled_27,
  t10.schedule_enabled AS schedule_enabled_28,
  t10.info_template_id AS info_template_id_29
FROM
  templates t0
  LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity_name AS entity_name_3, t0.type AS type_4, t0.is_hidden AS is_hidden_5, t0.duration_type AS duration_type_6, t0.duration AS duration_7, t0.deleted_at AS deleted_at_8, t0.container_id AS container_id_9, t10.id AS id_11, t10.date_time_format AS date_time_format_12, t10.time_format AS time_format_13, t10.comment_overlay_font_size AS comment_overlay_font_size_14, t10.streaming_method AS streaming_method_15, t10.smtp_server_address AS smtp_server_address_16, t10.smtp_server_port AS smtp_server_port_17, t10.email_encryption AS email_encryption_18, t10.email_username AS email_username_19, t10.email_password AS email_password_20, t10.email_from_name AS email_from_name_21, t10.email_bcc_email AS email_bcc_email_22, t10.email_from_address AS email_from_address_23, t10.login_page_logo AS login_page_logo_24, t10.camera_alert_delay_seconds AS camera_alert_delay_seconds_25, t10.notifications_enabled AS notifications_enabled_26, t10.alerts_enabled AS alerts_enabled_27, t10.schedule_enabled AS schedule_enabled_28, t10.info_template_id AS info_template_id_29 FROM templates t0 LEFT JOIN global_settings t10 ON t10.info_template_id = t0.id WHERE t0.id = 666;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Valt\Template\Domain\Entity\Template::getName (line 275)
5	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
6	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
7	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
8	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
9	call_user_func_array (line 50)
10	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::{closure:JMS\SerializerBundle\Debug\TraceableHandlerRegistry::getHandler():47} (line 50)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
12	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
13	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
14	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
15	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
16	JMS\Serializer\Serializer->visit (line 256)
17	JMS\Serializer\Serializer->serialize (line 163)
18	Valt\MobileBundle\Controller\User\GetUserController->__invoke (line 39)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

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
Valt\UserBundle\Entity\Right	144
Valt\Template\Domain\Entity\TemplateField	140
Valt\Template\Domain\Entity\TemplateFieldOption	65
Valt\Template\Domain\Entity\Template	59
Valt\CamBundle\Entity\Room	36
Valt\CamBundle\Entity\DeviceSource	34
Valt\UserBundle\Entity\User	8
Valt\UserBundle\Entity\Container	7
Valt\CamBundle\Entity\SharingLink\SharingLink	7
Valt\CamBundle\Entity\Device\Device	6
Valt\CamBundle\Entity\Room\MotionDetection	6
Valt\CamBundle\Entity\Wowza	3
Valt\CamBundle\Entity\Device\Camera\MotionDetection	3
Valt\CamBundle\Entity\Device\Camera\MotionDetection\Mask	3
Valt\CamBundle\Entity\Wowza\Routing	3
Valt\CamBundle\Entity\Wowza\Status	3
Valt\CamBundle\Entity\Expiration	2
Valt\CamBundle\Entity\RestrictAccess	2
Valt\UserBundle\Entity\UserGroup	1
Valt\UserBundle\Entity\UserEmailSettings	1
Valt\CamBundle\Entity\RetentionRule	1
Valt\CamBundle\Entity\Device\Ocr\OcrConfig	1
Valt\BasicBundle\Entity\GlobalSettings	1
Valt\CamBundle\Entity\TranscriptionService	1
Valt\CamBundle\Entity\Wowza\Storage	1
Valt\CamBundle\Entity\WowzaSync	1

Entities Mapping

Class	Mapping errors
Valt\CamBundle\Entity\Device\Device	No errors.
Valt\CamBundle\Entity\Device\Ocr\OcrConfig	No errors.
Valt\CamBundle\Entity\Wowza	The field Valt\CamBundle\Entity\Wowza#rooms is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Room#wowza does not contain the required 'inversedBy: "rooms"' attribute. The field Valt\CamBundle\Entity\Wowza#videoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Record\Video\VideoLocation#wowza does not contain the required 'inversedBy: "videoLocations"' attribute. The field Valt\CamBundle\Entity\Wowza#audioRecordings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Audio#wowza does not contain the required 'inversedBy: "audioRecordings"' attribute.
Valt\CamBundle\Entity\Device\Camera\Camera	No errors.
Valt\CamBundle\Entity\Device\MobileDevice\MobileDevice	No errors.
Valt\CamBundle\Entity\Device\MobileDevice\Beam	No errors.
Valt\CamBundle\Entity\Device\MobileDevice\Roam	No errors.
Valt\CamBundle\Entity\Device\Controller	No errors.
Valt\CamBundle\Entity\Device\Stream	No errors.
Valt\UserBundle\Entity\User	No errors.
Valt\CamBundle\Entity\DeviceSource	No errors.
Valt\CamBundle\Entity\Preset	No errors.
Valt\CamBundle\Entity\Alert	No errors.
Valt\UserBundle\Entity\UserGroup	No errors.
Valt\UserBundle\Entity\LdapSynchronize	No errors.
Valt\SsoBundle\Entity\SsoConfig	No errors.
Valt\ZoomIntegration\Domain\Entity\Account	No errors.
Valt\UserBundle\Entity\UserEmailSettings	No errors.
Valt\CamBundle\Entity\Expiration	No errors.
Valt\CamBundle\Entity\RestrictAccess	No errors.
Valt\CamBundle\Entity\Room	The field Valt\CamBundle\Entity\Room#groups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\UserBundle\Entity\UserGroup#rooms does not contain the required 'inversedBy: "groups"' attribute.
Valt\CamBundle\Entity\Filter	No errors.
Valt\CamBundle\Entity\Report\Report	No errors.
Valt\UserBundle\Entity\UserSection	No errors.
Valt\CamBundle\Entity\Evaluation	No errors.
Valt\UserBundle\Entity\Right	No errors.
Valt\Template\Domain\Entity\Template	No errors.
Valt\CamBundle\Entity\RetentionRule	No errors.
Valt\UserBundle\Entity\Container	The field Valt\UserBundle\Entity\Container#userGroups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\UserBundle\Entity\UserGroup#container does not contain the required 'inversedBy: "userGroups"' attribute.
Valt\UserBundle\Entity\UserGroupRight	No errors.
Valt\CamBundle\Entity\TranscriptionService	No errors.
Valt\CamBundle\Entity\TranscriptionService\AwsTranscriptionService	No errors.
Valt\Cue\Session\Domain\Entity\SessionTrackCode	No errors.
Valt\Cue\Session\Domain\Entity\SessionTrack	No errors.
Valt\CamBundle\Entity\Recording	No errors.
Valt\CamBundle\Entity\Record\Record	No errors.
Valt\CamBundle\Entity\Record\StandaloneRecord	No errors.
Valt\CamBundle\Entity\Record\RecordedRecord	No errors.
Valt\CamBundle\Entity\ScheduleSession	No errors.
Valt\CamBundle\Entity\SharingLink\SharingLink	No errors.
Valt\CamBundle\Entity\Room\MotionDetection	No errors.
Valt\CamBundle\Entity\IOCommand	No errors.
Valt\Cue\Session\Domain\Entity\Session	No errors.
Valt\CamBundle\Entity\SharingLink\RecordSharingLink	No errors.
Valt\CamBundle\Entity\Device\Camera\MotionDetection	No errors.
Valt\CamBundle\Entity\Device\Camera\MotionDetection\Mask	The field Valt\CamBundle\Entity\Device\Camera\MotionDetection\Mask#motionDetection is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Device\Camera\MotionDetection#mask does not contain the required 'inversedBy: "motionDetection"' attribute.
Valt\CamBundle\Entity\Device\Ocr\OcrArea	No errors.
Valt\BasicBundle\Entity\GlobalSettings	No errors.
Valt\Template\Domain\Entity\TemplateField	No errors.
Valt\CamBundle\Entity\Comment\Comment	The field Valt\CamBundle\Entity\Comment\Comment#commentFiles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\CommentFile#comment does not contain the required 'inversedBy: "commentFiles"' attribute.
Valt\CamBundle\Entity\Report\InformationReport	No errors.
Valt\CamBundle\Entity\Report\CommentReport	No errors.
Valt\CamBundle\Entity\Schedule	No errors.
Valt\Cue\Session\Domain\Entity\SessionAssignment	No errors.
Valt\Template\Domain\Entity\TemplateFieldOption	No errors.
Valt\Template\Domain\Entity\MultipointRow	No errors.
Valt\Template\Domain\Entity\MultipointColumn	No errors.
Valt\BasicBundle\Entity\LoginPageImage	No errors.
Valt\CamBundle\Entity\WowzaSync	No errors.
Valt\CamBundle\Entity\Wowza\Routing	No errors.
Valt\CamBundle\Entity\Wowza\Status	No errors.
Valt\CamBundle\Entity\Wowza\Storage	No errors.
Valt\CamBundle\Entity\TranscriptionService\LocalTranscriptionService	No errors.
Valt\CamBundle\Entity\Record\Video\VideoLocation	No errors.
Valt\CamBundle\Entity\Audio	No errors.

Symfony Profiler

GET https://dev.valt.forasoft.com/mobile/api/v2/users/1?deviceUID=1475

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping