Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.fop_data AS fop_data_2,
  t0.fop AS fop_3,
  t0.offert AS offert_4,
  t0.sir_trevor_content AS sir_trevor_content_5,
  t0.tax_active AS tax_active_6,
  t0.checkbox_enabled AS checkbox_enabled_7,
  t0.checkbox_login AS checkbox_login_8,
  t0.checkbox_pass AS checkbox_pass_9,
  t0.checkbox_secret AS checkbox_secret_10,
  t0.title AS title_11,
  t0.mail_description AS mail_description_12,
  t0.background_color AS background_color_13,
  t0.way_for_pay_account AS way_for_pay_account_14,
  t0.way_for_pay_secret AS way_for_pay_secret_15,
  t0.button_color AS button_color_16,
  t0.button_border AS button_border_17,
  t0.text_button_color AS text_button_color_18,
  t0.fonts AS fonts_19,
  t0.font_family AS font_family_20,
  t0.not_filled_button_color AS not_filled_button_color_21,
  t0.not_filled_button_border AS not_filled_button_border_22,
  t0.not_filled_button_text_color AS not_filled_button_text_color_23,
  t0.link_text_color AS link_text_color_24,
  t0.back_button_color AS back_button_color_25,
  t0.timer_text_color AS timer_text_color_26,
  t0.tariff_background_color AS tariff_background_color_27,
  t0.tariff_text_color AS tariff_text_color_28,
  t0.tariff_text_align AS tariff_text_align_29,
  t0.title_text_color AS title_text_color_30,
  t0.title_text_align AS title_text_align_31,
  t0.second_title_text_color AS second_title_text_color_32,
  t0.second_title_text_align AS second_title_text_align_33,
  t0.description_text_align AS description_text_align_34,
  t0.tariff_style_type AS tariff_style_type_35,
  t0.random_operators AS random_operators_36,
  t0.random_operators_from AS random_operators_from_37,
  t0.random_operators_to AS random_operators_to_38,
  t0.payment_description AS payment_description_39,
  t0.payment_description_kyivstar AS payment_description_kyivstar_40,
  t0.payment_type AS payment_type_41,
  t0.footer_email AS footer_email_42,
  t0.footer_phone AS footer_phone_43,
  t0.display_version AS display_version_44,
  t0.custom_scripts AS custom_scripts_45,
  t0.promo_code_visible AS promo_code_visible_46,
  t0.header_visible AS header_visible_47,
  t0.footer_visible AS footer_visible_48,
  t0.slug AS slug_49,
  t0.created_at AS created_at_50,
  t0.updated_at AS updated_at_51,
  t0.active AS active_52,
  t0.main_image_id AS main_image_id_53,
  t0.favicon_id AS favicon_id_54
FROM
  company t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fop_data AS fop_data_2, t0.fop AS fop_3, t0.offert AS offert_4, t0.sir_trevor_content AS sir_trevor_content_5, t0.tax_active AS tax_active_6, t0.checkbox_enabled AS checkbox_enabled_7, t0.checkbox_login AS checkbox_login_8, t0.checkbox_pass AS checkbox_pass_9, t0.checkbox_secret AS checkbox_secret_10, t0.title AS title_11, t0.mail_description AS mail_description_12, t0.background_color AS background_color_13, t0.way_for_pay_account AS way_for_pay_account_14, t0.way_for_pay_secret AS way_for_pay_secret_15, t0.button_color AS button_color_16, t0.button_border AS button_border_17, t0.text_button_color AS text_button_color_18, t0.fonts AS fonts_19, t0.font_family AS font_family_20, t0.not_filled_button_color AS not_filled_button_color_21, t0.not_filled_button_border AS not_filled_button_border_22, t0.not_filled_button_text_color AS not_filled_button_text_color_23, t0.link_text_color AS link_text_color_24, t0.back_button_color AS back_button_color_25, t0.timer_text_color AS timer_text_color_26, t0.tariff_background_color AS tariff_background_color_27, t0.tariff_text_color AS tariff_text_color_28, t0.tariff_text_align AS tariff_text_align_29, t0.title_text_color AS title_text_color_30, t0.title_text_align AS title_text_align_31, t0.second_title_text_color AS second_title_text_color_32, t0.second_title_text_align AS second_title_text_align_33, t0.description_text_align AS description_text_align_34, t0.tariff_style_type AS tariff_style_type_35, t0.random_operators AS random_operators_36, t0.random_operators_from AS random_operators_from_37, t0.random_operators_to AS random_operators_to_38, t0.payment_description AS payment_description_39, t0.payment_description_kyivstar AS payment_description_kyivstar_40, t0.payment_type AS payment_type_41, t0.footer_email AS footer_email_42, t0.footer_phone AS footer_phone_43, t0.display_version AS display_version_44, t0.custom_scripts AS custom_scripts_45, t0.promo_code_visible AS promo_code_visible_46, t0.header_visible AS header_visible_47, t0.footer_visible AS footer_visible_48, t0.slug AS slug_49, t0.created_at AS created_at_50, t0.updated_at AS updated_at_51, t0.active AS active_52, t0.main_image_id AS main_image_id_53, t0.favicon_id AS favicon_id_54 FROM company t0 WHERE t0.slug = 'esim' AND t0.active = 1 LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.description AS description_2,
  o0_.top_up_link AS top_up_link_3,
  o0_.price_text AS price_text_4,
  o0_.slug AS slug_5,
  o0_.type AS type_6,
  o0_.min_number_qty AS min_number_qty_7,
  o0_.position AS position_8,
  o0_.purchase_limit AS purchase_limit_9,
  o0_.is_server_active AS is_server_active_10,
  o0_.inactive_text AS inactive_text_11,
  o0_.created_at AS created_at_12,
  o0_.updated_at AS updated_at_13,
  o0_.active AS active_14,
  t1_.id AS id_15,
  t1_.promo_image_url AS promo_image_url_16,
  t1_.active AS active_17,
  t1_.name AS name_18,
  t1_.price AS price_19,
  t1_.sale_price AS sale_price_20,
  t1_.in_feed AS in_feed_21,
  t1_.in_stock AS in_stock_22,
  t1_.info_code AS info_code_23,
  t1_.subscription AS subscription_24,
  t1_.description AS description_25,
  t1_.image_link AS image_link_26,
  t1_.api_code AS api_code_27,
  t1_.bottom_description AS bottom_description_28,
  t1_.short_description AS short_description_29,
  t1_.slug AS slug_30,
  t1_.reference AS reference_31,
  t1_.short_info AS short_info_32,
  t1_.detailed_info AS detailed_info_33,
  t1_.details_button_text AS details_button_text_34,
  t1_.details_button_url AS details_button_url_35,
  t1_.created_at AS created_at_36,
  t1_.updated_at AS updated_at_37,
  t1_.main_image_id AS main_image_id_38,
  t1_.promo_image_id AS promo_image_id_39,
  t1_.desktop_selection_image_id AS desktop_selection_image_id_40,
  t1_.mobile_selection_image_id AS mobile_selection_image_id_41,
  t1_.operator_id AS operator_id_42
FROM
  operator o0_
  LEFT JOIN tariff t1_ ON o0_.id = t1_.operator_id
  AND (t1_.active = ?)
WHERE
  o0_.slug = ?
  AND EXISTS (
    SELECT
      1
    FROM
      operators_companies o2_
    WHERE
      o2_.operator_id = o0_.id
      AND o2_.company_id IN (?)
  )
  AND (
    EXISTS (
      SELECT
        1
      FROM
        tariffs_companies t3_
      WHERE
        t3_.tariff_id = t1_.id
        AND t3_.company_id IN (?)
    )
    OR (
      SELECT
        COUNT(*)
      FROM
        tariffs_companies t3_
      WHERE
        t3_.tariff_id = t1_.id
    ) = 0
  )
  AND o0_.active = ?
  AND o0_.is_server_active = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.description AS description_2, o0_.top_up_link AS top_up_link_3, o0_.price_text AS price_text_4, o0_.slug AS slug_5, o0_.type AS type_6, o0_.min_number_qty AS min_number_qty_7, o0_.position AS position_8, o0_.purchase_limit AS purchase_limit_9, o0_.is_server_active AS is_server_active_10, o0_.inactive_text AS inactive_text_11, o0_.created_at AS created_at_12, o0_.updated_at AS updated_at_13, o0_.active AS active_14, t1_.id AS id_15, t1_.promo_image_url AS promo_image_url_16, t1_.active AS active_17, t1_.name AS name_18, t1_.price AS price_19, t1_.sale_price AS sale_price_20, t1_.in_feed AS in_feed_21, t1_.in_stock AS in_stock_22, t1_.info_code AS info_code_23, t1_.subscription AS subscription_24, t1_.description AS description_25, t1_.image_link AS image_link_26, t1_.api_code AS api_code_27, t1_.bottom_description AS bottom_description_28, t1_.short_description AS short_description_29, t1_.slug AS slug_30, t1_.reference AS reference_31, t1_.short_info AS short_info_32, t1_.detailed_info AS detailed_info_33, t1_.details_button_text AS details_button_text_34, t1_.details_button_url AS details_button_url_35, t1_.created_at AS created_at_36, t1_.updated_at AS updated_at_37, t1_.main_image_id AS main_image_id_38, t1_.promo_image_id AS promo_image_id_39, t1_.desktop_selection_image_id AS desktop_selection_image_id_40, t1_.mobile_selection_image_id AS mobile_selection_image_id_41, t1_.operator_id AS operator_id_42 FROM operator o0_ LEFT JOIN tariff t1_ ON o0_.id = t1_.operator_id AND (t1_.active = 1) WHERE o0_.slug = 'lifecell' AND EXISTS (SELECT 1 FROM operators_companies o2_ WHERE o2_.operator_id = o0_.id AND o2_.company_id IN (3)) AND (EXISTS (SELECT 1 FROM tariffs_companies t3_ WHERE t3_.tariff_id = t1_.id AND t3_.company_id IN (3)) OR (SELECT COUNT(*) FROM tariffs_companies t3_ WHERE t3_.tariff_id = t1_.id) = 0) AND o0_.active = 1 AND o0_.is_server_active = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_ip (
  event_type, ip, operator, tariff, user,
  register_email, order_reference,
  created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_ip (event_type, ip, operator, tariff, user, register_email, order_reference, created_at, updated_at) VALUES ('2', '216.73.216.228', 'lifecell', NULL, NULL, NULL, NULL, '2026-08-17 20:53:32', '2026-08-17 20:53:32');

"COMMIT"

"COMMIT";

SELECT
  t0_.id AS id_0,
  t0_.promo_image_url AS promo_image_url_1,
  t0_.active AS active_2,
  t0_.name AS name_3,
  t0_.price AS price_4,
  t0_.sale_price AS sale_price_5,
  t0_.in_feed AS in_feed_6,
  t0_.in_stock AS in_stock_7,
  t0_.info_code AS info_code_8,
  t0_.subscription AS subscription_9,
  t0_.description AS description_10,
  t0_.image_link AS image_link_11,
  t0_.api_code AS api_code_12,
  t0_.bottom_description AS bottom_description_13,
  t0_.short_description AS short_description_14,
  t0_.slug AS slug_15,
  t0_.reference AS reference_16,
  t0_.short_info AS short_info_17,
  t0_.detailed_info AS detailed_info_18,
  t0_.details_button_text AS details_button_text_19,
  t0_.details_button_url AS details_button_url_20,
  t0_.created_at AS created_at_21,
  t0_.updated_at AS updated_at_22,
  t0_.main_image_id AS main_image_id_23,
  t0_.promo_image_id AS promo_image_id_24,
  t0_.desktop_selection_image_id AS desktop_selection_image_id_25,
  t0_.mobile_selection_image_id AS mobile_selection_image_id_26,
  t0_.operator_id AS operator_id_27
FROM
  tariff t0_
  INNER JOIN operator o1_ ON t0_.operator_id = o1_.id
WHERE
  t0_.operator_id = ?
  AND EXISTS (
    SELECT
      1
    FROM
      operators_companies o2_
    WHERE
      o2_.operator_id = o1_.id
      AND o2_.company_id IN (?)
  )
  AND (
    EXISTS (
      SELECT
        1
      FROM
        tariffs_companies t3_
      WHERE
        t3_.tariff_id = t0_.id
        AND t3_.company_id IN (?)
    )
    OR (
      SELECT
        COUNT(*)
      FROM
        tariffs_companies t3_
      WHERE
        t3_.tariff_id = t0_.id
    ) = 0
  )
  AND o1_.active = ?
  AND t0_.active = ?

SELECT t0_.id AS id_0, t0_.promo_image_url AS promo_image_url_1, t0_.active AS active_2, t0_.name AS name_3, t0_.price AS price_4, t0_.sale_price AS sale_price_5, t0_.in_feed AS in_feed_6, t0_.in_stock AS in_stock_7, t0_.info_code AS info_code_8, t0_.subscription AS subscription_9, t0_.description AS description_10, t0_.image_link AS image_link_11, t0_.api_code AS api_code_12, t0_.bottom_description AS bottom_description_13, t0_.short_description AS short_description_14, t0_.slug AS slug_15, t0_.reference AS reference_16, t0_.short_info AS short_info_17, t0_.detailed_info AS detailed_info_18, t0_.details_button_text AS details_button_text_19, t0_.details_button_url AS details_button_url_20, t0_.created_at AS created_at_21, t0_.updated_at AS updated_at_22, t0_.main_image_id AS main_image_id_23, t0_.promo_image_id AS promo_image_id_24, t0_.desktop_selection_image_id AS desktop_selection_image_id_25, t0_.mobile_selection_image_id AS mobile_selection_image_id_26, t0_.operator_id AS operator_id_27 FROM tariff t0_ INNER JOIN operator o1_ ON t0_.operator_id = o1_.id WHERE t0_.operator_id = 4 AND EXISTS (SELECT 1 FROM operators_companies o2_ WHERE o2_.operator_id = o1_.id AND o2_.company_id IN (3)) AND (EXISTS (SELECT 1 FROM tariffs_companies t3_ WHERE t3_.tariff_id = t0_.id AND t3_.company_id IN (3)) OR (SELECT COUNT(*) FROM tariffs_companies t3_ WHERE t3_.tariff_id = t0_.id) = 0) AND o1_.active = 1 AND t0_.active = 1;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 72;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.position AS position_3,
  t0.title AS title_4,
  t0.sirTrevorContent AS sirTrevorContent_5,
  t0.content AS content_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.meta_title AS meta_title_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.meta_description AS meta_description_11,
  t0.meta_canonical AS meta_canonical_12,
  t0.meta_image_id AS meta_image_id_13
FROM
  meta t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.position AS position_3, t0.title AS title_4, t0.sirTrevorContent AS sirTrevorContent_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.meta_title AS meta_title_9, t0.meta_keywords AS meta_keywords_10, t0.meta_description AS meta_description_11, t0.meta_canonical AS meta_canonical_12, t0.meta_image_id AS meta_image_id_13 FROM meta t0 WHERE t0.type = 4 LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.page AS page_2,
  f0_.position AS position_3,
  f0_.created_at AS created_at_4,
  f0_.updated_at AS updated_at_5,
  f0_.active AS active_6,
  f1_.id AS id_7,
  f1_.answer AS answer_8,
  f1_.created_at AS created_at_9,
  f1_.updated_at AS updated_at_10,
  f0_.operator_id AS operator_id_11,
  f1_.faq_question_id AS faq_question_id_12
FROM
  faq_question f0_
  INNER JOIN faq_answer f1_ ON f0_.id = f1_.faq_question_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      faq_questions_companies f2_
    WHERE
      f2_.question_id = f0_.id
      AND f2_.company_id IN (?)
  )
  AND f0_.active = ?
  AND f0_.page LIKE ?
  AND (
    f0_.operator_id = ?
    OR f0_.operator_id IS NULL
  )
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.page AS page_2, f0_.position AS position_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.active AS active_6, f1_.id AS id_7, f1_.answer AS answer_8, f1_.created_at AS created_at_9, f1_.updated_at AS updated_at_10, f0_.operator_id AS operator_id_11, f1_.faq_question_id AS faq_question_id_12 FROM faq_question f0_ INNER JOIN faq_answer f1_ ON f0_.id = f1_.faq_question_id WHERE EXISTS (SELECT 1 FROM faq_questions_companies f2_ WHERE f2_.question_id = f0_.id AND f2_.company_id IN (3)) AND f0_.active = 1 AND f0_.page LIKE '%\"4\"%' AND (f0_.operator_id = 4 OR f0_.operator_id IS NULL) ORDER BY f0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.display_locations AS display_locations_4,
  t0.active AS active_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.meta_canonical AS meta_canonical_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.meta_image_id AS meta_image_id_13
FROM
  page t0
  INNER JOIN pages_companies ON t0.id = pages_companies.page_id
WHERE
  pages_companies.company_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.display_locations AS display_locations_4, t0.active AS active_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_canonical AS meta_canonical_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.meta_image_id AS meta_image_id_13 FROM page t0 INNER JOIN pages_companies ON t0.id = pages_companies.page_id WHERE pages_companies.company_id = 3;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 88;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 99;