Menu
type | calls | time (ms) | time (%) |
---|---|---|---|
Database (Doctrine) | 42 | 0.03 | 0 |
SET NAMES 'utf8mb4'
SELECT d.id AS d__id, d.name AS d__name, d.type AS d__type, d.params AS d__params, d.group_name AS d__group_name, d.credentials AS d__credentials, d2.id AS d2__id, d2.description AS d2__description, d2.value AS d2__value, d2.default_value AS d2__default_value, d2.lang AS d2__lang FROM dm_setting d LEFT JOIN dm_setting_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.name = '_header')
SELECT d.id AS d__id, d.ip AS d__ip, d.name AS d__name, d.ts AS d__ts, d.page AS d__page, d.country AS d__country, d.country_code AS d__country_code, d.city AS d__city, d.browser AS d__browser, d.dm_user AS d__dm_user FROM dm_who_is_online d WHERE (d.ip = '18.188.227.192' AND d.name = 'Guest')
INSERT INTO dm_who_is_online (ip, name, browser, ts, page) VALUES ('18.188.227.192', 'Guest', 'unknown', '1732493294', 'https://telltrail.com/dev.php/lost-and-found')
DELETE FROM dm_who_is_online WHERE (ts < '1732492995')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d INNER JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d2.slug = 'lost-and-found')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.dm_layout_id AS d__dm_layout_id, d2.id AS d2__id, d2.name AS d2__name, d2.template AS d2__template, d2.css_class AS d2__css_class FROM dm_page_view d LEFT JOIN dm_layout d2 ON d.dm_layout_id = d2.id WHERE (d.module = 'main' AND d.action = 'lostFound')
SELECT d.id AS d__id, d.dm_layout_id AS d__dm_layout_id, d.type AS d__type, d2.id AS d2__id, d2.width AS d2__width, d2.css_class AS d2__css_class, d3.id AS d3__id, d3.module AS d3__module, d3.action AS d3__action, d3.css_class AS d3__css_class, d4.id AS d4__id, d4.lang AS d4__lang, d4.value AS d4__value FROM dm_area d LEFT JOIN dm_zone d2 ON d.id = d2.dm_area_id LEFT JOIN dm_widget d3 ON d2.id = d3.dm_zone_id LEFT JOIN dm_widget_translation d4 ON d3.id = d4.id AND ((d4.lang = 'en' OR d4.lang = 'en')) WHERE (d.dm_layout_id = '30' OR d.dm_page_view_id = '25') ORDER BY d2.position asc, d3.position asc
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d INNER JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d2.slug = '')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'root')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'register')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'dmUser' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'classifiedCategories' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'directoryList')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'socialEvent' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'blog' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'news' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'job' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'poll' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'forumCategory' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'adviceList')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'lostFound')
SELECT d.id AS d__id, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.lft < '1702' AND d.rgt > '1715') ORDER BY d.lft asc
SELECT COUNT(*) AS num_results FROM tt_lost t WHERE (t.deleted_at IS NULL AND t.reunited_at IS NOT NULL) AND t.reunited_at > '2024-11-18 00:08:15'
SELECT COUNT(*) AS num_results FROM tt_found t WHERE (t.deleted_at IS NULL AND t.reunited_at IS NOT NULL) AND t.reunited_at > '2024-11-18 00:08:15'
SELECT COUNT(*) AS num_results FROM tt_lost t WHERE (t.deleted_at IS NULL AND t.reunited_at IS NULL) AND t.lifecycle_state = 'published'
SELECT COUNT(*) AS num_results FROM tt_found t WHERE (t.deleted_at IS NULL AND t.reunited_at IS NULL) AND t.lifecycle_state = 'published'
SELECT t.id AS t__id, t.title AS t__title, t.extract AS t__extract, t.body AS t__body, t.lost_cat AS t__lost_cat, t.reunited_at AS t__reunited_at, t.police_informed AS t__police_informed, t.comments_count AS t__comments_count, t.created_by AS t__created_by, t.updated_by AS t__updated_by, t.dm_taggable_denormalized_tags_cache_field AS t__dm_taggable_denormalized_tags_cache_field, t.deleted_at AS t__deleted_at, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.location_address AS t__location_address, t.location_latitude AS t__location_latitude, t.location_longitude AS t__location_longitude, t.location_type AS t__location_type, t.location_street_number AS t__location_street_number, t.location_route AS t__location_route, t.location_locality AS t__location_locality, t.location_country AS t__location_country, t.location_postal_code AS t__location_postal_code, t.location_postal_code_prefix AS t__location_postal_code_prefix, t.location_administrative_area_level_1 AS t__location_administrative_area_level_1, t.location_administrative_area_level_2 AS t__location_administrative_area_level_2, t.slug AS t__slug, t.gold_members AS t__gold_members, t.privacy AS t__privacy, t.content_class_id AS t__content_class_id, t.lifecycle_state AS t__lifecycle_state, t.expiration_date AS t__expiration_date, t.date_published AS t__date_published, t.views AS t__views, t.locality_country AS t__locality_country, t.locality_region AS t__locality_region, t.locality_city AS t__locality_city, t.locality_street AS t__locality_street, t.circulation AS t__circulation, t.version AS t__version, t.followers_count AS t__followers_count FROM tt_lost t WHERE (t.privacy = '40' AND (t.circulation = '0' OR t.circulation = '10') AND (t.lifecycle_state IN ('published') AND (t.expiration_date IS NULL OR t.expiration_date > NOW())) AND t.deleted_at IS NULL) ORDER BY t.date_published DESC LIMIT 12
SELECT t.id AS t__id, t.title AS t__title, t.extract AS t__extract, t.body AS t__body, t.found_cat AS t__found_cat, t.reunited_at AS t__reunited_at, t.police_informed AS t__police_informed, t.comments_count AS t__comments_count, t.created_by AS t__created_by, t.updated_by AS t__updated_by, t.dm_taggable_denormalized_tags_cache_field AS t__dm_taggable_denormalized_tags_cache_field, t.deleted_at AS t__deleted_at, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.location_address AS t__location_address, t.location_latitude AS t__location_latitude, t.location_longitude AS t__location_longitude, t.location_type AS t__location_type, t.location_street_number AS t__location_street_number, t.location_route AS t__location_route, t.location_locality AS t__location_locality, t.location_country AS t__location_country, t.location_postal_code AS t__location_postal_code, t.location_postal_code_prefix AS t__location_postal_code_prefix, t.location_administrative_area_level_1 AS t__location_administrative_area_level_1, t.location_administrative_area_level_2 AS t__location_administrative_area_level_2, t.slug AS t__slug, t.gold_members AS t__gold_members, t.privacy AS t__privacy, t.content_class_id AS t__content_class_id, t.lifecycle_state AS t__lifecycle_state, t.expiration_date AS t__expiration_date, t.date_published AS t__date_published, t.views AS t__views, t.locality_country AS t__locality_country, t.locality_region AS t__locality_region, t.locality_city AS t__locality_city, t.locality_street AS t__locality_street, t.circulation AS t__circulation, t.version AS t__version, t.followers_count AS t__followers_count FROM tt_found t WHERE (t.privacy = '40' AND (t.circulation = '0' OR t.circulation = '10') AND (t.lifecycle_state IN ('published') AND (t.expiration_date IS NULL OR t.expiration_date > NOW())) AND t.deleted_at IS NULL) ORDER BY t.date_published DESC LIMIT 12
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'ttLostList')
SELECT l.id AS l__id, l.title AS l__title, l.description AS l__description, l.is_active AS l__is_active, l.type AS l__type, l.deleted_at AS l__deleted_at, l.position AS l__position, l.slug AS l__slug FROM lost_found_cat l WHERE (l.id = '1')
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '7'
SELECT t.id AS t__id, t.dm_media_id AS t__dm_media_id, t.dm_record_id AS t__dm_record_id, t.position AS t__position, t.name AS t__name, t.legend AS t__legend, d.id AS d__id, d.dm_media_folder_id AS d__dm_media_folder_id, d.file AS d__file, d.legend AS d__legend, d.mime AS d__mime, d.size AS d__size, d.dimensions AS d__dimensions, d.name AS d__name, d.validated AS d__validated, d.active AS d__active, d.uploader AS d__uploader, d.imagetypecategory AS d__imagetypecategory, d.imageindexinternal AS d__imageindexinternal, d.imfingerprint AS d__imfingerprint, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.created_by AS d__created_by, d.updated_by AS d__updated_by, d2.id AS d2__id, d2.rel_path AS d2__rel_path, d2.lft AS d2__lft, d2.rgt AS d2__rgt, d2.level AS d2__level FROM tt_lost_dm_media t LEFT JOIN dm_media d ON t.dm_media_id = d.id LEFT JOIN dm_media_folder d2 ON d.dm_media_folder_id = d2.id WHERE (t.dm_record_id = '7') ORDER BY t.position ASC
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'welcomeConsumer')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'aboutTelltrail')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'contactUs')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'faqs')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'termsAndConditions')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'privacyAndCookies')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'fairUsage')
SELECT d.id AS d__id, d.name AS d__name, d.type AS d__type, d.params AS d__params, d.group_name AS d__group_name, d.credentials AS d__credentials, d2.id AS d2__id, d2.description AS d2__description, d2.value AS d2__value, d2.default_value AS d2__default_value, d2.lang AS d2__lang FROM dm_setting d LEFT JOIN dm_setting_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.name = 'base_urls')
UPDATE dm_setting_translation SET value = '{"front-prod":"https:\\/\\/www.telltrail.com\\/index.php","admin-prod":"https:\\/\\/www.telltrail.com\\/admin.php","front-dev":"https:\\/\\/telltrail.com\\/dev.php","admin-dev":"https:\\/\\/www.telltrail.com\\/admin_dev.php"}' WHERE id = '10' AND lang = 'en'