条件から検索する

このサイトのデータはテストデータで架空のものです。


※ このデータは「個人情報テストデータジェネレーター」によって作成されたダミーデーターです。画像は「Icooon Mono」を利用しています。


グローバル変数

global varsvalues
%{BID}1
%{UID}
%{CID}
%{EID}
%{RID}
%{RVID}
%{UTID}
%{CMID}
%{TBID}
%{KEYWORD}
%{TAG}
%{FIELD}
%{DATE}
%{START}1000-01-01 00:00:00
%{END}9999-12-31 23:59:59
%{PAGE}1
%{ORDER}
%{QUERY}
%{QOL}?
%{ADMIN}
%{IS_ADMIN}0
%{ADMIN_PATH}
%{ADMIN_PATH_MID}
%{MID}
%{MODULE_ID}
%{MODULE_NAME}
%{STYLEGUIDE_PAGE}acms-admin
%{GETTEXT_TYPE}user
%{BCD}
%{UCD}
%{CCD}
%{ECD}
%{BLOG_NAME}10万件データのサンプルサイト
%{USER_NAME}
%{CATEGORY_NAME}
%{ENTRY_TITLE}
%{RULE_NAME}
%{CONFIG_SET_NAME}
%{THEME_SET_NAME}
%{EDITOR_SET_NAME}
%{RCID}
%{PCID}
%{RCCD}
%{PCCD}
%{ROOT_CATEGORY_NAME}
%{PARENT_CATEGORY_NAME}
%{RBID}1
%{PBID}
%{RBCD}
%{PBCD}
%{ROOT_BLOG_NAME}10万件データのサンプルサイト
%{PARENT_BLOG_NAME}
%{ALIAD_ID}
%{ALIAS_ID}
%{ALIAS_DOMAIN}
%{ALIAS_CODE}
%{ALIAS_NAME}
%{CHARSET}UTF-8
%{META_KEYWORDS}
%{META_DESCRIPTION}
%{NOW_DATE}2024-07-04
%{NOW_TIME}17:09:15
%{BLOG_THEME_COLOR}
%{BLOG_THEME_CONTRAST_COLOR}#ffffff
%{VERSION}3.1.16
%{SNAME}sid
%{SID}
%{SESSION_USER_ID}
%{SESSION_BLOG_ID}
%{MAX_PUBLISHES}15
%{ROOT_TPL}/themes/htmx@site/index.html
%{ROOT_TPL_NAME}index
%{ROOT_DIR}/
%{DOCUMENT_ROOT}/
%{THEMES_DIR}/themes/
%{JS_DIR}/js/
%{JS_LIB_DIR}/js/library/
%{JS_LIB_JQUERY_DIR}/js/library/jquery/
%{JS_LIB_JQUERY_DIR_VERSION}3.6.1
%{LOGIN_SEGMENT}login
%{ADMIN_RESET_PASSWORD_SEGMENT}admin-reset-password
%{ADMIN_RESET_PASSWORD_AUTH_SEGMENT}admin-reset-password-auth
%{ADMIN_TFA_RECOVERY_SEGMENT}admin-tfa-recovery
%{SIGNIN_SEGMENT}signin
%{SIGNUP_SEGMENT}signup
%{RESET_PASSWORD_SEGMENT}reset-password
%{RESET_PASSWORD_AUTH_SEGMENT}reset-password-auth
%{TFA_RECOVERY_SEGMENT}tfa-recovery
%{PROFILE_UPDATE_SEGMENT}mypage/update-profile
%{PASSWORD_UPDATE_SEGMENT}mypage/update-password
%{EMAIL_UPDATE_SEGMENT}mypage/update-email
%{TFA_UPDATE_SEGMENT}mypage/update-tfa
%{WITHDRAWAL_SEGMENT}mypage/withdrawal
%{SYSTEM_THEMES_DIR}/themes/system/
%{CURRENT_THEMES_DIR}/themes/htmx@site/
%{ARCHIVES_DIR}/archives/
%{MEDIA_ARCHIVES_DIR}/media/
%{MEDIA_STORAGE_DIR}storage/
%{BID_ARCHIVES_DIR}/archives/001/
%{YM_ARCHIVES_DIR}/archives/001/202407/
%{ARCHIVES_DIR_TEMP}/archives/temp/
%{ARCHIVES_CACHE_SERVER}
%{HTTP_THEMES_DIR}https://appleple2017.xsrv.jp/themes/
%{HTTP_CURRENT_THEMES_DIR}https://appleple2017.xsrv.jp/themes/htmx@site/
%{HTTP_ARCHIVES_DIR}https://appleple2017.xsrv.jp/archives/
%{HTTP_MEDIA_ARCHIVES_DIR}https://appleple2017.xsrv.jp/media/
%{HTTP_ARCHIVES_DIR_TEMP}https://appleple2017.xsrv.jp/archives/temp/
%{HTTP_BID_ARCHIVES_DIR}https://appleple2017.xsrv.jp/archives/001/
%{HTTP_YM_ARCHIVES_DIR}https://appleple2017.xsrv.jp/archives/001/202407/
%{HTTP_REQUEST_URL}https://appleple2017.xsrv.jp/
%{IMAGES_DIR}/themes/system/images/
%{SCRIPT_ROOT}/
%{REWRITE_OFFSET}/
%{HTTP_ROOT}https://appleple2017.xsrv.jp/
%{DOMAIN}appleple2017.xsrv.jp
%{DOMAIN_ROOT}appleple2017.xsrv.jp
%{HTTP_HOST}appleple2017.xsrv.jp
%{BASE_URL}http://appleple2017.xsrv.jp/
%{ADMIN_BASE_URL}https://appleple2017.xsrv.jp/
%{BLOG_URL}https://appleple2017.xsrv.jp/
%{ROOT_BLOG_URL}https://appleple2017.xsrv.jp/
%{PARENT_BLOG_URL}
%{CATEGORY_URL}https://appleple2017.xsrv.jp/
%{ROOT_CATEGORY_URL}https://appleple2017.xsrv.jp/
%{PARENT_CATEGORY_URL}https://appleple2017.xsrv.jp/
%{CANONICAL_URL}https://appleple2017.xsrv.jp/
%{ENTRY_URL}https://appleple2017.xsrv.jp/
%{PERMALINK}https://appleple2017.xsrv.jp/
%{INHERLINK}https://appleple2017.xsrv.jp/
%{CURRENT_URL}https://appleple2017.xsrv.jp/
%{HOME_URL}https://appleple2017.xsrv.jp/
%{BASE_ACMS_PATH}/
%{ACMS_PATH_BASE}/
%{SCRIPT_DIR}/home/appleple2017/appleple2017.xsrv.jp/public_html/
%{CURRENT_ROOT}
%{REQUEST_PATH}
%{REQUEST_DIRNAME}
%{MODULE}
%{VALID_ID_REGEX}@^[a-zA-Z0-9_-]+$@
%{REGEX_VALID_ID}@^[a-zA-Z0-9_-]+$@
%{REGEX_VALID_PASSWD}@^[!-~]+$@
%{CATEGORY_EXISTS}1
%{CATEGORY_LEVEL}0
%{VIEW}top
%{UA}Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
%{CH_UA}
%{CH_UA_MOBILE}0
%{CH_UA_PLATFORM}
%{UA_GROUP}PC
%{REMOTE_ADDR}3.17.154.243
%{MAINTENANCE_MODE}
%{PROTOCOL}https
%{BLOG_CODE}
%{USER_CODE}
%{CATEGORY_CODE}
%{ENTRY_CODE}
%{BLOG_ID}1
%{USER_ID}
%{CATEGORY_ID}
%{ENTRY_ID}
%{SUID}
%{SBID}
%{SESSION_USER_AUTH}
%{SESSION_USER_NAME}
%{SESSION_USER_CODE}
%{SESSION_USER_MAIL}
%{SEARCH_ENGINE_KEYWORD}
%{MAIL_MAGAZINE_FROM}info@example.com
%{MAIL_TRACKBACK_FROM}
%{MAIL_COMMENT_FROM}info@example.com
%{MAIL_REMIND_FROM}
%{MAIL_SUBSCRIBE_FROM}info@example.com
%{MAIL_SUBSCRIBE_ADMIN_FROM}info@example.com
%{PHP_FILE_MAX_SIZE}30M
%{PHP_POST_MAX_SIZE}30M
%{MEDIA_LIBRARY}on
%{IS_DEVELOPMENT}off
%{IS_TRIAL}off
%{TRIAL_COUNT_DOWN}0
%{IS_SUBSCRIPTION}off
%{SUBSCRIPTION_PLAN}
%{UNLICENSED_REASON}
%{SUBSCRIPTION_PAYMENT}
%{ACTIVATION_ENDPOINT}https://mypage.a-blogcms.jp/api/activation
%{GOOGLE_API_KEY}
%{PREVIEW_DEFAULT_DEVICE}iPhone 6/7/8
%{PREVIEW_HAS_HISTORY_DEVICE}
%{APPROVAL_PREVIEW_DEFAULT_DEVICE}iPhone 6/7/8
%{APPROVAL_PREVIEW_HAS_HISTORY_DEVICE}
%{TIMEMACHINE_PREVIEW_DEFAULT_DEVICE}PC
%{TIMEMACHINE_PREVIEW_HAS_HISTORY_DEVICE}
%{d}04
%{D}Thu
%{j}4
%{l}Thursday
%{N}4
%{S}th
%{w}4
%{z}185
%{W}27
%{F}July
%{m}07
%{M}Jul
%{n}7
%{t}31
%{L}1
%{o}2024
%{Y}2024
%{y}24
%{a}pm
%{A}PM
%{B}381
%{g}5
%{G}17
%{h}05
%{H}17
%{i}09
%{s}15
%{u}000000
%{e}Asia/Tokyo
%{I}0
%{O}+0900
%{P}+09:00
%{T}JST
%{Z}32400
%{c}2024-07-04T17:09:15+09:00
%{r}Thu, 04 Jul 2024 17:09:15 +0900
%{U}1720080555

モジュール処理時間

moduleidentifierrun timesql
Entry_Summarysummary_custom0.344928
Category_Listcategory_list0.219950
Category_List0.202752
Navigationnav_global0.010991
Navigationnav_global0.009931
Blog_Field0.003651
Field_Search0.003141
Entry_Summarysummary_sub0.003094
Topicpathtopicpath0.002482
Media_Bannerbanner0.002362
Blog_Field0.001921
Admin_InjectTemplateadmin-action0.001271
Admin_ActionMenu0.001121
Blog_Field0.000962
Ogp0.000812
Topicpathtopicpath0.00072
Blog_Field0.000661
Blog_FieldBF_root0.000661
Blog_Field0.000621
Blog_FieldBF_root0.000621
Blog_Field0.000611
Topicpathtopicpath0.00062
Blog_FieldBF_root0.000591
Blog_Field0.000581
Blog_FieldBF_root0.000581
Blog_FieldBF_root0.000571
Field_Search0.000431
Js0.000331
Navigationnav_footer_contact0.000321
Touch_Keyword0.000321
Touch_Top0.00031
Touch_SessionWithAdministration0.000281
Navigationnav_footer_about0.000271
Linkslinks_header_nav0.000261
Navigationnav_footer_news0.000261
Navigationnav_footer_products0.000261
Touch_Index0.000261
Linkslinks_header_nav0.000251
Touch_NotApprovalORsessionWithApprovalAdministrator0.000241
Touch_Entry0.000231
Touch_NotPreview0.000231
Touch_Benchmark0.000221
Touch_NotAdmin0.000221
Linkslinks_header_icon_nav0.00021
Touch_Edit0.00021
Touch_EditInplace0.00021
Touch_MailMagazineEnable0.00021
Touch_NotEditInplace0.00021
Touch_SessionWithContribution0.00021
Touch_SwitchingUser0.00021
Touch_Category0.000191
Touch_Debug0.000191
Touch_Entry0.000191
Touch_HigherLicense0.000191
Touch_Keyword0.000191
Touch_Login0.000191
Touch_NotAdmin0.000191
Touch_NotCategory0.000191
Touch_NotEdit0.000191
Touch_NotEntry0.000191
Touch_NotTimemachineMode0.000191
Touch_SessionWithAdministration0.000191
Touch_SessionWithCompilation0.000191
Touch_SessionWithContribution0.000191
Touch_Tag0.000191
Touch_Unlogin0.000191
Touch_NotPreview0.000181
Touch_NotPreview0.000181
Touch_NotPreview0.000181
Touch_SessionWithAdministration0.000181
Touch_Entry0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_NotPreview0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithAdministration0.000171
Touch_SessionWithContribution0.000171
Touch_Entry0.000161
Touch_Entry0.000161
MODULE TOTAL TIME0.82964158
BOOT TOTAL TIME0.84468
BUILD TOTAL TIME0.84824
REWRITE PATH TOTAL TIME0.00233
PROCCESS TIME0.995467

Slow Query

timequery
0.332320SELECT COUNT(DISTINCT(entry_id)) AS entry_amount
FROM (SELECT entry_id, entry_code, entry_status, entry_approval, entry_form_status, entry_sort, entry_user_sort, entry_category_sort, entry_title, entry_link, entry_datetime, entry_start_datetime, entry_end_datetime, entry_posted_datetime, entry_updated_datetime, entry_summary_range, entry_indexing, entry_members_only, entry_primary_image, entry_current_rev_id, entry_last_update_user_id, entry_category_id, entry_user_id, entry_form_id, entry_blog_id, blog_id, blog_code, blog_status, blog_parent, blog_name, blog_domain, blog_indexing, blog_alias_status, blog_alias_sort, blog_alias_primary, category_id, category_code, category_status, category_parent, category_sort, category_name, category_scope, category_indexing, category_blog_id, geo_geometry, geo_zoom
FROM acms_entry AS union1
LEFT JOIN acms_category ON entry_category_id = category_id
LEFT JOIN acms_geo ON entry_id = geo_eid
LEFT JOIN (
SELECT *
FROM acms_blog

WHERE 1
AND blog_status IN ('open')
) AS filteredBlog ON filteredBlog.blog_id = entry_blog_id

WHERE 1
AND entry_datetime BETWEEN '1000-01-01 00:00:00' AND '9999-12-31 23:59:59'
AND ( 1
AND entry_start_datetime <= '2024-07-04 17:09:15'
AND entry_end_datetime >= '2024-07-04 17:09:15'
AND entry_status = 'open'
AND entry_approval <> 'pre_approval'
)
AND ( 0
OR category_status IS NULL
OR category_status = 'open'
)
AND entry_blog_id = 1
AND entry_indexing = 'on') AS master

テンプレート

template
themes/htmx@site/include/head/meta.html
themes/site/include/head/robots.html
themes/htmx@site/include/head/link.html
themes/site/include/head/structured-data.html
themes/htmx@site/include/head/js.html
themes/site/include/body-start.html
themes/site/include/body-start/js-sns.html
themes/site/include/body-start/cookie-consent.html
themes/htmx@site/include/header.html
themes/system/admin/module/setting.html
themes/htmx@site/include/header/global-nav.html
themes/htmx@site/include/header/topicpath.html
themes/system/admin/action.html
themes/system/admin/switch-user.html
themes/system/include/check-seo.html
themes/site/include/check-seo-extend.html
themes/htmx@site/include/parts/search.html
themes/site/include/entry/summary-pickup.html
themes/site/include/siteparts/banner.html
themes/site/include/siteparts/links.html
themes/site/include/header/sp-global-nav.html
themes/site/include/footer/sns-link.html
themes/site/include/footer/suggest.html
themes/site/include/footer.html
themes/site/include/siteparts/navigation-footer.html
themes/site/include/body-end.html
themes/htmx@site/include/htmx/search.html
themes/htmx@site/include/htmx/summary-li.html
themes/htmx@site/include/htmx/htmx.html
themes/htmx@site/include/ablogcms.html
themes/htmx@site/include/htmx/entry/list.html
themes/htmx@site/include/htmx/category/list.html

メモリー

keyvalue
memory_limit200M
memory_get_usage3.03 MB
memory_get_peak_usage5.16 MB

Query Count

query count
181