Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`ip`, `Post`.`display_date`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`shipping_name`, `User`.`address`, `User`.`city`, `User`.`state_id`, `User`.`zip`, `User`.`swag`, `User`.`group_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`allow_comment`, `PostType`.`created`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`created` FROM `focusgroup`.`posts` AS `Post` LEFT JOIN `focusgroup`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `focusgroup`.`post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `focusgroup`.`user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) LEFT JOIN `focusgroup`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`id` = 1896 AND `Post`.`publish` = '1' AND `Post`.`public` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `PostComment`.`id`, `PostComment`.`post_id`, `PostComment`.`user_id`, `PostComment`.`text`, `PostComment`.`publish`, `PostComment`.`ip`, `PostComment`.`created` FROM `focusgroup`.`post_comments` AS `PostComment` WHERE `PostComment`.`post_id` = (1896) ORDER BY `PostComment`.`created` ASC | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`ip`, `Post`.`display_date`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`shipping_name`, `User`.`address`, `User`.`city`, `User`.`state_id`, `User`.`zip`, `User`.`swag`, `User`.`group_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`allow_comment`, `PostType`.`created`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`created` FROM `focusgroup`.`posts` AS `Post` LEFT JOIN `focusgroup`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `focusgroup`.`post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `focusgroup`.`user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) LEFT JOIN `focusgroup`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`created` < '2024-07-31 22:56:00' AND `Post`.`publish` = '1' AND `Post`.`public` = '1' AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`created` desc LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`ip`, `Post`.`display_date`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`shipping_name`, `User`.`address`, `User`.`city`, `User`.`state_id`, `User`.`zip`, `User`.`swag`, `User`.`group_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`allow_comment`, `PostType`.`created`, `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`created` FROM `focusgroup`.`posts` AS `Post` LEFT JOIN `focusgroup`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `focusgroup`.`post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `focusgroup`.`user_files` AS `UserFile` ON (`Post`.`user_file_id` = `UserFile`.`id`) LEFT JOIN `focusgroup`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`created` > '2024-07-31 22:56:00' AND `Post`.`publish` = '1' AND `Post`.`public` = '1' AND `Post`.`post_type_id` = 1 ORDER BY `Post`.`created` asc LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `PostType`.`id`, `PostType`.`name`, `PostType`.`allow_comment`, `PostType`.`created` FROM `focusgroup`.`post_types` AS `PostType` WHERE 1 = 1 | 3 | 3 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE 1 = 1 | 15 | 15 | 0 | |
SELECT `Banner`.`id`, `Banner`.`ad_space_id`, `Banner`.`href1`, `Banner`.`href2`, `Banner`.`href3`, `Banner`.`href4`, `Banner`.`href5`, `Banner`.`user_file_id`, `Banner`.`alt_user_file_id`, `Banner`.`alt`, `Banner`.`impressions`, `Banner`.`clicks`, `Banner`.`active`, `Banner`.`display_order`, `Banner`.`last_shown`, `Banner`.`frequency`, `Banner`.`clicktag_string`, `Banner`.`impression_url1`, `Banner`.`impression_url2`, `Banner`.`impression_url3`, `Banner`.`add_html`, `Banner`.`created`, `Banner`.`modified` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`active` = 1 AND `Banner`.`ad_space_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `Banner`.`display_order` asc | 7 | 7 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 13 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 12 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 9 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 4 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 12 | 1 | 1 | 0 | |
SELECT `AdSpace`.`id`, `AdSpace`.`name` FROM `focusgroup`.`ad_spaces` AS `AdSpace` WHERE `AdSpace`.`id` = 6 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 818 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 944 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 854 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 738 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 738 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 854 | 1 | 1 | 0 | |
SELECT `UserFile`.`id`, `UserFile`.`user_id`, `UserFile`.`title`, `UserFile`.`description`, `UserFile`.`type`, `UserFile`.`size`, `UserFile`.`file_ext`, `UserFile`.`media_type`, `UserFile`.`original_file_name`, `UserFile`.`width`, `UserFile`.`height`, `UserFile`.`playtime_string`, `UserFile`.`sort_order`, `UserFile`.`hit_count`, `UserFile`.`created`, `UserFile`.`modified` FROM `focusgroup`.`user_files` AS `UserFile` WHERE `UserFile`.`id` = 818 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 818 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 951 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 854 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 738 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 738 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 854 | 1 | 1 | 0 | |
SELECT `AltUserFile`.`id`, `AltUserFile`.`user_id`, `AltUserFile`.`title`, `AltUserFile`.`description`, `AltUserFile`.`type`, `AltUserFile`.`size`, `AltUserFile`.`file_ext`, `AltUserFile`.`media_type`, `AltUserFile`.`original_file_name`, `AltUserFile`.`width`, `AltUserFile`.`height`, `AltUserFile`.`playtime_string`, `AltUserFile`.`sort_order`, `AltUserFile`.`hit_count`, `AltUserFile`.`created`, `AltUserFile`.`modified` FROM `focusgroup`.`user_files` AS `AltUserFile` WHERE `AltUserFile`.`id` = 818 | 1 | 1 | 0 | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 1 | 1 | 1 | 3 | maybe slow |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 4 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 4 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 4 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 4, `last_shown` = 1, `impressions` = 21871879, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '4' | 1 | 1 | 0 | |
COMMIT | | | | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 4 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 96 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 96 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 96 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 96, `last_shown` = 1, `impressions` = 21333450, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '96' | 1 | 1 | 0 | |
COMMIT | | | | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 6 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 99 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 99 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 99 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 99, `last_shown` = 1, `impressions` = 21167104, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '99' | 1 | 1 | 0 | |
COMMIT | | | | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 9 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 95 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 95 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 95 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 95, `last_shown` = 1, `impressions` = 21282219, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '95' | 1 | 1 | 0 | |
COMMIT | | | | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 12 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 82 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 82 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 82 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 82, `last_shown` = 1, `impressions` = 10869721, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '82' | 1 | 1 | 0 | |
COMMIT | | | | |
UPDATE banners SET last_shown = 0 WHERE ad_space_id = 13 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 114 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 114 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `focusgroup`.`banners` AS `Banner` WHERE `Banner`.`id` = 114 | 1 | 1 | 0 | |
UPDATE `focusgroup`.`banners` SET `id` = 114, `last_shown` = 1, `impressions` = 20561475, `modified` = '2024-10-13 12:26:10' WHERE `focusgroup`.`banners`.`id` = '114' | 1 | 1 | 0 | |
COMMIT | | | | |