POST http://dev.amply.tools/admin/graphql/

Query Metrics

10 Database Queries
6 Different statements
9.62 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 2.13 ms
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
2 1.49 ms
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.full_path_logo AS full_path_logo_3, t0.name AS name_4 FROM administration_organization t0 INNER JOIN administration_user_organization ON t0.id = administration_user_organization.organization_id WHERE administration_user_organization.amply_user_id = ?
Parameters:
[
  "413049a2-edcd-430f-b955-a0dfdae60678"
]
3 1.74 ms
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM administration_project a0_ WHERE a0_.organization_id = ?
Parameters:
[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
]
4 1.10 ms
SELECT DISTINCT id_0, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, ROW_NUMBER() OVER(ORDER BY a0_.id ASC) AS sclr_2 FROM administration_project a0_ WHERE a0_.organization_id = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 11
Parameters:
[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
]
5 0.65 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.organization_id AS organization_id_2 FROM administration_project a0_ WHERE a0_.organization_id = ? AND a0_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.id ASC
Parameters:
[
  "5b409a88-390b-47f4-b2df-7afe3cb8285a"
  "21d78a45-2d76-45a2-a958-1ba510fe598d"
  "64cdc9b2-1c6f-481d-bce4-210e9ff2777a"
  "68488f00-69d2-454c-bef6-a70ad37bb87e"
  "88946d55-6c7c-48e5-aca7-c3f093521bce"
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
]
6 0.77 ms
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?
Parameters:
[
  "21d78a45-2d76-45a2-a958-1ba510fe598d"
]
7 0.70 ms
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?
Parameters:
[
  "64cdc9b2-1c6f-481d-bce4-210e9ff2777a"
]
8 0.40 ms
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?
Parameters:
[
  "68488f00-69d2-454c-bef6-a70ad37bb87e"
]
9 0.36 ms
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?
Parameters:
[
  "88946d55-6c7c-48e5-aca7-c3f093521bce"
]
10 0.28 ms
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.project_id = ?
Parameters:
[
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
]

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
Amply\Administration\Entity\Project 5
Amply\Administration\Entity\Application 2
Amply\Administration\Entity\AmplyUser 1
Amply\Administration\Entity\Organization 1