Query Metrics

116 Database Queries
20 Different statements
189.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
29.76 ms
(15.68%)
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
]
25.97 ms
(13.69%)
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
]
15.24 ms
(8.03%)
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
]
15.15 ms
(7.98%)
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
]
14.33 ms
(7.55%)
10
SELECT t0.id AS id_1, t0.description AS description_2, t0.job_function AS job_function_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM member_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
13.21 ms
(6.96%)
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.19 ms
(6.42%)
7
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:
[]
10.97 ms
(5.78%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
8.94 ms
(4.71%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM presentation_value_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
8.22 ms
(4.33%)
2
SELECT t0.id AS id_1, t0.partner_file_name AS partner_file_name_2, t0.partner_file_size AS partner_file_size_3, t0.partner_file_updated_at AS partner_file_updated_at_4, t0.position AS position_5, t0.link AS link_6, t0.is_chinese AS is_chinese_7, t0.type AS type_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.updator_id AS updator_id_11, t0.creator_id AS creator_id_12 FROM partner t0 WHERE t0.type = ? ORDER BY t0.position ASC
Parameters:
[
  "Distributor"
]
5.76 ms
(3.04%)
2
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM presentation_paragraph_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
4.94 ms
(2.60%)
1
SELECT t0.id AS id_1, t0.iso_icon_name AS iso_icon_name_2, t0.iso_icon_size AS iso_icon_size_3, t0.iso_icon_updated_at AS iso_icon_updated_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.updator_id AS updator_id_7, t0.creator_id AS creator_id_8 FROM presentation t0
Parameters:
[]
4.82 ms
(2.54%)
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.54 ms
(2.39%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content_left AS content_left_3, t0.content_right AS content_right_4, t0.title_iso AS title_iso_5, t0.content_iso AS content_iso_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM presentation_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
3.65 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.map_file_name AS map_file_name_2, t0.map_file_size AS map_file_size_3, t0.map_file_updated_at AS map_file_updated_at_4 FROM setting t0 LIMIT 1
Parameters:
[]
3.13 ms
(1.65%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone_number AS phone_number_5, t0.position AS position_6, t0.member_file_name AS member_file_name_7, t0.member_file_size AS member_file_size_8, t0.member_file_updated_at AS member_file_updated_at_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.updator_id AS updator_id_12, t0.creator_id AS creator_id_13 FROM member t0 ORDER BY t0.position ASC
Parameters:
[]
2.47 ms
(1.30%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.presentation_value_file_name AS presentation_value_file_name_3, t0.presentation_value_file_size AS presentation_value_file_size_4, t0.presentation_value_file_updated_at AS presentation_value_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 presentation_value t0 ORDER BY t0.position ASC
Parameters:
[]
2.17 ms
(1.14%)
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::presentation"
]
2.16 ms
(1.14%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.presentation_paragraph_file_name AS presentation_paragraph_file_name_3, t0.presentation_paragraph_file_size AS presentation_paragraph_file_size_4, t0.presentation_paragraph_file_updated_at AS presentation_paragraph_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 presentation_paragraph t0 ORDER BY t0.position ASC
Parameters:
[]
2.11 ms
(1.11%)
1
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.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]

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\Presentation No errors.
App\Entity\User No errors.
App\Entity\PresentationTranslation No errors.
App\Entity\PresentationParagraph No errors.
App\Entity\PresentationParagraphTranslation No errors.
App\Entity\Member No errors.
App\Entity\MemberTranslation No errors.
App\Entity\Partner No errors.
App\Entity\PartnerTranslation No errors.
App\Entity\Setting 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\PresentationValue No errors.
App\Entity\PresentationValueTranslation No errors.
App\Entity\Page No errors.
App\Entity\PageTranslation 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\Newsletter No errors.