https://racket-trip.eu/sv/blog/articles/svenska-test-1

Query Metrics

9 Database Queries
9 Different statements
5.67 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.61 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:
[
  "svenska-test-1"
]
2 0.41 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:
[
  7
]
3 0.48 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:
[
  288
]
4 0.61 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:
[
  4
  "sv"
  "svenska-test-1"
  1
]
5 0.44 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.31 ms
"START TRANSACTION"
Parameters:
[]
7 0.42 ms
UPDATE article SET views = ? WHERE id = ?
Parameters:
[
  "9"
  288
]
8 1.80 ms
"COMMIT"
Parameters:
[]
9 0.59 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:
[
  288
]

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
  • The mappings App\Entity\Note#trainee and App\Entity\Trainee#notes are inconsistent with each other.
  • If association App\Entity\Note#trainee is many-to-one, then the inversed side App\Entity\Trainee#notes has to be one-to-many.
App\Entity\NoteRequest No errors.