| 1 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
settings |
ALL |
|
|
|
|
5 |
|
SELECT * FROM `settings`
|
5 |
0.000744 s
|
0 mb
|
| 2 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages_members |
ALL |
|
|
|
|
91 |
Using where; Using temporary; Using filesort |
SELECT `pages_members`.`id` AS `id`, `pages_members`.`name` AS `name`, `pages_members`.`homepage` AS `homepage`, `pages_members`.`content` AS `content`, `pages_members`.`icon` AS `icon`, `pages_members`.`updated_on` AS `updated_on`, `pages_members`.`created_on` AS `created_on`, `pages_members`.`posy` AS `posy`, `pages_members`.`active` AS `active`, `pages_members`.`page_id` AS `page` FROM `pages_members` AS `pages_members` WHERE `pages_members`.`active` = 1 GROUP BY `pages_members`.`name` ORDER BY RAND()
|
49 |
0.003111 s
|
0 mb
|
| 3 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages_members |
ALL |
|
|
|
|
91 |
Using where; Using temporary; Using filesort |
SELECT `pages_members`.`id` AS `id`, `pages_members`.`name` AS `name`, `pages_members`.`homepage` AS `homepage`, `pages_members`.`content` AS `content`, `pages_members`.`icon` AS `icon`, `pages_members`.`updated_on` AS `updated_on`, `pages_members`.`created_on` AS `created_on`, `pages_members`.`posy` AS `posy`, `pages_members`.`active` AS `active`, `pages_members`.`page_id` AS `page` FROM `pages_members` AS `pages_members` WHERE `pages_members`.`active` = 1 GROUP BY `pages_members`.`name` ORDER BY RAND()
|
49 |
0.002381 s
|
0 mb
|
| 4 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ref |
lft,scope |
lft |
4 |
const |
2 |
Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` = 1 AND `pages`.`scope` = '1' ORDER BY `lft` ASC LIMIT 1
|
1 |
0.001108 s
|
0 mb
|
| 5 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ref |
lft,scope |
lft |
4 |
const |
2 |
Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` = 1 AND `pages`.`scope` = '1' ORDER BY `lft` ASC LIMIT 1
|
1 |
0.000689 s
|
0 mb
|
| 6 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 1 AND `pages`.`rgt` < 36 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC
|
10 |
0.000933 s
|
0 mb
|
| 7 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 1 AND `pages`.`rgt` < 36 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC
|
10 |
0.001035 s
|
0 mb
|
| 8 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 1 AND `pages`.`rgt` < 36 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC
|
10 |
0.001062 s
|
0 mb
|
| 9 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 8 AND `pages`.`rgt` < 13 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 2 ORDER BY `pages`.`lft` ASC
|
2 |
0.000771 s
|
0 mb
|
| 10 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 8 AND `pages`.`rgt` < 13 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 2 ORDER BY `pages`.`lft` ASC
|
2 |
0.000847 s
|
0 mb
|
| 11 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 8 AND `pages`.`rgt` < 13 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 2 ORDER BY `pages`.`lft` ASC
|
2 |
0.000845 s
|
0 mb
|
| 12 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000801 s
|
0 mb
|
| 13 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000691 s
|
0 mb
|
| 14 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000725 s
|
0 mb
|
| 15 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.001111 s
|
0 mb
|
| 16 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.001256 s
|
0 mb
|
| 17 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000753 s
|
0 mb
|
| 18 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000848 s
|
0 mb
|
| 19 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000849 s
|
0 mb
|
| 20 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000657 s
|
0 mb
|
| 21 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 8 AND `pages`.`rgt` < 13 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000703 s
|
0 mb
|
| 22 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt,scope |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 8 AND `pages`.`rgt` < 13 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000616 s
|
0 mb
|
| 23 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ref |
lft,scope |
lft |
4 |
const |
2 |
Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` = 1 AND `pages`.`scope` = 1 ORDER BY `lft` ASC LIMIT 1
|
1 |
0.000879 s
|
0 mb
|
| 24 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
ALL |
lft,rgt |
|
|
|
34 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 ORDER BY `pages`.`lft` ASC
|
6 |
0.000814 s
|
0 mb
|
| 25 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
lft,rgt,scope |
lft |
4 |
|
22 |
Using index condition; Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` > 9 AND `pages`.`rgt` < 10 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 3 ORDER BY `pages`.`lft` ASC LIMIT 1
|
0 |
0.000820 s
|
0 mb
|
| 26 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages_newses |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
SELECT `pages_newses`.`id` AS `id`, `pages_newses`.`name` AS `name`, `pages_newses`.`content_short` AS `content_short`, `pages_newses`.`content` AS `content`, `pages_newses`.`icon` AS `icon`, `pages_newses`.`meta_title` AS `meta_title`, `pages_newses`.`meta_keywords` AS `meta_keywords`, `pages_newses`.`meta_description` AS `meta_description`, `pages_newses`.`slug` AS `slug`, `pages_newses`.`publish_on` AS `publish_on`, `pages_newses`.`updated_on` AS `updated_on`, `pages_newses`.`created_on` AS `created_on`, `pages_newses`.`posy` AS `posy`, `pages_newses`.`active` AS `active`, `pages_newses`.`page_id` AS `page` FROM `pages_newses` AS `pages_newses` WHERE `pages_newses`.`id` = '32' ORDER BY `pages_newses`.`publish_on` DESC LIMIT 1
|
1 |
0.001142 s
|
0 mb
|
| 27 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages_news_galleries |
ref |
news_id |
news_id |
5 |
const |
1 |
Using index condition; Using filesort |
SELECT `pages_news_galleries`.`id` AS `id`, `pages_news_galleries`.`icon` AS `icon`, `pages_news_galleries`.`updated_on` AS `updated_on`, `pages_news_galleries`.`created_on` AS `created_on`, `pages_news_galleries`.`posy` AS `posy`, `pages_news_galleries`.`news_id` AS `news` FROM `pages_news_galleries` AS `pages_news_galleries` WHERE `news_id` = 32 ORDER BY `pages_news_galleries`.`posy` ASC
|
0 |
0.001065 s
|
0 mb
|
| 28 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
attachments |
index_merge |
PRIMARY,obj_id,obj_type,type |
obj_id,PRIMARY |
9,4 |
|
1 |
Using intersect(obj_id,PRIMARY); Using where; Using filesort |
SELECT `attachments`.`id` AS `id`, `attachments`.`obj_id` AS `obj_id`, `attachments`.`obj_type` AS `obj_type`, `attachments`.`name` AS `name`, `attachments`.`filename` AS `filename`, `attachments`.`filesize` AS `filesize`, `attachments`.`ext` AS `ext`, `attachments`.`slug` AS `slug`, `attachments`.`type` AS `type` FROM `attachments` AS `attachments` WHERE `attachments`.`id` > 0 AND `attachments`.`obj_id` = 32 AND `attachments`.`obj_type` = 'news' AND `attachments`.`type` = 1 ORDER BY `posy` ASC
|
0 |
0.001352 s
|
0 mb
|
| 29 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`id` = '337' ORDER BY `lft` ASC LIMIT 1
|
1 |
0.000561 s
|
0 mb
|
| 30 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
lft |
4 |
|
12 |
Using index condition; Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC LIMIT 1
|
1 |
0.001047 s
|
0 mb
|
| 31 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
lft |
4 |
|
12 |
Using index condition; Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 9 AND `pages`.`rgt` >= 10 AND `pages`.`id` <> 337 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC LIMIT 1
|
1 |
0.000882 s
|
0 mb
|
| 32 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000619 s
|
0 mb
|
| 33 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000562 s
|
0 mb
|
| 34 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.001060 s
|
0 mb
|
| 35 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 ORDER BY `pages`.`lft` ASC
|
2 |
0.000960 s
|
0 mb
|
| 36 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
lft |
4 |
|
14 |
Using index condition; Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC LIMIT 1
|
1 |
0.000682 s
|
0 mb
|
| 37 |
EXPLAIN
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
pages |
range |
PRIMARY,lft,rgt,scope |
lft |
4 |
|
14 |
Using index condition; Using where |
SELECT `pages`.`id` AS `id`, `pages`.`parent_id` AS `parent_id`, `pages`.`title` AS `title`, `pages`.`header` AS `header`, `pages`.`header2` AS `header2`, `pages`.`content_short` AS `content_short`, `pages`.`content` AS `content`, `pages`.`icon` AS `icon`, `pages`.`slug` AS `slug`, `pages`.`type` AS `type`, `pages`.`template` AS `template`, `pages`.`created_on` AS `created_on`, `pages`.`keywords` AS `keywords`, `pages`.`description` AS `description`, `pages`.`menu` AS `menu`, `pages`.`options` AS `options`, `pages`.`active` AS `active`, `pages`.`lft` AS `left`, `pages`.`rgt` AS `right`, `pages`.`lvl` AS `level`, `pages`.`scope` AS `scope` FROM `pages` AS `pages` WHERE `pages`.`lft` <= 11 AND `pages`.`rgt` >= 12 AND `pages`.`id` <> 355 AND `pages`.`scope` = 1 AND `pages`.`lvl` = 1 ORDER BY `pages`.`lft` ASC LIMIT 1
|
1 |
0.001059 s
|
0 mb
|
|
total 37 queries |
|
0.036039 s |
0 mb |
