Query Metrics
5
Database Queries
5
Different statements
9.59 ms
Query time
0
Invalid entities
Queries
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. |