| 1 |
2.64 ms |
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, s3_.id AS id_13, s3_.title AS title_14, s3_.slug AS slug_15, s3_.profession_title AS profession_title_16, s3_.profession_description AS profession_description_17, s3_.seo_title AS seo_title_18, s3_.seo_description AS seo_description_19, s3_.seo_image AS seo_image_20, s3_.locale AS locale_21, p4_.id AS id_22, p4_.sort AS sort_23, p5_.id AS id_24, p5_.title AS title_25, p5_.locale AS locale_26, p0_.particular_project_budget_id AS particular_project_budget_id_27, p0_.user_id AS user_id_28, p1_.translatable_id AS translatable_id_29, s3_.translatable_id AS translatable_id_30, p5_.translatable_id AS translatable_id_31 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s3_ ON s2_.id = s3_.translatable_id AND (s3_.locale = ?) LEFT JOIN particular_project_budget p4_ ON p0_.particular_project_budget_id = p4_.id LEFT JOIN particular_project_budget_translation p5_ ON p4_.id = p5_.translatable_id AND (p5_.locale = ?) WHERE p0_.status IN (?) ORDER BY p0_.created_at DESC
Parameters: [
"fr"
"fr"
"active"
]
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, s3_.id AS id_13, s3_.title AS title_14, s3_.slug AS slug_15, s3_.profession_title AS profession_title_16, s3_.profession_description AS profession_description_17, s3_.seo_title AS seo_title_18, s3_.seo_description AS seo_description_19, s3_.seo_image AS seo_image_20, s3_.locale AS locale_21, p4_.id AS id_22, p4_.sort AS sort_23, p5_.id AS id_24, p5_.title AS title_25, p5_.locale AS locale_26, p0_.particular_project_budget_id AS particular_project_budget_id_27, p0_.user_id AS user_id_28, p1_.translatable_id AS translatable_id_29, s3_.translatable_id AS translatable_id_30, p5_.translatable_id AS translatable_id_31 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s3_ ON s2_.id = s3_.translatable_id AND (s3_.locale = 'fr') LEFT JOIN particular_project_budget p4_ ON p0_.particular_project_budget_id = p4_.id LEFT JOIN particular_project_budget_translation p5_ ON p4_.id = p5_.translatable_id AND (p5_.locale = 'fr') WHERE p0_.status IN ('active') ORDER BY p0_.created_at DESC;
|
| 2 |
0.58 ms |
SELECT s0_.id AS id_0, s0_.icon_image AS icon_image_1, s0_.sort AS sort_2, s1_.id AS id_3, s1_.title AS title_4, s1_.slug AS slug_5, s1_.profession_title AS profession_title_6, s1_.profession_description AS profession_description_7, s1_.seo_title AS seo_title_8, s1_.seo_description AS seo_description_9, s1_.seo_image AS seo_image_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM service s0_ LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?)
SELECT s0_.id AS id_0, s0_.icon_image AS icon_image_1, s0_.sort AS sort_2, s1_.id AS id_3, s1_.title AS title_4, s1_.slug AS slug_5, s1_.profession_title AS profession_title_6, s1_.profession_description AS profession_description_7, s1_.seo_title AS seo_title_8, s1_.seo_description AS seo_description_9, s1_.seo_image AS seo_image_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM service s0_ LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr');
|