Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

1.20 ms Query time

1 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.17 ms
(14.62%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.state AS state_3, t0.comment AS comment_4, t0.stop_list AS stop_list_5, t0.full_name AS full_name_6, t0.delete_list AS delete_list_7, t0.delete_list_date AS delete_list_date_8, t0.stop_list_date AS stop_list_date_9, t0.created_at AS created_at_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.source_id AS source_id_13, t0.phone_tchat_id AS phone_tchat_id_14 FROM mew_contact t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "OP6QFSM6XYFO"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.state AS state_3,
  t0.comment AS comment_4,
  t0.stop_list AS stop_list_5,
  t0.full_name AS full_name_6,
  t0.delete_list AS delete_list_7,
  t0.delete_list_date AS delete_list_date_8,
  t0.stop_list_date AS stop_list_date_9,
  t0.created_at AS created_at_10,
  t0.token AS token_11,
  t0.public_uuid AS public_uuid_12,
  t0.source_id AS source_id_13,
  t0.phone_tchat_id AS phone_tchat_id_14
FROM
  mew_contact t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.state AS state_3, t0.comment AS comment_4, t0.stop_list AS stop_list_5, t0.full_name AS full_name_6, t0.delete_list AS delete_list_7, t0.delete_list_date AS delete_list_date_8, t0.stop_list_date AS stop_list_date_9, t0.created_at AS created_at_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.source_id AS source_id_13, t0.phone_tchat_id AS phone_tchat_id_14 FROM mew_contact t0 WHERE t0.token = 'OP6QFSM6XYFO' LIMIT 1;

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

0.17 ms
(14.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.import_has_header AS import_has_header_4, t0.parameter_separator AS parameter_separator_5, t0.ftp_server AS ftp_server_6, t0.ftp_user AS ftp_user_7, t0.ftp_password AS ftp_password_8, t0.ftp_path AS ftp_path_9, t0.ftp_active AS ftp_active_10, t0.sftp_private_key AS sftp_private_key_11, t0.is_sftp AS is_sftp_12, t0.ftp_port AS ftp_port_13, t0.ftp_hours AS ftp_hours_14, t0.ftp_message AS ftp_message_15, t0.ftp_channel_type AS ftp_channel_type_16, t0.ftp_reminder1_active AS ftp_reminder1_active_17, t0.ftp_reminder1_message AS ftp_reminder1_message_18, t0.ftp_reminder1_hours AS ftp_reminder1_hours_19, t0.ftp_reminder2_active AS ftp_reminder2_active_20, t0.ftp_reminder2_message AS ftp_reminder2_message_21, t0.ftp_reminder2_hours AS ftp_reminder2_hours_22, t0.is_single_campaign_only AS is_single_campaign_only_23, t0.language AS language_24, t0.is_filter_active AS is_filter_active_25, t0.messages_condition AS messages_condition_26, t0.token AS token_27, t0.active AS active_28, t0.public_uuid AS public_uuid_29, t0.source_origin_id AS source_origin_id_30, t0.favorite_phone_number_id AS favorite_phone_number_id_31 FROM mew_source t0 WHERE t0.id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.import_has_header AS import_has_header_4,
  t0.parameter_separator AS parameter_separator_5,
  t0.ftp_server AS ftp_server_6,
  t0.ftp_user AS ftp_user_7,
  t0.ftp_password AS ftp_password_8,
  t0.ftp_path AS ftp_path_9,
  t0.ftp_active AS ftp_active_10,
  t0.sftp_private_key AS sftp_private_key_11,
  t0.is_sftp AS is_sftp_12,
  t0.ftp_port AS ftp_port_13,
  t0.ftp_hours AS ftp_hours_14,
  t0.ftp_message AS ftp_message_15,
  t0.ftp_channel_type AS ftp_channel_type_16,
  t0.ftp_reminder1_active AS ftp_reminder1_active_17,
  t0.ftp_reminder1_message AS ftp_reminder1_message_18,
  t0.ftp_reminder1_hours AS ftp_reminder1_hours_19,
  t0.ftp_reminder2_active AS ftp_reminder2_active_20,
  t0.ftp_reminder2_message AS ftp_reminder2_message_21,
  t0.ftp_reminder2_hours AS ftp_reminder2_hours_22,
  t0.is_single_campaign_only AS is_single_campaign_only_23,
  t0.language AS language_24,
  t0.is_filter_active AS is_filter_active_25,
  t0.messages_condition AS messages_condition_26,
  t0.token AS token_27,
  t0.active AS active_28,
  t0.public_uuid AS public_uuid_29,
  t0.source_origin_id AS source_origin_id_30,
  t0.favorite_phone_number_id AS favorite_phone_number_id_31
FROM
  mew_source t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.import_has_header AS import_has_header_4, t0.parameter_separator AS parameter_separator_5, t0.ftp_server AS ftp_server_6, t0.ftp_user AS ftp_user_7, t0.ftp_password AS ftp_password_8, t0.ftp_path AS ftp_path_9, t0.ftp_active AS ftp_active_10, t0.sftp_private_key AS sftp_private_key_11, t0.is_sftp AS is_sftp_12, t0.ftp_port AS ftp_port_13, t0.ftp_hours AS ftp_hours_14, t0.ftp_message AS ftp_message_15, t0.ftp_channel_type AS ftp_channel_type_16, t0.ftp_reminder1_active AS ftp_reminder1_active_17, t0.ftp_reminder1_message AS ftp_reminder1_message_18, t0.ftp_reminder1_hours AS ftp_reminder1_hours_19, t0.ftp_reminder2_active AS ftp_reminder2_active_20, t0.ftp_reminder2_message AS ftp_reminder2_message_21, t0.ftp_reminder2_hours AS ftp_reminder2_hours_22, t0.is_single_campaign_only AS is_single_campaign_only_23, t0.language AS language_24, t0.is_filter_active AS is_filter_active_25, t0.messages_condition AS messages_condition_26, t0.token AS token_27, t0.active AS active_28, t0.public_uuid AS public_uuid_29, t0.source_origin_id AS source_origin_id_30, t0.favorite_phone_number_id AS favorite_phone_number_id_31 FROM mew_source t0 WHERE t0.id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Source::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Source->__get (line 531)
8	App\Entity\Source->getName (line 267)
9	App\Entity\Contact->getSourceName (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
14	App\Serializer\ContactNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
20	App\Controller\Api\ApiContactController->get (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.14 ms
(12.03%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.date_creation AS date_creation_7, t0.reset_password_token AS reset_password_token_8, t0.date_request_reset_password AS date_request_reset_password_9, t0.need_to_reset_password AS need_to_reset_password_10, t0.image_name AS image_name_11, t0.phone_number AS phone_number_12, t0.anonymous AS anonymous_13, t0.email_auth_code AS email_auth_code_14, t0.is_email_auth_enabled AS is_email_auth_enabled_15, t0.ignore_read AS ignore_read_16, t0.token AS token_17, t0.active AS active_18, t0.public_uuid AS public_uuid_19 FROM mew_user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "joachim@cupani.dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.date_creation AS date_creation_7,
  t0.reset_password_token AS reset_password_token_8,
  t0.date_request_reset_password AS date_request_reset_password_9,
  t0.need_to_reset_password AS need_to_reset_password_10,
  t0.image_name AS image_name_11,
  t0.phone_number AS phone_number_12,
  t0.anonymous AS anonymous_13,
  t0.email_auth_code AS email_auth_code_14,
  t0.is_email_auth_enabled AS is_email_auth_enabled_15,
  t0.ignore_read AS ignore_read_16,
  t0.token AS token_17,
  t0.active AS active_18,
  t0.public_uuid AS public_uuid_19
FROM
  mew_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.date_creation AS date_creation_7, t0.reset_password_token AS reset_password_token_8, t0.date_request_reset_password AS date_request_reset_password_9, t0.need_to_reset_password AS need_to_reset_password_10, t0.image_name AS image_name_11, t0.phone_number AS phone_number_12, t0.anonymous AS anonymous_13, t0.email_auth_code AS email_auth_code_14, t0.is_email_auth_enabled AS is_email_auth_enabled_15, t0.ignore_read AS ignore_read_16, t0.token AS token_17, t0.active AS active_18, t0.public_uuid AS public_uuid_19 FROM mew_user t0 WHERE t0.email = 'joachim@cupani.dev' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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 7)

0.09 ms
(7.43%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.token AS token_4, t0.source_id AS source_id_5 FROM mew_tag t0 WHERE t0.source_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.token AS token_4,
  t0.source_id AS source_id_5
FROM
  mew_tag t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.token AS token_4, t0.source_id AS source_id_5 FROM mew_tag t0 WHERE t0.source_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 83)
8	App\Serializer\ContactNormalizer->normalize (line 50)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
10	Symfony\Component\Serializer\Serializer->normalize (line 131)
11	Symfony\Component\Serializer\Serializer->serialize (line 44)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
14	App\Controller\Api\ApiContactController->get (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 7)

0.09 ms
(7.19%)

SELECT t0.id AS id_1, t0.data AS data_2, t0.close AS close_3, t0.close_date AS close_date_4, t0.date_creation AS date_creation_5, t0.structured_data AS structured_data_6, t0.public_uuid AS public_uuid_7, t0.contact_id AS contact_id_8, t0.campaign_id AS campaign_id_9 FROM mew_contact_campaign t0 WHERE t0.contact_id = ?

Parameters:

[
  1309711
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.close AS close_3,
  t0.close_date AS close_date_4,
  t0.date_creation AS date_creation_5,
  t0.structured_data AS structured_data_6,
  t0.public_uuid AS public_uuid_7,
  t0.contact_id AS contact_id_8,
  t0.campaign_id AS campaign_id_9
FROM
  mew_contact_campaign t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.close AS close_3, t0.close_date AS close_date_4, t0.date_creation AS date_creation_5, t0.structured_data AS structured_data_6, t0.public_uuid AS public_uuid_7, t0.contact_id AS contact_id_8, t0.campaign_id AS campaign_id_9 FROM mew_contact_campaign t0 WHERE t0.contact_id = 1309711;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 177)
7	Doctrine\Common\Collections\AbstractLazyCollection->last (line 404)
8	App\Entity\Contact->getCampaign (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
13	App\Serializer\ContactNormalizer->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 150)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
19	App\Controller\Api\ApiContactController->get (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.08 ms
(6.85%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.lead AS lead_3, t0.lead_date AS lead_date_4, t0.data_api AS data_api_5, t0.data_api_response_code AS data_api_response_code_6, t0.data_api_response_errors AS data_api_response_errors_7, t0.active AS active_8, t0.token AS token_9, t0.public_uuid AS public_uuid_10, t0.company_division_id AS company_division_id_11, t0.contact_campaign_id AS contact_campaign_id_12 FROM mew_company_division_contact t0 WHERE t0.contact_campaign_id = ?

Parameters:

[
  1338006
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.lead AS lead_3,
  t0.lead_date AS lead_date_4,
  t0.data_api AS data_api_5,
  t0.data_api_response_code AS data_api_response_code_6,
  t0.data_api_response_errors AS data_api_response_errors_7,
  t0.active AS active_8,
  t0.token AS token_9,
  t0.public_uuid AS public_uuid_10,
  t0.company_division_id AS company_division_id_11,
  t0.contact_campaign_id AS contact_campaign_id_12
FROM
  mew_company_division_contact t0
WHERE
  t0.contact_campaign_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.lead AS lead_3, t0.lead_date AS lead_date_4, t0.data_api AS data_api_5, t0.data_api_response_code AS data_api_response_code_6, t0.data_api_response_errors AS data_api_response_errors_7, t0.active AS active_8, t0.token AS token_9, t0.public_uuid AS public_uuid_10, t0.company_division_id AS company_division_id_11, t0.contact_campaign_id AS contact_campaign_id_12 FROM mew_company_division_contact t0 WHERE t0.contact_campaign_id = 1338006;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 408)
8	App\Entity\Contact->getCampaign (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
13	App\Serializer\ContactNormalizer->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 150)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
19	App\Controller\Api\ApiContactController->get (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.08 ms
(6.61%)

SELECT t0.id AS id_1, t0.postal_code AS postal_code_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.created_at AS created_at_5, t0.property_type AS property_type_6, t0.city AS city_7, t0.delivery_at AS delivery_at_8, t0.reference AS reference_9, t0.address AS address_10, t0.description AS description_11, t0.name AS name_12, t0.lots AS lots_13, t0.url AS url_14, t0.token AS token_15, t0.active AS active_16, t0.company_id AS company_id_17 FROM mew_program t0 WHERE t0.company_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.postal_code AS postal_code_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.created_at AS created_at_5,
  t0.property_type AS property_type_6,
  t0.city AS city_7,
  t0.delivery_at AS delivery_at_8,
  t0.reference AS reference_9,
  t0.address AS address_10,
  t0.description AS description_11,
  t0.name AS name_12,
  t0.lots AS lots_13,
  t0.url AS url_14,
  t0.token AS token_15,
  t0.active AS active_16,
  t0.company_id AS company_id_17
FROM
  mew_program t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.postal_code AS postal_code_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.created_at AS created_at_5, t0.property_type AS property_type_6, t0.city AS city_7, t0.delivery_at AS delivery_at_8, t0.reference AS reference_9, t0.address AS address_10, t0.description AS description_11, t0.name AS name_12, t0.lots AS lots_13, t0.url AS url_14, t0.token AS token_15, t0.active AS active_16, t0.company_id AS company_id_17 FROM mew_program t0 WHERE t0.company_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 144)
8	App\Entity\Company->hasActiveProgram (line 73)
9	App\Serializer\ContactNormalizer->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 150)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
15	App\Controller\Api\ApiContactController->get (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 7)

0.07 ms
(5.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_send AS date_send_3, t0.message AS message_4, t0.channel_type AS channel_type_5, t0.state AS state_6, t0.nb_contact_backup AS nb_contact_backup_7, t0.nb_contact_delete_backup AS nb_contact_delete_backup_8, t0.nb_contact_stop_backup AS nb_contact_stop_backup_9, t0.nb_contact_close_backup AS nb_contact_close_backup_10, t0.nb_contact_lead_backup AS nb_contact_lead_backup_11, t0.public_form_text AS public_form_text_12, t0.nb_contacts_init AS nb_contacts_init_13, t0.created_at AS created_at_14, t0.is_archived AS is_archived_15, t0.calculated_stats AS calculated_stats_16, t0.reference AS reference_17, t0.postal_code AS postal_code_18, t0.city AS city_19, t0.comment AS comment_20, t0.url AS url_21, t0.extra_1 AS extra_1_22, t0.extra_2 AS extra_2_23, t0.extra_3 AS extra_3_24, t0.updated_at AS updated_at_25, t0.messages_condition AS messages_condition_26, t0.is_paused AS is_paused_27, t0.token AS token_28, t0.public_uuid AS public_uuid_29, t0.source_id AS source_id_30, t31.id AS id_32, t31.date AS date_33, t31.paused AS paused_34, t31.token AS token_35, t31.campaign_id AS campaign_id_36, t31.source_id AS source_id_37, t0.phone_number_id AS phone_number_id_38 FROM mew_campaign t0 LEFT JOIN mew_stack t31 ON t31.campaign_id = t0.id WHERE t0.id = ?

Parameters:

[
  8634
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_send AS date_send_3,
  t0.message AS message_4,
  t0.channel_type AS channel_type_5,
  t0.state AS state_6,
  t0.nb_contact_backup AS nb_contact_backup_7,
  t0.nb_contact_delete_backup AS nb_contact_delete_backup_8,
  t0.nb_contact_stop_backup AS nb_contact_stop_backup_9,
  t0.nb_contact_close_backup AS nb_contact_close_backup_10,
  t0.nb_contact_lead_backup AS nb_contact_lead_backup_11,
  t0.public_form_text AS public_form_text_12,
  t0.nb_contacts_init AS nb_contacts_init_13,
  t0.created_at AS created_at_14,
  t0.is_archived AS is_archived_15,
  t0.calculated_stats AS calculated_stats_16,
  t0.reference AS reference_17,
  t0.postal_code AS postal_code_18,
  t0.city AS city_19,
  t0.comment AS comment_20,
  t0.url AS url_21,
  t0.extra_1 AS extra_1_22,
  t0.extra_2 AS extra_2_23,
  t0.extra_3 AS extra_3_24,
  t0.updated_at AS updated_at_25,
  t0.messages_condition AS messages_condition_26,
  t0.is_paused AS is_paused_27,
  t0.token AS token_28,
  t0.public_uuid AS public_uuid_29,
  t0.source_id AS source_id_30,
  t31.id AS id_32,
  t31.date AS date_33,
  t31.paused AS paused_34,
  t31.token AS token_35,
  t31.campaign_id AS campaign_id_36,
  t31.source_id AS source_id_37,
  t0.phone_number_id AS phone_number_id_38
FROM
  mew_campaign t0
  LEFT JOIN mew_stack t31 ON t31.campaign_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_send AS date_send_3, t0.message AS message_4, t0.channel_type AS channel_type_5, t0.state AS state_6, t0.nb_contact_backup AS nb_contact_backup_7, t0.nb_contact_delete_backup AS nb_contact_delete_backup_8, t0.nb_contact_stop_backup AS nb_contact_stop_backup_9, t0.nb_contact_close_backup AS nb_contact_close_backup_10, t0.nb_contact_lead_backup AS nb_contact_lead_backup_11, t0.public_form_text AS public_form_text_12, t0.nb_contacts_init AS nb_contacts_init_13, t0.created_at AS created_at_14, t0.is_archived AS is_archived_15, t0.calculated_stats AS calculated_stats_16, t0.reference AS reference_17, t0.postal_code AS postal_code_18, t0.city AS city_19, t0.comment AS comment_20, t0.url AS url_21, t0.extra_1 AS extra_1_22, t0.extra_2 AS extra_2_23, t0.extra_3 AS extra_3_24, t0.updated_at AS updated_at_25, t0.messages_condition AS messages_condition_26, t0.is_paused AS is_paused_27, t0.token AS token_28, t0.public_uuid AS public_uuid_29, t0.source_id AS source_id_30, t31.id AS id_32, t31.date AS date_33, t31.paused AS paused_34, t31.token AS token_35, t31.campaign_id AS campaign_id_36, t31.source_id AS source_id_37, t0.phone_number_id AS phone_number_id_38 FROM mew_campaign t0 LEFT JOIN mew_stack t31 ON t31.campaign_id = t0.id WHERE t0.id = 8634;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Campaign::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Campaign->__get (line 40)
8	App\Entity\Campaign->getToken (line 420)
9	App\Entity\Contact->getCampaign (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
14	App\Serializer\ContactNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
20	App\Controller\Api\ApiContactController->get (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.06 ms
(5.36%)

SELECT t0.id AS id_1, t0.text AS text_2, t0.rich_content AS rich_content_3, t0.information AS information_4, t0.date AS date_5, t0.sender AS sender_6, t0.seen AS seen_7, t0.seen_date AS seen_date_8, t0.date_received AS date_received_9, t0.error_details AS error_details_10, t0.error_number AS error_number_11, t0.scheduled_date AS scheduled_date_12, t0.udh AS udh_13, t0.parts AS parts_14, t0.token AS token_15, t0.public_uuid AS public_uuid_16, t0.contact_id AS contact_id_17, t0.user_id AS user_id_18, t0.seen_user_id AS seen_user_id_19, t0.campaign_id AS campaign_id_20, t0.reminder_id AS reminder_id_21, t22.id AS id_23, t22.content AS content_24, t22.rich_content AS rich_content_25, t22.scheduled_at AS scheduled_at_26, t22.status AS status_27, t22.processing_at AS processing_at_28, t22.sent_at AS sent_at_29, t22.failed_reason AS failed_reason_30, t22.priority AS priority_31, t22.dispateched_at AS dispateched_at_32, t22.contact_id AS contact_id_33, t22.campaign_id AS campaign_id_34, t22.reminder_id AS reminder_id_35, t22.message_id AS message_id_36 FROM mew_message t0 LEFT JOIN mew_message_queue t22 ON t22.message_id = t0.id WHERE t0.contact_id = ? ORDER BY t0.date ASC

Parameters:

[
  1309711
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.rich_content AS rich_content_3,
  t0.information AS information_4,
  t0.date AS date_5,
  t0.sender AS sender_6,
  t0.seen AS seen_7,
  t0.seen_date AS seen_date_8,
  t0.date_received AS date_received_9,
  t0.error_details AS error_details_10,
  t0.error_number AS error_number_11,
  t0.scheduled_date AS scheduled_date_12,
  t0.udh AS udh_13,
  t0.parts AS parts_14,
  t0.token AS token_15,
  t0.public_uuid AS public_uuid_16,
  t0.contact_id AS contact_id_17,
  t0.user_id AS user_id_18,
  t0.seen_user_id AS seen_user_id_19,
  t0.campaign_id AS campaign_id_20,
  t0.reminder_id AS reminder_id_21,
  t22.id AS id_23,
  t22.content AS content_24,
  t22.rich_content AS rich_content_25,
  t22.scheduled_at AS scheduled_at_26,
  t22.status AS status_27,
  t22.processing_at AS processing_at_28,
  t22.sent_at AS sent_at_29,
  t22.failed_reason AS failed_reason_30,
  t22.priority AS priority_31,
  t22.dispateched_at AS dispateched_at_32,
  t22.contact_id AS contact_id_33,
  t22.campaign_id AS campaign_id_34,
  t22.reminder_id AS reminder_id_35,
  t22.message_id AS message_id_36
FROM
  mew_message t0
  LEFT JOIN mew_message_queue t22 ON t22.message_id = t0.id
WHERE
  t0.contact_id = ?
ORDER BY
  t0.date ASC

SELECT t0.id AS id_1, t0.text AS text_2, t0.rich_content AS rich_content_3, t0.information AS information_4, t0.date AS date_5, t0.sender AS sender_6, t0.seen AS seen_7, t0.seen_date AS seen_date_8, t0.date_received AS date_received_9, t0.error_details AS error_details_10, t0.error_number AS error_number_11, t0.scheduled_date AS scheduled_date_12, t0.udh AS udh_13, t0.parts AS parts_14, t0.token AS token_15, t0.public_uuid AS public_uuid_16, t0.contact_id AS contact_id_17, t0.user_id AS user_id_18, t0.seen_user_id AS seen_user_id_19, t0.campaign_id AS campaign_id_20, t0.reminder_id AS reminder_id_21, t22.id AS id_23, t22.content AS content_24, t22.rich_content AS rich_content_25, t22.scheduled_at AS scheduled_at_26, t22.status AS status_27, t22.processing_at AS processing_at_28, t22.sent_at AS sent_at_29, t22.failed_reason AS failed_reason_30, t22.priority AS priority_31, t22.dispateched_at AS dispateched_at_32, t22.contact_id AS contact_id_33, t22.campaign_id AS campaign_id_34, t22.reminder_id AS reminder_id_35, t22.message_id AS message_id_36 FROM mew_message t0 LEFT JOIN mew_message_queue t22 ON t22.message_id = t0.id WHERE t0.contact_id = 1309711 ORDER BY t0.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 90)
8	App\Serializer\ContactNormalizer->normalize (line 50)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
10	Symfony\Component\Serializer\Serializer->normalize (line 131)
11	Symfony\Component\Serializer\Serializer->serialize (line 44)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
14	App\Controller\Api\ApiContactController->get (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 7)

0.06 ms
(5.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_export_lead_by_mail AS active_export_lead_by_mail_3, t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4, t0.object_export_lead_by_mail AS object_export_lead_by_mail_5, t0.api_lead_connector AS api_lead_connector_6, t0.api_lead_connector_source AS api_lead_connector_source_7, t0.api_lead_connector_usage AS api_lead_connector_usage_8, t0.api_lead_connector_context AS api_lead_connector_context_9, t0.reference AS reference_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.company_id AS company_id_13 FROM mew_company_division t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active_export_lead_by_mail AS active_export_lead_by_mail_3,
  t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4,
  t0.object_export_lead_by_mail AS object_export_lead_by_mail_5,
  t0.api_lead_connector AS api_lead_connector_6,
  t0.api_lead_connector_source AS api_lead_connector_source_7,
  t0.api_lead_connector_usage AS api_lead_connector_usage_8,
  t0.api_lead_connector_context AS api_lead_connector_context_9,
  t0.reference AS reference_10,
  t0.token AS token_11,
  t0.public_uuid AS public_uuid_12,
  t0.company_id AS company_id_13
FROM
  mew_company_division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_export_lead_by_mail AS active_export_lead_by_mail_3, t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4, t0.object_export_lead_by_mail AS object_export_lead_by_mail_5, t0.api_lead_connector AS api_lead_connector_6, t0.api_lead_connector_source AS api_lead_connector_source_7, t0.api_lead_connector_usage AS api_lead_connector_usage_8, t0.api_lead_connector_context AS api_lead_connector_context_9, t0.reference AS reference_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.company_id AS company_id_13 FROM mew_company_division t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\CompanyDivision::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\CompanyDivision->__get (line 40)
8	App\Entity\CompanyDivision->getToken (line 411)
9	App\Entity\Contact->getCampaign (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
14	App\Serializer\ContactNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
20	App\Controller\Api\ApiContactController->get (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.06 ms
(5.28%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.token AS token_4, t0.source_id AS source_id_5 FROM mew_tag t0 INNER JOIN mew_tag_contact ON t0.id = mew_tag_contact.tag_id WHERE mew_tag_contact.contact_id = ?

Parameters:

[
  1309711
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.token AS token_4,
  t0.source_id AS source_id_5
FROM
  mew_tag t0
  INNER JOIN mew_tag_contact ON t0.id = mew_tag_contact.tag_id
WHERE
  mew_tag_contact.contact_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.token AS token_4, t0.source_id AS source_id_5 FROM mew_tag t0 INNER JOIN mew_tag_contact ON t0.id = mew_tag_contact.tag_id WHERE mew_tag_contact.contact_id = 1309711;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 68)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 169)
9	App\Entity\Contact->hasTag (line 85)
10	App\Serializer\ContactNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
12	Symfony\Component\Serializer\Serializer->normalize (line 131)
13	Symfony\Component\Serializer\Serializer->serialize (line 44)
14	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
16	App\Controller\Api\ApiContactController->get (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

0.06 ms
(4.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.color AS color_4, t0.token AS token_5, t0.public_uuid AS public_uuid_6 FROM mew_company t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.color AS color_4,
  t0.token AS token_5,
  t0.public_uuid AS public_uuid_6
FROM
  mew_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.color AS color_4, t0.token AS token_5, t0.public_uuid AS public_uuid_6 FROM mew_company t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Company::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Company->__get (line 59)
8	App\Entity\Company->getName (line 413)
9	App\Entity\Contact->getCampaign (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
14	App\Serializer\ContactNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
20	App\Controller\Api\ApiContactController->get (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 7)

0.05 ms
(4.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.parameter_key AS parameter_key_4, t0.token AS token_5, t0.source_id AS source_id_6 FROM mew_source_parameter t0 WHERE t0.source_id = ? ORDER BY t0.position ASC

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.parameter_key AS parameter_key_4,
  t0.token AS token_5,
  t0.source_id AS source_id_6
FROM
  mew_source_parameter t0
WHERE
  t0.source_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.parameter_key AS parameter_key_4, t0.token AS token_5, t0.source_id AS source_id_6 FROM mew_source_parameter t0 WHERE t0.source_id = 37 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 127)
8	App\Entity\ContactCampaign->getDataToMessage (line 433)
9	App\Entity\Contact->getCampaign (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 140)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 39)
14	App\Serializer\ContactNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 141)
20	App\Controller\Api\ApiContactController->get (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\SourceParameter	6
App\Entity\User	2
App\Entity\Tag	2
App\Entity\Message	2
App\Entity\Contact	1
App\Entity\Source	1
App\Entity\PhoneNumber	1
App\Entity\ContactCampaign	1
App\Entity\Campaign	1
App\Entity\CompanyDivisionContact	1
App\Entity\CompanyDivision	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Source	No errors.
App\Entity\Message	No errors.
App\Entity\Contact	No errors.
App\Entity\PhoneNumber	No errors.
App\Entity\Tag	No errors.
App\Entity\Reminder	No errors.
App\Entity\ContactCampaign	No errors.
App\Entity\MessageQueue	No errors.
App\Entity\SourceOrigin	No errors.
App\Entity\TemplateMessage	No errors.
App\Entity\Campaign	No errors.
App\Entity\Stack	No errors.
App\Entity\SourceParameter	No errors.
App\Entity\BlackListGroup	No errors.
App\Entity\BlackListContact	No errors.
App\Entity\CompanyDivisionSource	No errors.
App\Entity\UnmatchedContact	No errors.
App\Entity\ImportFilterStats	No errors.
App\Entity\SourceFilterItem	No errors.
App\Entity\ContactApi	No errors.
App\Entity\CompanyDivisionContact	No errors.
App\Entity\CompanyDivision	The field App\Entity\CompanyDivision#sourceFilterItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SourceFilterItem#companyDivision does not contain the required 'inversedBy="sourceFilterItems"' attribute.
App\Entity\Company	No errors.
App\Entity\Program	No errors.

Symfony Profiler

GET https://test-git.tchatbooster.com/api/contact/get/OP6QFSM6XYFO

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping