| Queries | Time | Rows |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 75 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
| SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2025-06-15'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`pages`)
WHERE `lang` = 'pl_PL'
AND `available` = 'Y'
AND `show_in_menu` = 1
AND `page_type` != 'news'
ORDER BY `page_position` DESC, `available` ASC | 0.000 | 5 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '2'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1'
ORDER BY `boxes`.`position` DESC | 0.001 | 4 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '4'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1' | 0.000 | 3 |
| SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.006 | 518 |
| SELECT `pages`.*, `news`.`id_news`, `news`.`title`, `news`.`short_description`, `news`.`news_date_added`, `news`.`news_modified_date`, `news`.`news_available`, `news`.`news_start_date`, `news`.`news_end_date`, `news`.`mainphotoname`, `news`.`mainfilename`, `news`.`page_id`, `news`.`icon_id`, `news`.`news_type`, `news_icons`.*, `brands`.*, `events`.*, `promotions`.*
FROM (`pages`)
LEFT JOIN `news` ON (`news`.`page_id` = `pages`.`id_page`)
LEFT JOIN `news_icons` ON (`news_icons`.`id_news_icon` = `news`.`icon_id`)
LEFT JOIN `brands` ON (`brands`.`page_id` = `pages`.`id_page`)
LEFT JOIN `events` ON (`events`.`page_id` = `pages`.`id_page`)
LEFT JOIN `promotions` ON (`promotions`.`page_id` = `pages`.`id_page`)
WHERE `pages`.`id_page` = '1' | 0.001 | 1 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.001 | 113 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '1' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '0' | 0.000 | 0 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '1' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '1' | 0.000 | 1 |
| Select * from ( Select * from( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
inner JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`)
WHERE p.active = 'Y' and sptv.active='Y' AND 1 AND p.productsale="1" order by rand()) as s GROUP BY id_product_ps ) as ss order by rand() LIMIT 0 ,3 | 0.078 | 3 |
| Select * from ( Select * from( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
inner JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`)
WHERE p.active = 'Y' and sptv.active='Y' AND 1 AND p.productnew="1" order by rand()) as s GROUP BY id_product_ps ) as ss order by rand() LIMIT 0 ,3 | 0.073 | 3 |
| SELECT *
FROM (`pages_elements`)
JOIN `polls_categories` ON (`polls_categories`.`element_id` = `pages_elements`.`element_id`)
JOIN `polls_questions_to_categories` ON (`polls_questions_to_categories`.`poll_category_id` = `polls_categories`.`id_poll_category`)
JOIN `polls_questions` ON (`polls_questions`.`id_question` = `polls_questions_to_categories`.`poll_question_id`)
JOIN `polls_answers` ON (`polls_answers`.`question_id` = `polls_questions`.`id_question`)
WHERE `page_id` = 1
AND `active` = 'Y' | 0.000 | 0 |
| SELECT *
FROM (`pages_elements`)
JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
WHERE `page_id` = '1'
ORDER BY `pages_elements`.`position` DESC | 0.000 | 3 |
| SELECT `boxes_set`.*, `elements`.*, `pages_elements`.`position`
FROM (`boxes_set`)
JOIN `pages_elements` ON (`pages_elements`.`element_id` = `boxes_set`.`element_id`)
JOIN `elements` ON (`elements`.`id_element` = `boxes_set`.`element_id`)
WHERE `boxes_set`.`element_id` = 8 | 0.000 | 1 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 4
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 3 |
| SELECT *, `languages`.`description` AS `language_description`, `news`.`description` AS `news_description`, `news_categories`.`element_id` AS `eid`
FROM (`news`)
JOIN `languages` ON (`languages`.`name` = `news`.`lang`)
JOIN `pages` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_images` ON (`news`.`id_news` = `news_images`.`news_id`)
LEFT JOIN `images` ON (`news_images`.`images_id` = `images`.`id_image`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_categories`.`id_news_category` = `news_to_categories`.`news_category_id`)
WHERE ( news_start_date<=1749945600 OR news_start_date = 0 OR news_start_date IS NULL )
AND ( news_end_date>=1749945600 OR news_end_date = 0 OR news_end_date IS NULL )
AND ( pages.available="Y" and news.news_available = 1 )
AND `news_categories`.`element_id` = '2'
ORDER BY `news_date_added` DESC | 0.001 | 44 |
| SELECT *, `languages`.`description` AS `language_description`, `news`.`description` AS `news_description`, `news_categories`.`element_id` AS `eid`
FROM (`news`)
JOIN `languages` ON (`languages`.`name` = `news`.`lang`)
JOIN `pages` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_images` ON (`news`.`id_news` = `news_images`.`news_id`)
LEFT JOIN `images` ON (`news_images`.`images_id` = `images`.`id_image`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_categories`.`id_news_category` = `news_to_categories`.`news_category_id`)
WHERE ( news_start_date<=1749945600 OR news_start_date = 0 OR news_start_date IS NULL )
AND ( news_end_date>=1749945600 OR news_end_date = 0 OR news_end_date IS NULL )
AND ( pages.available="Y" and news.news_available = 1 )
AND `news_categories`.`element_id` = '2'
ORDER BY `news_date_added` DESC
LIMIT 0, 3 | 0.001 | 3 |
| SELECT `boxes_set`.*, `elements`.*, `pages_elements`.`position`
FROM (`boxes_set`)
JOIN `pages_elements` ON (`pages_elements`.`element_id` = `boxes_set`.`element_id`)
JOIN `elements` ON (`elements`.`id_element` = `boxes_set`.`element_id`)
WHERE `boxes_set`.`element_id` = 1 | 0.000 | 2 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 4 | 0.000 | 1 |
| SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 4 | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '101' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '101' | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '101' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '101' | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '100' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '100' | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '100' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '100' | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '99' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '99' | 0.000 | 1 |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `id_page` = '99' | 0.000 | 1 |
| SELECT *
FROM (`pages`)
WHERE `id_page` = '99' | 0.000 | 1 |
| SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'footer_text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'rodo_pdf_link'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 64 | 0.170 | 1614 |
(+48) 22 812 90 60
