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
  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_.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 t0_.active = ?
  AND o1_.active = ?
  AND o1_.is_server_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_.id = '21' 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 t0_.active = 1 AND o1_.active = 1 AND o1_.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 ('3', '216.73.216.228', NULL, 'Vodafone FLEXX TOP', NULL, NULL, NULL, '2026-08-17 20:54:03', '2026-08-17 20:54:03');

"COMMIT"

"COMMIT";