object(Cake\ORM\Query\SelectQuery) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Items.id AS Items__id, Items.user_id AS Items__user_id, Items.brand_id AS Items__brand_id, Items.model_id AS Items__model_id, Items.district_id AS Items__district_id, Items.thana_id AS Items__thana_id, Items.is_new AS Items__is_new, Items.promo_image AS Items__promo_image, Items.alternate_phones AS Items__alternate_phones, Items.total_view AS Items__total_view, Items.status AS Items__status, Items.created AS Items__created, Items.published_at AS Items__published_at, Items.payment_status AS Items__payment_status, Items.is_featured AS Items__is_featured, Items.is_members_ad AS Items__is_members_ad, Images.id AS Images__id, Images.item_id AS Images__item_id, Images.path AS Images__path, Users.id AS Users__id, Users.district_id AS Users__district_id, Users.thana_id AS Users__thana_id, Users.phone AS Users__phone, Brands.id AS Brands__id, Brands.name AS Brands__name, Models.id AS Models__id, Models.brand_id AS Models__brand_id, Models.name AS Models__name, Models.name_en AS Models__name_en, Districts.id AS Districts__id, Districts.name AS Districts__name FROM items Items INNER JOIN images Images ON Items.id = Images.item_id INNER JOIN users Users ON Users.id = Items.user_id INNER JOIN brands Brands ON Brands.id = Items.brand_id INNER JOIN models Models ON Models.id = Items.model_id INNER JOIN districts Districts ON Districts.id = Items.district_id WHERE model_id = :c0 GROUP BY Items.id ORDER BY Items.published_at DESC, Items.created DESC LIMIT 4 OFFSET 0'
'params' => [
':c0' => [
'value' => '357',
'type' => 'integer',
'placeholder' => 'c0',
],
]
'role' => 'write'
'defaultTypes' => [
'Items__id' => 'integer',
'Items.id' => 'integer',
'id' => 'integer',
'Items__item_type_id' => 'integer',
'Items.item_type_id' => 'integer',
'item_type_id' => 'integer',
'Items__category_id' => 'integer',
'Items.category_id' => 'integer',
'category_id' => 'integer',
'Items__brand_id' => 'integer',
'Items.brand_id' => 'integer',
'brand_id' => 'integer',
'Items__model_id' => 'integer',
'Items.model_id' => 'integer',
'model_id' => 'integer',
'Items__user_id' => 'integer',
'Items.user_id' => 'integer',
'user_id' => 'integer',
'Items__price' => 'integer',
'Items.price' => 'integer',
'price' => 'integer',
'Items__phone' => 'string',
'Items.phone' => 'string',
'phone' => 'string',
'Items__alternate_phones' => 'text',
'Items.alternate_phones' => 'text',
'alternate_phones' => 'text',
'Items__district_id' => 'integer',
'Items.district_id' => 'integer',
'district_id' => 'integer',
'Items__thana_id' => 'integer',
'Items.thana_id' => 'integer',
'thana_id' => 'integer',
'Items__promo_image' => 'string',
'Items.promo_image' => 'string',
'promo_image' => 'string',
'Items__video_link' => 'string',
'Items.video_link' => 'string',
'video_link' => 'string',
'Items__year' => 'string',
'Items.year' => 'string',
'year' => 'string',
'Items__engine' => 'string',
'Items.engine' => 'string',
'engine' => 'string',
'Items__kilo_runned' => 'integer',
'Items.kilo_runned' => 'integer',
'kilo_runned' => 'integer',
'Items__descr' => 'text',
'Items.descr' => 'text',
'descr' => 'text',
'Items__is_new' => 'boolean',
'Items.is_new' => 'boolean',
'is_new' => 'boolean',
'Items__ad_source' => 'string',
'Items.ad_source' => 'string',
'ad_source' => 'string',
'Items__status' => 'tinyinteger',
'Items.status' => 'tinyinteger',
'status' => 'tinyinteger',
'Items__payment_status' => 'integer',
'Items.payment_status' => 'integer',
'payment_status' => 'integer',
'Items__admin_note' => 'text',
'Items.admin_note' => 'text',
'admin_note' => 'text',
'Items__is_featured' => 'tinyinteger',
'Items.is_featured' => 'tinyinteger',
'is_featured' => 'tinyinteger',
'Items__featured_from' => 'integer',
'Items.featured_from' => 'integer',
'featured_from' => 'integer',
'Items__featured_to' => 'integer',
'Items.featured_to' => 'integer',
'featured_to' => 'integer',
'Items__is_image_optimized' => 'tinyinteger',
'Items.is_image_optimized' => 'tinyinteger',
'is_image_optimized' => 'tinyinteger',
'Items__total_chat' => 'integer',
'Items.total_chat' => 'integer',
'total_chat' => 'integer',
'Items__total_call_max' => 'integer',
'Items.total_call_max' => 'integer',
'total_call_max' => 'integer',
'Items__total_call_min' => 'integer',
'Items.total_call_min' => 'integer',
'total_call_min' => 'integer',
'Items__total_view' => 'integer',
'Items.total_view' => 'integer',
'total_view' => 'integer',
'Items__published_at' => 'datetime',
'Items.published_at' => 'datetime',
'published_at' => 'datetime',
'Items__is_members_ad' => 'boolean',
'Items.is_members_ad' => 'boolean',
'is_members_ad' => 'boolean',
'Items__created' => 'datetime',
'Items.created' => 'datetime',
'created' => 'datetime',
'Items__modified' => 'datetime',
'Items.modified' => 'datetime',
'modified' => 'datetime',
'Users__id' => 'integer',
'Users.id' => 'integer',
'Users__role_id' => 'integer',
'Users.role_id' => 'integer',
'role_id' => 'integer',
'Users__name' => 'string',
'Users.name' => 'string',
'name' => 'string',
'Users__phone' => 'string',
'Users.phone' => 'string',
'Users__alternate_phone' => 'string',
'Users.alternate_phone' => 'string',
'alternate_phone' => 'string',
'Users__email' => 'string',
'Users.email' => 'string',
'email' => 'string',
'Users__password' => 'string',
'Users.password' => 'string',
'password' => 'string',
'Users__api_token' => 'string',
'Users.api_token' => 'string',
'api_token' => 'string',
'Users__district_id' => 'integer',
'Users.district_id' => 'integer',
'Users__thana_id' => 'integer',
'Users.thana_id' => 'integer',
'Users__address' => 'string',
'Users.address' => 'string',
'address' => 'string',
'Users__profile_picture' => 'string',
'Users.profile_picture' => 'string',
'profile_picture' => 'string',
'Users__shop_name' => 'string',
'Users.shop_name' => 'string',
'shop_name' => 'string',
'Users__shop_front_image' => 'string',
'Users.shop_front_image' => 'string',
'shop_front_image' => 'string',
'Users__visiting_card' => 'string',
'Users.visiting_card' => 'string',
'visiting_card' => 'string',
'Users__trade_license' => 'string',
'Users.trade_license' => 'string',
'trade_license' => 'string',
'Users__about' => 'text',
'Users.about' => 'text',
'about' => 'text',
'Users__whatsapp' => 'string',
'Users.whatsapp' => 'string',
'whatsapp' => 'string',
'Users__website' => 'string',
'Users.website' => 'string',
'website' => 'string',
'Users__logo' => 'string',
'Users.logo' => 'string',
'logo' => 'string',
'Users__total_item' => 'integer',
'Users.total_item' => 'integer',
'total_item' => 'integer',
'Users__total_running_ads' => 'integer',
'Users.total_running_ads' => 'integer',
'total_running_ads' => 'integer',
'Users__running_feature_ads' => 'integer',
'Users.running_feature_ads' => 'integer',
'running_feature_ads' => 'integer',
'Users__max_allowed_ads' => 'integer',
'Users.max_allowed_ads' => 'integer',
'max_allowed_ads' => 'integer',
'Users__max_allowed_feature_ads' => 'integer',
'Users.max_allowed_feature_ads' => 'integer',
'max_allowed_feature_ads' => 'integer',
'Users__membership_ends_at' => 'integer',
'Users.membership_ends_at' => 'integer',
'membership_ends_at' => 'integer',
'Users__total_paid' => 'integer',
'Users.total_paid' => 'integer',
'total_paid' => 'integer',
'Users__last_paid_at' => 'datetime',
'Users.last_paid_at' => 'datetime',
'last_paid_at' => 'datetime',
'Users__last_paid_amount' => 'integer',
'Users.last_paid_amount' => 'integer',
'last_paid_amount' => 'integer',
'Users__last_otp' => 'integer',
'Users.last_otp' => 'integer',
'last_otp' => 'integer',
'Users__otp_valid_till' => 'integer',
'Users.otp_valid_till' => 'integer',
'otp_valid_till' => 'integer',
'Users__status' => 'text',
'Users.status' => 'text',
'Users__membership_status' => 'integer',
'Users.membership_status' => 'integer',
'membership_status' => 'integer',
'Users__payment_due_reminded_at' => 'integer',
'Users.payment_due_reminded_at' => 'integer',
'payment_due_reminded_at' => 'integer',
'Users__admin_note' => 'text',
'Users.admin_note' => 'text',
'Users__created' => 'datetime',
'Users.created' => 'datetime',
'Users__modified' => 'datetime',
'Users.modified' => 'datetime',
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'Brands__item_type_id' => 'integer',
'Brands.item_type_id' => 'integer',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__name_en' => 'string',
'Brands.name_en' => 'string',
'name_en' => 'string',
'Brands__searching_terms' => 'text',
'Brands.searching_terms' => 'text',
'searching_terms' => 'text',
'Brands__logo' => 'string',
'Brands.logo' => 'string',
'Brands__status' => 'boolean',
'Brands.status' => 'boolean',
'Brands__created' => 'datetime',
'Brands.created' => 'datetime',
'Brands__modified' => 'datetime',
'Brands.modified' => 'datetime',
'Models__id' => 'integer',
'Models.id' => 'integer',
'Models__brand_id' => 'integer',
'Models.brand_id' => 'integer',
'Models__name' => 'string',
'Models.name' => 'string',
'Models__name_en' => 'string',
'Models.name_en' => 'string',
'Models__promo_image' => 'string',
'Models.promo_image' => 'string',
'Models__price' => 'integer',
'Models.price' => 'integer',
'Models__descr' => 'text',
'Models.descr' => 'text',
'Models__descr_en' => 'text',
'Models.descr_en' => 'text',
'descr_en' => 'text',
'Models__searching_terms' => 'text',
'Models.searching_terms' => 'text',
'Models__has_full_specification' => 'tinyinteger',
'Models.has_full_specification' => 'tinyinteger',
'has_full_specification' => 'tinyinteger',
'Models__has_photo_gallery' => 'tinyinteger',
'Models.has_photo_gallery' => 'tinyinteger',
'has_photo_gallery' => 'tinyinteger',
'Models__video_path' => 'string',
'Models.video_path' => 'string',
'video_path' => 'string',
'Models__has_details_descr' => 'tinyinteger',
'Models.has_details_descr' => 'tinyinteger',
'has_details_descr' => 'tinyinteger',
'Models__is_featured' => 'tinyinteger',
'Models.is_featured' => 'tinyinteger',
'Models__is_for_spare_parts' => 'boolean',
'Models.is_for_spare_parts' => 'boolean',
'is_for_spare_parts' => 'boolean',
'Models__status' => 'boolean',
'Models.status' => 'boolean',
'Models__total_view' => 'integer',
'Models.total_view' => 'integer',
'Models__created' => 'datetime',
'Models.created' => 'datetime',
'Models__modified' => 'datetime',
'Models.modified' => 'datetime',
'FeatureValues__id' => 'integer',
'FeatureValues.id' => 'integer',
'FeatureValues__item_id' => 'integer',
'FeatureValues.item_id' => 'integer',
'item_id' => 'integer',
'FeatureValues__feature_id' => 'integer',
'FeatureValues.feature_id' => 'integer',
'feature_id' => 'integer',
'FeatureValues__value' => 'text',
'FeatureValues.value' => 'text',
'value' => 'text',
'FeatureValues__created' => 'datetime',
'FeatureValues.created' => 'datetime',
'FeatureValues__modified' => 'datetime',
'FeatureValues.modified' => 'datetime',
'Districts__id' => 'integer',
'Districts.id' => 'integer',
'Districts__name' => 'string',
'Districts.name' => 'string',
'Districts__name_en' => 'string',
'Districts.name_en' => 'string',
'Districts__searching_terms' => 'text',
'Districts.searching_terms' => 'text',
'Districts__sort_order' => 'integer',
'Districts.sort_order' => 'integer',
'sort_order' => 'integer',
'Districts__total_user' => 'integer',
'Districts.total_user' => 'integer',
'total_user' => 'integer',
'Districts__total_customer' => 'integer',
'Districts.total_customer' => 'integer',
'total_customer' => 'integer',
'Districts__total_order' => 'integer',
'Districts.total_order' => 'integer',
'total_order' => 'integer',
'Districts__total_ad' => 'integer',
'Districts.total_ad' => 'integer',
'total_ad' => 'integer',
'Districts__status' => 'boolean',
'Districts.status' => 'boolean',
'Districts__created' => 'datetime',
'Districts.created' => 'datetime',
'Districts__modified' => 'datetime',
'Districts.modified' => 'datetime',
'Images__id' => 'integer',
'Images.id' => 'integer',
'Images__item_id' => 'integer',
'Images.item_id' => 'integer',
'Images__path' => 'string',
'Images.path' => 'string',
'path' => 'string',
'Images__created' => 'datetime',
'Images.created' => 'datetime',
'Images__modified' => 'datetime',
'Images.modified' => 'datetime',
]
'executed' => false
'decorators' => (int) 0
'hydrate' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'Users' => [
'queryBuilder' => object(Closure) id:1 {
},
],
'Brands' => [
'queryBuilder' => object(Closure) id:2 {
},
],
'Models' => [
'queryBuilder' => object(Closure) id:3 {
},
],
'FeatureValues' => [
'queryBuilder' => object(Closure) id:4 {
},
],
'Districts' => [
'queryBuilder' => object(Closure) id:5 {
},
],
]
'matching' => [
'Images' => [
'matching' => true,
'queryBuilder' => object(Closure) id:6 {
},
'joinType' => 'INNER',
],
]
'extraOptions' => [
]
'repository' => object(App\Model\Table\ItemsTable) id:7 {
'registryAlias' => 'Items'
'table' => 'items'
'alias' => 'Items'
'entityClass' => 'App\Model\Entity\Item'
'associations' => [
(int) 0 => 'ItemTypes',
(int) 1 => 'Brands',
(int) 2 => 'Models',
(int) 3 => 'Users',
(int) 4 => 'Districts',
(int) 5 => 'Thanas',
(int) 6 => 'FeatureValues',
(int) 7 => 'Images',
(int) 8 => 'Favorites',
(int) 9 => 'Chats',
]
'behaviors' => [
(int) 0 => 'Timestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}