Query Metrics
34
Database Queries
9
Different statements
7.77 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.34 ms |
SELECT t0.id AS id_1, t0.last_visited_at AS last_visited_at_2, t0.visits AS visits_3, t0.route AS route_4, t0.url AS url_5, t0.referrer AS referrer_6, t0.ip AS ip_7, t0.os AS os_8, t0.browser AS browser_9, t0.country AS country_10, t0.city AS city_11, t0.user_id AS user_id_12 FROM visitor t0 WHERE t0.ip = ? AND t0.route = ? LIMIT 1
Parameters:
[ "49.51.233.95" "homepage" ] |
2 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.32 ms |
INSERT INTO visitor (last_visited_at, visits, route, url, referrer, ip, os, browser, country, city, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2025-09-05 16:25:34" 1 "homepage" "https://www.aperove.com/" "http://aperove.com" "49.51.233.95" "Mac" "Safari" "Unknown Country" "Unknown City" null ] |
4 | 0.87 ms |
"COMMIT"
Parameters:
[] |
5 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short AS short_4, t0.text AS text_5, t0.thumb AS thumb_6, t0.image AS image_7, t0.cover AS cover_8, t0.layout AS layout_9, t0.show_in_home AS show_in_home_10, t0.pagetitle AS pagetitle_11, t0.meta_description AS meta_description_12, t0.head_code AS head_code_13, t0.body_code AS body_code_14, t0.icon AS icon_15, t0.created_at AS created_at_16, t0.parent_id AS parent_id_17 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"صفحه-اصلی"
]
|
6 | 0.28 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short AS short_3, p0_.text AS text_4, p0_.thumb AS thumb_5, p0_.image AS image_6, p0_.cover AS cover_7, p0_.layout AS layout_8, p0_.show_in_home AS show_in_home_9, p0_.pagetitle AS pagetitle_10, p0_.meta_description AS meta_description_11, p0_.head_code AS head_code_12, p0_.body_code AS body_code_13, p0_.icon AS icon_14, p0_.created_at AS created_at_15, p0_.parent_id AS parent_id_16 FROM page p0_ WHERE p0_.layout = ? ORDER BY p0_.created_at DESC
Parameters:
[
"feature"
]
|
7 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short AS short_3, p0_.text AS text_4, p0_.thumb AS thumb_5, p0_.image AS image_6, p0_.cover AS cover_7, p0_.layout AS layout_8, p0_.show_in_home AS show_in_home_9, p0_.pagetitle AS pagetitle_10, p0_.meta_description AS meta_description_11, p0_.head_code AS head_code_12, p0_.body_code AS body_code_13, p0_.icon AS icon_14, p0_.created_at AS created_at_15, p0_.parent_id AS parent_id_16 FROM page p0_ WHERE p0_.layout = ? ORDER BY p0_.created_at DESC
Parameters:
[
"post"
]
|
8 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short AS short_3, p0_.text AS text_4, p0_.thumb AS thumb_5, p0_.image AS image_6, p0_.cover AS cover_7, p0_.layout AS layout_8, p0_.show_in_home AS show_in_home_9, p0_.pagetitle AS pagetitle_10, p0_.meta_description AS meta_description_11, p0_.head_code AS head_code_12, p0_.body_code AS body_code_13, p0_.icon AS icon_14, p0_.created_at AS created_at_15, p0_.parent_id AS parent_id_16 FROM page p0_ WHERE p0_.layout = ? ORDER BY p0_.created_at DESC
Parameters:
[
"archive"
]
|
9 | 0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short AS short_4, t0.text AS text_5, t0.thumb AS thumb_6, t0.image AS image_7, t0.cover AS cover_8, t0.layout AS layout_9, t0.show_in_home AS show_in_home_10, t0.pagetitle AS pagetitle_11, t0.meta_description AS meta_description_12, t0.head_code AS head_code_13, t0.body_code AS body_code_14, t0.icon AS icon_15, t0.created_at AS created_at_16, t0.parent_id AS parent_id_17 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"صفحه-اصلی"
]
|
10 | 0.26 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short AS short_3, p0_.text AS text_4, p0_.thumb AS thumb_5, p0_.image AS image_6, p0_.cover AS cover_7, p0_.layout AS layout_8, p0_.show_in_home AS show_in_home_9, p0_.pagetitle AS pagetitle_10, p0_.meta_description AS meta_description_11, p0_.head_code AS head_code_12, p0_.body_code AS body_code_13, p0_.icon AS icon_14, p0_.created_at AS created_at_15, p0_.parent_id AS parent_id_16 FROM page p0_ LEFT JOIN page p1_ ON p0_.parent_id = p1_.id WHERE p1_.slug = ? ORDER BY p0_.created_at DESC
Parameters:
[
"صفحه-اصلی"
]
|
11 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "banner" "صفحه-اصلی" ] |
12 | 0.18 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"banner"
]
|
13 | 0.16 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "infoBoxSlide" "صفحه-اصلی" ] |
14 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoBoxSlide"
]
|
15 | 0.15 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "infoBoxRow" "صفحه-اصلی" ] |
16 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoBoxRow"
]
|
17 | 0.16 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "infoBoxRow2" "صفحه-اصلی" ] |
18 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoBoxRow2"
]
|
19 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "infoImageText" "صفحه-اصلی" ] |
20 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoImageText"
]
|
21 | 0.16 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "faq" "صفحه-اصلی" ] |
22 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"faq"
]
|
23 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "faq2" "صفحه-اصلی" ] |
24 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"faq2"
]
|
25 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "contact" "صفحه-اصلی" ] |
26 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"contact"
]
|
27 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "customers" "صفحه-اصلی" ] |
28 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"customers"
]
|
29 | 0.13 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "plans" "صفحه-اصلی" ] |
30 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"plans"
]
|
31 | 0.18 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "features" "صفحه-اصلی" ] |
32 | 0.15 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"features"
]
|
33 | 0.14 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id INNER JOIN page p2_ ON c0_.page_id = p2_.id WHERE c1_.token = ? AND p2_.slug = ?
Parameters:
[ "plaintext" "صفحه-اصلی" ] |
34 | 0.12 ms |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.link AS link_4, c0_.sort AS sort_5, c0_.icon AS icon_6, c0_.text AS text_7, c0_.class_names AS class_names_8, c0_.content_id AS content_id_9, c0_.page_id AS page_id_10 FROM content_item c0_ INNER JOIN content c1_ ON c0_.content_id = c1_.id WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"plaintext"
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Stats\Visitor | No errors. |
App\Entity\User\User | No errors. |
App\Entity\CMS\Page | No errors. |
App\Entity\CMS\ContentItem | No errors. |
App\Entity\CMS\Content | No errors. |