Query Metrics

8 Database Queries
6 Different statements
11.25 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 2.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.duration AS duration_4, t0.is_visible AS is_visible_5 FROM plan t0 WHERE t0.is_visible = ?
Parameters:
[
  1
]
2 1.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0
Parameters:
[]
3 1.41 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.direction AS direction_8, t0.is_public AS is_public_9, t0.path AS path_10, t0.url AS url_11, t0.is_menu AS is_menu_12, t0.background_id AS background_id_13, t0.image_id AS image_id_14, t0.created_by_id AS created_by_id_15, t0.parent_id AS parent_id_16 FROM cms t0 WHERE t0.is_menu = ? AND t0.is_public = ? AND t0.type = ?
Parameters:
[
  1
  1
  "Page"
]
4 1.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0 INNER JOIN plan_option ON t0.id = plan_option.option_id WHERE plan_option.plan_id = ?
Parameters:
[
  1
]
5 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0 INNER JOIN plan_option ON t0.id = plan_option.option_id WHERE plan_option.plan_id = ?
Parameters:
[
  2
]
6 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0 INNER JOIN plan_option ON t0.id = plan_option.option_id WHERE plan_option.plan_id = ?
Parameters:
[
  3
]
7 1.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_visible AS is_visible_4, t0.joined_at AS joined_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.thumbnail_id AS thumbnail_id_8 FROM cms_partner t0 WHERE t0.is_visible = ?
Parameters:
[
  1
]
8 1.47 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.is_validated AS is_validated_4, t0.is_public AS is_public_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cms_faq t0 WHERE t0.is_public = ?
Parameters:
[
  1
]

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\Plan No errors.
App\Entity\Option No errors.
App\Entity\Cms No errors.
App\Entity\Attachment No errors.
App\Entity\User
  • The field 'App\Entity\User#bannedAt' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\CmsPartner No errors.
App\Entity\Flow No errors.
App\Entity\Article No errors.
App\Entity\Service No errors.
App\Entity\Establishment No errors.
App\Entity\ConnectionLog No errors.
App\Entity\OTP No errors.
App\Entity\UserDetail No errors.
App\Entity\Mutuality No errors.
App\Entity\Planning No errors.
App\Entity\FlowUser No errors.
App\Entity\FlowStep No errors.
App\Entity\Currency No errors.
App\Entity\Collections No errors.
App\Entity\ArticleDepartment No errors.
App\Entity\ArticleSupply No errors.
App\Entity\Tax No errors.
Tchoulom\ViewCounterBundle\Entity\ViewCounter No errors.
App\Entity\ViewCounter No errors.
App\Entity\Department
  • The association App\Entity\Department#collections refers to the owning side field App\Entity\Collections#department which does not exist.
App\Entity\Address No errors.
App\Entity\Document No errors.
App\Entity\Client No errors.
App\Entity\Invitation No errors.
App\Entity\Operation No errors.
App\Entity\Journal No errors.
App\Entity\Supply No errors.
App\Entity\Promotion
  • The association App\Entity\Promotion#orders refers to the owning side field App\Entity\Order#promotion which does not exist.
App\Entity\Rate No errors.
App\Entity\Employee No errors.
App\Entity\Subscription No errors.
App\Entity\Order No errors.
App\Entity\Configuration No errors.
App\Entity\Model No errors.
App\Entity\Menu No errors.
App\Entity\QrCode No errors.
App\Entity\Bot No errors.
App\Entity\Role No errors.
App\Entity\Advertisement No errors.
App\Entity\Contract No errors.
App\Entity\MutualityCategory No errors.
App\Entity\CardType No errors.
App\Entity\Gateway No errors.
App\Entity\WalletOperation No errors.
App\Entity\Card No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Attendance No errors.
App\Entity\Revision No errors.
App\Entity\AdvertisementAttachment No errors.
App\Entity\Invoice No errors.
App\Entity\Contact No errors.
App\Entity\ArticleLog No errors.
App\Entity\CmsContact No errors.
App\Entity\ModelMenu No errors.
App\Entity\Shipment No errors.
App\Entity\LoginAttempt No errors.
App\Entity\Lot No errors.
App\Entity\ArticleDepartmentPackage No errors.
App\Entity\CmsNewsletter No errors.
App\Entity\Notification No errors.
App\Entity\LotConfiguration No errors.
App\Entity\FlowAction No errors.
App\Entity\FlowModel No errors.
App\Entity\Ticket No errors.
App\Entity\Discover No errors.
App\Entity\CmsQuote No errors.
App\Entity\Event No errors.
App\Entity\EmployeeContract No errors.
App\Entity\CmsFaq No errors.
App\Entity\Transaction No errors.
App\Entity\OrderItems No errors.
App\Entity\FlowProcess No errors.
Vich\UploaderBundle\Entity\File No errors.