https://www.aperove.com/jackpot-lottery

Query Metrics

36 Database Queries
11 Different statements
7.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.