Query Metrics
6
Database Queries
4
Different statements
147.83 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105.88 ms (71.62%) |
1 |
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_.name AS name_40, p2_.free AS free_41, p2_.single AS single_42, p2_.monthly AS monthly_43, p2_.deleted_at AS deleted_at_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, p2_.id AS id_47, i3_.name AS name_48, i3_.original_name AS original_name_49, i3_.size AS size_50, i3_.alt AS alt_51, i3_.source AS source_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, i3_.id AS id_55, p4_.title AS title_56, p4_.content AS content_57, p4_.id AS id_58, c5_.position AS position_59, c5_.id AS id_60, p1_.basis_id AS basis_id_61, p1_.image_id AS image_id_62, p1_.page_id AS page_id_63, p4_.plan_id AS plan_id_64, c5_.company_id AS company_id_65, c5_.slide_id AS slide_id_66 FROM company c0_ LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id LEFT JOIN image i3_ ON p1_.image_id = i3_.id LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id ORDER BY c0_.id ASC, p1_.lipiwell_id ASC, c5_.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
21.65 ms (14.65%) |
1 |
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.60 ms (7.85%) |
2 |
SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.image_id AS image_id_6, t0.link_id AS link_id_7, t0.video_id AS video_id_8 FROM slide t0 WHERE t0.id = ?
Parameters:
[
"0193c01e-3854-728d-b9b6-81d6e8b9df94"
]
|
||||||||||||||||||||||||||||||||||
8.70 ms (5.89%) |
2 |
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.alt AS alt_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8 FROM image t0 WHERE t0.id = ?
Parameters:
[
"0193c01e-3855-73e3-8730-1df9b61cba15"
]
|
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\Plan\PlanFeature | No errors. |
App\Entity\Plan\PlanBasis | No errors. |
App\Entity\Abstracts\AbstractImage | No errors. |
App\Entity\Media\Image | No errors. |
App\Entity\User\CompanySlide | No errors. |
App\Entity\Page\Page | No errors. |
App\Entity\Abstracts\AbstractSlide | No errors. |
App\Entity\Media\Slide | No errors. |
App\Entity\User\UserProfile |
|
App\Entity\Form\Form | No errors. |
App\Entity\LipiwellContent\LipiwellContent | No errors. |
App\Entity\Plan\Suscription |
|
App\Entity\Block\BlockImage | No errors. |
App\Entity\Page\PageImage | No errors. |
App\Entity\SEO\Slug | No errors. |
App\Entity\Page\PageBasis | No errors. |
App\Entity\SEO\Meta | No errors. |
App\Entity\Block\Block | No errors. |
App\Entity\Page\PageDownload | No errors. |
App\Entity\Page\PageSlide | 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. |