GET https://profajavon.com/

Query Metrics

18 Database Queries
6 Different statements
5.53 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM categories t0
Parameters:
[]
2 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 WHERE t0.is_popular = ?
Parameters:
[
  1
]
3 0.71 ms
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.banner_img AS banner_img_3, h0_.is_active AS is_active_4, h0_.slug AS slug_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.created_by AS created_by_8, h0_.updated_by AS updated_by_9 FROM header h0_ INNER JOIN header_tag h2_ ON h0_.id = h2_.header_id INNER JOIN tag t1_ ON t1_.id = h2_.tag_id WHERE t1_.name = ? ORDER BY h0_.title ASC
Parameters:
[
  "sliderLeft"
]
4 0.46 ms
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.banner_img AS banner_img_3, h0_.is_active AS is_active_4, h0_.slug AS slug_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.created_by AS created_by_8, h0_.updated_by AS updated_by_9 FROM header h0_ INNER JOIN header_tag h2_ ON h0_.id = h2_.header_id INNER JOIN tag t1_ ON t1_.id = h2_.tag_id WHERE t1_.name = ? ORDER BY h0_.title ASC
Parameters:
[
  "sliderRigth"
]
5 0.42 ms
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.banner_img AS banner_img_3, h0_.is_active AS is_active_4, h0_.slug AS slug_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.created_by AS created_by_8, h0_.updated_by AS updated_by_9 FROM header h0_ INNER JOIN header_tag h2_ ON h0_.id = h2_.header_id INNER JOIN tag t1_ ON t1_.id = h2_.tag_id WHERE t1_.name = ? ORDER BY h0_.title ASC
Parameters:
[
  "sliderMiddle"
]
6 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.banner_img AS banner_img_4, t0.is_active AS is_active_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM header t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
7 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  19
]
8 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  20
]
9 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  21
]
10 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  22
]
11 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  23
]
12 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  24
]
13 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  25
]
14 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.status AS status_6, t0.is_popular AS is_popular_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM courses t0 INNER JOIN courses_categories ON t0.id = courses_categories.courses_id WHERE courses_categories.categories_id = ?
Parameters:
[
  26
]
15 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM categories t0 INNER JOIN courses_categories ON t0.id = courses_categories.categories_id WHERE courses_categories.courses_id = ?
Parameters:
[
  13
]
16 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM categories t0 INNER JOIN courses_categories ON t0.id = courses_categories.categories_id WHERE courses_categories.courses_id = ?
Parameters:
[
  16
]
17 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM categories t0 INNER JOIN courses_categories ON t0.id = courses_categories.categories_id WHERE courses_categories.courses_id = ?
Parameters:
[
  17
]
18 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM categories t0 INNER JOIN courses_categories ON t0.id = courses_categories.categories_id WHERE courses_categories.courses_id = ?
Parameters:
[
  20
]

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\Courses 9
App\Entity\Categories 8
App\Entity\Header 3

Entities Mapping

Class Mapping errors
App\Entity\Categories No errors.
App\Entity\Courses No errors.
App\Entity\Documents No errors.
App\Entity\Downloads No errors.
App\Entity\Header No errors.
App\Entity\Tag No errors.