Query Metrics
11
Database Queries
8
Different statements
6.28 ms
Query time
0
Invalid entities
86
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.25 ms (51.79%) |
1 |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.content AS content_3, f0_.attachment_path AS attachment_path_4, f0_.is_pinned AS is_pinned_5, f0_.is_locked AS is_locked_6, f0_.status AS status_7, f0_.view_count AS view_count_8, f0_.reply_count AS reply_count_9, f0_.last_reply_at AS last_reply_at_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.category_id AS category_id_13, f0_.user_id AS user_id_14 FROM forum_topic f0_ WHERE f0_.category_id = ? AND f0_.status = ? ORDER BY f0_.is_pinned DESC, f0_.last_reply_at DESC, f0_.created_at DESC LIMIT 20
Parameters:
[ 1 "approved" ]
|
||||||||||||||||||||||||||
|
1.20 ms (19.09%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.format AS format_3, t0.image_url AS image_url_4, t0.link_url AS link_url_5, t0.alt_text AS alt_text_6, t0.dimensions AS dimensions_7, t0.css_class AS css_class_8, t0.custom_style AS custom_style_9, t0.html_content AS html_content_10, t0.header_image AS header_image_11, t0.background_color AS background_color_12, t0.gradient_end_color AS gradient_end_color_13, t0.advert_title AS advert_title_14, t0.description AS description_15, t0.cta_text AS cta_text_16, t0.impression_count AS impression_count_17, t0.click_count AS click_count_18, t0.is_active AS is_active_19, t0.advert_target AS advert_target_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_by_id AS created_by_id_23 FROM advert t0 WHERE t0.is_active = ? AND t0.advert_target = ? ORDER BY t0.created_at DESC
Parameters:
[ 1 "gallery" ]
|
||||||||||||||||||||||||||
|
0.51 ms (8.13%) |
2 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.slug AS slug_2, g0_.source_type AS source_type_3, g0_.status AS status_4, g0_.filter_config AS filter_config_5, g0_.created_at AS created_at_6, g0_.updated_at AS updated_at_7 FROM gallery g0_ WHERE g0_.slug = ? AND g0_.status = ?
Parameters:
[ "top5" 10 ] |
||||||||||||||||||||||||||
|
0.43 ms (6.83%) |
2 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC
Parameters:
[ 1780473936 1780473936 "header" ] |
||||||||||||||||||||||||||
|
0.25 ms (4.04%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||
|
0.25 ms (3.93%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6 FROM forum_category t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "team-pret" 1 ]
|
||||||||||||||||||||||||||
|
0.20 ms (3.20%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.slug AS slug_3, t0.auth_key AS auth_key_4, t0.password_hash AS password_hash_5, t0.password_reset_token AS password_reset_token_6, t0.email AS email_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.verification_token AS verification_token_11, t0.role AS role_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.phone AS phone_15, t0.whatsapp_number AS whatsapp_number_16, t0.website AS website_17, t0.address AS address_18, t0.bio AS bio_19, t0.profile_image AS profile_image_20, t0.avatar_path AS avatar_path_21, t0.social_links AS social_links_22, t0.two_factor_enabled AS two_factor_enabled_23, t0.two_factor_secret AS two_factor_secret_24, t0.two_factor_backup_codes AS two_factor_backup_codes_25, t0.failed_login_attempts AS failed_login_attempts_26, t0.locked_until AS locked_until_27, t0.last_failed_login AS last_failed_login_28, t0.billing_address AS billing_address_29, t0.total_points AS total_points_30, t0.is_deactivated AS is_deactivated_31, t0.deactivated_at AS deactivated_at_32, t0.referred_by AS referred_by_33, t0.is_approved AS is_approved_34, t0.approved_at AS approved_at_35, t0.approved_by AS approved_by_36 FROM user t0 WHERE t0.id = ?
Parameters:
[
658
]
|
||||||||||||||||||||||||||
|
0.19 ms (2.98%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC
Parameters:
[] |
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\Area | 76 |
| App\Entity\Service | 4 |
| App\Entity\User | 2 |
| App\Entity\Advert | 2 |
| App\Entity\ForumCategory | 1 |
| App\Entity\ForumTopic | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ForumCategory | No errors. |
| App\Entity\ForumTopic | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ForumReply | No errors. |
| App\Entity\Advert | No errors. |
| App\Entity\Area | No errors. |
| App\Entity\ProfileArea | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\ProfileService | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\Favorite | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\SocialAuth | No errors. |
| App\Entity\UserTier | No errors. |
| App\Entity\Gallery | No errors. |