Query Metrics

8 Database Queries
4 Different statements
5.08 ms Query time
0 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 1.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.locale AS locale_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.analytics AS analytics_7, t0.email AS email_8, t0.phone AS phone_9, t0.contact AS contact_10, t0.favicon AS favicon_11, t0.logo AS logo_12, t0.enable_cookies AS enable_cookies_13, t0.cookies_title AS cookies_title_14, t0.cookies_description AS cookies_description_15, t0.cookies_btn_settings AS cookies_btn_settings_16, t0.cookies_btn_allow_all AS cookies_btn_allow_all_17, t0.cookies_btn_confirm AS cookies_btn_confirm_18, t0.cookies_subtitle AS cookies_subtitle_19, t0.cookies_subtitle_description AS cookies_subtitle_description_20, t0.legal_name AS legal_name_21, t0.legal_mode AS legal_mode_22, t0.legal_file AS legal_file_23, t0.legal_url AS legal_url_24, t0.cookies_name AS cookies_name_25, t0.cookies_mode AS cookies_mode_26, t0.cookies_file AS cookies_file_27, t0.cookies_url AS cookies_url_28, t0.privacy_name AS privacy_name_29, t0.privacy_mode AS privacy_mode_30, t0.privacy_file AS privacy_file_31, t0.privacy_url AS privacy_url_32, t0.extra_option AS extra_option_33, t0.extra_name AS extra_name_34, t0.extra_mode AS extra_mode_35, t0.extra_file AS extra_file_36, t0.extra_url AS extra_url_37, t0.logo_header AS logo_header_38, t0.mailing_endpoint AS mailing_endpoint_39, t0.mailing_plan AS mailing_plan_40, t0.mailing_username AS mailing_username_41, t0.mailing_password AS mailing_password_42, t0.mailing_remitent AS mailing_remitent_43, t0.mailing_reset_password_template AS mailing_reset_password_template_44, t0.mailing_reset_password_subject AS mailing_reset_password_subject_45, t0.mailing_new_administrator_template AS mailing_new_administrator_template_46, t0.mailing_new_administrator_subject AS mailing_new_administrator_subject_47, t0.mailing_new_adhere_template AS mailing_new_adhere_template_48, t0.mailing_new_adhere_subject AS mailing_new_adhere_subject_49, t0.mailing_new_adhere_admin_template AS mailing_new_adhere_admin_template_50, t0.mailing_new_adhere_admin_subject AS mailing_new_adhere_admin_subject_51, t0.mailing_validate_adhere_template AS mailing_validate_adhere_template_52, t0.mailing_validate_adhere_subject AS mailing_validate_adhere_subject_53, t0.mailing_reject_adhere_template AS mailing_reject_adhere_template_54, t0.mailing_reject_adhere_subject AS mailing_reject_adhere_subject_55, t0.mailing_contact_template AS mailing_contact_template_56, t0.mailing_contact_subject AS mailing_contact_subject_57, t0.mailing_new_campaign_template AS mailing_new_campaign_template_58, t0.mailing_new_campaign_subject AS mailing_new_campaign_subject_59, t0.mailing_new_payment_template AS mailing_new_payment_template_60, t0.mailing_new_payment_subject AS mailing_new_payment_subject_61, t0.mailing_shop_electrolux_seller_template AS mailing_shop_electrolux_seller_template_62, t0.mailing_shop_electrolux_seller_subject AS mailing_shop_electrolux_seller_subject_63, t0.mailing_pending_shop_template AS mailing_pending_shop_template_64, t0.mailing_pending_shop_subject AS mailing_pending_shop_subject_65, t0.mailing_shop_documentation_updated_template AS mailing_shop_documentation_updated_template_66, t0.mailing_shop_documentation_updated_subject AS mailing_shop_documentation_updated_subject_67, t0.ftp_host AS ftp_host_68, t0.ftp_port AS ftp_port_69, t0.ftp_user AS ftp_user_70, t0.ftp_pwd AS ftp_pwd_71, t0.ftp_folder AS ftp_folder_72, t0.mailing_paid_payment_template AS mailing_paid_payment_template_73, t0.mailing_paid_payment_subject AS mailing_paid_payment_subject_74, t0.captcha_api_key AS captcha_api_key_75, t0.captcha_api_secret AS captcha_api_secret_76, t0.created_by AS created_by_77, t0.updated_by AS updated_by_78 FROM environment t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "electrolux.chequemotivadev.com"
]
2 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.locale AS locale_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.analytics AS analytics_7, t0.email AS email_8, t0.phone AS phone_9, t0.contact AS contact_10, t0.favicon AS favicon_11, t0.logo AS logo_12, t0.enable_cookies AS enable_cookies_13, t0.cookies_title AS cookies_title_14, t0.cookies_description AS cookies_description_15, t0.cookies_btn_settings AS cookies_btn_settings_16, t0.cookies_btn_allow_all AS cookies_btn_allow_all_17, t0.cookies_btn_confirm AS cookies_btn_confirm_18, t0.cookies_subtitle AS cookies_subtitle_19, t0.cookies_subtitle_description AS cookies_subtitle_description_20, t0.legal_name AS legal_name_21, t0.legal_mode AS legal_mode_22, t0.legal_file AS legal_file_23, t0.legal_url AS legal_url_24, t0.cookies_name AS cookies_name_25, t0.cookies_mode AS cookies_mode_26, t0.cookies_file AS cookies_file_27, t0.cookies_url AS cookies_url_28, t0.privacy_name AS privacy_name_29, t0.privacy_mode AS privacy_mode_30, t0.privacy_file AS privacy_file_31, t0.privacy_url AS privacy_url_32, t0.extra_option AS extra_option_33, t0.extra_name AS extra_name_34, t0.extra_mode AS extra_mode_35, t0.extra_file AS extra_file_36, t0.extra_url AS extra_url_37, t0.logo_header AS logo_header_38, t0.mailing_endpoint AS mailing_endpoint_39, t0.mailing_plan AS mailing_plan_40, t0.mailing_username AS mailing_username_41, t0.mailing_password AS mailing_password_42, t0.mailing_remitent AS mailing_remitent_43, t0.mailing_reset_password_template AS mailing_reset_password_template_44, t0.mailing_reset_password_subject AS mailing_reset_password_subject_45, t0.mailing_new_administrator_template AS mailing_new_administrator_template_46, t0.mailing_new_administrator_subject AS mailing_new_administrator_subject_47, t0.mailing_new_adhere_template AS mailing_new_adhere_template_48, t0.mailing_new_adhere_subject AS mailing_new_adhere_subject_49, t0.mailing_new_adhere_admin_template AS mailing_new_adhere_admin_template_50, t0.mailing_new_adhere_admin_subject AS mailing_new_adhere_admin_subject_51, t0.mailing_validate_adhere_template AS mailing_validate_adhere_template_52, t0.mailing_validate_adhere_subject AS mailing_validate_adhere_subject_53, t0.mailing_reject_adhere_template AS mailing_reject_adhere_template_54, t0.mailing_reject_adhere_subject AS mailing_reject_adhere_subject_55, t0.mailing_contact_template AS mailing_contact_template_56, t0.mailing_contact_subject AS mailing_contact_subject_57, t0.mailing_new_campaign_template AS mailing_new_campaign_template_58, t0.mailing_new_campaign_subject AS mailing_new_campaign_subject_59, t0.mailing_new_payment_template AS mailing_new_payment_template_60, t0.mailing_new_payment_subject AS mailing_new_payment_subject_61, t0.mailing_shop_electrolux_seller_template AS mailing_shop_electrolux_seller_template_62, t0.mailing_shop_electrolux_seller_subject AS mailing_shop_electrolux_seller_subject_63, t0.mailing_pending_shop_template AS mailing_pending_shop_template_64, t0.mailing_pending_shop_subject AS mailing_pending_shop_subject_65, t0.mailing_shop_documentation_updated_template AS mailing_shop_documentation_updated_template_66, t0.mailing_shop_documentation_updated_subject AS mailing_shop_documentation_updated_subject_67, t0.ftp_host AS ftp_host_68, t0.ftp_port AS ftp_port_69, t0.ftp_user AS ftp_user_70, t0.ftp_pwd AS ftp_pwd_71, t0.ftp_folder AS ftp_folder_72, t0.mailing_paid_payment_template AS mailing_paid_payment_template_73, t0.mailing_paid_payment_subject AS mailing_paid_payment_subject_74, t0.captcha_api_key AS captcha_api_key_75, t0.captcha_api_secret AS captcha_api_secret_76, t0.created_by AS created_by_77, t0.updated_by AS updated_by_78 FROM environment t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "electrolux.chequemotivadev.com"
]
3 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.mandatory AS mandatory_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.environment_id AS environment_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM cookies_category t0 WHERE t0.environment_id = ?
Parameters:
[
  1
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.mandatory AS mandatory_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.environment_id AS environment_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM cookies_category t0 WHERE t0.environment_id = ?
Parameters:
[
  1
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.type AS type_4, t0.duration AS duration_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.category_id AS category_id_9, t0.environment_id AS environment_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM cookie t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
6 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.type AS type_4, t0.duration AS duration_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.category_id AS category_id_9, t0.environment_id AS environment_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM cookie t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
7 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.locale AS locale_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.analytics AS analytics_7, t0.email AS email_8, t0.phone AS phone_9, t0.contact AS contact_10, t0.favicon AS favicon_11, t0.logo AS logo_12, t0.enable_cookies AS enable_cookies_13, t0.cookies_title AS cookies_title_14, t0.cookies_description AS cookies_description_15, t0.cookies_btn_settings AS cookies_btn_settings_16, t0.cookies_btn_allow_all AS cookies_btn_allow_all_17, t0.cookies_btn_confirm AS cookies_btn_confirm_18, t0.cookies_subtitle AS cookies_subtitle_19, t0.cookies_subtitle_description AS cookies_subtitle_description_20, t0.legal_name AS legal_name_21, t0.legal_mode AS legal_mode_22, t0.legal_file AS legal_file_23, t0.legal_url AS legal_url_24, t0.cookies_name AS cookies_name_25, t0.cookies_mode AS cookies_mode_26, t0.cookies_file AS cookies_file_27, t0.cookies_url AS cookies_url_28, t0.privacy_name AS privacy_name_29, t0.privacy_mode AS privacy_mode_30, t0.privacy_file AS privacy_file_31, t0.privacy_url AS privacy_url_32, t0.extra_option AS extra_option_33, t0.extra_name AS extra_name_34, t0.extra_mode AS extra_mode_35, t0.extra_file AS extra_file_36, t0.extra_url AS extra_url_37, t0.logo_header AS logo_header_38, t0.mailing_endpoint AS mailing_endpoint_39, t0.mailing_plan AS mailing_plan_40, t0.mailing_username AS mailing_username_41, t0.mailing_password AS mailing_password_42, t0.mailing_remitent AS mailing_remitent_43, t0.mailing_reset_password_template AS mailing_reset_password_template_44, t0.mailing_reset_password_subject AS mailing_reset_password_subject_45, t0.mailing_new_administrator_template AS mailing_new_administrator_template_46, t0.mailing_new_administrator_subject AS mailing_new_administrator_subject_47, t0.mailing_new_adhere_template AS mailing_new_adhere_template_48, t0.mailing_new_adhere_subject AS mailing_new_adhere_subject_49, t0.mailing_new_adhere_admin_template AS mailing_new_adhere_admin_template_50, t0.mailing_new_adhere_admin_subject AS mailing_new_adhere_admin_subject_51, t0.mailing_validate_adhere_template AS mailing_validate_adhere_template_52, t0.mailing_validate_adhere_subject AS mailing_validate_adhere_subject_53, t0.mailing_reject_adhere_template AS mailing_reject_adhere_template_54, t0.mailing_reject_adhere_subject AS mailing_reject_adhere_subject_55, t0.mailing_contact_template AS mailing_contact_template_56, t0.mailing_contact_subject AS mailing_contact_subject_57, t0.mailing_new_campaign_template AS mailing_new_campaign_template_58, t0.mailing_new_campaign_subject AS mailing_new_campaign_subject_59, t0.mailing_new_payment_template AS mailing_new_payment_template_60, t0.mailing_new_payment_subject AS mailing_new_payment_subject_61, t0.mailing_shop_electrolux_seller_template AS mailing_shop_electrolux_seller_template_62, t0.mailing_shop_electrolux_seller_subject AS mailing_shop_electrolux_seller_subject_63, t0.mailing_pending_shop_template AS mailing_pending_shop_template_64, t0.mailing_pending_shop_subject AS mailing_pending_shop_subject_65, t0.mailing_shop_documentation_updated_template AS mailing_shop_documentation_updated_template_66, t0.mailing_shop_documentation_updated_subject AS mailing_shop_documentation_updated_subject_67, t0.ftp_host AS ftp_host_68, t0.ftp_port AS ftp_port_69, t0.ftp_user AS ftp_user_70, t0.ftp_pwd AS ftp_pwd_71, t0.ftp_folder AS ftp_folder_72, t0.mailing_paid_payment_template AS mailing_paid_payment_template_73, t0.mailing_paid_payment_subject AS mailing_paid_payment_subject_74, t0.captcha_api_key AS captcha_api_key_75, t0.captcha_api_secret AS captcha_api_secret_76, t0.created_by AS created_by_77, t0.updated_by AS updated_by_78 FROM environment t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "electrolux.chequemotivadev.com"
]
8 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.type AS type_4, t0.duration AS duration_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.category_id AS category_id_9, t0.environment_id AS environment_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM cookie t0 WHERE t0.environment_id = ? AND t0.name = ? LIMIT 1
Parameters:
[
  1
  "_ga"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cookie 8
App\Entity\CookiesCategory 2
App\Entity\Environment 1
App\Entity\User 1

Entities Mapping