POST http://dev.amply.tools/admin/graphql/

Query Metrics

4 Database Queries
4 Different statements
4.91 ms Query time
2 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.60 ms
(32.66%)
1
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "yankervip@gmail.com"
]
1.14 ms
(23.19%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.state AS state_3, t0.name AS name_4, t0.triggering AS triggering_5, t0.targeting AS targeting_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.project_id AS project_id_10 FROM campaign t0 WHERE t0.id = ?
Parameters:
[
  "18779279-4d83-40eb-a246-42c3ab9dfa12"
]
1.11 ms
(22.59%)
1
SELECT s0_.date AS date_0, s0_.count AS count_1, s0_.id AS id_2, s0_.campaign_id AS campaign_id_3 FROM statistics_campaign_impression s0_ WHERE (s0_.date BETWEEN ? AND ?) AND s0_.campaign_id = ?
Parameters:
[
  "2025-04-04 00:00:00"
  "2025-05-04 00:00:00"
  "18779279-4d83-40eb-a246-42c3ab9dfa12"
]
1.06 ms
(21.56%)
1
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.id IN (?)
Parameters:
[
  "c30db438-3e6b-42f2-8983-e7faecfba38c"
]

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
Amply\Administration\Entity\AmplyUser 1
Amply\Campaign\Entity\Campaign 1
Amply\Administration\Entity\Project 1
Amply\Administration\Entity\Application 1

Entities Mapping

Class Mapping errors
Amply\Administration\Entity\AmplyUser No errors.
Amply\Administration\Entity\Organization No errors.
Amply\Campaign\Entity\Campaign No errors.
Amply\Administration\Entity\Project No errors.
Amply\Administration\Entity\Application No errors.
Amply\Administration\Entity\ApiKey No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
Amply\Administration\Entity\RefreshToken No errors.
Amply\Administration\Entity\ResetPassword No errors.
Amply\TM\Apple\Entity\Transaction No errors.
Amply\TM\Apple\Entity\Subscription No errors.
Amply\TM\Apple\Entity\DeviceTransaction No errors.
Amply\Attribution\Entity\AdjustAttribution No errors.
Amply\Attribution\Entity\CustomAttribution No errors.
Amply\Attribution\Entity\SystemAttribution No errors.
Amply\Attribution\Entity\AppleSearchAdsAttribution No errors.
Amply\Attribution\Entity\AppsFlyerAttribution No errors.
Amply\Device\Entity\Device No errors.
Amply\Statistics\Entity\CampaignStatistics\CampaignStatistics
  • The association Amply\Statistics\Entity\CampaignStatistics\CampaignStatistics#campaign refers to the inverse side field Amply\Campaign\Entity\Campaign#targetingCollection which does not exist.
Amply\Statistics\Entity\CampaignStatistics\ImpressionCampaignStatistics
  • The association Amply\Statistics\Entity\CampaignStatistics\ImpressionCampaignStatistics#campaign refers to the inverse side field Amply\Campaign\Entity\Campaign#targetingCollection which does not exist.