GET https://audiack.com/api/auditions/1

Query Metrics

3 Database Queries
3 Different statements
3.39 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# 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.