object(Cake\ORM\Query) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Incident.id AS Incident__id, Incident.location_id AS Incident__location_id, Incident.form_id AS Incident__form_id, Incident.locale AS Incident__locale, Incident.user_id AS Incident__user_id, Incident.incident_title AS Incident__incident_title, Incident.incident_description AS Incident__incident_description, Incident.incident_date AS Incident__incident_date, Incident.incident_mode AS Incident__incident_mode, Incident.incident_active AS Incident__incident_active, Incident.incident_verified AS Incident__incident_verified, Incident.incident_dateadd AS Incident__incident_dateadd, Incident.incident_dateadd_gmt AS Incident__incident_dateadd_gmt, Incident.incident_datemodify AS Incident__incident_datemodify, Incident.incident_alert_status AS Incident__incident_alert_status, Incident.incident_zoom AS Incident__incident_zoom, Location.id AS Location__id, Location.location_name AS Location__location_name, Location.country_id AS Location__country_id, Location.latitude AS Location__latitude, Location.longitude AS Location__longitude, Location.location_visible AS Location__location_visible, Location.location_date AS Location__location_date, LocationPais.id AS LocationPais__id, LocationPais.codigo AS LocationPais__codigo, LocationPais.termino AS LocationPais__termino, LocationPais.lista AS LocationPais__lista, LocationPais.term2 AS LocationPais__term2 FROM incident Incident INNER JOIN location Location ON Location.id = Incident.location_id INNER JOIN vocabulario LocationPais ON (lista = :c0 AND LocationPais.codigo = :c1 AND LocationPais.id = Location.country_id) WHERE incident_active >= :c2 ORDER BY location_pais asc LIMIT 20 OFFSET 0'
'params' => [
':c0' => [
'value' => '15',
'type' => 'string',
'placeholder' => 'c0',
],
':c1' => [
'value' => '02032300',
'type' => 'string',
'placeholder' => 'c1',
],
':c2' => [
'value' => (int) 1,
'type' => 'tinyinteger',
'placeholder' => 'c2',
],
]
'defaultTypes' => [
'Incident__id' => 'biginteger',
'Incident.id' => 'biginteger',
'id' => 'biginteger',
'Incident__location_id' => 'biginteger',
'Incident.location_id' => 'biginteger',
'location_id' => 'biginteger',
'Incident__form_id' => 'integer',
'Incident.form_id' => 'integer',
'form_id' => 'integer',
'Incident__locale' => 'string',
'Incident.locale' => 'string',
'locale' => 'string',
'Incident__user_id' => 'integer',
'Incident.user_id' => 'integer',
'user_id' => 'integer',
'Incident__incident_title' => 'string',
'Incident.incident_title' => 'string',
'incident_title' => 'string',
'Incident__incident_description' => 'text',
'Incident.incident_description' => 'text',
'incident_description' => 'text',
'Incident__incident_date' => 'datetime',
'Incident.incident_date' => 'datetime',
'incident_date' => 'datetime',
'Incident__incident_mode' => 'tinyinteger',
'Incident.incident_mode' => 'tinyinteger',
'incident_mode' => 'tinyinteger',
'Incident__incident_active' => 'tinyinteger',
'Incident.incident_active' => 'tinyinteger',
'incident_active' => 'tinyinteger',
'Incident__incident_verified' => 'tinyinteger',
'Incident.incident_verified' => 'tinyinteger',
'incident_verified' => 'tinyinteger',
'Incident__incident_dateadd' => 'datetime',
'Incident.incident_dateadd' => 'datetime',
'incident_dateadd' => 'datetime',
'Incident__incident_dateadd_gmt' => 'datetime',
'Incident.incident_dateadd_gmt' => 'datetime',
'incident_dateadd_gmt' => 'datetime',
'Incident__incident_datemodify' => 'datetime',
'Incident.incident_datemodify' => 'datetime',
'incident_datemodify' => 'datetime',
'Incident__incident_alert_status' => 'tinyinteger',
'Incident.incident_alert_status' => 'tinyinteger',
'incident_alert_status' => 'tinyinteger',
'Incident__incident_zoom' => 'tinyinteger',
'Incident.incident_zoom' => 'tinyinteger',
'incident_zoom' => 'tinyinteger',
'Location__id' => 'biginteger',
'Location.id' => 'biginteger',
'Location__location_name' => 'string',
'Location.location_name' => 'string',
'location_name' => 'string',
'Location__country_id' => 'integer',
'Location.country_id' => 'integer',
'country_id' => 'integer',
'Location__latitude' => 'float',
'Location.latitude' => 'float',
'latitude' => 'float',
'Location__longitude' => 'float',
'Location.longitude' => 'float',
'longitude' => 'float',
'Location__location_visible' => 'tinyinteger',
'Location.location_visible' => 'tinyinteger',
'location_visible' => 'tinyinteger',
'Location__location_date' => 'datetime',
'Location.location_date' => 'datetime',
'location_date' => 'datetime',
'LocationPais__id' => 'integer',
'LocationPais.id' => 'integer',
'LocationPais__codigo' => 'string',
'LocationPais.codigo' => 'string',
'codigo' => 'string',
'LocationPais__termino' => 'string',
'LocationPais.termino' => 'string',
'termino' => 'string',
'LocationPais__lista' => 'string',
'LocationPais.lista' => 'string',
'lista' => 'string',
'LocationPais__term2' => 'string',
'LocationPais.term2' => 'string',
'term2' => 'string',
'Category__id' => 'integer',
'Category.id' => 'integer',
'Category__parent_id' => 'integer',
'Category.parent_id' => 'integer',
'parent_id' => 'integer',
'Category__locale' => 'string',
'Category.locale' => 'string',
'Category__category_position' => 'tinyinteger',
'Category.category_position' => 'tinyinteger',
'category_position' => 'tinyinteger',
'Category__category_title' => 'string',
'Category.category_title' => 'string',
'category_title' => 'string',
'Category__category_description' => 'text',
'Category.category_description' => 'text',
'category_description' => 'text',
'Category__category_color' => 'string',
'Category.category_color' => 'string',
'category_color' => 'string',
'Category__category_image' => 'string',
'Category.category_image' => 'string',
'category_image' => 'string',
'Category__category_image_thumb' => 'string',
'Category.category_image_thumb' => 'string',
'category_image_thumb' => 'string',
'Category__category_visible' => 'tinyinteger',
'Category.category_visible' => 'tinyinteger',
'category_visible' => 'tinyinteger',
'Category__category_enabled' => 'tinyinteger',
'Category.category_enabled' => 'tinyinteger',
'category_enabled' => 'tinyinteger',
'MediaImage__id' => 'biginteger',
'MediaImage.id' => 'biginteger',
'MediaImage__location_id' => 'biginteger',
'MediaImage.location_id' => 'biginteger',
'MediaImage__incident_id' => 'biginteger',
'MediaImage.incident_id' => 'biginteger',
'incident_id' => 'biginteger',
'MediaImage__media_type' => 'tinyinteger',
'MediaImage.media_type' => 'tinyinteger',
'media_type' => 'tinyinteger',
'MediaImage__media_title' => 'string',
'MediaImage.media_title' => 'string',
'media_title' => 'string',
'MediaImage__media_description' => 'text',
'MediaImage.media_description' => 'text',
'media_description' => 'text',
'MediaImage__media_link' => 'string',
'MediaImage.media_link' => 'string',
'media_link' => 'string',
'MediaImage__media_medium' => 'string',
'MediaImage.media_medium' => 'string',
'media_medium' => 'string',
'MediaImage__media_thumb' => 'string',
'MediaImage.media_thumb' => 'string',
'media_thumb' => 'string',
'MediaImage__media_date' => 'datetime',
'MediaImage.media_date' => 'datetime',
'media_date' => 'datetime',
'MediaImage__media_active' => 'tinyinteger',
'MediaImage.media_active' => 'tinyinteger',
'media_active' => 'tinyinteger',
'MediaImage__verified' => 'datetime',
'MediaImage.verified' => 'datetime',
'verified' => 'datetime',
'MediaImage__errors' => 'tinyinteger',
'MediaImage.errors' => 'tinyinteger',
'errors' => 'tinyinteger',
'MediaImage__archive_link' => 'string',
'MediaImage.archive_link' => 'string',
'archive_link' => 'string',
]
'decorators' => (int) 0
'executed' => false
'hydrate' => true
'buffered' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'Category' => [
],
'Location' => [
'LocationPais' => [
'fields' => [
'' => [maximum depth reached],
],
],
],
'MediaImage' => [
'sort' => [
'media_type' => 'ASC',
'MediaImage.id' => 'ASC',
],
],
]
'matching' => [
'Location' => [
'negateMatch' => false,
'matching' => true,
'joinType' => 'INNER',
'LocationPais' => [
'matching' => true,
'queryBuilder' => object(Closure) id:1 {
},
'joinType' => 'INNER',
],
],
]
'extraOptions' => [
]
'repository' => object(App\Model\Table\IncidentTable) id:2 {
'registryAlias' => 'Incident'
'table' => 'incident'
'alias' => 'Incident'
'entityClass' => 'App\Model\Entity\Incident'
'associations' => [
(int) 0 => 'Users',
(int) 1 => 'Location',
(int) 2 => 'IncidentPerson',
(int) 3 => 'Media',
(int) 4 => 'Category',
(int) 5 => 'Conflicto',
(int) 6 => 'MediaImage',
(int) 7 => 'MediaVideo',
(int) 8 => 'MediaAudio',
(int) 9 => 'MediaNews',
]
'behaviors' => [
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}