GET http://cyklodev.com/

Query Metrics

13 Database Queries
6 Different statements
9.15 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.11 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 LIMIT 4
Parameters:
[
  0
]
2 0.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.body AS body_4, t0.publish AS publish_5, t0.createdAt AS createdAt_6, t0.category_id AS category_id_7 FROM blog_post t0 WHERE t0.publish = ? ORDER BY t0.id DESC LIMIT 3
Parameters:
[
  1
]
3 0.85 ms
SELECT g0_.id AS id_0, g0_.github_id AS github_id_1, g0_.name AS name_2, g0_.full_name AS full_name_3, g0_.description AS description_4, g0_.html_url AS html_url_5, g0_.language AS language_6, g0_.stargazers_count AS stargazers_count_7, g0_.forks_count AS forks_count_8, g0_.pushed_at AS pushed_at_9, g0_.archived AS archived_10, g0_.fork AS fork_11, g0_.private AS private_12, g0_.position AS position_13, g0_.synced_at AS synced_at_14 FROM github_repository g0_ WHERE g0_.private = ? ORDER BY g0_.position ASC, g0_.pushed_at DESC, g0_.id ASC LIMIT 3
Parameters:
[
  0
]
4 0.82 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
]
5 0.55 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
]
6 0.75 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
]
7 0.69 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
]
8 0.73 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
]
9 0.55 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
]
10 0.75 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
]
11 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:
[
  6
]
12 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]

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 4
App\Entity\ProjectCat 4
App\Entity\BlogPost 3
App\Entity\GitHubRepository 3
App\Entity\Category 2
App\Entity\ProjectScreenshot 2

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\ProjectCat No errors.
App\Entity\ProjectScreenshot No errors.
App\Entity\BlogPost No errors.
App\Entity\Category No errors.
App\Entity\GitHubRepository No errors.