Query Metrics
5
Database Queries
5
Different statements
10.79 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
||||||||||||||||||||||||||||
2 | 1.61 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.hash AS hash_6, t0.deleted_at AS deleted_at_7, t0.reg1 AS reg1_8, t0.reg3 AS reg3_9, t0.reg4 AS reg4_10, t0.reg5 AS reg5_11, t0.password_changed_at AS password_changed_at_12, t0.new_reg AS new_reg_13, t0.first_name AS first_name_14, t0.last_name AS last_name_15, t0.name AS name_16, t0.slug AS slug_17, t0.note AS note_18, t0.facebook_url AS facebook_url_19, t0.linkedin_url AS linkedin_url_20, t0.twitter_url AS twitter_url_21, t0.instagram_url AS instagram_url_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.suspended AS suspended_25, t0.wk AS wk_26, t0.wk_attempts AS wk_attempts_27, t0.reg9 AS reg9_28, t0.google_authenticator_secret AS google_authenticator_secret_29, t0.google_authenticator_complete AS google_authenticator_complete_30, t0.reg10 AS reg10_31, t0.reg11 AS reg11_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.reg6_reg AS reg6_reg_35, t0.reg6_first_name AS reg6_first_name_36, t0.reg6_last_name AS reg6_last_name_37, t0.reg6_pesel AS reg6_pesel_38, t0.reg6_no_pesel AS reg6_no_pesel_39, t0.reg6_other_document AS reg6_other_document_40, t0.reg6_other_document_number AS reg6_other_document_number_41, t0.reg7_reg AS reg7_reg_42, t0.reg7_first_name AS reg7_first_name_43, t0.reg7_last_name AS reg7_last_name_44, t0.reg7_pesel AS reg7_pesel_45, t0.reg7_no_pesel AS reg7_no_pesel_46, t0.reg7_other_document AS reg7_other_document_47, t0.reg7_other_document_number AS reg7_other_document_number_48, t0.reg8_reg AS reg8_reg_49, t0.reg8_first_name AS reg8_first_name_50, t0.reg8_last_name AS reg8_last_name_51, t0.reg8_pesel AS reg8_pesel_52, t0.reg8_no_pesel AS reg8_no_pesel_53, t0.reg8_other_document AS reg8_other_document_54, t0.reg8_other_document_number AS reg8_other_document_number_55, t0.group_id AS group_id_56, t0.avatar_id AS avatar_id_57, t0.site_id AS site_id_58, t0.default_doctor_id AS default_doctor_id_59 FROM user t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"redakcja"
]
|
||||||||||||||||||||||||||||
3 | 3.70 ms |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ?
Parameters:
[ 8 1 ] |
||||||||||||||||||||||||||||
4 | 1.33 ms |
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ? ORDER BY b0_.created_at DESC LIMIT 42
Parameters:
[ 8 1 ] |
||||||||||||||||||||||||||||
5 | 3.32 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.seo_title AS seo_title_5, b0_.seo_description AS seo_description_6, b0_.external_id AS external_id_7, b0_.seo_json AS seo_json_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.sources AS sources_11, b0_.active AS active_12, b0_.publish_at AS publish_at_13, b0_.deleted_at AS deleted_at_14, b0_.thumbnail_id AS thumbnail_id_15, b0_.user_id AS user_id_16 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC
Parameters:
[ 8 1 621 628 716 659 708 514 511 586 721 455 490 462 489 461 459 488 460 458 487 457 486 485 484 579 564 482 481 480 479 478 452 477 476 475 474 446 473 445 499 472 498 471 ] |
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.