創作プロット公開中

小説・シナリオになるまえのプロット（あらすじ）公開中。

創作・小説・シナリオ

幕末・明治を時代設定した、原作考案・企画を行います。
落語・漫画・ドラマ・舞台などのシナリオ、メディア化にお使いください。

オリジナル噺メニューはこちら

雑誌記事・コラムライティング

歴史・幕末維新・忠臣蔵・江戸文化風俗・時代考証など、歴史ジャンルの他、伝統芸能について記事執筆しております。

ライティング実績はこちら

著作権について

創作あらすじ、その他コンテンツの文章・タイトル・企画につきましては、全て作者：櫻庭由紀子に帰属します。
無断転載・無断使用は固く禁じます。

三遊亭楽松「粗忽の釘」亀戸梅屋敷落語会

自分の家すら忘れてしまう慌て者の亭主。
箒をかけるためだけなのに、長屋の壁を突き抜けるほどの瓦釘を打ち込んでしまい？
「粗忽の釘」他一席は「位牌屋」お楽しみに！！

日時：2016年10月29日　土曜日
開場：13:00 　開演：13:30

場所：亀戸梅屋敷

演目：「位牌屋」「粗忽の釘」

東京都東京都江東区亀戸４−１８−８
JR総武線　亀戸駅　徒歩7分

木戸銭：2000円　前売り：1500円

詳細・ご予約はこちら

O I DE MA SE !

櫻庭由紀子の原作創作サイトですおいでませ。

時代小説、創作落語とシナリオ執筆、その他IT・ビジネス・ライフスタイル・文化芸能系の取材ライターを行っています。

Joomla!デバッグコンソール

セッション

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1495653964,
                "last": 1495653964,
                "now": 1495653964
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

プロファイル情報

時間

メモリ

時間: 126.60 ms / 126.60 ms メモリ: 0.790 MB / 0.99 MB Application: afterLoad

時間: 156.19 ms / 282.79 ms メモリ: 1.347 MB / 2.34 MB Application: afterInitialise

時間: 223.40 ms / 506.19 ms メモリ: 0.560 MB / 2.90 MB Application: afterRoute

時間: 32.00 ms / 538.18 ms メモリ: 0.138 MB / 3.04 MB Application: beforeRenderComponent com_sppagebuilder

時間: 28.07 ms / 566.25 ms メモリ: 0.341 MB / 3.38 MB Application: Start JAccess::getAssetRules Old (1)

時間: 2.46 ms / 568.71 ms メモリ: 0.040 MB / 3.42 MB Application: Finish JAccess::getAssetRules Old (1)

時間: 145.96 ms / 714.68 ms メモリ: 0.670 MB / 4.09 MB Application: afterRenderComponent com_sppagebuilder

時間: 3.98 ms / 718.66 ms メモリ: 0.021 MB / 4.11 MB Application: afterDispatch

時間: 48.36 ms / 767.02 ms メモリ: 0.438 MB / 4.54 MB Application: beforeRenderModule mod_search (Search)

時間: 3.89 ms / 770.91 ms メモリ: 0.028 MB / 4.57 MB Application: afterRenderModule mod_search (Search)

時間: 0.08 ms / 770.99 ms メモリ: 0.000 MB / 4.56 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

時間: 8.35 ms / 779.34 ms メモリ: 0.056 MB / 4.62 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

時間: 0.27 ms / 779.61 ms メモリ: 0.000 MB / 4.61 MB Application: beforeRenderModule mod_custom (バナー1)

時間: 1.60 ms / 781.21 ms メモリ: 0.011 MB / 4.62 MB Application: afterRenderModule mod_custom (バナー1)

時間: 0.42 ms / 781.63 ms メモリ: 0.000 MB / 4.62 MB Application: beforeRenderModule mod_custom (O I DE MA SE ! (2))

時間: 0.45 ms / 782.08 ms メモリ: 0.007 MB / 4.62 MB Application: afterRenderModule mod_custom (O I DE MA SE ! (2))

時間: 0.15 ms / 782.23 ms メモリ: 0.000 MB / 4.62 MB Application: beforeRenderModule mod_custom (O I DE MA SE !)

時間: 0.46 ms / 782.70 ms メモリ: 0.007 MB / 4.63 MB Application: afterRenderModule mod_custom (O I DE MA SE !)

時間: 9.67 ms / 792.37 ms メモリ: 0.063 MB / 4.69 MB Application: afterRender

合計データベースクエリ: 145.80 ms

メモリ使用量

データベースクエリ

24クエリをログに記録しました 145.80 ms

クエリ時間: 0.85 ms クエリメモリ: 0.018 MB Memory before query: 1.496 MB 返された行: 0

SELECT `data`

  FROM `gi2yc_session`

  WHERE `session_id` = '41fd0381d484d4649d5741fa47480a92'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_session	const	PRIMARY	PRIMARY	766	const	1

プロファイル

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	下の行にあるコールと同じです。
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 0.73 ms 最後のクエリ以降: 5.73 ms クエリメモリ: 0.012 MB Memory before query: 1.562 MB 返された行: 0

SELECT `session_id`

  FROM `gi2yc_session`

  WHERE `session_id` = '41fd0381d484d4649d5741fa47480a92' 
  LIMIT 1

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_session	const	PRIMARY	PRIMARY	766	const	1	Using index

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 2.03 ms 最後のクエリ以降: 0.25 ms クエリメモリ: 0.009 MB Memory before query: 1.577 MB

INSERT INTO `gi2yc_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('41fd0381d484d4649d5741fa47480a92', 0, 1, '1495653964', 0, '')

説明

次のクエリではEXPLAINの使用不可: INSERT INTO `gi2yc_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('41fd0381d484d4649d5741fa47480a92', 0, 1, '1495653964', 0, '')

プロファイル

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
update	0.07 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.93 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 7.92 ms 最後のクエリ以降: 13.51 ms クエリメモリ: 0.017 MB Memory before query: 1.635 MB 返された行: 33

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `gi2yc_extensions`

  WHERE `type` = 'component'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_extensions	ref	extension	extension	82	const	33	Using where

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	下の行にあるコールと同じです。
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.44 ms 最後のクエリ以降: 13.05 ms クエリメモリ: 0.016 MB Memory before query: 1.696 MB 返された行: 2

SELECT b.id

  FROM gi2yc_usergroups AS a

  LEFT JOIN gi2yc_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 8

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using index

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.24 ms 最後のクエリ以降: 2.35 ms クエリメモリ: 0.014 MB Memory before query: 1.717 MB 返された行: 5

SELECT id, rules

  FROM `gi2yc_viewlevels`

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_viewlevels	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	5

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.69 ms 最後のクエリ以降: 0.21 ms クエリメモリ: 0.014 MB Memory before query: 1.735 MB 返された行: 52

SELECT folder AS type, element AS name, params

  FROM gi2yc_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_extensions	ref	extension	extension	82	const	64	Using where; filesortレコードの使用

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.26 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 72.65 ms 最後のクエリ以降: 48.66 ms クエリメモリ: 0.029 MB Memory before query: 2.396 MB 返された行: 25

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM gi2yc_menu AS m

  LEFT JOIN gi2yc_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	78	Using where; filesortレコードの使用
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sakurabayukiko_rakugo.m.component_id	1

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.23 ms
Sending data	0.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.13 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 13.17 ms 最後のクエリ以降: 124.92 ms クエリメモリ: 0.024 MB Memory before query: 2.813 MB 返された行: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `gi2yc_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

プロファイル

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	下の行にあるコールと同じです。
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	下の行にあるコールと同じです。
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.82 ms 最後のクエリ以降: 0.48 ms クエリメモリ: 0.018 MB Memory before query: 2.820 MB

UPDATE `gi2yc_extensions`

  SET `params` = '{\"mediaversion\":\"6c43aa0ec6e4bb17d8be19868a4097dc\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

説明

次のクエリではEXPLAINの使用不可: UPDATE `gi2yc_extensions` SET `params` = '{\"mediaversion\":\"6c43aa0ec6e4bb17d8be19868a4097dc\"}' WHERE `type` = 'library' AND `element` = 'joomla'

プロファイル

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.06 ms
Updating	0.06 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.17 ms
query end	0.92 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	下の行にあるコールと同じです。
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 4.84 ms 最後のクエリ以降: 4.98 ms クエリメモリ: 0.014 MB Memory before query: 2.907 MB 返された行: 1

SELECT *

  FROM gi2yc_languages

  WHERE published=1

  ORDER BY ordering ASC

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_languages	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	Using where; filesortレコードの使用

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 20.20 ms 最後のクエリ以降: 0.52 ms クエリメモリ: 0.021 MB Memory before query: 2.927 MB 返された行: 4

SELECT id, home, template, s.params

  FROM gi2yc_template_styles as s

  LEFT JOIN gi2yc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	使用可能なインデックスキーがありません	NULL	NULL	3	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sakurabayukiko_rakugo.s.template,const	1	Using where

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 2.06 ms 最後のクエリ以降: 28.66 ms クエリメモリ: 0.034 MB Memory before query: 3.292 MB 返された行: 8

SHOW FULL COLUMNS 
  FROM `gi2yc_assets`

説明

次のクエリではEXPLAINの使用不可: SHOW FULL COLUMNS FROM `gi2yc_assets`

プロファイル

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.98 ms
System lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 0.91 ms 最後のクエリ以降: 1.76 ms クエリメモリ: 0.028 MB Memory before query: 3.355 MB 返された行: 1

SELECT *

  FROM gi2yc_assets

  WHERE `id` = '1'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_assets	const	PRIMARY	PRIMARY	4	const	1

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.04 ms 最後のクエリ以降: 0.30 ms クエリメモリ: 0.024 MB Memory before query: 3.378 MB 返された行: 1

SELECT a.rules

  FROM gi2yc_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.16 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.96 ms 最後のクエリ以降: 6.02 ms クエリメモリ: 0.025 MB Memory before query: 3.417 MB 返された行: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM gi2yc_sppagebuilder as a

  LEFT JOIN `gi2yc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN gi2yc_users AS ua 
  ON ua.id = a.created_by

  WHERE a.id = 2

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	0	unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 2.30 ms 最後のクエリ以降: 36.19 ms クエリメモリ: 0.028 MB Memory before query: 3.471 MB 返された行: 23

SHOW FULL COLUMNS 
  FROM `gi2yc_sppagebuilder`

説明

次のクエリではEXPLAINの使用不可: SHOW FULL COLUMNS FROM `gi2yc_sppagebuilder`

プロファイル

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.99 ms
System lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:126
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.31 ms 最後のクエリ以降: 0.73 ms クエリメモリ: 0.025 MB Memory before query: 3.548 MB 返された行: 1

SELECT *

  FROM gi2yc_sppagebuilder

  WHERE `id` = '2'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:127
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.71 ms 最後のクエリ以降: 2.13 ms クエリメモリ: 0.016 MB Memory before query: 3.574 MB

UPDATE gi2yc_sppagebuilder

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

説明

次のクエリではEXPLAINの使用不可: UPDATE gi2yc_sppagebuilder SET `hits` = (`hits` + 1) WHERE `id` = '2'

プロファイル

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.06 ms
Updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.03 ms
query end	0.97 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:128
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 0.95 ms 最後のクエリ以降: 15.35 ms クエリメモリ: 0.019 MB Memory before query: 3.818 MB 返された行: 1

SELECT `template`

  FROM `gi2yc_template_styles`

  WHERE `client_id` = '0' 
  AND `home` = '1'

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gi2yc_template_styles	ref	idx_home	idx_home	28	const	2	Using where

プロファイル

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/helper.php:32
12	SppagebuilderHelperSite::getTemplate()	JROOT/components/com_sppagebuilder/helpers/helper.php:19
11	SppagebuilderHelperSite::loadLanguage()	JROOT/components/com_sppagebuilder/views/page/view.html.php:42
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.38 ms 最後のクエリ以降: 57.87 ms クエリメモリ: 0.026 MB Memory before query: 4.144 MB 返された行: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM gi2yc_modules AS m

  WHERE m.published = 1 
  AND m.id = 120 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-05-24 19:26:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-05-24 19:26:04') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 0.83 ms 最後のクエリ以降: 2.69 ms クエリメモリ: 0.026 MB Memory before query: 4.168 MB 返された行: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM gi2yc_modules AS m

  WHERE m.published = 1 
  AND m.id = 111 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-05-24 19:26:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-05-24 19:26:04') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 0.81 ms 最後のクエリ以降: 2.66 ms クエリメモリ: 0.025 MB Memory before query: 4.193 MB 返された行: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM gi2yc_modules AS m

  WHERE m.published = 1 
  AND m.id = 114 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-05-24 19:26:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-05-24 19:26:04') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

プロファイル

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

クエリ時間: 1.97 ms 最後のクエリ以降: 53.87 ms クエリメモリ: 0.025 MB Memory before query: 4.502 MB 返された行: 10

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM gi2yc_modules AS m

  LEFT JOIN gi2yc_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN gi2yc_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-05-24 19:26:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-05-24 19:26:04') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0 
  AND (mm.menuid = 437 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

説明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	30	Using where; filesortレコードの使用
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sakurabayukiko_rakugo.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sakurabayukiko_rakugo.m.module,const	1	Using where

プロファイル

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

コールスタック

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	下の行にあるコールと同じです。
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:502
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:458
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:222
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:158
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。]

21クエリの種類を出現頻度順でログに記録しました。

テーブルの選択:

3 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM gi2yc_modules AS m

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `gi2yc_extensions`

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM gi2yc_sppagebuilder as a 
  LEFT JOIN `gi2yc_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN gi2yc_users AS ua 
  ON ua.id = a.created_by

1 × SELECT a.rules 
  FROM gi2yc_assets AS a

1 × SELECT * 
  FROM gi2yc_sppagebuilder

1 × SELECT `template` 
  FROM `gi2yc_template_styles`

```
1 × SELECT * 
  FROM gi2yc_assets
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM gi2yc_modules AS m 
  LEFT JOIN gi2yc_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN gi2yc_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM gi2yc_languages
```

1 × SELECT b.id 
  FROM gi2yc_usergroups AS a 
  LEFT JOIN gi2yc_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `session_id` 
  FROM `gi2yc_session`

1 × SELECT id, rules 
  FROM `gi2yc_viewlevels

1 × SELECT folder AS type, element AS name, params 
  FROM gi2yc_extensions

1 × SELECT `data` 
  FROM `gi2yc_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM gi2yc_menu AS m 
  LEFT JOIN gi2yc_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, home, template, s.params 
  FROM gi2yc_template_styles as s 
  LEFT JOIN gi2yc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

その他のテーブル:

1 × UPDATE gi2yc_sppagebuilder 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `gi2yc_sppagebuilder

1 × SHOW FULL COLUMNS 
  FROM `gi2yc_assets

1 × UPDATE `gi2yc_extensions` 
  SET `params` = '{\"mediaversion\":\"6c43aa0ec6e4bb17d8be19868a4097dc\"}'

1 × INSERT INTO `gi2yc_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('41fd0381d484d4649d5741fa47480a92', 0, 1, '1495653964', 0, ''