| 1 |
0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.image AS image_5, t0.excerpt AS excerpt_6, t0.credits AS credits_7, t0.access_counter AS access_counter_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM bytes_commerce_blog_post t0 WHERE t0.status = ? ORDER BY t0.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.image AS image_5, t0.excerpt AS excerpt_6, t0.credits AS credits_7, t0.access_counter AS access_counter_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM bytes_commerce_blog_post t0 WHERE t0.status = 1 ORDER BY t0.created_at DESC LIMIT 3;
|
| 2 |
1.11 ms |
SELECT o0_.id AS id_0, o0_.warmmiete AS warmmiete_1, o0_.nebenkosten AS nebenkosten_2, o0_.heizkosten AS heizkosten_3, o0_.wohnflaeche AS wohnflaeche_4, o0_.grundstuecksflaeche AS grundstuecksflaeche_5, o0_.anzahl_zimmer AS anzahl_zimmer_6, o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7, o0_.anzahl_badezimmer AS anzahl_badezimmer_8, o0_.endenergiebedarf AS endenergiebedarf_9, o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10, o0_.objekttitel AS objekttitel_11, o0_.objektbeschreibung AS objektbeschreibung_12, o0_.lage AS lage_13, o0_.ausstatt_beschr AS ausstatt_beschr_14, o0_.sonstige_angaben AS sonstige_angaben_15, o0_.kaufpreis AS kaufpreis_16, o0_.mietpreis AS mietpreis_17, o0_.nettokaltmiete AS nettokaltmiete_18, o0_.kaltmiete AS kaltmiete_19, o0_.waehrung AS waehrung_20, o0_.aussen_courtage AS aussen_courtage_21, o0_.strasse AS strasse_22, o0_.hausnummer AS hausnummer_23, o0_.plz AS plz_24, o0_.ort AS ort_25, o0_.bundesland AS bundesland_26, o0_.land AS land_27, o0_.breitengrad AS breitengrad_28, o0_.laengengrad AS laengengrad_29, o0_.vermarktungsart AS vermarktungsart_30, o0_.nutzungsart AS nutzungsart_31, o0_.objektart AS objektart_32, o0_.objekttyp AS objekttyp_33, o0_.zustand AS zustand_34, o0_.baujahr AS baujahr_35, o0_.is_active AS is_active_36, o0_.is_sold AS is_sold_37, o0_.is_reserved AS is_reserved_38, o0_.is_published AS is_published_39, o0_.energieausweistyp AS energieausweistyp_40, o0_.energy_class AS energy_class_41, o0_.energieausweis_baujahr AS energieausweis_baujahr_42, o0_.seo_slug AS seo_slug_43, o0_.stadt_slug AS stadt_slug_44, o0_.erstellt_am AS erstellt_am_45, o0_.geaendert_am AS geaendert_am_46, o0_.created_at AS created_at_47, o0_.updated_at AS updated_at_48 FROM onoffice_estate o0_ WHERE o0_.is_active = ? AND o0_.is_published = ? AND o0_.is_sold = ? AND o0_.is_reserved = ? ORDER BY o0_.created_at DESC
SELECT
o0_.id AS id_0,
o0_.warmmiete AS warmmiete_1,
o0_.nebenkosten AS nebenkosten_2,
o0_.heizkosten AS heizkosten_3,
o0_.wohnflaeche AS wohnflaeche_4,
o0_.grundstuecksflaeche AS grundstuecksflaeche_5,
o0_.anzahl_zimmer AS anzahl_zimmer_6,
o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7,
o0_.anzahl_badezimmer AS anzahl_badezimmer_8,
o0_.endenergiebedarf AS endenergiebedarf_9,
o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10,
o0_.objekttitel AS objekttitel_11,
o0_.objektbeschreibung AS objektbeschreibung_12,
o0_.lage AS lage_13,
o0_.ausstatt_beschr AS ausstatt_beschr_14,
o0_.sonstige_angaben AS sonstige_angaben_15,
o0_.kaufpreis AS kaufpreis_16,
o0_.mietpreis AS mietpreis_17,
o0_.nettokaltmiete AS nettokaltmiete_18,
o0_.kaltmiete AS kaltmiete_19,
o0_.waehrung AS waehrung_20,
o0_.aussen_courtage AS aussen_courtage_21,
o0_.strasse AS strasse_22,
o0_.hausnummer AS hausnummer_23,
o0_.plz AS plz_24,
o0_.ort AS ort_25,
o0_.bundesland AS bundesland_26,
o0_.land AS land_27,
o0_.breitengrad AS breitengrad_28,
o0_.laengengrad AS laengengrad_29,
o0_.vermarktungsart AS vermarktungsart_30,
o0_.nutzungsart AS nutzungsart_31,
o0_.objektart AS objektart_32,
o0_.objekttyp AS objekttyp_33,
o0_.zustand AS zustand_34,
o0_.baujahr AS baujahr_35,
o0_.is_active AS is_active_36,
o0_.is_sold AS is_sold_37,
o0_.is_reserved AS is_reserved_38,
o0_.is_published AS is_published_39,
o0_.energieausweistyp AS energieausweistyp_40,
o0_.energy_class AS energy_class_41,
o0_.energieausweis_baujahr AS energieausweis_baujahr_42,
o0_.seo_slug AS seo_slug_43,
o0_.stadt_slug AS stadt_slug_44,
o0_.erstellt_am AS erstellt_am_45,
o0_.geaendert_am AS geaendert_am_46,
o0_.created_at AS created_at_47,
o0_.updated_at AS updated_at_48
FROM
onoffice_estate o0_
WHERE
o0_.is_active = ?
AND o0_.is_published = ?
AND o0_.is_sold = ?
AND o0_.is_reserved = ?
ORDER BY
o0_.created_at DESC
SELECT o0_.id AS id_0, o0_.warmmiete AS warmmiete_1, o0_.nebenkosten AS nebenkosten_2, o0_.heizkosten AS heizkosten_3, o0_.wohnflaeche AS wohnflaeche_4, o0_.grundstuecksflaeche AS grundstuecksflaeche_5, o0_.anzahl_zimmer AS anzahl_zimmer_6, o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7, o0_.anzahl_badezimmer AS anzahl_badezimmer_8, o0_.endenergiebedarf AS endenergiebedarf_9, o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10, o0_.objekttitel AS objekttitel_11, o0_.objektbeschreibung AS objektbeschreibung_12, o0_.lage AS lage_13, o0_.ausstatt_beschr AS ausstatt_beschr_14, o0_.sonstige_angaben AS sonstige_angaben_15, o0_.kaufpreis AS kaufpreis_16, o0_.mietpreis AS mietpreis_17, o0_.nettokaltmiete AS nettokaltmiete_18, o0_.kaltmiete AS kaltmiete_19, o0_.waehrung AS waehrung_20, o0_.aussen_courtage AS aussen_courtage_21, o0_.strasse AS strasse_22, o0_.hausnummer AS hausnummer_23, o0_.plz AS plz_24, o0_.ort AS ort_25, o0_.bundesland AS bundesland_26, o0_.land AS land_27, o0_.breitengrad AS breitengrad_28, o0_.laengengrad AS laengengrad_29, o0_.vermarktungsart AS vermarktungsart_30, o0_.nutzungsart AS nutzungsart_31, o0_.objektart AS objektart_32, o0_.objekttyp AS objekttyp_33, o0_.zustand AS zustand_34, o0_.baujahr AS baujahr_35, o0_.is_active AS is_active_36, o0_.is_sold AS is_sold_37, o0_.is_reserved AS is_reserved_38, o0_.is_published AS is_published_39, o0_.energieausweistyp AS energieausweistyp_40, o0_.energy_class AS energy_class_41, o0_.energieausweis_baujahr AS energieausweis_baujahr_42, o0_.seo_slug AS seo_slug_43, o0_.stadt_slug AS stadt_slug_44, o0_.erstellt_am AS erstellt_am_45, o0_.geaendert_am AS geaendert_am_46, o0_.created_at AS created_at_47, o0_.updated_at AS updated_at_48 FROM onoffice_estate o0_ WHERE o0_.is_active = 1 AND o0_.is_published = 1 AND o0_.is_sold = 0 AND o0_.is_reserved = 0 ORDER BY o0_.created_at DESC;
|
| 3 |
1.08 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2159 ORDER BY t0.sort_order ASC;
|
| 4 |
0.61 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2157 ORDER BY t0.sort_order ASC;
|
| 5 |
0.60 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2143 ORDER BY t0.sort_order ASC;
|
| 6 |
0.39 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2147 ORDER BY t0.sort_order ASC;
|
| 7 |
0.35 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2145 ORDER BY t0.sort_order ASC;
|
| 8 |
0.41 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2139 ORDER BY t0.sort_order ASC;
|
| 9 |
0.35 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2111 ORDER BY t0.sort_order ASC;
|
| 10 |
0.44 ms |
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = 2107 ORDER BY t0.sort_order ASC;
|
| 11 |
0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.bottom_description AS bottom_description_5, t0.sort_order AS sort_order_6, t0.access_counter AS access_counter_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.parent_id AS parent_id_13 FROM bytes_commerce_blog_category t0 INNER JOIN bytes_commerce_blog_post_category ON t0.id = bytes_commerce_blog_post_category.category_id WHERE bytes_commerce_blog_post_category.post_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.bottom_description AS bottom_description_5, t0.sort_order AS sort_order_6, t0.access_counter AS access_counter_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.parent_id AS parent_id_13 FROM bytes_commerce_blog_category t0 INNER JOIN bytes_commerce_blog_post_category ON t0.id = bytes_commerce_blog_post_category.category_id WHERE bytes_commerce_blog_post_category.post_id = 5;
|