Query Metrics
5
Database Queries
5
Different statements
1.17 ms
Query time
0
Invalid entities
61
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.38 ms (32.69%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.status AS status_4, a0_.price AS price_5, a0_.price_on_request AS price_on_request_6, a0_.year AS year_7, a0_.is_unique AS is_unique_8, a0_.edition_number AS edition_number_9, a0_.edition_total AS edition_total_10, a0_.height AS height_11, a0_.width AS width_12, a0_.depth AS depth_13, a0_.weight AS weight_14, a0_.shipping_weight AS shipping_weight_15, a0_.video_url AS video_url_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.published_at AS published_at_19, a0_.sold_at AS sold_at_20, a1_.id AS id_21, a1_.artist_name AS artist_name_22, a1_.slug AS slug_23, a1_.bio AS bio_24, a1_.profile_photo AS profile_photo_25, a1_.cover_photo AS cover_photo_26, a1_.city AS city_27, a1_.department AS department_28, a1_.region AS region_29, a1_.postal_code AS postal_code_30, a1_.country AS country_31, a1_.siret AS siret_32, a1_.cgv_filename AS cgv_filename_33, a1_.latitude AS latitude_34, a1_.longitude AS longitude_35, a1_.workshop_visitable AS workshop_visitable_36, a1_.workshop_hours AS workshop_hours_37, a1_.workshop_address AS workshop_address_38, a1_.website AS website_39, a1_.instagram AS instagram_40, a1_.facebook AS facebook_41, a1_.stripe_account_id AS stripe_account_id_42, a1_.stripe_onboarding_status AS stripe_onboarding_status_43, a1_.subscription_status AS subscription_status_44, a1_.subscription_stripe_id AS subscription_stripe_id_45, a1_.created_at AS created_at_46, a1_.updated_at AS updated_at_47, a0_.artisan_id AS artisan_id_48, a0_.category_id AS category_id_49, a1_.user_id AS user_id_50 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN (?) GROUP BY a0_.id, a1_.id ORDER BY a0_.created_at DESC LIMIT 24
Parameters:
[
"for_sale"
]
|
||||||||||||||||||||||||||||||
|
0.28 ms (24.29%) |
1 |
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN (?)
Parameters:
[
"for_sale"
]
|
||||||||||||||||||||||||||||||
|
0.18 ms (15.40%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.description AS description_3 FROM technique t0_ ORDER BY t0_.name ASC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.16 ms (14.11%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.icon AS icon_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.16 ms (13.50%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM material m0_ ORDER BY m0_.name ASC LIMIT 20
Parameters:
[]
|
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\Category | 21 |
| App\Entity\Technique | 20 |
| App\Entity\Material | 20 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Artwork | No errors. |
| App\Entity\Artisan | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Technique | No errors. |
| App\Entity\Material | No errors. |