https://noblenatives.com/store?style=1

Query Metrics

14 Database Queries
10 Different statements
2.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template_pack AS template_pack_5, t0.howitwork AS howitwork_6, t0.uid AS uid_7, t0.status AS status_8 FROM global_category t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
2 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template_pack AS template_pack_5, t0.design_width AS design_width_6, t0.design_height AS design_height_7, t0.global_category AS global_category_8, t0.uid AS uid_9, t0.status AS status_10 FROM product_category t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
3 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.howitwork AS howitwork_5, t0.uid AS uid_6, t0.status AS status_7 FROM product_type t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
4 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.description AS description_4, t0.image AS image_5, t0.sizechart AS sizechart_6, t0.howitwork AS howitwork_7, t0.product_category AS product_category_8, t0.uid AS uid_9, t0.status AS status_10 FROM style t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
5 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.price AS price_5, t0.uid AS uid_6, t0.status AS status_7 FROM size t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
6 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color_code AS color_code_3, t0.extra_code AS extra_code_4, t0.color_group AS color_group_5, t0.status AS status_6 FROM color t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
7 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.status AS status_4 FROM attribute t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "collections"
]
8 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.status AS status_4 FROM attribute t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "category"
]
9 0.41 ms
SELECT p0_.id AS id_0, p0_.path AS path_1, p0_.title AS title_2, p1_.id AS id_3, p1_.color AS color_4, p1_.size AS size_5, p2_.image AS image_6, p0_.styledescription AS styledescription_7, p0_.type AS type_8, p1_.price AS price_9, p1_.actual_price AS actual_price_10, p1_.total AS total_11, p0_.totalcount AS totalcount_12 FROM product p0_, product_variation p1_, product_image p2_ WHERE p1_.product_id = p0_.id AND p2_.product_id = p0_.id AND p0_.status = 1 AND p0_.style = ? GROUP BY p0_.id LIMIT 12
Parameters:
[
  "1"
]
10 0.15 ms
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.title AS title_3, t0.page AS page_4, t0.path AS path_5, t0.body AS body_6, t0.created AS created_7, t0.updated AS updated_8, t0.uid AS uid_9, t0.status AS status_10 FROM content t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "free_shipping_banner"
]
11 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.country AS country_4, t0.access AS access_5, t0.accessed AS accessed_6, t0.created AS created_7, t0.updated AS updated_8, t0.status AS status_9 FROM city t0 WHERE t0.status = ? ORDER BY t0.access DESC
Parameters:
[
  1
]
12 0.14 ms
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.title AS title_3, t0.page AS page_4, t0.path AS path_5, t0.body AS body_6, t0.created AS created_7, t0.updated AS updated_8, t0.uid AS uid_9, t0.status AS status_10 FROM content t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "site_insta_page"
]
13 0.13 ms
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.title AS title_3, t0.page AS page_4, t0.path AS path_5, t0.body AS body_6, t0.created AS created_7, t0.updated AS updated_8, t0.uid AS uid_9, t0.status AS status_10 FROM content t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "site_fb_page"
]
14 0.12 ms
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.title AS title_3, t0.page AS page_4, t0.path AS path_5, t0.body AS body_6, t0.created AS created_7, t0.updated AS updated_8, t0.uid AS uid_9, t0.status AS status_10 FROM content t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "site_yt_page"
]

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\GlobalCategory No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductType No errors.
App\Entity\Style No errors.
App\Entity\Size No errors.
App\Entity\Color No errors.
App\Entity\Attribute No errors.
App\Entity\Product No errors.
App\Entity\ProductVariation No errors.
App\Entity\ProductImage No errors.
App\Entity\Content No errors.
App\Entity\City No errors.