| 1 |
0.43 ms |
SELECT f0_.id AS id_0, f0_.icon AS icon_1, f0_.title AS title_2, f0_.duration AS duration_3, f0_.price AS price_4, f0_.description AS description_5, f0_.color AS color_6, f0_.is_published AS is_published_7, f0_.position AS position_8 FROM formation f0_ WHERE f0_.is_published = 1 ORDER BY f0_.position ASC
SELECT f0_.id AS id_0, f0_.icon AS icon_1, f0_.title AS title_2, f0_.duration AS duration_3, f0_.price AS price_4, f0_.description AS description_5, f0_.color AS color_6, f0_.is_published AS is_published_7, f0_.position AS position_8 FROM formation f0_ WHERE f0_.is_published = 1 ORDER BY f0_.position ASC;
|
| 2 |
0.82 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.billing_cycle AS billing_cycle_4, p0_.is_active AS is_active_5, p0_.position AS position_6, p1_.id AS id_7, p1_.label AS label_8, p1_.position AS position_9, p1_.pack_id AS pack_id_10 FROM pack p0_ LEFT JOIN pack_feature p1_ ON p0_.id = p1_.pack_id WHERE p0_.is_active = 1 ORDER BY p0_.position ASC, p1_.position ASC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.billing_cycle AS billing_cycle_4, p0_.is_active AS is_active_5, p0_.position AS position_6, p1_.id AS id_7, p1_.label AS label_8, p1_.position AS position_9, p1_.pack_id AS pack_id_10 FROM pack p0_ LEFT JOIN pack_feature p1_ ON p0_.id = p1_.pack_id WHERE p0_.is_active = 1 ORDER BY p0_.position ASC, p1_.position ASC;
|
| 3 |
0.28 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.price AS price_2, t0_.info AS info_3, t0_.badge_label AS badge_label_4, t0_.category AS category_5, t0_.is_active AS is_active_6, t0_.position AS position_7, t0_.section_id AS section_id_8 FROM tarif t0_ WHERE t0_.is_active = 1 ORDER BY t0_.category ASC, t0_.position ASC
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.price AS price_2, t0_.info AS info_3, t0_.badge_label AS badge_label_4, t0_.category AS category_5, t0_.is_active AS is_active_6, t0_.position AS position_7, t0_.section_id AS section_id_8 FROM tarif t0_ WHERE t0_.is_active = 1 ORDER BY t0_.category ASC, t0_.position ASC;
|
| 4 |
0.38 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.image_path AS image_path_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN `user` u2_ ON b0_.author_id = u2_.id WHERE b0_.status = ? ORDER BY b0_.published_at DESC LIMIT 3
Parameters: [
"published"
]
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.image_path AS image_path_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN `user` u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' ORDER BY b0_.published_at DESC LIMIT 3;
|