1 | DESCRIBE `users` | | 6 | 6 | 2 |
2 | DESCRIBE `popups` | | 2 | 2 | 2 |
3 | DESCRIBE `uploads` | | 7 | 7 | 2 |
4 | DESCRIBE `adminsections` | | 7 | 7 | 2 |
5 | DESCRIBE `adminsections_users` | | 5 | 5 | 2 |
6 | DESCRIBE `sliders` | | 8 | 8 | 2 |
7 | DESCRIBE `news` | | 11 | 11 | 2 |
8 | DESCRIBE `news_i18ns` | | 6 | 6 | 1 |
9 | DESCRIBE `settings` | | 73 | 73 | 2 |
10 | DESCRIBE `category_products` | | 11 | 11 | 1 |
11 | DESCRIBE `products` | | 15 | 15 | 1 |
12 | DESCRIBE `subpages` | | 21 | 21 | 1 |
13 | DESCRIBE `trainings` | | 35 | 35 | 1 |
14 | DESCRIBE `days` | | 4 | 4 | 1 |
15 | DESCRIBE `times` | | 8 | 8 | 1 |
16 | DESCRIBE `agendas` | | 4 | 4 | 1 |
17 | DESCRIBE `opinions` | | 4 | 4 | 1 |
18 | DESCRIBE `trainers` | | 15 | 15 | 1 |
19 | DESCRIBE `trainings_trainers` | | 3 | 3 | 1 |
20 | DESCRIBE `galleries` | | 9 | 9 | 1 |
21 | DESCRIBE `category_galleries` | | 7 | 7 | 1 |
22 | DESCRIBE `subpage_i18ns` | | 6 | 6 | 1 |
23 | DESCRIBE `banners` | | 3 | 3 | 1 |
24 | DESCRIBE `category_projects` | | 4 | 4 | 1 |
25 | DESCRIBE `boxes` | | 7 | 7 | 1 |
26 | DESCRIBE `box_i18ns` | | 6 | 6 | 1 |
27 | DESCRIBE `offers` | | 7 | 7 | 1 |
28 | DESCRIBE `offer_i18ns` | | 6 | 6 | 1 |
29 | DESCRIBE `type_shippings` | | 3 | 3 | 1 |
30 | DESCRIBE `posts` | | 11 | 11 | 1 |
31 | DESCRIBE `category_news` | | 4 | 4 | 1 |
32 | DESCRIBE `category_posts` | | 3 | 3 | 1 |
33 | DESCRIBE `translations` | | 3 | 3 | 1 |
34 | DESCRIBE `translation_i18ns` | | 6 | 6 | 1 |
35 | SELECT `TypeShipping`.`id`, `TypeShipping`.`name`, `TypeShipping`.`price` FROM `type_shippings` AS `TypeShipping` WHERE `TypeShipping`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
36 | SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`google_analistic`, `Setting`.`subpage_home`, `Setting`.`login_google_analistic`, `Setting`.`pass_google_analistic`, `Setting`.`profil_google_analistic`, `Setting`.`company_name`, `Setting`.`company_address`, `Setting`.`company_postcode`, `Setting`.`company_bank_name`, `Setting`.`company_account_number`, `Setting`.`company_account_number_swift`, `Setting`.`company_email`, `Setting`.`company_phone`, `Setting`.`company_fax`, `Setting`.`company_mobile`, `Setting`.`contact_rules`, `Setting`.`company_city`, `Setting`.`company_nip`, `Setting`.`company_regon`, `Setting`.`company_info`, `Setting`.`company_show_info`, `Setting`.`company_show_contact`, `Setting`.`company_show_hours`, `Setting`.`footer_hours`, `Setting`.`footer_hours_title`, `Setting`.`system_email`, `Setting`.`system_email_order_copy`, `Setting`.`newsletter_from`, `Setting`.`newsletter_raport`, `Setting`.`newsletter_copy`, `Setting`.`newsletter_confirmation`, `Setting`.`newsletter_sender`, `Setting`.`news_home_font_size`, `Setting`.`group_id`, `Setting`.`training_confirmation`, `Setting`.`robots`, `Setting`.`privacy`, `Setting`.`ga_tracking_code`, `Setting`.`layout_type`, `Setting`.`layout_slider`, `Setting`.`layout_color`, `Setting`.`layout_background`, `Setting`.`layout_pattern`, `Setting`.`layout_pattern_position`, `Setting`.`layout_logo_desc`, `Setting`.`layout_partners_title`, `Setting`.`layout_logo_rotator_title`, `Setting`.`layout_news_desc`, `Setting`.`layout_youtube_background`, `Setting`.`alt`, `Setting`.`subpage_policy`, `Setting`.`subpage_rules`, `Setting`.`subpage_cookies`, `Setting`.`social_facebook`, `Setting`.`social_googleplus`, `Setting`.`social_twitter`, `Setting`.`social_linkedin`, `Setting`.`social_flickr`, `Setting`.`social_pinterest`, `Setting`.`social_instagram`, `Setting`.`social_youtube`, `Setting`.`social_500px`, `Setting`.`social_tumblr`, `Setting`.`ga_cords`, `Setting`.`open_graph_protocol`, `Setting`.`module_news_available`, `Setting`.`google_map_api_key`, `Setting`.`recaptcha_site_key`, `Setting`.`recaptcha_secret_key` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 1 |
37 | SELECT `News`.*, `I18n__title`.`content`, `I18n__body`.`content`, `News`.`id` FROM `news` AS `News` LEFT JOIN `news_i18ns` AS `I18n__title` ON (`News`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'News' AND `I18n__title`.`field` = 'title') LEFT JOIN `news_i18ns` AS `I18n__body` ON (`News`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'News' AND `I18n__body`.`field` = 'body') WHERE `I18n__title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' LIMIT 1 | | 0 | 0 | 1 |
38 | SELECT `News`.*, `I18n__title`.`content`, `I18n__body`.`content`, `News`.`id` FROM `news` AS `News` LEFT JOIN `news_i18ns` AS `I18n__title` ON (`News`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'News' AND `I18n__title`.`field` = 'title') LEFT JOIN `news_i18ns` AS `I18n__body` ON (`News`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'News' AND `I18n__body`.`field` = 'body') WHERE `I18n__title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' LIMIT 1 | | 0 | 0 | 1 |
39 | SELECT `News`.*, `I18n__title`.`content`, `I18n__body`.`content`, `News`.`id` FROM `news` AS `News` LEFT JOIN `news_i18ns` AS `I18n__title` ON (`News`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'News' AND `I18n__title`.`field` = 'title') LEFT JOIN `news_i18ns` AS `I18n__body` ON (`News`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'News' AND `I18n__body`.`field` = 'body') WHERE `I18n__title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' LIMIT 3 | | 0 | 0 | 1 |
40 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`seo`, `Post`.`body`, `Post`.`seo_title`, `Post`.`seo_keywords`, `Post`.`seo_description`, `Post`.`created`, `Post`.`show_enable`, `Post`.`show_start`, `Post`.`show_end` FROM `posts` AS `Post` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
41 | SELECT `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `uploads` AS `Upload` WHERE `Upload`.`section` = 'posts' AND `Upload`.`parent_id` = (20) | | 1 | 1 | 1 |
42 | SELECT `CategoryNews`.`id`, `CategoryNews`.`name`, `CategoryNews`.`seo`, `CategoryNews`.`description`, `CategoryPost`.`id`, `CategoryPost`.`category_news_id`, `CategoryPost`.`news_id` FROM `category_news` AS `CategoryNews` JOIN `category_posts` AS `CategoryPost` ON (`CategoryPost`.`news_id` = 20 AND `CategoryPost`.`category_news_id` = `CategoryNews`.`id`) | | 2 | 2 | 0 |
43 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`seo`, `Post`.`body`, `Post`.`seo_title`, `Post`.`seo_keywords`, `Post`.`seo_description`, `Post`.`created`, `Post`.`show_enable`, `Post`.`show_start`, `Post`.`show_end` FROM `posts` AS `Post` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
44 | SELECT `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `uploads` AS `Upload` WHERE `Upload`.`section` = 'posts' AND `Upload`.`parent_id` = (20) | | 1 | 1 | 1 |
45 | SELECT `CategoryNews`.`id`, `CategoryNews`.`name`, `CategoryNews`.`seo`, `CategoryNews`.`description`, `CategoryPost`.`id`, `CategoryPost`.`category_news_id`, `CategoryPost`.`news_id` FROM `category_news` AS `CategoryNews` JOIN `category_posts` AS `CategoryPost` ON (`CategoryPost`.`news_id` = 20 AND `CategoryPost`.`category_news_id` = `CategoryNews`.`id`) | | 2 | 2 | 0 |
46 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`seo`, `Post`.`body`, `Post`.`seo_title`, `Post`.`seo_keywords`, `Post`.`seo_description`, `Post`.`created`, `Post`.`show_enable`, `Post`.`show_start`, `Post`.`show_end` FROM `posts` AS `Post` WHERE 1 = 1 LIMIT 3 | | 3 | 3 | 0 |
47 | SELECT `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `uploads` AS `Upload` WHERE `Upload`.`section` = 'posts' AND `Upload`.`parent_id` IN (20, 21, 22) | | 3 | 3 | 1 |
48 | SELECT `CategoryNews`.`id`, `CategoryNews`.`name`, `CategoryNews`.`seo`, `CategoryNews`.`description`, `CategoryPost`.`id`, `CategoryPost`.`category_news_id`, `CategoryPost`.`news_id` FROM `category_news` AS `CategoryNews` JOIN `category_posts` AS `CategoryPost` ON (`CategoryPost`.`news_id` IN (20, 21, 22) AND `CategoryPost`.`category_news_id` = `CategoryNews`.`id`) | | 6 | 6 | 0 |
49 | SELECT `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `uploads` AS `Upload` WHERE `section` = 'slider' | | 1 | 1 | 1 |
50 | SELECT `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `uploads` AS `Upload` WHERE `section` = 'galeria' ORDER BY RAND() ASC LIMIT 8 | | 8 | 8 | 1 |
51 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `Subpage`.`id` = 255 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `order` ASC LIMIT 1 | | 0 | 0 | 1 |
52 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `Subpage`.`id` = 256 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `order` ASC LIMIT 1 | | 0 | 0 | 1 |
53 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `Subpage`.`parent_id` = 256 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `order` ASC | | 0 | 0 | 2 |
54 | SELECT `Popup`.`id`, `Popup`.`active`, `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `popups` AS `Popup` LEFT JOIN `uploads` AS `Upload` ON (`Upload`.`parent_id` = `Popup`.`id` AND `Upload`.`section` = 'popup') WHERE `Popup`.`active` = 1 LIMIT 1 | | 0 | 0 | 0 |
55 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `show` = 1 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `Subpage`.`order` ASC | | 0 | 0 | 1 |
56 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `show` = 1 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `Subpage`.`order` asc | | 0 | 0 | 1 |
57 | SELECT `Banner`.`id`, `Banner`.`line1`, `Banner`.`line2`, `Upload`.`id`, `Upload`.`section`, `Upload`.`filename`, `Upload`.`description`, `Upload`.`path`, `Upload`.`pdf`, `Upload`.`parent_id` FROM `banners` AS `Banner` LEFT JOIN `uploads` AS `Upload` ON (`Upload`.`parent_id` = `Banner`.`id` AND `Upload`.`section` = 'banner') WHERE 1 = 1 | | 0 | 0 | 0 |
58 | SELECT `CategoryProduct`.`id`, `CategoryProduct`.`name`, `CategoryProduct`.`description`, `CategoryProduct`.`seo`, `CategoryProduct`.`seo_name`, `CategoryProduct`.`seo_description`, `CategoryProduct`.`seo_keywords`, `CategoryProduct`.`parent_id`, `CategoryProduct`.`lft`, `CategoryProduct`.`rght`, `CategoryProduct`.`order` FROM `category_products` AS `CategoryProduct` WHERE 1 = 1 ORDER BY `order` ASC | | 0 | 0 | 0 |
59 | SELECT `CategoryNews`.`id`, `CategoryNews`.`name`, `CategoryNews`.`seo`, `CategoryNews`.`description` FROM `category_news` AS `CategoryNews` WHERE 1 = 1 | | 5 | 5 | 0 |
60 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `Subpage`.`id` = 300 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `order` ASC LIMIT 1 | | 0 | 0 | 1 |
61 | SELECT `Subpage`.*, `I18n__title`.`content`, `I18n__page_title`.`content`, `I18n__body`.`content`, `Subpage`.`id` FROM `subpages` AS `Subpage` LEFT JOIN `subpage_i18ns` AS `I18n__title` ON (`Subpage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Subpage' AND `I18n__title`.`field` = 'title') LEFT JOIN `subpage_i18ns` AS `I18n__page_title` ON (`Subpage`.`id` = `I18n__page_title`.`foreign_key` AND `I18n__page_title`.`model` = 'Subpage' AND `I18n__page_title`.`field` = 'page_title') LEFT JOIN `subpage_i18ns` AS `I18n__body` ON (`Subpage`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Subpage' AND `I18n__body`.`field` = 'body') WHERE `Subpage`.`id` = 308 AND `I18n__title`.`locale` = 'en_us' AND `I18n__page_title`.`locale` = 'en_us' AND `I18n__body`.`locale` = 'en_us' ORDER BY `order` ASC LIMIT 1 | | 0 | 0 | 1 |
62 | SELECT `Box`.*, `Upload`.*, `I18n__name`.`content`, `I18n__desc`.`content`, `I18n__alt`.`content`, `I18n__label`.`content` FROM `boxes` AS `Box` LEFT JOIN `box_i18ns` AS `I18n__name` ON (`Box`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Box' AND `I18n__name`.`field` = 'name') LEFT JOIN `box_i18ns` AS `I18n__desc` ON (`Box`.`id` = `I18n__desc`.`foreign_key` AND `I18n__desc`.`model` = 'Box' AND `I18n__desc`.`field` = 'desc') LEFT JOIN `box_i18ns` AS `I18n__alt` ON (`Box`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Box' AND `I18n__alt`.`field` = 'alt') LEFT JOIN `box_i18ns` AS `I18n__label` ON (`Box`.`id` = `I18n__label`.`foreign_key` AND `I18n__label`.`model` = 'Box' AND `I18n__label`.`field` = 'label') LEFT JOIN `uploads` AS `Upload` ON (`Upload`.`parent_id` = `Box`.`id` AND `Upload`.`section` = 'box') WHERE `I18n__name`.`locale` = 'en_us' AND `I18n__desc`.`locale` = 'en_us' AND `I18n__alt`.`locale` = 'en_us' AND `I18n__label`.`locale` = 'en_us' ORDER BY `Box`.`order` ASC | | 0 | 0 | 2 |