| Queries | Time | Rows |
| SELECT * FROM wb_structures LEFT JOIN wb_meta ON wb_structures.structure_id = wb_meta.table_col_value WHERE wb_structures.structure_path IN ('/home/index', '/home', '/') AND wb_structures.structure_scope = 'ru' AND wb_meta.table = 'structures' AND wb_meta.table_col = 'structure_id' ORDER BY LENGTH(wb_structures.structure_path) DESC LIMIT 0,1 | 0.001 | 1 |
SELECT *
FROM (`wb_settings`)
ORDER BY `wb_settings`.`setting_id` DESC | 0.000 | 10 |
SELECT `wb_users`.*, `wb_users_roles`.*
FROM (`wb_users_roles`)
LEFT JOIN `wb_users` ON (`wb_users`.`role_id` = `wb_users_roles`.`role_id`)
WHERE `wb_users_roles`.`role_name` = 'guest' | 0.000 | 1 |
SELECT `wb_users_roles_permissions`.`permission_name`
FROM (`wb_users_roles_permissions`)
WHERE `wb_users_roles_permissions`.`role_id` = '2' | 0.000 | 18 |
SELECT `wb_users_roles`.`role_name`, `wb_users_roles_permissions`.`permission_name`
FROM (`wb_users_roles`)
LEFT JOIN `wb_users_roles_permissions` ON (`wb_users_roles_permissions`.`role_id` = `wb_users_roles`.`role_id`)
ORDER BY `wb_users_roles`.`role_id` ASC | 0.001 | 45 |
SELECT `A`.`structure_lkey`, `A`.`structure_rkey`, `A`.`structure_level`
FROM (`wb_structures` AS `A`, `wb_structures` AS `B`) WHERE `B`.`structure_id` = 117
AND `B`.`structure_lkey` BETWEEN `A`.`structure_lkey` AND `A`.`structure_rkey`
ORDER BY `A`.`structure_lkey` ASC | 0.000 | 2 |
SELECT *
FROM `wb_structures`
LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`)
WHERE (`structure_level` = 2 OR (`structure_level` = 2 AND `structure_lkey` > 1 AND `structure_rkey` < 36) OR (`structure_level` = 3 AND `structure_lkey` > 2 AND `structure_rkey` < 3))
AND `wb_meta`.`table_col` = 'structure_id'
AND `wb_structures`.`structure_level` >= '3'
ORDER BY `structure_level` ASC | 0.001 | 0 |
SELECT `wb_users`.*, `wb_users_roles`.*
FROM (`wb_users_roles`)
LEFT JOIN `wb_users` ON (`wb_users`.`role_id` = `wb_users_roles`.`role_id`)
WHERE `wb_users_roles`.`role_name` = 'guest' | 0.000 | 1 |
SELECT `wb_users_roles_permissions`.`permission_name`
FROM (`wb_users_roles_permissions`)
WHERE `wb_users_roles_permissions`.`role_id` = '2' | 0.000 | 18 |
SELECT `wb_structures`.*, `wb_meta`.*
FROM (`wb_structures`)
LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`)
WHERE `wb_structures`.`structure_id` = '117'
AND `wb_meta`.`table` = 'structures'
AND `wb_meta`.`table_col` = 'structure_id' | 0.001 | 1 |
SELECT *
FROM (`wb_structures`)
LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`)
WHERE `wb_meta`.`table` = 'structures'
AND `wb_meta`.`table_col` = 'structure_id'
AND structure_lkey <= 2
AND structure_rkey >= 3
AND `structure_scope` = 'ru'
AND `structure_level` >= 1 | 0.001 | 2 |
SELECT *
FROM (`wb_settings`)
ORDER BY `wb_settings`.`setting_id` DESC | 0.000 | 10 |
SELECT *
FROM (`wb_defaults`)
LEFT JOIN `wb_structures` ON (`wb_defaults`.`structure_id` = `wb_structures`.`structure_id`)
WHERE `wb_structures`.`structure_id` IN (117) | 0.000 | 1 |
SELECT *
FROM (`wb_vars`)
LEFT JOIN `wb_users` ON (`wb_vars`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_vars`.`var_name` IN ('home_jobs')
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`wb_jobs`)
LEFT JOIN `wb_structures` ON (`wb_structures`.`structure_id` = `wb_jobs`.`job_scope`)
LEFT JOIN `wb_meta` ON (`wb_jobs`.`job_id` = `wb_meta`.`table_col_value`)
LEFT JOIN `wb_users` ON (`wb_jobs`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_jobs`.`job_level` > 1
AND `wb_meta`.`table` = 'jobs'
AND `wb_meta`.`table_col` = 'job_id'
ORDER BY `job_lkey` ASC
LIMIT 0, 7 | 0.001 | 3 |
SELECT *
FROM (`wb_blocks`)
LEFT JOIN `wb_users` ON (`wb_blocks`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_blocks`.`block_id` IN (1)
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`wb_vars`)
LEFT JOIN `wb_users` ON (`wb_vars`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_vars`.`var_name` IN ('home_lastnews')
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`wb_news`)
LEFT JOIN `wb_structures` ON (`wb_structures`.`structure_id` = `wb_news`.`news_scope`)
LEFT JOIN `wb_meta` ON (`wb_news`.`news_id` = `wb_meta`.`table_col_value`)
LEFT JOIN `wb_users` ON (`wb_news`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_news`.`news_level` > 1
AND `wb_meta`.`table` = 'news'
AND `wb_meta`.`table_col` = 'news_id'
ORDER BY `wb_news`.`news_lkey` ASC
LIMIT 0, 2 | 0.001 | 2 |
SELECT *
FROM (`wb_vars`)
LEFT JOIN `wb_users` ON (`wb_vars`.`user_id` = `wb_users`.`user_id`)
WHERE `wb_vars`.`var_name` IN ('home_catalog')
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`wb_catalog_categories`)
LEFT JOIN `wb_structures` ON (`wb_structures`.`structure_id` = `wb_catalog_categories`.`structure_id`)
LEFT JOIN `wb_meta` ON (`wb_structures`.`structure_id` = `wb_meta`.`table_col_value`)
WHERE `wb_meta`.`table` = 'structures'
AND `wb_meta`.`table_col` = 'structure_id'
ORDER BY `wb_structures`.`structure_lkey` ASC | 0.002 | 7 |
| Total: 20 | 0.013 | 126 |
