https://sharmadesignhouse.com/blog

Query Metrics

12 Database Queries
10 Different statements
6.67 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.published AS published_4, t0.setting AS setting_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.template_id AS template_id_8, t0.created_by_id AS created_by_id_9 FROM blog t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "blog"
]
2 0.55 ms
SELECT t0.layout AS layout_1, t0.type AS type_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by_id AS created_by_id_6 FROM templates t0 WHERE t0.id = ?
Parameters:
[
  4
]
3 0.54 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metadata AS metadata_4, t0.tags AS tags_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10 FROM post t0
Parameters:
[]
4 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.content AS content_9, t0.slug AS slug_10, t0.parent_id AS parent_id_11, t0.created_by_id AS created_by_id_12 FROM category t0 INNER JOIN post_category ON t0.id = post_category.category_id WHERE post_category.post_id = ?
Parameters:
[
  1
]
5 0.51 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metadata AS metadata_4, t0.tags AS tags_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10 FROM post t0
Parameters:
[]
6 0.58 ms
SELECT t0.status AS status_1, t0.accepted_terms_at AS accepted_terms_at_2, t0.public_accessable AS public_accessable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.customer_id AS customer_id_7, t0.source_id AS source_id_8, t0.billing_id AS billing_id_9, t0.shipping_id AS shipping_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
  "cart"
]
7 0.45 ms
SELECT t0.status AS status_1, t0.accepted_terms_at AS accepted_terms_at_2, t0.public_accessable AS public_accessable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.customer_id AS customer_id_7, t0.source_id AS source_id_8, t0.billing_id AS billing_id_9, t0.shipping_id AS shipping_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
  "cart"
]
8 0.78 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT p0_.title AS title_0, p0_.content AS content_1, p0_.slug AS slug_2, p0_.metadata AS metadata_3, p0_.tags AS tags_4, p0_.published_at AS published_at_5, p0_.id AS id_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM post p0_) dctrn_result) dctrn_table
Parameters:
[]
9 0.54 ms
SELECT DISTINCT id_6 FROM (SELECT p0_.title AS title_0, p0_.content AS content_1, p0_.slug AS slug_2, p0_.metadata AS metadata_3, p0_.tags AS tags_4, p0_.published_at AS published_at_5, p0_.id AS id_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM post p0_) dctrn_result LIMIT 10
Parameters:
[]
10 0.49 ms
SELECT p0_.title AS title_0, p0_.content AS content_1, p0_.slug AS slug_2, p0_.metadata AS metadata_3, p0_.tags AS tags_4, p0_.published_at AS published_at_5, p0_.id AS id_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by_id AS created_by_id_9 FROM post p0_ WHERE p0_.id IN (?)
Parameters:
[
  1
]
11 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.content AS content_9, t0.slug AS slug_10, t0.parent_id AS parent_id_11, t0.created_by_id AS created_by_id_12 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
12 0.42 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.link AS link_3, t0.alt AS alt_4 FROM social_media t0
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.

Entities Mapping

Class Mapping errors
App\Entity\Blog No errors.
App\Entity\Templates No errors.
App\Entity\User No errors.
App\Entity\Post No errors.
App\Entity\Category No errors.
App\Entity\Comment No errors.
App\Entity\Product No errors.
App\Entity\Order No errors.
App\Entity\Customer No errors.
App\Entity\Source No errors.
App\Entity\Address No errors.
App\Entity\SocialMedia No errors.