Symfony Profiler

Query Metrics

32 Database Queries

9 Different statements

289.63 ms Query time

1 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

98.39 ms
(33.97%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.translations AS translations_3, t0.code AS code_4, t0.icon AS icon_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.church_id AS church_id_8 FROM church_feature t0 WHERE t0.church_id = ? AND t0.code = ? LIMIT 1

Parameters:

[
  7
  "mass_request"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.translations AS translations_3,
  t0.code AS code_4,
  t0.icon AS icon_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.church_id AS church_id_8
FROM
  church_feature t0
WHERE
  t0.church_id = ?
  AND t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.translations AS translations_3, t0.code AS code_4, t0.icon AS icon_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.church_id AS church_id_8 FROM church_feature t0 WHERE t0.church_id = 7 AND t0.code = 'mass_request' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 24)
5	App\Service\Church\ChurchFeatureResolver->resolveFeature (line 54)
6	App\Service\Church\ChurchFeatureResolver->resolveAllFeatures (line 43)
7	App\Controller\Api\ApiChurchController->getChurch (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

94.41 ms
(32.60%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.fees AS fees_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.church_id AS church_id_6, t0.mass_category_id AS mass_category_id_7 FROM mass_price t0 WHERE t0.church_id = ? AND t0.mass_category_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.fees AS fees_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.church_id AS church_id_6,
  t0.mass_category_id AS mass_category_id_7
FROM
  mass_price t0
WHERE
  t0.church_id = ?
  AND t0.mass_category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.fees AS fees_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.church_id AS church_id_6, t0.mass_category_id AS mass_category_id_7 FROM mass_price t0 WHERE t0.church_id = 7 AND t0.mass_category_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 26)
5	App\Service\Mass\MassPriceResolver->resolve (line 398)
6	App\Controller\Api\ApiChurchController->hydratePricesRecursively (line 41)
7	App\Controller\Api\ApiChurchController->getChurch (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

93.31 ms
(32.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.map_short_url AS map_short_url_10, t0.logo AS logo_11, t0.banner AS banner_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.root_id AS root_id_15, t0.parent_id AS parent_id_16, t0.category_id AS category_id_17, t18.id AS id_19, t18.name AS name_20, t18.type AS type_21, t18.is_enabled AS is_enabled_22, t18.config AS config_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.church_id AS church_id_26 FROM church t0 LEFT JOIN institution t18 ON t18.church_id = t0.id WHERE t0.id = ?

Parameters:

[
  "7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.longitude AS longitude_8,
  t0.latitude AS latitude_9,
  t0.map_short_url AS map_short_url_10,
  t0.logo AS logo_11,
  t0.banner AS banner_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.root_id AS root_id_15,
  t0.parent_id AS parent_id_16,
  t0.category_id AS category_id_17,
  t18.id AS id_19,
  t18.name AS name_20,
  t18.type AS type_21,
  t18.is_enabled AS is_enabled_22,
  t18.config AS config_23,
  t18.created_at AS created_at_24,
  t18.updated_at AS updated_at_25,
  t18.church_id AS church_id_26
FROM
  church t0
  LEFT JOIN institution t18 ON t18.church_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.map_short_url AS map_short_url_10, t0.logo AS logo_11, t0.banner AS banner_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.root_id AS root_id_15, t0.parent_id AS parent_id_16, t0.category_id AS category_id_17, t18.id AS id_19, t18.name AS name_20, t18.type AS type_21, t18.is_enabled AS is_enabled_22, t18.config AS config_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.church_id AS church_id_26 FROM church t0 LEFT JOIN institution t18 ON t18.church_id = t0.id WHERE t0.id = '7';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.00 ms
(0.35%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.icon AS icon_4, t0.color AS color_5, t0.nb_churches AS nb_churches_6, t0.level AS level_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM church_category t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.wording AS wording_3,
  t0.icon AS icon_4,
  t0.color AS color_5,
  t0.nb_churches AS nb_churches_6,
  t0.level AS level_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  church_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.icon AS icon_4, t0.color AS color_5, t0.nb_churches AS nb_churches_6, t0.level AS level_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM church_category t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\ChurchCategory::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\ChurchCategory->__get (line 76)
8	App\Entity\ChurchCategory->getCode (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 139)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 198)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 227)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 227)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
20	Symfony\Component\Serializer\Serializer->normalize (line 170)
21	Symfony\Component\Serializer\Serializer->normalize (line 227)
22	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
23	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
24	Symfony\Component\Serializer\Serializer->normalize (line 131)
25	Symfony\Component\Serializer\Serializer->serialize (line 44)
26	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 62)
27	App\Controller\Api\ApiChurchController->getChurch (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.59 ms
(0.20%)

SELECT t0.id AS id_1, t0.intention AS intention_2, t0.requester AS requester_3, t0.is_payed AS is_payed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7, t0.church_id AS church_id_8, t0.category_id AS category_id_9, t10.id AS id_11, t10.reference AS reference_12, t10.status AS status_13, t10.type AS type_14, t10.mode AS mode_15, t10.amount AS amount_16, t10.gateway_response AS gateway_response_17, t10.transaction_token AS transaction_token_18, t10.external_id AS external_id_19, t10.currency AS currency_20, t10.payment_fees AS payment_fees_21, t10.base_amount AS base_amount_22, t10.payment_source AS payment_source_23, t10.customer_number AS customer_number_24, t10.contry_origin AS contry_origin_25, t10.payment_source_transaction_id AS payment_source_transaction_id_26, t10.payment_intent_id AS payment_intent_id_27, t10.is_compensated AS is_compensated_28, t10.compensated_at AS compensated_at_29, t10.receiver_balance_before AS receiver_balance_before_30, t10.receiver_balance_after AS receiver_balance_after_31, t10.receiver_fees_balance_before AS receiver_fees_balance_before_32, t10.receiver_fees_balance_after AS receiver_fees_balance_after_33, t10.created_at AS created_at_34, t10.updated_at AS updated_at_35, t10.mass_id AS mass_id_36, t10.institution_id AS institution_id_37 FROM mass t0 LEFT JOIN payment t10 ON t10.mass_id = t0.id WHERE t0.church_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.intention AS intention_2,
  t0.requester AS requester_3,
  t0.is_payed AS is_payed_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.owner_id AS owner_id_7,
  t0.church_id AS church_id_8,
  t0.category_id AS category_id_9,
  t10.id AS id_11,
  t10.reference AS reference_12,
  t10.status AS status_13,
  t10.type AS type_14,
  t10.mode AS mode_15,
  t10.amount AS amount_16,
  t10.gateway_response AS gateway_response_17,
  t10.transaction_token AS transaction_token_18,
  t10.external_id AS external_id_19,
  t10.currency AS currency_20,
  t10.payment_fees AS payment_fees_21,
  t10.base_amount AS base_amount_22,
  t10.payment_source AS payment_source_23,
  t10.customer_number AS customer_number_24,
  t10.contry_origin AS contry_origin_25,
  t10.payment_source_transaction_id AS payment_source_transaction_id_26,
  t10.payment_intent_id AS payment_intent_id_27,
  t10.is_compensated AS is_compensated_28,
  t10.compensated_at AS compensated_at_29,
  t10.receiver_balance_before AS receiver_balance_before_30,
  t10.receiver_balance_after AS receiver_balance_after_31,
  t10.receiver_fees_balance_before AS receiver_fees_balance_before_32,
  t10.receiver_fees_balance_after AS receiver_fees_balance_after_33,
  t10.created_at AS created_at_34,
  t10.updated_at AS updated_at_35,
  t10.mass_id AS mass_id_36,
  t10.institution_id AS institution_id_37
FROM
  mass t0
  LEFT JOIN payment t10 ON t10.mass_id = t0.id
WHERE
  t0.church_id = ?

SELECT t0.id AS id_1, t0.intention AS intention_2, t0.requester AS requester_3, t0.is_payed AS is_payed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7, t0.church_id AS church_id_8, t0.category_id AS category_id_9, t10.id AS id_11, t10.reference AS reference_12, t10.status AS status_13, t10.type AS type_14, t10.mode AS mode_15, t10.amount AS amount_16, t10.gateway_response AS gateway_response_17, t10.transaction_token AS transaction_token_18, t10.external_id AS external_id_19, t10.currency AS currency_20, t10.payment_fees AS payment_fees_21, t10.base_amount AS base_amount_22, t10.payment_source AS payment_source_23, t10.customer_number AS customer_number_24, t10.contry_origin AS contry_origin_25, t10.payment_source_transaction_id AS payment_source_transaction_id_26, t10.payment_intent_id AS payment_intent_id_27, t10.is_compensated AS is_compensated_28, t10.compensated_at AS compensated_at_29, t10.receiver_balance_before AS receiver_balance_before_30, t10.receiver_balance_after AS receiver_balance_after_31, t10.receiver_fees_balance_before AS receiver_fees_balance_before_32, t10.receiver_fees_balance_after AS receiver_fees_balance_after_33, t10.created_at AS created_at_34, t10.updated_at AS updated_at_35, t10.mass_id AS mass_id_36, t10.institution_id AS institution_id_37 FROM mass t0 LEFT JOIN payment t10 ON t10.mass_id = t0.id WHERE t0.church_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 161)
9	App\Entity\Church->getMassCount (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 139)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 198)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 131)
16	Symfony\Component\Serializer\Serializer->serialize (line 44)
17	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 62)
18	App\Controller\Api\ApiChurchController->getChurch (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.58 ms
(0.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.map_short_url AS map_short_url_10, t0.logo AS logo_11, t0.banner AS banner_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.root_id AS root_id_15, t0.parent_id AS parent_id_16, t0.category_id AS category_id_17, t18.id AS id_19, t18.name AS name_20, t18.type AS type_21, t18.is_enabled AS is_enabled_22, t18.config AS config_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.church_id AS church_id_26 FROM church t0 LEFT JOIN institution t18 ON t18.church_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.lft ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.longitude AS longitude_8,
  t0.latitude AS latitude_9,
  t0.map_short_url AS map_short_url_10,
  t0.logo AS logo_11,
  t0.banner AS banner_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.root_id AS root_id_15,
  t0.parent_id AS parent_id_16,
  t0.category_id AS category_id_17,
  t18.id AS id_19,
  t18.name AS name_20,
  t18.type AS type_21,
  t18.is_enabled AS is_enabled_22,
  t18.config AS config_23,
  t18.created_at AS created_at_24,
  t18.updated_at AS updated_at_25,
  t18.church_id AS church_id_26
FROM
  church t0
  LEFT JOIN institution t18 ON t18.church_id = t0.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.map_short_url AS map_short_url_10, t0.logo AS logo_11, t0.banner AS banner_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.root_id AS root_id_15, t0.parent_id AS parent_id_16, t0.category_id AS category_id_17, t18.id AS id_19, t18.name AS name_20, t18.type AS type_21, t18.is_enabled AS is_enabled_22, t18.config AS config_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.church_id AS church_id_26 FROM church t0 LEFT JOIN institution t18 ON t18.church_id = t0.id WHERE t0.parent_id = 7 ORDER BY t0.lft ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 379)
8	App\Controller\Api\ApiChurchController->hydratePricesRecursively (line 41)
9	App\Controller\Api\ApiChurchController->getChurch (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.53 ms
(0.18%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.color AS color_4, t0.icon AS icon_5, t0.color_hex AS color_hex_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mass_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.wording AS wording_3,
  t0.color AS color_4,
  t0.icon AS icon_5,
  t0.color_hex AS color_hex_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  mass_category t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.color AS color_4, t0.icon AS icon_5, t0.color_hex AS color_hex_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mass_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 40)
6	App\Controller\Api\ApiChurchController->getChurch (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.43 ms
(0.15%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.contact_id AS contact_id_6 FROM contact_item t0 WHERE t0.contact_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.contact_id AS contact_id_6
FROM
  contact_item t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.contact_id AS contact_id_6 FROM contact_item t0 WHERE t0.contact_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 169)
8	Symfony\Component\Serializer\Serializer->normalize (line 227)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Serializer->normalize (line 227)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 131)
16	Symfony\Component\Serializer\Serializer->serialize (line 44)
17	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 62)
18	App\Controller\Api\ApiChurchController->getChurch (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.39 ms
(0.13%)

SELECT t0.id AS id_1, t0.wording AS wording_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.church_id AS church_id_5 FROM contact t0 WHERE t0.church_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.wording AS wording_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.church_id AS church_id_5
FROM
  contact t0
WHERE
  t0.church_id = ?

SELECT t0.id AS id_1, t0.wording AS wording_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.church_id AS church_id_5 FROM contact t0 WHERE t0.church_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 169)
8	Symfony\Component\Serializer\Serializer->normalize (line 227)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 131)
12	Symfony\Component\Serializer\Serializer->serialize (line 44)
13	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 62)
14	App\Controller\Api\ApiChurchController->getChurch (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\ChurchFeature	9
App\Entity\ContactItem	4
App\Entity\MassCategory	3
App\Entity\MassPrice	3
App\Entity\Church	2
App\Entity\ChurchCategory	2
App\Entity\Institution	2
App\Entity\Contact	1

Entities Mapping

Class	Mapping errors
App\Entity\Church	No errors.
App\Entity\ChurchCategory	No errors.
App\Entity\Institution	No errors.
App\Entity\User	No errors.
App\Entity\Mass	No errors.
App\Entity\MassPrice	The field 'App\Entity\MassPrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\MassPrice#fees' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ChurchFeature	No errors.
App\Entity\MassSchedule	No errors.
App\Entity\Contact	No errors.
App\Entity\Wallet	No errors.
App\Entity\Payment	No errors.
App\Entity\CommissionRate	No errors.
App\Entity\MassCategory	No errors.
App\Entity\ContactItem	No errors.

Symfony Profiler

GET https://kathosmart.com/api/church/details/7

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping