Log Messages
Info. & Errors 16
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO 13:06:44 | request |
Matched route "group_home" .
[ "route" => "group_home" "route_parameters" => [ "_controller" => "CustomBundle\Controller\GroupHomeController::indexAction" "_route" => "group_home" ] "request_uri" => "http://nisshindetabeyo.jp/" "method" => "GET" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "ジャンル" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "和食" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "洋食" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "中華" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "ジブリパークからの距離" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "お車20分圏内" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "お車30分圏内" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "利用シーン" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "家族・子供と" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "知人・友人と" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "デート" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "特徴" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "ランチ" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "ディナー" "domain" => "messages" "locale" => "ja" ] |
WARNING 13:06:44 | translation |
Translation not found.
[ "id" => "クーポン" "domain" => "messages" "locale" => "ja" ] |
Deprecations 12
Log messages generated by using features marked as deprecated.
Time | Channel | Message |
---|---|---|
13:06:44 | php |
User Deprecated: Bundle inheritance is deprecated as of 3.4 and will be removed in 4.0.
[ "exception" => ErrorException {#32 #message: "User Deprecated: Bundle inheritance is deprecated as of 3.4 and will be removed in 4.0." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php" #line: 501 #severity: E_USER_DEPRECATED : { { › {{ › |
13:06:44 | php |
User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\BaseController".
[ "exception" => ErrorException {#416 #message: "User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\BaseController"." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/symfony/symfony/src/Symfony/Component/Debug/DebugClassLoader.php" #line: 200 #severity: E_USER_DEPRECATED : { { › {{ › |
13:06:44 | php |
User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::createForm()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "CustomBundle\Controller\GroupHomeController".
[ "exception" => ErrorException {#353 #message: "User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::createForm()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "CustomBundle\Controller\GroupHomeController"." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/symfony/symfony/src/Symfony/Component/Debug/DebugClassLoader.php" #line: 200 #severity: E_USER_DEPRECATED : { { › {{ › |
13:06:44 | php |
User Deprecated: Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0.
[ "exception" => ErrorException {#245 #message: "User Deprecated: Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UnderscoreNamingStrategy.php" #line: 66 #severity: E_USER_DEPRECATED : { { › {{ › |
13:06:44 | php (2 times) |
User Deprecated: Absolute template path support is deprecated since Symfony 3.1 and will be removed in 4.0.
[ "exception" => ErrorException {#3433 #message: "User Deprecated: Absolute template path support is deprecated since Symfony 3.1 and will be removed in 4.0." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Templating/TemplateNameParser.php" #line: 75 #severity: E_USER_DEPRECATED : { { › {{ › |
13:07:08 | php |
User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\Admin\Base\BaseController".
[ "exception" => ErrorException {#3874 #message: "User Deprecated: The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\Admin\Base\BaseController"." #code: 0 #file: "/usr/home/hbw1003dss5t/html/admin/cms/vendor/symfony/symfony/src/Symfony/Component/Debug/DebugClassLoader.php" #line: 200 #severity: E_USER_DEPRECATED : { { › {{ › |
14:49:18 | - |
The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\Admin\Base\BaseController".
[ "exception" => SilencedErrorContext {#4033 +count: 1 -severity: E_USER_DEPRECATED : { { › {{ › |
14:49:18 | - |
The "Symfony\Bundle\FrameworkBundle\Controller\Controller::render()" method is considered final since version 3.4. It may change without further notice as of its next major version. You should not extend it from "AppBundle\Controller\BaseController".
[ "exception" => SilencedErrorContext {#4030 +count: 1 -severity: E_USER_DEPRECATED : { { › {{ › |
14:49:18 | - |
The "profiler.matcher" configuration key has been deprecated in Symfony 3.4 and it will be removed in 4.0.
[ "exception" => SilencedErrorContext {#4031 +count: 1 -severity: E_USER_DEPRECATED : { { › {{ › |
14:49:18 | - |
Not setting "logout_on_user_change" to true on firewall "setup_util" is deprecated as of 3.4, it will always be true in 4.0.
[ "exception" => SilencedErrorContext {#4029 +count: 1 -severity: E_USER_DEPRECATED : { { › {{ › |
14:49:18 | - |
Relying on service auto-registration for type "AppBundle\Entity\Approval\ApprovalRequest" is deprecated since Symfony 3.4 and won't be supported in 4.0. Create a service named "AppBundle\Entity\Approval\ApprovalRequest" instead.
[ "exception" => SilencedErrorContext {#4028 +count: 1 -severity: E_USER_DEPRECATED : { { › › {{ › › |
Debug 75
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "CustomBundle\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "CustomBundle\EventListener\LocaleListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "AppBundle\EventListener\KernelEventListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "AppBundle\EventListener\KernelEventListener::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "AppBundle\DataCollector\CustomRequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "AppBundle\DataCollector\CustomRequestDataCollector::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
13:06:44 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
13:06:44 | 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" ] |
13:06:44 | 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" ] |
13:06:44 | doctrine | SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC |
13:06:44 | doctrine |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 13:06:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[ [ 405 406 409 410 413 414 ] ] |
13:06:44 | doctrine |
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[
[
1
]
]
|
13:06:44 | doctrine |
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (?)
[
[
1
]
]
|
13:06:44 | doctrine |
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[
[
1
]
]
|
13:06:44 | doctrine |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2024-11-15 13:06:44") AND (t27.expires_at IS NULL OR t27.expires_at > "2024-11-15 13:06:44"))) WHERE t0.id IN (?)
[
[
1
]
]
|
13:06:44 | doctrine | SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC |
13:06:44 | doctrine | SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC |
13:06:44 | doctrine | SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC |
13:06:44 | doctrine | SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC |
13:06:44 | doctrine | SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.image AS image_17, c0_.time_by_car AS time_by_car_18, c0_.scene AS scene_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_gourmet_pickup_items c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC |
13:06:44 | doctrine |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 13:06:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[ [ 626 628 590 ] ] |
13:06:44 | doctrine |
SELECT t0.public_date AS public_date_1, t0.customblock AS customblock_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.revision_parent AS revision_parent_14, t0.revision_version AS revision_version_15, t0.post_type AS post_type_16, t0.access_token AS access_token_17, t0.thumbnail AS thumbnail_18, t19.alt AS alt_20, t19.caption AS caption_21, t19.collation_code AS collation_code_22, t19.meta AS meta_23, t19.id AS id_24, t19.sort_num AS sort_num_25, t19.status AS status_26, t19.publish_at AS publish_at_27, t19.expires_at AS expires_at_28, t19.created_at AS created_at_29, t19.updated_at AS updated_at_30, t19.title AS title_31, t19.item_id AS item_id_32, t19.thumb_item_id AS thumb_item_id_33, t19.group_id AS group_id_34, t19.created_by AS created_by_35, t19.updated_by AS updated_by_36, t0.facility_id AS facility_id_37, t38.code AS code_39, t38.title AS title_40, t38.intro_text AS intro_text_41, t38.zip AS zip_42, t38.address AS address_43, t38.building AS building_44, t38.google_maps_url AS google_maps_url_45, t38.phone AS phone_46, t38.website AS website_47, t38.opening_hours AS opening_hours_48, t38.holiday AS holiday_49, t38.access AS access_50, t38.access_car AS access_car_51, t38.access_train AS access_train_52, t38.id AS id_53, t38.sort_num AS sort_num_54, t38.status AS status_55, t38.publish_at AS publish_at_56, t38.expires_at AS expires_at_57, t38.created_at AS created_at_58, t38.updated_at AS updated_at_59, t38.area_id AS area_id_60, t38.prefecture_id AS prefecture_id_61, t38.logo_image AS logo_image_62, t38.main_image AS main_image_63, t38.created_by AS created_by_64, t38.updated_by AS updated_by_65, t0.created_by AS created_by_66, t67.username AS username_68, t67.username_canonical AS username_canonical_69, t67.enabled AS enabled_70, t67.last_login AS last_login_71, t67.confirmation_token AS confirmation_token_72, t67.password_requested_at AS password_requested_at_73, t67.roles AS roles_74, t67.id AS id_75, t67.display_name AS display_name_76, t67.sort_num AS sort_num_77, t67.email AS email_78, t67.email_canonical AS email_canonical_79, t67.salt AS salt_80, t67.password AS password_81, t67.group_id AS group_id_82, t67.facility_id AS facility_id_83, t0.updated_by AS updated_by_84, t85.username AS username_86, t85.username_canonical AS username_canonical_87, t85.enabled AS enabled_88, t85.last_login AS last_login_89, t85.confirmation_token AS confirmation_token_90, t85.password_requested_at AS password_requested_at_91, t85.roles AS roles_92, t85.id AS id_93, t85.display_name AS display_name_94, t85.sort_num AS sort_num_95, t85.email AS email_96, t85.email_canonical AS email_canonical_97, t85.salt AS salt_98, t85.password AS password_99, t85.group_id AS group_id_100, t85.facility_id AS facility_id_101, t0.language_id AS language_id_102, t103.alias AS alias_104, t103.translate_key AS translate_key_105, t103.target_key AS target_key_106, t103.id AS id_107, t103.sort_num AS sort_num_108, t103.status AS status_109, t103.publish_at AS publish_at_110, t103.expires_at AS expires_at_111, t103.created_at AS created_at_112, t103.updated_at AS updated_at_113, t103.title AS title_114, t103.created_by AS created_by_115, t103.updated_by AS updated_by_116, t0.latest_approval_request_id AS latest_approval_request_id_117, t118.id AS id_119, t118.handler_name AS handler_name_120, t118.title AS title_121, t118.target_id AS target_id_122, t118.request_type AS request_type_123, t118.moderated_at AS moderated_at_124, t118.approval_status AS approval_status_125, t118.comment AS comment_126, t118.created_at AS created_at_127, t118.updated_at AS updated_at_128, t118.facility_id AS facility_id_129, t118.requested_by AS requested_by_130, t118.moderated_by AS moderated_by_131 FROM cms_mod_restaurant_time_by_cars t0 LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id AND ((t19.status = 1 AND (t19.publish_at IS NULL OR t19.publish_at <= "2024-11-15 13:06:44") AND (t19.expires_at IS NULL OR t19.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id AND ((t38.status = 1 AND (t38.publish_at IS NULL OR t38.publish_at <= "2024-11-15 13:06:44") AND (t38.expires_at IS NULL OR t38.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t67 ON t0.created_by = t67.id LEFT JOIN cms_user t85 ON t0.updated_by = t85.id LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id AND ((t103.status = 1 AND (t103.publish_at IS NULL OR t103.publish_at <= "2024-11-15 13:06:44") AND (t103.expires_at IS NULL OR t103.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.id WHERE t0.id IN (?) AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15")))
[
[
1
]
]
|
13:06:44 | doctrine | SELECT c0_.catch_copy AS catch_copy_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.restaurant AS restaurant_18, c0_.image AS image_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_restaurant_pickup_items c0_ INNER JOIN cms_mod_restaurant_restaurants c1_ ON c0_.restaurant = c1_.id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 13:06:44") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 13:06:44") AND (c1_.public_date IS NULL OR c1_.public_date <= "2024-11-15")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC |
13:06:44 | doctrine |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 13:06:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[ [ 674 592 ] ] |
13:06:44 | doctrine | SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 13:06:44") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 13:06:44")) WHERE (c0_.important = 1) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 1 |
13:06:44 | doctrine |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 13:06:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[
[
618
]
]
|
13:06:44 | doctrine | SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 13:06:44") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 13:06:44")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 5 |
13:06:44 | doctrine | SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_top_banners c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 13:06:44") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 13:06:44") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC LIMIT 1 |
13:06:44 | doctrine |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 13:06:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")))
[ [ 635 636 ] ] |
13:06:44 | doctrine |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 13:06:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
1
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id WHERE cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
1
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2024-11-15 13:06:44") AND (t23.expires_at IS NULL OR t23.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2024-11-15 13:06:44") AND (t42.expires_at IS NULL OR t42.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2024-11-15 13:06:44") AND (t107.expires_at IS NULL OR t107.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_top_gourmet_pickup_items_features ON t0.id = cms_mod_top_gourmet_pickup_items_features.feature_id WHERE cms_mod_top_gourmet_pickup_items_features.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
1
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id WHERE cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
3
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2024-11-15 13:06:44") AND (t23.expires_at IS NULL OR t23.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2024-11-15 13:06:44") AND (t42.expires_at IS NULL OR t42.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2024-11-15 13:06:44") AND (t107.expires_at IS NULL OR t107.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_top_gourmet_pickup_items_features ON t0.id = cms_mod_top_gourmet_pickup_items_features.feature_id WHERE cms_mod_top_gourmet_pickup_items_features.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
3
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id WHERE cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
5
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2024-11-15 13:06:44") AND (t23.expires_at IS NULL OR t23.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2024-11-15 13:06:44") AND (t42.expires_at IS NULL OR t42.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2024-11-15 13:06:44") AND (t107.expires_at IS NULL OR t107.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_top_gourmet_pickup_items_features ON t0.id = cms_mod_top_gourmet_pickup_items_features.feature_id WHERE cms_mod_top_gourmet_pickup_items_features.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
5
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id WHERE cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
7
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2024-11-15 13:06:44") AND (t23.expires_at IS NULL OR t23.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2024-11-15 13:06:44") AND (t42.expires_at IS NULL OR t42.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2024-11-15 13:06:44") AND (t107.expires_at IS NULL OR t107.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_top_gourmet_pickup_items_features ON t0.id = cms_mod_top_gourmet_pickup_items_features.feature_id WHERE cms_mod_top_gourmet_pickup_items_features.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
7
]
|
13:06:44 | doctrine |
SELECT t0.this_month_recommendation AS this_month_recommendation_1, t0.title_kana AS title_kana_2, t0.business_hours AS business_hours_3, t0.business_hours_supplement AS business_hours_supplement_4, t0.holiday AS holiday_5, t0.holiday_supplement AS holiday_supplement_6, t0.description AS description_7, t0.map_url AS map_url_8, t0.route AS route_9, t0.tabelog_reserve AS tabelog_reserve_10, t0.hotpepper_reserve AS hotpepper_reserve_11, t0.ikyu_reserve AS ikyu_reserve_12, t0.contact_etc AS contact_etc_13, t0.tel AS tel_14, t0.information AS information_15, t0.budget AS budget_16, t0.address AS address_17, t0.access AS access_18, t0.parking AS parking_19, t0.seats AS seats_20, t0.private_room AS private_room_21, t0.payment AS payment_22, t0.site_url_1 AS site_url_1_23, t0.site_url_2 AS site_url_2_24, t0.site_url_3 AS site_url_3_25, t0.map_iframe AS map_iframe_26, t0.public_date AS public_date_27, t0.customblock AS customblock_28, t0.id AS id_29, t0.sort_num AS sort_num_30, t0.status AS status_31, t0.publish_at AS publish_at_32, t0.expires_at AS expires_at_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.title AS title_36, t0.language_parent AS language_parent_37, t0.language_alias AS language_alias_38, t0.language_active AS language_active_39, t0.revision_parent AS revision_parent_40, t0.revision_version AS revision_version_41, t0.post_type AS post_type_42, t0.access_token AS access_token_43, t0.main_image AS main_image_44, t45.meta AS meta_46, t45.id AS id_47, t45.sort_num AS sort_num_48, t45.status AS status_49, t45.publish_at AS publish_at_50, t45.expires_at AS expires_at_51, t45.created_at AS created_at_52, t45.updated_at AS updated_at_53, t45.title AS title_54, t45.created_by AS created_by_55, t45.updated_by AS updated_by_56, t0.time_by_car_id AS time_by_car_id_57, t58.public_date AS public_date_59, t58.customblock AS customblock_60, t58.id AS id_61, t58.sort_num AS sort_num_62, t58.status AS status_63, t58.publish_at AS publish_at_64, t58.expires_at AS expires_at_65, t58.created_at AS created_at_66, t58.updated_at AS updated_at_67, t58.title AS title_68, t58.language_parent AS language_parent_69, t58.language_alias AS language_alias_70, t58.language_active AS language_active_71, t58.revision_parent AS revision_parent_72, t58.revision_version AS revision_version_73, t58.post_type AS post_type_74, t58.access_token AS access_token_75, t58.thumbnail AS thumbnail_76, t58.facility_id AS facility_id_77, t58.created_by AS created_by_78, t58.updated_by AS updated_by_79, t58.language_id AS language_id_80, t58.latest_approval_request_id AS latest_approval_request_id_81, t0.thumbnail AS thumbnail_82, t83.alt AS alt_84, t83.caption AS caption_85, t83.collation_code AS collation_code_86, t83.meta AS meta_87, t83.id AS id_88, t83.sort_num AS sort_num_89, t83.status AS status_90, t83.publish_at AS publish_at_91, t83.expires_at AS expires_at_92, t83.created_at AS created_at_93, t83.updated_at AS updated_at_94, t83.title AS title_95, t83.item_id AS item_id_96, t83.thumb_item_id AS thumb_item_id_97, t83.group_id AS group_id_98, t83.created_by AS created_by_99, t83.updated_by AS updated_by_100, t0.facility_id AS facility_id_101, t102.code AS code_103, t102.title AS title_104, t102.intro_text AS intro_text_105, t102.zip AS zip_106, t102.address AS address_107, t102.building AS building_108, t102.google_maps_url AS google_maps_url_109, t102.phone AS phone_110, t102.website AS website_111, t102.opening_hours AS opening_hours_112, t102.holiday AS holiday_113, t102.access AS access_114, t102.access_car AS access_car_115, t102.access_train AS access_train_116, t102.id AS id_117, t102.sort_num AS sort_num_118, t102.status AS status_119, t102.publish_at AS publish_at_120, t102.expires_at AS expires_at_121, t102.created_at AS created_at_122, t102.updated_at AS updated_at_123, t102.area_id AS area_id_124, t102.prefecture_id AS prefecture_id_125, t102.logo_image AS logo_image_126, t102.main_image AS main_image_127, t102.created_by AS created_by_128, t102.updated_by AS updated_by_129, t0.created_by AS created_by_130, t131.username AS username_132, t131.username_canonical AS username_canonical_133, t131.enabled AS enabled_134, t131.last_login AS last_login_135, t131.confirmation_token AS confirmation_token_136, t131.password_requested_at AS password_requested_at_137, t131.roles AS roles_138, t131.id AS id_139, t131.display_name AS display_name_140, t131.sort_num AS sort_num_141, t131.email AS email_142, t131.email_canonical AS email_canonical_143, t131.salt AS salt_144, t131.password AS password_145, t131.group_id AS group_id_146, t131.facility_id AS facility_id_147, t0.updated_by AS updated_by_148, t149.username AS username_150, t149.username_canonical AS username_canonical_151, t149.enabled AS enabled_152, t149.last_login AS last_login_153, t149.confirmation_token AS confirmation_token_154, t149.password_requested_at AS password_requested_at_155, t149.roles AS roles_156, t149.id AS id_157, t149.display_name AS display_name_158, t149.sort_num AS sort_num_159, t149.email AS email_160, t149.email_canonical AS email_canonical_161, t149.salt AS salt_162, t149.password AS password_163, t149.group_id AS group_id_164, t149.facility_id AS facility_id_165, t0.language_id AS language_id_166, t167.alias AS alias_168, t167.translate_key AS translate_key_169, t167.target_key AS target_key_170, t167.id AS id_171, t167.sort_num AS sort_num_172, t167.status AS status_173, t167.publish_at AS publish_at_174, t167.expires_at AS expires_at_175, t167.created_at AS created_at_176, t167.updated_at AS updated_at_177, t167.title AS title_178, t167.created_by AS created_by_179, t167.updated_by AS updated_by_180, t0.latest_approval_request_id AS latest_approval_request_id_181, t182.id AS id_183, t182.handler_name AS handler_name_184, t182.title AS title_185, t182.target_id AS target_id_186, t182.request_type AS request_type_187, t182.moderated_at AS moderated_at_188, t182.approval_status AS approval_status_189, t182.comment AS comment_190, t182.created_at AS created_at_191, t182.updated_at AS updated_at_192, t182.facility_id AS facility_id_193, t182.requested_by AS requested_by_194, t182.moderated_by AS moderated_by_195 FROM cms_mod_restaurant_restaurants t0 LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id AND ((t45.status = 1 AND (t45.publish_at IS NULL OR t45.publish_at <= "2024-11-15 13:06:44") AND (t45.expires_at IS NULL OR t45.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id AND ((t58.post_type IN ("master")) AND (t58.status = 1 AND (t58.publish_at IS NULL OR t58.publish_at <= "2024-11-15 13:06:44") AND (t58.expires_at IS NULL OR t58.expires_at > "2024-11-15 13:06:44") AND (t58.public_date IS NULL OR t58.public_date <= "2024-11-15"))) LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id AND ((t83.status = 1 AND (t83.publish_at IS NULL OR t83.publish_at <= "2024-11-15 13:06:44") AND (t83.expires_at IS NULL OR t83.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t131 ON t0.created_by = t131.id LEFT JOIN cms_user t149 ON t0.updated_by = t149.id LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id AND ((t167.status = 1 AND (t167.publish_at IS NULL OR t167.publish_at <= "2024-11-15 13:06:44") AND (t167.expires_at IS NULL OR t167.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id WHERE t0.id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15")))
[
1
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id WHERE cms_mod_restaurant_restaurants_genres.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
1
]
|
13:06:44 | doctrine |
SELECT t0.this_month_recommendation AS this_month_recommendation_1, t0.title_kana AS title_kana_2, t0.business_hours AS business_hours_3, t0.business_hours_supplement AS business_hours_supplement_4, t0.holiday AS holiday_5, t0.holiday_supplement AS holiday_supplement_6, t0.description AS description_7, t0.map_url AS map_url_8, t0.route AS route_9, t0.tabelog_reserve AS tabelog_reserve_10, t0.hotpepper_reserve AS hotpepper_reserve_11, t0.ikyu_reserve AS ikyu_reserve_12, t0.contact_etc AS contact_etc_13, t0.tel AS tel_14, t0.information AS information_15, t0.budget AS budget_16, t0.address AS address_17, t0.access AS access_18, t0.parking AS parking_19, t0.seats AS seats_20, t0.private_room AS private_room_21, t0.payment AS payment_22, t0.site_url_1 AS site_url_1_23, t0.site_url_2 AS site_url_2_24, t0.site_url_3 AS site_url_3_25, t0.map_iframe AS map_iframe_26, t0.public_date AS public_date_27, t0.customblock AS customblock_28, t0.id AS id_29, t0.sort_num AS sort_num_30, t0.status AS status_31, t0.publish_at AS publish_at_32, t0.expires_at AS expires_at_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.title AS title_36, t0.language_parent AS language_parent_37, t0.language_alias AS language_alias_38, t0.language_active AS language_active_39, t0.revision_parent AS revision_parent_40, t0.revision_version AS revision_version_41, t0.post_type AS post_type_42, t0.access_token AS access_token_43, t0.main_image AS main_image_44, t45.meta AS meta_46, t45.id AS id_47, t45.sort_num AS sort_num_48, t45.status AS status_49, t45.publish_at AS publish_at_50, t45.expires_at AS expires_at_51, t45.created_at AS created_at_52, t45.updated_at AS updated_at_53, t45.title AS title_54, t45.created_by AS created_by_55, t45.updated_by AS updated_by_56, t0.time_by_car_id AS time_by_car_id_57, t58.public_date AS public_date_59, t58.customblock AS customblock_60, t58.id AS id_61, t58.sort_num AS sort_num_62, t58.status AS status_63, t58.publish_at AS publish_at_64, t58.expires_at AS expires_at_65, t58.created_at AS created_at_66, t58.updated_at AS updated_at_67, t58.title AS title_68, t58.language_parent AS language_parent_69, t58.language_alias AS language_alias_70, t58.language_active AS language_active_71, t58.revision_parent AS revision_parent_72, t58.revision_version AS revision_version_73, t58.post_type AS post_type_74, t58.access_token AS access_token_75, t58.thumbnail AS thumbnail_76, t58.facility_id AS facility_id_77, t58.created_by AS created_by_78, t58.updated_by AS updated_by_79, t58.language_id AS language_id_80, t58.latest_approval_request_id AS latest_approval_request_id_81, t0.thumbnail AS thumbnail_82, t83.alt AS alt_84, t83.caption AS caption_85, t83.collation_code AS collation_code_86, t83.meta AS meta_87, t83.id AS id_88, t83.sort_num AS sort_num_89, t83.status AS status_90, t83.publish_at AS publish_at_91, t83.expires_at AS expires_at_92, t83.created_at AS created_at_93, t83.updated_at AS updated_at_94, t83.title AS title_95, t83.item_id AS item_id_96, t83.thumb_item_id AS thumb_item_id_97, t83.group_id AS group_id_98, t83.created_by AS created_by_99, t83.updated_by AS updated_by_100, t0.facility_id AS facility_id_101, t102.code AS code_103, t102.title AS title_104, t102.intro_text AS intro_text_105, t102.zip AS zip_106, t102.address AS address_107, t102.building AS building_108, t102.google_maps_url AS google_maps_url_109, t102.phone AS phone_110, t102.website AS website_111, t102.opening_hours AS opening_hours_112, t102.holiday AS holiday_113, t102.access AS access_114, t102.access_car AS access_car_115, t102.access_train AS access_train_116, t102.id AS id_117, t102.sort_num AS sort_num_118, t102.status AS status_119, t102.publish_at AS publish_at_120, t102.expires_at AS expires_at_121, t102.created_at AS created_at_122, t102.updated_at AS updated_at_123, t102.area_id AS area_id_124, t102.prefecture_id AS prefecture_id_125, t102.logo_image AS logo_image_126, t102.main_image AS main_image_127, t102.created_by AS created_by_128, t102.updated_by AS updated_by_129, t0.created_by AS created_by_130, t131.username AS username_132, t131.username_canonical AS username_canonical_133, t131.enabled AS enabled_134, t131.last_login AS last_login_135, t131.confirmation_token AS confirmation_token_136, t131.password_requested_at AS password_requested_at_137, t131.roles AS roles_138, t131.id AS id_139, t131.display_name AS display_name_140, t131.sort_num AS sort_num_141, t131.email AS email_142, t131.email_canonical AS email_canonical_143, t131.salt AS salt_144, t131.password AS password_145, t131.group_id AS group_id_146, t131.facility_id AS facility_id_147, t0.updated_by AS updated_by_148, t149.username AS username_150, t149.username_canonical AS username_canonical_151, t149.enabled AS enabled_152, t149.last_login AS last_login_153, t149.confirmation_token AS confirmation_token_154, t149.password_requested_at AS password_requested_at_155, t149.roles AS roles_156, t149.id AS id_157, t149.display_name AS display_name_158, t149.sort_num AS sort_num_159, t149.email AS email_160, t149.email_canonical AS email_canonical_161, t149.salt AS salt_162, t149.password AS password_163, t149.group_id AS group_id_164, t149.facility_id AS facility_id_165, t0.language_id AS language_id_166, t167.alias AS alias_168, t167.translate_key AS translate_key_169, t167.target_key AS target_key_170, t167.id AS id_171, t167.sort_num AS sort_num_172, t167.status AS status_173, t167.publish_at AS publish_at_174, t167.expires_at AS expires_at_175, t167.created_at AS created_at_176, t167.updated_at AS updated_at_177, t167.title AS title_178, t167.created_by AS created_by_179, t167.updated_by AS updated_by_180, t0.latest_approval_request_id AS latest_approval_request_id_181, t182.id AS id_183, t182.handler_name AS handler_name_184, t182.title AS title_185, t182.target_id AS target_id_186, t182.request_type AS request_type_187, t182.moderated_at AS moderated_at_188, t182.approval_status AS approval_status_189, t182.comment AS comment_190, t182.created_at AS created_at_191, t182.updated_at AS updated_at_192, t182.facility_id AS facility_id_193, t182.requested_by AS requested_by_194, t182.moderated_by AS moderated_by_195 FROM cms_mod_restaurant_restaurants t0 LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id AND ((t45.status = 1 AND (t45.publish_at IS NULL OR t45.publish_at <= "2024-11-15 13:06:44") AND (t45.expires_at IS NULL OR t45.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id AND ((t58.post_type IN ("master")) AND (t58.status = 1 AND (t58.publish_at IS NULL OR t58.publish_at <= "2024-11-15 13:06:44") AND (t58.expires_at IS NULL OR t58.expires_at > "2024-11-15 13:06:44") AND (t58.public_date IS NULL OR t58.public_date <= "2024-11-15"))) LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id AND ((t83.status = 1 AND (t83.publish_at IS NULL OR t83.publish_at <= "2024-11-15 13:06:44") AND (t83.expires_at IS NULL OR t83.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t131 ON t0.created_by = t131.id LEFT JOIN cms_user t149 ON t0.updated_by = t149.id LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id AND ((t167.status = 1 AND (t167.publish_at IS NULL OR t167.publish_at <= "2024-11-15 13:06:44") AND (t167.expires_at IS NULL OR t167.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id WHERE t0.id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15")))
[
19
]
|
13:06:44 | doctrine |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-15 13:06:44") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-15 13:06:44") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-15 13:06:44") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-15 13:06:44") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-15 13:06:44") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id WHERE cms_mod_restaurant_restaurants_genres.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
19
]
|
13:06:44 | doctrine |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 13:06:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
45
]
|
13:06:44 | doctrine |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 13:06:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
42
]
|
13:06:44 | doctrine |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 13:06:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
39
]
|
13:06:44 | doctrine |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 13:06:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC
[
36
]
|
13:06:44 | event |
Notified event "kernel.response" to listener "AppBundle\EventListener\KernelEventListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "AppBundle\EventListener\KernelEventListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "AppBundle\DataCollector\CustomRequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "AppBundle\DataCollector\CustomRequestDataCollector::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" ] |
13:06:44 | 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" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
13:06:44 | event |
Notified event "kernel.finish_request" to listener "AppBundle\EventListener\KernelEventListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "AppBundle\EventListener\KernelEventListener::onKernelFinishRequest" ] |
13:06:44 | 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" ] |
13:06:44 | 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" ] |
13:06:44 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
13:06:44 | 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" ] |
13:06:44 | 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" ] |
PHP Notices 1
Log messages generated by PHP notices silenced with the @ operator.
Time | Channel | Message |
---|---|---|
13:06:44 | php |
Notice: Undefined index: HTTP_HOST
[ "exception" => SilencedErrorContext {#3431 +count: 1 -severity: E_NOTICE : { { › {{ › |
Container 1687
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Liip\ImagineBundle\DependencyInjection\Compiler\LoadersCompilerPass
|
1 |
Liip\ImagineBundle\DependencyInjection\Compiler\FiltersCompilerPass
|
17 |
Liip\ImagineBundle\DependencyInjection\Compiler\PostProcessorsCompilerPass
|
4 |
Liip\ImagineBundle\DependencyInjection\Compiler\ResolversCompilerPass
|
2 |
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
269 |
Symfony\Component\DependencyInjection\Compiler\AutowirePass
|
24 |
Symfony\Component\HttpKernel\DependencyInjection\RemoveEmptyControllerArgumentLocatorsPass
|
78 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
96 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
114 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
304 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
193 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
584 |
Symfony\Bundle\FrameworkBundle\DependencyInjection\Compiler\UnusedTagsPass
|
1 |