Logo Sas Asia
  • Company
    • Management
  • Quality
  • Applications
  • News
  • Reference projects
  • Downloads
    • Technical Documents
    • Catalogs and Brochures
    • Approvals
    • Certificates
  • Contact
    • SAH worldwide
  • Career
  1. Home
  2. Data Privacy

This Data Protection Notice (“Notice”) sets out the basis which [SAS Asia Bar Systems Pte. Ltd.] (“we”, “us”, or “our”) may collect, use, disclose or otherwise process personal data of our customers in accordance with the Personal Data Protection Act (“PDPA”). This Notice applies to personal data in our possession or under our control, including personal data in the possession of organisations which we have engaged to collect, use, disclose or process personal data for our purposes.

PERSONAL DATA

1. As used in this Notice: “customer” means an individual who (a) has contacted us through any means to find out more about any goods or services we provide, or (b) may, or has, entered into a contract with us for the supply of any goods or services by us; and “personal data” means data, whether true or not, about a customer who can be identified: (a) from that data; or (b) from that data and other information to which we have or are likely to have access.

2. Depending on the nature of your interaction with us, some examples of personal data which we may collect from you include your name and identification information such as your NRIC number, contact information such as your address, email address or telephone number, nationality, gender, date of birth, marital status, photographs and other audio-visual information, employment information and financial information such as credit card numbers, debit card numbers or bank account information.

3. Other terms used in this Notice shall have the meanings given to them in the PDPA (where the context so permits).

COLLECTION, USE AND DISCLOSURE OF PERSONAL DATA

4. We generally do not collect your personal data unless

(a) it is provided to us voluntarily by you directly or via a third party who has been duly authorised by you to disclose your personal data to us (your “authorised representative”) after (i) you (or your authorised representative) have been notified of the purposes for which the data is collected, and (ii) you (or your authorised representative) have provided written consent to the collection and usage of your personal data for those purposes, or

(b) collection and use of personal data without consent is permitted or required by the PDPA or other laws. We shall seek your consent before collecting any additional personal data and before using your personal data for a purpose which has not been notified to you (except where permitted or authorised by law).

5. We may collect and use your personal data for any or all of the following purposes:

(a) performing obligations in the course of or in connection with our provision of the goods and/or services requested by you;

(b) verifying your identity;

(c) responding to, handling, and processing queries, requests, applications, complaints, and feedback from you;

(d) managing your relationship with us;

(e) processing payment or credit transactions;

(f) sending your marketing information about our goods or services including notifying you of our marketing events, initiatives and promotions, lucky draws, membership and rewards schemes and other promotions;

(g) complying with any applicable laws, regulations, codes of practice, guidelines, or rules, or to assist in law enforcement and investigations conducted by any governmental and/or regulatory authority;

(h) any other purposes for which you have provided the information;

(i) transmitting to any unaffiliated third parties including our third party service providers and agents, and relevant governmental and/or regulatory authorities, whether in Singapore or abroad, for the aforementioned purposes; and

(j) any other incidental business purposes related to or in connection with the above.

6. We may disclose your personal data:

(a) where such disclosure is required for performing obligations in the course of or in connection with our provision of the goods or services requested by you; or

(b) to third party service providers, agents and other organisations we have engaged to perform any of the functions listed in clause 5 above for us.

7. The purposes listed in the above clauses may continue to apply even in situations where your relationship with us (for example, pursuant to a contract) has been terminated or altered in any way, for a reasonable period thereafter (including, where applicable, a period to enable us to enforce our rights under any contract with you).

WITHDRAWING YOUR CONSENT

8. The consent that you provide for the collection, use and disclosure of your personal data will remain valid until such time it is being withdrawn by you in writing. You may withdraw consent and request us to stop using and/or disclosing your personal data for any or all of the purposes listed above by submitting your request in writing or via email to our Data Protection Officer at the contact details provided below.

9. Upon receipt of your written request to withdraw your consent, we may require reasonable time (depending on the complexity of the request and its impact on our relationship with you) for your request to be processed and for us to notify you of the consequences of us acceding to the same, including any legal consequences which may affect your rights and liabilities to us. In general, we shall seek to process your request within ten (10) business days of receiving it.

10. Whilst we respect your decision to withdraw your consent, please note that depending on the nature and scope of your request, we may not be in a position to continue providing our goodsor services to you and we shall, in such circumstances, notify you before completing the processing of your request. Should you decide to cancel your withdrawal of consent, please inform us in writing in the manner described in clause 8 above.

11. Please note that withdrawing consent does not affect our right to continue to collect, use and disclose personal data where such collection, use and disclose without consent is permitted or required under applicable laws.

ACCESS TO AND CORRECTION OF PERSONAL DATA

12. If you wish to make (a) an access request for access to a copy of the personal data which we hold about you or information about the ways in which we use or disclose your personal data, or (b) a correction request to correct or update any of your personal data which we hold about you, you may submit your request in writing or via email to our Data Protection Officer at the contact details provided below.

13. Please note that a reasonable fee may be charged for an access request. If so, we will inform you of the fee before processing your request.

14. We will respond to your request as soon as reasonably possible. Should we not be able to respond to your request within thirty (30) days after receiving your request, we will inform you in writing within thirty (30) days of the time by which we will be able to respond to your request. If we are unable to provide you with any personal data or to make a correction requested by you, we shall generally inform you of the reasons why we are unable to do so (except where we are not required to do so under the PDPA).

PROTECTION OF PERSONAL DATA

15. To safeguard your personal data from unauthorised access, collection, use, disclosure, copying, modification, disposal or similar risks, we have introduced appropriate administrative, physical and technical measures such as up-to-date antivirus protection, encryption and the use of privacy filters to secure all storage and transmission of personal data by us, and disclosing personal data both internally and to our authorised third party service providers and agents only on a need-to-know basis.

16. You should be aware, however, that no method of transmission over the Internet or method of electronic storage is completely secure. While security cannot be guaranteed, we strive to protect the security of your information and are constantly reviewing and enhancing our information security measures.

ACCURACY OF PERSONAL DATA

17. We generally rely on personal data provided by you (or your authorised representative). In order to ensure that your personal data is current, complete and accurate, please update us if there are changes to your personal data by informing our Data Protection Officer in writing or via email at the contact details provided below.

RETENTION OF PERSONAL DATA

18. We may retain your personal data for as long as it is necessary to fulfil the purpose for which it was collected, or as required or permitted by applicable laws.

19. We will cease to retain your personal data, or remove the means by which the data can be associated with you, as soon as it is reasonable to assume that such retention no longer serves the purpose for which the personal data was collected, and is no longer necessary for legal or business purposes.

TRANSFERS OF PERSONAL DATA OUTSIDE OF SINGAPORE

20. We generally do not transfer your personal data to countries outside of Singapore. However, if we do so, we will obtain your consent for the transfer to be made and we will take steps to ensure that your personal data continues to receive a standard of protection that is at least comparable to that provided under the PDPA.

DATA PROTECTION OFFICER

21. You may contact us if you have any enquiries or feedback on our personal data protection policies and procedures, or if you wish to make any request.

EFFECT OF NOTICE AND CHANGES TO NOTICE

22. This Notice applies in conjunction with any other notices, contractual clauses and consent clauses that apply in relation to the collection, use and disclosure of your personal data by us.

23. We may revise this Notice from time to time without any prior notice. You may determine if any such revision has taken place by referring to the date on which this Notice was last updated. Your continued use of our services constitutes your acknowledgement and acceptance of such changes.

 

Effective date : [1st October 2018]

Last updated :  [1st October 2018]

© SAS Asia Bar Systems Pte. Ltd.
  • Terms and Conditions
  • Data Privacy
Partnerlogo UkasPartnerlogo Biz Safe
  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    • Restore to current request
    • home/contact
    • home/contact
    • home/quality
    • robots.txt
    ====
  • Session
    +

    Session

    • Config(array)
      • userAgentca40b5f22cf3d88f707fb259b2686ed4
      • time1657136127
      • countdown10
      • languageen
    ====
  • Request
    +

    Request

    Cake Params

    • pluginFrontendMenus
    • controllerFrontendMenus
    • actioncontent
    • named(empty)
    • pass(array)
      • 065
    • ids(array)
      • Menu65
      • Content(null)
      • Language2
    • route(array)
      • id173
      • hash0c14c8ba9ca0cb82d380036a1908b975
      • created2016-11-22 14:15:23
      • updated2018-01-23 08:16:48
      • modelMenu
      • foreign_key65
      • base/home/
      • aliasdata-privacy
      • controllerFrontendMenus.FrontendMenus
      • actioncontent
      • parent_id169
      • lft248
      • rght251
      • route/home/data-privacy
    • isAjax(false)

    Post data

    No post data.

    Query string

    No querystring data.

    Cookie

    To view Cookies, add CookieComponent to Controller

    Current Route

    • keys(empty)
    • options(empty)
    • defaults(array)
      • plugin(null)
      • actionindex
    • template/*
    ====
  • Sql Log
    +

    Sql Logs

    default

    Total Time: 8 ms
    Total Queries: 100 queries
    Query Affected Num. rows Took (ms) Actions
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/home/data-privacy' LIMIT 1 1 1 0
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`lft` <= 248 AND `Route`.`rght` >= 251 ORDER BY `Route`.`lft` asc 4 4 0
    SELECT `Language`.`langid` FROM `sas_asia`.`languages` AS `Language` WHERE `Language`.`id` = 2 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 65 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 164 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published` FROM `sas_asia`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (65) ORDER BY `Content`.`position` asc 1 1 1
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 150 AND `Route`.`model` = 'Content' 1 1 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 52 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 151 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 151 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 52 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 3 3 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (1, 76, 77) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 24 24 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 52 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (54) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 7 7 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 52 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 3 3 0
    SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 14 AND `Menu`.`rght` < 77 ORDER BY `Menu`.`lft` asc 31 31 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 65 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 164 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 65 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 65 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 65 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`contents` AS `Content` LEFT JOIN `sas_asia`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Teaser`.`show_home` = 1 AND `Language`.`id` = 2 ORDER BY `Teaser`.`updated` desc LIMIT 3 3 3 3
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 234 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 231 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 212 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 234 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (26) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 231 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (25) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 9 9 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 212 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ArticleContentMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (146, 145, 126) AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC 17 17 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (355, 354, 347, 343, 342, 341, 339, 337, 336, 333, 331, 316, 315, 294, 71, 64, 61) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 120 120 0
    SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `GalleryMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (146, 145, 126) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Teaser`.`show_home` = 1 AND `Language`.`id` = 2 ORDER BY `Teaser`.`updated` desc LIMIT 3 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (62) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 83 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (66) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 83 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 83 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 78 AND `Menu`.`rght` < 83 ORDER BY `Menu`.`lft` asc 2 2 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'firma' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 68 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 167 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 167 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 68 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 91 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 240 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 240 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 91 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 91 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 91 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 91 2 2 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 241 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 242 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 241 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 242 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (92, 93) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (92, 93) AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 2 2 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (59, 58) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 2 2 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` IN (92, 93) AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`languages` AS `Language` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1 1 1 0
    SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `sas_asia`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC 2 2 0
    SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 65 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank` FROM `sas_asia`.`menus` AS `Menu` WHERE `Menu`.`id` = 65 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 81 AND `Menu`.`rght` >= 82 ORDER BY `Menu`.`lft` asc 3 3 1 maybe slow
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-logos' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 88 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 237 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 237 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 88 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 88 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 88 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 88 2 2 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 238 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 239 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 238 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 239 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (89, 90) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (89, 90) AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 2 2 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (55, 56) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 14 14 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` IN (89, 90) AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/home/data-privacy/data-privacy' LIMIT 1 1 1 1
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`lft` <= 249 AND `Route`.`rght` >= 250 ORDER BY `Route`.`lft` asc 5 5 0
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`contents` AS `Content` LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 150 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1 1 1 1
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 244 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 1 maybe slow
    SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`languages` AS `Language` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`id` = 2 LIMIT 1 1 1 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1 1 1 0
    SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `sas_asia`.`settings` AS `Setting` LEFT JOIN `sas_asia`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id` 27 27 0
    SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `sas_asia`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC 1 1 0
    SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'search-result' LIMIT 1 1 1 0

    Query Explain:

    Click an "Explain" link above, to see the query explanation.

    ====
  • Timer
    +

    Memory

    Peak Memory Use 20.38 MB

    Message Memory use
    Component initialization 7.19 MB
    Controller action start 7.41 MB
    Controller render start 9.95 MB
    Component initialization #2 14.51 MB
    Controller action start #2 14.69 MB
    Controller render start #2 14.82 MB
    View render complete 15.73 MB

    Timers

    Total Request Time: 543 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 153.79
    Event: Controller.initialize 5.18
    Event: Controller.startup 1.35
    Controller action 62.27
    Event: Controller.beforeRender 127.46
    » Processing toolbar data 23.64
    Rendering View 67.78
    » Event: View.beforeRender 0.07
    » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php 33.16
    » » Event: Controller.initialize #2 0.66
    » » Event: Controller.startup #2 0.43
    » » Controller action #2 4.65
    » » Event: Controller.beforeRender #2 12.38
    » » » Processing toolbar data #2 12.10
    Rendering View #2 0.00
    » » » Event: View.beforeRender #2 0.07
    » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php 3.64
    » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php 0.52
    » » » Event: View.afterRender 0.05
    » » » Event: Controller.shutdown 0.03
    » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2 0.36
    » » Event: View.afterRender #2 9.21
    » » Event: View.beforeLayout 0.07
    » » Rendering APP/View/Layouts/index.php 21.88
    » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php 13.49
    Event: View.afterLayout 0.00
    ====
  • Log
    +

    Logs

    There were no log entries made this request

    ====
  • Variables
    +

    View Variables

    • row(array)
      • Menu(array)
        • id65
        • hashc762e277d14ffd19fa0d6634ce7affcd
        • created2016-11-22 14:15:23
        • updated2018-01-23 08:16:48
        • parent_id61
        • lft81
        • rght82
        • language_id2
        • typecontent
        • titleData Privacy
        • previous_url(null)
        • url(null)
        • target_blank(false)
      • Seo(array)
        • id164
        • hash9a303af7bb8ad6f75bcf28c95951a1c8
        • created2016-11-22 14:15:23
        • updated2018-01-23 08:16:48
        • modelMenu
        • foreign_key65
        • titleData Privacy
        • description
        • author
        • tw_creator
        • fb_author
        • robots3
        • ImageMedia(empty)
      • Content(array)
        • 0(array)
          • id150
          • hash9eb6fb83cb5fc40b1f6fa42113386bef
          • created2018-10-01 11:10:20
          • updated2018-10-01 11:10:20
          • menu_id65
          • position1
          • typearticle
          • statusactive
          • titleData Privacy
          • layoutcol12
          • language_id2
          • article_content<p>This Data Protection Notice (“Notice”) sets out the basis which [<strong>SAS Asia Bar Systems Pte. Ltd.</strong>] (“we”, “us”, or “our”) may collect, use, disclose or otherwise process personal data of our customers in accordance with the Personal Data Protection Act (“PDPA”). This Notice applies to personal data in our possession or under our control, including personal data in the possession of organisations which we have engaged to collect, use, disclose or process personal data for our purposes.</p> <p><u><strong>PERSONAL DATA</strong></u></p> <p>1. As used in this Notice: “customer” means an individual who (a) has contacted us through any means to find out more about any goods or services we provide, or (b) may, or has, entered into a contract with us for the supply of any goods or services by us; and “personal data” means data, whether true or not, about a customer who can be identified: (a) from that data; or (b) from that data and other information to which we have or are likely to have access.</p> <p>2. Depending on the nature of your interaction with us, some examples of personal data which we may collect from you include your name and identification information such as your NRIC number, contact information such as your address, email address or telephone number, nationality, gender, date of birth, marital status, photographs and other audio-visual information, employment information and financial information such as credit card numbers, debit card numbers or bank account information.</p> <p>3. Other terms used in this Notice shall have the meanings given to them in the PDPA (where the context so permits).</p> <p><u><strong>COLLECTION, USE AND DISCLOSURE OF PERSONAL DATA</strong></u></p> <p>4. We generally do not collect your personal data unless</p> <p>(a) it is provided to us voluntarily by you directly or via a third party who has been duly authorised by you to disclose your personal data to us (your “authorised representative”) after (i) you (or your authorised representative) have been notified of the purposes for which the data is collected, and (ii) you (or your authorised representative) have provided written consent to the collection and usage of your personal data for those purposes, or</p> <p>(b) collection and use of personal data without consent is permitted or required by the PDPA or other laws. We shall seek your consent before collecting any additional personal data and before using your personal data for a purpose which has not been notified to you (except where permitted or authorised by law).</p> <p>5. We may collect and use your personal data for any or all of the following purposes:</p> <p>(a) performing obligations in the course of or in connection with our provision of the goods and/or services requested by you;</p> <p>(b) verifying your identity;</p> <p>(c) responding to, handling, and processing queries, requests, applications, complaints, and feedback from you;</p> <p>(d) managing your relationship with us;</p> <p>(e) processing payment or credit transactions;</p> <p>(f) sending your marketing information about our goods or services including notifying you of our marketing events, initiatives and promotions, lucky draws, membership and rewards schemes and other promotions;</p> <p>(g) complying with any applicable laws, regulations, codes of practice, guidelines, or rules, or to assist in law enforcement and investigations conducted by any governmental and/or regulatory authority;</p> <p>(h) any other purposes for which you have provided the information;</p> <p>(i) transmitting to any unaffiliated third parties including our third party service providers and agents, and relevant governmental and/or regulatory authorities, whether in Singapore or abroad, for the aforementioned purposes; and</p> <p>(j) any other incidental business purposes related to or in connection with the above.</p> <p>6. We may disclose your personal data:</p> <p>(a) where such disclosure is required for performing obligations in the course of or in connection with our provision of the goods or services requested by you; or</p> <p>(b) to third party service providers, agents and other organisations we have engaged to perform any of the functions listed in clause 5 above for us.</p> <p>7. The purposes listed in the above clauses may continue to apply even in situations where your relationship with us (for example, pursuant to a contract) has been terminated or altered in any way, for a reasonable period thereafter (including, where applicable, a period to enable us to enforce our rights under any contract with you).</p> <p><u><strong>WITHDRAWING YOUR CONSENT </strong></u></p> <p>8. The consent that you provide for the collection, use and disclosure of your personal data will remain valid until such time it is being withdrawn by you in writing. You may withdraw consent and request us to stop using and/or disclosing your personal data for any or all of the purposes listed above by submitting your request in writing or via email to our Data Protection Officer at the contact details provided below.</p> <p>9. Upon receipt of your written request to withdraw your consent, we may require reasonable time (depending on the complexity of the request and its impact on our relationship with you) for your request to be processed and for us to notify you of the consequences of us acceding to the same, including any legal consequences which may affect your rights and liabilities to us. In general, we shall seek to process your request within ten (10) business days of receiving it.</p> <p>10. Whilst we respect your decision to withdraw your consent, please note that depending on the nature and scope of your request, we may not be in a position to continue providing our goodsor services to you and we shall, in such circumstances, notify you before completing the processing of your request. Should you decide to cancel your withdrawal of consent, please inform us in writing in the manner described in clause 8 above.</p> <p>11. Please note that withdrawing consent does not affect our right to continue to collect, use and disclose personal data where such collection, use and disclose without consent is permitted or required under applicable laws.</p> <p><u><strong>ACCESS TO AND CORRECTION OF PERSONAL DATA </strong></u></p> <p>12. If you wish to make (a) an access request for access to a copy of the personal data which we hold about you or information about the ways in which we use or disclose your personal data, or (b) a correction request to correct or update any of your personal data which we hold about you, you may submit your request in writing or via email to our Data Protection Officer at the contact details provided below.</p> <p>13. Please note that a reasonable fee may be charged for an access request. If so, we will inform you of the fee before processing your request.</p> <p>14. We will respond to your request as soon as reasonably possible. Should we not be able to respond to your request within thirty (30) days after receiving your request, we will inform you in writing within thirty (30) days of the time by which we will be able to respond to your request. If we are unable to provide you with any personal data or to make a correction requested by you, we shall generally inform you of the reasons why we are unable to do so (except where we are not required to do so under the PDPA).</p> <p><strong><u>PROTECTION OF PERSONAL DATA</u></strong></p> <p>15. To safeguard your personal data from unauthorised access, collection, use, disclosure, copying, modification, disposal or similar risks, we have introduced appropriate administrative, physical and technical measures such as up-to-date antivirus protection, encryption and the use of privacy filters to secure all storage and transmission of personal data by us, and disclosing personal data both internally and to our authorised third party service providers and agents only on a need-to-know basis.</p> <p>16. You should be aware, however, that no method of transmission over the Internet or method of electronic storage is completely secure. While security cannot be guaranteed, we strive to protect the security of your information and are constantly reviewing and enhancing our information security measures.</p> <p><u><strong>ACCURACY OF PERSONAL DATA</strong></u></p> <p>17. We generally rely on personal data provided by you (or your authorised representative). In order to ensure that your personal data is current, complete and accurate, please update us if there are changes to your personal data by informing our Data Protection Officer in writing or via email at the contact details provided below.</p> <p><u><strong>RETENTION OF PERSONAL DATA</strong></u></p> <p>18. We may retain your personal data for as long as it is necessary to fulfil the purpose for which it was collected, or as required or permitted by applicable laws.</p> <p>19. We will cease to retain your personal data, or remove the means by which the data can be associated with you, as soon as it is reasonable to assume that such retention no longer serves the purpose for which the personal data was collected, and is no longer necessary for legal or business purposes.</p> <p><u><strong>TRANSFERS OF PERSONAL DATA OUTSIDE OF SINGAPORE </strong></u></p> <p>20. We generally do not transfer your personal data to countries outside of Singapore. However, if we do so, we will obtain your consent for the transfer to be made and we will take steps to ensure that your personal data continues to receive a standard of protection that is at least comparable to that provided under the PDPA.</p> <p><u><strong>DATA PROTECTION OFFICER </strong></u></p> <p>21. You may contact us if you have any enquiries or feedback on our personal data protection policies and procedures, or if you wish to make any request.</p> <p><u><strong>EFFECT OF NOTICE AND CHANGES TO NOTICE </strong></u></p> <p>22. This Notice applies in conjunction with any other notices, contractual clauses and consent clauses that apply in relation to the collection, use and disclosure of your personal data by us.</p> <p>23. We may revise this Notice from time to time without any prior notice. You may determine if any such revision has taken place by referring to the date on which this Notice was last updated. Your continued use of our services constitutes your acknowledgement and acceptance of such changes.</p> <p> </p> <p>Effective date : [1st October 2018]</p> <p>Last updated :  [1st October 2018]</p>
          • contact_content(null)
          • contact_email(null)
          • contact_success(null)
          • contact_error(null)
          • iframe_url(null)
          • iframe_width(null)
          • iframe_height(null)
          • release(null)
          • hide(null)
          • gmap_lat(null)
          • gmap_long(null)
          • gmap_zoom(null)
          • gmap_type(null)
          • gmap_marker(null)
          • video_type(null)
          • video_url(null)
          • developer_template_code(null)
          • teaser_menu_id(null)
          • teaser_external_url(null)
          • teaser_external_target(null)
          • developer_template_css(null)
          • developer_template_js(null)
          • gmap
          • published1
          • Route(array)
            • id254
            • hashc199b1a378cf759ab71354af92aaa0ac
            • created2018-10-01 11:10:20
            • updated2018-10-01 11:10:20
            • modelContent
            • foreign_key150
            • base/home/data-privacy/
            • aliasdata-privacy
            • controllerFrontendContents.FrontendContents
            • actionarticle
            • parent_id173
            • lft249
            • rght250
            • route/home/data-privacy/data-privacy
    • $request->data(empty)
    • $this->validationErrors(array)
      • Route(empty)
      • MountPoint(empty)
      • Redirect(empty)
      • Language(empty)
      • Menu(empty)
      • Parent(empty)
      • HeaderImagesMedia(empty)
      • MediaEntity(empty)
      • LogoMedia(empty)
      • Seo(empty)
      • ImageMedia(empty)
      • Teaser(empty)
      • Item(empty)
      • Content(empty)
      • ArticleContentMedia(empty)
      • GalleryMedia(empty)
      • FileUpload(empty)
      • ItemsMenu(empty)
      • FlagUpload(empty)
    • Loaded Helpers(array)
      • 0Html
      • 1Tree
      • 2Upload
      • 3Media
      • 4Route
      • 5Bs3Html
      • 6Form
      • 7SocialMedia
      • 8GMap
      • 9Embed
      • 10Layout
      • 11CookieBar
      • 12Number
      • 13SimpleGraph
      • 14DebugTimer
      • 15Toolbar
      • 16Session
      • 17Js
      • 18HtmlToolbar
    ====
  • Environment
    +

    App Constants

    Constant Value
    MH
    MH_IP
    BACKEND_APP_DIR contrance
    UPLOADS_APP /var/www/vhosts/sas-asia.sg/httpdocs/contrance/
    UPLOAD_TMP_DIR tmp/uploads/

    CakePHP Constants

    Constant Value
    APP /var/www/vhosts/sas-asia.sg/httpdocs/
    APP_DIR httpdocs
    APPLIBS /var/www/vhosts/sas-asia.sg/httpdocs/Lib/
    CACHE /var/www/vhosts/sas-asia.sg/httpdocs/tmp/cache/
    CAKE /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/Cake/
    CAKE_CORE_INCLUDE_PATH /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib
    CORE_PATH /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/
    CAKE_VERSION 2.9.0
    CSS /var/www/vhosts/sas-asia.sg/httpdocs/webroot/css/
    CSS_URL css/
    DS /
    FULL_BASE_URL https://www.sas-asia.sg
    IMAGES /var/www/vhosts/sas-asia.sg/httpdocs/webroot/img/
    IMAGES_URL img/
    JS /var/www/vhosts/sas-asia.sg/httpdocs/webroot/js/
    JS_URL js/
    LOGS /var/www/vhosts/sas-asia.sg/httpdocs/tmp/logs/
    ROOT /var/www/vhosts/sas-asia.sg
    TESTS /var/www/vhosts/sas-asia.sg/httpdocs/Test/
    TMP /var/www/vhosts/sas-asia.sg/httpdocs/tmp/
    VENDORS /var/www/vhosts/sas-asia.sg/vendors/
    WEBROOT_DIR webroot
    WWW_ROOT /var/www/vhosts/sas-asia.sg/httpdocs/webroot/

    PHP Environment

    Environment Variable Value
    Php Version 5.5.38
    User u020939593499
    Home /var/www/vhosts/sas-asia.sg
    Fcgi Role RESPONDER
    Redirect Redirect Unique Id YsWrvzw7Kce3t-Jt8nny@QAAAQk
    Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Redirect Redirect Https on
    Redirect Redirect Status 200
    Redirect Unique Id YsWrvzw7Kce3t-Jt8nny@QAAAQk
    Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Redirect Https on
    Redirect Status 200
    Unique Id YsWrvzw7Kce3t-Jt8nny@QAAAQk
    Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Https on
    Proxy-nokeepalive 1
    Http Host www.sas-asia.sg
    Http X Real Ip 3.236.221.156
    Http X Accel Internal /internal-nginx-static-location
    Http Connection close
    Http User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
    Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Http Accept Language en-US,en;q=0.5
    Http If Modified Since Thu, 20 Jan 2022 16:21:17 GMT
    Http Accept Encoding br,gzip
    Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
    Server Signature
    Server Software Apache
    Server Name www.sas-asia.sg
    Server Addr 85.236.63.133
    Server Port 443
    Remote Addr 3.236.221.156
    Document Root /var/www/vhosts/sas-asia.sg/httpdocs
    Request Scheme https
    Context Prefix
    Context Document Root /var/www/vhosts/sas-asia.sg/httpdocs
    Server Admin root@localhost
    Script Filename /var/www/vhosts/sas-asia.sg/httpdocs/webroot/index.php
    Remote Port 54190
    Redirect Url /webroot/home/data-privacy
    Gateway Interface CGI/1.1
    Server Protocol HTTP/1.0
    Request Method GET
    Query String
    Request Uri /home/data-privacy
    Script Name /webroot/index.php
    Php Self /webroot/index.php
    Request Time Float 1657121727.1258
    Request Time 1657121727
    ====
  • Include
    +

    Included Files

    Include Paths

    • 1/opt/plesk/php/5.5/share/pear
    • 2-> /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/Cake/

    Included Files

    • core(empty)
    • app(array)
      • Behavior(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
      • Cache(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
      • Component(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
      • Config(array)
        • 0APP/Config/core.php
        • 1APP/Config/bootstrap.php
        • 2APP/Config/routes.php
        • 3APP/Config/database.php
        • 4APP/contrance/Config/database.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
      • Controller(array)
        • 0APP/Controller/AppController.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
      • Datasource(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
      • Error(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
      • I18n(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
      • Log(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
      • Model(array)
        • 0APP/Model/AppModel.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
      • Network(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
      • Other(array)
        • 0APP/webroot/index.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/basics.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
        • 6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
        • 7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
        • 8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
        • 9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
      • Routing(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
        • 5APP/Lib/Routing/Route/AliasRoute.php
        • 6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
      • Utility(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
      • View(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
    • plugins(array)
      • Audit(array)
        • Behavior(array)
          • 0Audit/Model/Behavior/AuditableBehavior.php
      • BaseData(array)
        • Model(array)
          • 0BaseData/Model/BaseDataAppModel.php
        • Behavior(array)
          • 0BaseData/Model/Behavior/AdvancedContainableBehavior.php
          • 1BaseData/Model/Behavior/EssentialBehavior.php
          • 2BaseData/Model/Behavior/SearchBehavior.php
          • 3BaseData/Model/Behavior/HashBehavior.php
          • 4BaseData/Model/Behavior/DateTimeBehavior.php
          • 5BaseData/Model/Behavior/NullableBehavior.php
          • 6BaseData/Model/Behavior/EnumBehavior.php
          • 7BaseData/Model/Behavior/SwitchableBehavior.php
          • 8BaseData/Model/Behavior/BitMaskBehavior.php
          • 9BaseData/Model/Behavior/LayoutBehavior.php
          • 10BaseData/Model/Behavior/HabtmBehavior.php
          • 11BaseData/Model/Behavior/ListBehavior.php
      • BaseTree(array)
        • Model(array)
          • 0BaseTree/Model/BaseTreeAppModel.php
      • Contents(array)
        • Model(array)
          • 0Contents/Model/Content.php
          • 1Contents/Model/ContentsAppModel.php
      • DebugKit(array)
        • Component(array)
          • 0DebugKit/Controller/Component/ToolbarComponent.php
        • Plugin(array)
          • 0DebugKit/Lib/DebugMemory.php
          • 1DebugKit/Lib/Panel/HistoryPanel.php
          • 2DebugKit/Lib/DebugPanel.php
          • 3DebugKit/Lib/Panel/SessionPanel.php
          • 4DebugKit/Lib/Panel/RequestPanel.php
          • 5DebugKit/Lib/Panel/SqlLogPanel.php
          • 6DebugKit/Lib/Panel/TimerPanel.php
          • 7DebugKit/Lib/Panel/LogPanel.php
          • 8DebugKit/Lib/Log/Engine/DebugKitLog.php
          • 9DebugKit/Lib/Panel/VariablesPanel.php
          • 10DebugKit/Lib/Panel/EnvironmentPanel.php
          • 11DebugKit/Lib/Panel/IncludePanel.php
          • 12DebugKit/Lib/DebugTimer.php
      • FrontendMenus(array)
        • Controller(array)
          • 0FrontendMenus/Controller/FrontendMenusController.php
          • 1FrontendMenus/Controller/FrontendMenusAppController.php
      • FrontendUploads(array)
        • Config(array)
          • 0FrontendUploads/Config/routes.php
      • FrontendUtils(array)
        • Config(array)
          • 0FrontendUtils/Config/bootstrap.php
          • 1FrontendUtils/Config/routes.php
        • Plugin(array)
          • 0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
      • Items(array)
        • Model(array)
          • 0Items/Model/Item.php
          • 1Items/Model/ItemsAppModel.php
      • Languages(array)
        • Behavior(array)
          • 0Languages/Model/Behavior/LanguageBehavior.php
        • Model(array)
          • 0Languages/Model/Language.php
          • 1Languages/Model/LanguagesAppModel.php
      • Media(array)
        • Behavior(array)
          • 0Media/Model/Behavior/MediaBehavior.php
        • Model(array)
          • 0Media/Model/Media.php
          • 1Media/Model/MediaAppModel.php
          • 2Media/Model/MediaEntity.php
      • Menus(array)
        • Model(array)
          • 0Menus/Model/Menu.php
          • 1Menus/Model/MenusAppModel.php
      • MountPoints(array)
        • Model(array)
          • 0MountPoints/Model/MountPoint.php
          • 1MountPoints/Model/MountPointsAppModel.php
      • Outdooractive(array)
        • Behavior(array)
          • 0Outdooractive/Model/Behavior/OAGeoBehavior.php
      • Pdf(array)
        • Config(array)
          • 0Pdf/Config/bootstrap.php
          • 1Pdf/Config/routes.php
        • Plugin(array)
          • 0Pdf/Vendor/autoload.php
          • 1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
          • 2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
          • 3Pdf/Vendor/autoloader/Autoloader.php
      • Routes(array)
        • Model(array)
          • 0Routes/Model/Route.php
          • 1Routes/Model/RoutesAppModel.php
          • 2Routes/Model/Redirect.php
        • Behavior(array)
          • 0Routes/Model/Behavior/RedirectBehavior.php
          • 1Routes/Model/Behavior/RoutableBehavior.php
      • Seo(array)
        • Behavior(array)
          • 0Seo/Model/Behavior/SeoBehavior.php
        • Model(array)
          • 0Seo/Model/Seo.php
          • 1Seo/Model/SeoAppModel.php
      • Tags(array)
        • Behavior(array)
          • 0Tags/Model/Behavior/TaggableBehavior.php
      • Teasers(array)
        • Behavior(array)
          • 0Teasers/Model/Behavior/TeaserBehavior.php
        • Model(array)
          • 0Teasers/Model/Teaser.php
          • 1Teasers/Model/TeasersAppModel.php
      • Uploads(array)
        • Config(array)
          • 0Uploads/Config/bootstrap.php
        • Behavior(array)
          • 0Uploads/Model/Behavior/UploadBehavior.php
          • 1Uploads/Model/Behavior/TransformationBehavior.php
        • Model(array)
          • 0Uploads/Model/Upload.php
          • 1Uploads/Model/UploadsAppModel.php
    ====