Query Metrics

98 Database Queries
16 Different statements
150.41 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.28 ms
(18.80%)
22
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.title AS title_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_addon_title AS hardware_addon_title_8, t0.software_addon_title AS software_addon_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
22.76 ms
(15.13%)
22
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_file_name AS product_file_name_3, t0.product_file_size AS product_file_size_4, t0.product_file_updated_at AS product_file_updated_at_5, t0.is_hardware AS is_hardware_6, t0.product1_file_name AS product1_file_name_7, t0.product1_file_size AS product1_file_size_8, t0.product1_file_updated_at AS product1_file_updated_at_9, t0.display_demo_btn AS display_demo_btn_10, t0.hide AS hide_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.updator_id AS updator_id_16, t0.creator_id AS creator_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
14.23 ms
(9.46%)
9
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.sub_category_file_name AS sub_category_file_name_2, s0_.sub_category_file_size AS sub_category_file_size_3, s0_.sub_category_file_updated_at AS sub_category_file_updated_at_4, s0_.sub_category1_file_name AS sub_category1_file_name_5, s0_.sub_category1_file_size AS sub_category1_file_size_6, s0_.sub_category1_file_updated_at AS sub_category1_file_updated_at_7, s0_.hide AS hide_8, s0_.updated_at AS updated_at_9, s0_.created_at AS created_at_10, s0_.category_id AS category_id_11, s0_.updator_id AS updator_id_12, s0_.creator_id AS creator_id_13 FROM sub_category s0_ LEFT JOIN sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s0_.category_id = ? AND s0_.hide = ? GROUP BY s0_.id ORDER BY s0_.position ASC
Parameters:
[
  1
  0
]
13.54 ms
(9.00%)
11
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.sub_category_id AS sub_category_id_4 FROM product_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
12.48 ms
(8.30%)
11
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.intro_title AS intro_title_7, t0.hardware_products_title AS hardware_products_title_8, t0.software_products_title AS software_products_title_9, t0.intro AS intro_10, t0.h1 AS h1_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
8.15 ms
(5.42%)
6
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.category1_file_name AS category1_file_name_6, t0.category1_file_size AS category1_file_size_7, t0.category1_file_updated_at AS category1_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.category_icon1_file_name AS category_icon1_file_name_12, t0.category_icon1_file_size AS category_icon1_file_size_13, t0.category_icon1_file_updated_at AS category_icon1_file_updated_at_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16, t0.updator_id AS updator_id_17, t0.creator_id AS creator_id_18 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
7.65 ms
(5.09%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM post_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
7.07 ms
(4.70%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.intro_raw AS intro_raw_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.h1 AS h1_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
6.28 ms
(4.17%)
2
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.updator_id AS updator_id_4, t0.creator_id AS creator_id_5 FROM post_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
5.77 ms
(3.83%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.intro_raw AS intro_raw_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.h1 AS h1_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM post_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "developing-a-new-complementary-therapy-for-parkinsons-disease"
]
5.18 ms
(3.44%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.post_file_name AS post_file_name_3, t0.post_file_size AS post_file_size_4, t0.post_file_updated_at AS post_file_updated_at_5, t0.is_published AS is_published_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.post_category_id AS post_category_id_9, t0.updator_id AS updator_id_10, t0.creator_id AS creator_id_11 FROM post t0 WHERE t0.id = ?
Parameters:
[
  17
]
5.13 ms
(3.41%)
1
SELECT t0.id AS id_1, t0.paragraph_file_name AS paragraph_file_name_2, t0.paragraph_file_size AS paragraph_file_size_3, t0.paragraph_file_updated_at AS paragraph_file_updated_at_4, t0.position AS position_5, t0.color AS color_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.post_id AS post_id_9, t0.updator_id AS updator_id_10, t0.creator_id AS creator_id_11 FROM paragraph t0 WHERE t0.post_id = ? ORDER BY t0.position ASC
Parameters:
[
  17
]
4.53 ms
(3.01%)
3
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_title_publication AS meta_title_publication_4, t0.meta_description_publication AS meta_description_publication_5, t0.title AS title_6, t0.slug AS slug_7, t0.description AS description_8, t0.h1 AS h1_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
4.42 ms
(2.94%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.youtube AS youtube_3, t0.post_media_file_name AS post_media_file_name_4, t0.post_media_file_size AS post_media_file_size_5, t0.post_media_file_updated_at AS post_media_file_updated_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.post_id AS post_id_9, t0.updator_id AS updator_id_10, t0.creator_id AS creator_id_11 FROM post_media t0 WHERE t0.post_id = ? ORDER BY t0.position ASC
Parameters:
[
  17
]
3.09 ms
(2.05%)
1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.post_file_name AS post_file_name_2, p0_.post_file_size AS post_file_size_3, p0_.post_file_updated_at AS post_file_updated_at_4, p0_.is_published AS is_published_5, p0_.updated_at AS updated_at_6, p0_.created_at AS created_at_7, p0_.post_category_id AS post_category_id_8, p0_.updator_id AS updator_id_9, p0_.creator_id AS creator_id_10 FROM post p0_ LEFT JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.id IS NOT NULL AND p0_.is_published = ? AND p0_.date <= ? GROUP BY p0_.id ORDER BY p0_.date DESC LIMIT 3
Parameters:
[
  1
  "2024-12-21 17:42:25"
]
1.85 ms
(1.23%)
1
SELECT t0.id AS id_1, t0.controller AS controller_2, t0.sitemap_file_name AS sitemap_file_name_3, t0.sitemap_file_size AS sitemap_file_size_4, t0.sitemap_file_updated_at AS sitemap_file_updated_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.updator_id AS updator_id_8, t0.creator_id AS creator_id_9 FROM page t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\FrontController::post"
]

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\PostTranslation No errors.
App\Entity\Post No errors.
App\Entity\PostCategory No errors.
App\Entity\User No errors.
App\Entity\Paragraph No errors.
App\Entity\PostMedia No errors.
App\Entity\Page No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\SubCategory No errors.
App\Entity\Publication No errors.
App\Entity\CategoryPhaseEvolution No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\SubCategoryTranslation No errors.
App\Entity\ProductSubCategory No errors.
App\Entity\ProductParagraph No errors.
App\Entity\ProductPublication No errors.
App\Entity\PhaseEvolution No errors.
App\Entity\ProductKeyFeature No errors.
App\Entity\ProductHardwareProductAddon No errors.
App\Entity\ProductSoftwareProductAddon No errors.
App\Entity\ProductProductBrochure No errors.
App\Entity\ProductProductMedia No errors.
App\Entity\ProductProduct No errors.
App\Entity\ProductTranslation No errors.
App\Entity\PostCategoryTranslation No errors.
App\Entity\Newsletter No errors.