https://myflix-dev.solutions-mtech.com/

Query Metrics

7 Database Queries
5 Different statements
2.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.07 ms
(39.28%)
3
SELECT t0.id AS id_1, t0.description_fr AS description_fr_2, t0.description_en AS description_en_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.package_id AS package_id_6 FROM package_info t0 WHERE t0.package_id = ?
Parameters:
[
  11
]
0.85 ms
(31.24%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_en AS title_en_3, t0.amount AS amount_4, t0.amount_euro AS amount_euro_5, t0.amount_usd AS amount_usd_6, t0.nbflix AS nbflix_7, t0.unlimited AS unlimited_8, t0.max_nbflix AS max_nbflix_9, t0.on_demand AS on_demand_10, t0.is_deleted AS is_deleted_11, t0.nb_user AS nb_user_12, t0.storage AS storage_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.status AS status_16 FROM package t0 WHERE t0.status = ? AND t0.is_deleted = ? ORDER BY t0.created_at ASC LIMIT 3
Parameters:
[
  1
  0
]
0.30 ms
(11.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.name_en AS name_en_5, t0.iso_code_en AS iso_code_en_6 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.30 ms
(11.14%)
1
SELECT t0.id AS id_1, t0.percent_package AS percent_package_2, t0.amount_storage AS amount_storage_3, t0.amount_storage_euro AS amount_storage_euro_4, t0.amount_storage_usd AS amount_storage_usd_5, t0.amount_register AS amount_register_6, t0.amount_register_euro AS amount_register_euro_7, t0.amount_register_usd AS amount_register_usd_8 FROM default_setting t0
Parameters:
[]
0.20 ms
(7.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.currency AS currency_3, t0.value AS value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7 FROM conversion_rate t0
Parameters:
[]

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\UserFlix No errors.
App\Entity\Myflix No errors.
App\Entity\UserDevice No errors.
App\Entity\ComplaintUser No errors.
App\Entity\ShortcutUserMenu No errors.
App\Entity\MemberPaymentDetails No errors.
App\Entity\StatisticMember No errors.
App\Entity\User No errors.
App\Entity\BannerCapsule No errors.
App\Entity\Banner No errors.
App\Entity\Capsule No errors.
App\Entity\ClictopayTransaction No errors.
App\Entity\CollectionCapsule No errors.
App\Entity\CategoryCapsule No errors.
App\Entity\Conditions No errors.
App\Entity\Contact No errors.
App\Entity\ConversionRate No errors.
App\Entity\DefaultField No errors.
App\Entity\DefaultNotification No errors.
App\Entity\DefaultSetting No errors.
App\Entity\FavoriteQuestion No errors.
App\Entity\Field No errors.
App\Entity\GeneralSetting No errors.
App\Entity\LanguageCapsule No errors.
App\Entity\BlocDashboard No errors.
App\Entity\NoteCapsule No errors.
App\Entity\Notification No errors.
App\Entity\OptionCondition No errors.
App\Entity\OptionList No errors.
App\Entity\PackageInfo No errors.
App\Entity\Package No errors.
App\Entity\QuestionCapsule No errors.
App\Entity\RatingCapsule No errors.
App\Entity\RegisterPaymentDetails No errors.
App\Entity\Representative No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Rubric No errors.
App\Entity\Speaker No errors.
App\Entity\SpecificForm No errors.
App\Entity\StatisticCapsule No errors.
App\Entity\StatisticSearch No errors.
App\Entity\StoragePaymentDetails No errors.
App\Entity\TagCapsule No errors.
App\Entity\ThemeCapsule No errors.
App\Entity\TimeCapsule No errors.
App\Entity\TypeCapsule No errors.
App\Entity\Complaint No errors.
App\Entity\ComplaintResponse No errors.
App\Entity\Lang No errors.
App\Entity\StockReminder No errors.
App\Entity\Logs No errors.
App\Entity\Historic No errors.
App\Entity\Invoice No errors.
App\Entity\OrganizationVideo No errors.
App\Entity\Sectors No errors.