Eng
- Total SQL queries: 14
- Total SQL elapsed seconds: 6.08 ms
- Memory usage: 2 Mb
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'publication_type_translate' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.58 ms
- SQL Statement:
- DESCRIBE `publication_type_translate`
- Total Elapsed Time:
- 0.91 ms
- SQL Statement:
- SELECT `publication_type_translate`.`id`, `publication_type_translate`.`foreign_id`, `publication_type_translate`.`lang`, `publication_type_translate`.`key`, `publication_type_translate`.`value` FROM `publication_type_translate` WHERE `publication_type_translate`.`foreign_id` = 12 AND `publication_type_translate`.`lang` = 'en'
- Total Elapsed Time:
- 0.13 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'publication' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.36 ms
- SQL Statement:
- DESCRIBE `publication`
- Total Elapsed Time:
- 0.74 ms
- SQL Statement:
- SELECT `p`.`id` AS `_p_id`, `p`.`type_id` AS `_p_type_id`, `p`.`slug` AS `_p_slug`, `p`.`created_at` AS `_p_created_at`, `p`.`updated_at` AS `_p_updated_at`, `p`.`date` AS `_p_date`, `p`.`preview_inner` AS `_p_preview_inner`, `p`.`preview_src` AS `_p_preview_src`, `p`.`index_page` AS `_p_index_page`, `p`.`views` AS `_p_views`, `p`.`likes` AS `_p_likes`, `p`.`important` AS `_p_important`, `t`.`slug` AS `t_slug`, ((SELECT `tr`.`value` AS `value` FROM `publication_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 `publication_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'meta_description')) AS `meta_description`, ((SELECT `tr`.`value` AS `value` FROM `publication_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'meta_title')) AS `meta_title`, ((SELECT `tr`.`value` AS `value` FROM `publication_translate` AS `tr` WHERE `tr`.`foreign_id` = `p`.`id` AND `tr`.`lang` = 'en' AND `tr`.`key` = 'text')) AS `text` FROM `publication` AS `p` LEFT JOIN `publication_type` AS `t` ON `p`.`type_id` = `t`.`id` WHERE (`t`.`slug` = :type) AND (`p`.`date` <= NOW()) ORDER BY `p`.`date` DESC LIMIT :APL0
- Total Elapsed Time:
- 0.85 ms
- SQL Statement:
- SELECT COUNT(*) AS `rowcount` FROM `publication` AS `p` LEFT JOIN `publication_type` AS `t` ON `p`.`type_id` = `t`.`id` WHERE (`t`.`slug` = :type) AND (`p`.`date` <= NOW())
- Total Elapsed Time:
- 0.33 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.29 ms
- SQL Statement:
- DESCRIBE `cms_settings`
- Total Elapsed Time:
- 0.65 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.12 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.3 ms
- SQL Statement:
- DESCRIBE `language`
- Total Elapsed Time:
- 0.65 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.11 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