| 1 |
0.66 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.street_address AS street_address_4, a0_.address_line2 AS address_line2_5, a0_.city AS city_6, a0_.state AS state_7, a0_.postal_code AS postal_code_8, a0_.country_code AS country_code_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.created_at AS created_at_12, a1_.id AS id_13, a1_.image_name AS image_name_14, a2_.id AS id_15, a2_.label AS label_16, a2_.phone_number AS phone_number_17, a2_.comment AS comment_18, a2_.position AS position_19, a0_.owner_id AS owner_id_20, a1_.dismantling_id AS dismantling_id_21, a2_.dismantling_id AS dismantling_id_22 FROM auto_dismantlings a0_ LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id WHERE a0_.id = ? ORDER BY a2_.position ASC, a2_.id ASC
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.street_address AS street_address_4, a0_.address_line2 AS address_line2_5, a0_.city AS city_6, a0_.state AS state_7, a0_.postal_code AS postal_code_8, a0_.country_code AS country_code_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.created_at AS created_at_12, a1_.id AS id_13, a1_.image_name AS image_name_14, a2_.id AS id_15, a2_.label AS label_16, a2_.phone_number AS phone_number_17, a2_.comment AS comment_18, a2_.position AS position_19, a0_.owner_id AS owner_id_20, a1_.dismantling_id AS dismantling_id_21, a2_.dismantling_id AS dismantling_id_22 FROM auto_dismantlings a0_ LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id WHERE a0_.id = 4 ORDER BY a2_.position ASC, a2_.id ASC;
|