Query Metrics
5
Database Queries
5
Different statements
11.13 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.95 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 | 3.07 ms |
SELECT count(s0_.id) AS sclr_0 FROM source s0_ WHERE s0_.code = ? AND s0_.enabled = ? AND s0_.api = ?
Parameters:
[ "kezia-cloud" 1 1 ] |
| 3 | 0.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 | 0.73 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 | 0.72 ms |
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"
]
|
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. |