2channel2.blog32.fc2.comのレシピ人気順一覧

5 queries took 3402 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1	1	1	0
2	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `date` = '2009-01-10' ORDER BY `Log`.`count` DESC LIMIT 30	30	30	0
3	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE 1 = 1 ORDER BY `Log`.`modified` DESC LIMIT 30	30	30	3402
4	SELECT `Recipe`.`id`, `Recipe`.`eid`, `Recipe`.`url`, `Recipe`.`title`, `Recipe`.`users`, `Recipe`.`tag`, `Recipe`.`tag_orig`, `Recipe`.`description`, `Recipe`.`date`, `Recipe`.`created`, `Recipe`.`modified` FROM `recipes` AS `Recipe` WHERE `url` LIKE 'http://2channel2.blog32.fc2.com%' ORDER BY `Recipe`.`users` DESC LIMIT 25	6	6	0
5	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `url` LIKE 'http://2channel2.blog32.fc2.com%'	1	1	0

5 queries took 3402 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1

SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `date` = '2009-01-10' ORDER BY `Log`.`count` DESC LIMIT 30

SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE 1 = 1 ORDER BY `Log`.`modified` DESC LIMIT 30

3402

SELECT `Recipe`.`id`, `Recipe`.`eid`, `Recipe`.`url`, `Recipe`.`title`, `Recipe`.`users`, `Recipe`.`tag`, `Recipe`.`tag_orig`, `Recipe`.`description`, `Recipe`.`date`, `Recipe`.`created`, `Recipe`.`modified` FROM `recipes` AS `Recipe` WHERE `url` LIKE 'http://2channel2.blog32.fc2.com%' ORDER BY `Recipe`.`users` DESC LIMIT 25

SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `url` LIKE 'http://2channel2.blog32.fc2.com%'