-
SET NAMES 'utf8mb4'
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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 = '3.22.42.25' AND d.name = 'Guest')
0.00s, "doctrine" connection
-
INSERT INTO dm_who_is_online (ip, name, browser, ts, page) VALUES ('3.22.42.25', 'Guest', 'unknown', '1734901071', 'https://dev.telltrail.com/dev.php?page=15')
0.00s, "doctrine" connection
-
DELETE FROM dm_who_is_online WHERE (ts < '1734900771')
0.03s, "doctrine" connection
-
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 = '')
0.00s, "doctrine" connection
-
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 = 'root')
0.00s, "doctrine" connection
-
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 = '1') ORDER BY d2.position asc, d3.position asc
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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 < '1' AND d.rgt > '2964') ORDER BY d.lft asc
0.00s, "doctrine" connection
-
SELECT a.id AS a__id, a.uid AS a__uid, a.guid AS a__guid, a.model AS a__model, a.renderer AS a__renderer, a.cached_data AS a__cached_data, a.created_by AS a__created_by, a.date_published AS a__date_published, a.privacy_flag AS a__privacy_flag, a.privacy_gold_members AS a__privacy_gold_members, a.privacy_content_class_id AS a__privacy_content_class_id, a.circulation_flag AS a__circulation_flag, a.circulation_country AS a__circulation_country, a.circulation_region AS a__circulation_region, a.circulation_city AS a__circulation_city, a.circulation_street AS a__circulation_street, a.valid_to AS a__valid_to, a.created_at AS a__created_at, a.updated_at AS a__updated_at, 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 activity_stream_aggregator a LEFT JOIN dm_user d ON a.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c ON d.id = c.dm_user_id INNER JOIN dm_user d2 ON a.created_by = d2.id WHERE (a.privacy_flag = '40' AND a.privacy_flag = '40' AND (a.circulation_flag = '0' OR a.circulation_flag = '10') AND a.date_published BETWEEN '2024-12-23 00:00' AND '2024-12-30 23:59') ORDER BY a.date_published ASC
0.00s, "doctrine" connection
-
SELECT a.id AS a__id, a.uid AS a__uid, a.guid AS a__guid, a.model AS a__model, a.renderer AS a__renderer, a.cached_data AS a__cached_data, a.created_by AS a__created_by, a.date_published AS a__date_published, a.privacy_flag AS a__privacy_flag, a.privacy_gold_members AS a__privacy_gold_members, a.privacy_content_class_id AS a__privacy_content_class_id, a.circulation_flag AS a__circulation_flag, a.circulation_country AS a__circulation_country, a.circulation_region AS a__circulation_region, a.circulation_city AS a__circulation_city, a.circulation_street AS a__circulation_street, a.valid_to AS a__valid_to, a.created_at AS a__created_at, a.updated_at AS a__updated_at, 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 activity_stream_aggregator a LEFT JOIN dm_user d ON a.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c ON d.id = c.dm_user_id INNER JOIN dm_user d2 ON a.created_by = d2.id WHERE (a.privacy_flag = '40' AND a.privacy_flag = '40' AND (a.circulation_flag = '0' OR a.circulation_flag = '10') AND a.date_published BETWEEN '2024-12-22 00:00' AND '2024-12-22 23:59') ORDER BY a.date_published DESC
0.00s, "doctrine" connection
-
SELECT a.id AS a__id, a.uid AS a__uid, a.guid AS a__guid, a.model AS a__model, a.renderer AS a__renderer, a.cached_data AS a__cached_data, a.created_by AS a__created_by, a.date_published AS a__date_published, a.privacy_flag AS a__privacy_flag, a.privacy_gold_members AS a__privacy_gold_members, a.privacy_content_class_id AS a__privacy_content_class_id, a.circulation_flag AS a__circulation_flag, a.circulation_country AS a__circulation_country, a.circulation_region AS a__circulation_region, a.circulation_city AS a__circulation_city, a.circulation_street AS a__circulation_street, a.valid_to AS a__valid_to, a.created_at AS a__created_at, a.updated_at AS a__updated_at, 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 activity_stream_aggregator a LEFT JOIN dm_user d ON a.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c ON d.id = c.dm_user_id INNER JOIN dm_user d2 ON a.created_by = d2.id WHERE (a.privacy_flag = '40' AND a.privacy_flag = '40' AND (a.circulation_flag = '0' OR a.circulation_flag = '10') AND a.date_published BETWEEN '2024-12-22 00:00' AND '2024-12-22 23:59') ORDER BY a.date_published DESC
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM (SELECT a.id FROM activity_stream_aggregator a LEFT JOIN dm_user d ON a.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c ON d.id = c.dm_user_id INNER JOIN dm_user d2 ON a.created_by = d2.id WHERE a.privacy_flag = '40' AND a.privacy_flag = '40' AND (a.circulation_flag = '0' OR a.circulation_flag = '10') AND a.date_published < '2024-12-22 00:00' GROUP BY a.id) dctrn_count_query
0.01s, "doctrine" connection
-
SELECT a.id AS a__id, a.uid AS a__uid, a.guid AS a__guid, a.model AS a__model, a.renderer AS a__renderer, a.cached_data AS a__cached_data, a.created_by AS a__created_by, a.date_published AS a__date_published, a.privacy_flag AS a__privacy_flag, a.privacy_gold_members AS a__privacy_gold_members, a.privacy_content_class_id AS a__privacy_content_class_id, a.circulation_flag AS a__circulation_flag, a.circulation_country AS a__circulation_country, a.circulation_region AS a__circulation_region, a.circulation_city AS a__circulation_city, a.circulation_street AS a__circulation_street, a.valid_to AS a__valid_to, a.created_at AS a__created_at, a.updated_at AS a__updated_at, 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 activity_stream_aggregator a LEFT JOIN dm_user d ON a.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c ON d.id = c.dm_user_id INNER JOIN dm_user d2 ON a.created_by = d2.id WHERE (a.privacy_flag = '40' AND a.privacy_flag = '40' AND (a.circulation_flag = '0' OR a.circulation_flag = '10') AND a.date_published < '2024-12-22 00:00') ORDER BY a.date_published DESC LIMIT 15 OFFSET 210
0.00s, "doctrine" connection
-
SELECT DISTINCT d3.id FROM dm_user d3 INNER JOIN dm_media d4 ON d3.id = d4.created_by INNER JOIN user_galleries_dm_media u3 ON d4.id = u3.dm_media_id INNER JOIN user_galleries u4 ON u3.dm_record_id = u4.id WHERE u4.type = 'user_profile_photo' AND d3.is_active = '1' ORDER BY d3.created_at DESC, d4.created_at DESC LIMIT 40
0.01s, "doctrine" connection
-
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, d2.id AS d2__id, d2.dm_media_folder_id AS d2__dm_media_folder_id, d2.file AS d2__file, d2.legend AS d2__legend, d2.mime AS d2__mime, d2.size AS d2__size, d2.dimensions AS d2__dimensions, d2.name AS d2__name, d2.validated AS d2__validated, d2.active AS d2__active, d2.uploader AS d2__uploader, d2.imagetypecategory AS d2__imagetypecategory, d2.imageindexinternal AS d2__imageindexinternal, d2.imfingerprint AS d2__imfingerprint, d2.created_at AS d2__created_at, d2.updated_at AS d2__updated_at, d2.created_by AS d2__created_by, d2.updated_by AS d2__updated_by, u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend FROM dm_user d INNER JOIN dm_media d2 ON d.id = d2.created_by INNER JOIN user_galleries_dm_media u ON d2.id = u.dm_media_id INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id WHERE d.id IN ('528', '526', '493', '492', '422', '413', '350', '348', '340', '316', '297', '295', '294', '293', '292', '291', '290', '289', '288', '287', '286', '285', '284', '283', '282', '281', '280', '279', '278', '276', '275', '274', '273', '272', '271', '270', '269', '268', '267', '266') AND (u2.type = 'user_profile_photo' AND d.is_active = '1') ORDER BY d.created_at DESC, d2.created_at DESC
0.02s, "doctrine" connection
-
SELECT h.id AS h__id, h.is_active AS h__is_active, h.start_date AS h__start_date, h.end_date AS h__end_date, h.detail_page_id AS h__detail_page_id, h.prize AS h__prize, h.created_by AS h__created_by, h.updated_by AS h__updated_by, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h.version AS h__version FROM hi5_run h WHERE (EXISTS (SELECT h2.id AS h2__id, h2.is_active AS h2__is_active, h2.start_date AS h2__start_date, h2.end_date AS h2__end_date, h2.detail_page_id AS h2__detail_page_id, h2.prize AS h2__prize, h2.created_by AS h2__created_by, h2.updated_by AS h2__updated_by, h2.created_at AS h2__created_at, h2.updated_at AS h2__updated_at, h2.version AS h2__version FROM hi5_run h2 LEFT JOIN hi5_user h3 ON h2.id = h3.hi5_run_id AND ((h2.id = h3.hi5_run_id AND h3.end_competing >= '2024-12-22 00:00' AND h3.is_active = '1')) LEFT JOIN dm_user d ON h3.user_id = d.id WHERE (h2.is_active = '1' AND h2.start_date <= '2024-12-31 23:59' AND h2.id = h.id) GROUP BY h2.id HAVING (COUNT(h3.id) > 0 OR h2.end_date >= '2024-12-22 00:00'))) ORDER BY h.start_date DESC LIMIT 3
0.00s, "doctrine" connection
-
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.id = '41') LIMIT 1
0.00s, "doctrine" connection
-
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 = '10')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '41'
0.00s, "doctrine" connection
-
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_found_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 = '41') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = 'ttFoundList')
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '40') LIMIT 1
0.00s, "doctrine" connection
-
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 = '10')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '40'
0.00s, "doctrine" connection
-
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_found_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 = '40') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '32') LIMIT 1
0.00s, "doctrine" connection
-
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 = '10')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '32'
0.00s, "doctrine" connection
-
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 = '32') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '31') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '31'
0.00s, "doctrine" connection
-
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 = '31') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '30') LIMIT 1
0.00s, "doctrine" connection
-
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 = '14')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '30'
0.00s, "doctrine" connection
-
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 = '30') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '37') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '37'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '29') LIMIT 1
0.00s, "doctrine" connection
-
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 = '14')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '29'
0.00s, "doctrine" connection
-
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 = '29') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '33') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '33'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '28') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '28'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '30') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '30'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '29') LIMIT 1
0.00s, "doctrine" connection
-
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 = '14')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '29'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '27') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '27'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '26') LIMIT 1
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '26'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '27') LIMIT 1
0.00s, "doctrine" connection
-
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 = '4')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_found_dm_media t WHERE t.dm_record_id = '27'
0.00s, "doctrine" connection
-
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 = '29')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
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.id = '23') LIMIT 1
0.00s, "doctrine" connection
-
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 = '6')
0.00s, "doctrine" connection
-
SELECT COUNT(*) AS num_results FROM tt_lost_dm_media t WHERE t.dm_record_id = '23'
0.00s, "doctrine" connection
-
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 = '23') ORDER BY t.position ASC
0.00s, "doctrine" connection
-
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 = '11')
0.00s, "doctrine" connection
-
SELECT s.iso_2 AS s__0, s.iso_2 AS s__0 FROM sca_country s WHERE (s.name LIKE '%United Kingdom%') ORDER BY s.name asc
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '288')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '805' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '246')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '282')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '800' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '241')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '268')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '779' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '223')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '286')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '804' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '244')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '270')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '783' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '238')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '271')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '785' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '225')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '276')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '819' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '228')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '279')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '797' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '251')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '297')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '817' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '240')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '267')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '777' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '222')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '278')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '810' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '210')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '269')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '781' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '224')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '291')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '792' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '200')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '422')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1073' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '321')
0.00s, "doctrine" connection
-
SELECT r.id AS r__id, r.is_active AS r__is_active, r.status AS r__status, r.business_trading_name AS r__business_trading_name, r.house_building_no AS r__house_building_no, r.postcode AS r__postcode, r.town_city AS r__town_city, r.country AS r__country, r.vat_check_status AS r__vat_check_status, r.vat_number AS r__vat_number, r.vat_vies_response AS r__vat_vies_response, r.contact_name AS r__contact_name, r.contact_email AS r__contact_email, r.sponsor_promotional_code AS r__sponsor_promotional_code, r.sponsor_id AS r__sponsor_id, r.sponsor_notified AS r__sponsor_notified, r.sponsor_commission_fee AS r__sponsor_commission_fee, r.dm_user_id AS r__dm_user_id, r.admin_notes AS r__admin_notes, r.registration_code AS r__registration_code, r.official_company_name AS r__official_company_name, r.sub_building AS r__sub_building, r.street_name AS r__street_name, r.state_region AS r__state_region, r.primary_category_id AS r__primary_category_id, r.primary_category_goods AS r__primary_category_goods, r.primary_category_services AS r__primary_category_services, r.second_category_id AS r__second_category_id, r.second_category_goods AS r__second_category_goods, r.second_category_services AS r__second_category_services, r.third_category_id AS r__third_category_id, r.third_category_goods AS r__third_category_goods, r.third_category_services AS r__third_category_services, r.sd_show_full_address AS r__sd_show_full_address, r.sd_range_from_business_address AS r__sd_range_from_business_address, r.sd_range_from_business_m_km AS r__sd_range_from_business_m_km, r.sd_by_mail_email AS r__sd_by_mail_email, r.sd_chain AS r__sd_chain, r.headline AS r__headline, r.main_description AS r__main_description, r.company_logo_id AS r__company_logo_id, r.feedback_incentives_id AS r__feedback_incentives_id, r.supplier_recommendation_id AS r__supplier_recommendation_id, r.website AS r__website, r.sales_telephone AS r__sales_telephone, r.directory_status AS r__directory_status, r.directory_date_published AS r__directory_date_published, r.created_at AS r__created_at, r.updated_at AS r__updated_at, r.dm_taggable_denormalized_tags_cache_field AS r__dm_taggable_denormalized_tags_cache_field, r.location_address AS r__location_address, r.location_latitude AS r__location_latitude, r.location_longitude AS r__location_longitude, r.location_type AS r__location_type, r.location_street_number AS r__location_street_number, r.location_route AS r__location_route, r.location_locality AS r__location_locality, r.location_country AS r__location_country, r.location_postal_code AS r__location_postal_code, r.location_postal_code_prefix AS r__location_postal_code_prefix, r.location_administrative_area_level_1 AS r__location_administrative_area_level_1, r.location_administrative_area_level_2 AS r__location_administrative_area_level_2 FROM retailer_account r WHERE (r.dm_user_id = '422')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '284')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '802' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '249')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '289')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '812' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '207')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '272')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '787' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '253')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '295')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '791' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '201')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '287')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '809' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '208')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '493')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1291' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '299')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '528')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1349' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '314')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '280')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '798' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '247')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '316')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '842' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '268')
0.00s, "doctrine" connection
-
SELECT r.id AS r__id, r.is_active AS r__is_active, r.status AS r__status, r.business_trading_name AS r__business_trading_name, r.house_building_no AS r__house_building_no, r.postcode AS r__postcode, r.town_city AS r__town_city, r.country AS r__country, r.vat_check_status AS r__vat_check_status, r.vat_number AS r__vat_number, r.vat_vies_response AS r__vat_vies_response, r.contact_name AS r__contact_name, r.contact_email AS r__contact_email, r.sponsor_promotional_code AS r__sponsor_promotional_code, r.sponsor_id AS r__sponsor_id, r.sponsor_notified AS r__sponsor_notified, r.sponsor_commission_fee AS r__sponsor_commission_fee, r.dm_user_id AS r__dm_user_id, r.admin_notes AS r__admin_notes, r.registration_code AS r__registration_code, r.official_company_name AS r__official_company_name, r.sub_building AS r__sub_building, r.street_name AS r__street_name, r.state_region AS r__state_region, r.primary_category_id AS r__primary_category_id, r.primary_category_goods AS r__primary_category_goods, r.primary_category_services AS r__primary_category_services, r.second_category_id AS r__second_category_id, r.second_category_goods AS r__second_category_goods, r.second_category_services AS r__second_category_services, r.third_category_id AS r__third_category_id, r.third_category_goods AS r__third_category_goods, r.third_category_services AS r__third_category_services, r.sd_show_full_address AS r__sd_show_full_address, r.sd_range_from_business_address AS r__sd_range_from_business_address, r.sd_range_from_business_m_km AS r__sd_range_from_business_m_km, r.sd_by_mail_email AS r__sd_by_mail_email, r.sd_chain AS r__sd_chain, r.headline AS r__headline, r.main_description AS r__main_description, r.company_logo_id AS r__company_logo_id, r.feedback_incentives_id AS r__feedback_incentives_id, r.supplier_recommendation_id AS r__supplier_recommendation_id, r.website AS r__website, r.sales_telephone AS r__sales_telephone, r.directory_status AS r__directory_status, r.directory_date_published AS r__directory_date_published, r.created_at AS r__created_at, r.updated_at AS r__updated_at, r.dm_taggable_denormalized_tags_cache_field AS r__dm_taggable_denormalized_tags_cache_field, r.location_address AS r__location_address, r.location_latitude AS r__location_latitude, r.location_longitude AS r__location_longitude, r.location_type AS r__location_type, r.location_street_number AS r__location_street_number, r.location_route AS r__location_route, r.location_locality AS r__location_locality, r.location_country AS r__location_country, r.location_postal_code AS r__location_postal_code, r.location_postal_code_prefix AS r__location_postal_code_prefix, r.location_administrative_area_level_1 AS r__location_administrative_area_level_1, r.location_administrative_area_level_2 AS r__location_administrative_area_level_2 FROM retailer_account r WHERE (r.dm_user_id = '316')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '413')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1033' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '286')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '292')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '811' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '209')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '283')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '801' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '248')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '293')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '807' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '243')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '340')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '867' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '267')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '274')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '727' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '227')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '294')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '793' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '203')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '275')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '729' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '204')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '350')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '896' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '272')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '290')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '806' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '245')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '285')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '803' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '250')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '526')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1343' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '309')
0.00s, "doctrine" connection
-
SELECT r.id AS r__id, r.is_active AS r__is_active, r.status AS r__status, r.business_trading_name AS r__business_trading_name, r.house_building_no AS r__house_building_no, r.postcode AS r__postcode, r.town_city AS r__town_city, r.country AS r__country, r.vat_check_status AS r__vat_check_status, r.vat_number AS r__vat_number, r.vat_vies_response AS r__vat_vies_response, r.contact_name AS r__contact_name, r.contact_email AS r__contact_email, r.sponsor_promotional_code AS r__sponsor_promotional_code, r.sponsor_id AS r__sponsor_id, r.sponsor_notified AS r__sponsor_notified, r.sponsor_commission_fee AS r__sponsor_commission_fee, r.dm_user_id AS r__dm_user_id, r.admin_notes AS r__admin_notes, r.registration_code AS r__registration_code, r.official_company_name AS r__official_company_name, r.sub_building AS r__sub_building, r.street_name AS r__street_name, r.state_region AS r__state_region, r.primary_category_id AS r__primary_category_id, r.primary_category_goods AS r__primary_category_goods, r.primary_category_services AS r__primary_category_services, r.second_category_id AS r__second_category_id, r.second_category_goods AS r__second_category_goods, r.second_category_services AS r__second_category_services, r.third_category_id AS r__third_category_id, r.third_category_goods AS r__third_category_goods, r.third_category_services AS r__third_category_services, r.sd_show_full_address AS r__sd_show_full_address, r.sd_range_from_business_address AS r__sd_range_from_business_address, r.sd_range_from_business_m_km AS r__sd_range_from_business_m_km, r.sd_by_mail_email AS r__sd_by_mail_email, r.sd_chain AS r__sd_chain, r.headline AS r__headline, r.main_description AS r__main_description, r.company_logo_id AS r__company_logo_id, r.feedback_incentives_id AS r__feedback_incentives_id, r.supplier_recommendation_id AS r__supplier_recommendation_id, r.website AS r__website, r.sales_telephone AS r__sales_telephone, r.directory_status AS r__directory_status, r.directory_date_published AS r__directory_date_published, r.created_at AS r__created_at, r.updated_at AS r__updated_at, r.dm_taggable_denormalized_tags_cache_field AS r__dm_taggable_denormalized_tags_cache_field, r.location_address AS r__location_address, r.location_latitude AS r__location_latitude, r.location_longitude AS r__location_longitude, r.location_type AS r__location_type, r.location_street_number AS r__location_street_number, r.location_route AS r__location_route, r.location_locality AS r__location_locality, r.location_country AS r__location_country, r.location_postal_code AS r__location_postal_code, r.location_postal_code_prefix AS r__location_postal_code_prefix, r.location_administrative_area_level_1 AS r__location_administrative_area_level_1, r.location_administrative_area_level_2 AS r__location_administrative_area_level_2 FROM retailer_account r WHERE (r.dm_user_id = '526')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '273')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '789' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '226')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '492')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '1289' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '294')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '348')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '883' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '270')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '281')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '799' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '242')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.title AS u__title, u.description AS u__description, u.type AS u__type, u.created_by AS u__created_by, u.updated_by AS u__updated_by, u.position AS u__position, u.deleted_at AS u__deleted_at, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.gold_members AS u__gold_members, u.privacy AS u__privacy, u.content_class_id AS u__content_class_id, u.followers_count AS u__followers_count, u.slug AS u__slug FROM user_galleries u WHERE (u.type = 'user_profile_photo' AND u.created_by = '266')
0.00s, "doctrine" connection
-
SELECT u.id AS u__id, u.dm_media_id AS u__dm_media_id, u.dm_record_id AS u__dm_record_id, u.position AS u__position, u.name AS u__name, u.legend AS u__legend, u2.id AS u2__id, u2.title AS u2__title, u2.description AS u2__description, u2.type AS u2__type, u2.created_by AS u2__created_by, u2.updated_by AS u2__updated_by, u2.position AS u2__position, u2.deleted_at AS u2__deleted_at, u2.created_at AS u2__created_at, u2.updated_at AS u2__updated_at, u2.gold_members AS u2__gold_members, u2.privacy AS u2__privacy, u2.content_class_id AS u2__content_class_id, u2.followers_count AS u2__followers_count, u2.slug AS u2__slug, 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 FROM user_galleries_dm_media u INNER JOIN user_galleries u2 ON u.dm_record_id = u2.id INNER JOIN dm_media d ON u.dm_media_id = d.id WHERE (u2.id = '775' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC
0.00s, "doctrine" connection
-
SELECT d.id AS d__id, d.rel_path AS d__rel_path, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_media_folder d WHERE (d.id = '239')
0.00s, "doctrine" connection
-
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 = 'charityChoice')
0.00s, "doctrine" connection
-
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 = 'nonConsumerApplication')
0.00s, "doctrine" connection
-
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 = 'tellMeMore')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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 = 'forgottenPassword')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection
-
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')
0.00s, "doctrine" connection