1 | SHOW FULL COLUMNS FROM `users` | | 12 | 12 | 0 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci'; | | 1 | 1 | 0 |
3 | SHOW FULL COLUMNS FROM `partners` | | 16 | 16 | 0 |
4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
5 | SHOW FULL COLUMNS FROM `memberinfos` | | 41 | 41 | 0 |
6 | SHOW FULL COLUMNS FROM `ranks` | | 2 | 2 | 0 |
7 | SHOW FULL COLUMNS FROM `paymentmethods` | | 4 | 4 | 0 |
8 | SHOW FULL COLUMNS FROM `membercars` | | 17 | 17 | 0 |
9 | SHOW FULL COLUMNS FROM `fueltypes` | | 4 | 4 | 0 |
10 | SHOW FULL COLUMNS FROM `transmissions` | | 4 | 4 | 1 |
11 | SHOW FULL COLUMNS FROM `axles` | | 4 | 4 | 1 |
12 | SHOW FULL COLUMNS FROM `vipcards` | | 8 | 8 | 1 |
13 | SHOW FULL COLUMNS FROM `menuitems` | | 13 | 13 | 0 |
14 | SHOW FULL COLUMNS FROM `menus` | | 5 | 5 | 1 |
15 | SHOW FULL COLUMNS FROM `categories` | | 10 | 10 | 1 |
16 | SHOW FULL COLUMNS FROM `settings` | | 5 | 5 | 1 |
17 | SELECT `Setting`.`title`, `Setting`.`content` FROM `settings` AS `Setting` WHERE 1 = 1 | | 1 | 1 | 0 |
18 | SHOW FULL COLUMNS FROM `pages` | | 16 | 16 | 1 |
19 | SHOW FULL COLUMNS FROM `attachments` | | 7 | 7 | 1 |
20 | SHOW FULL COLUMNS FROM `attachments_pages` | | 3 | 3 | 1 |
21 | SELECT `Page`.`id`, `Page`.`content`, `Page`.`highlight_content`, `Page`.`highlight_url`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) WHERE `Page`.`is_highlight` = 1 AND `Page`.`status` != 3 ORDER BY `Page`.`modified` desc | | 8 | 8 | 1 |
22 | SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`saved_name`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`created`, `Attachment`.`modified`, `AttachmentsPage`.`id`, `AttachmentsPage`.`page_id`, `AttachmentsPage`.`attachment_id` FROM `attachments` AS `Attachment` JOIN `attachments_pages` AS `AttachmentsPage` ON (`AttachmentsPage`.`page_id` IN (274, 257, 261, 258, 256, 198, 195, 197) AND `AttachmentsPage`.`attachment_id` = `Attachment`.`id`) | | 0 | 0 | 0 |
23 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`title`, `Menuitem`.`url`, `Menuitem`.`parent_id`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`status`, `Menuitem`.`emph`, `Menuitem`.`is_category_list`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `menuitems` AS `Menuitem` LEFT JOIN `menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) WHERE `Menuitem`.`menu_id` = 2 AND `Menuitem`.`status` != 3 ORDER BY `Menuitem`.`sort` asc | | 8 | 8 | 1 |
24 | SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`parent_id`, `Category`.`show_in_menu`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Category`.`id_old` FROM `categories` AS `Category` WHERE `Category`.`status` != 3 AND `Category`.`show_in_menu` = 1 | | 5 | 5 | 0 |
25 | SHOW FULL COLUMNS FROM `adpositions` | | 9 | 9 | 1 |
26 | SHOW FULL COLUMNS FROM `advertisements` | | 13 | 13 | 1 |
27 | SELECT `Adposition`.`id`, `Adposition`.`title`, `Adposition`.`comment`, `Adposition`.`position_width`, `Adposition`.`position_height`, `Adposition`.`ad_width`, `Adposition`.`ad_height`, `Adposition`.`visible_ads_count`, `Adposition`.`status` FROM `adpositions` AS `Adposition` WHERE `Adposition`.`status` = 1 | | 2 | 2 | 0 |
28 | SELECT `Advertisement`.`id`, `Advertisement`.`adposition_id`, `Advertisement`.`partner_id`, `Advertisement`.`valid_from`, `Advertisement`.`valid_to`, `Advertisement`.`saved_filename`, `Advertisement`.`alt`, `Advertisement`.`url`, `Advertisement`.`status`, `Advertisement`.`display_count`, `Advertisement`.`click_count`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`valid_from` <= '2024-12-21 15:20:30' AND `Advertisement`.`valid_to` >= '2024-12-21 15:20:30' AND `Advertisement`.`status` = 1 AND `Advertisement`.`adposition_id` IN (4, 5) ORDER BY RAND() ASC | | 0 | 0 | 1 |
29 | UPDATE `advertisements` AS `Advertisement` LEFT JOIN `adpositions` AS `Adposition` ON (`Advertisement`.`adposition_id` = `Adposition`.`id`) SET `Advertisement`.`display_count` = Advertisement.display_count + 1 WHERE `Advertisement`.`id` IS NULL | | 0 | | 0 |
30 | SELECT `Memberinfo`.`id`, `Memberinfo`.`ocskid`, `Memberinfo`.`user_id`, `Memberinfo`.`street`, `Memberinfo`.`city`, `Memberinfo`.`zip`, `Memberinfo`.`phone`, `Memberinfo`.`payment_month`, `Memberinfo`.`last_payment_date`, `Memberinfo`.`membership_valid_until`, `Memberinfo`.`icq`, `Memberinfo`.`skype`, `Memberinfo`.`facebook`, `Memberinfo`.`twitter`, `Memberinfo`.`youtube`, `Memberinfo`.`aboutme`, `Memberinfo`.`occupation`, `Memberinfo`.`public_street`, `Memberinfo`.`public_city`, `Memberinfo`.`public_zip`, `Memberinfo`.`public_phone`, `Memberinfo`.`public_icq`, `Memberinfo`.`public_skype`, `Memberinfo`.`public_facebook`, `Memberinfo`.`public_twitter`, `Memberinfo`.`public_youtube`, `Memberinfo`.`public_aboutme`, `Memberinfo`.`public_occupation`, `Memberinfo`.`public_email`, `Memberinfo`.`avatar_filename`, `Memberinfo`.`car_image_filename`, `Memberinfo`.`car_name`, `Memberinfo`.`note`, `Memberinfo`.`recommended_by`, `Memberinfo`.`paymentmethod_id`, `Memberinfo`.`rank_id`, `Memberinfo`.`status`, `Memberinfo`.`ztp`, `Memberinfo`.`registered`, `Memberinfo`.`created`, `Memberinfo`.`modified`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified`, `Rank`.`id`, `Rank`.`title`, `Paymentmethod`.`id`, `Paymentmethod`.`title`, `Paymentmethod`.`created`, `Paymentmethod`.`modified` FROM `memberinfos` AS `Memberinfo` LEFT JOIN `users` AS `User` ON (`Memberinfo`.`user_id` = `User`.`id`) LEFT JOIN `ranks` AS `Rank` ON (`Memberinfo`.`rank_id` = `Rank`.`id`) LEFT JOIN `paymentmethods` AS `Paymentmethod` ON (`Memberinfo`.`paymentmethod_id` = `Paymentmethod`.`id`) WHERE `Memberinfo`.`id` = 2098 LIMIT 1 | | 1 | 1 | 1 |
31 | SELECT `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified` FROM `users` AS `User` WHERE `User`.`id` = 11451 | | 1 | 1 | 0 |
32 | SELECT `Rank`.`id`, `Rank`.`title` FROM `ranks` AS `Rank` WHERE `Rank`.`id` = 6 | | 1 | 1 | 0 |
33 | SELECT `Paymentmethod`.`id`, `Paymentmethod`.`title`, `Paymentmethod`.`created`, `Paymentmethod`.`modified` FROM `paymentmethods` AS `Paymentmethod` WHERE `Paymentmethod`.`id` = 2 | | 1 | 1 | 0 |
34 | SELECT `Membercar`.`id`, `Membercar`.`memberinfo_id`, `Membercar`.`title`, `Membercar`.`manufactured_year`, `Membercar`.`engine`, `Membercar`.`power`, `Membercar`.`fueltype_id`, `Membercar`.`cylinder_count`, `Membercar`.`transmission_id`, `Membercar`.`axle_id`, `Membercar`.`consumption`, `Membercar`.`weight`, `Membercar`.`top_speed`, `Membercar`.`acceleration`, `Membercar`.`equipment`, `Membercar`.`created`, `Membercar`.`modified` FROM `membercars` AS `Membercar` WHERE `Membercar`.`memberinfo_id` = (2098) | | 1 | 1 | 0 |
35 | SELECT `Vipcard`.`id`, `Vipcard`.`memberinfo_id`, `Vipcard`.`cardno`, `Vipcard`.`cvv`, `Vipcard`.`expiry`, `Vipcard`.`blocked`, `Vipcard`.`created`, `Vipcard`.`modified` FROM `vipcards` AS `Vipcard` WHERE `Vipcard`.`memberinfo_id` = (2098) | | 1 | 1 | 0 |
36 | SELECT `Memberinfo`.`id`, `Memberinfo`.`ocskid`, `Memberinfo`.`user_id`, `Memberinfo`.`street`, `Memberinfo`.`city`, `Memberinfo`.`zip`, `Memberinfo`.`phone`, `Memberinfo`.`payment_month`, `Memberinfo`.`last_payment_date`, `Memberinfo`.`membership_valid_until`, `Memberinfo`.`icq`, `Memberinfo`.`skype`, `Memberinfo`.`facebook`, `Memberinfo`.`twitter`, `Memberinfo`.`youtube`, `Memberinfo`.`aboutme`, `Memberinfo`.`occupation`, `Memberinfo`.`public_street`, `Memberinfo`.`public_city`, `Memberinfo`.`public_zip`, `Memberinfo`.`public_phone`, `Memberinfo`.`public_icq`, `Memberinfo`.`public_skype`, `Memberinfo`.`public_facebook`, `Memberinfo`.`public_twitter`, `Memberinfo`.`public_youtube`, `Memberinfo`.`public_aboutme`, `Memberinfo`.`public_occupation`, `Memberinfo`.`public_email`, `Memberinfo`.`avatar_filename`, `Memberinfo`.`car_image_filename`, `Memberinfo`.`car_name`, `Memberinfo`.`note`, `Memberinfo`.`recommended_by`, `Memberinfo`.`paymentmethod_id`, `Memberinfo`.`rank_id`, `Memberinfo`.`status`, `Memberinfo`.`ztp`, `Memberinfo`.`registered`, `Memberinfo`.`created`, `Memberinfo`.`modified` FROM `memberinfos` AS `Memberinfo` WHERE `Memberinfo`.`id` = 2098 | | 1 | 1 | 0 |
37 | SHOW FULL COLUMNS FROM `galleries` | | 6 | 6 | 0 |
38 | SHOW FULL COLUMNS FROM `pictures` | | 10 | 10 | 0 |
39 | SELECT `Gallery`.`id`, `Gallery`.`user_id`, `Gallery`.`status`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`modified`, `User`.`id`, `User`.`user`, `User`.`password`, `User`.`pwd_old`, `User`.`status`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`admin`, `User`.`partner_id`, `User`.`created`, `User`.`modified` FROM `galleries` AS `Gallery` LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) WHERE `Gallery`.`user_id` = 11451 AND `Gallery`.`status` = 1 | | 0 | 0 | 0 |