アプリケーション

7 queries took 0 ms
Nr	Query	Affected	Num. rows
1	DESCRIBE `ASP_categories`	4	4
2	DESCRIBE `ASP_configs`	13	13
3	SELECT `Config`.`modified` FROM `ASP_configs` AS `Config` WHERE id=1 LIMIT 1	1	1
4	SELECT `Config`.`id`, `Config`.`siteName`, `Config`.`siteUrl`, `Config`.`theme`, `Config`.`thumbSize`, `Config`.`thumbType`, `Config`.`updateNews`, `Config`.`moderateComment`, `Config`.`commentNotification`, `Config`.`timezone`, `Config`.`filmstripCount`, `Config`.`created`, `Config`.`modified` FROM `ASP_configs` AS `Config` WHERE id=1 LIMIT 1	1	1
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `Category`.`description` FROM `ASP_categories` AS `Category` WHERE `Category`.`id` = 2 LIMIT 1	1	1
6	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `Category`.`description` FROM `ASP_categories` AS `Category` WHERE parent = 2	30	30
7	SELECT Script.id,Script.title,Script.created FROM ASP_scripts Script, ASP_categories cats WHERE Script.category_id = cats.id AND cats.id = 2 ORDER BY Script.created DESC LIMIT 0, 50	0	0

7 queries took 0 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `ASP_categories`

DESCRIBE `ASP_configs`

SELECT `Config`.`modified` FROM `ASP_configs` AS `Config` WHERE id=1 LIMIT 1

SELECT `Config`.`id`, `Config`.`siteName`, `Config`.`siteUrl`, `Config`.`theme`, `Config`.`thumbSize`, `Config`.`thumbType`, `Config`.`updateNews`, `Config`.`moderateComment`, `Config`.`commentNotification`, `Config`.`timezone`, `Config`.`filmstripCount`, `Config`.`created`, `Config`.`modified` FROM `ASP_configs` AS `Config` WHERE id=1 LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `Category`.`description` FROM `ASP_categories` AS `Category` WHERE `Category`.`id` = 2 LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `Category`.`description` FROM `ASP_categories` AS `Category` WHERE parent = 2

SELECT Script.id,Script.title,Script.created FROM ASP_scripts Script, ASP_categories cats WHERE Script.category_id = cats.id AND cats.id = 2 ORDER BY Script.created DESC LIMIT 0, 50

アプリケーション - ASP入門講座3

アプリケーション

目的別索引