| 1 | DESCRIBE `products` | | 72 | 72 | 2 |
| 2 | DESCRIBE `brands` | | 9 | 9 | 1 |
| 3 | DESCRIBE `product_categories` | | 13 | 13 | 1 |
| 4 | DESCRIBE `products_related_items` | | 3 | 3 | 1 |
| 5 | DESCRIBE `pages` | | 16 | 16 | 1 |
| 6 | DESCRIBE `articles` | | 15 | 15 | 1 |
| 7 | DESCRIBE `images` | | 6 | 6 | 1 |
| 8 | DESCRIBE `modifiedcar_categories` | | 13 | 13 | 1 |
| 9 | DESCRIBE `modifiedcars` | | 9 | 9 | 1 |
| 10 | SELECT `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 | | 5 | 5 | 1 |
| 11 | SELECT `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 | | 3 | 3 | 0 |
| 12 | SELECT `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 | | 0 | 0 | 0 |
| 13 | SELECT `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 | | 0 | 0 | 0 |
| 14 | SELECT `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 | | 0 | 0 | 0 |
| 15 | SELECT `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 | | 0 | 0 | 0 |
| 16 | SELECT `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 | | 0 | 0 | 0 |
| 17 | SELECT `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 | | 0 | 0 | 0 |
| 18 | SELECT `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 | | 0 | 0 | 0 |
| 19 | SELECT `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 | | 0 | 0 | 0 |
| 20 | SELECT `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' | | 5 | 5 | 0 |
| 21 | SELECT `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 1 | | 1 | 1 | 0 |
| 22 | SELECT `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 1 | | 1 | 1 | 0 |
| 23 | SELECT `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 1 | | 0 | 0 | 0 |
| 24 | SELECT `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` = 1280 AND `Product`.`product_status` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 25 | SELECT `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` = 1280 AND `ProductRelatedItem`.`related_item_id` = `RelatedItem`.`id`) | | 0 | 0 | 1 |
| 26 | SELECT `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 | | 1 | 1 | 0 |