Query Metrics
1
Database Queries
1
Different statements
3.74 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3.74 ms (100.00%) |
1 |
SELECT v0_.id AS id_0, v0_.uuid AS uuid_1, v0_.name AS name_2, v0_.description AS description_3, v0_.image AS image_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.deleted_at AS deleted_at_7, v0_.is_active AS is_active_8, v1_.id AS id_9, v1_.name AS name_10, v1_.created_at AS created_at_11, v1_.updated_at AS updated_at_12, v1_.deleted_at AS deleted_at_13, v1_.is_active AS is_active_14, c2_.id AS id_15, c2_.name AS name_16, c2_.created_at AS created_at_17, c2_.updated_at AS updated_at_18, c2_.deleted_at AS deleted_at_19, c2_.is_active AS is_active_20, c3_.id AS id_21, c3_.name AS name_22, c3_.created_at AS created_at_23, c3_.updated_at AS updated_at_24, c3_.deleted_at AS deleted_at_25, c3_.is_active AS is_active_26, c4_.id AS id_27, c4_.name AS name_28, c4_.created_at AS created_at_29, c4_.updated_at AS updated_at_30, c4_.deleted_at AS deleted_at_31, c4_.is_active AS is_active_32, s5_.id AS id_33, s5_.name AS name_34, s5_.created_at AS created_at_35, s5_.updated_at AS updated_at_36, s5_.deleted_at AS deleted_at_37, s5_.is_active AS is_active_38, c6_.id AS id_39, c6_.name AS name_40, c6_.created_at AS created_at_41, c6_.updated_at AS updated_at_42, c6_.deleted_at AS deleted_at_43, c6_.is_active AS is_active_44, f7_.id AS id_45, f7_.name AS name_46, f7_.created_at AS created_at_47, f7_.updated_at AS updated_at_48, f7_.deleted_at AS deleted_at_49, f7_.is_active AS is_active_50, p8_.id AS id_51, p8_.name AS name_52, p8_.created_at AS created_at_53, p8_.updated_at AS updated_at_54, p8_.deleted_at AS deleted_at_55, p8_.is_active AS is_active_56, t9_.id AS id_57, t9_.name AS name_58, t9_.created_at AS created_at_59, t9_.updated_at AS updated_at_60, t9_.deleted_at AS deleted_at_61, t9_.is_active AS is_active_62, c10_.id AS id_63, c10_.name AS name_64, c10_.created_at AS created_at_65, c10_.updated_at AS updated_at_66, c10_.deleted_at AS deleted_at_67, c10_.is_active AS is_active_68, m11_.id AS id_69, m11_.name AS name_70, m11_.created_at AS created_at_71, m11_.updated_at AS updated_at_72, m11_.deleted_at AS deleted_at_73, m11_.is_active AS is_active_74, s12_.id AS id_75, s12_.name AS name_76, s12_.created_at AS created_at_77, s12_.updated_at AS updated_at_78, s12_.deleted_at AS deleted_at_79, s12_.is_active AS is_active_80, g13_.id AS id_81, g13_.name AS name_82, g13_.created_at AS created_at_83, g13_.updated_at AS updated_at_84, g13_.deleted_at AS deleted_at_85, g13_.is_active AS is_active_86, t14_.id AS id_87, t14_.name AS name_88, t14_.created_at AS created_at_89, t14_.updated_at AS updated_at_90, t14_.deleted_at AS deleted_at_91, t14_.is_active AS is_active_92 FROM visual v0_ LEFT JOIN visual_type v1_ ON v0_.visual_type_id = v1_.id LEFT JOIN category c2_ ON v0_.category_id = c2_.id LEFT JOIN category c3_ ON c2_.parent_id = c3_.id LEFT JOIN complexity c4_ ON v0_.complexity_id = c4_.id LEFT JOIN subject_orientation s5_ ON v0_.subject_orientation_id = s5_.id LEFT JOIN color_density c6_ ON v0_.color_density_id = c6_.id LEFT JOIN format f7_ ON v0_.format_id = f7_.id LEFT JOIN visual_placement v15_ ON v0_.id = v15_.visual_id LEFT JOIN placement p8_ ON p8_.id = v15_.placement_id LEFT JOIN visual_tag v16_ ON v0_.id = v16_.visual_id LEFT JOIN tag t9_ ON t9_.id = v16_.tag_id LEFT JOIN visual_color v17_ ON v0_.id = v17_.visual_id LEFT JOIN color c10_ ON c10_.id = v17_.color_id LEFT JOIN visual_mood v18_ ON v0_.id = v18_.visual_id LEFT JOIN mood m11_ ON m11_.id = v18_.mood_id LEFT JOIN visual_style v19_ ON v0_.id = v19_.visual_id LEFT JOIN style s12_ ON s12_.id = v19_.style_id LEFT JOIN visual_graphic_style v20_ ON v0_.id = v20_.visual_id LEFT JOIN graphic_style g13_ ON g13_.id = v20_.graphic_style_id LEFT JOIN visual_theme v21_ ON v0_.id = v21_.visual_id LEFT JOIN theme t14_ ON t14_.id = v21_.theme_id WHERE v0_.is_active = 1 AND v0_.uuid = ?
Parameters:
[
b"\ì╔M*bB¿ø8ø╝█ØWù"
]
|
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\VisualLibrary\Visual | No errors. |
App\Entity\VisualLibrary\VisualType | No errors. |
App\Entity\VisualLibrary\Category | No errors. |
App\Entity\VisualLibrary\Complexity | No errors. |
App\Entity\VisualLibrary\SubjectOrientation | No errors. |
App\Entity\VisualLibrary\ColorDensity | No errors. |
App\Entity\VisualLibrary\Format | No errors. |
App\Entity\VisualLibrary\Placement | No errors. |
App\Entity\VisualLibrary\Tag | No errors. |
App\Entity\VisualLibrary\Color | No errors. |
App\Entity\VisualLibrary\Mood | No errors. |
App\Entity\VisualLibrary\Style | No errors. |
App\Entity\VisualLibrary\GraphicStyle | No errors. |
App\Entity\VisualLibrary\Theme | No errors. |