傘機及傘架
<上一頁下一頁>
<上一頁下一頁>
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `product_categories` | 13 | 13 | 1 | |
| 2 | DESCRIBE `products` | 72 | 72 | 2 | |
| 3 | DESCRIBE `brands` | 9 | 9 | 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 `ProductCategory`.`id` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`category_url` = '_3' LIMIT 1 | 1 | 1 | 0 | |
| 25 | SELECT `ProductCategory`.`category_name`, `ProductCategory`.`category_title`, `ProductCategory`.`category_meta_keywords`, `ProductCategory`.`category_meta_description`, `ProductCategory`.`category_image` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 195 LIMIT 1 | 1 | 1 | 0 | |
| 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 | |
| 27 | SELECT COUNT(*) AS `count` 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`.`product_category_id` = 195 AND `Product`.`product_status` = 1 | 1 | 1 | 1 | |
| 28 | 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`.`product_category_id` = 195 AND `Product`.`product_status` = 1 ORDER BY `Product`.`product_order` ASC, `Product`.`product_name` ASC LIMIT 20 | 14 | 14 | 4 |