https://dev-foxorders.fr/api/v2/franchises/domain?url=https%3A%2F%2Fbornelouvine.dev-foxorders.fr

Query Metrics

7 Database Queries
7 Different statements
10.53 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.dsn AS dsn_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mail_transport t0 WHERE t0.enabled = ? LIMIT 1
Parameters:
[
  1
]
2 1.28 ms
SELECT count(s0_.id) AS sclr_0 FROM source s0_ WHERE s0_.code = ? AND s0_.enabled = ? AND s0_.api = ?
Parameters:
[
  "foxorders-front"
  1
  1
]
3 1.67 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.facebook_id AS facebook_id_6, t0.google_id AS google_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.gender AS gender_10, t0.phone AS phone_11, t0.landline_phone AS landline_phone_12, t0.accepted_tou AS accepted_tou_13, t0.image_url AS image_url_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.image_name AS image_name_19, t0.image_original_name AS image_original_name_20, t0.image_mime_type AS image_mime_type_21, t0.image_size AS image_size_22, t0.image_dimensions AS image_dimensions_23, t0.discr, t0.franchise_id AS franchise_id_24, t0.shop_id AS shop_id_25, t0.device_id AS device_id_26, t0.notification_email AS notification_email_27, t0.notification_sms AS notification_sms_28, t0.receive_qoodos_notification AS receive_qoodos_notification_29, t0.default_language AS default_language_30, t0.source AS source_31, t0.phone_verified AS phone_verified_32 FROM user t0 WHERE t0.email = ? AND t0.discr IN ('user', 'manager', 'shopmanager', 'customer', 'administrator', 'support', 'developer') AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "api@foxorders.com"
]
4 2.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.importance AS importance_4, t0.enabled AS enabled_5 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
  703
]
5 1.29 ms
SELECT f0_.id AS id_0, f0_.qoodos_id AS qoodos_id_1, f0_.multiple AS multiple_2, f0_.name AS name_3, f0_.status AS status_4, f0_.qoodos_tokens AS qoodos_tokens_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.token AS token_8 FROM franchise f0_ INNER JOIN domain d1_ ON f0_.id = d1_.franchise_id WHERE d1_.url = ? LIMIT 1
Parameters:
[
  "https://bornelouvine.dev-foxorders.fr"
]
6 1.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.secondary_phone AS secondary_phone_4, t0.fax AS fax_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.franchise_id AS franchise_id_9 FROM company t0 WHERE t0.franchise_id = ?
Parameters:
[
  14
]
7 1.29 ms
SELECT t0.id AS id_1, t0.header AS header_2, t0.enable_header AS enable_header_3, t0.title AS title_4, t0.description AS description_5, t0.keywords AS keywords_6, t0.map AS map_7, t0.google_auth_enabled AS google_auth_enabled_8, t0.apple_auth_enabled AS apple_auth_enabled_9, t0.signup_text AS signup_text_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.franchise_id AS franchise_id_13, t0.locale_id AS locale_id_14 FROM parameter t0 WHERE t0.franchise_id = ?
Parameters:
[
  14
]

Database Connections

Name Service
default doctrine.dbal.default_connection
foxorders_v1 doctrine.dbal.foxorders_v1_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\Admin\Locale No errors.
App\Entity\Payment\Payment No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Product\Product\Product No errors.
App\Entity\Product\Product\StepItem No errors.
App\Entity\Product\ProductCategory No errors.
App\Entity\Admin\Webhook\Webhook No errors.
App\Entity\Admin\Webhook\Notification No errors.
App\Entity\Security\User No errors.
App\Entity\Security\Customer No errors.
App\Entity\Franchise\Domain No errors.
App\Entity\Admin\Source No errors.
App\Entity\Shop\Shop No errors.
App\Entity\Device\Device No errors.
App\Entity\Franchise\Franchise No errors.
App\Entity\Franchise\CustomerFranchise No errors.
App\Entity\Shop\CustomerShop No errors.
App\Entity\Franchise\Application No errors.
App\Entity\Shop\ShopMode No errors.
App\Entity\Franchise\Media No errors.
App\Entity\Order\Order No errors.
App\Entity\Order\OrderItem No errors.
App\Entity\Admin\MailTransport No errors.
App\Entity\Product\OptionVariant\OptionVariant No errors.
App\Entity\Shop\OpeningHours No errors.
App\Entity\Shop\Zone No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\Security\RefreshToken No errors.
App\Entity\Security\Manager No errors.
App\Entity\Security\ShopManager No errors.
App\Entity\Security\Administrator No errors.
App\Entity\Security\Support No errors.
App\Entity\Security\Developer No errors.
App\Entity\Security\Role No errors.
App\Entity\Event\Event No errors.
App\Entity\Shop\Menu No errors.
App\Entity\Franchise\Company No errors.
App\Entity\Franchise\CompanyTranslation No errors.
App\Entity\Franchise\Social No errors.
App\Entity\Franchise\Color No errors.
App\Entity\Franchise\Parameter No errors.
App\Entity\Franchise\Slide No errors.
App\Entity\Franchise\ExternalLink No errors.
App\Entity\Message\Message No errors.