I can see no readings but British Gas can ... and they've been NO help
After a LOOOOOOONG wait on the phone I got to speak to someone but they only suggested switching off/on and moving the monitor closer to the actual meter.
Now the unit's been left off for days and is now on an extension and sitting next to the meter but it still won't connect
Do I really have to buy my own replacement???
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Database (Doctrine) | 54 | 0.04 | 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.117.71.239' AND d.name = 'Guest')
INSERT INTO dm_who_is_online (ip, name, browser, ts, page) VALUES ('18.117.71.239', 'Guest', 'unknown', '1732260753', 'https://telltrail.com/dev.php/advice/practical/my-british-gas-smart-meter-monitor-won-t-connect-to-my-smart-meter')
DELETE FROM dm_who_is_online WHERE (ts < '1732260453')
SELECT a.id AS a__id, a.title AS a__title, a.extract AS a__extract, a.body AS a__body, a.price AS a__price, a.advice_cat AS a__advice_cat, a.poll_id AS a__poll_id, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.comments_count AS a__comments_count, a.dm_taggable_denormalized_tags_cache_field AS a__dm_taggable_denormalized_tags_cache_field, a.deleted_at AS a__deleted_at, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.gold_members AS a__gold_members, a.privacy AS a__privacy, a.content_class_id AS a__content_class_id, a.locality_country AS a__locality_country, a.locality_region AS a__locality_region, a.locality_city AS a__locality_city, a.locality_street AS a__locality_street, a.circulation AS a__circulation, a.lifecycle_state AS a__lifecycle_state, a.expiration_date AS a__expiration_date, a.date_published AS a__date_published, a.views AS a__views, a.slug AS a__slug, a.version AS a__version, a.followers_count AS a__followers_count FROM advice a WHERE (a.slug = 'my-british-gas-smart-meter-monitor-won-t-connect-to-my-smart-meter') LIMIT 1
SELECT a.id AS a__id, a.title AS a__title, a.description AS a__description, a.is_active AS a__is_active, a.deleted_at AS a__deleted_at, a.slug AS a__slug, a.root_id AS a__root_id, a.lft AS a__lft, a.rgt AS a__rgt, a.level AS a__level FROM advice_cat a WHERE (a.slug = 'practical') LIMIT 1
SELECT a.id AS a__id, a.title AS a__title, a.description AS a__description, a.is_active AS a__is_active, a.deleted_at AS a__deleted_at, a.slug AS a__slug, a.root_id AS a__root_id, a.lft AS a__lft, a.rgt AS a__rgt, a.level AS a__level FROM advice_cat a WHERE ((a.lft < '1' AND a.rgt > '2') AND a.root_id = '1') ORDER BY a.lft asc
SELECT a.id AS a__id, a.title AS a__title, a.description AS a__description, a.is_active AS a__is_active, a.deleted_at AS a__deleted_at, a.slug AS a__slug, a.root_id AS a__root_id, a.lft AS a__lft, a.rgt AS a__rgt, a.level AS a__level FROM advice_cat a WHERE (a.id = '1')
SELECT a.id AS a__id, a.title AS a__title, a.description AS a__description, a.is_active AS a__is_active, a.deleted_at AS a__deleted_at, a.slug AS a__slug, a.root_id AS a__root_id, a.lft AS a__lft, a.rgt AS a__rgt, a.level AS a__level FROM advice_cat a WHERE ((a.lft < '1' AND a.rgt > '2') AND a.root_id = '1') ORDER BY a.lft 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 FROM dm_page d WHERE (d.module = 'main' AND d.action = 'adviceShow') LIMIT 1
SELECT d.id AS d__id, d.slug AS d__slug, d.name AS d__name, d.title AS d__title, d.h1 AS d__h1, d.description AS d__description, d.keywords AS d__keywords, d.auto_mod AS d__auto_mod, d.is_active AS d__is_active, d.is_secure AS d__is_secure, d.is_indexable AS d__is_indexable, d.lang AS d__lang FROM dm_page_translation d WHERE (d.id IN ('2246'))
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.117.71.239' AND d.name = 'Guest')
UPDATE dm_who_is_online SET ts = '1732260754' WHERE id = '11793592'
DELETE FROM dm_who_is_online WHERE (ts < '1732260454')
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 = 'adviceShow')
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 = '18' OR d.dm_page_view_id = '150') ORDER BY d2.position asc, d3.position asc
SELECT d.id AS d__id, d.username AS d__username, d.email AS d__email, d.algorithm AS d__algorithm, d.salt AS d__salt, d.password AS d__password, d.is_active AS d__is_active, d.is_super_admin AS d__is_super_admin, d.last_login AS d__last_login, d.forgot_password_code AS d__forgot_password_code, d.sca_address AS d__sca_address, d.notifications_read AS d__notifications_read, d.notifications_emailed AS d__notifications_emailed, d.points AS d__points, d.referrer AS d__referrer, d.image_folder AS d__image_folder, d.firstname AS d__firstname, d.lastname AS d__lastname, d.dob AS d__dob, d.gender AS d__gender, d.headline AS d__headline, d.description AS d__description, d.about AS d__about, d.hobbies AS d__hobbies, d.education AS d__education, d.employment AS d__employment, d.ethnicity AS d__ethnicity, d.smoker AS d__smoker, d.alcohol AS d__alcohol, d.build AS d__build, d.religion AS d__religion, d.marital_status AS d__marital_status, d.dependent_children AS d__dependent_children, d.want_children AS d__want_children, d.looking_for_min AS d__looking_for_min, d.looking_for_max AS d__looking_for_max, d.privacy_profile AS d__privacy_profile, d.privacy_profile_share_online AS d__privacy_profile_share_online, d.privacy_profile_share_age AS d__privacy_profile_share_age, d.privacy_profile_share_cover AS d__privacy_profile_share_cover, d.privacy_search_realname AS d__privacy_search_realname, d.privacy_search_email AS d__privacy_search_email, d.privacy_search_hobbies AS d__privacy_search_hobbies, d.privacy_accept_messages AS d__privacy_accept_messages, d.preferences_timeformat AS d__preferences_timeformat, d.currency AS d__currency, d.country AS d__country, d.notifications AS d__notifications, d.telltrail_update AS d__telltrail_update, d.coins AS d__coins, d.expire_date AS d__expire_date, d.rating AS d__rating, d.warning AS d__warning, d.suspended AS d__suspended, d.suspended_reason AS d__suspended_reason, d.membership AS d__membership, d.language AS d__language, d.referral AS d__referral, d.email_backup AS d__email_backup, d.security_question AS d__security_question, d.security_response AS d__security_response, d.phone AS d__phone, d.mobile AS d__mobile, d.notification_interval AS d__notification_interval, d.region AS d__region, d.town_city AS d__town_city, d.postcode AS d__postcode, d.street AS d__street, d.registration_code AS d__registration_code, d.password_changed AS d__password_changed, d.security_question_changed AS d__security_question_changed, d.is_in_quarantine AS d__is_in_quarantine, d.quarantine_start AS d__quarantine_start, d.quarantine_end AS d__quarantine_end, d.quarantine_time AS d__quarantine_time, d.nb_views AS d__nb_views, d.is_completed_activation AS d__is_completed_activation, d.last_activation_reminder_date AS d__last_activation_reminder_date, d.invitation_link_welcome_text AS d__invitation_link_welcome_text, d.invitation_email_welcome_text AS d__invitation_email_welcome_text, d.location_address_valid AS d__location_address_valid, d.invitation_email_message_text AS d__invitation_email_message_text, d.invitation_email_shortlink_text AS d__invitation_email_shortlink_text, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.location_address AS d__location_address, d.location_latitude AS d__location_latitude, d.location_longitude AS d__location_longitude, d.location_type AS d__location_type, d.location_street_number AS d__location_street_number, d.location_route AS d__location_route, d.location_locality AS d__location_locality, d.location_country AS d__location_country, d.location_postal_code AS d__location_postal_code, d.location_postal_code_prefix AS d__location_postal_code_prefix, d.location_administrative_area_level_1 AS d__location_administrative_area_level_1, d.location_administrative_area_level_2 AS d__location_administrative_area_level_2, d.dm_taggable_denormalized_tags_cache_field AS d__dm_taggable_denormalized_tags_cache_field, d.comments_count AS d__comments_count, d.followers_count AS d__followers_count, d.slug AS d__slug FROM dm_user d WHERE (d.id = '474')
UPDATE advice SET views = views + 1 WHERE (id = '17')
SELECT COUNT(*) AS num_results FROM advice_dm_media a WHERE a.dm_record_id = '17'
SELECT a.id AS a__id, a.dm_media_id AS a__dm_media_id, a.dm_record_id AS a__dm_record_id, a.position AS a__position, a.name AS a__name, a.legend AS a__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 advice_dm_media a LEFT JOIN dm_media d ON a.dm_media_id = d.id LEFT JOIN dm_media_folder d2 ON d.dm_media_folder_id = d2.id WHERE (a.dm_record_id = '17') ORDER BY a.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 < '1719' AND d.rgt > '1720') ORDER BY d.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.deleted_at AS c__deleted_at, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, sc.id AS sc__id FROM advice_cat c INNER JOIN advice_cat sc ON sc.root_id = c.id WHERE sc.id = '1'
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 = 'adviceForm')
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 = 'manageContent')
SELECT a.id AS a__id, a.dm_media_id AS a__dm_media_id, a.dm_record_id AS a__dm_record_id, a.position AS a__position, a.name AS a__name, a.legend AS a__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 advice_dm_media a LEFT JOIN dm_media d ON a.dm_media_id = d.id LEFT JOIN dm_media_folder d2 ON d.dm_media_folder_id = d2.id WHERE (a.dm_record_id = '17') ORDER BY a.position ASC
SELECT a.id AS a__id, a.tt_content_record_id AS a__tt_content_record_id, a.body AS a__body, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.version AS a__version FROM advice_addendum a WHERE (a.tt_content_record_id IN ('17'))
SELECT d.id AS d__id, d.record_model AS d__record_model, d.record_id AS d__record_id, d.body AS d__body, d.is_active AS d__is_active, 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, d.deleted_at AS d__deleted_at, d.root_id AS d__root_id, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.username AS d2__username, d2.email AS d2__email, d2.algorithm AS d2__algorithm, d2.salt AS d2__salt, d2.password AS d2__password, d2.is_active AS d2__is_active, d2.is_super_admin AS d2__is_super_admin, d2.last_login AS d2__last_login, d2.forgot_password_code AS d2__forgot_password_code, d2.sca_address AS d2__sca_address, d2.notifications_read AS d2__notifications_read, d2.notifications_emailed AS d2__notifications_emailed, d2.points AS d2__points, d2.referrer AS d2__referrer, d2.image_folder AS d2__image_folder, d2.firstname AS d2__firstname, d2.lastname AS d2__lastname, d2.dob AS d2__dob, d2.gender AS d2__gender, d2.headline AS d2__headline, d2.description AS d2__description, d2.about AS d2__about, d2.hobbies AS d2__hobbies, d2.education AS d2__education, d2.employment AS d2__employment, d2.ethnicity AS d2__ethnicity, d2.smoker AS d2__smoker, d2.alcohol AS d2__alcohol, d2.build AS d2__build, d2.religion AS d2__religion, d2.marital_status AS d2__marital_status, d2.dependent_children AS d2__dependent_children, d2.want_children AS d2__want_children, d2.looking_for_min AS d2__looking_for_min, d2.looking_for_max AS d2__looking_for_max, d2.privacy_profile AS d2__privacy_profile, d2.privacy_profile_share_online AS d2__privacy_profile_share_online, d2.privacy_profile_share_age AS d2__privacy_profile_share_age, d2.privacy_profile_share_cover AS d2__privacy_profile_share_cover, d2.privacy_search_realname AS d2__privacy_search_realname, d2.privacy_search_email AS d2__privacy_search_email, d2.privacy_search_hobbies AS d2__privacy_search_hobbies, d2.privacy_accept_messages AS d2__privacy_accept_messages, d2.preferences_timeformat AS d2__preferences_timeformat, d2.currency AS d2__currency, d2.country AS d2__country, d2.notifications AS d2__notifications, d2.telltrail_update AS d2__telltrail_update, d2.coins AS d2__coins, d2.expire_date AS d2__expire_date, d2.rating AS d2__rating, d2.warning AS d2__warning, d2.suspended AS d2__suspended, d2.suspended_reason AS d2__suspended_reason, d2.membership AS d2__membership, d2.language AS d2__language, d2.referral AS d2__referral, d2.email_backup AS d2__email_backup, d2.security_question AS d2__security_question, d2.security_response AS d2__security_response, d2.phone AS d2__phone, d2.mobile AS d2__mobile, d2.notification_interval AS d2__notification_interval, d2.region AS d2__region, d2.town_city AS d2__town_city, d2.postcode AS d2__postcode, d2.street AS d2__street, d2.registration_code AS d2__registration_code, d2.password_changed AS d2__password_changed, d2.security_question_changed AS d2__security_question_changed, d2.is_in_quarantine AS d2__is_in_quarantine, d2.quarantine_start AS d2__quarantine_start, d2.quarantine_end AS d2__quarantine_end, d2.quarantine_time AS d2__quarantine_time, d2.nb_views AS d2__nb_views, d2.is_completed_activation AS d2__is_completed_activation, d2.last_activation_reminder_date AS d2__last_activation_reminder_date, d2.invitation_link_welcome_text AS d2__invitation_link_welcome_text, d2.invitation_email_welcome_text AS d2__invitation_email_welcome_text, d2.location_address_valid AS d2__location_address_valid, d2.invitation_email_message_text AS d2__invitation_email_message_text, d2.invitation_email_shortlink_text AS d2__invitation_email_shortlink_text, d2.created_at AS d2__created_at, d2.updated_at AS d2__updated_at, d2.location_address AS d2__location_address, d2.location_latitude AS d2__location_latitude, d2.location_longitude AS d2__location_longitude, d2.location_type AS d2__location_type, d2.location_street_number AS d2__location_street_number, d2.location_route AS d2__location_route, d2.location_locality AS d2__location_locality, d2.location_country AS d2__location_country, d2.location_postal_code AS d2__location_postal_code, d2.location_postal_code_prefix AS d2__location_postal_code_prefix, d2.location_administrative_area_level_1 AS d2__location_administrative_area_level_1, d2.location_administrative_area_level_2 AS d2__location_administrative_area_level_2, d2.dm_taggable_denormalized_tags_cache_field AS d2__dm_taggable_denormalized_tags_cache_field, d2.comments_count AS d2__comments_count, d2.followers_count AS d2__followers_count, d2.slug AS d2__slug FROM dm_comment d INNER JOIN dm_user d2 ON d.created_by = d2.id WHERE (d.record_id = '17' AND d.record_model = 'Advice' AND d.deleted_at IS NULL AND d.is_active = '1' AND d.lft = '1') ORDER BY d.created_at DESC
SELECT g.id AS g__id, g.name AS g__name, g.is_active AS g__is_active, g.position AS g__position, g.deleted_at AS g__deleted_at FROM gender g WHERE (g.id = '1')
SELECT a.id AS a__id, a.title AS a__title, a.description AS a__description, a.is_active AS a__is_active, a.deleted_at AS a__deleted_at, a.slug AS a__slug, a.root_id AS a__root_id, a.lft AS a__lft, a.rgt AS a__rgt, a.level AS a__level FROM advice_cat a WHERE ((a.lft < '1' AND a.rgt > '2') AND a.root_id = '1') ORDER BY a.lft 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'
logs
2763 ms
1181.6 MB
54
Comments