| 1 |
1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.address AS address_5, t0.completion_date AS completion_date_6, t0.furniture AS furniture_7, t0.budget_global AS budget_global_8, t0.unit_size AS unit_size_9, t0.unit_number AS unit_number_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.urban AS urban_13, t0.service AS service_14, t0.works AS works_15, t0.purpose AS purpose_16, t0.senior AS senior_17, t0.virtual_tour_before AS virtual_tour_before_18, t0.virtual_tour_after AS virtual_tour_after_19, t0.total_size AS total_size_20, t0.key_number AS key_number_21, t0.size_per_resident AS size_per_resident_22, t0.type AS type_23, t0.citizen_id AS citizen_id_24, t0.configuration AS configuration_25, t0.sort AS sort_26, t0.furnish AS furnish_27, t0.amo AS amo_28, t0.sourcing AS sourcing_29, t0.act AS act_30 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.address AS address_5, t0.completion_date AS completion_date_6, t0.furniture AS furniture_7, t0.budget_global AS budget_global_8, t0.unit_size AS unit_size_9, t0.unit_number AS unit_number_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.urban AS urban_13, t0.service AS service_14, t0.works AS works_15, t0.purpose AS purpose_16, t0.senior AS senior_17, t0.virtual_tour_before AS virtual_tour_before_18, t0.virtual_tour_after AS virtual_tour_after_19, t0.total_size AS total_size_20, t0.key_number AS key_number_21, t0.size_per_resident AS size_per_resident_22, t0.type AS type_23, t0.citizen_id AS citizen_id_24, t0.configuration AS configuration_25, t0.sort AS sort_26, t0.furnish AS furnish_27, t0.amo AS amo_28, t0.sourcing AS sourcing_29, t0.act AS act_30 FROM product t0 WHERE t0.id = '4';
|
| 2 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = 1;
|
| 3 |
0.74 ms |
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = '4' AND p0_.gallery_id = 1 ORDER BY p0_.sort ASC;
|
| 4 |
0.51 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
51
54
53
56
55
52
66
77
76
75
74
73
72
71
70
69
68
67
65
64
63
62
61
]
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (51, 54, 53, 56, 55, 52, 66, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 65, 64, 63, 62, 61);
|
| 5 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = 2;
|
| 6 |
0.50 ms |
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = '4' AND p0_.gallery_id = 2 ORDER BY p0_.sort ASC;
|
| 7 |
0.28 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?, ?, ?, ?)
Parameters: [
57
58
59
60
]
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (57, 58, 59, 60);
|
| 8 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = 3;
|
| 9 |
0.34 ms |
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = '4' AND p0_.gallery_id = 3 ORDER BY p0_.sort ASC;
|
| 10 |
0.24 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?)
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (1020);
|