Query Metrics
13
Database Queries
8
Different statements
3.83 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.50 ms |
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 ] |
| 2 | 0.59 ms |
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 = ?
Parameters:
[ "vodafone-turbo" 3 3 1 1 ] |
| 3 | 0.36 ms |
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 = ?
Parameters:
[
72
]
|
| 4 | 0.22 ms |
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
Parameters:
[
1
]
|
| 5 | 0.41 ms |
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 ? ORDER BY f0_.position ASC
Parameters:
[ 3 1 "%"1"%" ] |
| 6 | 0.44 ms |
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 = ?
Parameters:
[
3
]
|
| 7 | 0.16 ms |
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 = ?
Parameters:
[
88
]
|
| 8 | 0.21 ms |
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 = ?
Parameters:
[
109
]
|
| 9 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.top_up_link AS top_up_link_4, t0.price_text AS price_text_5, t0.slug AS slug_6, t0.type AS type_7, t0.min_number_qty AS min_number_qty_8, t0.position AS position_9, t0.purchase_limit AS purchase_limit_10, t0.is_server_active AS is_server_active_11, t0.inactive_text AS inactive_text_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.active AS active_15 FROM operator t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 10 | 0.36 ms |
SELECT t0.id AS id_1, t0.promo_image_url AS promo_image_url_2, t0.active AS active_3, t0.name AS name_4, t0.price AS price_5, t0.sale_price AS sale_price_6, t0.in_feed AS in_feed_7, t0.in_stock AS in_stock_8, t0.info_code AS info_code_9, t0.subscription AS subscription_10, t0.description AS description_11, t0.image_link AS image_link_12, t0.api_code AS api_code_13, t0.bottom_description AS bottom_description_14, t0.short_description AS short_description_15, t0.slug AS slug_16, t0.reference AS reference_17, t0.short_info AS short_info_18, t0.detailed_info AS detailed_info_19, t0.details_button_text AS details_button_text_20, t0.details_button_url AS details_button_url_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.main_image_id AS main_image_id_24, t0.promo_image_id AS promo_image_id_25, t0.desktop_selection_image_id AS desktop_selection_image_id_26, t0.mobile_selection_image_id AS mobile_selection_image_id_27, t0.operator_id AS operator_id_28 FROM tariff t0 WHERE t0.operator_id = ?
Parameters:
[
3
]
|
| 11 | 0.15 ms |
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 = ?
Parameters:
[
74
]
|
| 12 | 0.14 ms |
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 = ?
Parameters:
[
84
]
|
| 13 | 0.14 ms |
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 = ?
Parameters:
[
73
]
|
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 |
|
| App\Entity\SonataMediaMedia |
|
| 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. |
| App\Entity\PhoneNumber | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\SonataMediaGalleryItem | No errors. |
| App\Entity\Meta | No errors. |
| App\Entity\FaqAnswer | No errors. |