Log Messages
Info. & Errors 1
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO | request |
Matched route "search_index" .
[ "route" => "search_index" "route_parameters" => [ "_route" => "search_index" "_controller" => "App\Controller\Mvc\searchController::index" "_locale" => "tw" ] "request_uri" => "https://mie-workation-staging.site/tw/search/" "method" => "GET" ] |
Deprecations 42
Log messages generated by using features marked as deprecated.
Debug 166
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
security |
Checking for authenticator support.
[ "firewall_name" => "main" "authenticators" => 3 ] |
|
security |
Checking support on authenticator.
[ "firewall_name" => "main" "authenticator" => "App\Security\ApiLoginAuthenticator" ] |
|
security |
Authenticator does not support the request.
[ "firewall_name" => "main" "authenticator" => "App\Security\ApiLoginAuthenticator" ] |
|
security |
Checking support on authenticator.
[ "firewall_name" => "main" "authenticator" => "App\Security\LoginFormAuthenticator" ] |
|
security |
Authenticator does not support the request.
[ "firewall_name" => "main" "authenticator" => "App\Security\LoginFormAuthenticator" ] |
|
security |
Checking support on authenticator.
[ "firewall_name" => "main" "authenticator" => "App\Security\ApiTokenAuthenticator" ] |
|
security |
Authenticator does not support the request.
[ "firewall_name" => "main" "authenticator" => "App\Security\ApiTokenAuthenticator" ] |
|
event |
Notified event "kernel.request" to listener "App\EventListener\CorsListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "App\EventListener\CorsListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator" ] |
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
|
event |
Notified event "kernel.controller" to listener "App\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "App\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments" ] |
|
event |
Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments" .
[ "event" => "kernel.controller_arguments" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments" ] |
|
doctrine |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 4
[ 1 true false 1 ] |
|
doctrine |
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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC
[ 1 true false 1 [ 2 14 12 8 ] ] |
|
doctrine |
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))
[
14
]
|
|
doctrine |
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))
[
14
]
|
|
doctrine |
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))
[
14
]
|
|
doctrine |
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))
[
14
]
|
|
doctrine |
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))
[
14
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
2
]
|
|
doctrine |
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))
[
2
]
|
|
doctrine |
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))
[
2
]
|
|
doctrine |
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))
[
2
]
|
|
doctrine |
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))
[
2
]
|
|
doctrine |
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))
[
12
]
|
|
doctrine |
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))
[
12
]
|
|
doctrine |
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))
[
12
]
|
|
doctrine |
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))
[
12
]
|
|
doctrine |
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))
[
12
]
|
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC) dctrn_result) dctrn_table
[ 1 true false 1 ] |
|
doctrine |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4
[ 4 true false 1 ] |
|
doctrine |
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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC
[ 4 true false 1 [ 63 62 61 60 ] ] |
|
doctrine |
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))
[
63
]
|
|
doctrine |
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))
[
63
]
|
|
doctrine |
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))
[
63
]
|
|
doctrine |
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))
[
63
]
|
|
doctrine |
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))
[
63
]
|
|
doctrine |
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))
[
62
]
|
|
doctrine |
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))
[
62
]
|
|
doctrine |
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))
[
62
]
|
|
doctrine |
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))
[
62
]
|
|
doctrine |
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))
[
62
]
|
|
doctrine |
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))
[
61
]
|
|
doctrine |
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))
[
61
]
|
|
doctrine |
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))
[
61
]
|
|
doctrine |
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))
[
61
]
|
|
doctrine |
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))
[
61
]
|
|
doctrine |
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))
[
60
]
|
|
doctrine |
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))
[
60
]
|
|
doctrine |
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))
[
60
]
|
|
doctrine |
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))
[
60
]
|
|
doctrine |
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))
[
60
]
|
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC) dctrn_result) dctrn_table
[ 4 true false 1 ] |
|
doctrine |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4
[ 2 true false 1 ] |
|
doctrine |
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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC
[ 2 true false 1 [ 50 49 48 47 ] ] |
|
doctrine |
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))
[
50
]
|
|
doctrine |
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))
[
50
]
|
|
doctrine |
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))
[
50
]
|
|
doctrine |
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))
[
50
]
|
|
doctrine |
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))
[
50
]
|
|
doctrine |
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))
[
49
]
|
|
doctrine |
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))
[
49
]
|
|
doctrine |
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))
[
49
]
|
|
doctrine |
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))
[
49
]
|
|
doctrine |
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))
[
49
]
|
|
doctrine |
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))
[
48
]
|
|
doctrine |
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))
[
48
]
|
|
doctrine |
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))
[
48
]
|
|
doctrine |
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))
[
48
]
|
|
doctrine |
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))
[
48
]
|
|
doctrine |
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))
[
47
]
|
|
doctrine |
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))
[
47
]
|
|
doctrine |
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))
[
47
]
|
|
doctrine |
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))
[
47
]
|
|
doctrine |
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))
[
47
]
|
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC) dctrn_result) dctrn_table
[ 2 true false 1 ] |
|
doctrine |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4
[ 8 true false 1 ] |
|
doctrine |
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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC
[ 8 true false 1 [ 92 91 90 89 ] ] |
|
doctrine |
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))
[
92
]
|
|
doctrine |
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))
[
92
]
|
|
doctrine |
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))
[
92
]
|
|
doctrine |
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))
[
92
]
|
|
doctrine |
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))
[
92
]
|
|
doctrine |
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))
[
91
]
|
|
doctrine |
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))
[
91
]
|
|
doctrine |
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))
[
91
]
|
|
doctrine |
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))
[
91
]
|
|
doctrine |
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))
[
91
]
|
|
doctrine |
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))
[
90
]
|
|
doctrine |
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))
[
90
]
|
|
doctrine |
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))
[
90
]
|
|
doctrine |
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))
[
90
]
|
|
doctrine |
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))
[
90
]
|
|
doctrine |
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))
[
89
]
|
|
doctrine |
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))
[
89
]
|
|
doctrine |
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))
[
89
]
|
|
doctrine |
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))
[
89
]
|
|
doctrine |
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))
[
89
]
|
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC) dctrn_result) dctrn_table
[ 8 true false 1 ] |
|
doctrine |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4
[ 16 true false 1 ] |
|
doctrine |
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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ? AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC
[ 16 true false 1 [ 93 ] ] |
|
doctrine |
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))
[
93
]
|
|
doctrine |
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))
[
93
]
|
|
doctrine |
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))
[
93
]
|
|
doctrine |
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))
[
93
]
|
|
doctrine |
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))
[
93
]
|
|
doctrine |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = ? AND e0_.approval = ? AND e0_.is_draft = ? AND a1_.status = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC) dctrn_result) dctrn_table
[ 16 true false 1 ] |
|
doctrine |
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))
[
24
]
|
|
doctrine |
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))
[
16
]
|
|
doctrine |
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))
[
13
]
|
|
doctrine |
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))
[
27
]
|
|
doctrine |
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))
[
18
]
|
|
doctrine |
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))
[
19
]
|
|
doctrine |
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))
[
25
]
|
|
doctrine |
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))
[
8
]
|
|
doctrine |
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))
[
20
]
|
|
doctrine | SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
doctrine | SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
doctrine | SELECT DATABASE() | |
doctrine | SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'xs049568_workationstg' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC | |
doctrine | SELECT DATABASE() | |
doctrine | SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'xs049568_workationstg' /*!50116 AND c.CONSTRAINT_SCHEMA = 'xs049568_workationstg' */ORDER BY k.ORDINAL_POSITION | |
doctrine | SELECT DATABASE() | |
doctrine | SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'xs049568_workationstg' ORDER BY SEQ_IN_INDEX ASC | |
doctrine | SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions' | |
doctrine | SELECT * FROM doctrine_migration_versions | |
doctrine | SELECT DATABASE() | |
event |
Notified event "kernel.response" to listener "App\EventListener\CorsListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "App\EventListener\CorsListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets" ] |
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 1828
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
532 |
Symfony\Component\HttpKernel\DependencyInjection\RemoveEmptyControllerArgumentLocatorsPass
|
1 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
257 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
76 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
520 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
92 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
350 |