Symfony Profiler

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'esim'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'esim' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'esim' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'esim' */ ORDER BY k.ORDINAL_POSITION;

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
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'esim' AND t.TABLE_SCHEMA = 'esim' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

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_.slug = ?
  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 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_.slug = 'delivery' 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 o1_.is_server_active = 1;

SELECT
  DATABASE()

SELECT DATABASE();

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
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'esim' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.content AS content_2,
  p0_.display_locations AS display_locations_3,
  p0_.active AS active_4,
  p0_.meta_title AS meta_title_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.meta_description AS meta_description_7,
  p0_.meta_canonical AS meta_canonical_8,
  p0_.slug AS slug_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.meta_image_id AS meta_image_id_12
FROM
  page p0_
WHERE
  p0_.slug = ?
  AND EXISTS (
    SELECT
      1
    FROM
      pages_companies p1_
    WHERE
      p1_.page_id = p0_.id
      AND p1_.company_id IN (?)
  )
  AND p0_.active = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.display_locations AS display_locations_3, p0_.active AS active_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.meta_description AS meta_description_7, p0_.meta_canonical AS meta_canonical_8, p0_.slug AS slug_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.meta_image_id AS meta_image_id_12 FROM page p0_ WHERE p0_.slug = 'delivery' AND EXISTS (SELECT 1 FROM pages_companies p1_ WHERE p1_.page_id = p0_.id AND p1_.company_id IN (3)) AND p0_.active = 1;

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'esim' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

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
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;