Query Metrics
31
Database Queries
6
Different statements
3.67 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 2.04 ms |
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 entry_modelplan e1_ ON (e0_.id = e1_.entry_id) AND (e1_.deleted_at IS NULL) LEFT JOIN account_owner a2_ ON (e0_.owner_id = a2_.id) AND (a2_.deleted_at IS NULL) WHERE (e0_.category = 1 AND e0_.approval = ? AND e0_.is_draft = ? AND a2_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.is_recommend DESC, RAND() ASC, e0_.id DESC LIMIT 6
Parameters:
[ 1 0 1 ] |
2 | 0.08 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.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:
[
17
]
|
3 | 0.06 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.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:
[
17
]
|
4 | 0.08 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.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:
[
17
]
|
5 | 0.06 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.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:
[
17
]
|
6 | 0.07 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.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:
[
17
]
|
7 | 0.06 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.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:
[
3
]
|
8 | 0.05 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.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:
[
3
]
|
9 | 0.05 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.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:
[
3
]
|
10 | 0.05 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.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:
[
3
]
|
11 | 0.05 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.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:
[
3
]
|
12 | 0.04 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.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:
[
7
]
|
13 | 0.05 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.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:
[
7
]
|
14 | 0.05 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.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:
[
7
]
|
15 | 0.04 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.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:
[
7
]
|
16 | 0.04 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.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:
[
7
]
|
17 | 0.05 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.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:
[
8
]
|
18 | 0.04 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.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:
[
8
]
|
19 | 0.05 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.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:
[
8
]
|
20 | 0.05 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.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:
[
8
]
|
21 | 0.05 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.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:
[
8
]
|
22 | 0.04 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.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:
[
16
]
|
23 | 0.04 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.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:
[
16
]
|
24 | 0.05 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.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:
[
16
]
|
25 | 0.05 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.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:
[
16
]
|
26 | 0.05 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.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:
[
16
]
|
27 | 0.04 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.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:
[
2
]
|
28 | 0.12 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.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:
[
2
]
|
29 | 0.07 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.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:
[
2
]
|
30 | 0.05 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.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:
[
2
]
|
31 | 0.05 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.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:
[
2
]
|
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\Entry\ModelPlan | 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\Master\Parson | No errors. |
App\Entity\Entry\ModelPlanScheduleDay | No errors. |
App\Entity\Entry\ModelPlanScore | No errors. |
App\Entity\Master\Equipment | No errors. |
App\Entity\Master\Service | No errors. |
App\Entity\Master\Target | No errors. |
App\Entity\Master\Tag | No errors. |
App\Entity\Entry\Hotel | No errors. |
App\Entity\Entry\Workspace | No errors. |
App\Entity\Entry\Actibity | No errors. |
App\Entity\Entry\SlaveModelPlanScheduleDay | No errors. |
App\Entity\Entry\Report\Post | No errors. |