GET https://www.vidstatus.co.in/festival/navaratri/?page=2

Query Metrics

7 Database Queries
7 Different statements
119.59 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 1.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.title AS title_8, t0.cat_desc AS cat_desc_9, t0.seo_title AS seo_title_10, t0.keywords AS keywords_11, t0.seo_desc AS seo_desc_12, t0.desc_title AS desc_title_13, t0.video_count AS video_count_14 FROM festival t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "navaratri"
]
2 7.35 ms
SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.slug AS slug_3, v0_.status AS status_4, v0_.mime_type AS mime_type_5, v0_.file_name AS file_name_6, v0_.picture AS picture_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.duration AS duration_10, v0_.file_size AS file_size_11, v0_.total_view AS total_view_12, v0_.total_like AS total_like_13, v0_.total_dislike AS total_dislike_14, v0_.total_download AS total_download_15, v0_.lang_slug AS lang_slug_16, v0_.file_path AS file_path_17 FROM video v0_ LEFT JOIN festival f1_ ON v0_.festival = f1_.id WHERE f1_.slug = ? AND v0_.status = 1 ORDER BY v0_.id DESC
Parameters:
[
  "navaratri"
]
3 3.46 ms
SELECT c0_.id AS id_0, c0_.comment_at AS comment_at_1, c0_.obj_id AS obj_id_2, c0_.type AS type_3, c0_.website AS website_4, c0_.name AS name_5, c0_.email AS email_6, c0_.comment AS comment_7, c0_.ip_address AS ip_address_8, c0_.bg_color AS bg_color_9, c0_.status AS status_10, c0_.parent_id AS parent_id_11 FROM comments c0_ WHERE c0_.obj_id = ? AND c0_.type = ? AND c0_.parent_id IS NULL AND (c0_.status = ? OR c0_.ip_address = ?) ORDER BY c0_.comment_at DESC
Parameters:
[
  26
  "festival"
  1
  "216.73.216.148"
]
4 2.63 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.display_name AS display_name_2, v0_.slug AS slug_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.image_name AS image_name_6, v0_.title AS title_7, v0_.cat_desc AS cat_desc_8, v0_.seo_desc AS seo_desc_9, v0_.seo_title AS seo_title_10, v0_.desc_title AS desc_title_11, v0_.keywords AS keywords_12, v0_.has_child AS has_child_13, v0_.video_count AS video_count_14 FROM vid_category v0_ WHERE v0_.parent_id IS NULL AND v0_.video_count > ? ORDER BY v0_.name ASC LIMIT 5
Parameters:
[
  0
]
5 4.75 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.display_name AS display_name_3, f0_.image_name AS image_name_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.title AS title_7, f0_.cat_desc AS cat_desc_8, f0_.seo_title AS seo_title_9, f0_.keywords AS keywords_10, f0_.seo_desc AS seo_desc_11, f0_.desc_title AS desc_title_12, f0_.video_count AS video_count_13 FROM festival f0_ WHERE f0_.video_count > ? ORDER BY f0_.name ASC LIMIT 5
Parameters:
[
  0
]
6 22.35 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.display_name AS display_name_3, s0_.image_name AS image_name_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.title AS title_7, s0_.cat_desc AS cat_desc_8, s0_.seo_title AS seo_title_9, s0_.keywords AS keywords_10, s0_.seo_desc AS seo_desc_11, s0_.desc_title AS desc_title_12, s0_.video_count AS video_count_13 FROM singer s0_ WHERE s0_.video_count > ? ORDER BY s0_.name ASC LIMIT 5
Parameters:
[
  0
]
7 77.12 ms
SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.picture AS picture_2, v0_.slug AS slug_3, v0_.file_size AS file_size_4, v0_.total_view AS total_view_5, v0_.duration AS duration_6, v0_.slug AS slug_7, v1_.id AS id_8, v1_.name AS name_9, v1_.slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 5
Parameters:
[]

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\Festival 1

Entities Mapping

Class Mapping errors
App\Entity\Festival No errors.
App\Entity\Video No errors.
App\Entity\Comments No errors.
App\Entity\Category No errors.
App\Entity\Singer No errors.