Query Metrics

10 Database Queries
5 Different statements
4.69 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 1.01 ms
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
  "https://rct.dev.bbntimes.com/support/terms-and-conditions"
  "published"
]
2 1.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.orders AS orders_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.canonical AS canonical_11, t0.image_id AS image_id_12 FROM PAGE t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "terms-and-conditions"
  "published"
]
3 0.43 ms
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
  "https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis"
  "published"
]
4 0.38 ms
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
  "https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderHeader"
  "published"
]
5 0.48 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = ? ORDER BY c0_.orders ASC
Parameters:
[
  "published"
]
6 0.37 ms
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = ? ORDER BY p0_.orders ASC
Parameters:
[
  "published"
]
7 0.29 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "facebook"
  "general"
]
8 0.15 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "twitter"
  "general"
]
9 0.17 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "linkedin"
  "general"
]
10 0.18 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "youtube"
  "general"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
App\Entity\Redirection No errors.
App\Entity\Page
  • The association App\Entity\Page#image refers to the inverse side field App\Entity\File#pages which does not exist.
App\Entity\File No errors.
App\Entity\Category No errors.
App\Entity\Article No errors.
App\Entity\Setting No errors.