Query Metrics
3
Database Queries
3
Different statements
22.07 ms
Query time
4
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.53 ms (61.29%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 INNER JOIN workshop_user ON t0.id = workshop_user.user_id WHERE workshop_user.workshop_id = ? AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet')
Parameters:
[
"1682a2ad-2f77-4d11-85a6-7abe83bcd0d2"
]
|
|
7.54 ms (34.15%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.time_zone AS time_zone_3, t0.activity AS activity_4, t0.supported_practice_type AS supported_practice_type_5, t0.supported_bike_type AS supported_bike_type_6, t0.services_provided AS services_provided_7, t0.electric_bike_accepted AS electric_bike_accepted_8, t0.supported_motor_brands AS supported_motor_brands_9, t0.supported_brands AS supported_brands_10, t0.motor_position AS motor_position_11, t0.social_network_links AS social_network_links_12, t0.description AS description_13, t0.contact AS contact_14, t0.booking_type AS booking_type_15, t0.status AS status_16, t0.opening_hours AS opening_hours_17, t0.time_slots AS time_slots_18, t0.availability_calendar AS availability_calendar_19, t0.location AS location_20, t0.gallery AS gallery_21, t0.schedule AS schedule_22, t0.service_pricing AS service_pricing_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.avatar_path AS avatar_path_26, t0.city AS city_27, t0.postal_code AS postal_code_28, t0.lat AS lat_29, t0.lng AS lng_30, t0.radius AS radius_31, t0.next_available_date AS next_available_date_32, t0.bike_type_keys AS bike_type_keys_33, t0.services_provided_keys AS services_provided_keys_34, t0.practice_type_keys AS practice_type_keys_35, t0.motor_brands AS motor_brands_36, t0.motor_positions AS motor_positions_37, t0.country AS country_38, t0.address AS address_39, t0.company_name AS company_name_40, t0.siret AS siret_41, t0.num_vat AS num_vat_42, t0.rate_vat AS rate_vat_43, t0.billing_address AS billing_address_44, t0.shipping_address AS shipping_address_45, t0.billing_mail AS billing_mail_46, t0.kbis_name AS kbis_name_47, t0.rib_name AS rib_name_48, t0.assurance_name AS assurance_name_49, t0.kbis_path AS kbis_path_50, t0.rib_path AS rib_path_51, t0.assurance_path AS assurance_path_52, t0.currency AS currency_53, t0.stripe_account_id AS stripe_account_id_54, t0.stripe_charges_enabled AS stripe_charges_enabled_55, t0.stripe_payouts_enabled AS stripe_payouts_enabled_56, t57.id AS id_58, t57.date AS date_59, t57.mileage AS mileage_60, t57.malfunction AS malfunction_61, t57.comment AS comment_62, t57.next_recommended_visit AS next_recommended_visit_63, t57.interventions AS interventions_64, t57.workshop_id AS workshop_id_65, t57.appointment_id AS appointment_id_66, t57.bike_id AS bike_id_67 FROM workshop t0 LEFT JOIN bike_history t57 ON t57.workshop_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"1682a2ad-2f77-4d11-85a6-7abe83bcd0d2"
]
|
|
1.01 ms (4.57%) |
1 |
SELECT a0_.start_date AS start_date_0, a0_.end_date AS end_date_1 FROM appointment a0_ INNER JOIN workshop w1_ ON a0_.workshop_id = w1_.id WHERE w1_.id = ? AND a0_.start_date >= ? AND a0_.start_date <= ? AND a0_.status NOT IN (?) ORDER BY a0_.start_date ASC
Parameters:
[ "1682a2ad-2f77-4d11-85a6-7abe83bcd0d2" "2026-02-21 00:00:00" "2026-05-22 08:48:54" "CANCELED" ] |
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\Workshop | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Workshop |
|
| App\Entity\BikeHistory | No errors. |
| App\Entity\Appointment |
|
| App\Entity\Bike |
|
| App\Entity\User | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Repairer | No errors. |
| App\Entity\Manager | No errors. |
| App\Entity\Fleet |
|