https://mie-workation-staging.site/tw/report/2

Query Metrics

5 Database Queries
5 Different statements
9.59 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.68 ms
SELECT c0_.created_at AS created_at_0, c0_.updated_at AS updated_at_1, c0_.deleted_at AS deleted_at_2, c0_.id AS id_3, c0_.entry_date AS entry_date_4, c0_.title AS title_5, c0_.title_en AS title_en_6, c0_.title_cn AS title_cn_7, c0_.title_tw AS title_tw_8, c0_.enable AS enable_9, c0_.pub_date AS pub_date_10, c0_.close_date AS close_date_11, c0_.main_img AS main_img_12, c0_.main_img_width AS main_img_width_13, c0_.main_img_height AS main_img_height_14, c0_.thumbnail AS thumbnail_15, c0_.description AS description_16, c0_.link_url AS link_url_17, c0_.link_newtab AS link_newtab_18, c0_.content AS content_19, c0_.content_en AS content_en_20, c0_.content_cn AS content_cn_21, c0_.content_tw AS content_tw_22, c0_.entry_id AS entry_id_23, c0_.report_writer_id AS report_writer_id_24 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_.entry_id = e1_.id) AND (e1_.deleted_at IS NULL) LEFT JOIN account_owner a2_ ON (e1_.owner_id = a2_.id) AND (a2_.deleted_at IS NULL) WHERE (c0_.enable = ? AND (c0_.pub_date IS NULL OR c0_.pub_date <= ?) AND (c0_.close_date IS NULL OR c0_.close_date >= ?) AND c0_.id = ? AND e1_.approval = ? AND e1_.is_draft = ? AND a2_.status = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.entry_date DESC, c0_.id DESC
Parameters:
[
  1
  "2025-04-01 14:37:50"
  "2025-04-01 14:37:50"
  2
  1
  0
  1
]
2 0.28 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.title AS title_3, t0.main_image AS main_image_4, t0.thumbnail AS thumbnail_5, t0.summary_title AS summary_title_6, t0.summary_content AS summary_content_7, t0.pickup_content_description AS pickup_content_description_8, t0.title_en AS title_en_9, t0.title_cn AS title_cn_10, t0.summary_title_en AS summary_title_en_11, t0.summary_title_cn AS summary_title_cn_12, t0.summary_content_en AS summary_content_en_13, t0.summary_content_cn AS summary_content_cn_14, t0.pickup_contents_description_en AS pickup_contents_description_en_15, t0.pickup_contents_description_cn AS pickup_contents_description_cn_16, t0.title_tw AS title_tw_17, t0.summary_title_tw AS summary_title_tw_18, t0.summary_content_tw AS summary_content_tw_19, t0.pickup_contents_description_tw AS pickup_contents_description_tw_20, t0.add_life_experience AS add_life_experience_21, t0.life_experience_thumbnail AS life_experience_thumbnail_22, t0.is_draft AS is_draft_23, t0.approval AS approval_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.deleted_at AS deleted_at_27, t28.created_at AS created_at_29, t28.updated_at AS updated_at_30, t28.deleted_at AS deleted_at_31, t28.id AS id_32, t28.lat AS lat_33, t28.lng AS lng_34, t28.entry_id AS entry_id_35, t36.created_at AS created_at_37, t36.updated_at AS updated_at_38, t36.deleted_at AS deleted_at_39, t36.id AS id_40, t36.number AS number_41, t36.parson_comment AS parson_comment_42, t36.parson_comment_en AS parson_comment_en_43, t36.parson_comment_cn AS parson_comment_cn_44, t36.parson_comment_tw AS parson_comment_tw_45, t36.inquiry_name AS inquiry_name_46, t36.inquiry_name_en AS inquiry_name_en_47, t36.inquiry_name_cn AS inquiry_name_cn_48, t36.inquiry_name_tw AS inquiry_name_tw_49, t36.inquiry_phone AS inquiry_phone_50, t36.inquiry_url AS inquiry_url_51, t36.inquiry_remark AS inquiry_remark_52, t36.inquiry_remark_en AS inquiry_remark_en_53, t36.inquiry_remark_cn AS inquiry_remark_cn_54, t36.inquiry_remark_tw AS inquiry_remark_tw_55, t36.is_recommend AS is_recommend_56, t36.entry_id AS entry_id_57, t36.parson_id AS parson_id_58, t59.created_at AS created_at_60, t59.updated_at AS updated_at_61, t59.deleted_at AS deleted_at_62, t59.id AS id_63, t59.description AS description_64, t59.postal AS postal_65, t59.address AS address_66, t59.phone AS phone_67, t59.business_time AS business_time_68, t59.parking AS parking_69, t59.website AS website_70, t59.transportation AS transportation_71, t59.description_en AS description_en_72, t59.description_cn AS description_cn_73, t59.description_tw AS description_tw_74, t59.address_en AS address_en_75, t59.address_cn AS address_cn_76, t59.address_tw AS address_tw_77, t59.business_time_en AS business_time_en_78, t59.business_time_cn AS business_time_cn_79, t59.business_time_tw AS business_time_tw_80, t59.parking_en AS parking_en_81, t59.parking_cn AS parking_cn_82, t59.parking_tw AS parking_tw_83, t59.transportation_en AS transportation_en_84, t59.transportation_cn AS transportation_cn_85, t59.transportation_tw AS transportation_tw_86, t59.life_summary AS life_summary_87, t59.life_summary_en AS life_summary_en_88, t59.life_summary_cn AS life_summary_cn_89, t59.life_summary_tw AS life_summary_tw_90, t59.parson_comment AS parson_comment_91, t59.parson_comment_en AS parson_comment_en_92, t59.parson_comment_cn AS parson_comment_cn_93, t59.parson_comment_tw AS parson_comment_tw_94, t59.entry_id AS entry_id_95, t59.parson_id AS parson_id_96, t97.created_at AS created_at_98, t97.updated_at AS updated_at_99, t97.deleted_at AS deleted_at_100, t97.id AS id_101, t97.description AS description_102, t97.postal AS postal_103, t97.address AS address_104, t97.phone AS phone_105, t97.business_time AS business_time_106, t97.parking AS parking_107, t97.website AS website_108, t97.transportation AS transportation_109, t97.description_en AS description_en_110, t97.description_cn AS description_cn_111, t97.description_tw AS description_tw_112, t97.address_en AS address_en_113, t97.address_cn AS address_cn_114, t97.address_tw AS address_tw_115, t97.business_time_en AS business_time_en_116, t97.business_time_cn AS business_time_cn_117, t97.business_time_tw AS business_time_tw_118, t97.parking_en AS parking_en_119, t97.parking_cn AS parking_cn_120, t97.parking_tw AS parking_tw_121, t97.transportation_en AS transportation_en_122, t97.transportation_cn AS transportation_cn_123, t97.transportation_tw AS transportation_tw_124, t97.life_summary AS life_summary_125, t97.life_summary_en AS life_summary_en_126, t97.life_summary_cn AS life_summary_cn_127, t97.life_summary_tw AS life_summary_tw_128, t97.parson_comment AS parson_comment_129, t97.parson_comment_en AS parson_comment_en_130, t97.parson_comment_cn AS parson_comment_cn_131, t97.parson_comment_tw AS parson_comment_tw_132, t97.entry_id AS entry_id_133, t97.parson_id AS parson_id_134, t135.created_at AS created_at_136, t135.updated_at AS updated_at_137, t135.deleted_at AS deleted_at_138, t135.id AS id_139, t135.description AS description_140, t135.postal AS postal_141, t135.address AS address_142, t135.phone AS phone_143, t135.business_time AS business_time_144, t135.parking AS parking_145, t135.website AS website_146, t135.transportation AS transportation_147, t135.description_en AS description_en_148, t135.description_cn AS description_cn_149, t135.description_tw AS description_tw_150, t135.address_en AS address_en_151, t135.address_cn AS address_cn_152, t135.address_tw AS address_tw_153, t135.business_time_en AS business_time_en_154, t135.business_time_cn AS business_time_cn_155, t135.business_time_tw AS business_time_tw_156, t135.parking_en AS parking_en_157, t135.parking_cn AS parking_cn_158, t135.parking_tw AS parking_tw_159, t135.transportation_en AS transportation_en_160, t135.transportation_cn AS transportation_cn_161, t135.transportation_tw AS transportation_tw_162, t135.life_summary AS life_summary_163, t135.life_summary_en AS life_summary_en_164, t135.life_summary_cn AS life_summary_cn_165, t135.life_summary_tw AS life_summary_tw_166, t135.parson_comment AS parson_comment_167, t135.parson_comment_en AS parson_comment_en_168, t135.parson_comment_cn AS parson_comment_cn_169, t135.parson_comment_tw AS parson_comment_tw_170, t135.entry_id AS entry_id_171, t135.parson_id AS parson_id_172, t0.slave_entry_id AS slave_entry_id_173, t0.owner_id AS owner_id_174, t0.area_id AS area_id_175 FROM entry_entry t0 LEFT JOIN entry_geolocation t28 ON t28.entry_id = t0.id LEFT JOIN entry_modelplan t36 ON t36.entry_id = t0.id LEFT JOIN entry_hotel t59 ON t59.entry_id = t0.id LEFT JOIN entry_workspace t97 ON t97.entry_id = t0.id LEFT JOIN entry_actibity t135 ON t135.entry_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  26
]
3 0.51 ms
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.headline AS headline_5, t0.headline_en AS headline_en_6, t0.headline_cn AS headline_cn_7, t0.headline_tw AS headline_tw_8, t0.image AS image_9, t0.image_width AS image_width_10, t0.image_height AS image_height_11, t0.content AS content_12, t0.content_en AS content_en_13, t0.content_cn AS content_cn_14, t0.content_tw AS content_tw_15, t0.link_url AS link_url_16, t0.link_label AS link_label_17, t0.link_label_en AS link_label_en_18, t0.link_label_cn AS link_label_cn_19, t0.link_label_tw AS link_label_tw_20, t0.sort AS sort_21, t0.post_id AS post_id_22 FROM cms_entry_report_child t0 WHERE t0.post_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC
Parameters:
[
  2
]
4 3.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.intro AS intro_5, t0.intro_en AS intro_en_6, t0.intro_cn AS intro_cn_7, t0.intro_tw AS intro_tw_8, t0.enable AS enable_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM mst_master_reportwriter t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
5 3.89 ms
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:
[
  26
]

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\Report\Post No errors.
App\Entity\Entry\Entry No errors.
App\Entity\Account\Owner No errors.
App\Entity\Master\ReportWriter No errors.
App\Entity\Entry\Report\Child 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\Entry\Workspace No errors.
App\Entity\Entry\Actibity 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\ModelPlanScheduleDay No errors.
App\Entity\Entry\SlaveModelPlanScheduleDay No errors.
App\Entity\Master\Equipment No errors.
App\Entity\Master\Service No errors.
App\Entity\Master\Target No errors.