Query Metrics
5
Database Queries
5
Different statements
1.15 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.27 ms (23.27%) |
1 |
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"
]
|
|
0.26 ms (22.64%) |
1 |
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" ] |
|
0.25 ms (21.69%) |
1 |
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"
]
|
|
0.22 ms (18.82%) |
1 |
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
]
|
|
0.16 ms (13.59%) |
1 |
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 |
|
| 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. |