| mymodel | Anuncio_venderapido_model Object
(
[table] => anuncios_venderapido
[primary_key] => id
[_database_connection:protected] =>
[_database:protected] => CI_DB_mysqli_driver Object
(
[dbdriver] => mysqli
[compress] =>
[delete_hack] => 1
[stricton] =>
[_escape_char:protected] => `
[_mysqli:protected] => mysqli Object
(
[affected_rows] => 19
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 10
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.31-MariaDB
[server_version] => 100331
[stat] => Uptime: 830027 Threads: 36 Questions: 67783216 Slow queries: 5 Opens: 1907 Flush tables: 1 Open tables: 1400 Queries per second avg: 81.663
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 739535
[warning_count] => 0
)
[return_delete_sql:protected] =>
[reset_delete_data:protected] =>
[qb_select:protected] => Array
(
)
[qb_distinct:protected] =>
[qb_from:protected] => Array
(
)
[qb_join:protected] => Array
(
)
[qb_where:protected] => Array
(
)
[qb_groupby:protected] => Array
(
)
[qb_having:protected] => Array
(
)
[qb_keys:protected] => Array
(
)
[qb_limit:protected] =>
[qb_offset:protected] =>
[qb_orderby:protected] => Array
(
)
[qb_set:protected] => Array
(
)
[qb_set_ub:protected] => Array
(
)
[qb_aliased_tables:protected] => Array
(
)
[qb_where_group_started:protected] =>
[qb_where_group_count:protected] => 0
[qb_caching:protected] =>
[qb_cache_exists:protected] => Array
(
)
[qb_cache_select:protected] => Array
(
)
[qb_cache_from:protected] => Array
(
)
[qb_cache_join:protected] => Array
(
)
[qb_cache_aliased_tables:protected] => Array
(
)
[qb_cache_where:protected] => Array
(
)
[qb_cache_groupby:protected] => Array
(
)
[qb_cache_having:protected] => Array
(
)
[qb_cache_orderby:protected] => Array
(
)
[qb_cache_set:protected] => Array
(
)
[qb_no_escape:protected] => Array
(
)
[qb_cache_no_escape:protected] => Array
(
)
[dsn] =>
[username] => agronomis_user
[password] => 4HgccTJowuY9dxbl
[hostname] => localhost
[database] => agronomis_ci
[subdriver] =>
[dbprefix] =>
[char_set] => utf8
[dbcollat] => utf8_general_ci
[encrypt] =>
[swap_pre] =>
[port] =>
[pconnect] =>
[conn_id] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 10
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.31-MariaDB
[server_version] => 100331
[stat] => Uptime: 830027 Threads: 36 Questions: 67783216 Slow queries: 5 Opens: 1907 Flush tables: 1 Open tables: 1400 Queries per second avg: 81.663
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 739535
[warning_count] => 0
)
[result_id] => mysqli_result Object
(
[current_field] => 0
[field_count] => 10
[lengths] =>
[num_rows] => 19
[type] => 0
)
[db_debug] =>
[benchmark] => 0.04571270942688
[query_count] => 71
[bind_marker] => ?
[save_queries] => 1
[queries] => Array
(
[0] => SELECT GET_LOCK('e49db8731c6440ff5080bd0b6af0b945', 300) AS ci_session_lock
[1] => SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'c515195aa6df0df5c1ac3ad4bc4d436b695cc91d'
[2] => SHOW TABLES FROM `agronomis_ci`
[3] => SHOW COLUMNS FROM `anuncios`
[4] => SHOW COLUMNS FROM `certificaciones`
[5] => SELECT *, `anuncios`.`id_categoria`, `anuncios`.`id`, `anuncios`.`id`, `anuncios`.`id_marca`
FROM `anuncios`
WHERE `anuncios`.`activo` != 0
AND `anuncios`.`id` = '2410'
LIMIT 1
[6] => SHOW COLUMNS FROM `categorias`
[7] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('341')
[8] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('40')
[9] => SHOW COLUMNS FROM `maquina_anuncio`
[10] => SELECT *
FROM `maquina_anuncio`
WHERE `maquina_anuncio`.`id_anuncio` IN('2410')
[11] => SHOW COLUMNS FROM `anuncios_imagenes`
[12] => SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('2410')
[13] => SHOW COLUMNS FROM `marcas`
[14] => SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('1027')
[15] => SHOW COLUMNS FROM `maquinas_videos`
[16] => SELECT *
FROM `maquinas_videos`
WHERE `maquinas_videos`.`id_maquina` = '312'
[17] => SHOW COLUMNS FROM `usuarios`
[18] => SHOW COLUMNS FROM `suscripciones_planes`
[19] => SHOW COLUMNS FROM `roles`
[20] => SELECT *, `usuarios`.`id`
FROM `usuarios`
WHERE `usuarios`.`id` = '16'
AND usuarios.deleted_at IS NULL
LIMIT 1
[21] => SELECT `roles`.`id`, `usuarios_roles`.`id_usuario`
FROM `roles`
LEFT JOIN `usuarios_roles` ON `roles`.`id` = `usuarios_roles`.`id_rol`
LEFT JOIN `usuarios` ON `usuarios_roles`.`id_usuario` = `usuarios`.`id`
WHERE `usuarios_roles`.`id_usuario` IN('16')
[22] => SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
[23] => SHOW COLUMNS FROM `empresas`
[24] => SELECT *, `empresas`.`id`, `empresas`.`id`
FROM `empresas`
WHERE `empresas`.`id` = '23'
LIMIT 1
[25] => SHOW COLUMNS FROM `empresas_contactos`
[26] => SELECT *
FROM `empresas_contactos`
WHERE `empresas_contactos`.`id_empresa` IN('23')
[27] => SHOW COLUMNS FROM `empresas_sedes`
[28] => SELECT *
FROM `empresas_sedes`
WHERE `empresas_sedes`.`id_empresa` IN('23')
[29] => SELECT `id_categoria`, `id_categoria`
FROM `categorias`
WHERE `categorias`.`padre` = '40'
[30] => SELECT COUNT(*) AS `numrows`
FROM `anuncios`
LEFT JOIN `maquina_anuncio` as `canal` ON `canal`.`id_anuncio`=`anuncios`.`id`
WHERE `anuncios`.`id_categoria` IN('338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366')
AND `anuncios`.`activo` = 1
AND `anuncios`.`deleted_at` IS NULL
AND (`canal`.`agronomis` !=0 or `canal`.`agronomis` is null)
[31] => SELECT `id_categoria`, `id_categoria`
FROM `categorias`
WHERE `categorias`.`padre` = '40'
[32] => SELECT `anuncios`.`id` as `id`
FROM `anuncios`
LEFT JOIN `maquina_anuncio` as `canal` ON `canal`.`id_anuncio`=`anuncios`.`id`
WHERE `anuncios`.`id_categoria` IN('338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366')
AND `anuncios`.`activo` = 1
AND `anuncios`.`deleted_at` IS NULL
AND (`canal`.`agronomis` !=0 or `canal`.`agronomis` is null)
ORDER BY RAND()
LIMIT 4
[33] => SHOW COLUMNS FROM `anuncios_venderapido`
[34] => SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '2948'
LIMIT 1
[35] => SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('1076')
[36] => SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('2948')
[37] => SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('746')
AND usuarios.deleted_at IS NULL
[38] => SELECT `roles`.`id`, `usuarios_roles`.`id_usuario`
FROM `roles`
LEFT JOIN `usuarios_roles` ON `roles`.`id` = `usuarios_roles`.`id_rol`
LEFT JOIN `usuarios` ON `usuarios_roles`.`id_usuario` = `usuarios`.`id`
WHERE `usuarios_roles`.`id_usuario` IN('746')
[39] => SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
[40] => SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('480')
[41] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('353')
[42] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('40')
[43] => SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '2203'
LIMIT 1
[44] => SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('519')
[45] => SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('2203')
[46] => SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('20')
AND usuarios.deleted_at IS NULL
[47] => SELECT `roles`.`id`, `usuarios_roles`.`id_usuario`
FROM `roles`
LEFT JOIN `usuarios_roles` ON `roles`.`id` = `usuarios_roles`.`id_rol`
LEFT JOIN `usuarios` ON `usuarios_roles`.`id_usuario` = `usuarios`.`id`
WHERE `usuarios_roles`.`id_usuario` IN('20')
[48] => SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
[49] => SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('27')
[50] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('353')
[51] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('40')
[52] => SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '3949'
LIMIT 1
[53] => SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('325')
[54] => SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('3949')
[55] => SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('404')
AND usuarios.deleted_at IS NULL
[56] => SELECT `roles`.`id`, `usuarios_roles`.`id_usuario`
FROM `roles`
LEFT JOIN `usuarios_roles` ON `roles`.`id` = `usuarios_roles`.`id_rol`
LEFT JOIN `usuarios` ON `usuarios_roles`.`id_usuario` = `usuarios`.`id`
WHERE `usuarios_roles`.`id_usuario` IN('404')
[57] => SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
[58] => SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('449')
[59] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('355')
[60] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('40')
[61] => SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '2258'
LIMIT 1
[62] => SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('519')
[63] => SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('2258')
[64] => SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('20')
AND usuarios.deleted_at IS NULL
[65] => SELECT `roles`.`id`, `usuarios_roles`.`id_usuario`
FROM `roles`
LEFT JOIN `usuarios_roles` ON `roles`.`id` = `usuarios_roles`.`id_rol`
LEFT JOIN `usuarios` ON `usuarios_roles`.`id_usuario` = `usuarios`.`id`
WHERE `usuarios_roles`.`id_usuario` IN('20')
[66] => SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
[67] => SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('27')
[68] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('366')
[69] => SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('40')
[70] => SELECT *
FROM `categorias`
WHERE `categorias`.`padre` = 0
)
[query_times] => Array
(
[0] => 0.00011801719665527
[1] => 0.00073003768920898
[2] => 0.0001990795135498
[3] => 0.00070285797119141
[4] => 0.00036978721618652
[5] => 0.00023388862609863
[6] => 0.00035500526428223
[7] => 0.00011897087097168
[8] => 9.7990036010742E-5
[9] => 0.00036311149597168
[10] => 0.00018191337585449
[11] => 0.00037217140197754
[12] => 0.00012516975402832
[13] => 0.00038695335388184
[14] => 0.00019502639770508
[15] => 0.00042200088500977
[16] => 0.00011587142944336
[17] => 0.00044107437133789
[18] => 0.0003659725189209
[19] => 0.0003960132598877
[20] => 0.00016903877258301
[21] => 0.00037193298339844
[22] => 9.3936920166016E-5
[23] => 0.00039291381835938
[24] => 0.00021100044250488
[25] => 0.00034904479980469
[26] => 0.00012707710266113
[27] => 0.00045108795166016
[28] => 0.00024986267089844
[29] => 0.00020408630371094
[30] => 0.014909029006958
[31] => 0.00021100044250488
[32] => 0.015666007995605
[33] => 0.00054407119750977
[34] => 0.0002739429473877
[35] => 9.608268737793E-5
[36] => 0.00011897087097168
[37] => 0.00017189979553223
[38] => 0.00035405158996582
[39] => 8.8930130004883E-5
[40] => 0.00010180473327637
[41] => 9.3936920166016E-5
[42] => 0.00012707710266113
[43] => 0.00012803077697754
[44] => 0.00010180473327637
[45] => 9.2029571533203E-5
[46] => 0.0001068115234375
[47] => 0.0002748966217041
[48] => 0.00011301040649414
[49] => 9.3936920166016E-5
[50] => 8.7976455688477E-5
[51] => 8.2015991210938E-5
[52] => 0.00011706352233887
[53] => 8.2015991210938E-5
[54] => 0.00014185905456543
[55] => 0.00011110305786133
[56] => 0.000244140625
[57] => 0.00012087821960449
[58] => 9.3936920166016E-5
[59] => 8.702278137207E-5
[60] => 8.2015991210938E-5
[61] => 0.00010800361633301
[62] => 0.00010299682617188
[63] => 0.00012397766113281
[64] => 0.0001978874206543
[65] => 0.0004270076751709
[66] => 8.8930130004883E-5
[67] => 0.00017595291137695
[68] => 0.00013208389282227
[69] => 8.1777572631836E-5
[70] => 0.00044584274291992
)
[data_cache] => Array
(
[table_names] => Array
(
[0] => agroshopper
[1] => anuncios
[2] => anuncios_envios
[3] => anuncios_generalistas
[4] => anuncios_generalistas_imagenes
[5] => anuncios_imagenes
[6] => anuncios_milanuncios
[7] => anuncios_reportes
[8] => anuncios_venderapido
[9] => anuncios_web
[10] => anuncios_web_imagenes
[11] => captcha
[12] => categorias
[13] => certificaciones
[14] => ci_sessions
[15] => contactos
[16] => empresas
[17] => empresas_contactos
[18] => empresas_sedes
[19] => intentos_login
[20] => maquina_anuncio
[21] => maquinas
[22] => maquinas_imagenes
[23] => maquinas_videos
[24] => marcas
[25] => migrations
[26] => mnt_imagenes
[27] => roles
[28] => servicios
[29] => suscripciones
[30] => suscripciones_planes
[31] => suscripciones_planes_copia
[32] => usuario_agroshopper_checks
[33] => usuarios
[34] => usuarios_roles
)
)
[trans_enabled] => 1
[trans_strict] => 1
[_trans_depth:protected] => 0
[_trans_status:protected] => 1
[_trans_failure:protected] =>
[cache_on] =>
[cachedir] =>
[cache_autodel] =>
[CACHE] =>
[_protect_identifiers:protected] => 1
[_reserved_identifiers:protected] => Array
(
[0] => *
)
[_like_escape_str:protected] => ESCAPE '%s'
[_like_escape_chr:protected] => !
[_random_keyword:protected] => Array
(
[0] => RAND()
[1] => RAND(%d)
)
[_count_string:protected] => SELECT COUNT(*) AS
[failover] => Array
(
)
)
[fillable] => Array
(
[0] => usuarios_id
[1] => anuncios_id
[2] => fecha
[3] => created_at
[4] => updated_at
[5] => deleted_at
)
[protected] => Array
(
[0] => id
)
[timestamps:protected] => 1
[timestamps_format:protected] => Y-m-d H:i:s
[_created_at_field:protected] => created_at
[_updated_at_field:protected] => updated_at
[_deleted_at_field:protected] => deleted_at
[soft_deletes:protected] =>
[_relationships:MY_Model:private] => Array
(
)
[has_one] => Array
(
[usuario] => Array
(
[foreign_model] => usuario_model
[foreign_table] => usuarios
[foreign_key] => id
[local_key] => usuarios_id
)
[anuncio] => Array
(
[foreign_model] => anuncio_model
[foreign_table] => anuncios
[foreign_key] => id
[local_key] => anuncios_id
)
)
[has_many] => Array
(
)
[has_many_pivot] => Array
(
)
[separate_subqueries] => 1
[_requested:MY_Model:private] => Array
(
)
[cache_driver] => file
[cache_prefix] => mm
[_cache:protected] => Array
(
)
[delete_cache_on_save] =>
[next_page] =>
[previous_page] =>
[all_pages] =>
[pagination_delimiters] => Array
(
[0] => <span>
[1] => </span>
)
[pagination_arrows] => Array
(
[0] => <
[1] => >
)
[validated:MY_Model:private] => 1
[row_fields_to_update:MY_Model:private] => Array
(
)
[before_create:protected] => Array
(
)
[after_create:protected] => Array
(
)
[before_update:protected] => Array
(
)
[after_update:protected] => Array
(
)
[before_get:protected] => Array
(
)
[after_get:protected] => Array
(
)
[before_delete:protected] => Array
(
)
[after_delete:protected] => Array
(
)
[before_soft_delete:protected] => Array
(
)
[after_soft_delete:protected] => Array
(
)
[callback_parameters:protected] => Array
(
)
[return_as:protected] => array
[return_as_dropdown:protected] =>
[_dropdown_field:protected] =>
[_trashed:MY_Model:private] => without
[_select:MY_Model:private] => *
)
|
