| 1 | SHOW FULL COLUMNS FROM `products` | | 39 | 39 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `categories` | | 5 | 5 | 0 |
| 4 | SHOW FULL COLUMNS FROM `ratings` | | 8 | 8 | 0 |
| 5 | SHOW FULL COLUMNS FROM `order_details` | | 9 | 9 | 0 |
| 6 | SHOW FULL COLUMNS FROM `orders` | | 41 | 41 | 1 |
| 7 | SHOW FULL COLUMNS FROM `members` | | 52 | 52 | 1 |
| 8 | SHOW FULL COLUMNS FROM `member_billing_informations` | | 13 | 13 | 1 |
| 9 | SHOW FULL COLUMNS FROM `member_shipping_informations` | | 13 | 13 | 1 |
| 10 | SHOW FULL COLUMNS FROM `inventories` | | 8 | 8 | 1 |
| 11 | SELECT `Inventory`.* FROM `inventories` AS `Inventory` WHERE 1 = 1 LIMIT 1 | | 0 | 0 | 0 |
| 12 | SHOW FULL COLUMNS FROM `site_ratings` | | 7 | 7 | 0 |
| 13 | SELECT `SiteRating`.* FROM `site_ratings` AS `SiteRating` WHERE `SiteRating`.`is_active` = 1 | | 0 | 0 | 0 |
| 14 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `categories` AS `Category` WHERE `is_active` = 'Y' | | 20 | 20 | 0 |
| 15 | SHOW FULL COLUMNS FROM `stores` | | 47 | 47 | 1 |
| 16 | SELECT `Store`.`id`, `Store`.`store_name`, `Store`.`store_url`, `Store`.`contact_name`, `Store`.`sales_representative`, `Store`.`email_address`, `Store`.`username`, `Store`.`password`, `Store`.`package_id`, `Store`.`package_name`, `Store`.`storage_space`, `Store`.`number_of_products`, `Store`.`package_price`, `Store`.`package_setup_fee`, `Store`.`template_package`, `Store`.`template_id`, `Store`.`template_package_price`, `Store`.`design_package_id`, `Store`.`design_package`, `Store`.`design_package_price`, `Store`.`active_ssl`, `Store`.`active_seo`, `Store`.`payment_gateway_id`, `Store`.`sales_tax_percentage`, `Store`.`tax_shipping`, `Store`.`currency`, `Store`.`sales_email`, `Store`.`support_email`, `Store`.`store_info_email`, `Store`.`billing_address`, `Store`.`billing_city`, `Store`.`state_id`, `Store`.`billing_zip`, `Store`.`country_id`, `Store`.`billing_phone`, `Store`.`promo_code`, `Store`.`payable_amount`, `Store`.`session_time_out`, `Store`.`company_logo`, `Store`.`company_slogan`, `Store`.`creation_date`, `Store`.`expiration_date`, `Store`.`active`, `Store`.`expired`, `Store`.`is_paid`, `Store`.`invoice_number`, `Store`.`estimate_number` FROM `stores` AS `Store` WHERE `Store`.`id` = 1 | | 1 | 1 | 0 |
| 17 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 18 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 19 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 20 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 | | 1 | 1 | 0 |
| 21 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 22 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 | | 1 | 1 | 0 |
| 23 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 24 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 25 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 | | 1 | 1 | 0 |
| 26 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 27 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 4 | | 1 | 1 | 0 |
| 28 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 29 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 30 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 31 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 7 | | 1 | 1 | 0 |
| 32 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 33 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 34 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 7 | | 1 | 1 | 0 |
| 35 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 36 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 37 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 38 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 0 |
| 39 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 40 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 0 |
| 41 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 42 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 0 |
| 43 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 44 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 45 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 0 |
| 46 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 47 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 1 |
| 48 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 49 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 | | 1 | 1 | 1 |
| 50 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 51 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 1 |
| 52 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 53 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 54 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 55 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 56 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 57 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 58 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 59 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 60 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 61 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 62 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 63 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 64 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 65 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 1 |
| 66 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 67 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 68 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 69 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 70 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 71 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 72 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 73 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 74 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 75 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 76 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 14 | | 1 | 1 | 0 |
| 77 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 78 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 79 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 80 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 81 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 82 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 83 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 84 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 85 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 86 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 87 | SELECT `Category`.`id`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`id` = 0 | | 0 | 0 | 0 |
| 88 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 0 |
| 89 | SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat` FROM `categories` AS `Category` WHERE `Category`.`is_active` = 'Y' | | 20 | 20 | 1 |
| 90 | SHOW FULL COLUMNS FROM `static_pages` | | 5 | 5 | 0 |
| 91 | SELECT `StaticPage`.`id`, `StaticPage`.`page_title` FROM `static_pages` AS `StaticPage` WHERE `StaticPage`.`is_active` = 'Y' | | 7 | 7 | 0 |
| 92 | SELECT `Product`.`id`, `Product`.`type`, `Product`.`account_id`, `Product`.`sku`, `Product`.`upc`, `Product`.`product_name`, `Product`.`image`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`description`, `Product`.`is_featured`, `Product`.`is_hot_offer`, `Product`.`category_id`, `Product`.`start_qty`, `Product`.`current_qty`, `Product`.`price_information`, `Product`.`price`, `Product`.`cost`, `Product`.`downloadable_product`, `Product`.`weight`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`display_dimension`, `Product`.`tax_information`, `Product`.`max_qty`, `Product`.`retail_min_qty`, `Product`.`retail_max_qty`, `Product`.`wholesale_min_qty`, `Product`.`wholesale_max_qty`, `Product`.`shipping_preferences`, `Product`.`fixed_domestic_amount`, `Product`.`fixed_international_amount`, `Product`.`handling_fee`, `Product`.`ships_separately`, `Product`.`product_options`, `Product`.`modify_date`, `Product`.`active`, `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE `is_featured` = 'Y' ORDER BY `Product`.`id` DESC | | 11 | 11 | 0 |
| 93 | SELECT COUNT(*) AS `count` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE 1 = 1 | | 1 | 1 | 0 |
| 94 | SELECT `Product`.`id`, `Product`.`type`, `Product`.`account_id`, `Product`.`sku`, `Product`.`upc`, `Product`.`product_name`, `Product`.`image`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`description`, `Product`.`is_featured`, `Product`.`is_hot_offer`, `Product`.`category_id`, `Product`.`start_qty`, `Product`.`current_qty`, `Product`.`price_information`, `Product`.`price`, `Product`.`cost`, `Product`.`downloadable_product`, `Product`.`weight`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`display_dimension`, `Product`.`tax_information`, `Product`.`max_qty`, `Product`.`retail_min_qty`, `Product`.`retail_max_qty`, `Product`.`wholesale_min_qty`, `Product`.`wholesale_max_qty`, `Product`.`shipping_preferences`, `Product`.`fixed_domestic_amount`, `Product`.`fixed_international_amount`, `Product`.`handling_fee`, `Product`.`ships_separately`, `Product`.`product_options`, `Product`.`modify_date`, `Product`.`active`, `Category`.`id`, `Category`.`category_name`, `Category`.`parent_cat`, `Category`.`is_active`, `Category`.`last_updated` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY `Product`.`modify_date` DESC LIMIT 6 | | 6 | 6 | 0 |
.gif)
