1 | SHOW FULL COLUMNS FROM `pages` | | 26 | 26 | 1 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 |
3 | SHOW FULL COLUMNS FROM `users` | | 11 | 11 | 1 |
4 | SHOW FULL COLUMNS FROM `sites` | | 15 | 15 | 1 |
5 | SHOW FULL COLUMNS FROM `groups` | | 5 | 5 | 1 |
6 | SHOW FULL COLUMNS FROM `groups_sites` | | 2 | 2 | 1 |
7 | SHOW FULL COLUMNS FROM `layouts` | | 2 | 2 | 1 |
8 | SHOW FULL COLUMNS FROM `modules` | | 7 | 7 | 1 |
9 | SHOW FULL COLUMNS FROM `pages_modules` | | 2 | 2 | 1 |
10 | SHOW FULL COLUMNS FROM `products` | | 8 | 8 | 2 |
11 | SHOW FULL COLUMNS FROM `product_categories` | | 5 | 5 | 1 |
12 | SHOW FULL COLUMNS FROM `orders` | | 19 | 19 | 1 |
13 | SHOW FULL COLUMNS FROM `orders_products` | | 4 | 4 | 1 |
14 | SHOW FULL COLUMNS FROM `air_mail_rates` | | 2 | 2 | 1 |
15 | SELECT `Page`.`id`, `Site`.`id`, `Site`.`store_online` FROM `pages` AS `Page` LEFT JOIN `sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` IS NULL AND `Site`.`url` LIKE '%pulpfigures.com' ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
16 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`photo`, `Category`.`description`, `Category`.`order` FROM `product_categories` AS `Category` WHERE 1 = 1 ORDER BY `order` ASC | | 17 | 17 | 1 |
17 | SELECT `Site`.`unit_price`, `Site`.`id` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
18 | SELECT `Page`.`id`, `Page`.`sef_description`, `Page`.`title`, `Page`.`sef_keywords`, `Page`.`sef_url`, `Page`.`created`, `Page`.`modified`, `Page`.`modified_by`, `Page`.`is_visible`, `Page`.`parent_id`, `Page`.`is_active`, `Page`.`lft`, `Page`.`rght`, `Page`.`slug`, `Page`.`site_id`, `Page`.`sef_title`, `Page`.`layout_id`, `Page`.`theme_id`, `Page`.`photo`, `Page`.`content`, `Page`.`external_link`, `Page`.`old_parent_id`, `Page`.`sub_title`, `Page`.`synopsis`, `Page`.`left_col`, `Page`.`right_col` FROM `pages` AS `Page` WHERE `Page`.`site_id` = (1) | | 23 | 23 | 2 |
19 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`is_active`, `GroupsSite`.`group_id`, `GroupsSite`.`site_id` FROM `groups` AS `Group` JOIN `groups_sites` AS `GroupsSite` ON (`GroupsSite`.`site_id` = 1 AND `GroupsSite`.`group_id` = `Group`.`id`) | | 1 | 1 | 1 |