Query Metrics
2
Database Queries
2
Different statements
281.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 281.06 ms |
SELECT e0_.id AS id_0, e0_.uuid AS uuid_1, e0_.last_sent_to_your_monaco AS last_sent_to_your_monaco_2, e0_.last_sent_to_your_monaco_prod AS last_sent_to_your_monaco_prod_3, e0_.created_by AS created_by_4, e0_.updated_by AS updated_by_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.choices AS choices_9, e0_.data AS data_10, e1_.id AS id_11, e1_.status AS status_12, e1_.changed_at AS changed_at_13, e1_.imported_at AS imported_at_14, e1_.external_id AS external_id_15, e1_.date_from AS date_from_16, e1_.date_to AS date_to_17, e1_.time_from AS time_from_18, e1_.time_to AS time_to_19, e1_.phone AS phone_20, e1_.email AS email_21, e1_.url AS url_22, e1_.owner AS owner_23, e1_.photo_url AS photo_url_24, e1_.photos_url AS photos_url_25, e1_.category AS category_26, e1_.theme AS theme_27, e1_.is_accessible AS is_accessible_28, e1_.is_event_free AS is_event_free_29, e1_.is_private AS is_private_30, e1_.is_on_public_area AS is_on_public_area_31, e1_.sessions AS sessions_32, e1_.prices AS prices_33, e1_.price_from AS price_from_34, e1_.price_to AS price_to_35, e1_.payment_accepted AS payment_accepted_36, e1_.door_time_open AS door_time_open_37, e1_.door_time_close AS door_time_close_38, e1_.language AS language_39, e1_.contact_languages AS contact_languages_40, e1_.event_type AS event_type_41, e1_.duration AS duration_42, e1_.map_url AS map_url_43, e1_.booking_url AS booking_url_44, e1_.super_event AS super_event_45, e1_.created_by AS created_by_46, e1_.updated_by AS updated_by_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e1_.deleted_at AS deleted_at_50, e1_.data AS data_51, e2_.id AS id_52, e2_.locale AS locale_53, e2_.title AS title_54, e2_.intro AS intro_55, e2_.content AS content_56, e2_.date AS date_57, i3_.id AS id_58, i3_.code AS code_59, i3_.name AS name_60, i3_.color AS color_61, i3_.last_import AS last_import_62, i3_.data AS data_63, p4_.id AS id_64, p4_.external_id AS external_id_65, p4_.lat AS lat_66, p4_.lng AS lng_67, p4_.address AS address_68, p4_.zip AS zip_69, p4_.city AS city_70, p4_.country_code AS country_code_71, p4_.is_accessible AS is_accessible_72, p4_.map_url AS map_url_73, p4_.photo_url AS photo_url_74, p4_.photos_url AS photos_url_75, p4_.owner AS owner_76, p4_.deleted_at AS deleted_at_77, p5_.id AS id_78, p5_.locale AS locale_79, p5_.title AS title_80, p5_.intro AS intro_81, p5_.content AS content_82, p5_.date AS date_83, p6_.id AS id_84, p6_.uuid AS uuid_85, p6_.created_by AS created_by_86, p6_.updated_by AS updated_by_87, p6_.created_at AS created_at_88, p6_.updated_at AS updated_at_89, p6_.deleted_at AS deleted_at_90, p6_.choices AS choices_91, i7_.id AS id_92, i7_.code AS code_93, i7_.name AS name_94, i7_.color AS color_95, i7_.last_import AS last_import_96, i7_.data AS data_97, e1_.importer_id AS importer_id_98, e1_.event_id AS event_id_99, e1_.place_source_id AS place_source_id_100, e1_.parent_id AS parent_id_101, e2_.source_id AS source_id_102, p4_.importer_id AS importer_id_103, p4_.place_id AS place_id_104, p5_.source_id AS source_id_105 FROM event e0_ LEFT JOIN event_source e1_ ON e0_.id = e1_.event_id AND (e1_.deleted_at IS NULL) LEFT JOIN event_source_text e2_ ON e1_.id = e2_.source_id LEFT JOIN importer i3_ ON e1_.importer_id = i3_.id LEFT JOIN place_source p4_ ON e1_.place_source_id = p4_.id AND (p4_.deleted_at IS NULL) LEFT JOIN place_source_text p5_ ON p4_.id = p5_.source_id LEFT JOIN place p6_ ON p4_.place_id = p6_.id AND (p6_.deleted_at IS NULL) LEFT JOIN importer i7_ ON p4_.importer_id = i7_.id WHERE (e0_.deleted_at IS NULL) ORDER BY e1_.id ASC
Parameters:
[] |
| 2 | 0.31 ms |
SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.name AS name_2, i0_.color AS color_3, i0_.last_import AS last_import_4, i0_.data AS data_5 FROM importer i0_ ORDER BY i0_.name ASC
Parameters:
[] |
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\Event | No errors. |
| App\Entity\Event\Source | No errors. |
| App\Entity\Event\Source\Text | No errors. |
| App\Entity\Importer | No errors. |
| App\Entity\Place\Source | No errors. |
| App\Entity\Place\Source\Text | No errors. |
| App\Entity\Place | No errors. |