Query Metrics
6
Database Queries
4
Different statements
204.95 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
176.04 ms (85.90%) |
2 |
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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p1_.template = ? AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.position ASC LIMIT 1
Parameters:
[
"home"
]
|
|
14.79 ms (7.22%) |
2 |
SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC
Parameters:
[] |
|
11.27 ms (5.50%) |
1 |
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.publishable AS publishable_17, t0.planable AS planable_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.deleted_at AS deleted_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.id AS id_24 FROM page_basis t0 WHERE t0.template = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"legalpage"
]
|
|
2.85 ms (1.39%) |
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_.banner_id AS banner_id_18, p0_.company_id AS company_id_19, p0_.plan_id AS plan_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 WHERE (p0_.active = ? AND p0_.basis_id = ? AND p0_.company_id = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.title ASC
Parameters:
[ 1 Symfony\Component\Uid\UuidV7 {#4127 : "0193c01e-1ece-7149-bf20-c353ebe0d43e" } Symfony\Component\Uid\UuidV7 {#2209 : "0193c01e-3854-728d-b9b6-81d6e805102c" } ] |
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\User\Company | No errors. |
| App\Entity\Plan\Plan |
|
| App\Entity\Page\Page | No errors. |
| App\Entity\SEO\Slug | No errors. |
| App\Entity\Plan\PlanBasis | No errors. |
| App\Entity\Abstracts\AbstractImage | No errors. |
| App\Entity\Media\Image | No errors. |
| App\Entity\Page\PageBasis | No errors. |
| App\Entity\SEO\Meta | No errors. |
| App\Entity\User\UserProfile |
|
| App\Entity\Form\Form | No errors. |
| App\Entity\User\CompanySlide | No errors. |
| App\Entity\LipiwellContent\LipiwellContent | No errors. |
| App\Entity\Plan\PlanFeature | No errors. |
| App\Entity\Plan\Suscription |
|
| App\Entity\Block\Block | No errors. |
| App\Entity\Page\PageDownload | No errors. |
| App\Entity\Page\PageImage | No errors. |
| App\Entity\Page\PageSlide | No errors. |
| App\Entity\Block\BlockBasis | No errors. |
| App\Entity\Abstracts\AbstractLink | No errors. |
| App\Entity\Media\Link | No errors. |
| App\Entity\Abstracts\AbstractVideo | No errors. |
| App\Entity\Media\Video | No errors. |
| App\Entity\Block\BlockDownload | No errors. |
| App\Entity\Abstracts\AbstractDownload | No errors. |
| App\Entity\Media\Download | No errors. |
| App\Entity\Block\BlockImage | No errors. |
| App\Entity\Block\BlockLink | No errors. |
| App\Entity\Abstracts\AbstractSlide | No errors. |
| App\Entity\Media\Slide | No errors. |
| App\Entity\Block\BlockSubsection | No errors. |
| App\Entity\Block\BlockThreeColumn | No errors. |