Doctrine Version: 1.2.4

1. SET NAMES 'utf8mb4'

   0.00s, "doctrine" connection

2. 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

3. SELECT d.id AS d__id, d.ip AS d__ip, d.name AS d__name, d.ts AS d__ts, d.page AS d__page, d.country AS d__country, d.country_code AS d__country_code, d.city AS d__city, d.browser AS d__browser, d.dm_user AS d__dm_user FROM dm_who_is_online d WHERE (d.ip = '18.227.209.101' AND d.name = 'Guest')

   0.00s, "doctrine" connection

4. INSERT INTO dm_who_is_online (ip, name, browser, ts, page) VALUES ('18.227.209.101', 'Guest', 'unknown', '1732237634', 'https://telltrail.com/dev.php/directory')

   0.00s, "doctrine" connection

5. DELETE FROM dm_who_is_online WHERE (ts < '1732237334')

   0.00s, "doctrine" connection

6. 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 = 'directory')

   0.00s, "doctrine" connection

7. 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 = 'directoryList')

   0.00s, "doctrine" connection

8. 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 = '5' OR d.dm_page_view_id = '133') ORDER BY d2.position asc, d3.position asc

   0.00s, "doctrine" connection

9. 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

10. 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

11. 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

12. SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'dmUser' AND d.action = 'list')

    0.00s, "doctrine" connection

13. 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

14. 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

15. 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

16. 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

17. 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

18. 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

19. 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

20. 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

21. 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

22. 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

23. 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 < '2556' AND d.rgt > '2561') ORDER BY d.lft asc

    0.00s, "doctrine" connection

24. SELECT COUNT(*) as num_results FROM (SELECT DISTINCT u.id FROM dm_user u LEFT JOIN retailer_account r ON r.dm_user_id = u.id LEFT JOIN charity_account c ON c.dm_user_id = u.id LEFT JOIN business_category bc_r1 ON r.primary_category_id = bc_r1.id LEFT JOIN business_category bc_r2 ON r.second_category_id = bc_r2.id LEFT JOIN business_category bc_r3 ON r.third_category_id = bc_r3.id LEFT JOIN business_category cc_r1 ON c.primary_category_id = cc_r1.id LEFT JOIN business_category cc_r2 ON c.second_category_id = cc_r2.id LEFT JOIN business_category cc_r3 ON c.third_category_id = cc_r3.id WHERE u.membership IN ('charity', 'retailer', 'retailer_trial') AND (r.directory_status = 'published' OR r.directory_status = 'default' OR c.directory_status = 'published' OR c.directory_status = 'default')) as results

    0.00s, "doctrine" connection

25. SELECT u.id AS u__id, u.username AS u__username, u.email AS u__email, u.algorithm AS u__algorithm, u.salt AS u__salt, u.password AS u__password, u.is_active AS u__is_active, u.is_super_admin AS u__is_super_admin, u.last_login AS u__last_login, u.forgot_password_code AS u__forgot_password_code, u.sca_address AS u__sca_address, u.notifications_read AS u__notifications_read, u.notifications_emailed AS u__notifications_emailed, u.points AS u__points, u.referrer AS u__referrer, u.image_folder AS u__image_folder, u.firstname AS u__firstname, u.lastname AS u__lastname, u.dob AS u__dob, u.gender AS u__gender, u.headline AS u__headline, u.description AS u__description, u.about AS u__about, u.hobbies AS u__hobbies, u.education AS u__education, u.employment AS u__employment, u.ethnicity AS u__ethnicity, u.smoker AS u__smoker, u.alcohol AS u__alcohol, u.build AS u__build, u.religion AS u__religion, u.marital_status AS u__marital_status, u.dependent_children AS u__dependent_children, u.want_children AS u__want_children, u.looking_for_min AS u__looking_for_min, u.looking_for_max AS u__looking_for_max, u.privacy_profile AS u__privacy_profile, u.privacy_profile_share_online AS u__privacy_profile_share_online, u.privacy_profile_share_age AS u__privacy_profile_share_age, u.privacy_profile_share_cover AS u__privacy_profile_share_cover, u.privacy_search_realname AS u__privacy_search_realname, u.privacy_search_email AS u__privacy_search_email, u.privacy_search_hobbies AS u__privacy_search_hobbies, u.privacy_accept_messages AS u__privacy_accept_messages, u.preferences_timeformat AS u__preferences_timeformat, u.currency AS u__currency, u.country AS u__country, u.notifications AS u__notifications, u.telltrail_update AS u__telltrail_update, u.coins AS u__coins, u.expire_date AS u__expire_date, u.rating AS u__rating, u.warning AS u__warning, u.suspended AS u__suspended, u.suspended_reason AS u__suspended_reason, u.membership AS u__membership, u.language AS u__language, u.referral AS u__referral, u.email_backup AS u__email_backup, u.security_question AS u__security_question, u.security_response AS u__security_response, u.phone AS u__phone, u.mobile AS u__mobile, u.notification_interval AS u__notification_interval, u.region AS u__region, u.town_city AS u__town_city, u.postcode AS u__postcode, u.street AS u__street, u.registration_code AS u__registration_code, u.password_changed AS u__password_changed, u.security_question_changed AS u__security_question_changed, u.is_in_quarantine AS u__is_in_quarantine, u.quarantine_start AS u__quarantine_start, u.quarantine_end AS u__quarantine_end, u.quarantine_time AS u__quarantine_time, u.nb_views AS u__nb_views, u.is_completed_activation AS u__is_completed_activation, u.last_activation_reminder_date AS u__last_activation_reminder_date, u.invitation_link_welcome_text AS u__invitation_link_welcome_text, u.invitation_email_welcome_text AS u__invitation_email_welcome_text, u.location_address_valid AS u__location_address_valid, u.invitation_email_message_text AS u__invitation_email_message_text, u.invitation_email_shortlink_text AS u__invitation_email_shortlink_text, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.location_address AS u__location_address, u.location_latitude AS u__location_latitude, u.location_longitude AS u__location_longitude, u.location_type AS u__location_type, u.location_street_number AS u__location_street_number, u.location_route AS u__location_route, u.location_locality AS u__location_locality, u.location_country AS u__location_country, u.location_postal_code AS u__location_postal_code, u.location_postal_code_prefix AS u__location_postal_code_prefix, u.location_administrative_area_level_1 AS u__location_administrative_area_level_1, u.location_administrative_area_level_2 AS u__location_administrative_area_level_2, u.dm_taggable_denormalized_tags_cache_field AS u__dm_taggable_denormalized_tags_cache_field, u.comments_count AS u__comments_count, u.followers_count AS u__followers_count, u.slug AS u__slug, 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, c.id AS c__id, c.is_active AS c__is_active, c.status AS c__status, c.dm_user_id AS c__dm_user_id, c.charity_name AS c__charity_name, c.official_name AS c__official_name, c.charity_number AS c__charity_number, c.website AS c__website, c.charity_logo_id AS c__charity_logo_id, c.primary_category_id AS c__primary_category_id, c.second_category_id AS c__second_category_id, c.third_category_id AS c__third_category_id, c.sd_show_full_address AS c__sd_show_full_address, c.sd_range_from_charity_address AS c__sd_range_from_charity_address, c.sd_range_from_charity_m_km AS c__sd_range_from_charity_m_km, c.sd_by_mail_email AS c__sd_by_mail_email, c.sd_chain AS c__sd_chain, c.headline AS c__headline, c.main_description AS c__main_description, c.house_building_no AS c__house_building_no, c.postcode AS c__postcode, c.town_city AS c__town_city, c.country AS c__country, c.sub_building AS c__sub_building, c.street_name AS c__street_name, c.state_region AS c__state_region, c.contact_name AS c__contact_name, c.directory_status AS c__directory_status, c.directory_date_published AS c__directory_date_published, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.dm_taggable_denormalized_tags_cache_field AS c__dm_taggable_denormalized_tags_cache_field, bc_r1.id AS bc_r1__id, bc_r1.is_active AS bc_r1__is_active, bc_r1.title AS bc_r1__title, bc_r1.description AS bc_r1__description, bc_r1.deleted_at AS bc_r1__deleted_at, bc_r1.position AS bc_r1__position, bc_r1.root_id AS bc_r1__root_id, bc_r1.lft AS bc_r1__lft, bc_r1.rgt AS bc_r1__rgt, bc_r1.level AS bc_r1__level, bc_r2.id AS bc_r2__id, bc_r2.is_active AS bc_r2__is_active, bc_r2.title AS bc_r2__title, bc_r2.description AS bc_r2__description, bc_r2.deleted_at AS bc_r2__deleted_at, bc_r2.position AS bc_r2__position, bc_r2.root_id AS bc_r2__root_id, bc_r2.lft AS bc_r2__lft, bc_r2.rgt AS bc_r2__rgt, bc_r2.level AS bc_r2__level, bc_r3.id AS bc_r3__id, bc_r3.is_active AS bc_r3__is_active, bc_r3.title AS bc_r3__title, bc_r3.description AS bc_r3__description, bc_r3.deleted_at AS bc_r3__deleted_at, bc_r3.position AS bc_r3__position, bc_r3.root_id AS bc_r3__root_id, bc_r3.lft AS bc_r3__lft, bc_r3.rgt AS bc_r3__rgt, bc_r3.level AS bc_r3__level, cc_r1.id AS cc_r1__id, cc_r1.is_active AS cc_r1__is_active, cc_r1.title AS cc_r1__title, cc_r1.description AS cc_r1__description, cc_r1.deleted_at AS cc_r1__deleted_at, cc_r1.position AS cc_r1__position, cc_r1.root_id AS cc_r1__root_id, cc_r1.lft AS cc_r1__lft, cc_r1.rgt AS cc_r1__rgt, cc_r1.level AS cc_r1__level, cc_r2.id AS cc_r2__id, cc_r2.is_active AS cc_r2__is_active, cc_r2.title AS cc_r2__title, cc_r2.description AS cc_r2__description, cc_r2.deleted_at AS cc_r2__deleted_at, cc_r2.position AS cc_r2__position, cc_r2.root_id AS cc_r2__root_id, cc_r2.lft AS cc_r2__lft, cc_r2.rgt AS cc_r2__rgt, cc_r2.level AS cc_r2__level, cc_r3.id AS cc_r3__id, cc_r3.is_active AS cc_r3__is_active, cc_r3.title AS cc_r3__title, cc_r3.description AS cc_r3__description, cc_r3.deleted_at AS cc_r3__deleted_at, cc_r3.position AS cc_r3__position, cc_r3.root_id AS cc_r3__root_id, cc_r3.lft AS cc_r3__lft, cc_r3.rgt AS cc_r3__rgt, cc_r3.level AS cc_r3__level FROM dm_user u LEFT JOIN retailer_account r ON r.dm_user_id = u.id LEFT JOIN charity_account c ON c.dm_user_id = u.id LEFT JOIN business_category bc_r1 ON r.primary_category_id = bc_r1.id LEFT JOIN business_category bc_r2 ON r.second_category_id = bc_r2.id LEFT JOIN business_category bc_r3 ON r.third_category_id = bc_r3.id LEFT JOIN business_category cc_r1 ON c.primary_category_id = cc_r1.id LEFT JOIN business_category cc_r2 ON c.second_category_id = cc_r2.id LEFT JOIN business_category cc_r3 ON c.third_category_id = cc_r3.id WHERE u.membership IN ('charity', 'retailer', 'retailer_trial') AND (r.directory_status = 'published' OR r.directory_status = 'default' OR c.directory_status = 'published' OR c.directory_status = 'default') ORDER BY (IF (r.directory_date_published IS NOT NULL, r.directory_date_published, c.directory_date_published)) DESC LIMIT 20 OFFSET 0

    0.01s, "doctrine" connection

26. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE (b.lft = '1')

    0.00s, "doctrine" connection

27. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b

    0.00s, "doctrine" connection

28. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '1' AND b.rgt < '428') AND b.level <= '1' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

29. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '2' AND b.rgt < '21') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

30. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '22' AND b.rgt < '27') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

31. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '28' AND b.rgt < '39') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

32. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '40' AND b.rgt < '49') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

33. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '50' AND b.rgt < '67') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

34. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '57' AND b.rgt < '62') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

35. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '68' AND b.rgt < '83') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

36. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '84' AND b.rgt < '141') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

37. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '87' AND b.rgt < '112') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

38. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '88' AND b.rgt < '99') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

39. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '100' AND b.rgt < '111') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

40. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '113' AND b.rgt < '138') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

41. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '114' AND b.rgt < '125') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

42. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '126' AND b.rgt < '137') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

43. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '142' AND b.rgt < '155') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

44. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '156' AND b.rgt < '167') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

45. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '168' AND b.rgt < '183') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

46. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '184' AND b.rgt < '195') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

47. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '196' AND b.rgt < '211') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

48. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '212' AND b.rgt < '223') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

49. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '224' AND b.rgt < '233') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

50. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '234' AND b.rgt < '271') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

51. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '239' AND b.rgt < '256') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

52. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '272' AND b.rgt < '287') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

53. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '288' AND b.rgt < '297') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

54. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '298' AND b.rgt < '309') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

55. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '310' AND b.rgt < '317') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

56. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '318' AND b.rgt < '329') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

57. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '330' AND b.rgt < '337') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

58. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '338' AND b.rgt < '347') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

59. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '348' AND b.rgt < '383') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

60. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '355' AND b.rgt < '362') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

61. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '365' AND b.rgt < '372') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

62. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '384' AND b.rgt < '413') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

63. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '387' AND b.rgt < '394') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

64. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '414' AND b.rgt < '425') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

65. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '1' AND b.rgt < '154') AND b.level <= '1' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

66. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '2' AND b.rgt < '13') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

67. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '14' AND b.rgt < '25') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

68. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '26' AND b.rgt < '33') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

69. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '34' AND b.rgt < '43') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

70. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '44' AND b.rgt < '49') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

71. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '50' AND b.rgt < '57') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

72. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '58' AND b.rgt < '63') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

73. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '64' AND b.rgt < '87') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

74. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '88' AND b.rgt < '101') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

75. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '102' AND b.rgt < '109') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

76. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '110' AND b.rgt < '123') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

77. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '124' AND b.rgt < '141') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

78. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '144' AND b.rgt < '151') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

    0.00s, "doctrine" connection

79. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b

    0.00s, "doctrine" connection

80. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE (b.lft = '1')

    0.00s, "doctrine" connection

81. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b

    0.00s, "doctrine" connection

82. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '1' AND b.rgt < '428') AND b.level <= '1' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

83. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '2' AND b.rgt < '21') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

84. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '22' AND b.rgt < '27') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

85. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '28' AND b.rgt < '39') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

86. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '40' AND b.rgt < '49') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

87. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '50' AND b.rgt < '67') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

88. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '57' AND b.rgt < '62') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

89. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '68' AND b.rgt < '83') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

90. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '84' AND b.rgt < '141') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

91. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '87' AND b.rgt < '112') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

92. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '88' AND b.rgt < '99') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

93. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '100' AND b.rgt < '111') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

94. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '113' AND b.rgt < '138') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

95. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '114' AND b.rgt < '125') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

96. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '126' AND b.rgt < '137') AND b.level <= '4' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

97. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '142' AND b.rgt < '155') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

98. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '156' AND b.rgt < '167') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

99. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '168' AND b.rgt < '183') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

    0.00s, "doctrine" connection

100. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '184' AND b.rgt < '195') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

101. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '196' AND b.rgt < '211') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

102. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '212' AND b.rgt < '223') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

103. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '224' AND b.rgt < '233') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

104. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '234' AND b.rgt < '271') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

105. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '239' AND b.rgt < '256') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

106. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '272' AND b.rgt < '287') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

107. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '288' AND b.rgt < '297') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

108. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '298' AND b.rgt < '309') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

109. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '310' AND b.rgt < '317') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

110. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '318' AND b.rgt < '329') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

111. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '330' AND b.rgt < '337') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

112. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '338' AND b.rgt < '347') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

113. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '348' AND b.rgt < '383') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

114. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '355' AND b.rgt < '362') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

115. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '365' AND b.rgt < '372') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

116. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '384' AND b.rgt < '413') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

117. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '387' AND b.rgt < '394') AND b.level <= '3' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

118. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '414' AND b.rgt < '425') AND b.level <= '2' AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

119. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '1' AND b.rgt < '154') AND b.level <= '1' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

120. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '2' AND b.rgt < '13') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

121. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '14' AND b.rgt < '25') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

122. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '26' AND b.rgt < '33') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

123. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '34' AND b.rgt < '43') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

124. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '44' AND b.rgt < '49') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

125. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '50' AND b.rgt < '57') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

126. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '58' AND b.rgt < '63') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

127. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '64' AND b.rgt < '87') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

128. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '88' AND b.rgt < '101') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

129. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '102' AND b.rgt < '109') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

130. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '110' AND b.rgt < '123') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

131. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '124' AND b.rgt < '141') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

132. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft > '144' AND b.rgt < '151') AND b.level <= '2' AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

133. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b

     0.00s, "doctrine" connection

134. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 36 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

135. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 36 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

136. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 36 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

137. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 36 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

138. 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 = '554')

     0.00s, "doctrine" connection

139. 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 = '554')

     0.00s, "doctrine" connection

140. 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 = '1445' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

141. 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 = '486')

     0.00s, "doctrine" connection

142. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '409' AND b.rgt > '410') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

143. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

144. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 35 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

145. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 35 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

146. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 35 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

147. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 35 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

148. 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 = '553')

     0.00s, "doctrine" connection

149. 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 = '553')

     0.00s, "doctrine" connection

150. 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 = '1443' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

151. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '411' AND b.rgt > '412') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

152. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

153. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 34 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

154. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 34 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

155. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 34 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

156. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 34 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

157. 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 = '552')

     0.00s, "doctrine" connection

158. 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 = '552')

     0.00s, "doctrine" connection

159. 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 = '1441' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

160. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

161. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

162. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 33 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

163. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 33 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

164. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 33 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

165. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 33 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

166. 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 = '551')

     0.00s, "doctrine" connection

167. 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 = '551')

     0.00s, "doctrine" connection

168. 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 = '1439' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

169. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

170. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

171. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 32 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

172. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 32 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

173. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 32 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

174. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 32 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

175. 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 = '550')

     0.00s, "doctrine" connection

176. 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 = '550')

     0.00s, "doctrine" connection

177. 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 = '1437' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

178. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

179. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

180. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 31 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

181. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 31 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

182. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 31 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

183. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 31 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

184. 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 = '542')

     0.00s, "doctrine" connection

185. 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 = '542')

     0.00s, "doctrine" connection

186. 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 = '1339' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

187. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

188. SELECT d.id AS d__id, d.name AS d__name, d.vars AS d__vars, d.created_at AS d__created_at, d.updated_at AS d__updated_at FROM dm_mail_template d WHERE (d.name = 'tt_invalid_town_fetch_from_db_to_admin') LIMIT 1

     0.00s, "doctrine" connection

189. SELECT d.id AS d__id, d.description AS d__description, d.subject AS d__subject, d.body AS d__body, d.from_email AS d__from_email, d.to_email AS d__to_email, d.cc_email AS d__cc_email, d.bcc_email AS d__bcc_email, d.reply_to_email AS d__reply_to_email, d.sender_email AS d__sender_email, d.list_unsubscribe AS d__list_unsubscribe, d.is_html AS d__is_html, d.is_active AS d__is_active, d.lang AS d__lang FROM dm_mail_template_translation d WHERE (d.id IN ('46'))

     0.00s, "doctrine" connection

190. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 26 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

191. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 26 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

192. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 26 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

193. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 26 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

194. 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 = '366')

     0.00s, "doctrine" connection

195. 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 = '366')

     0.00s, "doctrine" connection

196. 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 = '973' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

197. 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 = '326')

     0.00s, "doctrine" connection

198. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

199. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

200. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 6 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

201. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 6 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

202. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 6 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

203. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 6 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

204. 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 = '39')

     0.00s, "doctrine" connection

205. 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 = '39')

     0.00s, "doctrine" connection

206. 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 = '263' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

207. 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 = '85')

     0.00s, "doctrine" connection

208. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

209. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

210. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 19 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

211. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 19 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

212. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 19 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

213. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 19 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

214. 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 = '356')

     0.00s, "doctrine" connection

215. 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 = '356')

     0.00s, "doctrine" connection

216. 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 = '946' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

217. 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 = '318')

     0.00s, "doctrine" connection

218. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '275' AND b.rgt > '276') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

219. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

220. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 28 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

221. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 28 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

222. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 28 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

223. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 28 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

224. 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 = '395')

     0.00s, "doctrine" connection

225. 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 = '395')

     0.00s, "doctrine" connection

226. 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 = '1023' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

227. 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 = '340')

     0.00s, "doctrine" connection

228. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

229. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

230. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 24 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

231. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 24 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

232. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 24 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

233. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 24 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

234. 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 = '364')

     0.00s, "doctrine" connection

235. 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 = '364')

     0.00s, "doctrine" connection

236. 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 = '969' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

237. 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 = '324')

     0.00s, "doctrine" connection

238. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '331' AND b.rgt > '332') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

239. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

240. SELECT AVG(user_avg_score) as active_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 17 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

241. SELECT COUNT(grouped_scores) as active_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 17 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('implicitly_accepted', 'immediately_accepted', 'unsatisfied_conclusion', 'unsatisfied_conclusion_offer_rejected', 'satisfactory_conclusion_with_improved_score', 'satisfactory_conclusion_without_improved_score', 'satisfactory_conclusion_offer_accepted')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

242. SELECT AVG(user_avg_score) as pending_avg_score FROM (SELECT user_id, AVG(score) AS user_avg_score FROM (SELECT created_by AS user_id, score, (SELECT COUNT(*) FROM retailer_feedback_report WHERE rfd.created_by = created_by) FROM (SELECT created_by, score FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 17 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer') ORDER BY created_by , score) as rfd) AS scr GROUP BY user_id) as user_avg_score

     0.00s, "doctrine" connection

243. SELECT COUNT(grouped_scores) as pending_total_reports FROM (SELECT COUNT(scr.score) as grouped_scores FROM ( SELECT rf.score, rf.created_by FROM retailer_feedback_report rf WHERE rf.retailer_account_id = 17 AND rf.created_at >= '2024-08-24 01:07:14' AND rf.status IN ('initial', 'pending', 'dispute', 'offer')) as scr GROUP BY scr.created_by) as scrs

     0.00s, "doctrine" connection

244. 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 = '355')

     0.00s, "doctrine" connection

245. 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 = '355')

     0.00s, "doctrine" connection

246. 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 = '944' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

247. 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 = '317')

     0.00s, "doctrine" connection

248. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '426' AND b.rgt > '427') AND b.root_id = '1') ORDER BY b.lft asc

     0.00s, "doctrine" connection

249. 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 = '301')

     0.00s, "doctrine" connection

250. 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 = '301')

     0.00s, "doctrine" connection

251. 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 = '846' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

252. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

253. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

254. 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 = '300')

     0.00s, "doctrine" connection

255. 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 = '300')

     0.00s, "doctrine" connection

256. 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 = '843' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

257. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

258. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

259. 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 = '299')

     0.00s, "doctrine" connection

260. 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 = '299')

     0.00s, "doctrine" connection

261. 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 = '840' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

262. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

263. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

264. 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 = '98')

     0.00s, "doctrine" connection

265. 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 = '98')

     0.00s, "doctrine" connection

266. 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 = '357' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

267. 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 = '101')

     0.00s, "doctrine" connection

268. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '31' AND b.rgt > '32') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

269. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

270. 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 = '237')

     0.00s, "doctrine" connection

271. 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 = '237')

     0.00s, "doctrine" connection

272. 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 = '710' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

273. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

274. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

275. 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 = '232')

     0.00s, "doctrine" connection

276. 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 = '232')

     0.00s, "doctrine" connection

277. 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 = '700' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

278. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

279. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

280. 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 = '227')

     0.00s, "doctrine" connection

281. 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 = '227')

     0.00s, "doctrine" connection

282. 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 = '694' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

283. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '152' AND b.rgt > '153') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

284. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

285. 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 = '226')

     0.00s, "doctrine" connection

286. 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 = '226')

     0.00s, "doctrine" connection

287. 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 = '692' AND u2.type = 'user_profile_photo') ORDER BY u.position ASC

     0.00s, "doctrine" connection

288. SELECT b.id AS b__id, b.is_active AS b__is_active, b.title AS b__title, b.description AS b__description, b.deleted_at AS b__deleted_at, b.position AS b__position, b.root_id AS b__root_id, b.lft AS b__lft, b.rgt AS b__rgt, b.level AS b__level FROM business_category b WHERE ((b.lft < '41' AND b.rgt > '42') AND b.root_id = '2') ORDER BY b.lft asc

     0.00s, "doctrine" connection

289. SELECT s.id AS s__id, s.name AS s__name, s.currency AS s__currency, s.local_currency AS s__local_currency, s.vat_rate AS s__vat_rate, s.is_active AS s__is_active, s.iso_2 AS s__iso_2, s.iso_3 AS s__iso_3, s.iso_num AS s__iso_num, s.distance_unit AS s__distance_unit, s.eec AS s__eec, s.actual_billing AS s__actual_billing, s.language AS s__language, s.position AS s__position FROM sca_country s WHERE (s.id = '10') ORDER BY s.name asc

     0.00s, "doctrine" connection

290. 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 = 'comingSoonMakeMoney')

     0.00s, "doctrine" connection

291. 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

292. 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

293. 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

294. 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

295. 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

296. 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

297. 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

298. SELECT d.id AS d__id, d.name AS d__name, d.type AS d__type, d.params AS d__params, d.group_name AS d__group_name, d.credentials AS d__credentials, d2.id AS d2__id, d2.description AS d2__description, d2.value AS d2__value, d2.default_value AS d2__default_value, d2.lang AS d2__lang FROM dm_setting d LEFT JOIN dm_setting_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.name = 'base_urls')

     0.00s, "doctrine" connection

299. UPDATE dm_setting_translation SET value = '{"front-prod":"https:\\/\\/telltrail.com\\/index.php","admin-prod":"https:\\/\\/www.telltrail.com\\/admin.php","front-dev":"https:\\/\\/telltrail.com\\/dev.php","admin-dev":"https:\\/\\/www.telltrail.com\\/admin_dev.php"}' WHERE id = '10' AND lang = 'en'

     0.00s, "doctrine" connection