Query Metrics
4
Database Queries
4
Different statements
1.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.64 ms (37.08%) |
1 |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.description AS description_2, w0_.duration AS duration_3, w0_.capacity AS capacity_4, w0_.price AS price_5, w0_.tva AS tva_6, w0_.color AS color_7, w0_.image AS image_8, w0_.created_at AS created_at_9, w0_.updated_at AS updated_at_10, w0_.delay AS delay_11, w0_.delay_type AS delay_type_12, w0_.coef_majoration AS coef_majoration_13, w0_.is_fixed_price AS is_fixed_price_14, w0_.fixed_purchase_price AS fixed_purchase_price_15, w0_.fixed_selling_price AS fixed_selling_price_16, w0_.marketplace_family AS marketplace_family_17, w0_.marketplace_is_display AS marketplace_is_display_18, w0_.is_virtual AS is_virtual_19, w0_.banner_image AS banner_image_20, w0_.tag_id AS tag_id_21, w0_.company_id AS company_id_22, w0_.specialist_id AS specialist_id_23, w0_.marketplace_category_id AS marketplace_category_id_24 FROM workshop w0_ WHERE w0_.marketplace_is_display = 1 AND w0_.marketplace_is_display = ? AND w0_.is_virtual = ? AND w0_.id IN (?)
Parameters:
[ "1" "" [ 15 16 17 18 19 20 22 23 ] ] |
|
0.55 ms (31.61%) |
1 |
SELECT s0_.id AS id_0, s0_.seo_title AS seo_title_1, s0_.seo_description AS seo_description_2, s0_.page_name AS page_name_3, s0_.search_town AS search_town_4, s0_.search_family AS search_family_5, s0_.search_marketplace_category AS search_marketplace_category_6, s0_.search_env AS search_env_7, s0_.search_is_virtual AS search_is_virtual_8 FROM seo s0_ WHERE s0_.page_name = ? AND s0_.search_env = 'collective'
Parameters:
[
"marketplace_app_event_all"
]
|
|
0.35 ms (20.07%) |
1 |
SELECT count(DISTINCT w0_.id) AS sclr_0 FROM workshop w0_ WHERE w0_.marketplace_is_display = 1 AND w0_.marketplace_is_display = ? AND w0_.is_virtual = ?
Parameters:
[
"1"
""
]
|
|
0.20 ms (11.25%) |
1 |
SELECT DISTINCT w0_.id AS id_0 FROM workshop w0_ WHERE w0_.marketplace_is_display = 1 AND w0_.marketplace_is_display = ? AND w0_.is_virtual = ? LIMIT 10
Parameters:
[
"1"
""
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\MarketplaceReservation | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AffiliatedEventApplication | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\VisioEvent | No errors. |
| App\Entity\VisioEventPromotion | No errors. |
| App\Entity\Seo | No errors. |
| App\Entity\Workshop | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Specialist | No errors. |
| App\Entity\MarketplaceCategory | No errors. |