GET https://siatecbrasil.com.br/en/produto/Roasters-for-the-Black-Gold-Specialty-Coffee-Line-18

Query Metrics

16 Database Queries
11 Different statements
1.36 ms Query time
0 Invalid entities
29 Managed entities

Queries

Group similar statements

# Time Info
1 0.16 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.language AS language_3, p0_.content_html AS content_html_4, p0_.slug AS slug_5, p0_.meta_description AS meta_description_6, p0_.meta_keywords AS meta_keywords_7, p0_.is_published AS is_published_8, p0_.published_at AS published_at_9, p0_.updated_at AS updated_at_10 FROM page p0_ WHERE p0_.language = ? AND p0_.is_published = 1 ORDER BY p0_.published_at DESC, p0_.updated_at DESC
Parameters:
[
  3
]
2 0.11 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.title AS title_3, t0.code AS code_4, t0.short_description AS short_description_5, t0.youtube_video_code AS youtube_video_code_6, t0.image AS image_7, t0.img_updated_at AS img_updated_at_8, t0.description AS description_9, t0.language AS language_10, t0.slug AS slug_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "Roasters-for-the-Black-Gold-Specialty-Coffee-Line-18"
]
3 0.12 ms
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.title AS title_2, p0_.code AS code_3, p0_.short_description AS short_description_4, p0_.youtube_video_code AS youtube_video_code_5, p0_.image AS image_6, p0_.img_updated_at AS img_updated_at_7, p0_.description AS description_8, p0_.language AS language_9, p0_.slug AS slug_10, p0_.category_id AS category_id_11 FROM product p0_ WHERE p0_.language = ? LIMIT 6
Parameters:
[
  3
]
4 0.11 ms
SELECT t0.id AS id_1, t0.ga4 AS ga4_2, t0.tags_google_ads AS tags_google_ads_3, t0.pixel_meta_ads AS pixel_meta_ads_4 FROM global_tags t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
5 0.08 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.img_updated_at AS img_updated_at_3, t0.image_title AS image_title_4, t0.image_alt AS image_alt_5, t0.product_id AS product_id_6 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  18
]
6 0.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.img_updated_at AS img_updated_at_4, t0.language AS language_5, t0.features AS features_6, t0.short_description AS short_description_7, t0.subtitle AS subtitle_8, t0.position AS position_9, t0.product_highlight_id AS product_highlight_id_10 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
  22
]
7 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.language AS language_3, t0.product_id AS product_id_4, t0.product_property_id AS product_property_id_5 FROM product_property_value t0 WHERE t0.product_id = ?
Parameters:
[
  18
]
8 0.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  110
]
9 0.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  132
]
10 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  134
]
11 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  135
]
12 0.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  133
]
13 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  136
]
14 0.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.file_name AS file_name_4, t0.file_updated_at AS file_updated_at_5, t0.product_id AS product_id_6 FROM product_manual t0 WHERE t0.product_id = ?
Parameters:
[
  18
]
15 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.img_updated_at AS img_updated_at_4, t0.language AS language_5, t0.features AS features_6, t0.short_description AS short_description_7, t0.subtitle AS subtitle_8, t0.position AS position_9, t0.product_highlight_id AS product_highlight_id_10 FROM product_category t0 WHERE t0.language = ? ORDER BY t0.title ASC
Parameters:
[
  "3"
]
16 0.08 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address AS address_4, t0.whatsapp AS whatsapp_5 FROM general_data t0 ORDER BY t0.id DESC LIMIT 1
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\ProductCategory 8
App\Entity\Product 6
App\Entity\ProductPropertyValue 6
App\Entity\ProductProperty 6
App\Entity\Page 1
App\Entity\GlobalTags 1
App\Entity\GeneralData 1

Entities Mapping