Symfony Profiler

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.updated_at AS updated_at_2,
  i0_.user_id AS user_id_3,
  i0_.`from` AS from_4,
  i0_.`to` AS to_5,
  u1_.id AS id_6,
  u1_.login_at AS login_at_7,
  u1_.password_at AS password_at_8,
  u1_.activation_at AS activation_at_9,
  u1_.username_at AS username_at_10,
  u1_.password_token AS password_token_11,
  u1_.password_token_created_at AS password_token_created_at_12,
  u1_.activation_token AS activation_token_13,
  u1_.username_token AS username_token_14,
  u1_.source AS source_15,
  u1_.role AS role_16,
  u1_.roles AS roles_17,
  u1_.company_id AS company_id_18,
  u1_.manager AS manager_19,
  u1_.username AS username_20,
  u1_.hash AS hash_21,
  u1_.name AS name_22,
  u1_.salutation AS salutation_23,
  u1_.firstname AS firstname_24,
  u1_.lastname_prefix AS lastname_prefix_25,
  u1_.lastname AS lastname_26,
  u1_.initials AS initials_27,
  u1_.sex AS sex_28,
  u1_.job AS job_29,
  u1_.username_change AS username_change_30,
  u1_.migrated_id AS migrated_id_31,
  u1_.deleted_at AS deleted_at_32,
  u1_.created_at AS created_at_33,
  u1_.updated_at AS updated_at_34,
  c2_.id AS id_35,
  c2_.created_at AS created_at_36,
  c2_.updated_at AS updated_at_37,
  c2_.source AS source_38,
  c2_.name AS name_39,
  c2_.street AS street_40,
  c2_.housenumber AS housenumber_41,
  c2_.zipcode AS zipcode_42,
  c2_.city AS city_43,
  c2_.telephone AS telephone_44,
  c2_.fax AS fax_45,
  c2_.customernumber AS customernumber_46,
  c2_.ordernumber AS ordernumber_47,
  c2_.vatnumber AS vatnumber_48,
  c2_.couponcode AS couponcode_49,
  c2_.invoice AS invoice_50,
  c2_.invoice_street AS invoice_street_51,
  c2_.invoice_housenumber AS invoice_housenumber_52,
  c2_.invoice_zipcode AS invoice_zipcode_53,
  c2_.invoice_city AS invoice_city_54,
  c2_.license_product AS license_product_55,
  c2_.license_amount AS license_amount_56,
  c2_.license_price AS license_price_57,
  c2_.license_caption AS license_caption_58,
  c2_.license_starts_at AS license_starts_at_59,
  c2_.license_ends_at AS license_ends_at_60,
  c2_.license_trial AS license_trial_61,
  c2_.license_upgrade AS license_upgrade_62,
  c2_.license_testing AS license_testing_63,
  c2_.license_code AS license_code_64,
  c2_.license_type AS license_type_65,
  c2_.contractnumber AS contractnumber_66,
  c2_.remarks AS remarks_67,
  c2_.edit_token AS edit_token_68,
  c2_.migrated_id AS migrated_id_69,
  c2_.deleted_at AS deleted_at_70,
  c2_.logo_file_name AS logo_file_name_71,
  c2_.logo_file_original_name AS logo_file_original_name_72,
  c2_.logo_file_mime_type AS logo_file_mime_type_73,
  c2_.logo_file_size AS logo_file_size_74,
  c2_.logo_file_dimensions AS logo_file_dimensions_75,
  i0_.user_id AS user_id_76,
  u1_.company_id AS company_id_77
FROM
  ips i0_
  INNER JOIN users u1_ ON i0_.user_id = u1_.id
  AND (u1_.deleted_at IS NULL)
  INNER JOIN companies c2_ ON u1_.company_id = c2_.id
  AND (c2_.deleted_at IS NULL)
WHERE
  i0_.`from` <= 64442316
  AND i0_.`to` >= 64442316
LIMIT
  1

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.user_id AS user_id_3, i0_.`from` AS from_4, i0_.`to` AS to_5, u1_.id AS id_6, u1_.login_at AS login_at_7, u1_.password_at AS password_at_8, u1_.activation_at AS activation_at_9, u1_.username_at AS username_at_10, u1_.password_token AS password_token_11, u1_.password_token_created_at AS password_token_created_at_12, u1_.activation_token AS activation_token_13, u1_.username_token AS username_token_14, u1_.source AS source_15, u1_.role AS role_16, u1_.roles AS roles_17, u1_.company_id AS company_id_18, u1_.manager AS manager_19, u1_.username AS username_20, u1_.hash AS hash_21, u1_.name AS name_22, u1_.salutation AS salutation_23, u1_.firstname AS firstname_24, u1_.lastname_prefix AS lastname_prefix_25, u1_.lastname AS lastname_26, u1_.initials AS initials_27, u1_.sex AS sex_28, u1_.job AS job_29, u1_.username_change AS username_change_30, u1_.migrated_id AS migrated_id_31, u1_.deleted_at AS deleted_at_32, u1_.created_at AS created_at_33, u1_.updated_at AS updated_at_34, c2_.id AS id_35, c2_.created_at AS created_at_36, c2_.updated_at AS updated_at_37, c2_.source AS source_38, c2_.name AS name_39, c2_.street AS street_40, c2_.housenumber AS housenumber_41, c2_.zipcode AS zipcode_42, c2_.city AS city_43, c2_.telephone AS telephone_44, c2_.fax AS fax_45, c2_.customernumber AS customernumber_46, c2_.ordernumber AS ordernumber_47, c2_.vatnumber AS vatnumber_48, c2_.couponcode AS couponcode_49, c2_.invoice AS invoice_50, c2_.invoice_street AS invoice_street_51, c2_.invoice_housenumber AS invoice_housenumber_52, c2_.invoice_zipcode AS invoice_zipcode_53, c2_.invoice_city AS invoice_city_54, c2_.license_product AS license_product_55, c2_.license_amount AS license_amount_56, c2_.license_price AS license_price_57, c2_.license_caption AS license_caption_58, c2_.license_starts_at AS license_starts_at_59, c2_.license_ends_at AS license_ends_at_60, c2_.license_trial AS license_trial_61, c2_.license_upgrade AS license_upgrade_62, c2_.license_testing AS license_testing_63, c2_.license_code AS license_code_64, c2_.license_type AS license_type_65, c2_.contractnumber AS contractnumber_66, c2_.remarks AS remarks_67, c2_.edit_token AS edit_token_68, c2_.migrated_id AS migrated_id_69, c2_.deleted_at AS deleted_at_70, c2_.logo_file_name AS logo_file_name_71, c2_.logo_file_original_name AS logo_file_original_name_72, c2_.logo_file_mime_type AS logo_file_mime_type_73, c2_.logo_file_size AS logo_file_size_74, c2_.logo_file_dimensions AS logo_file_dimensions_75, i0_.user_id AS user_id_76, u1_.company_id AS company_id_77 FROM ips i0_ INNER JOIN users u1_ ON i0_.user_id = u1_.id AND (u1_.deleted_at IS NULL) INNER JOIN companies c2_ ON u1_.company_id = c2_.id AND (c2_.deleted_at IS NULL) WHERE i0_.`from` <= 64442316 AND i0_.`to` >= 64442316 LIMIT 1;

SELECT
  b0_.title AS title_0,
  b0_.description AS description_1,
  b0_.faqs AS faqs_2,
  b0_.about_title AS about_title_3,
  b0_.about_description AS about_description_4,
  b0_.tool AS tool_5,
  b0_.subscriptions AS subscriptions_6,
  b0_.id AS id_7,
  b0_.slug AS slug_8,
  b0_.datecreated AS datecreated_9,
  b0_.datechanged AS datechanged_10,
  b0_.datepublish AS datepublish_11,
  b0_.datedepublish AS datedepublish_12,
  b0_.ownerid AS ownerid_13,
  b0_.status AS status_14,
  b0_.templatefields AS templatefields_15,
  b0_.meta_title AS meta_title_16,
  b0_.meta_description AS meta_description_17,
  b1_.id AS id_18,
  b1_.content_id AS content_id_19,
  b1_.contenttype AS contenttype_20,
  b1_.taxonomytype AS taxonomytype_21,
  b1_.slug AS slug_22,
  b1_.name AS name_23,
  b1_.sortorder AS sortorder_24,
  b1_.content_id AS content_id_25,
  b1_.content_id AS content_id_26
FROM
  bolt_pages b0_
  INNER JOIN bolt_taxonomy b1_ ON b0_.id = b1_.content_id
WHERE
  (
    b1_.contenttype = ?
    AND b1_.taxonomytype = ?
    AND b1_.slug = ?
    AND b0_.slug = ?
  )
  AND (
    b0_.status IN ('published', 'timed')
    AND b0_.datepublish <= '2022-07-03 17:03:25'
    AND (
      b0_.datedepublish IS NULL
      OR b0_.datedepublish >= '2022-07-03 17:03:25'
    )
  )
ORDER BY
  b1_.sortorder ASC

SELECT b0_.title AS title_0, b0_.description AS description_1, b0_.faqs AS faqs_2, b0_.about_title AS about_title_3, b0_.about_description AS about_description_4, b0_.tool AS tool_5, b0_.subscriptions AS subscriptions_6, b0_.id AS id_7, b0_.slug AS slug_8, b0_.datecreated AS datecreated_9, b0_.datechanged AS datechanged_10, b0_.datepublish AS datepublish_11, b0_.datedepublish AS datedepublish_12, b0_.ownerid AS ownerid_13, b0_.status AS status_14, b0_.templatefields AS templatefields_15, b0_.meta_title AS meta_title_16, b0_.meta_description AS meta_description_17, b1_.id AS id_18, b1_.content_id AS content_id_19, b1_.contenttype AS contenttype_20, b1_.taxonomytype AS taxonomytype_21, b1_.slug AS slug_22, b1_.name AS name_23, b1_.sortorder AS sortorder_24, b1_.content_id AS content_id_25, b1_.content_id AS content_id_26 FROM bolt_pages b0_ INNER JOIN bolt_taxonomy b1_ ON b0_.id = b1_.content_id WHERE (b1_.contenttype = 'pages' AND b1_.taxonomytype = 'sections' AND b1_.slug = 'general-public' AND b0_.slug = 'abonnementen') AND (
            b0_.status IN ('published', 'timed')
            AND b0_.datepublish <= '2022-07-03 17:03:25'
            AND (b0_.datedepublish IS NULL OR b0_.datedepublish >= '2022-07-03 17:03:25')
        ) ORDER BY b1_.sortorder ASC;

SELECT
  b0_.block_type AS block_type_0,
  b0_.title AS title_1,
  b0_.block_title AS block_title_2,
  b0_.description AS description_3,
  b0_.button_text AS button_text_4,
  b0_.button_url AS button_url_5,
  b0_.button_function AS button_function_6,
  b0_.button_color AS button_color_7,
  b0_.button_type AS button_type_8,
  b0_.id AS id_9,
  b0_.slug AS slug_10,
  b0_.datecreated AS datecreated_11,
  b0_.datechanged AS datechanged_12,
  b0_.datepublish AS datepublish_13,
  b0_.datedepublish AS datedepublish_14,
  b0_.ownerid AS ownerid_15,
  b0_.status AS status_16,
  b0_.templatefields AS templatefields_17
FROM
  bolt_blocks b0_
  INNER JOIN bolt_field_value b1_ ON (
    b1_.contenttype = ?
    AND b1_.content_id = ?
    AND b1_.name = ?
    AND b1_.value_text = b0_.id
  )
WHERE
  (
    b0_.status IN ('published', 'timed')
    AND b0_.datepublish <= '2022-07-03 17:03:25'
    AND (
      b0_.datedepublish IS NULL
      OR b0_.datedepublish >= '2022-07-03 17:03:25'
    )
  )
ORDER BY
  b1_.grouping ASC

SELECT b0_.block_type AS block_type_0, b0_.title AS title_1, b0_.block_title AS block_title_2, b0_.description AS description_3, b0_.button_text AS button_text_4, b0_.button_url AS button_url_5, b0_.button_function AS button_function_6, b0_.button_color AS button_color_7, b0_.button_type AS button_type_8, b0_.id AS id_9, b0_.slug AS slug_10, b0_.datecreated AS datecreated_11, b0_.datechanged AS datechanged_12, b0_.datepublish AS datepublish_13, b0_.datedepublish AS datedepublish_14, b0_.ownerid AS ownerid_15, b0_.status AS status_16, b0_.templatefields AS templatefields_17 FROM bolt_blocks b0_ INNER JOIN bolt_field_value b1_ ON (b1_.contenttype = 'pages' AND b1_.content_id = 7 AND b1_.name = 'blocks' AND b1_.value_text = b0_.id) WHERE (
            b0_.status IN ('published', 'timed')
            AND b0_.datepublish <= '2022-07-03 17:03:25'
            AND (b0_.datedepublish IS NULL OR b0_.datedepublish >= '2022-07-03 17:03:25')
        ) ORDER BY b1_.grouping ASC;

SELECT
  b0_.slug AS slug_0,
  b0_.title AS title_1,
  b0_.subscriptions AS subscriptions_2
FROM
  bolt_pages b0_
  INNER JOIN bolt_field_value b1_ ON (
    b1_.contenttype = ?
    AND b1_.content_id = ?
    AND b1_.name = ?
    AND b1_.value_text = b0_.id
  )
WHERE
  (
    b0_.status IN ('published', 'timed')
    AND b0_.datepublish <= '2022-07-03 17:03:25'
    AND (
      b0_.datedepublish IS NULL
      OR b0_.datedepublish >= '2022-07-03 17:03:25'
    )
  )
ORDER BY
  b1_.grouping ASC

SELECT b0_.slug AS slug_0, b0_.title AS title_1, b0_.subscriptions AS subscriptions_2 FROM bolt_pages b0_ INNER JOIN bolt_field_value b1_ ON (b1_.contenttype = 'pages' AND b1_.content_id = 7 AND b1_.name = 'pages' AND b1_.value_text = b0_.id) WHERE (
            b0_.status IN ('published', 'timed')
            AND b0_.datepublish <= '2022-07-03 17:03:25'
            AND (b0_.datedepublish IS NULL OR b0_.datedepublish >= '2022-07-03 17:03:25')
        ) ORDER BY b1_.grouping ASC;

SELECT
  b0_.id AS id_0,
  b0_.contenttype AS contenttype_1,
  b0_.content_id AS content_id_2,
  b0_.name AS name_3,
  b0_.grouping AS grouping_4,
  b0_.block AS block_5,
  b0_.fieldname AS fieldname_6,
  b0_.fieldtype AS fieldtype_7,
  b0_.value_string AS value_string_8,
  b0_.value_text AS value_text_9,
  b0_.value_integer AS value_integer_10,
  b0_.value_float AS value_float_11,
  b0_.value_decimal AS value_decimal_12,
  b0_.value_date AS value_date_13,
  b0_.value_datetime AS value_datetime_14,
  b0_.value_json_array AS value_json_array_15,
  b0_.value_boolean AS value_boolean_16
FROM
  bolt_field_value b0_
WHERE
  b0_.contenttype = ?
  AND b0_.content_id = ?
  AND b0_.name IN ('extra_sections')
ORDER BY
  b0_.grouping ASC

SELECT b0_.id AS id_0, b0_.contenttype AS contenttype_1, b0_.content_id AS content_id_2, b0_.name AS name_3, b0_.grouping AS grouping_4, b0_.block AS block_5, b0_.fieldname AS fieldname_6, b0_.fieldtype AS fieldtype_7, b0_.value_string AS value_string_8, b0_.value_text AS value_text_9, b0_.value_integer AS value_integer_10, b0_.value_float AS value_float_11, b0_.value_decimal AS value_decimal_12, b0_.value_date AS value_date_13, b0_.value_datetime AS value_datetime_14, b0_.value_json_array AS value_json_array_15, b0_.value_boolean AS value_boolean_16 FROM bolt_field_value b0_ WHERE b0_.contenttype = 'pages' AND b0_.content_id = 7 AND b0_.name IN ('extra_sections') ORDER BY b0_.grouping ASC;

SELECT
  t0.titel AS titel_1,
  t0.button_text AS button_text_2,
  t0.most_chosen AS most_chosen_3,
  t0.benefits AS benefits_4,
  t0.more_info_link AS more_info_link_5,
  t0.conditions_short AS conditions_short_6,
  t0.conditions AS conditions_7,
  t0.sorting AS sorting_8,
  t0.user_1 AS user_1_9,
  t0.user_2 AS user_2_10,
  t0.user_3 AS user_3_11,
  t0.user_4 AS user_4_12,
  t0.user_5 AS user_5_13,
  t0.user_amount_1 AS user_amount_1_14,
  t0.user_amount_2 AS user_amount_2_15,
  t0.user_amount_3 AS user_amount_3_16,
  t0.user_amount_4 AS user_amount_4_17,
  t0.user_amount_5 AS user_amount_5_18,
  t0.user_duration_1 AS user_duration_1_19,
  t0.user_duration_2 AS user_duration_2_20,
  t0.user_duration_3 AS user_duration_3_21,
  t0.user_duration_4 AS user_duration_4_22,
  t0.user_duration_5 AS user_duration_5_23,
  t0.user_description_1 AS user_description_1_24,
  t0.user_description_2 AS user_description_2_25,
  t0.user_description_3 AS user_description_3_26,
  t0.user_description_4 AS user_description_4_27,
  t0.user_description_5 AS user_description_5_28,
  t0.convert_subscription AS convert_subscription_29,
  t0.trial AS trial_30,
  t0.trial_duration AS trial_duration_31,
  t0.id AS id_32,
  t0.slug AS slug_33,
  t0.datecreated AS datecreated_34,
  t0.datechanged AS datechanged_35,
  t0.datepublish AS datepublish_36,
  t0.datedepublish AS datedepublish_37,
  t0.ownerid AS ownerid_38,
  t0.status AS status_39,
  t0.templatefields AS templatefields_40
FROM
  bolt_subscriptions t0
WHERE
  (
    (
      t0.status IN ('published', 'timed')
      AND t0.datepublish <= '2022-07-03 17:03:25'
      AND (
        t0.datedepublish IS NULL
        OR t0.datedepublish >= '2022-07-03 17:03:25'
      )
    )
  )
ORDER BY
  t0.sorting ASC

SELECT t0.titel AS titel_1, t0.button_text AS button_text_2, t0.most_chosen AS most_chosen_3, t0.benefits AS benefits_4, t0.more_info_link AS more_info_link_5, t0.conditions_short AS conditions_short_6, t0.conditions AS conditions_7, t0.sorting AS sorting_8, t0.user_1 AS user_1_9, t0.user_2 AS user_2_10, t0.user_3 AS user_3_11, t0.user_4 AS user_4_12, t0.user_5 AS user_5_13, t0.user_amount_1 AS user_amount_1_14, t0.user_amount_2 AS user_amount_2_15, t0.user_amount_3 AS user_amount_3_16, t0.user_amount_4 AS user_amount_4_17, t0.user_amount_5 AS user_amount_5_18, t0.user_duration_1 AS user_duration_1_19, t0.user_duration_2 AS user_duration_2_20, t0.user_duration_3 AS user_duration_3_21, t0.user_duration_4 AS user_duration_4_22, t0.user_duration_5 AS user_duration_5_23, t0.user_description_1 AS user_description_1_24, t0.user_description_2 AS user_description_2_25, t0.user_description_3 AS user_description_3_26, t0.user_description_4 AS user_description_4_27, t0.user_description_5 AS user_description_5_28, t0.convert_subscription AS convert_subscription_29, t0.trial AS trial_30, t0.trial_duration AS trial_duration_31, t0.id AS id_32, t0.slug AS slug_33, t0.datecreated AS datecreated_34, t0.datechanged AS datechanged_35, t0.datepublish AS datepublish_36, t0.datedepublish AS datedepublish_37, t0.ownerid AS ownerid_38, t0.status AS status_39, t0.templatefields AS templatefields_40 FROM bolt_subscriptions t0 WHERE ((
            t0.status IN ('published', 'timed')
            AND t0.datepublish <= '2022-07-03 17:03:25'
            AND (t0.datedepublish IS NULL OR t0.datedepublish >= '2022-07-03 17:03:25')
        )) ORDER BY t0.sorting ASC;

SELECT
  t0.title AS title_1,
  t0.javascript_head AS javascript_head_2,
  t0.javascript_body_start AS javascript_body_start_3,
  t0.javascript_body_end AS javascript_body_end_4,
  t0.contact_send_from AS contact_send_from_5,
  t0.contact_send_from_name AS contact_send_from_name_6,
  t0.contact_name AS contact_name_7,
  t0.contact_address AS contact_address_8,
  t0.contact_zipcode AS contact_zipcode_9,
  t0.contact_city AS contact_city_10,
  t0.contact_phone AS contact_phone_11,
  t0.contact_email AS contact_email_12,
  t0.contact_website AS contact_website_13,
  t0.contact_hours AS contact_hours_14,
  t0.privacy_statement AS privacy_statement_15,
  t0.disclaimer AS disclaimer_16,
  t0.terms_and_conditions AS terms_and_conditions_17,
  t0.notice_text AS notice_text_18,
  t0.notice_button_text AS notice_button_text_19,
  t0.notice_button_url AS notice_button_url_20,
  t0.publication_xslt AS publication_xslt_21,
  t0.product_logo AS product_logo_22,
  t0.invite_content AS invite_content_23,
  t0.invite_message AS invite_message_24,
  t0.reminder_content AS reminder_content_25,
  t0.reminder_message AS reminder_message_26,
  t0.id AS id_27,
  t0.slug AS slug_28,
  t0.datecreated AS datecreated_29,
  t0.datechanged AS datechanged_30,
  t0.datepublish AS datepublish_31,
  t0.datedepublish AS datedepublish_32,
  t0.ownerid AS ownerid_33,
  t0.status AS status_34,
  t0.templatefields AS templatefields_35,
  t0.meta_title AS meta_title_36,
  t0.meta_description AS meta_description_37
FROM
  bolt_settings t0
WHERE
  (
    (
      t0.status IN ('published', 'timed')
      AND t0.datepublish <= '2022-07-03 17:03:25'
      AND (
        t0.datedepublish IS NULL
        OR t0.datedepublish >= '2022-07-03 17:03:25'
      )
    )
  )
LIMIT
  1

SELECT t0.title AS title_1, t0.javascript_head AS javascript_head_2, t0.javascript_body_start AS javascript_body_start_3, t0.javascript_body_end AS javascript_body_end_4, t0.contact_send_from AS contact_send_from_5, t0.contact_send_from_name AS contact_send_from_name_6, t0.contact_name AS contact_name_7, t0.contact_address AS contact_address_8, t0.contact_zipcode AS contact_zipcode_9, t0.contact_city AS contact_city_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.contact_website AS contact_website_13, t0.contact_hours AS contact_hours_14, t0.privacy_statement AS privacy_statement_15, t0.disclaimer AS disclaimer_16, t0.terms_and_conditions AS terms_and_conditions_17, t0.notice_text AS notice_text_18, t0.notice_button_text AS notice_button_text_19, t0.notice_button_url AS notice_button_url_20, t0.publication_xslt AS publication_xslt_21, t0.product_logo AS product_logo_22, t0.invite_content AS invite_content_23, t0.invite_message AS invite_message_24, t0.reminder_content AS reminder_content_25, t0.reminder_message AS reminder_message_26, t0.id AS id_27, t0.slug AS slug_28, t0.datecreated AS datecreated_29, t0.datechanged AS datechanged_30, t0.datepublish AS datepublish_31, t0.datedepublish AS datedepublish_32, t0.ownerid AS ownerid_33, t0.status AS status_34, t0.templatefields AS templatefields_35, t0.meta_title AS meta_title_36, t0.meta_description AS meta_description_37 FROM bolt_settings t0 WHERE ((
            t0.status IN ('published', 'timed')
            AND t0.datepublish <= '2022-07-03 17:03:25'
            AND (t0.datedepublish IS NULL OR t0.datedepublish >= '2022-07-03 17:03:25')
        )) LIMIT 1;

SELECT
  b0_.title AS title_0,
  b0_.html AS html_1,
  b0_.id AS id_2,
  b0_.slug AS slug_3,
  b0_.datecreated AS datecreated_4,
  b0_.datechanged AS datechanged_5,
  b0_.datepublish AS datepublish_6,
  b0_.datedepublish AS datedepublish_7,
  b0_.ownerid AS ownerid_8,
  b0_.status AS status_9,
  b0_.templatefields AS templatefields_10
FROM
  bolt_snippets b0_
WHERE
  (
    b0_.status IN ('published', 'timed')
    AND b0_.datepublish <= '2022-07-03 17:03:25'
    AND (
      b0_.datedepublish IS NULL
      OR b0_.datedepublish >= '2022-07-03 17:03:25'
    )
  )

SELECT b0_.title AS title_0, b0_.html AS html_1, b0_.id AS id_2, b0_.slug AS slug_3, b0_.datecreated AS datecreated_4, b0_.datechanged AS datechanged_5, b0_.datepublish AS datepublish_6, b0_.datedepublish AS datedepublish_7, b0_.ownerid AS ownerid_8, b0_.status AS status_9, b0_.templatefields AS templatefields_10 FROM bolt_snippets b0_ WHERE (
            b0_.status IN ('published', 'timed')
            AND b0_.datepublish <= '2022-07-03 17:03:25'
            AND (b0_.datedepublish IS NULL OR b0_.datedepublish >= '2022-07-03 17:03:25')
        );