CURLS:
Array
(
[donde_estoy] => /include/estructura.php:118
[count] => 2
[object_debug] => Array
(
[0] => /class/Motos.php:515 = https://apipre2.appmoto.net/v1/es/custom/daniSql
[1] => /class/Motos.php:80 = https://apipre2.appmoto.net/v1/es/productos/getQuery
)
)
Querys:
Array
(
[donde_estoy] => /include/estructura.php:121
[count] => 201
[object_debug] => Array
(
[0] => /class/Sql.php:137:: SELECT t1.* FROM lvt_configuraciones t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1'
[1] => /class/Sql.php:137:: SELECT t1.* FROM lvt_idiomas t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1'
[2] => /class/Sql.php:137:: SELECT t1.* FROM lvt_traducciones_frontend t1 WHERE t1.id_idioma = 1
[3] => /class/Sql.php:137:: SELECT t1.* FROM lvt_microsites t1 WHERE t1.subdominio = 'pre2' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[4] => /class/Sql.php:137:: SELECT t1.* FROM lvt_microsites t1 WHERE t1.id = 1 LIMIT 1
[5] => /class/BBDD.php:93:: SELECT * FROM lvt_urls WHERE tabla='paginas' AND id_tabla NOt IN (select id FROM lvt_paginas WHERE tipo_pagina='HOME')
[6] => /class/Sql.php:137:: SELECT t1.* FROM lvt_provincias t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1'
[7] => /class/Sql.php:137:: SELECT t1.* FROM lvt_marcas t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion desc,nombre asc
[8] => /class/BBDD.php:93:: select * from lvt_marcas_idiomas where id in (SELECT t1.id FROM lvt_marcas t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion desc,nombre asc) AND id_idioma=1
[9] => /class/BBDD.php:93:: SELECT DISTINCT(ma.id), ma.id_api, ma.nombre, ma.ordenacion FROM lvt_productos p INNER JOIN lvt_marcas ma on ma.id = p.id_marca WHERE 1 AND (p.estado_venta = 'DISPONIBLE' OR (p.estado_venta = 'VENDIDO' AND p.fecha_modificacion >= UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY))) AND p.estado='CREADO' AND p.activo=1 AND p.estado_anuncio='PUBLICADO' AND ma.activo=1 AND ma.estado='CREADO' order by ma.ordenacion desc, ma.nombre asc
[10] => /class/Sql.php:137:: SELECT t1.* FROM lvt_categorias t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1'
[11] => /class/BBDD.php:93:: select * from lvt_categorias_idiomas where id in (SELECT t1.id FROM lvt_categorias t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1') AND id_idioma=1
[12] => /class/Sql.php:137:: SELECT t1.* FROM lvt_usuarios_web t1 WHERE t1.tipo_usuario = 'PROFESIONAL' AND t1.distribuidor = '0' AND t1.estado = 'CREADO' AND t1.activo = '1'
[13] => /class/BBDD.php:93:: select * from lvt_usuarios_web_idiomas where id in (SELECT t1.id FROM lvt_usuarios_web t1 WHERE t1.tipo_usuario = 'PROFESIONAL' AND t1.distribuidor = '0' AND t1.activo = '1') AND id_idioma=1
[14] => /class/Sql.php:137:: SELECT t1.* FROM lvt_tipos_motos t1 WHERE t1.estado = 'CREADO' AND t1.activo = '1'
[15] => /class/BBDD.php:93:: SELECT min(precio), max(precio), min(cilindrada), max(cilindrada), min(kilometros), max(kilometros), min(potencia), max(potencia), min(anio), max(anio) FROM v_buscador WHERE estado_venta='DISPONIBLE' LIMIT 1;
[16] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.url = 'encuentra-tu-moto' AND t1.id_idioma = 1 LIMIT 1
[17] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[18] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.activo = '1' ) AND id_idioma=1
[19] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND ISNULL(t1.id_menu_enlace) AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[20] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND ISNULL(t1.id_menu_enlace) AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[21] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[22] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.activo = '1' ) AND id_idioma=1
[23] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '2' AND t1.id_idioma = '1' LIMIT 1
[24] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '2' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[25] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '2' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[26] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '2' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[27] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '2' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[28] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '35' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[29] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '35' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[30] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '35' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[31] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '35' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[32] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '32' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[33] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '32' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[34] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '32' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[35] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '32' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[36] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '36' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[37] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '36' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[38] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '36' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[39] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '36' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[40] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '37' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[41] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '37' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[42] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '37' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[43] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '37' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[44] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '53' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[45] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '53' AND t1.activo = '1' ) AND id_idioma=1
[46] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '53' AND t1.id_idioma = '1' LIMIT 1
[47] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '34' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[48] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '34' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[49] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '34' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[50] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '34' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[51] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '5' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[52] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '5' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[53] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '5' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[54] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '5' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[55] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '25' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[56] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '25' AND t1.activo = '1' ) AND id_idioma=1
[57] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '25' AND t1.id_idioma = '1' LIMIT 1
[58] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '6' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[59] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '6' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[60] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '6' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[61] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '6' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[62] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '26' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[63] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '26' AND t1.activo = '1' ) AND id_idioma=1
[64] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '26' AND t1.id_idioma = '1' LIMIT 1
[65] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '7' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[66] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '7' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[67] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '7' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[68] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '7' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[69] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '28' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[70] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '28' AND t1.activo = '1' ) AND id_idioma=1
[71] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '28' AND t1.id_idioma = '1' LIMIT 1
[72] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '8' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[73] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '8' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[74] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '8' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[75] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '8' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[76] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '27' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[77] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '27' AND t1.activo = '1' ) AND id_idioma=1
[78] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '27' AND t1.id_idioma = '1' LIMIT 1
[79] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '9' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[80] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '9' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[81] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '9' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[82] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '9' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[83] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '29' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[84] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '29' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[85] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '29' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[86] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '29' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[87] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '30' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[88] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '30' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[89] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '30' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[90] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '30' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[91] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '31' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[92] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '31' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[93] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '31' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[94] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '31' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[95] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '14' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[96] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '14' AND t1.activo = '1' ) AND id_idioma=1
[97] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '14' AND t1.id_idioma = '1' LIMIT 1
[98] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '3' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[99] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '3' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[100] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '3' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[101] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '3' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[102] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '8' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[103] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '8' AND t1.activo = '1' ) AND id_idioma=1
[104] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '8' AND t1.id_idioma = '1' LIMIT 1
[105] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '4' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[106] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '4' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[107] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '4' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion asc
[108] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 1 AND t1.id_menu_enlace = '4' AND t1.activo = '1' ORDER BY ordenacion asc) AND id_idioma=1
[109] => /class/Motos.php:515:: SELECT
distinct(m.nombre) as modelo,
ma.nombre as marca,
'APPMOTO',
p.id_modelo
FROM lvt_productos as p
inner join lvt_modelos as m on m.id=p.id_modelo
left join lvt_marcas as ma on ma.id=p.id_marca
WHERE p.estado='CREADO' AND m.estado ='CREADO' AND m.is_oficial =1 AND ma.estado ='CREADO' AND p.activo=1 AND p.id_marca <>'' AND p.estado_anuncio='PUBLICADO' AND ( p.estado_venta = 'DISPONIBLE' OR (p.estado_venta = 'VENDIDO' AND p.fecha_modificacion >=1745248375)) ORDER BY ma.ordenacion DESC, modelo
[110] => /class/Motos.php:53:: SELECT SQL_CALC_FOUND_ROWS
'select2024' AS select2024,
'APPMOTO' AS contexto,
p.id,
p.id_categoria,
p.id_categoria_brand,
p.nombre,
p.id_marca,
p.id_usuario_web,
p.id_modelo,
p.id_propulsion,
p.consumo_electrico,
p.autonomia_electrica,
p.kilometros,
p.potencia,
p.cilindrada,
p.anio,
p.precio,
p.precio_financiado,
p.precio_financiado_tae,
p.precio_financiado_entrada,
p.precio_financiado_meses,
p.es_nuevo,
p.garantia_marca,
p.destacado,
p.ofrece_garantiplus,
(SELECT IF((p.destacado != 0 && estado_venta = 'DISPONIBLE'), rand(), 0)) as relevancia,
p.descripcion_garantia,
p.id_provincia_localizacion,
p.cp_localizacion,
p.id_localidad_localizacion,
p.fecha_creacion,
p.fecha_modificacion,
p.fecha_matriculacion,
p.estado_venta,
m.nombre as nombre_modelo
FROM lvt_productos as p JOIN lvt_modelos as m ON p.id_modelo = m.id WHERE p.estado='CREADO' AND p.activo=1 AND p.id_marca <>'' AND p.estado_anuncio='PUBLICADO' AND ( p.estado_venta = 'DISPONIBLE' OR (p.estado_venta = 'VENDIDO' AND p.fecha_modificacion >=1745248375)) AND p.id_usuario_web=2190 ORDER BY relevancia DESC, fecha_creacion DESC LIMIT 0, 10
[111] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND ISNULL(t1.id_menu_enlace) AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[112] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND ISNULL(t1.id_menu_enlace) AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[113] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[114] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '2' AND t1.activo = '1' ) AND id_idioma=1
[115] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '2' AND t1.id_idioma = '1' LIMIT 1
[116] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '11' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[117] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '11' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[118] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '11' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[119] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '11' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[120] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '6' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[121] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '6' AND t1.activo = '1' ) AND id_idioma=1
[122] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '6' AND t1.id_idioma = '1' LIMIT 1
[123] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '19' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[124] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '19' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[125] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '19' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[126] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '19' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[127] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '25' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[128] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '25' AND t1.activo = '1' ) AND id_idioma=1
[129] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '25' AND t1.id_idioma = '1' LIMIT 1
[130] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '13' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[131] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '13' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[132] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '13' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[133] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '13' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[134] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '14' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[135] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '14' AND t1.activo = '1' ) AND id_idioma=1
[136] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '14' AND t1.id_idioma = '1' LIMIT 1
[137] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '12' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[138] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '12' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[139] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '12' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[140] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '12' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[141] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '40' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[142] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '40' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[143] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '40' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[144] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '40' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[145] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '41' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[146] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '41' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[147] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '41' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[148] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '41' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[149] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '42' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[150] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '42' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[151] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '42' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[152] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 2 AND t1.id_menu_enlace = '42' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[153] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND ISNULL(t1.id_menu_enlace) AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[154] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND ISNULL(t1.id_menu_enlace) AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[155] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '8' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[156] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '8' AND t1.activo = '1' ) AND id_idioma=1
[157] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '8' AND t1.id_idioma = '1' LIMIT 1
[158] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '20' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[159] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '20' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[160] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '20' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[161] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '20' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[162] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '33' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[163] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '33' AND t1.activo = '1' ) AND id_idioma=1
[164] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '33' AND t1.id_idioma = '1' LIMIT 1
[165] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '14' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[166] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '14' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[167] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '14' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[168] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '14' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[169] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '34' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[170] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '34' AND t1.activo = '1' ) AND id_idioma=1
[171] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '34' AND t1.id_idioma = '1' LIMIT 1
[172] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '16' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[173] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '16' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[174] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '16' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[175] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '16' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[176] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '31' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[177] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '31' AND t1.activo = '1' ) AND id_idioma=1
[178] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '31' AND t1.id_idioma = '1' LIMIT 1
[179] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '17' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[180] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '17' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[181] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '17' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[182] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '17' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[183] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '18' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[184] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '18' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[185] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '18' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[186] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '18' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[187] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '32' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[188] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '32' AND t1.activo = '1' ) AND id_idioma=1
[189] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '32' AND t1.id_idioma = '1' LIMIT 1
[190] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '15' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[191] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '15' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[192] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '15' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[193] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '15' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[194] => /class/Sql.php:137:: SELECT t1.* FROM lvt_paginas t1 WHERE t1.id = '60' AND t1.estado = 'CREADO' AND t1.activo = '1' LIMIT 1
[195] => /class/BBDD.php:93:: select * from lvt_paginas_idiomas where id in (SELECT t1.id FROM lvt_paginas t1 WHERE t1.id = '60' AND t1.activo = '1' ) AND id_idioma=1
[196] => /class/Sql.php:137:: SELECT t1.* FROM lvt_urls t1 WHERE t1.tabla = 'paginas' AND t1.id_tabla = '60' AND t1.id_idioma = '1' LIMIT 1
[197] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '38' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[198] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '38' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
[199] => /class/Sql.php:137:: SELECT t1.* FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '38' AND t1.estado = 'CREADO' AND t1.activo = '1' ORDER BY ordenacion ASC
[200] => /class/BBDD.php:93:: select * from lvt_menus_enlaces_idiomas where id in (SELECT t1.id FROM lvt_menus_enlaces t1 WHERE t1.id_menu = 3 AND t1.id_menu_enlace = '38' AND t1.activo = '1' ORDER BY ordenacion ASC) AND id_idioma=1
)
)
cURL DETALLE:
Array
(
[donde_estoy] => /include/estructura.php:130
[count] => 2
[object_debug] => Array
(
[0] => Array
(
[url] => https://apipre2.appmoto.net/v1/es/custom/daniSql
[datos] => Array
(
[query] => SELECT
distinct(m.nombre) as modelo,
ma.nombre as marca,
'APPMOTO',
p.id_modelo
FROM lvt_productos as p
inner join lvt_modelos as m on m.id=p.id_modelo
left join lvt_marcas as ma on ma.id=p.id_marca
WHERE p.estado='CREADO' AND m.estado ='CREADO' AND m.is_oficial =1 AND ma.estado ='CREADO' AND p.activo=1 AND p.id_marca <>'' AND p.estado_anuncio='PUBLICADO' AND ( p.estado_venta = 'DISPONIBLE' OR (p.estado_venta = 'VENDIDO' AND p.fecha_modificacion >=1745248375)) ORDER BY ma.ordenacion DESC, modelo
[daniSecret] => yO****3D
[entorno] => FRONTEND
[ip_usuario] => 3.143.4.96
[api_key] => 65****61
[api_key_app] => 65****61
[ua] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[seg_id_usuario_web] =>
[overwrite_save_stats] =>
[overwrite_send_stats_to_rabbit] =>
)
[method] => POST
)
[1] => Array
(
[url] => https://apipre2.appmoto.net/v1/es/productos/getQuery
[datos] => Array
(
[query] => SELECT SQL_CALC_FOUND_ROWS
'select2024' AS select2024,
'APPMOTO' AS contexto,
p.id,
p.id_categoria,
p.id_categoria_brand,
p.nombre,
p.id_marca,
p.id_usuario_web,
p.id_modelo,
p.id_propulsion,
p.consumo_electrico,
p.autonomia_electrica,
p.kilometros,
p.potencia,
p.cilindrada,
p.anio,
p.precio,
p.precio_financiado,
p.precio_financiado_tae,
p.precio_financiado_entrada,
p.precio_financiado_meses,
p.es_nuevo,
p.garantia_marca,
p.destacado,
p.ofrece_garantiplus,
(SELECT IF((p.destacado != 0 && estado_venta = 'DISPONIBLE'), rand(), 0)) as relevancia,
p.descripcion_garantia,
p.id_provincia_localizacion,
p.cp_localizacion,
p.id_localidad_localizacion,
p.fecha_creacion,
p.fecha_modificacion,
p.fecha_matriculacion,
p.estado_venta,
m.nombre as nombre_modelo
FROM lvt_productos as p JOIN lvt_modelos as m ON p.id_modelo = m.id WHERE p.estado='CREADO' AND p.activo=1 AND p.id_marca <>'' AND p.estado_anuncio='PUBLICADO' AND ( p.estado_venta = 'DISPONIBLE' OR (p.estado_venta = 'VENDIDO' AND p.fecha_modificacion >=1745248375)) AND p.id_usuario_web=2190 ORDER BY relevancia DESC, fecha_creacion DESC LIMIT 0, 10
[extraData] => Array
(
[donde_estoy] => /class/Motos.php:60
[params] => {"formAnioReferencia":null,"formVista":null,"formPaginacion":null,"formOrdenacion":null,"formVendedor":"uh9aJoyb3Bzx2NdKArtDYQ_p0r_3D_p0r_3D","formCategoria":null,"formPropulsion":null,"formModelo":null,"formModeloTexto":null,"formMarca":null,"formProvincia":null,"formEstado":null,"formTipoVendedor":null,"formPrecio":null,"formPrecioDesde":null,"formPrecioHasta":null,"formKilometrosDesde":null,"formKilometrosHasta":null,"formCilindradaDesde":null,"formCilindradaHasta":null,"formPotenciaDesde":null,"formPotenciaHasta":null,"formAnioDesde":null,"formAnioHasta":null,"formTipoPropulsion":null,"formConcesionario":null}
[session_id] => 4fbtjih5er7erp6457kvs2a5r6
[origen_amclickid] =>
[origen_referer] =>
[usuario_logado] =>
)
[entorno] => FRONTEND
[ip_usuario] => 3.143.4.96
[api_key] => 65****61
[api_key_app] => 65****61
[ua] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[seg_id_usuario_web] =>
[overwrite_save_stats] =>
[overwrite_send_stats_to_rabbit] =>
)
[method] => POST
)
)
)
