https://dev-foxorders.fr/api/v2/payments/pay_6p4qYXo1PUlUsIWoNhqgY4/status

Query Metrics

5 Database Queries
5 Different statements
11.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
5.95 ms
(53.46%)
1
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
]
3.07 ms
(27.55%)
1
SELECT count(s0_.id) AS sclr_0 FROM source s0_ WHERE s0_.code = ? AND s0_.enabled = ? AND s0_.api = ?
Parameters:
[
  "kezia-cloud"
  1
  1
]
0.73 ms
(6.55%)
1
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
]
0.72 ms
(6.45%)
1
SELECT t0.id AS id_1, t0.qoodos_id AS qoodos_id_2, t0.multiple AS multiple_3, t0.name AS name_4, t0.status AS status_5, t0.qoodos_tokens AS qoodos_tokens_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.token AS token_9, t10.id AS id_11, t10.name AS name_12, t10.phone AS phone_13, t10.secondary_phone AS secondary_phone_14, t10.fax AS fax_15, t10.email AS email_16, t10.created_at AS created_at_17, t10.updated_at AS updated_at_18, t10.franchise_id AS franchise_id_19, t20.id AS id_21, t20.header AS header_22, t20.enable_header AS enable_header_23, t20.title AS title_24, t20.description AS description_25, t20.keywords AS keywords_26, t20.map AS map_27, t20.google_auth_enabled AS google_auth_enabled_28, t20.apple_auth_enabled AS apple_auth_enabled_29, t20.signup_text AS signup_text_30, t20.created_at AS created_at_31, t20.updated_at AS updated_at_32, t20.franchise_id AS franchise_id_33, t20.locale_id AS locale_id_34 FROM franchise t0 LEFT JOIN company t10 ON t10.franchise_id = t0.id LEFT JOIN parameter t20 ON t20.franchise_id = t0.id WHERE t0.token = ? LIMIT 1
Parameters:
[
  "w8wyCb4xDG"
]
0.67 ms
(6.00%)
1
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"
]

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\Parameter No errors.
App\Entity\Franchise\Social No errors.
App\Entity\Franchise\Color No errors.
App\Entity\Franchise\ExternalLink No errors.
App\Entity\Message\Message No errors.
App\Entity\Franchise\CompanyTranslation No errors.