Query Metrics
16
Database Queries
8
Different statements
797.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
751.00 ms (94.14%) |
6 |
SELECT p0_.title AS title_0, p0_.menu_title AS menu_title_1, p0_.content AS content_2, p0_.feature AS feature_3, p0_.published_at AS published_at_4, p0_.deleted_at AS deleted_at_5, p0_.position AS position_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.active AS active_9, p0_.id AS id_10, p1_.title AS title_11, p1_.template AS template_12, p1_.allow_blocks AS allow_blocks_13, p1_.allow_categories AS allow_categories_14, p1_.static_page AS static_page_15, p1_.banner_image AS banner_image_16, p1_.slider AS slider_17, p1_.content AS content_18, p1_.duplicable AS duplicable_19, p1_.deletable AS deletable_20, p1_.searchable AS searchable_21, p1_.featurable AS featurable_22, p1_.sortable AS sortable_23, p1_.exportable AS exportable_24, p1_.has_downloads AS has_downloads_25, p1_.has_images AS has_images_26, p1_.family AS family_27, p1_.product AS product_28, p1_.publishable AS publishable_29, p1_.tagged AS tagged_30, p1_.meta_title AS meta_title_31, p1_.meta_description AS meta_description_32, p1_.deleted_at AS deleted_at_33, p1_.created_at AS created_at_34, p1_.updated_at AS updated_at_35, p1_.id AS id_36, i2_.name AS name_37, i2_.original_name AS original_name_38, i2_.size AS size_39, i2_.alt AS alt_40, i2_.source AS source_41, i2_.created_at AS created_at_42, i2_.updated_at AS updated_at_43, i2_.id AS id_44, s3_.slug AS slug_45, s3_.class_name AS class_name_46, s3_.content_updated_at AS content_updated_at_47, s3_.created_at AS created_at_48, s3_.updated_at AS updated_at_49, s3_.id AS id_50, m4_.keywords AS keywords_51, m4_.meta_title AS meta_title_52, m4_.meta_description AS meta_description_53, m4_.og_title AS og_title_54, m4_.og_description AS og_description_55, m4_.twitter_title AS twitter_title_56, m4_.twitter_description AS twitter_description_57, m4_.robots_index AS robots_index_58, m4_.created_at AS created_at_59, m4_.updated_at AS updated_at_60, m4_.id AS id_61, i5_.name AS name_62, i5_.original_name AS original_name_63, i5_.size AS size_64, i5_.alt AS alt_65, i5_.source AS source_66, i5_.created_at AS created_at_67, i5_.updated_at AS updated_at_68, i5_.id AS id_69, i6_.name AS name_70, i6_.original_name AS original_name_71, i6_.size AS size_72, i6_.alt AS alt_73, i6_.source AS source_74, i6_.created_at AS created_at_75, i6_.updated_at AS updated_at_76, i6_.id AS id_77, b7_.is_wide AS is_wide_78, b7_.title AS title_79, b7_.content AS content_80, b7_.deleted_at AS deleted_at_81, b7_.position AS position_82, b7_.created_at AS created_at_83, b7_.updated_at AS updated_at_84, b7_.active AS active_85, b7_.id AS id_86, b8_.name AS name_87, b8_.template AS template_88, b8_.has_wide AS has_wide_89, b8_.has_title AS has_title_90, b8_.has_content AS has_content_91, b8_.has_image AS has_image_92, b8_.has_link AS has_link_93, b8_.has_video AS has_video_94, b8_.has_downloads AS has_downloads_95, b8_.has_images AS has_images_96, b8_.has_links AS has_links_97, b8_.created_at AS created_at_98, b8_.updated_at AS updated_at_99, b8_.active AS active_100, b8_.id AS id_101, a9_.name AS name_102, a9_.original_name AS original_name_103, a9_.size AS size_104, a9_.alt AS alt_105, a9_.source AS source_106, a9_.created_at AS created_at_107, a9_.updated_at AS updated_at_108, a9_.id AS id_109, i10_.name AS name_110, i10_.original_name AS original_name_111, i10_.size AS size_112, i10_.alt AS alt_113, i10_.source AS source_114, i10_.created_at AS created_at_115, i10_.updated_at AS updated_at_116, i10_.id AS id_117, l11_.text AS text_118, l11_.link AS link_119, l11_.created_at AS created_at_120, l11_.updated_at AS updated_at_121, l11_.id AS id_122, v12_.text AS text_123, v12_.link AS link_124, v12_.source AS source_125, v12_.created_at AS created_at_126, v12_.updated_at AS updated_at_127, v12_.id AS id_128, b13_.position AS position_129, b13_.id AS id_130, d14_.name AS name_131, d14_.original_name AS original_name_132, d14_.size AS size_133, d14_.text AS text_134, d14_.created_at AS created_at_135, d14_.updated_at AS updated_at_136, d14_.id AS id_137, b15_.position AS position_138, b15_.id AS id_139, i16_.name AS name_140, i16_.original_name AS original_name_141, i16_.size AS size_142, i16_.alt AS alt_143, i16_.source AS source_144, i16_.created_at AS created_at_145, i16_.updated_at AS updated_at_146, i16_.id AS id_147, b17_.position AS position_148, b17_.id AS id_149, l18_.text AS text_150, l18_.link AS link_151, l18_.created_at AS created_at_152, l18_.updated_at AS updated_at_153, l18_.id AS id_154, p19_.position AS position_155, p19_.id AS id_156, s20_.title AS title_157, s20_.subtitle AS subtitle_158, s20_.created_at AS created_at_159, s20_.updated_at AS updated_at_160, s20_.id AS id_161, i21_.name AS name_162, i21_.original_name AS original_name_163, i21_.size AS size_164, i21_.alt AS alt_165, i21_.source AS source_166, i21_.created_at AS created_at_167, i21_.updated_at AS updated_at_168, i21_.id AS id_169, l22_.text AS text_170, l22_.link AS link_171, l22_.created_at AS created_at_172, l22_.updated_at AS updated_at_173, l22_.id AS id_174, v23_.text AS text_175, v23_.link AS link_176, v23_.source AS source_177, v23_.created_at AS created_at_178, v23_.updated_at AS updated_at_179, v23_.id AS id_180, f24_.code AS code_181, f24_.created_at AS created_at_182, f24_.updated_at AS updated_at_183, f24_.id AS id_184, p25_.reference AS reference_185, p25_.created_at AS created_at_186, p25_.updated_at AS updated_at_187, p25_.id AS id_188, p0_.basis_id AS basis_id_189, p0_.family_id AS family_id_190, p0_.product_id AS product_id_191, p0_.banner_id AS banner_id_192, p0_.meta_id AS meta_id_193, p0_.slug_id AS slug_id_194, m4_.og_image_id AS og_image_id_195, m4_.twitter_image_id AS twitter_image_id_196, b7_.image_id AS image_id_197, b7_.link_id AS link_id_198, b7_.video_id AS video_id_199, b7_.basis_id AS basis_id_200, b7_.page_id AS page_id_201, b8_.image_id AS image_id_202, b13_.block_id AS block_id_203, b13_.download_id AS download_id_204, b15_.block_id AS block_id_205, b15_.image_id AS image_id_206, b17_.block_id AS block_id_207, b17_.link_id AS link_id_208, p19_.page_id AS page_id_209, p19_.slide_id AS slide_id_210, s20_.image_id AS image_id_211, s20_.link_id AS link_id_212, s20_.video_id AS video_id_213, f24_.page_id AS page_id_214, p25_.family_id AS family_id_215, p25_.page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_.basis_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN image i2_ ON p0_.banner_id = i2_.id LEFT JOIN slug s3_ ON p0_.slug_id = s3_.id LEFT JOIN meta m4_ ON p0_.meta_id = m4_.id LEFT JOIN image i5_ ON m4_.og_image_id = i5_.id LEFT JOIN image i6_ ON m4_.twitter_image_id = i6_.id LEFT JOIN block b7_ ON p0_.id = b7_.page_id LEFT JOIN block_basis b8_ ON b7_.basis_id = b8_.id LEFT JOIN admin_image a9_ ON b8_.image_id = a9_.id LEFT JOIN image i10_ ON b7_.image_id = i10_.id LEFT JOIN link l11_ ON b7_.link_id = l11_.id LEFT JOIN video v12_ ON b7_.video_id = v12_.id LEFT JOIN block_download b13_ ON b7_.id = b13_.block_id LEFT JOIN download d14_ ON b13_.download_id = d14_.id LEFT JOIN block_image b15_ ON b7_.id = b15_.block_id LEFT JOIN image i16_ ON b15_.image_id = i16_.id LEFT JOIN block_link b17_ ON b7_.id = b17_.block_id LEFT JOIN link l18_ ON b17_.link_id = l18_.id LEFT JOIN page_slide p19_ ON p0_.id = p19_.page_id LEFT JOIN slide s20_ ON p19_.slide_id = s20_.id LEFT JOIN image i21_ ON s20_.image_id = i21_.id LEFT JOIN link l22_ ON s20_.link_id = l22_.id LEFT JOIN video v23_ ON s20_.video_id = v23_.id LEFT JOIN family f24_ ON p0_.family_id = f24_.id LEFT JOIN product p25_ ON p0_.product_id = p25_.id WHERE (p1_.template = ? AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b13_.position ASC, b15_.position ASC, b17_.position ASC, p19_.position ASC LIMIT 1
Parameters:
[
"home"
]
|
||||||||||||||||||||||||||||||
|
23.31 ms (2.92%) |
1 |
SELECT p0_.title AS title_0, p0_.menu_title AS menu_title_1, p0_.content AS content_2, p0_.feature AS feature_3, p0_.published_at AS published_at_4, p0_.deleted_at AS deleted_at_5, p0_.position AS position_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.active AS active_9, p0_.id AS id_10, p1_.title AS title_11, p1_.template AS template_12, p1_.allow_blocks AS allow_blocks_13, p1_.allow_categories AS allow_categories_14, p1_.static_page AS static_page_15, p1_.banner_image AS banner_image_16, p1_.slider AS slider_17, p1_.content AS content_18, p1_.duplicable AS duplicable_19, p1_.deletable AS deletable_20, p1_.searchable AS searchable_21, p1_.featurable AS featurable_22, p1_.sortable AS sortable_23, p1_.exportable AS exportable_24, p1_.has_downloads AS has_downloads_25, p1_.has_images AS has_images_26, p1_.family AS family_27, p1_.product AS product_28, p1_.publishable AS publishable_29, p1_.tagged AS tagged_30, p1_.meta_title AS meta_title_31, p1_.meta_description AS meta_description_32, p1_.deleted_at AS deleted_at_33, p1_.created_at AS created_at_34, p1_.updated_at AS updated_at_35, p1_.id AS id_36, i2_.name AS name_37, i2_.original_name AS original_name_38, i2_.size AS size_39, i2_.alt AS alt_40, i2_.source AS source_41, i2_.created_at AS created_at_42, i2_.updated_at AS updated_at_43, i2_.id AS id_44, s3_.slug AS slug_45, s3_.class_name AS class_name_46, s3_.content_updated_at AS content_updated_at_47, s3_.created_at AS created_at_48, s3_.updated_at AS updated_at_49, s3_.id AS id_50, m4_.keywords AS keywords_51, m4_.meta_title AS meta_title_52, m4_.meta_description AS meta_description_53, m4_.og_title AS og_title_54, m4_.og_description AS og_description_55, m4_.twitter_title AS twitter_title_56, m4_.twitter_description AS twitter_description_57, m4_.robots_index AS robots_index_58, m4_.created_at AS created_at_59, m4_.updated_at AS updated_at_60, m4_.id AS id_61, i5_.name AS name_62, i5_.original_name AS original_name_63, i5_.size AS size_64, i5_.alt AS alt_65, i5_.source AS source_66, i5_.created_at AS created_at_67, i5_.updated_at AS updated_at_68, i5_.id AS id_69, i6_.name AS name_70, i6_.original_name AS original_name_71, i6_.size AS size_72, i6_.alt AS alt_73, i6_.source AS source_74, i6_.created_at AS created_at_75, i6_.updated_at AS updated_at_76, i6_.id AS id_77, b7_.is_wide AS is_wide_78, b7_.title AS title_79, b7_.content AS content_80, b7_.deleted_at AS deleted_at_81, b7_.position AS position_82, b7_.created_at AS created_at_83, b7_.updated_at AS updated_at_84, b7_.active AS active_85, b7_.id AS id_86, b8_.name AS name_87, b8_.template AS template_88, b8_.has_wide AS has_wide_89, b8_.has_title AS has_title_90, b8_.has_content AS has_content_91, b8_.has_image AS has_image_92, b8_.has_link AS has_link_93, b8_.has_video AS has_video_94, b8_.has_downloads AS has_downloads_95, b8_.has_images AS has_images_96, b8_.has_links AS has_links_97, b8_.created_at AS created_at_98, b8_.updated_at AS updated_at_99, b8_.active AS active_100, b8_.id AS id_101, a9_.name AS name_102, a9_.original_name AS original_name_103, a9_.size AS size_104, a9_.alt AS alt_105, a9_.source AS source_106, a9_.created_at AS created_at_107, a9_.updated_at AS updated_at_108, a9_.id AS id_109, i10_.name AS name_110, i10_.original_name AS original_name_111, i10_.size AS size_112, i10_.alt AS alt_113, i10_.source AS source_114, i10_.created_at AS created_at_115, i10_.updated_at AS updated_at_116, i10_.id AS id_117, l11_.text AS text_118, l11_.link AS link_119, l11_.created_at AS created_at_120, l11_.updated_at AS updated_at_121, l11_.id AS id_122, v12_.text AS text_123, v12_.link AS link_124, v12_.source AS source_125, v12_.created_at AS created_at_126, v12_.updated_at AS updated_at_127, v12_.id AS id_128, b13_.position AS position_129, b13_.id AS id_130, d14_.name AS name_131, d14_.original_name AS original_name_132, d14_.size AS size_133, d14_.text AS text_134, d14_.created_at AS created_at_135, d14_.updated_at AS updated_at_136, d14_.id AS id_137, b15_.position AS position_138, b15_.id AS id_139, i16_.name AS name_140, i16_.original_name AS original_name_141, i16_.size AS size_142, i16_.alt AS alt_143, i16_.source AS source_144, i16_.created_at AS created_at_145, i16_.updated_at AS updated_at_146, i16_.id AS id_147, b17_.position AS position_148, b17_.id AS id_149, l18_.text AS text_150, l18_.link AS link_151, l18_.created_at AS created_at_152, l18_.updated_at AS updated_at_153, l18_.id AS id_154, p19_.position AS position_155, p19_.id AS id_156, s20_.title AS title_157, s20_.subtitle AS subtitle_158, s20_.created_at AS created_at_159, s20_.updated_at AS updated_at_160, s20_.id AS id_161, i21_.name AS name_162, i21_.original_name AS original_name_163, i21_.size AS size_164, i21_.alt AS alt_165, i21_.source AS source_166, i21_.created_at AS created_at_167, i21_.updated_at AS updated_at_168, i21_.id AS id_169, l22_.text AS text_170, l22_.link AS link_171, l22_.created_at AS created_at_172, l22_.updated_at AS updated_at_173, l22_.id AS id_174, v23_.text AS text_175, v23_.link AS link_176, v23_.source AS source_177, v23_.created_at AS created_at_178, v23_.updated_at AS updated_at_179, v23_.id AS id_180, f24_.code AS code_181, f24_.created_at AS created_at_182, f24_.updated_at AS updated_at_183, f24_.id AS id_184, p25_.reference AS reference_185, p25_.created_at AS created_at_186, p25_.updated_at AS updated_at_187, p25_.id AS id_188, p0_.basis_id AS basis_id_189, p0_.family_id AS family_id_190, p0_.product_id AS product_id_191, p0_.banner_id AS banner_id_192, p0_.meta_id AS meta_id_193, p0_.slug_id AS slug_id_194, m4_.og_image_id AS og_image_id_195, m4_.twitter_image_id AS twitter_image_id_196, b7_.image_id AS image_id_197, b7_.link_id AS link_id_198, b7_.video_id AS video_id_199, b7_.basis_id AS basis_id_200, b7_.page_id AS page_id_201, b8_.image_id AS image_id_202, b13_.block_id AS block_id_203, b13_.download_id AS download_id_204, b15_.block_id AS block_id_205, b15_.image_id AS image_id_206, b17_.block_id AS block_id_207, b17_.link_id AS link_id_208, p19_.page_id AS page_id_209, p19_.slide_id AS slide_id_210, s20_.image_id AS image_id_211, s20_.link_id AS link_id_212, s20_.video_id AS video_id_213, f24_.page_id AS page_id_214, p25_.family_id AS family_id_215, p25_.page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_.basis_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN image i2_ ON p0_.banner_id = i2_.id LEFT JOIN slug s3_ ON p0_.slug_id = s3_.id LEFT JOIN meta m4_ ON p0_.meta_id = m4_.id LEFT JOIN image i5_ ON m4_.og_image_id = i5_.id LEFT JOIN image i6_ ON m4_.twitter_image_id = i6_.id LEFT JOIN block b7_ ON p0_.id = b7_.page_id LEFT JOIN block_basis b8_ ON b7_.basis_id = b8_.id LEFT JOIN admin_image a9_ ON b8_.image_id = a9_.id LEFT JOIN image i10_ ON b7_.image_id = i10_.id LEFT JOIN link l11_ ON b7_.link_id = l11_.id LEFT JOIN video v12_ ON b7_.video_id = v12_.id LEFT JOIN block_download b13_ ON b7_.id = b13_.block_id LEFT JOIN download d14_ ON b13_.download_id = d14_.id LEFT JOIN block_image b15_ ON b7_.id = b15_.block_id LEFT JOIN image i16_ ON b15_.image_id = i16_.id LEFT JOIN block_link b17_ ON b7_.id = b17_.block_id LEFT JOIN link l18_ ON b17_.link_id = l18_.id LEFT JOIN page_slide p19_ ON p0_.id = p19_.page_id LEFT JOIN slide s20_ ON p19_.slide_id = s20_.id LEFT JOIN image i21_ ON s20_.image_id = i21_.id LEFT JOIN link l22_ ON s20_.link_id = l22_.id LEFT JOIN video v23_ ON s20_.video_id = v23_.id LEFT JOIN family f24_ ON p0_.family_id = f24_.id LEFT JOIN product p25_ ON p0_.product_id = p25_.id WHERE (p0_.slug_id = ?) AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b13_.position ASC, b15_.position ASC, b17_.position ASC, p19_.position ASC
Parameters:
[ Symfony\Component\Uid\UuidV7 {#800 : "018ee149-8f00-7d1d-82b2-32a5d423cff4" } ]
|
||||||||||||||||||||||||||||||
|
13.90 ms (1.74%) |
1 |
SELECT p0_.title AS title_0, p0_.menu_title AS menu_title_1, p0_.content AS content_2, p0_.feature AS feature_3, p0_.published_at AS published_at_4, p0_.deleted_at AS deleted_at_5, p0_.position AS position_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.active AS active_9, p0_.id AS id_10, s1_.slug AS slug_11, s1_.class_name AS class_name_12, s1_.content_updated_at AS content_updated_at_13, s1_.created_at AS created_at_14, s1_.updated_at AS updated_at_15, s1_.id AS id_16, p0_.basis_id AS basis_id_17, p0_.family_id AS family_id_18, p0_.product_id AS product_id_19, p0_.banner_id AS banner_id_20, p0_.meta_id AS meta_id_21, p0_.slug_id AS slug_id_22 FROM PAGE p0_ LEFT JOIN slug s1_ ON p0_.slug_id = s1_.id LEFT JOIN page_basis p2_ ON p0_.basis_id = p2_.id AND (p2_.deleted_at IS NULL) WHERE (p0_.active = ? AND p2_.searchable = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.title ASC
Parameters:
[ 1 1 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (0.34%) |
3 |
SELECT t0.slug AS slug_1, t0.class_name AS class_name_2, t0.content_updated_at AS content_updated_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM slug t0 WHERE t0.id = ?
Parameters:
[
"018ee149-9ff0-70df-9a1d-d5417acc1624"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.26%) |
2 |
SELECT t0.title AS title_1, t0.template AS template_2, t0.allow_blocks AS allow_blocks_3, t0.allow_categories AS allow_categories_4, t0.static_page AS static_page_5, t0.banner_image AS banner_image_6, t0.slider AS slider_7, t0.content AS content_8, t0.duplicable AS duplicable_9, t0.deletable AS deletable_10, t0.searchable AS searchable_11, t0.featurable AS featurable_12, t0.sortable AS sortable_13, t0.exportable AS exportable_14, t0.has_downloads AS has_downloads_15, t0.has_images AS has_images_16, t0.family AS family_17, t0.product AS product_18, t0.publishable AS publishable_19, t0.tagged AS tagged_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.deleted_at AS deleted_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.id AS id_26 FROM page_basis t0 WHERE t0.template = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"home"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.26%) |
1 |
SELECT s0_.slug AS slug_0, s0_.class_name AS class_name_1, s0_.content_updated_at AS content_updated_at_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.id AS id_5 FROM slug s0_ WHERE s0_.slug = ? LIMIT 1
Parameters:
[ "" ] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.17%) |
1 |
SELECT t0.text AS text_1, t0.link AS link_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.deleted_at AS deleted_at_6, t0.position AS position_7, t0.active AS active_8 FROM seolink t0 WHERE t0.active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.16%) |
1 |
SELECT t0.title AS title_1, t0.menu_title AS menu_title_2, t0.content AS content_3, t0.feature AS feature_4, t0.published_at AS published_at_5, t0.deleted_at AS deleted_at_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.id AS id_11, t0.basis_id AS basis_id_12, t0.family_id AS family_id_13, t0.product_id AS product_id_14, t0.banner_id AS banner_id_15, t0.meta_id AS meta_id_16, t0.slug_id AS slug_id_17 FROM PAGE t0 WHERE t0.active = ? AND t0.basis_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.title ASC
Parameters:
[ 1 "018ee149-8e70-7161-ad87-f467f08549f2" ] |
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.