Query Metrics
565
Database Queries
13
Different statements
315.30 ms
Query time
0
Invalid entities
4442
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
242.65 ms (76.96%) |
483 |
SELECT t0.uuid AS uuid_1, t0.adult_number AS adult_number_2, t0.child_number AS child_number_3, t0.form_result AS form_result_4, t0.comment AS comment_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.workshop_id AS workshop_id_8, t0.occurrence_id AS occurrence_id_9, t0.contact_id AS contact_id_10 FROM workshop_subscriptions t0 WHERE t0.occurrence_id = ?
Parameters:
[
1
]
|
|
21.89 ms (6.94%) |
1 |
SELECT w0_.id AS id_0, w0_.begin_at AS begin_at_1, w0_.end_at AS end_at_2, w0_.status AS status_3, w0_.bookable AS bookable_4, w0_.external_booking AS external_booking_5, w0_.booking_url AS booking_url_6, w0_.min_attendee AS min_attendee_7, w0_.max_attendee AS max_attendee_8, w0_.is_recurrent AS is_recurrent_9, w0_.comment AS comment_10, w0_.description AS description_11, w0_.name AS name_12, w0_.slug AS slug_13, w0_.created_by AS created_by_14, w0_.updated_by AS updated_by_15, w0_.deleted_by AS deleted_by_16, w0_.created_at AS created_at_17, w0_.updated_at AS updated_at_18, p1_.id AS id_19, p1_.color AS color_20, p1_.description AS description_21, p1_.name AS name_22, p1_.slug AS slug_23, p1_.created_by AS created_by_24, p1_.updated_by AS updated_by_25, p1_.deleted_by AS deleted_by_26, p1_.created_at AS created_at_27, p1_.updated_at AS updated_at_28, d2_.opening_hours AS opening_hours_29, s3_.opening_hours AS opening_hours_30, s3_.accept_donation AS accept_donation_31, s3_.donation_hours AS donation_hours_32, w4_.opening_hours AS opening_hours_33, w4_.is_default AS is_default_34, w4_.is_virtual AS is_virtual_35, w4_.accept_donation AS accept_donation_36, w4_.donation_hours AS donation_hours_37, w4_.enabled AS enabled_38, w5_.filter AS filter_39, w6_.id AS id_40, w6_.hidden AS hidden_41, w6_.color AS color_42, w6_.name AS name_43, w6_.enabled AS enabled_44, w6_.description AS description_45, w6_.duration AS duration_46, w6_.min_age AS min_age_47, w6_.educational_goals AS educational_goals_48, w6_.position AS position_49, w6_.public_type AS public_type_50, w6_.slug AS slug_51, w6_.created_by AS created_by_52, w6_.updated_by AS updated_by_53, w6_.deleted_by AS deleted_by_54, w6_.created_at AS created_at_55, w6_.updated_at AS updated_at_56, w7_.id AS id_57, w7_.name AS name_58, w7_.contact_fields AS contact_fields_59, w7_.created_by AS created_by_60, w7_.updated_by AS updated_by_61, w7_.deleted_by AS deleted_by_62, w7_.created_at AS created_at_63, w7_.updated_at AS updated_at_64, w8_.id AS id_65, w8_.start_date AS start_date_66, w8_.end_date AS end_date_67, w8_.enabled AS enabled_68, w8_.cancellation_date AS cancellation_date_69, w8_.cancellation_comment AS cancellation_comment_70, w8_.status AS status_71, w8_.created_at AS created_at_72, w8_.updated_at AS updated_at_73, w0_.place_id AS place_id_74, w0_.workshop_category_id AS workshop_category_id_75, w0_.workshop_form_id AS workshop_form_id_76, w0_.workshop_rrule_id AS workshop_rrule_id_77, p1_.type AS type_78, p1_.picture_id AS picture_id_79, p1_.address_id AS address_id_80, w6_.picture_id AS picture_id_81, w6_.video_id AS video_id_82, w8_.workshop_id AS workshop_id_83 FROM workshops w0_ LEFT JOIN places p1_ ON w0_.place_id = p1_.id LEFT JOIN desks d2_ ON p1_.id = d2_.id LEFT JOIN shops s3_ ON p1_.id = s3_.id LEFT JOIN warehouses w4_ ON p1_.id = w4_.id LEFT JOIN workplaces w5_ ON p1_.id = w5_.id LEFT JOIN workshop_categories w6_ ON w0_.workshop_category_id = w6_.id LEFT JOIN workshop_forms w7_ ON w0_.workshop_form_id = w7_.id LEFT JOIN workshop_occurrences w8_ ON w0_.id = w8_.workshop_id ORDER BY w0_.id ASC
Parameters:
[] |
|
11.41 ms (3.62%) |
35 |
SELECT t0.id AS id_1, t0.hidden AS hidden_2, t0.color AS color_3, t0.name AS name_4, t0.enabled AS enabled_5, t0.description AS description_6, t0.duration AS duration_7, t0.min_age AS min_age_8, t0.educational_goals AS educational_goals_9, t0.position AS position_10, t0.public_type AS public_type_11, t0.slug AS slug_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.picture_id AS picture_id_18, t0.video_id AS video_id_19 FROM workshop_categories t0 WHERE t0.video_id = ?
Parameters:
[
2
]
|
|
11.01 ms (3.49%) |
37 |
SELECT t0.id AS id_1, t0.hidden AS hidden_2, t0.color AS color_3, t0.name AS name_4, t0.enabled AS enabled_5, t0.description AS description_6, t0.duration AS duration_7, t0.min_age AS min_age_8, t0.educational_goals AS educational_goals_9, t0.position AS position_10, t0.public_type AS public_type_11, t0.slug AS slug_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.picture_id AS picture_id_18, t0.video_id AS video_id_19 FROM workshop_categories t0 WHERE t0.picture_id = ?
Parameters:
[
38
]
|
|
9.00 ms (2.86%) |
1 |
SELECT t0.id AS id_1, t0.group_id AS group_id_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.validation_date AS validation_date_5, t0.start_cash AS start_cash_6, t0.end_cash AS end_cash_7, t0.bank_cash AS bank_cash_8, t0.total_weight AS total_weight_9, t0.total AS total_10, t0.num_item AS num_item_11, t0.num_refund AS num_refund_12, t0.num_membership AS num_membership_13, t0.num_payment AS num_payment_14, t0.sales AS sales_15, t0.memberships AS memberships_16, t0.payments AS payments_17, t0.cash_inventory AS cash_inventory_18, t0.status AS status_19, t0.comment AS comment_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.deleted_by AS deleted_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.shop_uuid AS shop_uuid_27 FROM order_groups t0 WHERE t0.shop_uuid IN (?, ?, ?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ "68e2d9f8-68ac-4f78-bd72-b99337e52b34" "b6b17911-6cc2-41e7-aa06-e5f3eed68455" "26057091-014f-4fed-bf81-020cc39d4e58" "91cf7234-eb0c-4cc8-8d20-b07a5883bf30" "dbe606c6-2502-4545-88bf-b74de95a5202" "f78017d8-b74a-4064-897e-f8b47ed16adb" "763d43ff-54d5-4b23-9b00-d9861122d204" "39592778-f5ce-4fb6-8383-c25852d78516" ] |
|
8.62 ms (2.73%) |
1 |
SELECT t0.id AS id_10, t0.filename AS filename_11, t0.original_name AS original_name_12, t0.thumb_path AS thumb_path_13, t0.filesize AS filesize_14, t0.filemime AS filemime_15, t0.img_path AS img_path_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.discr, t1.preview_path AS preview_path_22, t2.preview_path AS preview_path_23, t2.place_id AS place_id_24, t3.preview_path AS preview_path_25, t4.preview_path AS preview_path_26, t4.collect_id AS collect_id_27, t5.preview_path AS preview_path_28, t6.preview_path AS preview_path_29, t6.workshop_category_id AS workshop_category_id_30, t7.preview_path AS preview_path_31, t8.preview_path AS preview_path_32, t9.preview_path AS preview_path_33 FROM medias t0 LEFT JOIN partner_images t1 ON t0.id = t1.id LEFT JOIN place_images t2 ON t0.id = t2.id LEFT JOIN waste_category_images t3 ON t0.id = t3.id LEFT JOIN collect_images t4 ON t0.id = t4.id LEFT JOIN workshop_category_images t5 ON t0.id = t5.id LEFT JOIN workshop_category_medias t6 ON t0.id = t6.id LEFT JOIN letter_images t7 ON t0.id = t7.id LEFT JOIN post_images t8 ON t0.id = t8.id LEFT JOIN timeline_images t9 ON t0.id = t9.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 9641 184 76 133 210 77 62 6969 6971 6970 8663 45 58 9643 9638 9639 9642 9644 49 38 44 14765 15303 17093 17094 18794 18796 17088 19057 19058 18799 20206 20670 20666 20783 46 66 ] |
|
3.11 ms (0.99%) |
1 |
SELECT t0.id AS id_1, t0.begin_at AS begin_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.bookable AS bookable_5, t0.external_booking AS external_booking_6, t0.booking_url AS booking_url_7, t0.min_attendee AS min_attendee_8, t0.max_attendee AS max_attendee_9, t0.is_recurrent AS is_recurrent_10, t0.comment AS comment_11, t0.description AS description_12, t0.name AS name_13, t0.slug AS slug_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.place_id AS place_id_20, t0.workshop_category_id AS workshop_category_id_21, t0.workshop_form_id AS workshop_form_id_22, t0.workshop_rrule_id AS workshop_rrule_id_23 FROM workshops t0 WHERE t0.workshop_category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 55 45 35 37 46 3 4 49 51 50 52 11 10 57 53 54 56 58 1 5 19 61 62 64 65 66 67 63 69 70 68 71 73 72 74 12 22 ] |
|
2.17 ms (0.69%) |
1 |
SELECT t1.id AS id_2, t1.filename AS filename_3, t1.original_name AS original_name_4, t1.thumb_path AS thumb_path_5, t1.filesize AS filesize_6, t1.filemime AS filemime_7, t1.img_path AS img_path_8, t1.created_by AS created_by_9, t1.updated_by AS updated_by_10, t1.deleted_by AS deleted_by_11, t1.created_at AS created_at_12, t1.updated_at AS updated_at_13, t0.preview_path AS preview_path_14, t0.workshop_category_id AS workshop_category_id_15, t1.discr FROM workshop_category_medias t0 INNER JOIN medias t1 ON t0.id = t1.id WHERE t0.workshop_category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 55 45 35 37 46 3 4 49 51 50 52 11 10 57 53 54 56 58 1 5 19 61 62 64 65 66 67 63 69 70 68 71 73 72 74 12 22 ] |
|
1.64 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.complement AS complement_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.valid AS valid_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.geo_city_id AS geo_city_id_15 FROM addresses t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 3079 3089 4 5 2 4655 1 3 5888 6722 8611 10735 11128 12008 12009 12010 ] |
|
1.29 ms (0.41%) |
1 |
SELECT t0.id AS id_2, t0.filename AS filename_3, t0.original_name AS original_name_4, t0.filesize AS filesize_5, t0.filemime AS filemime_6, t0.video_path AS video_path_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.discr FROM videos t0 LEFT JOIN workshop_category_videos t1 ON t0.id = t1.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 30 13 2 14 27 3 5 7 6 25 31 12 33 28 29 32 34 8 26 37 38 40 41 42 43 39 45 46 44 47 49 48 50 24 51 ] |
|
1.02 ms (0.32%) |
1 |
SELECT t0.uuid AS uuid_1, t0.current_cash AS current_cash_2, t0.current_cash_date AS current_cash_date_3, t0.active AS active_4, t0.name AS name_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.shop_id AS shop_id_12 FROM shop_uuids t0 WHERE t0.shop_id IN (?, ?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 4 5 2 46 1 3 55 ] |
|
0.77 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.help AS help_4, t0.required AS required_5, t0.multiple AS multiple_6, t0.slug AS slug_7, t0.workshop_form_id AS workshop_form_id_8 FROM workshop_form_elements t0 WHERE t0.workshop_form_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 4 3 1 2 8 9 7 11 12 13 ] |
|
0.73 ms (0.23%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.workshop_form_element_id AS workshop_form_element_id_4 FROM workshop_form_element_choices t0 WHERE t0.workshop_form_element_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 6 5 4 3 2 10 11 26 27 28 19 25 16 7 9 8 29 15 24 20 ] |
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 |
|---|---|
| Revo\Bundle\OrderBundle\Entity\OrderGroup | 1598 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopSubscription | 755 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopOccurrence | 483 |
| Revo\Bundle\CoreBundle\Entity\Contact | 446 |
| Revo\Bundle\WorkshopBundle\Entity\Workshop | 432 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopRrule | 431 |
| Revo\Bundle\CoreBundle\Entity\Media | 120 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopCategory | 37 |
| Revo\Bundle\CoreBundle\Entity\Video | 35 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopFormElementChoice | 27 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopFormElement | 21 |
| Revo\Bundle\CoreBundle\Entity\Place | 16 |
| Revo\Bundle\CoreBundle\Entity\Address | 16 |
| Revo\Bundle\WorkshopBundle\Entity\WorkshopForm | 10 |
| Revo\Bundle\OrderBundle\Entity\ShopUuid | 8 |
| Revo\Bundle\CoreBundle\Entity\City | 7 |