Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

4.20 ms Query time

6 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	1.08 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	2.06 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"mts"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mts' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	1.06 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

1.08 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

2.06 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "mts"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'mts'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

1.06 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection
redshift	doctrine.dbal.redshift_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
redshift	doctrine.orm.redshift_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Advertiser	No errors.
App\Entity\AdvertiserIpWhitelist	No errors.
App\Entity\Affiliate	No errors.
App\Entity\AffiliateAdvertiserBlock	No errors.
App\Entity\AffiliateOfferAccess	No errors.
App\Entity\AffiliateOfferBlock	No errors.
App\Entity\Click	No errors.
App\Entity\ClickCap	No errors.
App\Entity\Conversion	No errors.
App\Entity\ConversionPixel	No errors.
App\Entity\Employees	No errors.
App\Entity\IP2LocationDb3	No errors.
App\Entity\Locations	The association App\Entity\Locations#offers refers to the owning side field App\Entity\OfferLocation#location which does not exist.
App\Entity\MediaObject	No errors.
App\Entity\OAuth2ClientProfile	No errors.
App\Entity\OAuth2UserConsent	No errors.
App\Entity\Offer	No errors.
App\Entity\OfferAffiliateCapping	No errors.
App\Entity\OfferCountry	The association App\Entity\OfferCountry#offer refers to the inverse side field App\Entity\Offer#countries which does not exist.
App\Entity\OfferDisabledLink	No errors.
App\Entity\OfferGoal	No errors.
App\Entity\OfferLocation	No errors.
App\Entity\OfferMedia	No errors.
App\Entity\OfferOsTargetingRule	No errors.
App\Entity\OfferUrlMacros	No errors.
App\Entity\OsTargetingRule	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Roles	No errors.
FOS\UserBundle\Model\User	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.
League\Bundle\OAuth2ServerBundle\Model\AbstractClient	No errors.
League\Bundle\OAuth2ServerBundle\Model\AuthorizationCode	No errors.
League\Bundle\OAuth2ServerBundle\Model\RefreshToken	No errors.
League\Bundle\OAuth2ServerBundle\Model\Client	No errors.
League\Bundle\OAuth2ServerBundle\Model\AccessToken	No errors.

redshift entity manager

Class	Mapping errors
App\Entity\Advertiser	No errors.
App\Entity\AdvertiserIpWhitelist	No errors.
App\Entity\Affiliate	No errors.
App\Entity\AffiliateAdvertiserBlock	No errors.
App\Entity\AffiliateOfferAccess	No errors.
App\Entity\AffiliateOfferBlock	No errors.
App\Entity\Click	No errors.
App\Entity\ClickCap	No errors.
App\Entity\Conversion	No errors.
App\Entity\ConversionPixel	No errors.
App\Entity\Employees	No errors.
App\Entity\IP2LocationDb3	No errors.
App\Entity\Locations	The association App\Entity\Locations#offers refers to the owning side field App\Entity\OfferLocation#location which does not exist.
App\Entity\MediaObject	No errors.
App\Entity\OAuth2ClientProfile	The target entity 'League\Bundle\OAuth2ServerBundle\Model\Client' specified on App\Entity\OAuth2ClientProfile#client is unknown or not an entity.
App\Entity\OAuth2UserConsent	The target entity 'League\Bundle\OAuth2ServerBundle\Model\Client' specified on App\Entity\OAuth2UserConsent#client is unknown or not an entity.
App\Entity\Offer	No errors.
App\Entity\OfferAffiliateCapping	No errors.
App\Entity\OfferCountry	The association App\Entity\OfferCountry#offer refers to the inverse side field App\Entity\Offer#countries which does not exist.
App\Entity\OfferDisabledLink	No errors.
App\Entity\OfferGoal	No errors.
App\Entity\OfferLocation	No errors.
App\Entity\OfferMedia	No errors.
App\Entity\OfferOsTargetingRule	No errors.
App\Entity\OfferUrlMacros	No errors.
App\Entity\OsTargetingRule	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Roles	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://mts-api.mobupps.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

redshift entity manager