Query Metrics
3
Database Queries
3
Different statements
1.40 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.44 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 | 0.55 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.image_url AS image_url_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.image_original_name AS image_original_name_19, t0.image_mime_type AS image_mime_type_20, t0.image_size AS image_size_21, t0.image_dimensions AS image_dimensions_22, t0.discr, t0.franchise_id AS franchise_id_23, t0.shop_id AS shop_id_24, t0.device_id AS device_id_25, t0.notification_email AS notification_email_26, t0.notification_sms AS notification_sms_27, t0.receive_qoodos_notification AS receive_qoodos_notification_28, t0.default_language AS default_language_29, t0.source AS source_30 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'manager', 'shopmanager', 'customer', 'administrator', 'support') AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
| 3 | 0.41 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:
[
2
]
|
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. |
| 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\Franchise\Domain | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Shop\Shop | No errors. |
| App\Entity\Admin\Source | No errors. |
| App\Entity\Device\Device | No errors. |
| App\Entity\Franchise\Franchise | No errors. |
| App\Entity\Franchise\CustomerFranchise | No errors. |
| App\Entity\Security\User | No errors. |
| App\Entity\Security\Customer | No errors. |
| App\Entity\Shop\CustomerShop | No errors. |
| App\Entity\Franchise\Application | No errors. |
| App\Entity\Franchise\Media | No errors. |
| App\Entity\Order\Order | No errors. |
| App\Entity\Message\Message | No errors. |
| App\Entity\Message\Email | No errors. |
| App\Entity\Admin\MailTransport | No errors. |
| App\Entity\Product\OptionVariant\OptionVariant | No errors. |
| App\Entity\Order\OrderItem | No errors. |
| App\Entity\Shop\OpeningHours | No errors. |
| App\Entity\Product\Product\Product | No errors. |
| App\Entity\Security\Manager | No errors. |
| App\Entity\Shop\Zone | No errors. |
| App\Entity\Security\ShopManager | No errors. |
| App\Entity\Security\Administrator | No errors. |
| App\Entity\Security\Support | No errors. |
| App\Entity\Security\Role | No errors. |
| App\Entity\Event\Event | No errors. |
| App\Entity\Shop\Menu | No errors. |