Query Metrics
5
Database Queries
3
Different statements
4.03 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.31 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.54 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
]
|
||||||||||||||||||||||||||||
| 3 | 0.59 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.63 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
]
|
||||||||||||||||||||||||||||
| 5 | 0.96 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
]
|
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
| Class | Mapping errors |
|---|---|
| App\Entity\Environment | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CookiesCategory | No errors. |
| App\Entity\Cookie | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\Campaign | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\ElectroluxCodes | No errors. |
| App\Entity\Upload | No errors. |
| App\Entity\ElectroluxPlc | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Catalog | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\CreditNote | No errors. |