| 1 |
1.02 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 2 |
46.08 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, c1_.id AS id_19, c1_.name AS name_20, c1_.slug AS slug_21, c1_.created_at AS created_at_22, c1_.updated_at AS updated_at_23, c1_.deleted_at AS deleted_at_24, c1_.status AS status_25, c1_.description AS description_26, c1_.main_view AS main_view_27, c1_.theme AS theme_28, c1_.orders AS orders_29, c1_.metakey AS metakey_30, c1_.metadesc AS metadesc_31, c1_.canonical AS canonical_32, f2_.id AS id_33, f2_.description AS description_34, f2_.url AS url_35, f2_.created_at AS created_at_36, f2_.updated_at AS updated_at_37, a0_.user_id AS user_id_38, a0_.category_id AS category_id_39, a0_.image_card_id AS image_card_id_40, a0_.image_header_id AS image_header_id_41 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN FILE f2_ ON a0_.image_card_id = f2_.id WHERE a0_.reviewed_at IS NOT NULL AND a0_.main_view = ? AND a0_.status = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 4
Parameters: [
1
"published"
"2025-01-14 14:52:36"
]
SELECT
a0_.id AS id_0,
a0_.title AS title_1,
a0_.slug AS slug_2,
a0_.introtext AS introtext_3,
a0_.content AS content_4,
a0_.created_at AS created_at_5,
a0_.updated_at AS updated_at_6,
a0_.deleted_at AS deleted_at_7,
a0_.status AS status_8,
a0_.featured AS featured_9,
a0_.main_view AS main_view_10,
a0_.clicks AS clicks_11,
a0_.reviewed_at AS reviewed_at_12,
a0_.metakey AS metakey_13,
a0_.metadesc AS metadesc_14,
a0_.robots AS robots_15,
a0_.published_at AS published_at_16,
a0_.canonical AS canonical_17,
a0_.super_tag AS super_tag_18,
c1_.id AS id_19,
c1_.name AS name_20,
c1_.slug AS slug_21,
c1_.created_at AS created_at_22,
c1_.updated_at AS updated_at_23,
c1_.deleted_at AS deleted_at_24,
c1_.status AS status_25,
c1_.description AS description_26,
c1_.main_view AS main_view_27,
c1_.theme AS theme_28,
c1_.orders AS orders_29,
c1_.metakey AS metakey_30,
c1_.metadesc AS metadesc_31,
c1_.canonical AS canonical_32,
f2_.id AS id_33,
f2_.description AS description_34,
f2_.url AS url_35,
f2_.created_at AS created_at_36,
f2_.updated_at AS updated_at_37,
a0_.user_id AS user_id_38,
a0_.category_id AS category_id_39,
a0_.image_card_id AS image_card_id_40,
a0_.image_header_id AS image_header_id_41
FROM
article a0_
LEFT JOIN category c1_ ON a0_.category_id = c1_.id
LEFT JOIN FILE f2_ ON a0_.image_card_id = f2_.id
WHERE
a0_.reviewed_at IS NOT NULL
AND a0_.main_view = ?
AND a0_.status = ?
AND a0_.published_at <= ?
ORDER BY
a0_.published_at DESC
LIMIT
4
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, c1_.id AS id_19, c1_.name AS name_20, c1_.slug AS slug_21, c1_.created_at AS created_at_22, c1_.updated_at AS updated_at_23, c1_.deleted_at AS deleted_at_24, c1_.status AS status_25, c1_.description AS description_26, c1_.main_view AS main_view_27, c1_.theme AS theme_28, c1_.orders AS orders_29, c1_.metakey AS metakey_30, c1_.metadesc AS metadesc_31, c1_.canonical AS canonical_32, f2_.id AS id_33, f2_.description AS description_34, f2_.url AS url_35, f2_.created_at AS created_at_36, f2_.updated_at AS updated_at_37, a0_.user_id AS user_id_38, a0_.category_id AS category_id_39, a0_.image_card_id AS image_card_id_40, a0_.image_header_id AS image_header_id_41 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN FILE f2_ ON a0_.image_card_id = f2_.id WHERE a0_.reviewed_at IS NOT NULL AND a0_.main_view = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' ORDER BY a0_.published_at DESC LIMIT 4;
|
| 3 |
15.78 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.featured = ? AND a0_.status = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 9
Parameters: [
1
"published"
"2025-01-14 14:52:36"
]
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' ORDER BY a0_.published_at DESC LIMIT 9;
|
| 4 |
0.44 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"facebook"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'facebook' AND s0_.type = 'general';
|
| 5 |
0.24 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"twitter"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'twitter' AND s0_.type = 'general';
|
| 6 |
0.19 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"linkedin"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'linkedin' AND s0_.type = 'general';
|
| 7 |
0.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"youtube"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'youtube' AND s0_.type = 'general';
|
| 8 |
0.18 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"ios_app"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'ios_app' AND s0_.type = 'general';
|
| 9 |
0.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"android_app"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'android_app' AND s0_.type = 'general';
|
| 10 |
0.33 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 11 |
0.38 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderHeader"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderHeader' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 12 |
0.41 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = ? ORDER BY c0_.orders ASC
Parameters: [
"published"
]
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = 'published' ORDER BY c0_.orders ASC;
|
| 13 |
0.32 ms |
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = ? ORDER BY p0_.orders ASC
Parameters: [
"published"
]
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = 'published' ORDER BY p0_.orders ASC;
|
| 14 |
0.22 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"facebook"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'facebook' AND s0_.type = 'general';
|
| 15 |
0.16 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"twitter"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'twitter' AND s0_.type = 'general';
|
| 16 |
0.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"linkedin"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'linkedin' AND s0_.type = 'general';
|
| 17 |
0.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"youtube"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'youtube' AND s0_.type = 'general';
|
| 18 |
0.24 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 90863;
|
| 19 |
0.20 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 90859;
|
| 20 |
0.16 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 90854;
|
| 21 |
0.23 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 68258;
|
| 22 |
0.23 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 68257;
|
| 23 |
0.21 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 68256;
|
| 24 |
0.29 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 25 |
23.70 ms |
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= ? AND c1_.status = ? LIMIT 8
Parameters: [
"2025-01-14 14:52:36"
"published"
]
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' AND c1_.status = 'published' LIMIT 8;
|
| 26 |
0.56 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 27 |
138.12 ms |
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.status = 'published' AND a0_.published_at <= ? AND c1_.status = ? ORDER BY a0_.clicks DESC LIMIT 8
Parameters: [
"2025-01-14 14:52:36"
"published"
]
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' AND c1_.status = 'published' ORDER BY a0_.clicks DESC LIMIT 8;
|
| 28 |
0.51 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderCarousel' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 29 |
20.23 ms |
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= ? AND c1_.status = ? LIMIT 8
Parameters: [
"2025-01-14 14:52:36"
"published"
]
SELECT a0_.title AS title_0, a0_.slug AS slug_1, c1_.slug AS slug_2, f2_.url AS url_3, f2_.description AS description_4 FROM article a0_ INNER JOIN category c1_ ON (c1_.id = a0_.category_id) INNER JOIN FILE f2_ ON (a0_.image_card_id = f2_.id) WHERE a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' AND c1_.status = 'published' LIMIT 8;
|
| 30 |
0.37 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderFooter"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderFooter' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|
| 31 |
0.25 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"footer_description"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'footer_description' AND s0_.type = 'general';
|
| 32 |
16.52 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.status = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 5
Parameters: [
"published"
"2025-01-14 14:52:36"
]
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' ORDER BY a0_.published_at DESC LIMIT 5;
|
| 33 |
0.40 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = ? ORDER BY c0_.orders ASC
Parameters: [
"published"
]
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = 'published' ORDER BY c0_.orders ASC;
|
| 34 |
0.23 ms |
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = ? ORDER BY p0_.orders ASC
Parameters: [
"published"
]
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = 'published' ORDER BY p0_.orders ASC;
|
| 35 |
0.16 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"facebook"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'facebook' AND s0_.type = 'general';
|
| 36 |
0.16 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"twitter"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'twitter' AND s0_.type = 'general';
|
| 37 |
0.14 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"linkedin"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'linkedin' AND s0_.type = 'general';
|
| 38 |
0.14 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters: [
"youtube"
"general"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'youtube' AND s0_.type = 'general';
|
| 39 |
2.82 ms |
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters: [
"https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderCookie"
"published"
]
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderCookie' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;
|