オーディオ通販比較館　売れ筋ランキング

「オーディオ通販比較館　売れ筋ランキング」をオープンしました。
オーディオを探すなら、オーディオ通販比較館　売れ筋ランキングにおまかせください！

価格帯

割引率

(common) 1 query took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `brands`		7	7	1

(common) 1 query took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `brands`

(default) 16 queries took 8 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `categories`	16	16	1
2	DESCRIBE `items`	11	11	1
3	DESCRIBE `tags`	9	9	1
4	DESCRIBE `items_tags`	3	3	1
5	SELECT `SiteSetting`.`id`, `SiteSetting`.`keyword`, `SiteSetting`.`title`, `SiteSetting`.`title_suffix`, `SiteSetting`.`sub_title`, `SiteSetting`.`title_separator`, `SiteSetting`.`meta_keywords`, `SiteSetting`.`meta_description`, `SiteSetting`.`description_suffix`, `SiteSetting`.`footer`, `SiteSetting`.`company_name_ja`, `SiteSetting`.`company_name_en`, `SiteSetting`.`company_address`, `SiteSetting`.`company_url`, `SiteSetting`.`president_name_ja`, `SiteSetting`.`president_name_en`, `SiteSetting`.`business1`, `SiteSetting`.`business2`, `SiteSetting`.`business3`, `SiteSetting`.`brand_id`, `SiteSetting`.`category_id`, `SiteSetting`.`is_growing`, `SiteSetting`.`is_seo`, `SiteSetting`.`is_ext_html`, `SiteSetting`.`is_maintenance`, `SiteSetting`.`analytics`, `SiteSetting`.`contact_email`, `SiteSetting`.`google_maps_key`, `SiteSetting`.`yahoo_app_id`, `SiteSetting`.`vc_yahoo_sid`, `SiteSetting`.`vc_yahoo_pid`, `SiteSetting`.`amazon_associate_id`, `SiteSetting`.`amazon_access_key_id`, `SiteSetting`.`youtube_dev_id`, `SiteSetting`.`yahoo_topics_category`, `SiteSetting`.`created`, `SiteSetting`.`modified` FROM `site_settings` AS `SiteSetting` WHERE `SiteSetting`.`id` = 1 LIMIT 1	1	1	1
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '1itoedm37b3d25ui66napdjrh2'	0	0	1
7	SELECT `Tag`.`id`, `Tag`.`tag_group`, `Tag`.`name`, `Tag`.`name_en`, `Tag`.`short_name`, `Tag`.`options`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE `Tag`.`name` = '' LIMIT 1	0	0	0
8	SELECT `Item`.`name`, `Item`.`price`, `Item`.`price_range`, `Item`.`off_rate`, count(`Item`.`name`) AS num FROM `items_tags` AS `ItemsTag` LEFT JOIN `items` AS `Item` ON (`ItemsTag`.`item_id` = `Item`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`name`	0	0	0
9	SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '10' ORDER BY `Tag`.`id` ASC	0	0	0
10	SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '20' ORDER BY `Tag`.`id` ASC	0	0	0
11	SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '30' ORDER BY `Tag`.`id` ASC	0	0	0
12	SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '40' ORDER BY `Tag`.`id` ASC	0	0	0
13	SELECT COUNT(*) AS `count` FROM `items` AS `Item` LEFT JOIN items_tags AS `ItemsTag` ON (`Item`.`id` = `ItemsTag`.`item_id`) LEFT JOIN tags AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`id`	0	0	0
14	SELECT `Item`.`id`, `Item`.`url`, `Item`.`category`, `Item`.`brand`, `Item`.`name`, `Item`.`price`, `Item`.`price_range`, `Item`.`off_rate`, `Item`.`value`, `Item`.`created`, `Item`.`modified` FROM `items` AS `Item` LEFT JOIN items_tags AS `ItemsTag` ON (`Item`.`id` = `ItemsTag`.`item_id`) LEFT JOIN tags AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`id` ORDER BY `Item`.`name` ASC LIMIT 20	0	0	0
15	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '1itoedm37b3d25ui66napdjrh2'	1	1	1
16	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:4:{s:9:\"userAgent\";s:32:\"9fed58a7df07e6f94ba400ed0dd5480e\";s:4:\"time\";i:1268323040;s:4:\"rand\";i:2047131716;s:7:\"timeout\";i:10;}', 1268323040, '1itoedm37b3d25ui66napdjrh2')	1		1

(default) 16 queries took 8 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `categories`

DESCRIBE `items`

DESCRIBE `tags`

DESCRIBE `items_tags`

SELECT `SiteSetting`.`id`, `SiteSetting`.`keyword`, `SiteSetting`.`title`, `SiteSetting`.`title_suffix`, `SiteSetting`.`sub_title`, `SiteSetting`.`title_separator`, `SiteSetting`.`meta_keywords`, `SiteSetting`.`meta_description`, `SiteSetting`.`description_suffix`, `SiteSetting`.`footer`, `SiteSetting`.`company_name_ja`, `SiteSetting`.`company_name_en`, `SiteSetting`.`company_address`, `SiteSetting`.`company_url`, `SiteSetting`.`president_name_ja`, `SiteSetting`.`president_name_en`, `SiteSetting`.`business1`, `SiteSetting`.`business2`, `SiteSetting`.`business3`, `SiteSetting`.`brand_id`, `SiteSetting`.`category_id`, `SiteSetting`.`is_growing`, `SiteSetting`.`is_seo`, `SiteSetting`.`is_ext_html`, `SiteSetting`.`is_maintenance`, `SiteSetting`.`analytics`, `SiteSetting`.`contact_email`, `SiteSetting`.`google_maps_key`, `SiteSetting`.`yahoo_app_id`, `SiteSetting`.`vc_yahoo_sid`, `SiteSetting`.`vc_yahoo_pid`, `SiteSetting`.`amazon_associate_id`, `SiteSetting`.`amazon_access_key_id`, `SiteSetting`.`youtube_dev_id`, `SiteSetting`.`yahoo_topics_category`, `SiteSetting`.`created`, `SiteSetting`.`modified` FROM `site_settings` AS `SiteSetting` WHERE `SiteSetting`.`id` = 1 LIMIT 1

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '1itoedm37b3d25ui66napdjrh2'

SELECT `Tag`.`id`, `Tag`.`tag_group`, `Tag`.`name`, `Tag`.`name_en`, `Tag`.`short_name`, `Tag`.`options`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE `Tag`.`name` = '' LIMIT 1

SELECT `Item`.`name`, `Item`.`price`, `Item`.`price_range`, `Item`.`off_rate`, count(`Item`.`name`) AS num FROM `items_tags` AS `ItemsTag` LEFT JOIN `items` AS `Item` ON (`ItemsTag`.`item_id` = `Item`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`name`

SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '10' ORDER BY `Tag`.`id` ASC

SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '20' ORDER BY `Tag`.`id` ASC

SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '30' ORDER BY `Tag`.`id` ASC

SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '40' ORDER BY `Tag`.`id` ASC

SELECT COUNT(*) AS `count` FROM `items` AS `Item` LEFT JOIN items_tags AS `ItemsTag` ON (`Item`.`id` = `ItemsTag`.`item_id`) LEFT JOIN tags AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`id`

SELECT `Item`.`id`, `Item`.`url`, `Item`.`category`, `Item`.`brand`, `Item`.`name`, `Item`.`price`, `Item`.`price_range`, `Item`.`off_rate`, `Item`.`value`, `Item`.`created`, `Item`.`modified` FROM `items` AS `Item` LEFT JOIN items_tags AS `ItemsTag` ON (`Item`.`id` = `ItemsTag`.`item_id`) LEFT JOIN tags AS `Tag` ON (`ItemsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Item`.`id` ORDER BY `Item`.`name` ASC LIMIT 20

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '1itoedm37b3d25ui66napdjrh2'

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:4:{s:9:\"userAgent\";s:32:\"9fed58a7df07e6f94ba400ed0dd5480e\";s:4:\"time\";i:1268323040;s:4:\"rand\";i:2047131716;s:7:\"timeout\";i:10;}', 1268323040, '1itoedm37b3d25ui66napdjrh2')

激安価格！おすすめオーディオランキング

価格帯

割引率