Query Metrics
7
Database Queries
3
Different statements
1.69 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.92 ms (54.45%) |
4 |
SELECT i0_.income AS income_0, i0_.countries AS countries_1, i0_.id AS id_2 FROM IncomeCountry i0_ WHERE LOWER(i0_.countries) LIKE LOWER(?) LIMIT 1
Parameters:
[
"%US%"
]
|
|
0.52 ms (30.97%) |
2 |
SELECT p0_.id AS id_0, p0_.stripe_id AS stripe_id_1, p0_.paypal_id AS paypal_id_2, p0_.`name` AS name_3, p0_.`interval` AS interval_4, p0_.intervalCount AS intervalCount_5, p0_.amount AS amount_6, p0_.currency AS currency_7, p0_.toll AS toll_8, p0_.tier AS tier_9, p0_.amountTotal AS amountTotal_10, p0_.amountMonth AS amountMonth_11, p0_.`extra` AS extra_12, p0_.expectedLifetimeValue AS expectedLifetimeValue_13, p0_.googleConversionLabel AS googleConversionLabel_14, p0_.taxes_included AS taxes_included_15, p0_.features_id AS features_id_16, p0_.season_id AS season_id_17 FROM Plan p0_ WHERE p0_.`interval` = ? AND p0_.intervalCount = ? AND p0_.currency = ? AND p0_.season_id = ? AND p0_.tier = ? AND p0_.taxes_included = ? LIMIT 1
Parameters:
[ "month" 1 "USD" 66 "advanced" 1 ] |
|
0.25 ms (14.57%) |
1 |
SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.`default` AS default_2, p0_.active AS active_3, p0_.enabled_for_teams AS enabled_for_teams_4, p0_.availableInCountries_id AS availableInCountries_id_5 FROM PlanSeason p0_ WHERE p0_.availableInCountries_id = ? AND p0_.active = 1 AND p0_.`default` = 1 LIMIT 1
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| read_only | doctrine.dbal.read_only_connection |
| email_productivity | doctrine.dbal.email_productivity_connection |
| realtime_feed | doctrine.dbal.realtime_feed_connection |
| bi | doctrine.dbal.bi_connection |
| contact_comms | doctrine.dbal.contact_comms_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| read_only | doctrine.orm.read_only_entity_manager |
| email_productivity | doctrine.orm.email_productivity_entity_manager |
| realtime_feed | doctrine.orm.realtime_feed_entity_manager |
| bi | doctrine.orm.bi_entity_manager |
| contact_comms | doctrine.orm.contact_comms_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| MailTrack\PaymentBundle\Entity\Plan | 2 |
| MailTrack\Common\Domain\Country\IncomeCountry | 1 |
| MailTrack\PaymentBundle\Entity\PlanSeason | 1 |
| MailTrack\PaymentBundle\Entity\PlanFeatures | 1 |
read_only entity manager
| Class | Amount of managed objects |
|---|
email_productivity entity manager
| Class | Amount of managed objects |
|---|
realtime_feed entity manager
| Class | Amount of managed objects |
|---|
bi entity manager
| Class | Amount of managed objects |
|---|
contact_comms entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
read_only entity manager
| Class | Mapping errors |
|---|---|
| MailTrack\MonitorReply\Domain\MonitorReply | No errors. |
| MailTrack\Track\Domain\IndividualTracking\IndividualTracking | No errors. |
| MailTrack\CRM\Domain\ReadModel\CRMData | No errors. |
| MailTrack\TraceBundle\Entity\Track | No errors. |
email_productivity entity manager
No loaded entities.
realtime_feed entity manager
No loaded entities.
bi entity manager
| Class | Mapping errors |
|---|---|
| MailTrack\Track\Domain\IndividualTracking\BounceRate | No errors. |
contact_comms entity manager
No loaded entities.