Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.72 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.72 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.shop_url AS shop_url_4, t0.map_api_key AS map_api_key_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.app_package_name AS app_package_name_8, t0.google_place_id AS google_place_id_9, t0.place_id_secondary AS place_id_secondary_10, t0.shop_secondary_url AS shop_secondary_url_11, t0.rdv_url AS rdv_url_12, t0.rdv_secondary_url AS rdv_secondary_url_13, t0.yzical_user_id AS yzical_user_id_14, t0.use_booking AS use_booking_15, t0.uber_url AS uber_url_16, t0.app_version AS app_version_17, t0.user_id AS user_id_18 FROM cross_app t0 WHERE t0.app_package_name = ? LIMIT 1 Parameters: [`"com.yziapp.centre.dermo.esthetique"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.shop_url AS shop_url_4, t0.map_api_key AS map_api_key_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.app_package_name AS app_package_name_8, t0.google_place_id AS google_place_id_9, t0.place_id_secondary AS place_id_secondary_10, t0.shop_secondary_url AS shop_secondary_url_11, t0.rdv_url AS rdv_url_12, t0.rdv_secondary_url AS rdv_secondary_url_13, t0.yzical_user_id AS yzical_user_id_14, t0.use_booking AS use_booking_15, t0.uber_url AS uber_url_16, t0.app_version AS app_version_17, t0.user_id AS user_id_18 FROM cross_app t0 WHERE t0.app_package_name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.shop_url AS shop_url_4, t0.map_api_key AS map_api_key_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.app_package_name AS app_package_name_8, t0.google_place_id AS google_place_id_9, t0.place_id_secondary AS place_id_secondary_10, t0.shop_secondary_url AS shop_secondary_url_11, t0.rdv_url AS rdv_url_12, t0.rdv_secondary_url AS rdv_secondary_url_13, t0.yzical_user_id AS yzical_user_id_14, t0.use_booking AS use_booking_15, t0.uber_url AS uber_url_16, t0.app_version AS app_version_17, t0.user_id AS user_id_18 FROM cross_app t0 WHERE t0.app_package_name = 'com.yziapp.centre.dermo.esthetique' LIMIT 1;

#▲

Time

Info

0.72 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.shop_url AS shop_url_4, t0.map_api_key AS map_api_key_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.app_package_name AS app_package_name_8, t0.google_place_id AS google_place_id_9, t0.place_id_secondary AS place_id_secondary_10, t0.shop_secondary_url AS shop_secondary_url_11, t0.rdv_url AS rdv_url_12, t0.rdv_secondary_url AS rdv_secondary_url_13, t0.yzical_user_id AS yzical_user_id_14, t0.use_booking AS use_booking_15, t0.uber_url AS uber_url_16, t0.app_version AS app_version_17, t0.user_id AS user_id_18 FROM cross_app t0 WHERE t0.app_package_name = ? LIMIT 1

Parameters:

[
  "com.yziapp.centre.dermo.esthetique"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.shop_url AS shop_url_4,
  t0.map_api_key AS map_api_key_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.app_package_name AS app_package_name_8,
  t0.google_place_id AS google_place_id_9,
  t0.place_id_secondary AS place_id_secondary_10,
  t0.shop_secondary_url AS shop_secondary_url_11,
  t0.rdv_url AS rdv_url_12,
  t0.rdv_secondary_url AS rdv_secondary_url_13,
  t0.yzical_user_id AS yzical_user_id_14,
  t0.use_booking AS use_booking_15,
  t0.uber_url AS uber_url_16,
  t0.app_version AS app_version_17,
  t0.user_id AS user_id_18
FROM
  cross_app t0
WHERE
  t0.app_package_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.shop_url AS shop_url_4, t0.map_api_key AS map_api_key_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.app_package_name AS app_package_name_8, t0.google_place_id AS google_place_id_9, t0.place_id_secondary AS place_id_secondary_10, t0.shop_secondary_url AS shop_secondary_url_11, t0.rdv_url AS rdv_url_12, t0.rdv_secondary_url AS rdv_secondary_url_13, t0.yzical_user_id AS yzical_user_id_14, t0.use_booking AS use_booking_15, t0.uber_url AS uber_url_16, t0.app_version AS app_version_17, t0.user_id AS user_id_18 FROM cross_app t0 WHERE t0.app_package_name = 'com.yziapp.centre.dermo.esthetique' LIMIT 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\CrossApp	The mappings App\Entity\CrossApp#status and App\Entity\AppGallery#app are inconsistent with each other.
App\Entity\User	No errors.
App\Entity\AppSlides	No errors.
App\Entity\AppGallery	No errors.
App\Entity\ContactCoords	No errors.
App\Entity\AppFb	No errors.
App\Entity\AppItineraire	No errors.
App\Entity\AppAbout	No errors.
App\Entity\AppCarteMenu	No errors.
App\Entity\AppCarteMenuType	No errors.
App\Entity\NotificationPush	No errors.
App\Entity\AppDeviceToken	No errors.
App\Entity\FcmToken	No errors.
App\Entity\Formations	No errors.
App\Entity\AppEvent	No errors.
App\Entity\Pages	The association App\Entity\Pages#advertisers refers to the owning side field App\Entity\Advertisers#chu which is not defined as association, but as field. The association App\Entity\Pages#advertisers refers to the owning side field App\Entity\Advertisers#chu which does not exist.
App\Entity\AppEmail	No errors.
App\Entity\QuestionResponse	No errors.
App\Entity\AppCarteMenuBrand	No errors.
App\Entity\DanceType	No errors.
App\Entity\DancePlaning	No errors.
App\Entity\Advertisers	No errors.

Symfony Profiler

https://appadmin.yziapp.com/privacy?pkg=com.yziapp.centre.dermo.esthetique

Configuration Settings

Theme