Eng
- Total SQL queries: 16
- Total SQL elapsed seconds: 6.26 ms
- Memory usage: 4 Mb
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'page' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.36 ms
- SQL Statement:
- DESCRIBE `page`
- Total Elapsed Time:
- 0.53 ms
- SQL Statement:
- SELECT `p`.`id` AS `_p_id`, `p`.`slug` AS `_p_slug`, `p`.`created_at` AS `_p_created_at`, `p`.`updated_at` AS `_p_updated_at`, `p`.`index_page` AS `_p_index_page`, `p`.`anons` AS `_p_anons`, ((SELECT `t`.`value` AS `value` FROM `page_translate` AS `t` WHERE `t`.`foreign_id` = `p`.`id` AND `t`.`lang` = 'en' AND `t`.`key` = 'title')) AS `title`, ((SELECT `t`.`value` AS `value` FROM `page_translate` AS `t` WHERE `t`.`foreign_id` = `p`.`id` AND `t`.`lang` = 'en' AND `t`.`key` = 'meta_title')) AS `meta_title`, ((SELECT `t`.`value` AS `value` FROM `page_translate` AS `t` WHERE `t`.`foreign_id` = `p`.`id` AND `t`.`lang` = 'en' AND `t`.`key` = 'meta_description')) AS `meta_description`, ((SELECT `t`.`value` AS `value` FROM `page_translate` AS `t` WHERE `t`.`foreign_id` = `p`.`id` AND `t`.`lang` = 'en' AND `t`.`key` = 'menu_check')) AS `menu_check`, ((SELECT `t`.`value` AS `value` FROM `page_translate` AS `t` WHERE `t`.`foreign_id` = `p`.`id` AND `t`.`lang` = 'en' AND `t`.`key` = 'text')) AS `text` FROM `page` AS `p` WHERE `p`.`slug` = :slug
- Total Elapsed Time:
- 1.42 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'page_translate' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.22 ms
- SQL Statement:
- DESCRIBE `page_translate`
- Total Elapsed Time:
- 0.41 ms
- SQL Statement:
- SELECT `page_translate`.`id`, `page_translate`.`foreign_id`, `page_translate`.`lang`, `page_translate`.`key`, `page_translate`.`value` FROM `page_translate` WHERE `page_translate`.`foreign_id` = 37 AND `page_translate`.`lang` = 'en'
- Total Elapsed Time:
- 0.34 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'cms_settings' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.21 ms
- SQL Statement:
- DESCRIBE `cms_settings`
- Total Elapsed Time:
- 0.44 ms
- SQL Statement:
- SELECT `cms_settings`.`id`, `cms_settings`.`site_name`, `cms_settings`.`email`, `cms_settings`.`favicon`, `cms_settings`.`logo`, `cms_settings`.`comment_control`, `cms_settings`.`logoUz`, `cms_settings`.`logoEn`, `cms_settings`.`logoRu` FROM `cms_settings` WHERE `cms_settings`.`id` = 1 LIMIT :APL0
- Total Elapsed Time:
- 0.08 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'language' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.17 ms
- SQL Statement:
- DESCRIBE `language`
- Total Elapsed Time:
- 0.4 ms
- SQL Statement:
- SELECT `language`.`id`, `language`.`iso`, `language`.`locale`, `language`.`name`, `language`.`short_name`, `language`.`url`, `language`.`sortorder`, `language`.`primary` FROM `language` WHERE `language`.`iso` = 'en' LIMIT :APL0
- Total Elapsed Time:
- 0.07 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'employee' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.2 ms
- SQL Statement:
- DESCRIBE `employee`
- Total Elapsed Time:
- 0.58 ms
- SQL Statement:
- SELECT `p`.`id` AS `_p_id`, `p`.`foto` AS `_p_foto`, `p`.`phone` AS `_p_phone`, `p`.`email` AS `_p_email`, `p`.`category` AS `_p_category`, ((SELECT `tr`.`value` AS `value` FROM `employee_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'title')) AS `title`, ((SELECT `tr`.`value` AS `value` FROM `employee_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'text')) AS `text`, ((SELECT `tr`.`value` AS `value` FROM `employee_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'job')) AS `job`, ((SELECT `tr`.`value` AS `value` FROM `employee_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'bio')) AS `bio`, ((SELECT `tr`.`value` AS `value` FROM `employee_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'seo')) AS `seo` FROM `employee` AS `p` WHERE `p`.`category` = 'regions' ORDER BY `p`.`id` ASC LIMIT :APL0
- Total Elapsed Time:
- 0.76 ms
- SQL Statement:
- SELECT `language`.`id`, `language`.`iso`, `language`.`locale`, `language`.`name`, `language`.`short_name`, `language`.`url`, `language`.`sortorder`, `language`.`primary` FROM `language` WHERE `language`.`iso` = 'en' LIMIT :APL0
- Total Elapsed Time:
- 0.08 ms