https://mie-workation-staging.site/cn/facility/31

Query Metrics

33 Database Queries
15 Different statements
14.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
5.09 ms
(36.31%)
4
SELECT t0.area_group AS area_group_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.id AS id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.name_cn AS name_cn_8, t0.name_tw AS name_tw_9, t0.enable AS enable_10, t0.sort AS sort_11 FROM mst_area t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  23
]
3.84 ms
(27.42%)
1
SELECT t0.icon AS icon_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.id AS id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.name_cn AS name_cn_8, t0.name_tw AS name_tw_9, t0.enable AS enable_10, t0.sort AS sort_11, t0.is_model_plan AS is_model_plan_12, t0.is_hotel AS is_hotel_13, t0.is_workspace AS is_workspace_14, t0.is_activity AS is_activity_15 FROM mst_equipment t0 INNER JOIN hotel_equipment ON t0.id = hotel_equipment.equipment_id WHERE hotel_equipment.hotel_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  14
]
1.18 ms
(8.43%)
1
SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26, e0_.slave_entry_id AS slave_entry_id_27, e0_.owner_id AS owner_id_28, e0_.area_id AS area_id_29 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id) AND (m2_.deleted_at IS NULL) WHERE (e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.category = ? AND m2_.area_group = ? AND e0_.id <> ?) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 3
Parameters:
[
  1
  0
  1
  2
  4
  31
]
1.12 ms
(7.99%)
1
SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26, e0_.slave_entry_id AS slave_entry_id_27, e0_.owner_id AS owner_id_28, e0_.area_id AS area_id_29 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) WHERE (e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id = ? AND e0_.category = ?) AND (e0_.deleted_at IS NULL)
Parameters:
[
  1
  0
  1
  31
  2
]
0.51 ms
(3.65%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.entry_date AS entry_date_5, t0.title AS title_6, t0.title_en AS title_en_7, t0.title_cn AS title_cn_8, t0.title_tw AS title_tw_9, t0.enable AS enable_10, t0.pub_date AS pub_date_11, t0.close_date AS close_date_12, t0.main_img AS main_img_13, t0.main_img_width AS main_img_width_14, t0.main_img_height AS main_img_height_15, t0.thumbnail AS thumbnail_16, t0.description AS description_17, t0.link_url AS link_url_18, t0.link_newtab AS link_newtab_19, t0.content AS content_20, t0.content_en AS content_en_21, t0.content_cn AS content_cn_22, t0.content_tw AS content_tw_23, t0.entry_id AS entry_id_24, t0.report_writer_id AS report_writer_id_25 FROM cms_entry_report_post t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.entry_date DESC, t0.id DESC
Parameters:
[
  31
]
0.43 ms
(3.03%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.image AS image_5, t0.title AS title_6, t0.caption AS caption_7, t0.sort AS sort_8, t0.title_en AS title_en_9, t0.title_cn AS title_cn_10, t0.caption_en AS caption_en_11, t0.caption_cn AS caption_cn_12, t0.to_simulation AS to_simulation_13, t0.title_tw AS title_tw_14, t0.caption_tw AS caption_tw_15, t0.entry_id AS entry_id_16 FROM entry_pickup_contents t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC
Parameters:
[
  31
]
0.32 ms
(2.25%)
4
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_workspace t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
0.31 ms
(2.22%)
4
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_hotel t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
0.29 ms
(2.07%)
4
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.number AS number_5, t0.parson_comment AS parson_comment_6, t0.parson_comment_en AS parson_comment_en_7, t0.parson_comment_cn AS parson_comment_cn_8, t0.parson_comment_tw AS parson_comment_tw_9, t0.inquiry_name AS inquiry_name_10, t0.inquiry_name_en AS inquiry_name_en_11, t0.inquiry_name_cn AS inquiry_name_cn_12, t0.inquiry_name_tw AS inquiry_name_tw_13, t0.inquiry_phone AS inquiry_phone_14, t0.inquiry_url AS inquiry_url_15, t0.inquiry_remark AS inquiry_remark_16, t0.inquiry_remark_en AS inquiry_remark_en_17, t0.inquiry_remark_cn AS inquiry_remark_cn_18, t0.inquiry_remark_tw AS inquiry_remark_tw_19, t0.is_recommend AS is_recommend_20, t0.entry_id AS entry_id_21, t0.parson_id AS parson_id_22 FROM entry_modelplan t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
0.24 ms
(1.70%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.image AS image_5, t0.sort AS sort_6, t0.entry_id AS entry_id_7 FROM entry_pickup_contents_image t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC
Parameters:
[
  31
]
0.23 ms
(1.65%)
4
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_actibity t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
0.22 ms
(1.59%)
4
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.entry_id AS entry_id_7 FROM entry_geolocation t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
0.10 ms
(0.69%)
1
SELECT m0_.icon AS icon_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_equipment m0_ WHERE (m0_.enable = ? AND m0_.is_hotel = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC
Parameters:
[
  1
]
0.07 ms
(0.52%)
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_hotel = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC
Parameters:
[
  1
]
0.07 ms
(0.48%)
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_hotel = 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\Account\Owner No errors.
App\Entity\Entry\SlaveEntry No errors.
App\Entity\Master\Area No errors.
App\Entity\Entry\PickupContents No errors.
App\Entity\Entry\PickupContentsImage No errors.
App\Entity\Entry\Geolocation No errors.
App\Entity\Entry\ModelPlan No errors.
App\Entity\Master\Parson No errors.
App\Entity\Entry\Hotel No errors.
App\Entity\Master\Equipment No errors.
App\Entity\Master\Service No errors.
App\Entity\Master\Target No errors.
App\Entity\Entry\Workspace No errors.
App\Entity\Entry\Actibity No errors.
App\Entity\Entry\ModelPlanScheduleDay No errors.
App\Entity\Entry\SlaveModelPlanScheduleDay No errors.
App\Entity\Entry\Report\Post No errors.
App\Entity\Entry\PickupContentsScore No errors.
App\Entity\Master\ReportWriter No errors.