1 | SHOW FULL COLUMNS FROM `ck_posts` | | 13 | 13 | 5 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
3 | SHOW FULL COLUMNS FROM `ck_images` | | 9 | 9 | 4 |
4 | SHOW FULL COLUMNS FROM `ck_post_comments` | | 9 | 9 | 3 |
5 | SHOW FULL COLUMNS FROM `ck_contacts` | | 14 | 14 | 3 |
6 | SHOW FULL COLUMNS FROM `ck_redirects` | | 5 | 5 | 3 |
7 | SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/news/it-s-nearly-wine-fair-time-and-we-have-tickets-to-give-away' LIMIT 1 | | 0 | 0 | 0 |
8 | SHOW FULL COLUMNS FROM `ck_users` | | 11 | 11 | 3 |
9 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`introduction`, `Post`.`body`, `Post`.`image_id`, `Post`.`post_date`, `Post`.`meta_title`, `Post`.`meta_description`, `Post`.`meta_keywords`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_posts` AS `Post` LEFT JOIN `ck_images` AS `Image` ON (`Post`.`image_id` = `Image`.`id`) WHERE `Post`.`slug` = 'it-s-nearly-wine-fair-time-and-we-have-tickets-to-give-away' AND `Post`.`status` = 'active' AND `Post`.`post_date` <= '2019-12-08 06:47:29' AND NOT (`Post`.`slug` = '') ORDER BY `Post`.`post_date` DESC, `Post`.`created` DESC LIMIT 1 | | 1 | 1 | 0 |
10 | SELECT `PostComment`.`id`, `PostComment`.`post_id`, `PostComment`.`author_id`, `PostComment`.`user_id`, `PostComment`.`comment`, `PostComment`.`status`, `PostComment`.`ip_address`, `PostComment`.`created`, `PostComment`.`modified` FROM `ck_post_comments` AS `PostComment` WHERE ((`PostComment`.`status` = 'approved') OR (((`PostComment`.`id` IS NULL) AND (`PostComment`.`status` = 'pending')))) AND `PostComment`.`post_id` = (142) | | 0 | 0 | 0 |
11 | SHOW FULL COLUMNS FROM `ck_baskets` | | 7 | 7 | 4 |
12 | SHOW FULL COLUMNS FROM `ck_store_countries` | | 11 | 11 | 3 |
13 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
14 | SHOW FULL COLUMNS FROM `ck_delivery_methods` | | 11 | 11 | 3 |
15 | SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods` | | 3 | 3 | 4 |
16 | SHOW FULL COLUMNS FROM `ck_basket_products` | | 8 | 8 | 3 |
17 | SHOW FULL COLUMNS FROM `ck_products` | | 22 | 22 | 3 |
18 | SHOW FULL COLUMNS FROM `ck_regions` | | 13 | 13 | 3 |
19 | SHOW FULL COLUMNS FROM `ck_producers` | | 6 | 6 | 4 |
20 | SHOW FULL COLUMNS FROM `ck_styles` | | 10 | 10 | 3 |
21 | SHOW FULL COLUMNS FROM `ck_bottles` | | 5 | 5 | 4 |
22 | SHOW FULL COLUMNS FROM `ck_product_ratings` | | 9 | 9 | 3 |
23 | SHOW FULL COLUMNS FROM `ck_store_customers` | | 7 | 7 | 4 |
24 | SHOW FULL COLUMNS FROM `ck_store_customer_addresses` | | 20 | 20 | 5 |
25 | SHOW FULL COLUMNS FROM `ck_grapes` | | 9 | 9 | 4 |
26 | SHOW FULL COLUMNS FROM `ck_grapes_products` | | 3 | 3 | 4 |
27 | SHOW FULL COLUMNS FROM `ck_product_types` | | 7 | 7 | 4 |
28 | SHOW FULL COLUMNS FROM `ck_product_types_products` | | 3 | 3 | 4 |
29 | SHOW FULL COLUMNS FROM `ck_offers` | | 7 | 7 | 4 |
30 | SHOW FULL COLUMNS FROM `ck_offers_products` | | 3 | 3 | 4 |
31 | SELECT `Basket`.`id`, `Basket`.`created`, `Basket`.`modified`, `Basket`.`delivery_method_id`, `Basket`.`delivery_country_id`, `Basket`.`delivery`, `Basket`.`subtotal`, (`Basket`.`delivery` + `Basket`.`subtotal`) AS `Basket__total`, `DeliveryCountry`.`id`, `DeliveryCountry`.`key`, `DeliveryCountry`.`iso`, `DeliveryCountry`.`iso3`, `DeliveryCountry`.`order`, `DeliveryCountry`.`country`, `DeliveryCountry`.`billing`, `DeliveryCountry`.`delivery`, `DeliveryCountry`.`status`, `DeliveryCountry`.`modified`, `DeliveryCountry`.`created`, `DeliveryMethod`.`id`, `DeliveryMethod`.`name`, `DeliveryMethod`.`price`, `DeliveryMethod`.`cap`, `DeliveryMethod`.`threshold`, `DeliveryMethod`.`threshold_price`, `DeliveryMethod`.`status`, `DeliveryMethod`.`modified`, `DeliveryMethod`.`created`, `DeliveryMethod`.`order`, `DeliveryMethod`.`code` FROM `ck_baskets` AS `Basket` LEFT JOIN `ck_store_countries` AS `DeliveryCountry` ON (`Basket`.`delivery_country_id` = `DeliveryCountry`.`id`) LEFT JOIN `ck_delivery_methods` AS `DeliveryMethod` ON (`Basket`.`delivery_method_id` = `DeliveryMethod`.`id`) WHERE `Basket`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
32 | SELECT `Region`.`name`, `Region`.`slug`, `Region`.`parent_id`, `Region`.`id`, `Region`.`modified`, `Region`.`created` FROM `ck_regions` AS `Region` WHERE `Region`.`status` = 'active' AND NOT (`Region`.`slug` = '') ORDER BY `Region`.`order` ASC | | 121 | 121 | 0 |
33 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`vintage`, `Product`.`region_id`, `Product`.`producer_id`, `Product`.`style_id`, `Product`.`bottle_id`, `Product`.`image_id`, `Product`.`bid`, `Product`.`best_seller`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`stock`, `Product`.`stock_description`, `Product`.`original_id`, (`Product`.`price`) AS `Product__original_price`, (LEAST(IFNULL((select min(`ck_offers`.`price`) from (ck_offers join ck_offers_products) where ((`ck_offers_products`.`product_id` = `Product`.`id`) and (`ck_offers_products`.`offer_id` = `ck_offers`.`id`) and (`ck_offers`.`start_date` <= now()) and (`ck_offers`.`end_date` >= now()))),`Product`.`price`),`Product`.`price`)) AS `Product__price`, (CONCAT(`Product`.`name`, ' (£', `Product`.`price`,')')) AS `Product__detail_name` FROM `ck_products` AS `Product` WHERE `Product`.`region_id` IN (905, 899, 900, 904, 901, 902, 903, 42, 144, 86, 152, 56, 132, 134, 57, 81, 148, 1, 156, 90, 91, 4, 5, 6, 78, 7, 31, 93, 94, 32, 73, 63, 13, 37, 95, 96, 14, 70, 35, 21, 36, 24, 25, 26, 60, 98, 99, 100, 101, 102, 103, 104, 79, 43, 44, 67, 77, 84, 52, 53, 105, 135, 45, 106, 153, 47, 140, 68, 141, 111, 48, 65, 69, 113, 143, 145, 40, 83, 62, 41, 58, 114, 115, 59, 116, 49, 118, 119, 136, 120, 38, 64, 39, 121, 87, 50, 51, 71, 27, 28, 154, 150, 29, 129, 80, 155, 30, 151, 61, 122, 123, 138, 124, 125, 137, 126, 127, 85, 128, 139, 149) | | 1026 | 1026 | 37 |
34 | SELECT `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified` FROM `ck_regions` AS `Region` WHERE `Region`.`status` = 'active' AND NOT (`Region`.`slug` = '') ORDER BY `Region`.`order` ASC | | 121 | 121 | 1 |
35 | SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 | | 8 | 8 | 0 |
36 | SHOW FULL COLUMNS FROM `ck_right_banners` | | 7 | 7 | 3 |
37 | SELECT `RightBanner`.`id`, `RightBanner`.`name`, `RightBanner`.`image_id`, `RightBanner`.`url`, `RightBanner`.`status`, `RightBanner`.`created`, `RightBanner`.`modified`, `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_right_banners` AS `RightBanner` LEFT JOIN `ck_images` AS `Image` ON (`RightBanner`.`image_id` = `Image`.`id`) WHERE `RightBanner`.`status` = 'active' | | 4 | 4 | 0 |
38 | SHOW FULL COLUMNS FROM `ck_right_links` | | 6 | 6 | 3 |
39 | SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' | | 2 | 2 | 0 |
40 | SHOW FULL COLUMNS FROM `ck_settings` | | 4 | 4 | 4 |
41 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_description' LIMIT 1 | | 1 | 1 | 0 |
42 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1 | | 1 | 1 | 0 |
43 | SELECT `User`.`id`, `User`.`role`, `User`.`contact_id`, `User`.`username`, `User`.`password`, `User`.`status`, `User`.`active`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, `Contact`.`id`, `Contact`.`first_name`, `Contact`.`surname`, `Contact`.`email`, `Contact`.`website`, `Contact`.`address_1`, `Contact`.`address_2`, `Contact`.`city`, `Contact`.`postcode`, `Contact`.`country_code`, `Contact`.`telephone`, `Contact`.`organisation`, `Contact`.`created`, `Contact`.`modified`, (CONCAT(`Contact`.`first_name`,' ',`Contact`.`surname`)) AS `Contact__name` FROM `ck_users` AS `User` LEFT JOIN `ck_contacts` AS `Contact` ON (`User`.`contact_id` = `Contact`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
44 | SELECT `Contact`.`id`, `Contact`.`first_name`, `Contact`.`surname`, `Contact`.`email`, `Contact`.`website`, `Contact`.`address_1`, `Contact`.`address_2`, `Contact`.`city`, `Contact`.`postcode`, `Contact`.`country_code`, `Contact`.`telephone`, `Contact`.`organisation`, `Contact`.`created`, `Contact`.`modified`, (CONCAT(`Contact`.`first_name`,' ',`Contact`.`surname`)) AS `Contact__name` FROM `ck_contacts` AS `Contact` WHERE `Contact`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |