| 1 |
0.76 ms |
SELECT a0_.id AS id_0, a0_.advert_name AS advert_name_1, a0_.advert_location AS advert_location_2, a0_.advert_pieces AS advert_pieces_3, a0_.advert_sale AS advert_sale_4, a0_.advert_description AS advert_description_5, a0_.advert_date AS advert_date_6, a0_.advert_living_space AS advert_living_space_7, a0_.advert_total_surface AS advert_total_surface_8, a0_.advert_rent_alone AS advert_rent_alone_9, a0_.advert_rent_charges AS advert_rent_charges_10, a0_.advert_type_id AS advert_type_id_11, a0_.advert_photo_id AS advert_photo_id_12, a0_.advert_user_id AS advert_user_id_13 FROM advert a0_ ORDER BY a0_.advert_date DESC, a0_.advert_sale ASC
SELECT a0_.id AS id_0, a0_.advert_name AS advert_name_1, a0_.advert_location AS advert_location_2, a0_.advert_pieces AS advert_pieces_3, a0_.advert_sale AS advert_sale_4, a0_.advert_description AS advert_description_5, a0_.advert_date AS advert_date_6, a0_.advert_living_space AS advert_living_space_7, a0_.advert_total_surface AS advert_total_surface_8, a0_.advert_rent_alone AS advert_rent_alone_9, a0_.advert_rent_charges AS advert_rent_charges_10, a0_.advert_type_id AS advert_type_id_11, a0_.advert_photo_id AS advert_photo_id_12, a0_.advert_user_id AS advert_user_id_13 FROM advert a0_ ORDER BY a0_.advert_date DESC, a0_.advert_sale ASC;
|
| 2 |
0.62 ms |
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = 35;
|
| 3 |
0.33 ms |
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = 2;
|
| 4 |
0.66 ms |
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = 4;
|
| 5 |
0.34 ms |
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = 4;
|
| 6 |
0.86 ms |
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = 3;
|
| 7 |
0.30 ms |
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = 3;
|