GET http://cyklodev.com/projects

Query Metrics

27 Database Queries
3 Different statements
79.59 ms Query time
0 Invalid entities
27 Managed entities

Queries

Group similar statements

#▲ Time Info
1 55.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url AS url_4, t0.repository_url AS repository_url_5, t0.image AS image_6, t0.body AS body_7, t0.published AS published_8, t0.stopped AS stopped_9, t0.licence AS licence_10, t0.licence_body AS licence_body_11, t0.projectcat_id AS projectcat_id_12 FROM project t0 WHERE t0.stopped = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
2 7.92 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url AS url_4, t0.repository_url AS repository_url_5, t0.image AS image_6, t0.body AS body_7, t0.published AS published_8, t0.stopped AS stopped_9, t0.licence AS licence_10, t0.licence_body AS licence_body_11, t0.projectcat_id AS projectcat_id_12 FROM project t0 WHERE t0.stopped = ? ORDER BY t0.id DESC
Parameters:
[
  1
]
3 0.80 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  20
]
4 0.72 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  8
]
5 0.66 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  19
]
6 0.46 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  12
]
8 0.51 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  7
]
9 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  11
]
10 0.46 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  6
]
11 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  9
]
12 0.51 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.89 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  3
]
14 0.47 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  1
]
16 0.68 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  18
]
17 0.46 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  5
]
18 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  17
]
19 0.74 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  13
]
20 0.65 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  10
]
21 0.68 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  8
]
22 0.68 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  7
]
23 0.68 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  6
]
24 0.69 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  5
]
25 0.65 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  4
]
26 0.67 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  2
]
27 0.50 ms
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
  3
]

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 17
App\Entity\ProjectCat 8
App\Entity\ProjectScreenshot 2

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\ProjectCat No errors.
App\Entity\ProjectScreenshot No errors.