Query Metrics

5 Database Queries
5 Different statements
1.15 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_path AS image_path_3, t0.payment_alert AS payment_alert_4, t0.enabled_indexing AS enabled_indexing_5, t0.enabled_chat_bot AS enabled_chat_bot_6, t0.slogan AS slogan_7, t0.can_share_content AS can_share_content_8, t0.owner_id AS owner_id_9, t0.configuration_id AS configuration_id_10 FROM channel_channels t0 WHERE t0.id = ?
Parameters:
[
  "e231122f-1f18-11e9-8180-00163e87308f"
]
2 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.siret AS siret_4, t0.industry AS industry_5, t0.phone_number AS phone_number_6, t0.count_employees AS count_employees_7, t0.address_street AS address_street_8, t0.address_post_code AS address_post_code_9, t0.address_city AS address_city_10, t0.address_country AS address_country_11, t0.channel_id AS channel_id_12 FROM channel_company t0 WHERE t0.id = ?
Parameters:
[
  "1f18be9f-9546-6886-9f06-6bdb061bcbd2"
]
3 0.22 ms
SELECT t0.id AS id_1, t0.enabled_crm AS enabled_crm_2, t0.channel_id AS channel_id_3, t4.id AS id_5, t4.name AS name_6, t4.image_path AS image_path_7, t4.payment_alert AS payment_alert_8, t4.enabled_indexing AS enabled_indexing_9, t4.enabled_chat_bot AS enabled_chat_bot_10, t4.slogan AS slogan_11, t4.can_share_content AS can_share_content_12, t4.owner_id AS owner_id_13, t4.configuration_id AS configuration_id_14 FROM channel_configuration t0 INNER JOIN channel_channels t4 ON t0.channel_id = t4.id WHERE t0.id = ?
Parameters:
[
  152
]
4 0.26 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM crm_opportunity c0_ LEFT JOIN channel_contacts c1_ ON c0_.target_contact_id = c1_.id LEFT JOIN contacts c2_ ON c1_.contact_id = c2_.id LEFT JOIN channel_company c3_ ON c0_.target_company_id = c3_.id WHERE c0_.archived_at IS NULL AND c0_.channel_id = ? AND c0_.target_company_id = ?
Parameters:
[
  "e231122f-1f18-11e9-8180-00163e87308f"
  "1f18be9f-9546-6886-9f06-6bdb061bcbd2"
]
5 0.16 ms
SELECT DISTINCT c0_.id AS id_0, c0_.created_at AS created_at_1 FROM crm_opportunity c0_ LEFT JOIN channel_contacts c1_ ON c0_.target_contact_id = c1_.id LEFT JOIN contacts c2_ ON c1_.contact_id = c2_.id LEFT JOIN channel_company c3_ ON c0_.target_company_id = c3_.id WHERE c0_.archived_at IS NULL AND c0_.channel_id = ? AND c0_.target_company_id = ? ORDER BY c0_.created_at DESC LIMIT 50
Parameters:
[
  "e231122f-1f18-11e9-8180-00163e87308f"
  "1f18be9f-9546-6886-9f06-6bdb061bcbd2"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Channel\Channel
  • The association App\Entity\Channel\Channel#contacts refers to the owning side field App\Entity\Common\Contact#channels which does not exist.
Nellapp\Bundle\SDKBundle\Auth\Entity\Token No errors.
App\Entity\Account\User No errors.
App\Entity\Channel\ChannelConfiguration No errors.
Nellapp\Bundle\SDKBundle\Entity\Common\Address\Address No errors.
App\Entity\Common\Contact No errors.
App\Entity\Channel\Drive No errors.
App\Entity\Channel\Company No errors.
App\Entity\Crm\Embed\TextContent No errors.
App\Entity\Crm\Embed\Money No errors.
App\Entity\Crm\Opportunity\Opportunity No errors.
App\Entity\Channel\CompanyContact No errors.
App\Entity\Channel\ChannelContact No errors.