Useful articles

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.61 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` = 4 AND `publication_type_translate`.`lang` = 'en'
Total Elapsed Time:: 0.63 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.39 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:: 1.21 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.39 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.32 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.14 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.33 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.1 ms

SQL Statement:: SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'publication_translate' AND `TABLE_SCHEMA` = DATABASE()
Total Elapsed Time:: 0.24 ms

SQL Statement:: SELECT `publication_translate`.`id`, `publication_translate`.`foreign_id`, `publication_translate`.`lang`, `publication_translate`.`key`, `publication_translate`.`value` FROM `publication_translate` WHERE `publication_translate`.`foreign_id` = 1688 AND `publication_translate`.`lang` = 'en'
Total Elapsed Time:: 0.31 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.12 ms