Ўзб
- Total SQL queries: 37
- Total SQL elapsed seconds: 9.97 ms
- Memory usage: 4 Mb
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'language' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.37 ms
- SQL Statement:
- DESCRIBE `language`
- Total Elapsed Time:
- 0.48 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` = 'test-elon' LIMIT :APL0
- Total Elapsed Time:
- 0.19 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.44 ms
- SQL Statement:
- DESCRIBE `publication`
- Total Elapsed Time:
- 0.72 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` = 'uz' 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` = 'uz' 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` = 'uz' 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` = 'uz' AND `tr`.`key` = 'text')) AS `text` FROM `publication` AS `p` INNER JOIN `publication_type` AS `t` ON `p`.`type_id` = `t`.`id` WHERE `p`.`slug` = :slug
- Total Elapsed Time:
- 0.93 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.21 ms
- SQL Statement:
- DESCRIBE `publication_translate`
- Total Elapsed Time:
- 0.38 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` = 1686 AND `publication_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.25 ms
- SQL Statement:
- SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'publication_type' AND `TABLE_SCHEMA` = DATABASE()
- Total Elapsed Time:
- 0.19 ms
- SQL Statement:
- DESCRIBE `publication_type`
- Total Elapsed Time:
- 0.36 ms
- SQL Statement:
- SELECT `publication_type`.`id`, `publication_type`.`slug`, `publication_type`.`limit`, `publication_type`.`format`, `publication_type`.`display_date`, `publication_type`.`index_page` FROM `publication_type`
- Total Elapsed Time:
- 0.15 ms
- 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.18 ms
- SQL Statement:
- DESCRIBE `publication_type_translate`
- Total Elapsed Time:
- 0.49 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` = 1 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.27 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` = 2 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.3 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` = 3 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.26 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` = 'uz'
- Total Elapsed Time:
- 0.26 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` = 5 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.28 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` = 6 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.25 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` = 7 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.28 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` = 8 AND `publication_type_translate`.`lang` = 'uz'
- Total Elapsed Time:
- 0.25 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` = 'uz'
- Total Elapsed Time:
- 0.25 ms
- SQL Statement:
- SELECT `publication`.`id`, `publication`.`type_id`, `publication`.`slug`, `publication`.`created_at`, `publication`.`updated_at`, `publication`.`date`, `publication`.`preview_inner`, `publication`.`preview_src`, `publication`.`index_page`, `publication`.`views`, `publication`.`likes`, `publication`.`important` FROM `publication` WHERE `publication`.`id` <> :1 AND `publication`.`type_id` = :2 ORDER BY `publication`.`id` DESC LIMIT :APL0
- Total Elapsed Time:
- 0.25 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.41 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.07 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` = 'uz' LIMIT :APL0
- Total Elapsed Time:
- 0.06 ms
- SQL Statement:
- SELECT COUNT(*) AS `rowcount` FROM `publication` WHERE `publication`.`slug` = :0 AND `publication`.`id` <> :1
- Total Elapsed Time:
- 0.19 ms
- SQL Statement:
- UPDATE `publication` SET `type_id` = ?, `slug` = ?, `created_at` = ?, `updated_at` = ?, `date` = ?, `preview_inner` = ?, `preview_src` = null, `index_page` = ?, `views` = ?, `likes` = null, `important` = ? WHERE `id` = ?
- Total Elapsed Time:
- 0.47 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` = 'uz' LIMIT :APL0
- Total Elapsed Time:
- 0.09 ms
- SQL Statement:
- SELECT `publication_type`.`id`, `publication_type`.`slug`, `publication_type`.`limit`, `publication_type`.`format`, `publication_type`.`display_date`, `publication_type`.`index_page` FROM `publication_type` WHERE `publication_type`.`slug` = 'articles' LIMIT :APL0
- Total Elapsed Time:
- 0.19 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` = 'uz' LIMIT :APL0
- Total Elapsed Time:
- 0.07 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` = 'test-elon' LIMIT :APL0
- Total Elapsed Time:
- 0.07 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` = 'test-elon' LIMIT :APL0
- Total Elapsed Time:
- 0.05 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` = 'test-elon' LIMIT :APL0
- Total Elapsed Time:
- 0.06 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` = 'test-elon' LIMIT :APL0
- Total Elapsed Time:
- 0.05 ms