Query Metrics
36
Database Queries
11
Different statements
7.88 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.51 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:
[ "216.73.216.114" "page_show" ] |
2 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.26 ms |
UPDATE visitor SET last_visited_at = ?, visits = ? WHERE id = ?
Parameters:
[ "2025-09-03 12:23:53" 4 2579 ] |
4 | 0.72 ms |
"COMMIT"
Parameters:
[] |
5 | 0.26 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:
[
"jackpot-lottery"
]
|
6 | 0.27 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.19 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.18 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.19 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:
[
"jackpot-lottery"
]
|
10 | 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_ LEFT JOIN page p1_ ON p0_.parent_id = p1_.id WHERE p1_.slug = ? ORDER BY p0_.created_at DESC
Parameters:
[
"jackpot-lottery"
]
|
11 | 0.16 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.layout = ? LIMIT 1
Parameters:
[
"homepage"
]
|
12 | 0.20 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" "jackpot-lottery" ] |
13 | 0.20 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"
]
|
14 | 0.17 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" "jackpot-lottery" ] |
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 WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoBoxSlide"
]
|
16 | 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" "jackpot-lottery" ] |
17 | 0.17 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"
]
|
18 | 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:
[ "infoBoxRow2" "jackpot-lottery" ] |
19 | 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 WHERE c1_.token = ? AND c0_.page_id IS NULL
Parameters:
[
"infoBoxRow2"
]
|
20 | 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:
[ "infoImageText" "jackpot-lottery" ] |
21 | 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:
[
"infoImageText"
]
|
22 | 0.17 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" "jackpot-lottery" ] |
23 | 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:
[
"faq"
]
|
24 | 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:
[ "faq2" "jackpot-lottery" ] |
25 | 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:
[
"faq2"
]
|
26 | 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:
[ "contact" "jackpot-lottery" ] |
27 | 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"
]
|
28 | 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" "jackpot-lottery" ] |
29 | 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:
[
"customers"
]
|
30 | 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:
[ "plans" "jackpot-lottery" ] |
31 | 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"
]
|
32 | 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:
[ "features" "jackpot-lottery" ] |
33 | 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:
[
"features"
]
|
34 | 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:
[ "plaintext" "jackpot-lottery" ] |
35 | 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"
]
|
36 | 0.18 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.id = ?
Parameters:
[
9
]
|
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. |