GET https://dev-researchbay.skyworx.io/admin/project

Query Metrics

133 Database Queries
7 Different statements
473.10 ms Query time
0 Invalid entities
34 Managed entities

Grouped Statements

Show all queries

Time Count Info
417.03 ms
(88.15%)
100
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[
  1018
  "to_mailout"
]
22.71 ms
(4.80%)
20
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.header_text AS header_text_4, t0.footer_text AS footer_text_5, t0.email_subject AS email_subject_6, t0.email_body AS email_body_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.project_id AS project_id_11 FROM survey t0 WHERE t0.project_id = ?
Parameters:
[
  1018
]
22.62 ms
(4.78%)
9
SELECT t0.id AS id_1, t0.name AS name_2 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  18
]
4.83 ms
(1.02%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.27 ms
(0.48%)
1
SELECT count(p0_.id) AS sclr_0 FROM project p0_
Parameters:
[]
2.04 ms
(0.43%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date AS date_2, p0_.attendee_filter AS attendee_filter_3, p0_.customer_exclusion AS customer_exclusion_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.customer_id AS customer_id_7 FROM project p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC, p0_.id DESC
Parameters:
[
  1018
  1017
  1016
  1015
  1014
  1013
  1012
  1011
  1010
  1009
  1008
  1007
  1006
  1005
  1004
  1003
  1002
  1001
  1000
  999
]
1.60 ms
(0.34%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.id AS id_2 FROM project p0_ ORDER BY p0_.created_at DESC, p0_.id DESC LIMIT 20
Parameters:
[]

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\Project 20
App\Entity\Customer 9
App\Entity\Survey 4
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Project No errors.
App\Entity\Customer No errors.
App\Entity\Attendance No errors.
App\Entity\Attribute No errors.
App\Entity\Topic No errors.
App\Entity\Survey No errors.
App\Entity\SurveyQuestion No errors.
App\Entity\SurveyResponse No errors.
App\Entity\InvitationGroup No errors.
App\Entity\ProjectDocument No errors.