Symfony Profiler

Query Metrics

22 Database Queries

4 Different statements

27.13 ms Query time

0 Invalid entities

27 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.65 ms
(57.70%)

SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.hero_image AS hero_image_3, t0.og_image AS og_image_4, t0.slug AS slug_5, t0.title AS title_6, t0.description AS description_7, t0.content AS content_8, t0.tags AS tags_9, t0.seo_title AS seo_title_10, t0.meta_description AS meta_description_11, t0.status AS status_12, t0.published_at AS published_at_13, t0.is_trending AS is_trending_14, t0.is_editors_pick AS is_editors_pick_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.author_id AS author_id_18, t0.category_id AS category_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM article t0 WHERE t0.status = ? ORDER BY t0.created_at DESC

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.thumbnail AS thumbnail_2,
  t0.hero_image AS hero_image_3,
  t0.og_image AS og_image_4,
  t0.slug AS slug_5,
  t0.title AS title_6,
  t0.description AS description_7,
  t0.content AS content_8,
  t0.tags AS tags_9,
  t0.seo_title AS seo_title_10,
  t0.meta_description AS meta_description_11,
  t0.status AS status_12,
  t0.published_at AS published_at_13,
  t0.is_trending AS is_trending_14,
  t0.is_editors_pick AS is_editors_pick_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.author_id AS author_id_18,
  t0.category_id AS category_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21
FROM
  article t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.hero_image AS hero_image_3, t0.og_image AS og_image_4, t0.slug AS slug_5, t0.title AS title_6, t0.description AS description_7, t0.content AS content_8, t0.tags AS tags_9, t0.seo_title AS seo_title_10, t0.meta_description AS meta_description_11, t0.status AS status_12, t0.published_at AS published_at_13, t0.is_trending AS is_trending_14, t0.is_editors_pick AS is_editors_pick_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.author_id AS author_id_18, t0.category_id AS category_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM article t0 WHERE t0.status = 'published' ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Repository\Article\ArticleRepository->findPublished (line 42)
4	App\Controller\Api\ArticleController->index (line 44)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 7)

5.12 ms
(18.87%)

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 INNER JOIN article_partner ON t0.id = article_partner.partner_id WHERE article_partner.article_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.og_image AS og_image_3,
  t0.slug AS slug_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.full_name AS full_name_7,
  t0.position AS position_8,
  t0.about AS about_9,
  t0.languages AS languages_10,
  t0.categories AS categories_11,
  t0.status AS status_12,
  t0.profile_img AS profile_img_13,
  t0.country AS country_14,
  t0.type AS type_15,
  t0.socials_linkedin AS socials_linkedin_16,
  t0.socials_facebook AS socials_facebook_17,
  t0.socials_telegram AS socials_telegram_18,
  t0.socials_youtube AS socials_youtube_19,
  t0.socials_website AS socials_website_20,
  t0.socials_instagram AS socials_instagram_21,
  t0.company_name AS company_name_22,
  t0.company_category AS company_category_23,
  t0.company_industry AS company_industry_24,
  t0.company_headquarters AS company_headquarters_25,
  t0.company_website AS company_website_26,
  t0.company_countries AS company_countries_27,
  t0.company_description AS company_description_28,
  t0.company_logo AS company_logo_29,
  t0.expertise AS expertise_30,
  t0.is_featured AS is_featured_31,
  t0.sort_order AS sort_order_32,
  t0.seo_title AS seo_title_33,
  t0.meta_description AS meta_description_34,
  t0.charter_accepted AS charter_accepted_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.user_id AS user_id_38,
  t0.created_by_id AS created_by_id_39,
  t0.updated_by_id AS updated_by_id_40
FROM
  partner t0
  INNER JOIN article_partner ON t0.id = article_partner.partner_id
WHERE
  article_partner.article_id = ?

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 INNER JOIN article_partner ON t0.id = article_partner.partner_id WHERE article_partner.article_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Entity\Article->getContributors (line 106)
8	App\Controller\Api\ArticleController->{closure:App\Controller\Api\ArticleController::index():46} (line 72)
9	array_map (line 46)
10	App\Controller\Api\ArticleController::index (line 46)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 7)

3.98 ms
(14.67%)

SELECT t0.id AS id_1, t0.og_image AS og_image_2, t0.slug AS slug_3, t0.name AS name_4, t0.status AS status_5, t0.seo_title AS seo_title_6, t0.meta_description AS meta_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.og_image AS og_image_2,
  t0.slug AS slug_3,
  t0.name AS name_4,
  t0.status AS status_5,
  t0.seo_title AS seo_title_6,
  t0.meta_description AS meta_description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.og_image AS og_image_2, t0.slug AS slug_3, t0.name AS name_4, t0.status AS status_5, t0.seo_title AS seo_title_6, t0.meta_description AS meta_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM category t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Controller\Api\ArticleController::{closure:App\Controller\Api\ArticleController::index():46} (line 53)
5	array_map (line 46)
6	App\Controller\Api\ArticleController::index (line 46)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 7)

2.38 ms
(8.76%)

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.og_image AS og_image_3,
  t0.slug AS slug_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.full_name AS full_name_7,
  t0.position AS position_8,
  t0.about AS about_9,
  t0.languages AS languages_10,
  t0.categories AS categories_11,
  t0.status AS status_12,
  t0.profile_img AS profile_img_13,
  t0.country AS country_14,
  t0.type AS type_15,
  t0.socials_linkedin AS socials_linkedin_16,
  t0.socials_facebook AS socials_facebook_17,
  t0.socials_telegram AS socials_telegram_18,
  t0.socials_youtube AS socials_youtube_19,
  t0.socials_website AS socials_website_20,
  t0.socials_instagram AS socials_instagram_21,
  t0.company_name AS company_name_22,
  t0.company_category AS company_category_23,
  t0.company_industry AS company_industry_24,
  t0.company_headquarters AS company_headquarters_25,
  t0.company_website AS company_website_26,
  t0.company_countries AS company_countries_27,
  t0.company_description AS company_description_28,
  t0.company_logo AS company_logo_29,
  t0.expertise AS expertise_30,
  t0.is_featured AS is_featured_31,
  t0.sort_order AS sort_order_32,
  t0.seo_title AS seo_title_33,
  t0.meta_description AS meta_description_34,
  t0.charter_accepted AS charter_accepted_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.user_id AS user_id_38,
  t0.created_by_id AS created_by_id_39,
  t0.updated_by_id AS updated_by_id_40
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Controller\Api\ArticleController::{closure:App\Controller\Api\ArticleController::index():46} (line 60)
5	array_map (line 46)
6	App\Controller\Api\ArticleController::index (line 46)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 7)

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\Article	9
App\Entity\Partner	6
App\Entity\Category	6
App\Entity\User	6

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\Partner	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.
App\Entity\Tag	No errors.

Symfony Profiler

GET https://cp.movchansalliance.com/api/articles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping