object(Cake\ORM\Query\SelectQuery) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Users.id AS Users__id, Users.email AS Users__email, Users.first_name AS Users__first_name, Users.last_name AS Users__last_name, Users.password AS Users__password, Users.nonce AS Users__nonce, Users.nonce_expiry AS Users__nonce_expiry, Users.created AS Users__created, Users.modified AS Users__modified, Users.user_type AS Users__user_type, Users.status AS Users__status, Users.is_subscribed AS Users__is_subscribed, Users.mfa_secret AS Users__mfa_secret, ArtistProfiles.id AS ArtistProfiles__id, ArtistProfiles.user_id AS ArtistProfiles__user_id, ArtistProfiles.band_name AS ArtistProfiles__band_name, ArtistProfiles.description AS ArtistProfiles__description, ArtistProfiles.social_media_links AS ArtistProfiles__social_media_links, ArtistProfiles.website AS ArtistProfiles__website, ArtistProfiles.created AS ArtistProfiles__created, ArtistProfiles.modified AS ArtistProfiles__modified, ArtistProfiles.instagram AS ArtistProfiles__instagram, ArtistProfiles.genre AS ArtistProfiles__genre, ArtistProfiles.act_type AS ArtistProfiles__act_type, ArtistProfiles.biography AS ArtistProfiles__biography, ReviewForms.id AS ReviewForms__id, ReviewForms.user_id AS ReviewForms__user_id, ReviewForms.phone_number AS ReviewForms__phone_number, ReviewForms.website_url AS ReviewForms__website_url, ReviewForms.replied_status AS ReviewForms__replied_status, ReviewForms.epk_file_path AS ReviewForms__epk_file_path, ReviewForms.automated_message AS ReviewForms__automated_message, ReviewForms.created_at AS ReviewForms__created_at, ReviewForms.updated_at AS ReviewForms__updated_at, ReviewForms.enrollment_payment_id AS ReviewForms__enrollment_payment_id, ReviewForms.form2_token AS ReviewForms__form2_token, ReviewForms.collaboration_status AS ReviewForms__collaboration_status, DetailForms.id AS DetailForms__id, DetailForms.review_form_id AS DetailForms__review_form_id, DetailForms.band_name AS DetailForms__band_name, DetailForms.genre AS DetailForms__genre, DetailForms.biography AS DetailForms__biography, DetailForms.act_type AS DetailForms__act_type, DetailForms.business_structure AS DetailForms__business_structure, DetailForms.address AS DetailForms__address, DetailForms.songs_catalogue AS DetailForms__songs_catalogue, DetailForms.duration_of_sets AS DetailForms__duration_of_sets, DetailForms.gigs_on_long_weekends AS DetailForms__gigs_on_long_weekends, DetailForms.frequency_of_rehearsals AS DetailForms__frequency_of_rehearsals, DetailForms.location_of_rehearsals AS DetailForms__location_of_rehearsals, DetailForms.minimum_performance_fee AS DetailForms__minimum_performance_fee, DetailForms.equipment AS DetailForms__equipment, DetailForms.short_term_goals AS DetailForms__short_term_goals, DetailForms.venues AS DetailForms__venues, DetailForms.busking AS DetailForms__busking, DetailForms.radio AS DetailForms__radio, DetailForms.tv AS DetailForms__tv, DetailForms.specific_needs AS DetailForms__specific_needs, DetailForms.created AS DetailForms__created, DetailForms.modified AS DetailForms__modified FROM users Users LEFT JOIN artist_profiles ArtistProfiles ON Users.id = ArtistProfiles.user_id LEFT JOIN review_forms ReviewForms ON Users.id = ReviewForms.user_id LEFT JOIN detail_forms DetailForms ON ReviewForms.id = DetailForms.review_form_id WHERE Users.id = :c0 LIMIT 1'
'params' => [
':c0' => [
'value' => 'phpstorm:',
'type' => 'integer',
'placeholder' => 'c0',
],
]
'role' => 'write'
'defaultTypes' => [
'Users__id' => 'integer',
'Users.id' => 'integer',
'id' => 'integer',
'Users__email' => 'string',
'Users.email' => 'string',
'email' => 'string',
'Users__first_name' => 'string',
'Users.first_name' => 'string',
'first_name' => 'string',
'Users__last_name' => 'string',
'Users.last_name' => 'string',
'last_name' => 'string',
'Users__password' => 'string',
'Users.password' => 'string',
'password' => 'string',
'Users__nonce' => 'string',
'Users.nonce' => 'string',
'nonce' => 'string',
'Users__nonce_expiry' => 'datetime',
'Users.nonce_expiry' => 'datetime',
'nonce_expiry' => 'datetime',
'Users__created' => 'datetime',
'Users.created' => 'datetime',
'created' => 'datetime',
'Users__modified' => 'datetime',
'Users.modified' => 'datetime',
'modified' => 'datetime',
'Users__user_type' => 'string',
'Users.user_type' => 'string',
'user_type' => 'string',
'Users__status' => 'string',
'Users.status' => 'string',
'status' => 'string',
'Users__is_subscribed' => 'boolean',
'Users.is_subscribed' => 'boolean',
'is_subscribed' => 'boolean',
'Users__mfa_secret' => 'string',
'Users.mfa_secret' => 'string',
'mfa_secret' => 'string',
'ArtistImages__id' => 'integer',
'ArtistImages.id' => 'integer',
'ArtistImages__user_id' => 'integer',
'ArtistImages.user_id' => 'integer',
'user_id' => 'integer',
'ArtistImages__image_path' => 'string',
'ArtistImages.image_path' => 'string',
'image_path' => 'string',
'ArtistImages__is_profile' => 'boolean',
'ArtistImages.is_profile' => 'boolean',
'is_profile' => 'boolean',
'ArtistImages__created' => 'datetime',
'ArtistImages.created' => 'datetime',
'ArtistImages__modified' => 'datetime',
'ArtistImages.modified' => 'datetime',
'ArtistProfiles__id' => 'integer',
'ArtistProfiles.id' => 'integer',
'ArtistProfiles__user_id' => 'integer',
'ArtistProfiles.user_id' => 'integer',
'ArtistProfiles__band_name' => 'string',
'ArtistProfiles.band_name' => 'string',
'band_name' => 'string',
'ArtistProfiles__description' => 'text',
'ArtistProfiles.description' => 'text',
'description' => 'text',
'ArtistProfiles__social_media_links' => 'text',
'ArtistProfiles.social_media_links' => 'text',
'social_media_links' => 'text',
'ArtistProfiles__website' => 'string',
'ArtistProfiles.website' => 'string',
'website' => 'string',
'ArtistProfiles__created' => 'datetime',
'ArtistProfiles.created' => 'datetime',
'ArtistProfiles__modified' => 'datetime',
'ArtistProfiles.modified' => 'datetime',
'ArtistProfiles__instagram' => 'string',
'ArtistProfiles.instagram' => 'string',
'instagram' => 'string',
'ArtistProfiles__genre' => 'string',
'ArtistProfiles.genre' => 'string',
'genre' => 'string',
'ArtistProfiles__act_type' => 'string',
'ArtistProfiles.act_type' => 'string',
'act_type' => 'string',
'ArtistProfiles__biography' => 'text',
'ArtistProfiles.biography' => 'text',
'biography' => 'text',
'ReviewForms__id' => 'integer',
'ReviewForms.id' => 'integer',
'ReviewForms__user_id' => 'integer',
'ReviewForms.user_id' => 'integer',
'ReviewForms__phone_number' => 'string',
'ReviewForms.phone_number' => 'string',
'phone_number' => 'string',
'ReviewForms__website_url' => 'string',
'ReviewForms.website_url' => 'string',
'website_url' => 'string',
'ReviewForms__replied_status' => 'string',
'ReviewForms.replied_status' => 'string',
'replied_status' => 'string',
'ReviewForms__epk_file_path' => 'string',
'ReviewForms.epk_file_path' => 'string',
'epk_file_path' => 'string',
'ReviewForms__automated_message' => 'text',
'ReviewForms.automated_message' => 'text',
'automated_message' => 'text',
'ReviewForms__created_at' => 'datetime',
'ReviewForms.created_at' => 'datetime',
'created_at' => 'datetime',
'ReviewForms__updated_at' => 'datetime',
'ReviewForms.updated_at' => 'datetime',
'updated_at' => 'datetime',
'ReviewForms__enrollment_payment_id' => 'integer',
'ReviewForms.enrollment_payment_id' => 'integer',
'enrollment_payment_id' => 'integer',
'ReviewForms__form2_token' => 'string',
'ReviewForms.form2_token' => 'string',
'form2_token' => 'string',
'ReviewForms__collaboration_status' => 'string',
'ReviewForms.collaboration_status' => 'string',
'collaboration_status' => 'string',
'DetailForms__id' => 'integer',
'DetailForms.id' => 'integer',
'DetailForms__review_form_id' => 'integer',
'DetailForms.review_form_id' => 'integer',
'review_form_id' => 'integer',
'DetailForms__band_name' => 'string',
'DetailForms.band_name' => 'string',
'DetailForms__genre' => 'string',
'DetailForms.genre' => 'string',
'DetailForms__biography' => 'string',
'DetailForms.biography' => 'string',
'DetailForms__act_type' => 'string',
'DetailForms.act_type' => 'string',
'DetailForms__business_structure' => 'string',
'DetailForms.business_structure' => 'string',
'business_structure' => 'string',
'DetailForms__address' => 'text',
'DetailForms.address' => 'text',
'address' => 'text',
'DetailForms__songs_catalogue' => 'text',
'DetailForms.songs_catalogue' => 'text',
'songs_catalogue' => 'text',
'DetailForms__duration_of_sets' => 'string',
'DetailForms.duration_of_sets' => 'string',
'duration_of_sets' => 'string',
'DetailForms__gigs_on_long_weekends' => 'boolean',
'DetailForms.gigs_on_long_weekends' => 'boolean',
'gigs_on_long_weekends' => 'boolean',
'DetailForms__frequency_of_rehearsals' => 'string',
'DetailForms.frequency_of_rehearsals' => 'string',
'frequency_of_rehearsals' => 'string',
'DetailForms__location_of_rehearsals' => 'text',
'DetailForms.location_of_rehearsals' => 'text',
'location_of_rehearsals' => 'text',
'DetailForms__minimum_performance_fee' => 'decimal',
'DetailForms.minimum_performance_fee' => 'decimal',
'minimum_performance_fee' => 'decimal',
'DetailForms__equipment' => 'text',
'DetailForms.equipment' => 'text',
'equipment' => 'text',
'DetailForms__short_term_goals' => 'text',
'DetailForms.short_term_goals' => 'text',
'short_term_goals' => 'text',
'DetailForms__venues' => 'text',
'DetailForms.venues' => 'text',
'venues' => 'text',
'DetailForms__busking' => 'boolean',
'DetailForms.busking' => 'boolean',
'busking' => 'boolean',
'DetailForms__radio' => 'boolean',
'DetailForms.radio' => 'boolean',
'radio' => 'boolean',
'DetailForms__tv' => 'boolean',
'DetailForms.tv' => 'boolean',
'tv' => 'boolean',
'DetailForms__specific_needs' => 'text',
'DetailForms.specific_needs' => 'text',
'specific_needs' => 'text',
'DetailForms__created' => 'datetime',
'DetailForms.created' => 'datetime',
'DetailForms__modified' => 'datetime',
'DetailForms.modified' => 'datetime',
]
'executed' => false
'decorators' => (int) 0
'hydrate' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'ArtistImages' => [
],
'ArtistProfiles' => [
],
'ReviewForms' => [
'DetailForms' => [
],
],
]
'matching' => [
]
'extraOptions' => [
]
'repository' => object(App\Model\Table\UsersTable) id:1 {
'registryAlias' => 'Users'
'table' => 'users'
'alias' => 'Users'
'entityClass' => 'App\Model\Entity\User'
'associations' => [
(int) 0 => 'ManagementForms',
(int) 1 => 'BandInvoices',
(int) 2 => 'ReviewForms',
(int) 3 => 'ArtistProfiles',
(int) 4 => 'ArtistImages',
]
'behaviors' => [
(int) 0 => 'Timestamp',
(int) 1 => 'CanAuthenticate',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}