250.76 ms (76.85%)
|
72 |
SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = ? AND t0_.activo = ?
Parameters: [
"vehicles.page_title"
1
]
SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'vehicles.page_title' AND t0_.activo = 1;
|
57.47 ms (17.61%)
|
13 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_mobile AS filename_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.size_mobile AS size_mobile_8, t0.mime_type_mobile AS mime_type_mobile_9, t0.alt AS alt_10, t0.titulo AS titulo_11, t0.descripcion AS descripcion_12, t0.llave AS llave_13, t0.seccion AS seccion_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.galeria_id AS galeria_id_19 FROM imagenes t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_mobile AS filename_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.size_mobile AS size_mobile_8, t0.mime_type_mobile AS mime_type_mobile_9, t0.alt AS alt_10, t0.titulo AS titulo_11, t0.descripcion AS descripcion_12, t0.llave AS llave_13, t0.seccion AS seccion_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.galeria_id AS galeria_id_19 FROM imagenes t0 WHERE t0.id = 14;
|
7.39 ms (2.26%)
|
4 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = ? ORDER BY t0_.orden ASC, t0_.nombre ASC
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = 1 ORDER BY t0_.orden ASC, t0_.nombre ASC;
|
4.41 ms (1.35%)
|
1 |
SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = ? AND i0_.visible = ?
Parameters: [
"img-favicon"
1
]
SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = 'img-favicon' AND i0_.visible = 1;
|
1.85 ms (0.57%)
|
1 |
SELECT COUNT(m0_.id) AS sclr_0 FROM modelos m0_ WHERE m0_.id IN (SELECT DISTINCT m1_.id FROM modelos m1_ LEFT JOIN marca m2_ ON m1_.marca_id = m2_.id LEFT JOIN tipos_vehiculo t3_ ON m1_.tipo_vehiculo_id = t3_.id LEFT JOIN versiones v4_ ON m1_.id = v4_.modelo_id WHERE m1_.visible = 1 AND m1_.es_nuevo = ? AND t3_.id IN (?) ORDER BY m1_.nombre ASC)
SELECT COUNT(m0_.id) AS sclr_0 FROM modelos m0_ WHERE m0_.id IN (SELECT DISTINCT m1_.id FROM modelos m1_ LEFT JOIN marca m2_ ON m1_.marca_id = m2_.id LEFT JOIN tipos_vehiculo t3_ ON m1_.tipo_vehiculo_id = t3_.id LEFT JOIN versiones v4_ ON m1_.id = v4_.modelo_id WHERE m1_.visible = 1 AND m1_.es_nuevo = 0 AND t3_.id IN ('14') ORDER BY m1_.nombre ASC);
|
1.61 ms (0.49%)
|
1 |
SELECT DISTINCT v0_.combustible AS combustible_0 FROM versiones v0_ WHERE v0_.visible = ? AND v0_.combustible IS NOT NULL AND v0_.combustible <> ? ORDER BY v0_.combustible ASC
SELECT DISTINCT v0_.combustible AS combustible_0 FROM versiones v0_ WHERE v0_.visible = 1 AND v0_.combustible IS NOT NULL AND v0_.combustible <> '' ORDER BY v0_.combustible ASC;
|
1.42 ms (0.43%)
|
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.orden AS orden_2, m0_.visible AS visible_3, m0_.created_at AS created_at_4, m0_.imagen_id AS imagen_id_5 FROM marca m0_ WHERE m0_.visible = ? ORDER BY m0_.orden ASC, m0_.nombre ASC
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.orden AS orden_2, m0_.visible AS visible_3, m0_.created_at AS created_at_4, m0_.imagen_id AS imagen_id_5 FROM marca m0_ WHERE m0_.visible = 1 ORDER BY m0_.orden ASC, m0_.nombre ASC;
|
1.38 ms (0.42%)
|
1 |
SELECT DISTINCT m0_.id AS id_0 FROM modelos m0_ LEFT JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN tipos_vehiculo t2_ ON m0_.tipo_vehiculo_id = t2_.id LEFT JOIN versiones v3_ ON m0_.id = v3_.modelo_id WHERE m0_.visible = 1 AND m0_.es_nuevo = ? AND t2_.id IN (?) ORDER BY m0_.nombre ASC LIMIT 12
SELECT DISTINCT m0_.id AS id_0 FROM modelos m0_ LEFT JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN tipos_vehiculo t2_ ON m0_.tipo_vehiculo_id = t2_.id LEFT JOIN versiones v3_ ON m0_.id = v3_.modelo_id WHERE m0_.visible = 1 AND m0_.es_nuevo = 0 AND t2_.id IN ('14') ORDER BY m0_.nombre ASC LIMIT 12;
|