(common) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `brands`771
(default) 16 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `categories`16161
2DESCRIBE `items`11111
3DESCRIBE `tags`991
4DESCRIBE `items_tags`331
5SELECT `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 1001
6SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'e3hni3phig4j8tbntji2h12sa7'001
7SELECT `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 1000
8SELECT `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` 000
9SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '10' ORDER BY `Tag`.`id` ASC 000
10SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '20' ORDER BY `Tag`.`id` ASC 000
11SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '30' ORDER BY `Tag`.`id` ASC 000
12SELECT Tag.name, Tag.weight FROM `tags` AS `Tag` WHERE `tag_group` = '40' ORDER BY `Tag`.`id` ASC 000
13SELECT 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` 000
14SELECT `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 20000
15SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'e3hni3phig4j8tbntji2h12sa7'111
16INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:4:{s:9:\"userAgent\";s:32:\"9fed58a7df07e6f94ba400ed0dd5480e\";s:4:\"time\";i:1268298764;s:4:\"rand\";i:1669776370;s:7:\"timeout\";i:10;}', 1268298764, 'e3hni3phig4j8tbntji2h12sa7')11