Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.23 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.23 ms (100.00%)	2	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 Parameters: [`"esim" 1`] View formatted query View runnable query Explain query 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;

Time▼

Count

Info

1.23 ms
(100.00%)

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

Parameters:

[
  "esim"
  1
]

View formatted query View runnable query Explain query

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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
Sonata\MediaBundle\Entity\BaseMedia	The field 'Sonata\MediaBundle\Entity\BaseMedia#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\SonataMediaMedia	The field 'App\Entity\SonataMediaMedia#length' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Sonata\UserBundle\Entity\BaseUser	No errors.
App\Entity\User	No errors.
App\Entity\Operator	No errors.
App\Entity\Tariff	No errors.
App\Entity\Page	No errors.
App\Entity\FaqQuestion	No errors.
App\Entity\Order	No errors.

Symfony Profiler

https://esim.forforce.com/upload/media/default/0001/01/2e1db444c86330c1c57a65cae43b2791b68c8528.png

Configuration Settings

Theme