Query Metrics
9
Database Queries
9
Different statements
7.82 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.63 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_date AS created_date_4, t0.slug AS slug_5, t0.cover AS cover_6, t0.views AS views_7, t0.published AS published_8, t0.status AS status_9, t0.featured AS featured_10, t0.featured_at AS featured_at_11, t0.original AS original_12, t0.unit AS unit_13, t0.alt_cover AS alt_cover_14, t0.title_seo AS title_seo_15, t0.description_seo AS description_seo_16, t0.published_at AS published_at_17, t0.author_id AS author_id_18, t0.reviewer_id AS reviewer_id_19, t0.website_language_id AS website_language_id_20 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"english-test"
]
|
2 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM website_language t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3 | 0.84 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
270
]
|
4 | 0.92 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_date AS created_date_3, a0_.slug AS slug_4, a0_.cover AS cover_5, a0_.views AS views_6, a0_.published AS published_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.featured_at AS featured_at_10, a0_.original AS original_11, a0_.unit AS unit_12, a0_.alt_cover AS alt_cover_13, a0_.title_seo AS title_seo_14, a0_.description_seo AS description_seo_15, a0_.published_at AS published_at_16, a0_.author_id AS author_id_17, a0_.reviewer_id AS reviewer_id_18, a0_.website_language_id AS website_language_id_19 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE EXISTS (SELECT 1 FROM category_article c2_ WHERE c2_.article_id = a0_.id AND c2_.category_id IN (?)) AND w1_.slug = ? AND a0_.slug NOT LIKE ? AND a0_.published = ? ORDER BY a0_.created_date DESC LIMIT 2
Parameters:
[ 1 "en" "english-test" 1 ] |
5 | 0.63 ms |
SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.telephone AS telephone_3, u0_.email AS email_4, u0_.password AS password_5, u0_.activated AS activated_6, u0_.notification AS notification_7, u0_.registered_at AS registered_at_8, u0_.token AS token_9, u0_.photo AS photo_10, u0_.slug AS slug_11, u0_.is_pro AS is_pro_12, u0_.has_access AS has_access_13, u0_.status AS status_14, u0_.has_accepted_terms AS has_accepted_terms_15, u0_.is_ambassador AS is_ambassador_16, u0_.language AS language_17, u0_.timezone AS timezone_18, u0_.phone_code AS phone_code_19, u0_.newsletter AS newsletter_20, a1_.has_already_logged_in AS has_already_logged_in_21, a1_.need_review AS need_review_22, a1_.is_editor AS is_editor_23, u0_.type AS type_24, u0_.address_id AS address_id_25, u0_.pro_info_id AS pro_info_id_26, u0_.stripe_info_id AS stripe_info_id_27 FROM admin a1_ INNER JOIN user u0_ ON a1_.id = u0_.id WHERE a1_.has_already_logged_in = 1 AND u0_.status = ?
Parameters:
[
"online"
]
|
6 | 0.33 ms |
"START TRANSACTION"
Parameters:
[] |
7 | 0.63 ms |
UPDATE article SET views = ? WHERE id = ?
Parameters:
[ "10" 270 ] |
8 | 2.45 ms |
"COMMIT"
Parameters:
[] |
9 | 0.70 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.name AS name_3, t0.email AS email_4, t0.website AS website_5, t0.activated AS activated_6, t0.created_at AS created_at_7, t0.status AS status_8, t0.language AS language_9, t0.article_id AS article_id_10, t0.tutorial_id AS tutorial_id_11 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
270
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Article | No errors. |
App\Entity\User | No errors. |
App\Entity\Admin | No errors. |
App\Entity\WebsiteLanguage | No errors. |
App\Entity\Category | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Tutorial | No errors. |
App\Entity\WebsiteInfo | No errors. |
App\Entity\Faq | No errors. |
App\Entity\HomeSlider | No errors. |
App\Entity\Media | No errors. |
App\Entity\LegalInfo | No errors. |
App\Entity\Address | No errors. |
App\Entity\ProInfo | No errors. |
App\Entity\StripeInfo | No errors. |
App\Entity\Role | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\Course | No errors. |
App\Entity\Language | No errors. |
App\Entity\Message | No errors. |
App\Entity\Participant | No errors. |
App\Entity\Conversation | No errors. |
App\Entity\ProViewsStat | No errors. |
App\Entity\Trainee | No errors. |
App\Entity\Invoice | No errors. |
App\Entity\ProDescription | No errors. |
App\Entity\Note |
|
App\Entity\NoteRequest | No errors. |