(default) 26 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `products`72722
2DESCRIBE `brands`991
3DESCRIBE `product_categories`13131
4DESCRIBE `products_related_items`331
5DESCRIBE `pages`16161
6DESCRIBE `articles`15151
7DESCRIBE `images`661
8DESCRIBE `modifiedcar_categories`13131
9DESCRIBE `modifiedcars`991
10SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_display_on_main_nav` = 1) AND (`Page`.`lang` = 'zh_TW')) AND ((`Page`.`page_parent_id` = 0) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC 551
11SELECT `ProductCategory`.`id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_url` FROM `product_categories` AS `ProductCategory` WHERE ((`ProductCategory`.`category_parent_id` = 0) AND (`ProductCategory`.`category_status` = 1) AND (`ProductCategory`.`lang` = 'zh_TW')) ORDER BY `ProductCategory`.`category_order` ASC, `ProductCategory`.`category_name` ASC 330
12SELECT `ProductCategory`.`id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_url` FROM `product_categories` AS `ProductCategory` WHERE ((`ProductCategory`.`category_parent_id` = 197) AND (`ProductCategory`.`category_status` = 1) AND (`ProductCategory`.`lang` = 'zh_TW')) ORDER BY `ProductCategory`.`category_order` ASC, `ProductCategory`.`category_name` ASC 000
13SELECT `ProductCategory`.`id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_url` FROM `product_categories` AS `ProductCategory` WHERE ((`ProductCategory`.`category_parent_id` = 195) AND (`ProductCategory`.`category_status` = 1) AND (`ProductCategory`.`lang` = 'zh_TW')) ORDER BY `ProductCategory`.`category_order` ASC, `ProductCategory`.`category_name` ASC 000
14SELECT `ProductCategory`.`id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_url` FROM `product_categories` AS `ProductCategory` WHERE ((`ProductCategory`.`category_parent_id` = 193) AND (`ProductCategory`.`category_status` = 1) AND (`ProductCategory`.`lang` = 'zh_TW')) ORDER BY `ProductCategory`.`category_order` ASC, `ProductCategory`.`category_name` ASC 000
15SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_parent_id` = 24) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC, `Page`.`page_name` ASC 000
16SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_parent_id` = 22) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC, `Page`.`page_name` ASC 000
17SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_parent_id` = 23) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC, `Page`.`page_name` ASC 000
18SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_parent_id` = 27) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC, `Page`.`page_name` ASC 000
19SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE ((`Page`.`page_parent_id` = 29) AND (`Page`.`page_status` = 1)) ORDER BY `Page`.`page_order` ASC, `Page`.`page_name` ASC 000
20SELECT `Page`.`id`, `Page`.`page_name`, `Page`.`page_url` FROM `pages` AS `Page` WHERE `Page`.`page_display_on_footer` = 1 AND `Page`.`page_parent_id` = 0 AND `Page`.`page_status` = 1 AND `Page`.`lang` = 'zh_TW' 550
21SELECT `Article`.`article_name`, `Article`.`article_brief_content`, `Article`.`article_url` FROM `articles` AS `Article` WHERE `Article`.`article_status` = 1 AND `Article`.`lang` = 'zh_TW' ORDER BY `Article`.`article_published` DESC, `Article`.`article_name` ASC LIMIT 1112
22SELECT `Article`.`article_name`, `Article`.`article_brief_content`, `Article`.`article_url` FROM `articles` AS `Article` WHERE `Article`.`article_status` = 1 AND `Article`.`lang` = 'zh_TW' ORDER BY `Article`.`article_published` DESC, `Article`.`article_name` ASC LIMIT 1110
23SELECT `Image`.`id`, `Image`.`image_name`, `Image`.`image_path`, `Image`.`link`, `Image`.`lang`, `Image`.`mark_as_top_banner` FROM `images` AS `Image` WHERE `mark_as_top_banner` = 'Y' AND `lang` = 'zh_TW' LIMIT 1000
24SELECT `Product`.`id`, `Product`.`product_category_id`, `Product`.`product_name`, `Product`.`product_brand_id`, `Product`.`sold_out`, `Product`.`was_price`, `Product`.`now_price`, `Product`.`product_code`, `Product`.`product_meta_keywords`, `Product`.`product_meta_description`, `Product`.`product_description`, `Product`.`product_thumbnail_image`, `Product`.`product_large_image`, `Product`.`product_vic`, `Product`.`product_nsw`, `Product`.`product_wa`, `Product`.`product_sa`, `Product`.`product_act`, `Product`.`product_qld`, `Product`.`product_nt`, `Product`.`product_tas`, `Product`.`product_int`, `Product`.`product_order`, `Product`.`product_status`, `Product`.`product_url`, `Product`.`hkd_was_price`, `Product`.`weight`, `Product`.`hkd_now_price`, `Product`.`lang`, `Product`.`taobao_url`, `Product`.`product_anhui`, `Product`.`product_beijing`, `Product`.`product_chongqing`, `Product`.`product_fujian`, `Product`.`product_gansu`, `Product`.`product_guangdong`, `Product`.`product_guangxi`, `Product`.`product_guizhou`, `Product`.`product_hainan`, `Product`.`product_hebei`, `Product`.`product_heilongjiang`, `Product`.`product_henan`, `Product`.`product_hubei`, `Product`.`product_hunan`, `Product`.`product_jiangsu`, `Product`.`product_jiangxi`, `Product`.`product_jilin`, `Product`.`product_liaoning`, `Product`.`product_macau`, `Product`.`product_ningxia`, `Product`.`product_qinghai`, `Product`.`product_shandong`, `Product`.`product_shanxi`, `Product`.`product_shanghai`, `Product`.`product_sichuan`, `Product`.`product_taiwan`, `Product`.`product_tianjin`, `Product`.`product_yunnan`, `Product`.`product_zhejiang`, `Product`.`product_tibet`, `Product`.`product_sinkiang`, `Product`.`product_hong_Kong`, `Product`.`product_inner_Mongol`, `Product`.`default_shipping_cost_checkbox`, `Product`.`default_shipping_cost`, `Product`.`product_thumbnail_image_3`, `Product`.`product_thumbnail_image_2`, `Product`.`product_large_image_2`, `Product`.`product_large_image_3`, `Product`.`default_shipping_cost_2_checkbox`, `Product`.`default_shipping_cost_2`, `Product`.`display_price`, `Brand`.`id`, `Brand`.`brand_name`, `Brand`.`brand_title`, `Brand`.`brand_meta_keywords`, `Brand`.`brand_meta_description`, `Brand`.`brand_status`, `Brand`.`brand_logo`, `Brand`.`brand_url`, `Brand`.`brand_order`, `ProductCategory`.`id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_title`, `ProductCategory`.`category_meta_keywords`, `ProductCategory`.`category_meta_description`, `ProductCategory`.`category_description`, `ProductCategory`.`category_parent_id`, `ProductCategory`.`category_order`, `ProductCategory`.`category_status`, `ProductCategory`.`category_image`, `ProductCategory`.`category_url`, `ProductCategory`.`flickr_setid`, `ProductCategory`.`lang` FROM `products` AS `Product` LEFT JOIN `brands` AS `Brand` ON (`Product`.`product_brand_id` = `Brand`.`id`) LEFT JOIN `product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`id` = 1145 AND `Product`.`product_status` = 1 LIMIT 1111
25SELECT `RelatedItem`.`id`, `RelatedItem`.`product_category_id`, `RelatedItem`.`product_name`, `RelatedItem`.`product_brand_id`, `RelatedItem`.`sold_out`, `RelatedItem`.`was_price`, `RelatedItem`.`now_price`, `RelatedItem`.`product_code`, `RelatedItem`.`product_meta_keywords`, `RelatedItem`.`product_meta_description`, `RelatedItem`.`product_description`, `RelatedItem`.`product_thumbnail_image`, `RelatedItem`.`product_large_image`, `RelatedItem`.`product_vic`, `RelatedItem`.`product_nsw`, `RelatedItem`.`product_wa`, `RelatedItem`.`product_sa`, `RelatedItem`.`product_act`, `RelatedItem`.`product_qld`, `RelatedItem`.`product_nt`, `RelatedItem`.`product_tas`, `RelatedItem`.`product_int`, `RelatedItem`.`product_order`, `RelatedItem`.`product_status`, `RelatedItem`.`product_url`, `RelatedItem`.`hkd_was_price`, `RelatedItem`.`weight`, `RelatedItem`.`hkd_now_price`, `RelatedItem`.`lang`, `RelatedItem`.`taobao_url`, `RelatedItem`.`product_anhui`, `RelatedItem`.`product_beijing`, `RelatedItem`.`product_chongqing`, `RelatedItem`.`product_fujian`, `RelatedItem`.`product_gansu`, `RelatedItem`.`product_guangdong`, `RelatedItem`.`product_guangxi`, `RelatedItem`.`product_guizhou`, `RelatedItem`.`product_hainan`, `RelatedItem`.`product_hebei`, `RelatedItem`.`product_heilongjiang`, `RelatedItem`.`product_henan`, `RelatedItem`.`product_hubei`, `RelatedItem`.`product_hunan`, `RelatedItem`.`product_jiangsu`, `RelatedItem`.`product_jiangxi`, `RelatedItem`.`product_jilin`, `RelatedItem`.`product_liaoning`, `RelatedItem`.`product_macau`, `RelatedItem`.`product_ningxia`, `RelatedItem`.`product_qinghai`, `RelatedItem`.`product_shandong`, `RelatedItem`.`product_shanxi`, `RelatedItem`.`product_shanghai`, `RelatedItem`.`product_sichuan`, `RelatedItem`.`product_taiwan`, `RelatedItem`.`product_tianjin`, `RelatedItem`.`product_yunnan`, `RelatedItem`.`product_zhejiang`, `RelatedItem`.`product_tibet`, `RelatedItem`.`product_sinkiang`, `RelatedItem`.`product_hong_Kong`, `RelatedItem`.`product_inner_Mongol`, `RelatedItem`.`default_shipping_cost_checkbox`, `RelatedItem`.`default_shipping_cost`, `RelatedItem`.`product_thumbnail_image_3`, `RelatedItem`.`product_thumbnail_image_2`, `RelatedItem`.`product_large_image_2`, `RelatedItem`.`product_large_image_3`, `RelatedItem`.`default_shipping_cost_2_checkbox`, `RelatedItem`.`default_shipping_cost_2`, `RelatedItem`.`display_price`, `ProductRelatedItem`.`id`, `ProductRelatedItem`.`product_id`, `ProductRelatedItem`.`related_item_id` FROM `products` AS `RelatedItem` JOIN `products_related_items` AS `ProductRelatedItem` ON (`ProductRelatedItem`.`product_id` = 1145 AND `ProductRelatedItem`.`related_item_id` = `RelatedItem`.`id`) 000
26SELECT `ProductCategory`.`id`, `ProductCategory`.`category_parent_id`, `ProductCategory`.`category_name`, `ProductCategory`.`category_url` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`category_status` = 1 AND `ProductCategory`.`id` = 195 110