SELECT 
  t0.id AS id_1, 
  t0.post_title AS post_title_2, 
  t0.post_body AS post_body_3, 
  t0.post_slug AS post_slug_4, 
  t0.created_on AS created_on_5, 
  t0.updated_on AS updated_on_6, 
  t0.is_publish AS is_publish_7, 
  t0.post_robots AS post_robots_8, 
  t0.post_meta AS post_meta_9, 
  t0.views AS views_10, 
  t0.category_id AS category_id_11, 
  t0.user_id AS user_id_12, 
  t0.image_id AS image_id_13 
FROM 
  blog_post t0 
WHERE 
  t0.post_slug = ?

SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_body AS post_body_3, t0.post_slug AS post_slug_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.is_publish AS is_publish_7, t0.post_robots AS post_robots_8, t0.post_meta AS post_meta_9, t0.views AS views_10, t0.category_id AS category_id_11, t0.user_id AS user_id_12, t0.image_id AS image_id_13 FROM blog_post t0 WHERE t0.post_slug = 'the-benefits-of-email-marketing-for-bands';

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  blog_post 
SET 
  views = ?, 
  updated_on = ? 
WHERE 
  id = ?

UPDATE blog_post SET views = 24673, updated_on = '2025-06-12 04:33:39' WHERE id = 100;

"COMMIT"

"COMMIT";

SELECT 
  b0_.id AS id_0, 
  b0_.post_title AS post_title_1, 
  b0_.post_body AS post_body_2, 
  b0_.post_slug AS post_slug_3, 
  b0_.created_on AS created_on_4, 
  b0_.updated_on AS updated_on_5, 
  b0_.is_publish AS is_publish_6, 
  b0_.post_robots AS post_robots_7, 
  b0_.post_meta AS post_meta_8, 
  b0_.views AS views_9, 
  b1_.id AS id_10, 
  b1_.category_name AS category_name_11, 
  b1_.category_slug AS category_slug_12, 
  b1_.post_robots AS post_robots_13, 
  b2_.id AS id_14, 
  b2_.name AS name_15, 
  b2_.email AS email_16, 
  b2_.url AS url_17, 
  b2_.commentText AS commentText_18, 
  b2_.insert_date AS insert_date_19, 
  b0_.category_id AS category_id_20, 
  b0_.user_id AS user_id_21, 
  b0_.image_id AS image_id_22 
FROM 
  blog_post b0_ 
  LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id 
  LEFT JOIN blogpostcomment_blogpost b3_ ON b0_.id = b3_.blogpost_id 
  LEFT JOIN blog_post_comments b2_ ON b2_.id = b3_.blogpostcomment_id 
WHERE 
  b0_.is_publish = ? 
  AND b0_.post_slug = ? 
ORDER BY 
  b0_.views DESC

SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b2_.id AS id_14, b2_.name AS name_15, b2_.email AS email_16, b2_.url AS url_17, b2_.commentText AS commentText_18, b2_.insert_date AS insert_date_19, b0_.category_id AS category_id_20, b0_.user_id AS user_id_21, b0_.image_id AS image_id_22 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id LEFT JOIN blogpostcomment_blogpost b3_ ON b0_.id = b3_.blogpost_id LEFT JOIN blog_post_comments b2_ ON b2_.id = b3_.blogpostcomment_id WHERE b0_.is_publish = 1 AND b0_.post_slug = 'the-benefits-of-email-marketing-for-bands' ORDER BY b0_.views DESC;

SELECT 
  b0_.id AS id_0, 
  b0_.post_title AS post_title_1, 
  b0_.post_body AS post_body_2, 
  b0_.post_slug AS post_slug_3, 
  b0_.created_on AS created_on_4, 
  b0_.updated_on AS updated_on_5, 
  b0_.is_publish AS is_publish_6, 
  b0_.post_robots AS post_robots_7, 
  b0_.post_meta AS post_meta_8, 
  b0_.views AS views_9, 
  b1_.id AS id_10, 
  b1_.category_name AS category_name_11, 
  b1_.category_slug AS category_slug_12, 
  b1_.post_robots AS post_robots_13, 
  b0_.category_id AS category_id_14, 
  b0_.user_id AS user_id_15, 
  b0_.image_id AS image_id_16 
FROM 
  blog_post b0_ 
  LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id 
WHERE 
  b0_.is_publish = ? 
  AND b0_.id <> ? 
ORDER BY 
  b0_.created_on DESC 
LIMIT 
  3

SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b0_.category_id AS category_id_14, b0_.user_id AS user_id_15, b0_.image_id AS image_id_16 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b0_.is_publish = 1 AND b0_.id <> 100 ORDER BY b0_.created_on DESC LIMIT 3;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 136;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 150;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 157;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 148;

SELECT 
  b0_.id AS id_0, 
  b0_.post_title AS post_title_1, 
  b0_.post_body AS post_body_2, 
  b0_.post_slug AS post_slug_3, 
  b0_.created_on AS created_on_4, 
  b0_.updated_on AS updated_on_5, 
  b0_.is_publish AS is_publish_6, 
  b0_.post_robots AS post_robots_7, 
  b0_.post_meta AS post_meta_8, 
  b0_.views AS views_9, 
  b1_.id AS id_10, 
  b1_.category_name AS category_name_11, 
  b1_.category_slug AS category_slug_12, 
  b1_.post_robots AS post_robots_13, 
  b0_.category_id AS category_id_14, 
  b0_.user_id AS user_id_15, 
  b0_.image_id AS image_id_16 
FROM 
  blog_post b0_ 
  LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id 
WHERE 
  b0_.is_publish = ? 
ORDER BY 
  b0_.views DESC 
LIMIT 
  5

SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b0_.category_id AS category_id_14, b0_.user_id AS user_id_15, b0_.image_id AS image_id_16 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b0_.is_publish = 1 ORDER BY b0_.views DESC LIMIT 5;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 26;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 13;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 22;

SELECT 
  b0_.id AS id_0, 
  b0_.post_title AS post_title_1, 
  b0_.post_body AS post_body_2, 
  b0_.post_slug AS post_slug_3, 
  b0_.created_on AS created_on_4, 
  b0_.updated_on AS updated_on_5, 
  b0_.is_publish AS is_publish_6, 
  b0_.post_robots AS post_robots_7, 
  b0_.post_meta AS post_meta_8, 
  b0_.views AS views_9, 
  b1_.id AS id_10, 
  b1_.category_name AS category_name_11, 
  b1_.category_slug AS category_slug_12, 
  b1_.post_robots AS post_robots_13, 
  b0_.category_id AS category_id_14, 
  b0_.user_id AS user_id_15, 
  b0_.image_id AS image_id_16 
FROM 
  blog_post b0_ 
  LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id 
WHERE 
  b0_.is_publish = ? 
ORDER BY 
  b0_.created_on DESC 
LIMIT 
  5

SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b0_.category_id AS category_id_14, b0_.user_id AS user_id_15, b0_.image_id AS image_id_16 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b0_.is_publish = 1 ORDER BY b0_.created_on DESC LIMIT 5;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 147;

SELECT 
  t0.id AS id_1, 
  t0.file_name AS file_name_2, 
  t0.mime_type AS mime_type_3, 
  t0.original_name AS original_name_4, 
  t0.data AS data_5, 
  t0.post_id AS post_id_6 
FROM 
  blog_post_images t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = 146;

SELECT 
  t0.id AS id_1, 
  t0.category_name AS category_name_2, 
  t0.category_slug AS category_slug_3, 
  t0.post_robots AS post_robots_4 
FROM 
  blog_post_category t0

SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_slug AS category_slug_3, t0.post_robots AS post_robots_4 FROM blog_post_category t0;