| # | Query | Parameters | Time, ms |
|---|---|---|---|
| 0 | select * from `ms_pages` where `code` = ? and `active` = ? order by `sort` asc limit 1 | home, 1 | 1.33 |
| 1 | select * from `ms_pages` where `code` = ? and `active` = ? order by `sort` asc limit 1 | home, 1 | 0.27 |
| 2 | with recursive `laravel_cte` as ((select `ms_navigations`.*, 0 as `depth`, cast(`id` as char(65535)) as `path` from `ms_navigations` where `parent_id` is null) union all (select `ms_navigations`.*, `depth` + 1 as `depth`, concat(`path`, ?, `ms_navigations`.`id`) from `ms_navigations` inner join `laravel_cte` on `laravel_cte`.`id` = `ms_navigations`.`parent_id`)) select * from `laravel_cte` where `category` = ? and `parent_id` is null and `active` = ? order by `sort` asc, `path` asc | ., main, 1 | 1.17 |
| 3 | select * from `ms_pages` where `ms_pages`.`id` in (1) | 0.3 | |
| 4 | select * from `ms_navigations` where `ms_navigations`.`parent_id` = ? and `ms_navigations`.`parent_id` is not null | 1 | 0.4 |
| 5 | select * from `ms_page_datas` where `ms_page_datas`.`page_id` = ? and `ms_page_datas`.`page_id` is not null and `locale` = ? order by `sort` asc | 1, ru | 0.37 |