Query Metrics
2
Database Queries
2
Different statements
2.00 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.16 ms (57.73%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.display_name AS display_name_10, b1_.username AS username_11, b1_.email AS email_12, b1_.password AS password_13, b1_.roles AS roles_14, b1_.lastseen_at AS lastseen_at_15, b1_.last_ip AS last_ip_16, b1_.locale AS locale_17, b1_.backend_theme AS backend_theme_18, b1_.status AS status_19, b1_.avatar AS avatar_20, b1_.about AS about_21, b2_.id AS id_22, b2_.type AS type_23, b2_.slug AS slug_24, b2_.name AS name_25, b2_.sortorder AS sortorder_26 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id WHERE b2_.type = ? AND b2_.slug = ? AND b0_.status = ?) dctrn_result LIMIT 6
Parameters:
[ "categories" "news" "published" ] |
|
0.85 ms (42.27%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.display_name AS display_name_10, b1_.username AS username_11, b1_.email AS email_12, b1_.password AS password_13, b1_.roles AS roles_14, b1_.lastseen_at AS lastseen_at_15, b1_.last_ip AS last_ip_16, b1_.locale AS locale_17, b1_.backend_theme AS backend_theme_18, b1_.status AS status_19, b1_.avatar AS avatar_20, b1_.about AS about_21, b2_.id AS id_22, b2_.type AS type_23, b2_.slug AS slug_24, b2_.name AS name_25, b2_.sortorder AS sortorder_26 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id WHERE b2_.type = ? AND b2_.slug = ? AND b0_.status = ?) dctrn_result) dctrn_table
Parameters:
[ "categories" "news" "published" ] |
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| Bolt\Entity\Content | No errors. |
| Bolt\Entity\User | No errors. |
| Bolt\Entity\Taxonomy | No errors. |