| 1 |
20.03 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.TITLE AS TITLE_4, t0.DESCRIPTION AS DESCRIPTION_5, t0.PRICE AS PRICE_6, t0.PRICE_MIN AS PRICE_MIN_7, t0.PRICE_MAX AS PRICE_MAX_8, t0.CURRENCY AS CURRENCY_9, t0.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_10, t0.IS_SPONSORED AS IS_SPONSORED_11, t0.SPONSORED_UNTIL AS SPONSORED_UNTIL_12, t0.VIEWS_COUNT AS VIEWS_COUNT_13, t0.REJECTION_REASON AS REJECTION_REASON_14, t0.CORRECTION_NOTES AS CORRECTION_NOTES_15, t0.SUBMITTED_AT AS SUBMITTED_AT_16, t0.VALIDATED_AT AS VALIDATED_AT_17, t0.PUBLISHED_AT AS PUBLISHED_AT_18, t0.EXPIRES_AT AS EXPIRES_AT_19, t0.CREATED_AT AS CREATED_AT_20, t0.UPDATED_AT AS UPDATED_AT_21, t0.DELETED_AT AS DELETED_AT_22, t0.PROPERTY AS PROPERTY_23, t0.SUBMITTED_BY AS SUBMITTED_BY_24, t0.TRANSACTION_TYPE AS TRANSACTION_TYPE_25, t0.STATUS AS STATUS_26, t0.PRICE_MODE AS PRICE_MODE_27, t0.VALIDATED_BY AS VALIDATED_BY_28, t0.PUBLISHED_BY AS PUBLISHED_BY_29 FROM listing t0 WHERE t0.SLUG = ? LIMIT 1
Parameters: [
"bureau-gombe-location-105"
]
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.TITLE AS TITLE_4, t0.DESCRIPTION AS DESCRIPTION_5, t0.PRICE AS PRICE_6, t0.PRICE_MIN AS PRICE_MIN_7, t0.PRICE_MAX AS PRICE_MAX_8, t0.CURRENCY AS CURRENCY_9, t0.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_10, t0.IS_SPONSORED AS IS_SPONSORED_11, t0.SPONSORED_UNTIL AS SPONSORED_UNTIL_12, t0.VIEWS_COUNT AS VIEWS_COUNT_13, t0.REJECTION_REASON AS REJECTION_REASON_14, t0.CORRECTION_NOTES AS CORRECTION_NOTES_15, t0.SUBMITTED_AT AS SUBMITTED_AT_16, t0.VALIDATED_AT AS VALIDATED_AT_17, t0.PUBLISHED_AT AS PUBLISHED_AT_18, t0.EXPIRES_AT AS EXPIRES_AT_19, t0.CREATED_AT AS CREATED_AT_20, t0.UPDATED_AT AS UPDATED_AT_21, t0.DELETED_AT AS DELETED_AT_22, t0.PROPERTY AS PROPERTY_23, t0.SUBMITTED_BY AS SUBMITTED_BY_24, t0.TRANSACTION_TYPE AS TRANSACTION_TYPE_25, t0.STATUS AS STATUS_26, t0.PRICE_MODE AS PRICE_MODE_27, t0.VALIDATED_BY AS VALIDATED_BY_28, t0.PUBLISHED_BY AS PUBLISHED_BY_29 FROM listing t0 WHERE t0.SLUG = 'bureau-gombe-location-105' LIMIT 1;
|
| 2 |
0.28 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
1.45 ms |
UPDATE listing SET VIEWS_COUNT = ?, UPDATED_AT = ? WHERE ID = ?
Parameters: [
414
"2026-04-29 08:30:18"
105
]
UPDATE listing SET VIEWS_COUNT = 414, UPDATED_AT = '2026-04-29 08:30:18' WHERE ID = 105;
|
| 4 |
16.12 ms |
"COMMIT"
|
| 5 |
3.37 ms |
SELECT l0_.ID AS ID_0, l0_.UUID AS UUID_1, l0_.SLUG AS SLUG_2, l0_.TITLE AS TITLE_3, l0_.DESCRIPTION AS DESCRIPTION_4, l0_.PRICE AS PRICE_5, l0_.PRICE_MIN AS PRICE_MIN_6, l0_.PRICE_MAX AS PRICE_MAX_7, l0_.CURRENCY AS CURRENCY_8, l0_.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_9, l0_.IS_SPONSORED AS IS_SPONSORED_10, l0_.SPONSORED_UNTIL AS SPONSORED_UNTIL_11, l0_.VIEWS_COUNT AS VIEWS_COUNT_12, l0_.REJECTION_REASON AS REJECTION_REASON_13, l0_.CORRECTION_NOTES AS CORRECTION_NOTES_14, l0_.SUBMITTED_AT AS SUBMITTED_AT_15, l0_.VALIDATED_AT AS VALIDATED_AT_16, l0_.PUBLISHED_AT AS PUBLISHED_AT_17, l0_.EXPIRES_AT AS EXPIRES_AT_18, l0_.CREATED_AT AS CREATED_AT_19, l0_.UPDATED_AT AS UPDATED_AT_20, l0_.DELETED_AT AS DELETED_AT_21, l0_.PROPERTY AS PROPERTY_22, l0_.SUBMITTED_BY AS SUBMITTED_BY_23, l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_24, l0_.STATUS AS STATUS_25, l0_.PRICE_MODE AS PRICE_MODE_26, l0_.VALIDATED_BY AS VALIDATED_BY_27, l0_.PUBLISHED_BY AS PUBLISHED_BY_28 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID WHERE l0_.ID <> ? AND l0_.DELETED_AT IS NULL AND r2_.CODE = ? AND r3_.ID = ? ORDER BY l0_.PUBLISHED_AT DESC LIMIT 3
Parameters: [
105
"published"
1154
]
SELECT l0_.ID AS ID_0, l0_.UUID AS UUID_1, l0_.SLUG AS SLUG_2, l0_.TITLE AS TITLE_3, l0_.DESCRIPTION AS DESCRIPTION_4, l0_.PRICE AS PRICE_5, l0_.PRICE_MIN AS PRICE_MIN_6, l0_.PRICE_MAX AS PRICE_MAX_7, l0_.CURRENCY AS CURRENCY_8, l0_.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_9, l0_.IS_SPONSORED AS IS_SPONSORED_10, l0_.SPONSORED_UNTIL AS SPONSORED_UNTIL_11, l0_.VIEWS_COUNT AS VIEWS_COUNT_12, l0_.REJECTION_REASON AS REJECTION_REASON_13, l0_.CORRECTION_NOTES AS CORRECTION_NOTES_14, l0_.SUBMITTED_AT AS SUBMITTED_AT_15, l0_.VALIDATED_AT AS VALIDATED_AT_16, l0_.PUBLISHED_AT AS PUBLISHED_AT_17, l0_.EXPIRES_AT AS EXPIRES_AT_18, l0_.CREATED_AT AS CREATED_AT_19, l0_.UPDATED_AT AS UPDATED_AT_20, l0_.DELETED_AT AS DELETED_AT_21, l0_.PROPERTY AS PROPERTY_22, l0_.SUBMITTED_BY AS SUBMITTED_BY_23, l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_24, l0_.STATUS AS STATUS_25, l0_.PRICE_MODE AS PRICE_MODE_26, l0_.VALIDATED_BY AS VALIDATED_BY_27, l0_.PUBLISHED_BY AS PUBLISHED_BY_28 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID WHERE l0_.ID <> 105 AND l0_.DELETED_AT IS NULL AND r2_.CODE = 'published' AND r3_.ID = 1154 ORDER BY l0_.PUBLISHED_AT DESC LIMIT 3;
|
| 6 |
0.43 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = 105;
|
| 7 |
0.30 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1154;
|
| 8 |
0.32 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = 105;
|
| 9 |
0.27 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1160;
|
| 10 |
0.27 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = 52;
|
| 11 |
0.24 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1226;
|
| 12 |
0.23 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1149;
|
| 13 |
0.65 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.VALUE_TEXT AS VALUE_TEXT_3, t0.VALUE_NUMBER AS VALUE_NUMBER_4, t0.VALUE_BOOLEAN AS VALUE_BOOLEAN_5, t0.CREATED_AT AS CREATED_AT_6, t0.UPDATED_AT AS UPDATED_AT_7, t0.PROPERTY AS PROPERTY_8, t0.CHARACTERISTIC AS CHARACTERISTIC_9, t0.VALUE_OPTION AS VALUE_OPTION_10 FROM property_characteristic t0 WHERE t0.PROPERTY = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.VALUE_TEXT AS VALUE_TEXT_3, t0.VALUE_NUMBER AS VALUE_NUMBER_4, t0.VALUE_BOOLEAN AS VALUE_BOOLEAN_5, t0.CREATED_AT AS CREATED_AT_6, t0.UPDATED_AT AS UPDATED_AT_7, t0.PROPERTY AS PROPERTY_8, t0.CHARACTERISTIC AS CHARACTERISTIC_9, t0.VALUE_OPTION AS VALUE_OPTION_10 FROM property_characteristic t0 WHERE t0.PROPERTY = 105;
|
| 14 |
0.29 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = 107;
|
| 15 |
0.29 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = 107;
|
| 16 |
0.26 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = 57;
|
| 17 |
0.25 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1156;
|
| 18 |
0.28 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = 103;
|
| 19 |
0.29 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = 103;
|
| 20 |
0.26 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = 55;
|
| 21 |
0.25 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1162;
|
| 22 |
0.26 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = 101;
|
| 23 |
0.29 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = 101;
|
| 24 |
0.26 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = 53;
|
| 25 |
0.99 ms |
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.IS_PRINCIPAL AS IS_PRINCIPAL_3, t0.COMMISSION_PERCENT AS COMMISSION_PERCENT_4, t0.NOTES AS NOTES_5, t0.CREATED_AT AS CREATED_AT_6, t0.UPDATED_AT AS UPDATED_AT_7, t0.DELETED_AT AS DELETED_AT_8, t0.LISTING AS LISTING_9, t0.INTERMEDIARY AS INTERMEDIARY_10 FROM listing_intermediary t0 WHERE t0.LISTING = ?
SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.IS_PRINCIPAL AS IS_PRINCIPAL_3, t0.COMMISSION_PERCENT AS COMMISSION_PERCENT_4, t0.NOTES AS NOTES_5, t0.CREATED_AT AS CREATED_AT_6, t0.UPDATED_AT AS UPDATED_AT_7, t0.DELETED_AT AS DELETED_AT_8, t0.LISTING AS LISTING_9, t0.INTERMEDIARY AS INTERMEDIARY_10 FROM listing_intermediary t0 WHERE t0.LISTING = 105;
|