https://mie-workation-staging.site/cn/activity/filter?category=16

Query Metrics

3 Database Queries
3 Different statements
1.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.59 ms
(51.16%)
1
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_service m0_ WHERE (m0_.enable = ? AND m0_.is_activity = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC
Parameters:
[
  1
]
0.35 ms
(29.98%)
1
SELECT m0_.category AS category_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.id AS id_4, m0_.name AS name_5, m0_.name_en AS name_en_6, m0_.name_cn AS name_cn_7, m0_.name_tw AS name_tw_8, m0_.enable AS enable_9, m0_.sort AS sort_10, m0_.is_model_plan AS is_model_plan_11, m0_.is_hotel AS is_hotel_12, m0_.is_workspace AS is_workspace_13, m0_.is_activity AS is_activity_14 FROM mst_tag m0_ WHERE (m0_.enable = ? AND m0_.is_activity = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.category ASC, m0_.sort ASC
Parameters:
[
  1
]
0.22 ms
(18.85%)
1
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_target m0_ WHERE (m0_.enable = ? AND m0_.is_activity = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC
Parameters:
[
  1
]

aws connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
aws doctrine.dbal.aws_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\Account\ApiToken No errors.
App\Entity\Entry\Entry No errors.
App\Entity\Master\Service No errors.
App\Entity\Master\Tag No errors.
App\Entity\Master\Target No errors.