GET https://www.vidstatus.co.in/tag/navaratri-status-video?page=2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.15 ms
(45.77%)
1
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:
[
  595
  "tag"
  1
  "216.73.216.148"
]
57.85 ms
(42.61%)
1
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
]
6.00 ms
(4.42%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM vid_tag t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "navaratri-status-video"
]
4.81 ms
(3.54%)
1
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
]
2.56 ms
(1.89%)
1
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 video_tags v2_ ON v0_.id = v2_.video_id LEFT JOIN vid_tag v1_ ON v1_.id = v2_.tag_id WHERE v1_.slug = ? AND v0_.status = 1 ORDER BY v0_.id DESC
Parameters:
[
  "navaratri-status-video"
]
1.40 ms
(1.03%)
1
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
]
1.00 ms
(0.74%)
1
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\Tags 1

Entities Mapping

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