ブログ

SELECT *
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-06-22 18:10:47'
AND `datetime_end` >= '2025-06-22 18:10:47'
AND `category` = '20'
ORDER BY `id` DESC
 LIMIT 3 ?>

SELECT `id`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-06-22 18:10:47'
AND `datetime_end` >= '2025-06-22 18:10:47'
AND `category` = '20' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '20' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '20' ?>

SELECT `id`, CONCAT("articles/detail/", id) AS url, `title`, `updated`, `file_1`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-06-22 18:10:47'
AND `datetime_end` >= '2025-06-22 18:10:47'
ORDER BY `updated` DESC
 LIMIT 3 ?>

SELECT DATE_FORMAT(`updated`, "%Y年%m月") AS `year_month`, DATE_FORMAT(`updated`, "articles/archive/%Y-%m") AS `link`, COUNT(*) AS `count`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-06-22 18:10:47'
AND `datetime_end` >= '2025-06-22 18:10:47'
GROUP BY `year_month`
ORDER BY `year_month` DESC
 LIMIT 3 ?>

SELECT `category`, COUNT(*) AS `count`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-06-22 18:10:47'
AND `datetime_end` >= '2025-06-22 18:10:47'
GROUP BY `category`
ORDER BY `id` DESC
 LIMIT 10 ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '31' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '30' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '20' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '0' ?>

SELECT `name`
FROM `selects_options`
WHERE `id` = '19' ?>

Array
(
)

Array
(
    [database_group_name] => 
    [tables] => Array
        (
            [users] => users
            [groups] => groups
            [users_groups] => groups_link
            [login_attempts] => login_attempts
        )

    [join] => Array
        (
            [users] => user_id
            [groups] => group_id
        )

    [hash_method] => bcrypt
    [bcrypt_default_cost] => 10
    [argon2_default_params] => Array
        (
            [memory_cost] => 65536
            [time_cost] => 4
            [threads] => 1
        )

    [site_title] => eclise.inc
    [admin_email] => noreply@eclise.me
    [default_group] => users
    [admin_group] => users
    [identity] => email
    [min_password_length] => 4
    [email_activation] => 1
    [manual_activation] => 
    [remember_users] => 1
    [user_expire] => 86500
    [user_extend_on_login] => 
    [track_login_attempts] => 1
    [track_login_ip_address] => 1
    [maximum_login_attempts] => 3
    [lockout_time] => 600
    [forgot_password_expiration] => 1800
    [recheck_timer] => 0
    [session_hash] => 6583d6c4f205998eclise251b68a2a2e44ea0006
    [remember_cookie_name] => remember_code
    [use_ci_email] => 1
    [email_config] => Array
        (
            [mailtype] => html
        )

    [email_templates] => auth/email/
    [email_activate] => activate.tpl.php
    [email_forgot_password] => forgot_password.tpl.php
    [delimiters_source] => config
    [message_start_delimiter] => <p>
    [message_end_delimiter] => </p>
    [error_start_delimiter] => <p>
    [error_end_delimiter] => </p>
)

Array
(
    [database_group_name] => 
    [tables] => Array
        (
            [users] => users_shop
            [groups] => groups
            [users_groups] => groups_link
            [login_attempts] => login_attempts
        )

    [join] => Array
        (
            [users] => user_id
            [groups] => group_id
        )

    [hash_method] => bcrypt
    [bcrypt_default_cost] => 10
    [argon2_default_params] => Array
        (
            [memory_cost] => 65536
            [time_cost] => 4
            [threads] => 1
        )

    [site_title] => eclise.inc
    [admin_email] => info@eclise.jp
    [default_group] => users_shop
    [admin_group] => users_shop
    [identity] => email
    [min_password_length] => 8
    [email_activation] => 
    [manual_activation] => 
    [remember_users] => 1
    [user_expire] => 86500
    [user_extend_on_login] => 
    [track_login_attempts] => 1
    [track_login_ip_address] => 1
    [maximum_login_attempts] => 5
    [lockout_time] => 600
    [forgot_password_expiration] => 1800
    [recheck_timer] => 0
    [session_hash] => 6583d6c4f205998eclise251b68a2a2e44eashop
    [remember_cookie_name] => remember_code_shop
    [use_ci_email] => 
    [email_config] => Array
        (
            [mailtype] => html
        )

    [email_templates] => shop/auth/email/
    [email_activate] => activate.tpl.php
    [email_forgot_password] => forgot_password.tpl.php
    [delimiters_source] => config
    [message_start_delimiter] => <p>
    [message_end_delimiter] => </p>
    [error_start_delimiter] => <p>
    [error_end_delimiter] => </p>
)

Array
(
    [database_group_name] => 
    [tables] => Array
        (
            [users] => users_adm
            [groups] => groups
            [users_groups] => groups_link
            [login_attempts] => login_attempts
        )

    [join] => Array
        (
            [users] => user_id
            [groups] => group_id
        )

    [hash_method] => bcrypt
    [bcrypt_default_cost] => 10
    [argon2_default_params] => Array
        (
            [memory_cost] => 65536
            [time_cost] => 4
            [threads] => 1
        )

    [site_title] => eclise.inc
    [admin_email] => info@eclise.jp
    [default_group] => users_adm
    [admin_group] => users_adm
    [identity] => email
    [min_password_length] => 8
    [email_activation] => 
    [manual_activation] => 
    [remember_users] => 1
    [user_expire] => 0
    [user_extend_on_login] => 
    [track_login_attempts] => 1
    [track_login_ip_address] => 1
    [maximum_login_attempts] => 5
    [lockout_time] => 600
    [forgot_password_expiration] => 1800
    [recheck_timer] => 0
    [session_hash] => 6583d6c4f205998eclise251b68a2a2e44ea0adm
    [remember_cookie_name] => remember_code_adm
    [use_ci_email] => 
    [email_config] => Array
        (
            [mailtype] => html
        )

    [email_templates] => adm/auth/email/
    [email_activate] => activate.tpl.php
    [email_forgot_password] => forgot_password.tpl.php
    [delimiters_source] => config
    [message_start_delimiter] => <p>
    [message_end_delimiter] => </p>
    [error_start_delimiter] => <p>
    [error_end_delimiter] => </p>
)