Query Metrics
5
Database Queries
5
Different statements
1.74 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.21 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.status AS status_4, t0.plan AS plan_5, t0.commission_rate AS commission_rate_6, t0.loyalty_expiration_months AS loyalty_expiration_months_7, t0.admin_note AS admin_note_8, t0.stripe_account_id AS stripe_account_id_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.primary_color AS primary_color_12, t0.accent_color AS accent_color_13, t0.bg_color AS bg_color_14, t0.fg_color AS fg_color_15, t0.contact_phone AS contact_phone_16, t0.contact_email AS contact_email_17, t0.contact_address AS contact_address_18, t0.disabled_payment_modes AS disabled_payment_modes_19, t0.pickup_instructions AS pickup_instructions_20, t0.is_itinerant AS is_itinerant_21, t0.legal_representative_phone AS legal_representative_phone_22, t0.legal_representative_role AS legal_representative_role_23, t0.siret AS siret_24, t0.siret_pending AS siret_pending_25, t0.vat_number AS vat_number_26, t0.logo_filename AS logo_filename_27, t0.logo_size AS logo_size_28, t0.logo_mime_type AS logo_mime_type_29, t0.cover_filename AS cover_filename_30, t0.cover_size AS cover_size_31, t0.cover_mime_type AS cover_mime_type_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34 FROM shops t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"popote"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.58 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.price_cents AS price_cents_5, t0.vat_rate AS vat_rate_6, t0.position AS position_7, t0.active AS active_8, t0.open_pricing AS open_pricing_9, t0.unit_of_measure AS unit_of_measure_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.shop_id AS shop_id_13, t0.category_id AS category_id_14 FROM products t0 WHERE t0.slug = ? AND ((t0.shop_id = '5')) LIMIT 1
Parameters:
[
"riz-au-lait"
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.price_delta_cents AS price_delta_cents_4, t0.position AS position_5, t0.active AS active_6, t0.production_mode AS production_mode_7, t0.daily_quota_default AS daily_quota_default_8, t0.daily_quota_by_weekday AS daily_quota_by_weekday_9, t0.shelf_life_days AS shelf_life_days_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.shop_id AS shop_id_13, t0.product_id AS product_id_14 FROM variants t0 WHERE t0.product_id = ? AND ((t0.shop_id = '5'))
Parameters:
[
"19"
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.30 ms |
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.title AS title_2, c0_.content AS content_3, c0_.menu_position AS menu_position_4, c0_.published AS published_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.shop_id AS shop_id_8 FROM cms_pages c0_ WHERE (c0_.published = 1 AND c0_.menu_position IS NOT NULL) AND (c0_.shop_id = '5') ORDER BY c0_.menu_position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
| 5 | 0.22 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt_text AS alt_text_3, t0.position AS position_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.shop_id AS shop_id_9, t0.product_id AS product_id_10 FROM product_photos t0 WHERE t0.product_id = ? AND ((t0.shop_id = '5')) ORDER BY t0.position ASC
Parameters:
[
"19"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Cms\Page | 3 |
| App\Entity\Tenant\Shop | 1 |
| App\Entity\Catalog\Product | 1 |
| App\Entity\Catalog\Category | 1 |
| App\Entity\Catalog\Variant | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Tenant\Shop | No errors. |
| App\Entity\Catalog\Product | No errors. |
| App\Entity\Catalog\Category | No errors. |
| App\Entity\Catalog\Variant | No errors. |
| App\Entity\Catalog\ProductPhoto | No errors. |
| App\Entity\Cms\Page | No errors. |