Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.33 ms Query time

0 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.01 ms
(76.14%)

SELECT a0_.id AS id_0, a0_.artist_name AS artist_name_1, a0_.slug AS slug_2, a0_.bio AS bio_3, a0_.profile_photo AS profile_photo_4, a0_.cover_photo AS cover_photo_5, a0_.city AS city_6, a0_.department AS department_7, a0_.region AS region_8, a0_.postal_code AS postal_code_9, a0_.country AS country_10, a0_.siret AS siret_11, a0_.cgv_filename AS cgv_filename_12, a0_.latitude AS latitude_13, a0_.longitude AS longitude_14, a0_.workshop_visitable AS workshop_visitable_15, a0_.workshop_hours AS workshop_hours_16, a0_.workshop_address AS workshop_address_17, a0_.website AS website_18, a0_.instagram AS instagram_19, a0_.facebook AS facebook_20, a0_.stripe_account_id AS stripe_account_id_21, a0_.stripe_onboarding_status AS stripe_onboarding_status_22, a0_.subscription_status AS subscription_status_23, a0_.subscription_stripe_id AS subscription_stripe_id_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, s1_.id AS id_27, s1_.name AS name_28, s1_.slug AS slug_29, s1_.custom_domain AS custom_domain_30, s1_.theme AS theme_31, s1_.theme_config AS theme_config_32, s1_.is_active AS is_active_33, s1_.analytics_scripts AS analytics_scripts_34, s1_.created_at AS created_at_35, s1_.updated_at AS updated_at_36, c2_.id AS id_37, c2_.name AS name_38, c2_.slug AS slug_39, c2_.icon AS icon_40, a0_.user_id AS user_id_41, s1_.artisan_id AS artisan_id_42, c2_.parent_id AS parent_id_43 FROM artisan a0_ INNER JOIN shop s1_ ON a0_.id = s1_.artisan_id LEFT JOIN artisan_discipline a3_ ON a0_.id = a3_.artisan_id LEFT JOIN category c2_ ON c2_.id = a3_.category_id WHERE s1_.is_active = ? AND c2_.slug = ? ORDER BY a0_.artist_name ASC

Parameters:

[
  1
  "orfevrerie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.artist_name AS artist_name_1,
  a0_.slug AS slug_2,
  a0_.bio AS bio_3,
  a0_.profile_photo AS profile_photo_4,
  a0_.cover_photo AS cover_photo_5,
  a0_.city AS city_6,
  a0_.department AS department_7,
  a0_.region AS region_8,
  a0_.postal_code AS postal_code_9,
  a0_.country AS country_10,
  a0_.siret AS siret_11,
  a0_.cgv_filename AS cgv_filename_12,
  a0_.latitude AS latitude_13,
  a0_.longitude AS longitude_14,
  a0_.workshop_visitable AS workshop_visitable_15,
  a0_.workshop_hours AS workshop_hours_16,
  a0_.workshop_address AS workshop_address_17,
  a0_.website AS website_18,
  a0_.instagram AS instagram_19,
  a0_.facebook AS facebook_20,
  a0_.stripe_account_id AS stripe_account_id_21,
  a0_.stripe_onboarding_status AS stripe_onboarding_status_22,
  a0_.subscription_status AS subscription_status_23,
  a0_.subscription_stripe_id AS subscription_stripe_id_24,
  a0_.created_at AS created_at_25,
  a0_.updated_at AS updated_at_26,
  s1_.id AS id_27,
  s1_.name AS name_28,
  s1_.slug AS slug_29,
  s1_.custom_domain AS custom_domain_30,
  s1_.theme AS theme_31,
  s1_.theme_config AS theme_config_32,
  s1_.is_active AS is_active_33,
  s1_.analytics_scripts AS analytics_scripts_34,
  s1_.created_at AS created_at_35,
  s1_.updated_at AS updated_at_36,
  c2_.id AS id_37,
  c2_.name AS name_38,
  c2_.slug AS slug_39,
  c2_.icon AS icon_40,
  a0_.user_id AS user_id_41,
  s1_.artisan_id AS artisan_id_42,
  c2_.parent_id AS parent_id_43
FROM
  artisan a0_
  INNER JOIN shop s1_ ON a0_.id = s1_.artisan_id
  LEFT JOIN artisan_discipline a3_ ON a0_.id = a3_.artisan_id
  LEFT JOIN category c2_ ON c2_.id = a3_.category_id
WHERE
  s1_.is_active = ?
  AND c2_.slug = ?
ORDER BY
  a0_.artist_name ASC

SELECT a0_.id AS id_0, a0_.artist_name AS artist_name_1, a0_.slug AS slug_2, a0_.bio AS bio_3, a0_.profile_photo AS profile_photo_4, a0_.cover_photo AS cover_photo_5, a0_.city AS city_6, a0_.department AS department_7, a0_.region AS region_8, a0_.postal_code AS postal_code_9, a0_.country AS country_10, a0_.siret AS siret_11, a0_.cgv_filename AS cgv_filename_12, a0_.latitude AS latitude_13, a0_.longitude AS longitude_14, a0_.workshop_visitable AS workshop_visitable_15, a0_.workshop_hours AS workshop_hours_16, a0_.workshop_address AS workshop_address_17, a0_.website AS website_18, a0_.instagram AS instagram_19, a0_.facebook AS facebook_20, a0_.stripe_account_id AS stripe_account_id_21, a0_.stripe_onboarding_status AS stripe_onboarding_status_22, a0_.subscription_status AS subscription_status_23, a0_.subscription_stripe_id AS subscription_stripe_id_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, s1_.id AS id_27, s1_.name AS name_28, s1_.slug AS slug_29, s1_.custom_domain AS custom_domain_30, s1_.theme AS theme_31, s1_.theme_config AS theme_config_32, s1_.is_active AS is_active_33, s1_.analytics_scripts AS analytics_scripts_34, s1_.created_at AS created_at_35, s1_.updated_at AS updated_at_36, c2_.id AS id_37, c2_.name AS name_38, c2_.slug AS slug_39, c2_.icon AS icon_40, a0_.user_id AS user_id_41, s1_.artisan_id AS artisan_id_42, c2_.parent_id AS parent_id_43 FROM artisan a0_ INNER JOIN shop s1_ ON a0_.id = s1_.artisan_id LEFT JOIN artisan_discipline a3_ ON a0_.id = a3_.artisan_id LEFT JOIN category c2_ ON c2_.id = a3_.category_id WHERE s1_.is_active = 1 AND c2_.slug = 'orfevrerie' ORDER BY a0_.artist_name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ArtisanRepository->findByFilters (line 70)
7	App\Controller\Main\ArtisanDirectoryController->index (line 24)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.17 ms
(12.61%)

SELECT DISTINCT a0_.region AS region_0 FROM artisan a0_ WHERE a0_.region IS NOT NULL ORDER BY a0_.region ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.region AS region_0
FROM
  artisan a0_
WHERE
  a0_.region IS NOT NULL
ORDER BY
  a0_.region ASC

SELECT DISTINCT a0_.region AS region_0 FROM artisan a0_ WHERE a0_.region IS NOT NULL ORDER BY a0_.region ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 712)
6	App\Repository\ArtisanRepository->findAllRegions (line 85)
7	App\Controller\Main\ArtisanDirectoryController->index (line 31)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.15 ms
(11.25%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.parent_id AS parent_id_5 FROM category t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.icon AS icon_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.parent_id AS parent_id_5 FROM category t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\Main\ArtisanDirectoryController->index (line 30)
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 5)

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\Category	21

Entities Mapping

Class	Mapping errors
App\Entity\Artisan	No errors.
App\Entity\Shop	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.artifexium.fr/artisans?discipline=orfevrerie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping