GET https://dsides.dev/project/20

Query Metrics

5 Database Queries
5 Different statements
3.77 ms Query time
0 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.slug AS slug_4, t0.display_order AS display_order_5, t0.is_displayed AS is_displayed_6, t0.image AS image_7, t0.featured_image AS featured_image_8, t0.grid_image AS grid_image_9, t0.updated_at AS updated_at_10, t0.is_featured AS is_featured_11, t0.client_id AS client_id_12 FROM project t0 WHERE t0.id = ?
Parameters:
0 of 0
[ "20" ]
2 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.is_menu AS is_menu_5 FROM category t0
Parameters:
[]
3 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM client t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 5 ]
4 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.slug AS slug_4, t0.is_menu AS is_menu_5 FROM category t0 INNER JOIN project_category ON t0.id = project_category.category_id WHERE project_category.project_id = ?
Parameters:
0 of 0
[ 20 ]
5 0.66 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.project_id AS project_id_5 FROM attachment t0 WHERE t0.project_id = ?
Parameters:
0 of 0
[ 20 ]