| 0.0001 |
SELECT GET_LOCK('3249af7c1b50bbea68b36c863327efc7', 300) AS ci_session_lock
|
| 0.0009 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'badb170bb5c41fadf8e20da1945d1cd8075f30d7'
|
| 0.0002 |
SHOW TABLES FROM `agronomis_ci`
|
| 0.0006 |
SHOW COLUMNS FROM `anuncios`
|
| 0.0004 |
SHOW COLUMNS FROM `certificaciones`
|
| 0.0003 |
SELECT *, `anuncios`.`id_categoria`, `anuncios`.`id`, `anuncios`.`id`, `anuncios`.`id_marca`
FROM `anuncios`
WHERE `anuncios`.`activo` != 0
AND `anuncios`.`id` = '189'
LIMIT 1
|
| 0.0004 |
SHOW COLUMNS FROM `categorias`
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('594')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('201')
|
| 0.0004 |
SHOW COLUMNS FROM `maquina_anuncio`
|
| 0.0002 |
SELECT *
FROM `maquina_anuncio`
WHERE `maquina_anuncio`.`id_anuncio` IN('189')
|
| 0.0004 |
SHOW COLUMNS FROM `anuncios_imagenes`
|
| 0.0002 |
SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('189')
|
| 0.0003 |
SHOW COLUMNS FROM `marcas`
|
| 0.0001 |
SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('1043')
|
| 0.0004 |
SHOW COLUMNS FROM `maquinas_videos`
|
| 0.0001 |
SELECT *
FROM `maquinas_videos`
WHERE `maquinas_videos`.`id_maquina` = '349'
|
| 0.0005 |
SHOW COLUMNS FROM `usuarios`
|
| 0.0004 |
SHOW COLUMNS FROM `suscripciones_planes`
|
| 0.0004 |
SHOW COLUMNS FROM `roles`
|
| 0.0002 |
SELECT *, `usuarios`.`id`
FROM `usuarios`
WHERE `usuarios`.`id` = '18'
AND usuarios.deleted_at IS NULL
LIMIT 1
|
| 0.0003 |
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('18')
|
| 0.0001 |
SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
|
| 0.0004 |
SHOW COLUMNS FROM `empresas`
|
| 0.0002 |
SELECT *, `empresas`.`id`, `empresas`.`id`
FROM `empresas`
WHERE `empresas`.`id` = '25'
LIMIT 1
|
| 0.0004 |
SHOW COLUMNS FROM `empresas_contactos`
|
| 0.0001 |
SELECT *
FROM `empresas_contactos`
WHERE `empresas_contactos`.`id_empresa` IN('25')
|
| 0.0004 |
SHOW COLUMNS FROM `empresas_sedes`
|
| 0.0001 |
SELECT *
FROM `empresas_sedes`
WHERE `empresas_sedes`.`id_empresa` IN('25')
|
| 0.0001 |
SELECT `id_categoria`, `id_categoria`
FROM `categorias`
WHERE `categorias`.`padre` = '201'
|
| 0.0069 |
SELECT COUNT(*) AS `numrows`
FROM `anuncios`
LEFT JOIN `maquina_anuncio` as `canal` ON `canal`.`id_anuncio`=`anuncios`.`id`
WHERE `anuncios`.`id_categoria` IN('489', '490', '491', '492', '493', '494', '495', '496', '497', '498', '499', '500', '501', '502', '503', '504', '505', '506', '507', '508', '509', '594', '596')
AND `anuncios`.`activo` = 1
AND `anuncios`.`deleted_at` IS NULL
AND (`canal`.`agronomis` !=0 or `canal`.`agronomis` is null)
|
| 0.0003 |
SELECT `id_categoria`, `id_categoria`
FROM `categorias`
WHERE `categorias`.`padre` = '201'
|
| 0.0068 |
SELECT `anuncios`.`id` as `id`
FROM `anuncios`
LEFT JOIN `maquina_anuncio` as `canal` ON `canal`.`id_anuncio`=`anuncios`.`id`
WHERE `anuncios`.`id_categoria` IN('489', '490', '491', '492', '493', '494', '495', '496', '497', '498', '499', '500', '501', '502', '503', '504', '505', '506', '507', '508', '509', '594', '596')
AND `anuncios`.`activo` = 1
AND `anuncios`.`deleted_at` IS NULL
AND (`canal`.`agronomis` !=0 or `canal`.`agronomis` is null)
ORDER BY RAND()
LIMIT 4
|
| 0.0004 |
SHOW COLUMNS FROM `anuncios_venderapido`
|
| 0.0002 |
SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '1504'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('858')
|
| 0.0001 |
SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('1504')
|
| 0.0001 |
SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('210')
AND usuarios.deleted_at IS NULL
|
| 0.0003 |
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('210')
|
| 0.0001 |
SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('92')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('492')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('201')
|
| 0.0001 |
SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '1510'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('858')
|
| 0.0001 |
SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('1510')
|
| 0.0001 |
SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('210')
AND usuarios.deleted_at IS NULL
|
| 0.0002 |
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('210')
|
| 0.0001 |
SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('92')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('492')
|
| 0.0002 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('201')
|
| 0.0001 |
SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '2882'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('983')
|
| 0.0001 |
SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('2882')
|
| 0.0001 |
SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('210')
AND usuarios.deleted_at IS NULL
|
| 0.0003 |
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('210')
|
| 0.0001 |
SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('92')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('596')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('201')
|
| 0.0001 |
SELECT *, `anuncios`.`id_marca`, `anuncios`.`id`, `anuncios`.`id_usuario`, `anuncios`.`id_categoria`
FROM `anuncios`
WHERE `anuncios`.`id` = '1502'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `marcas`
WHERE `marcas`.`id_marca` IN('858')
|
| 0.0001 |
SELECT *
FROM `anuncios_imagenes`
WHERE `anuncios_imagenes`.`id_anuncio` IN('1502')
|
| 0.0001 |
SELECT *, `usuarios`.`id`, `usuarios`.`id_empresa`
FROM `usuarios`
WHERE `usuarios`.`id` IN('210')
AND usuarios.deleted_at IS NULL
|
| 0.0004 |
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('210')
|
| 0.0001 |
SELECT *
FROM `roles`
WHERE `roles`.`id` = '3'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `empresas`
WHERE `empresas`.`id` IN('92')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('492')
|
| 0.0001 |
SELECT *, `categorias`.`padre`
FROM `categorias`
WHERE `categorias`.`id_categoria` IN('201')
|
| 0.0003 |
SELECT *
FROM `categorias`
WHERE `categorias`.`padre` = 0
|
