SELECT `t0`.`id` AS `t0_c0`, `t0`.`article_id` AS `t0_c1`, `t0`.`created_at` AS `t0_c2` FROM `blog_setting_pickup` AS `t0` ORDER BY `t0`.`id` ASCSpeed: 2.158 ms Query analysis: · Query: SIMPLE on t0 · Key Used: PRIMARY · Type: index · Rows: 11 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/common/list_cache.php, line 422File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12350' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.666 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12399' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.482 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '13360' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.408 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '13372' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.432 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12043' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.495 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Type: const · Rows: 1 (Impossible ON condition) · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12099' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.664 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Type: const · Rows: 1 (Impossible ON condition) · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12188' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.463 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Type: const · Rows: 1 (Impossible ON condition) · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '12183' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.574 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Type: const · Rows: 1 (Impossible ON condition) · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '13361' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.524 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '13152' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0')Speed: 2.615 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: const · Rows: 1 · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 143File: APPPATH/classes/common/list_cache.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 48File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8` FROM `blog_article` AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0') WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`mst_blog_author_id` = 555 AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') ORDER BY `t0`.`start_date` DESC LIMIT 5 OFFSET 0Speed: 2.497 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: fk_blog_article_mst_blog_author1_idx · Key Used: fk_blog_article_mst_blog_author1_idx · Type: ref · Rows: 1 (Using where; Using filesort) · Query: SIMPLE on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/model/blog/article.php, line 402File: APPPATH/classes/common/list_cache.php, line 447File: APPPATH/modules/client/classes/controller/blog/article.php, line 51File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`slug` AS `t0_c2`, `t0`.`created_user` AS `t0_c3`, `t0`.`updated_user` AS `t0_c4`, `t0`.`created_at` AS `t0_c5`, `t0`.`updated_at` AS `t0_c6`, `t0`.`del_flg` AS `t0_c7`, `t0`.`disp_order` AS `t0_c8` FROM `mst_blog_category` AS `t0` WHERE `t0`.`del_flg` = 0 ORDER BY `t0`.`disp_order` ASCSpeed: 2.341 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: del_flg · Key Used: del_flg · Type: ref · Rows: 6 (Using filesort) Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/model/mst/blog/category.php, line 38File: APPPATH/modules/client/classes/controller/blog/article.php, line 54File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(log.article_id) AS `cnt`, `log`.`article_id` FROM `blog_article_log` AS `log` JOIN `blog_article` AS `ba` ON (`log`.`article_id` = `ba`.`id`) WHERE `ba`.`start_date` BETWEEN '2025-05-25 00:00:00' AND '2025-06-24 23:59:59' AND `ba`.`validity` = 1 AND `ba`.`del_flg` = 0 AND `ba`.`sub_list_flg` = 0 AND (`ba`.`start_date` IS null OR `ba`.`start_date` <= '2025-06-24 13:49:35') AND (`ba`.`finish_date` IS null OR `ba`.`finish_date` >= '2025-06-24 13:49:35') GROUP BY `log`.`article_id` ORDER BY `cnt` DESC LIMIT 12Speed: 10.250 ms Query analysis: · Query: SIMPLE on ba · Possible keys: PRIMARY,id_UNIQUE,sub_list_flg · Key Used: sub_list_flg · Type: ref · Rows: 2536 (Using where; Using temporary; Using filesort) · Query: SIMPLE on log · Possible keys: article_id · Key Used: article_id · Type: ref · Rows: 2 (Using index) Call trace for this query:File: APPPATH/classes/model/blog/articlelog.php, line 89File: APPPATH/classes/common/list_cache.php, line 258File: APPPATH/classes/common/list_cache.php, line 272File: APPPATH/modules/client/classes/controller/blog/article.php, line 57File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(log.article_id) AS `cnt`, `log`.`article_id` FROM `blog_article_log` AS `log` JOIN `blog_article` AS `ba` ON (`log`.`article_id` = `ba`.`id`) WHERE `ba`.`start_date` BETWEEN '2025-03-26 00:00:00' AND '2025-06-24 23:59:59' AND `ba`.`validity` = 1 AND `ba`.`del_flg` = 0 AND `ba`.`sub_list_flg` = 0 AND (`ba`.`start_date` IS null OR `ba`.`start_date` <= '2025-06-24 13:49:35') AND (`ba`.`finish_date` IS null OR `ba`.`finish_date` >= '2025-06-24 13:49:35') GROUP BY `log`.`article_id` ORDER BY `cnt` DESC LIMIT 12Speed: 10.437 ms Query analysis: · Query: SIMPLE on ba · Possible keys: PRIMARY,id_UNIQUE,sub_list_flg · Key Used: sub_list_flg · Type: ref · Rows: 2536 (Using where; Using temporary; Using filesort) · Query: SIMPLE on log · Possible keys: article_id · Key Used: article_id · Type: ref · Rows: 2 (Using index) Call trace for this query:File: APPPATH/classes/model/blog/articlelog.php, line 89File: APPPATH/classes/common/list_cache.php, line 297File: APPPATH/classes/common/list_cache.php, line 311File: APPPATH/modules/client/classes/controller/blog/article.php, line 58File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(log.article_id) AS `cnt`, `log`.`article_id` FROM `blog_article_log` AS `log` JOIN `blog_article` AS `ba` ON (`log`.`article_id` = `ba`.`id`) WHERE `ba`.`start_date` BETWEEN '2024-06-24 00:00:00' AND '2025-06-24 23:59:59' AND `ba`.`validity` = 1 AND `ba`.`del_flg` = 0 AND `ba`.`sub_list_flg` = 0 AND (`ba`.`start_date` IS null OR `ba`.`start_date` <= '2025-06-24 13:49:35') AND (`ba`.`finish_date` IS null OR `ba`.`finish_date` >= '2025-06-24 13:49:35') GROUP BY `log`.`article_id` ORDER BY `cnt` DESC LIMIT 12Speed: 10.337 ms Query analysis: · Query: SIMPLE on ba · Possible keys: PRIMARY,id_UNIQUE,sub_list_flg · Key Used: sub_list_flg · Type: ref · Rows: 2536 (Using where; Using temporary; Using filesort) · Query: SIMPLE on log · Possible keys: article_id · Key Used: article_id · Type: ref · Rows: 2 (Using index) Call trace for this query:File: APPPATH/classes/model/blog/articlelog.php, line 89File: APPPATH/classes/common/list_cache.php, line 336File: APPPATH/classes/common/list_cache.php, line 350File: APPPATH/modules/client/classes/controller/blog/article.php, line 59File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8`, `t3_through`.`mst_blog_category_id`, `t3_through`.`blog_article_id`, `t3`.`id` AS `t3_c0`, `t3`.`name` AS `t3_c1`, `t3`.`slug` AS `t3_c2`, `t3`.`created_user` AS `t3_c3`, `t3`.`updated_user` AS `t3_c4`, `t3`.`created_at` AS `t3_c5`, `t3`.`updated_at` AS `t3_c6`, `t3`.`del_flg` AS `t3_c7`, `t3`.`disp_order` AS `t3_c8`, `t4_through`.`mst_blog_category_sub_id`, `t4_through`.`blog_article_id`, `t4`.`id` AS `t4_c0`, `t4`.`name` AS `t4_c1`, `t4`.`slug` AS `t4_c2`, `t4`.`mst_blog_category_id` AS `t4_c3`, `t4`.`created_user` AS `t4_c4`, `t4`.`updated_user` AS `t4_c5`, `t4`.`created_at` AS `t4_c6`, `t4`.`updated_at` AS `t4_c7`, `t4`.`del_flg` AS `t4_c8`, `t5`.`id` AS `t5_c0`, `t5`.`name` AS `t5_c1`, `t5`.`post` AS `t5_c2`, `t5`.`desc_sub` AS `t5_c3`, `t5`.`body` AS `t5_c4`, `t5`.`image` AS `t5_c5`, `t5`.`disp_order` AS `t5_c6`, `t5`.`created_user` AS `t5_c7`, `t5`.`updated_user` AS `t5_c8`, `t5`.`created_at` AS `t5_c9`, `t5`.`updated_at` AS `t5_c10`, `t5`.`del_flg` AS `t5_c11`, `t6_through`.`mst_blog_tag_id`, `t6_through`.`blog_article_id`, `t6`.`id` AS `t6_c0`, `t6`.`name` AS `t6_c1`, `t6`.`created_user` AS `t6_c2`, `t6`.`updated_user` AS `t6_c3`, `t6`.`created_at` AS `t6_c4`, `t6`.`updated_at` AS `t6_c5`, `t6`.`del_flg` AS `t6_c6` FROM (SELECT `t0`.`id`, `t0`.`validity`, `t0`.`start_date`, `t0`.`finish_date`, `t0`.`mst_blog_category_id`, `t0`.`mst_blog_category_sub_id`, `t0`.`mst_blog_author_id`, `t0`.`title`, `t0`.`sub_title`, `t0`.`image`, `t0`.`image_caption`, `t0`.`body`, `t0`.`is_ad`, `t0`.`ad_id`, `t0`.`blog_type`, `t0`.`old_url`, `t0`.`created_user`, `t0`.`updated_user`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`del_flg`, `t0`.`pickup_flg`, `t0`.`special_flg`, `t0`.`sub_list_flg`, `t0`.`preview_key` FROM `blog_article` AS `t0` WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` = '13091' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') LIMIT 1) AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0') LEFT JOIN `blog_category_junction` AS `t3_through` ON (`t0`.`id` = `t3_through`.`blog_article_id`) LEFT JOIN `mst_blog_category` AS `t3` ON (`t3_through`.`mst_blog_category_id` = `t3`.`id` AND `t3`.`del_flg` = '0') LEFT JOIN `blog_category_sub_junction` AS `t4_through` ON (`t0`.`id` = `t4_through`.`blog_article_id`) LEFT JOIN `mst_blog_category_sub` AS `t4` ON (`t4_through`.`mst_blog_category_sub_id` = `t4`.`id` AND `t4`.`del_flg` = '0') LEFT JOIN `mst_blog_author` AS `t5` ON (`t0`.`mst_blog_author_id` = `t5`.`id` AND `t5`.`del_flg` = '0') LEFT JOIN `blog_tag_junction` AS `t6_through` ON (`t0`.`id` = `t6_through`.`blog_article_id`) LEFT JOIN `mst_blog_tag` AS `t6` ON (`t6_through`.`mst_blog_tag_id` = `t6`.`id` AND `t6`.`del_flg` = '0')Speed: 3.251 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Type: const · Rows: 1 (Impossible ON condition) · Query: PRIMARY on t3_through · Possible keys: fk_blog_category_junction_blog_article1_idx · Key Used: fk_blog_category_junction_blog_article1_idx · Type: ref · Rows: 1 · Query: PRIMARY on t3 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: PRIMARY on t4_through · Possible keys: fk_blog_category_sub_junction_blog_article1_idx · Key Used: fk_blog_category_sub_junction_blog_article1_idx · Type: ref · Rows: 1 · Query: PRIMARY on t4 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: eq_ref · Rows: 1 (Using where) · Query: PRIMARY on t5 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: del_flg,id_UNIQUE · Type: index_merge · Rows: 1 (Using intersect(del_flg,id_UNIQUE); Using where; Using join buffer (hash join)) · Query: PRIMARY on t6_through · Possible keys: fk_table1_blog_article1_idx · Key Used: fk_table1_blog_article1_idx · Type: ref · Rows: 1 · Query: PRIMARY on t6 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: DERIVED on t0 · Possible keys: PRIMARY,id_UNIQUE · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/blog/article.php, line 361File: APPPATH/modules/client/classes/controller/blog/article.php, line 73File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8`, `t3_through`.`mst_blog_category_id`, `t3_through`.`blog_article_id`, `t3`.`id` AS `t3_c0`, `t3`.`name` AS `t3_c1`, `t3`.`slug` AS `t3_c2`, `t3`.`created_user` AS `t3_c3`, `t3`.`updated_user` AS `t3_c4`, `t3`.`created_at` AS `t3_c5`, `t3`.`updated_at` AS `t3_c6`, `t3`.`del_flg` AS `t3_c7`, `t3`.`disp_order` AS `t3_c8`, `t4`.`id` AS `t4_c0`, `t4`.`name` AS `t4_c1`, `t4`.`post` AS `t4_c2`, `t4`.`desc_sub` AS `t4_c3`, `t4`.`body` AS `t4_c4`, `t4`.`image` AS `t4_c5`, `t4`.`disp_order` AS `t4_c6`, `t4`.`created_user` AS `t4_c7`, `t4`.`updated_user` AS `t4_c8`, `t4`.`created_at` AS `t4_c9`, `t4`.`updated_at` AS `t4_c10`, `t4`.`del_flg` AS `t4_c11` FROM `blog_article` AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0') LEFT JOIN `blog_category_junction` AS `t3_through` ON (`t0`.`id` = `t3_through`.`blog_article_id`) LEFT JOIN `mst_blog_category` AS `t3` ON (`t3_through`.`mst_blog_category_id` = `t3`.`id` AND `t3`.`del_flg` = '0') LEFT JOIN `mst_blog_author` AS `t4` ON (`t0`.`mst_blog_author_id` = `t4`.`id` AND `t4`.`del_flg` = '0') WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` != '13091' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') AND `t4`.`id` = '506' AND (`t1`.`id` = '6' OR `t3`.`id` = '6') ORDER BY `t0`.`start_date` DESC LIMIT 3Speed: 13.599 ms Query analysis: · Query: SIMPLE on t4 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on t0 · Possible keys: PRIMARY,id_UNIQUE,fk_blog_article_mst_blog_author1_idx · Key Used: PRIMARY · Type: range · Rows: 1768 (Using where) · Query: SIMPLE on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on t3_through · Possible keys: fk_blog_category_junction_blog_article1_idx · Key Used: fk_blog_category_junction_blog_article1_idx · Type: ref · Rows: 2 · Query: SIMPLE on t3 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/model/blog/article.php, line 425File: APPPATH/modules/client/classes/controller/blog/article.php, line 202File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`start_date` AS `t0_c2`, `t0`.`finish_date` AS `t0_c3`, `t0`.`mst_blog_category_id` AS `t0_c4`, `t0`.`mst_blog_category_sub_id` AS `t0_c5`, `t0`.`mst_blog_author_id` AS `t0_c6`, `t0`.`title` AS `t0_c7`, `t0`.`sub_title` AS `t0_c8`, `t0`.`image` AS `t0_c9`, `t0`.`image_caption` AS `t0_c10`, `t0`.`body` AS `t0_c11`, `t0`.`is_ad` AS `t0_c12`, `t0`.`ad_id` AS `t0_c13`, `t0`.`blog_type` AS `t0_c14`, `t0`.`old_url` AS `t0_c15`, `t0`.`created_user` AS `t0_c16`, `t0`.`updated_user` AS `t0_c17`, `t0`.`created_at` AS `t0_c18`, `t0`.`updated_at` AS `t0_c19`, `t0`.`del_flg` AS `t0_c20`, `t0`.`pickup_flg` AS `t0_c21`, `t0`.`special_flg` AS `t0_c22`, `t0`.`sub_list_flg` AS `t0_c23`, `t0`.`preview_key` AS `t0_c24`, `t1`.`id` AS `t1_c0`, `t1`.`name` AS `t1_c1`, `t1`.`slug` AS `t1_c2`, `t1`.`created_user` AS `t1_c3`, `t1`.`updated_user` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6`, `t1`.`del_flg` AS `t1_c7`, `t1`.`disp_order` AS `t1_c8`, `t2`.`id` AS `t2_c0`, `t2`.`name` AS `t2_c1`, `t2`.`slug` AS `t2_c2`, `t2`.`mst_blog_category_id` AS `t2_c3`, `t2`.`created_user` AS `t2_c4`, `t2`.`updated_user` AS `t2_c5`, `t2`.`created_at` AS `t2_c6`, `t2`.`updated_at` AS `t2_c7`, `t2`.`del_flg` AS `t2_c8`, `t3_through`.`mst_blog_category_id`, `t3_through`.`blog_article_id`, `t3`.`id` AS `t3_c0`, `t3`.`name` AS `t3_c1`, `t3`.`slug` AS `t3_c2`, `t3`.`created_user` AS `t3_c3`, `t3`.`updated_user` AS `t3_c4`, `t3`.`created_at` AS `t3_c5`, `t3`.`updated_at` AS `t3_c6`, `t3`.`del_flg` AS `t3_c7`, `t3`.`disp_order` AS `t3_c8`, `t4`.`id` AS `t4_c0`, `t4`.`name` AS `t4_c1`, `t4`.`post` AS `t4_c2`, `t4`.`desc_sub` AS `t4_c3`, `t4`.`body` AS `t4_c4`, `t4`.`image` AS `t4_c5`, `t4`.`disp_order` AS `t4_c6`, `t4`.`created_user` AS `t4_c7`, `t4`.`updated_user` AS `t4_c8`, `t4`.`created_at` AS `t4_c9`, `t4`.`updated_at` AS `t4_c10`, `t4`.`del_flg` AS `t4_c11` FROM `blog_article` AS `t0` LEFT JOIN `mst_blog_category` AS `t1` ON (`t0`.`mst_blog_category_id` = `t1`.`id` AND `t1`.`del_flg` = '0') LEFT JOIN `mst_blog_category_sub` AS `t2` ON (`t0`.`mst_blog_category_sub_id` = `t2`.`id` AND `t2`.`del_flg` = '0') LEFT JOIN `blog_category_junction` AS `t3_through` ON (`t0`.`id` = `t3_through`.`blog_article_id`) LEFT JOIN `mst_blog_category` AS `t3` ON (`t3_through`.`mst_blog_category_id` = `t3`.`id` AND `t3`.`del_flg` = '0') LEFT JOIN `mst_blog_author` AS `t4` ON (`t0`.`mst_blog_author_id` = `t4`.`id` AND `t4`.`del_flg` = '0') WHERE `t0`.`validity` = 1 AND `t0`.`del_flg` = 0 AND `t0`.`id` != '13091' AND (`t0`.`start_date` IS null OR `t0`.`start_date` <= '2025-06-24 13:49:35') AND (`t0`.`finish_date` IS null OR `t0`.`finish_date` >= '2025-06-24 13:49:35') AND `t4`.`id` != '506' AND (`t1`.`id` = '6' OR `t3`.`id` = '6') ORDER BY `t0`.`start_date` DESC LIMIT 7Speed: 22.051 ms Query analysis: · Query: SIMPLE on t4 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: range · Rows: 73 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t0 · Possible keys: PRIMARY,id_UNIQUE,fk_blog_article_mst_blog_author1_idx · Key Used: fk_blog_article_mst_blog_author1_idx · Type: ref · Rows: 23 (Using index condition; Using where) · Query: SIMPLE on t1 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on t2 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: id_UNIQUE · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on t3_through · Possible keys: fk_blog_category_junction_blog_article1_idx · Key Used: fk_blog_category_junction_blog_article1_idx · Type: ref · Rows: 2 · Query: SIMPLE on t3 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/model/blog/article.php, line 450File: APPPATH/modules/client/classes/controller/blog/article.php, line 208File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `s`.* FROM `seminar` AS `s` WHERE `s`.`validity` = 1 AND `s`.`del_flg` = 0 AND `s`.`sites` IN (1, 3) AND `s`.`holding_date` >= '2025-06-24' AND `s`.`mst_blog_category_id` = '6' ORDER BY `s`.`holding_date` ASC, `s`.`holding_hour_start` ASC, `s`.`holding_minute_start` ASC, `s`.`id` ASC LIMIT 4 OFFSET 0Speed: 2.420 ms Query analysis: · Query: SIMPLE on s · Possible keys: seminar_idx1,seminar_idx4,seminar_idx7,mst_blog_category_id,sites · Key Used: seminar_idx4 · Type: range · Rows: 1 (Using index condition; Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/seminar.php, line 173File: APPPATH/modules/client/classes/controller/blog/article.php, line 228File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT `s`.* FROM `seminar` AS `s` WHERE `s`.`validity` = 1 AND `s`.`del_flg` = 0 AND `s`.`sites` IN (1, 3) AND `s`.`holding_date` >= '2025-06-24' AND `s`.`mst_blog_category_id` = '6' ORDER BY `s`.`holding_date` ASC, `s`.`holding_hour_start` ASC, `s`.`holding_minute_start` ASC, `s`.`id` ASC) AS `counted_results`Speed: 2.345 ms Query analysis: · Query: SIMPLE on s · Possible keys: seminar_idx1,seminar_idx4,seminar_idx7,mst_blog_category_id,sites · Key Used: seminar_idx4 · Type: range · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/db.php, line 334File: APPPATH/classes/model/seminar.php, line 174File: APPPATH/modules/client/classes/controller/blog/article.php, line 228File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`name` AS `t0_c0`, `t0`.`id` AS `t0_c1` FROM `mst_blog_category` AS `t0` WHERE `t0`.`id` = '6' AND `t0`.`del_flg` = 0 LIMIT 1Speed: 2.246 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY,id_UNIQUE,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/mst/blog/category.php, line 59File: APPPATH/modules/client/views/2017_pc/blog/article/index.php, line 235File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172 |