1 | SHOW FULL COLUMNS FROM `pages` | | 20 | 20 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 4 |
3 | SELECT `Page`.`id`, `Page`.`page_id`, `Page`.`name`, `Page`.`slug`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`content`, `Page`.`header_image`, `Page`.`menu_image`, `Page`.`display_order`, `Page`.`active`, `Page`.`is_top_menu`, `Page`.`is_show_on_footer`, `Page`.`list_item_id`, `Page`.`slider`, `Page`.`lft`, `Page`.`rght`, `Page`.`created`, `Page`.`modified`, `ParentPage`.`id`, `ParentPage`.`page_id`, `ParentPage`.`name`, `ParentPage`.`slug`, `ParentPage`.`meta_title`, `ParentPage`.`meta_keywords`, `ParentPage`.`meta_description`, `ParentPage`.`content`, `ParentPage`.`header_image`, `ParentPage`.`menu_image`, `ParentPage`.`display_order`, `ParentPage`.`active`, `ParentPage`.`is_top_menu`, `ParentPage`.`is_show_on_footer`, `ParentPage`.`list_item_id`, `ParentPage`.`slider`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`created`, `ParentPage`.`modified` FROM `pages` AS `Page` LEFT JOIN `pages` AS `ParentPage` ON (`Page`.`page_id` = `ParentPage`.`id`) WHERE `Page`.`slug` = 'register' LIMIT 1 | | 0 | 0 | 5 |
4 | SHOW FULL COLUMNS FROM `sliders` | | 9 | 9 | 2 |
5 | SELECT `Slider`.`id`, `Slider`.`bg_image`, `Slider`.`front_image`, `Slider`.`fcontent`, `Slider`.`scontent`, `Slider`.`tcontent`, `Slider`.`active`, `Slider`.`created`, `Slider`.`modified` FROM `sliders` AS `Slider` WHERE `Slider`.`active` = 1 | | 1 | 1 | 1 |
6 | SHOW FULL COLUMNS FROM `list_items` | | 8 | 8 | 2 |
7 | SHOW FULL COLUMNS FROM `list_types` | | 6 | 6 | 2 |
8 | SHOW FULL COLUMNS FROM `categories` | | 19 | 19 | 2 |
9 | SHOW FULL COLUMNS FROM `products` | | 29 | 29 | 1 |
10 | SHOW FULL COLUMNS FROM `options` | | 5 | 5 | 1 |
11 | SHOW FULL COLUMNS FROM `attributes` | | 6 | 6 | 1 |
12 | SHOW FULL COLUMNS FROM `products_attributes` | | 20 | 20 | 2 |
13 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 1 |
14 | SHOW FULL COLUMNS FROM `countries` | | 6 | 6 | 2 |
15 | SHOW FULL COLUMNS FROM `bookings` | | 30 | 30 | 2 |
16 | SHOW FULL COLUMNS FROM `attendees` | | 9 | 9 | 2 |
17 | SHOW FULL COLUMNS FROM `products_images` | | 8 | 8 | 1 |
18 | SELECT `ListItem`.`id`, `ListItem`.`name` FROM `list_items` AS `ListItem` WHERE `ListItem`.`active` = 1 AND `ListItem`.`list_type_id` = 1 | | 2 | 2 | 1 |
19 | SELECT ListItem.id,ListItem.page_slug, `ListItem`.`id` FROM `list_items` AS `ListItem` LEFT JOIN `list_types` AS `ListType` ON (`ListItem`.`list_type_id` = `ListType`.`id`) WHERE `ListItem`.`active` = 1 AND `ListItem`.`list_type_id` = 1 | | 2 | 2 | 1 |
20 | SELECT Product.id,Product.list_item_id,Product.name,Product.slug, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `list_items` AS `ListItem` ON (`Product`.`list_item_id` = `ListItem`.`id`) LEFT JOIN `options` AS `Option` ON (`Product`.`option_id` = `Option`.`id`) WHERE `Product`.`active` = 1 | | 2 | 2 | 1 |