Query Metrics
3
Database Queries
3
Different statements
3.39 ms
Query time
0
Invalid entities
4
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.56 ms |
SELECT t0.id AS id_1, t0.role_title AS role_title_2, t0.project_title AS project_title_3, t0.medium AS medium_4, t0.location AS location_5, t0.due_date AS due_date_6, t0.due_time AS due_time_7, t0.status AS status_8, t0.outcome AS outcome_9, t0.fee AS fee_10, t0.priority AS priority_11, t0.notes AS notes_12, t0.sides_file_url AS sides_file_url_13, t0.self_tape_links AS self_tape_links_14, t0.checklist AS checklist_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.reminder_minutes AS reminder_minutes_18, t0.reminder_sent_at AS reminder_sent_at_19, t0.user_id AS user_id_20, t0.project_id AS project_id_21, t0.casting_director_id AS casting_director_id_22, t0.agent_id AS agent_id_23 FROM auditions t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
||||||||||||||||||||||||||||
2 | 0.75 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.full_name AS full_name_4, t0.phone AS phone_5, t0.bio AS bio_6, t0.location AS location_7, t0.timezone AS timezone_8, t0.profile_picture_url AS profile_picture_url_9, t0.organization AS organization_10, t0.username AS username_11, t0.is_active AS is_active_12, t0.subscription_status AS subscription_status_13, t0.email_verified_at AS email_verified_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.roles AS roles_17, t18.id AS id_19, t18.slug AS slug_20, t18.display_name AS display_name_21, t18.bio AS bio_22, t18.headshot_url AS headshot_url_23, t18.cv_url AS cv_url_24, t18.showreel_url AS showreel_url_25, t18.voicereel_url AS voicereel_url_26, t18.theme AS theme_27, t18.is_public AS is_public_28, t18.contact_email AS contact_email_29, t18.location AS location_30, t18.specialties AS specialties_31, t18.links AS links_32, t18.view_count AS view_count_33, t18.created_at AS created_at_34, t18.updated_at AS updated_at_35, t18.user_id AS user_id_36, t37.id AS id_38, t37.email_auditions AS email_auditions_39, t37.email_reminders AS email_reminders_40, t37.email_updates AS email_updates_41, t37.push_auditions AS push_auditions_42, t37.push_reminders AS push_reminders_43, t37.push_updates AS push_updates_44, t37.reminder_timing AS reminder_timing_45, t37.digest_frequency AS digest_frequency_46, t37.vat_registered AS vat_registered_47, t37.currency AS currency_48, t37.fiscal_year_start AS fiscal_year_start_49, t37.show_take_home_default AS show_take_home_default_50, t37.statement_mode_label AS statement_mode_label_51, t37.created_at AS created_at_52, t37.updated_at AS updated_at_53, t37.onboarding_data AS onboarding_data_54, t37.user_id AS user_id_55, t56.id AS id_57, t56.stripe_subscription_id AS stripe_subscription_id_58, t56.stripe_customer_id AS stripe_customer_id_59, t56.plan AS plan_60, t56.status AS status_61, t56.next_billing_date AS next_billing_date_62, t56.amount AS amount_63, t56.currency AS currency_64, t56.trial_ends_at AS trial_ends_at_65, t56.canceled_at AS canceled_at_66, t56.created_at AS created_at_67, t56.updated_at AS updated_at_68, t56.user_id AS user_id_69 FROM users t0 LEFT JOIN actor_profiles t18 ON t18.user_id = t0.id LEFT JOIN user_settings t37 ON t37.user_id = t0.id LEFT JOIN subscriptions t56 ON t56.user_id = t0.id WHERE t0.id = ?
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||
3 | 2.08 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.priority AS priority_5, t0.category AS category_6, t0.due_date AS due_date_7, t0.due_time AS due_time_8, t0.recurring_rule AS recurring_rule_9, t0.reminder_minutes AS reminder_minutes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.reminder_sent_at AS reminder_sent_at_13, t0.user_id AS user_id_14, t0.linked_audition_id AS linked_audition_id_15, t0.linked_project_id AS linked_project_id_16, t0.linked_contact_id AS linked_contact_id_17 FROM tasks t0 WHERE t0.linked_audition_id = ?
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Audition | 1 |
App\Entity\User | 1 |
App\Entity\UserSettings | 1 |
App\Entity\Subscription | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Audition | No errors. |
App\Entity\User | No errors. |
App\Entity\Project | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Task | No errors. |
App\Entity\ActorProfile | No errors. |
App\Entity\UserSettings | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\ProfileData | No errors. |