Symfony Profiler

SELECT
  l0_.`id` AS id_0,
  l0_.`code` AS code_1,
  l0_.`locale` AS locale_2,
  l0_.`phone_code` AS phone_code_3,
  l0_.`phone_mask` AS phone_mask_4,
  l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5,
  l0_.`zip_code_mask` AS zip_code_mask_6,
  l0_.`percent_vat` AS percent_vat_7,
  l0_.`name` AS name_8,
  l0_.`name_en` AS name_en_9,
  l0_.`alias` AS alias_10,
  l0_.`sort` AS sort_11,
  l0_.`count` AS count_12,
  l0_.`hide` AS hide_13,
  l0_.`important` AS important_14,
  l0_.`pay_pal_percent` AS pay_pal_percent_15,
  l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16,
  l0_.`vat` AS vat_17,
  l0_.`pv_type` AS pv_type_18,
  l0_.`capital_timezone_diff` AS capital_timezone_diff_19,
  l0_.`capital` AS capital_20,
  l0_.`free_sample_delivery` AS free_sample_delivery_21,
  l0_.`units` AS units_22
FROM
  `list_country` l0_
WHERE
  l0_.`hide` <> 1
ORDER BY
  l0_.`code` ASC

SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC;

SELECT
  t0.`id` AS id_1,
  t0.`code` AS code_2,
  t0.`locale` AS locale_3,
  t0.`phone_code` AS phone_code_4,
  t0.`phone_mask` AS phone_mask_5,
  t0.`min_valid_phone_numbers` AS min_valid_phone_numbers_6,
  t0.`zip_code_mask` AS zip_code_mask_7,
  t0.`percent_vat` AS percent_vat_8,
  t0.`name` AS name_9,
  t0.`name_en` AS name_en_10,
  t0.`alias` AS alias_11,
  t0.`sort` AS sort_12,
  t0.`count` AS count_13,
  t0.`hide` AS hide_14,
  t0.`important` AS important_15,
  t0.`pay_pal_percent` AS pay_pal_percent_16,
  t0.`pay_pal_percent_own` AS pay_pal_percent_own_17,
  t0.`vat` AS vat_18,
  t0.`pv_type` AS pv_type_19,
  t0.`capital_timezone_diff` AS capital_timezone_diff_20,
  t0.`capital` AS capital_21,
  t0.`free_sample_delivery` AS free_sample_delivery_22,
  t0.`units` AS units_23
FROM
  `list_country` t0
WHERE
  t0.`id` = ?

SELECT t0.`id` AS id_1, t0.`code` AS code_2, t0.`locale` AS locale_3, t0.`phone_code` AS phone_code_4, t0.`phone_mask` AS phone_mask_5, t0.`min_valid_phone_numbers` AS min_valid_phone_numbers_6, t0.`zip_code_mask` AS zip_code_mask_7, t0.`percent_vat` AS percent_vat_8, t0.`name` AS name_9, t0.`name_en` AS name_en_10, t0.`alias` AS alias_11, t0.`sort` AS sort_12, t0.`count` AS count_13, t0.`hide` AS hide_14, t0.`important` AS important_15, t0.`pay_pal_percent` AS pay_pal_percent_16, t0.`pay_pal_percent_own` AS pay_pal_percent_own_17, t0.`vat` AS vat_18, t0.`pv_type` AS pv_type_19, t0.`capital_timezone_diff` AS capital_timezone_diff_20, t0.`capital` AS capital_21, t0.`free_sample_delivery` AS free_sample_delivery_22, t0.`units` AS units_23 FROM `list_country` t0 WHERE t0.`id` = 840;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND c0_.country_id = ?
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 2 AND c0_.country_id = 840 ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND (
    c0_.country_id IS NULL
    OR c0_.country_id = 0
    OR c0_.country_id = 'en'
  )
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 2 AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  t0.`id` AS id_1,
  t0.`lang` AS lang_2,
  t0.`start_day` AS start_day_3,
  t0.`end_day` AS end_day_4,
  t0.`start_hour` AS start_hour_5,
  t0.`end_hour` AS end_hour_6,
  t0.`phone` AS phone_7,
  t0.`email` AS email_8,
  t0.`twilio_id` AS twilio_id_9,
  t0.`work_days` AS work_days_10,
  t0.country_id AS country_id_11
FROM
  `country_and_lang_specific_data` t0
WHERE
  t0.`lang` = ?
  AND t0.country_id = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = 'en' AND t0.country_id = 840 LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`unid` AS unid_2,
  t0.`corporate_unid` AS corporate_unid_3,
  t0.`token` AS token_4,
  t0.`is_active` AS is_active_5,
  t0.`proved` AS proved_6,
  t0.`alias` AS alias_7,
  t0.`lotus_name` AS lotus_name_8,
  t0.`security_field` AS security_field_9,
  t0.`is_legal_entity` AS is_legal_entity_10,
  t0.`companyName` AS companyName_11,
  t0.`vatNumber` AS vatNumber_12,
  t0.`password` AS password_13,
  t0.`last_ip` AS last_ip_14,
  t0.`source` AS source_15,
  t0.`test` AS test_16,
  t0.`bid` AS bid_17,
  t0.`email` AS email_18,
  t0.`salt` AS salt_19,
  t0.`username` AS username_20,
  t0.`roles` AS roles_21,
  t0.`enabled` AS enabled_22,
  t0.`confirmation_token` AS confirmation_token_23,
  t0.`last_login` AS last_login_24,
  t0.`created_at` AS created_at_25,
  t0.`lang` AS lang_26,
  t27.`foreign_alias` AS foreign_alias_28,
  t27.user_id AS user_id_29,
  t30.`google_id` AS google_id_31,
  t30.`facebook_id` AS facebook_id_32,
  t30.`vk_id` AS vk_id_33,
  t30.`instagram_id` AS instagram_id_34,
  t30.user_id AS user_id_35
FROM
  `user` t0
  LEFT JOIN `user_foreign_alias` t27 ON t27.user_id = t0.id
  LEFT JOIN `user_social_network` t30 ON t30.user_id = t0.id
WHERE
  t0.`token` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`corporate_unid` AS corporate_unid_3, t0.`token` AS token_4, t0.`is_active` AS is_active_5, t0.`proved` AS proved_6, t0.`alias` AS alias_7, t0.`lotus_name` AS lotus_name_8, t0.`security_field` AS security_field_9, t0.`is_legal_entity` AS is_legal_entity_10, t0.`companyName` AS companyName_11, t0.`vatNumber` AS vatNumber_12, t0.`password` AS password_13, t0.`last_ip` AS last_ip_14, t0.`source` AS source_15, t0.`test` AS test_16, t0.`bid` AS bid_17, t0.`email` AS email_18, t0.`salt` AS salt_19, t0.`username` AS username_20, t0.`roles` AS roles_21, t0.`enabled` AS enabled_22, t0.`confirmation_token` AS confirmation_token_23, t0.`last_login` AS last_login_24, t0.`created_at` AS created_at_25, t0.`lang` AS lang_26, t27.`foreign_alias` AS foreign_alias_28, t27.user_id AS user_id_29, t30.`google_id` AS google_id_31, t30.`facebook_id` AS facebook_id_32, t30.`vk_id` AS vk_id_33, t30.`instagram_id` AS instagram_id_34, t30.user_id AS user_id_35 FROM `user` t0 LEFT JOIN `user_foreign_alias` t27 ON t27.user_id = t0.id LEFT JOIN `user_social_network` t30 ON t30.user_id = t0.id WHERE t0.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' LIMIT 1;

SELECT
  l0_.`id` AS id_0,
  l0_.`code` AS code_1,
  l0_.`locale` AS locale_2,
  l0_.`phone_code` AS phone_code_3,
  l0_.`phone_mask` AS phone_mask_4,
  l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5,
  l0_.`zip_code_mask` AS zip_code_mask_6,
  l0_.`percent_vat` AS percent_vat_7,
  l0_.`name` AS name_8,
  l0_.`name_en` AS name_en_9,
  l0_.`alias` AS alias_10,
  l0_.`sort` AS sort_11,
  l0_.`count` AS count_12,
  l0_.`hide` AS hide_13,
  l0_.`important` AS important_14,
  l0_.`pay_pal_percent` AS pay_pal_percent_15,
  l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16,
  l0_.`vat` AS vat_17,
  l0_.`pv_type` AS pv_type_18,
  l0_.`capital_timezone_diff` AS capital_timezone_diff_19,
  l0_.`capital` AS capital_20,
  l0_.`free_sample_delivery` AS free_sample_delivery_21,
  l0_.`units` AS units_22
FROM
  `list_country` l0_
WHERE
  l0_.`code` = ?
  OR l0_.`id` = ?
LIMIT
  1

SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`code` = 'us' OR l0_.`id` = 'us' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`portal_login` AS portal_login_2,
  t0.`ava_file_name` AS ava_file_name_3,
  t0.`name_for_chat` AS name_for_chat_4,
  t0.`email` AS email_5,
  t0.`sex` AS sex_6
FROM
  `consultant` t0
WHERE
  t0.`portal_login` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = 'iyarosh' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`lang` AS lang_2,
  t0.`start_day` AS start_day_3,
  t0.`end_day` AS end_day_4,
  t0.`start_hour` AS start_hour_5,
  t0.`end_hour` AS end_hour_6,
  t0.`phone` AS phone_7,
  t0.`email` AS email_8,
  t0.`twilio_id` AS twilio_id_9,
  t0.`work_days` AS work_days_10,
  t0.country_id AS country_id_11
FROM
  `country_and_lang_specific_data` t0
WHERE
  t0.`lang` = ?
  AND t0.country_id = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = 'en' AND t0.country_id = 840 LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`portal_login` AS portal_login_2,
  t0.`ava_file_name` AS ava_file_name_3,
  t0.`name_for_chat` AS name_for_chat_4,
  t0.`email` AS email_5,
  t0.`sex` AS sex_6
FROM
  `consultant` t0
WHERE
  t0.`portal_login` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = 'iyarosh' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`unid` AS unid_2,
  t0.`corporate_unid` AS corporate_unid_3,
  t0.`token` AS token_4,
  t0.`is_active` AS is_active_5,
  t0.`proved` AS proved_6,
  t0.`alias` AS alias_7,
  t0.`lotus_name` AS lotus_name_8,
  t0.`security_field` AS security_field_9,
  t0.`is_legal_entity` AS is_legal_entity_10,
  t0.`companyName` AS companyName_11,
  t0.`vatNumber` AS vatNumber_12,
  t0.`password` AS password_13,
  t0.`last_ip` AS last_ip_14,
  t0.`source` AS source_15,
  t0.`test` AS test_16,
  t0.`bid` AS bid_17,
  t0.`email` AS email_18,
  t0.`salt` AS salt_19,
  t0.`username` AS username_20,
  t0.`roles` AS roles_21,
  t0.`enabled` AS enabled_22,
  t0.`confirmation_token` AS confirmation_token_23,
  t0.`last_login` AS last_login_24,
  t0.`created_at` AS created_at_25,
  t0.`lang` AS lang_26,
  t27.`foreign_alias` AS foreign_alias_28,
  t27.user_id AS user_id_29,
  t30.`google_id` AS google_id_31,
  t30.`facebook_id` AS facebook_id_32,
  t30.`vk_id` AS vk_id_33,
  t30.`instagram_id` AS instagram_id_34,
  t30.user_id AS user_id_35
FROM
  `user` t0
  LEFT JOIN `user_foreign_alias` t27 ON t27.user_id = t0.id
  LEFT JOIN `user_social_network` t30 ON t30.user_id = t0.id
WHERE
  t0.`token` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`corporate_unid` AS corporate_unid_3, t0.`token` AS token_4, t0.`is_active` AS is_active_5, t0.`proved` AS proved_6, t0.`alias` AS alias_7, t0.`lotus_name` AS lotus_name_8, t0.`security_field` AS security_field_9, t0.`is_legal_entity` AS is_legal_entity_10, t0.`companyName` AS companyName_11, t0.`vatNumber` AS vatNumber_12, t0.`password` AS password_13, t0.`last_ip` AS last_ip_14, t0.`source` AS source_15, t0.`test` AS test_16, t0.`bid` AS bid_17, t0.`email` AS email_18, t0.`salt` AS salt_19, t0.`username` AS username_20, t0.`roles` AS roles_21, t0.`enabled` AS enabled_22, t0.`confirmation_token` AS confirmation_token_23, t0.`last_login` AS last_login_24, t0.`created_at` AS created_at_25, t0.`lang` AS lang_26, t27.`foreign_alias` AS foreign_alias_28, t27.user_id AS user_id_29, t30.`google_id` AS google_id_31, t30.`facebook_id` AS facebook_id_32, t30.`vk_id` AS vk_id_33, t30.`instagram_id` AS instagram_id_34, t30.user_id AS user_id_35 FROM `user` t0 LEFT JOIN `user_foreign_alias` t27 ON t27.user_id = t0.id LEFT JOIN `user_social_network` t30 ON t30.user_id = t0.id WHERE t0.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' LIMIT 1;

SELECT
  l0_.`id` AS id_0,
  l0_.`code` AS code_1,
  l0_.`locale` AS locale_2,
  l0_.`phone_code` AS phone_code_3,
  l0_.`phone_mask` AS phone_mask_4,
  l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5,
  l0_.`zip_code_mask` AS zip_code_mask_6,
  l0_.`percent_vat` AS percent_vat_7,
  l0_.`name` AS name_8,
  l0_.`name_en` AS name_en_9,
  l0_.`alias` AS alias_10,
  l0_.`sort` AS sort_11,
  l0_.`count` AS count_12,
  l0_.`hide` AS hide_13,
  l0_.`important` AS important_14,
  l0_.`pay_pal_percent` AS pay_pal_percent_15,
  l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16,
  l0_.`vat` AS vat_17,
  l0_.`pv_type` AS pv_type_18,
  l0_.`capital_timezone_diff` AS capital_timezone_diff_19,
  l0_.`capital` AS capital_20,
  l0_.`free_sample_delivery` AS free_sample_delivery_21,
  l0_.`units` AS units_22
FROM
  `list_country` l0_
WHERE
  l0_.`code` = ?
  OR l0_.`id` = ?
LIMIT
  1

SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`code` = 'us' OR l0_.`id` = 'us' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`portal_login` AS portal_login_2,
  t0.`ava_file_name` AS ava_file_name_3,
  t0.`name_for_chat` AS name_for_chat_4,
  t0.`email` AS email_5,
  t0.`sex` AS sex_6
FROM
  `consultant` t0
WHERE
  t0.`portal_login` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = 'iyarosh' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`lang` AS lang_2,
  t0.`start_day` AS start_day_3,
  t0.`end_day` AS end_day_4,
  t0.`start_hour` AS start_hour_5,
  t0.`end_hour` AS end_hour_6,
  t0.`phone` AS phone_7,
  t0.`email` AS email_8,
  t0.`twilio_id` AS twilio_id_9,
  t0.`work_days` AS work_days_10,
  t0.country_id AS country_id_11
FROM
  `country_and_lang_specific_data` t0
WHERE
  t0.`lang` = ?
  AND t0.country_id = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = 'en' AND t0.country_id = 840 LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`portal_login` AS portal_login_2,
  t0.`ava_file_name` AS ava_file_name_3,
  t0.`name_for_chat` AS name_for_chat_4,
  t0.`email` AS email_5,
  t0.`sex` AS sex_6
FROM
  `consultant` t0
WHERE
  t0.`portal_login` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = 'iyarosh' LIMIT 1;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND c0_.country_id = ?
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 2 AND c0_.country_id = 840 ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND (
    c0_.country_id IS NULL
    OR c0_.country_id = 0
    OR c0_.country_id = 'en'
  )
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 2 AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND c0_.country_id = ?
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 3 AND c0_.country_id = 840 ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  c0_.`id` AS id_0,
  c0_.`special_date_start` AS special_date_start_1,
  c0_.`special_date_end` AS special_date_end_2,
  c0_.`is_working` AS is_working_3,
  c0_.`mode` AS mode_4,
  c0_.`mode_holiday` AS mode_holiday_5,
  c0_.`lang` AS lang_6,
  c0_.`timeZoneName` AS timeZoneName_7,
  c0_.country_id AS country_id_8,
  c0_.blog_id AS blog_id_9
FROM
  `calendar` c0_
WHERE
  c0_.`special_date_start` <= ?
  AND c0_.`special_date_end` >= ?
  AND c0_.`is_working` = ?
  AND (
    c0_.country_id IS NULL
    OR c0_.country_id = 0
    OR c0_.country_id = 'en'
  )
ORDER BY
  c0_.`special_date_start` ASC
LIMIT
  100

SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= '2026-03-01' AND c0_.`special_date_end` >= '2026-01-29' AND c0_.`is_working` = 3 AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100;

SELECT
  u0_.`id` AS id_0,
  u0_.`unid` AS unid_1,
  u0_.`corporate_unid` AS corporate_unid_2,
  u0_.`token` AS token_3,
  u0_.`is_active` AS is_active_4,
  u0_.`proved` AS proved_5,
  u0_.`alias` AS alias_6,
  u0_.`lotus_name` AS lotus_name_7,
  u0_.`security_field` AS security_field_8,
  u0_.`is_legal_entity` AS is_legal_entity_9,
  u0_.`companyName` AS companyName_10,
  u0_.`vatNumber` AS vatNumber_11,
  u0_.`password` AS password_12,
  u0_.`last_ip` AS last_ip_13,
  u0_.`source` AS source_14,
  u0_.`test` AS test_15,
  u0_.`bid` AS bid_16,
  u0_.`email` AS email_17,
  u0_.`salt` AS salt_18,
  u0_.`username` AS username_19,
  u0_.`roles` AS roles_20,
  u0_.`enabled` AS enabled_21,
  u0_.`confirmation_token` AS confirmation_token_22,
  u0_.`last_login` AS last_login_23,
  u0_.`created_at` AS created_at_24,
  u0_.`lang` AS lang_25
FROM
  `user` u0_
WHERE
  u0_.`token` = ?
LIMIT
  1

SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`lotus_name` AS lotus_name_7, u0_.`security_field` AS security_field_8, u0_.`is_legal_entity` AS is_legal_entity_9, u0_.`companyName` AS companyName_10, u0_.`vatNumber` AS vatNumber_11, u0_.`password` AS password_12, u0_.`last_ip` AS last_ip_13, u0_.`source` AS source_14, u0_.`test` AS test_15, u0_.`bid` AS bid_16, u0_.`email` AS email_17, u0_.`salt` AS salt_18, u0_.`username` AS username_19, u0_.`roles` AS roles_20, u0_.`enabled` AS enabled_21, u0_.`confirmation_token` AS confirmation_token_22, u0_.`last_login` AS last_login_23, u0_.`created_at` AS created_at_24, u0_.`lang` AS lang_25 FROM `user` u0_ WHERE u0_.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' LIMIT 1;

SELECT
  COUNT(b0_.`code`) AS sclr_0
FROM
  `buy_order` b1_
  LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id
WHERE
  b1_.`token` = ?
  AND b1_.`status` <> 12

SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' AND b1_.`status` <> 12;

SELECT
  b0_.`id` AS id_0
FROM
  `buy_order` b0_
WHERE
  b0_.`token` = ?
  AND b0_.`status` <> 12

SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' AND b0_.`status` <> 12;

SELECT
  COUNT(v0_.`id`) AS sclr_0
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` <> '/.*catalog.*/'

SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = '54cb791b60a903826e7189f7661412a4b97992746465564745c5b5fc62b90e42' AND v0_.`url` <> '/.*catalog.*/';

SELECT
  COUNT(i0_.`id`) AS sclr_0
FROM
  `idea` i1_
  INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id
  INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id
WHERE
  i1_.`token` = ?