Този сайт използва бисквитки, за да може да функционира. Бисквитките правят употребата му технически възможна, лесна и сигурна, спомагайки различни процеси в сайта като навигиране, пренос на данни и сигурност. Бисквитките се ползват и за набавяне на обобщена и напълно анонимизирана статистическа информация за това как сайтът се ползва от потребителите – например най-разглеждани страници, брой посетители, време на зареждане на страниците и други. Тази информация ни помага за подобряване на неговата визия, съдържание и бързодействие, както и за последващо таргетиране на потребители с пригодени според техните интереси рекламни съобщения. На линка долу може да прочетете по-подробно описание за това какво са бисквитките, какви бисквитки ползваме и каква е употребата им. За да работи нашия сайт по най-добрия и адаптиран за всеки потребител начин е необходимо съгласие с бисквитките.
Този сайт използва бисквитки, за да може да функционира. Бисквитките правят употребата му технически възможна, лесна и сигурна. Ползват се и за набавяне на анонимизирана статистическа информация за това как сайтът се ползва, с цел подобряване на неговата визия, съдържание и бързодействие, както и за последващо таргетиране на потребители с адаптирани за тях рекламни съобщения. За да работи нашия сайт по най-добрия и адаптиран за всеки потребител начин е необходимо съгласие с бисквитките.
SELECT `main`.`id` AS `id`, `main`.`type` AS `type`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'pageImages' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE (((`main`.`type` IN (3, 4, 7)) AND (`main`.`is_in_menu` = 1)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.28 ms
0.019 MB
Duration
0.28 ms
Memory usage
0.019 MB
query
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` WHERE ((`main`.`id` IN (34, 35, 84, 104)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang)
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
5.72 ms
0.016 MB
Duration
5.72 ms
Memory usage
0.016 MB
query
SELECT max(date) AS date FROM `cruise_prices_cache`
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.24 ms
0.017 MB
Duration
0.24 ms
Memory usage
0.017 MB
query
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'settings' AND `TABLE_SCHEMA` = DATABASE()
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.34 ms
0.018 MB
Duration
0.34 ms
Memory usage
0.018 MB
query
DESCRIBE `settings`
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.13 ms
0.017 MB
Duration
0.13 ms
Memory usage
0.017 MB
query
SELECT `main`.`keyword` AS `keyword`, `main`.`content` AS `content` FROM `settings` AS `main`
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
1.07 ms
0.021 MB
Duration
1.07 ms
Memory usage
0.021 MB
query
SELECT `main`.`id` AS `id`, `main18`.`settings` AS `settings`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion` FROM `carousel` AS `main` LEFT JOIN `carousel_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'carouselImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 WHERE (`main18`.`lang` = :lang) AND (`main18`.`is_active` = 1) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
2.25 ms
0.025 MB
Duration
2.25 ms
Memory usage
0.025 MB
query
SELECT `main18`.`title` AS `title`, `main18`.`slug` AS `slug`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional` FROM `companies` AS `main` LEFT JOIN `companies_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'companySliderLogo' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE ((`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang)) AND (`upload`.`filename` IS NOT NULL) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
1.15 ms
0.022 MB
Duration
1.15 ms
Memory usage
0.022 MB
query
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`footer_text` AS `footer_text`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional`, `page`.`type` AS `type`, `page18`.`slug` AS `slug` FROM `featured` AS `main` LEFT JOIN `featured_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'featuredIcon' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `pages` AS `page` ON `main`.`page_id` = `page`.`id` LEFT JOIN `pages_i18n` AS `page18` ON `page18`.`foreign_key` = `page`.`id` WHERE (`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
144.84 ms
0.029 MB
Duration
144.84 ms
Memory usage
0.029 MB
query
SELECT `cruise`.`id` AS `id`, any_value(`cruise`.`featured_id`) AS `featuredId`, any_value(`cruise`.`featured_date`) AS `featuredDate`, `cruise`.`display_in_whitelabel` AS `displayInWhitelabel`, any_value(`cruise18`.`title`) AS `title`, any_value(`cruise18`.`label`) AS `label`, any_value(`cruise18`.`slug`) AS `slug`, any_value(`upload`.`id`) AS `uploadId`, any_value(`upload`.`filename`) AS `uploadFilename`, any_value(`upload`.`ver`) AS `uploadVersion`, any_value(`upload18`.`additional`) AS `uploadAdditional`, any_value(`port`.`title`) AS `startPort`, any_value(`ship`.`id`) AS `shipId`, any_value(`ship`.`rating`) AS `shipRating`, any_value(`ship18`.`title`) AS `shipTitle`, any_value(`prices`.`price_lv`) AS `price`, any_value(`prices`.`date`) AS `date` FROM `cruises` AS `cruise` LEFT JOIN `cruises_i18n` AS `cruise18` ON `cruise18`.`foreign_key` = `cruise`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `cruise`.`id` AND `upload`.`section` = 'cruiseFeaturedImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `cruise_route_points` AS `route` ON `cruise`.`id` = `route`.`cruise_id` AND `route`.`ord` = 0 LEFT JOIN `ports_i18n` AS `port` ON `port`.`foreign_key` = `route`.`port_id` AND `port`.`lang` = 'bg' LEFT JOIN `ships` AS `ship` ON `cruise`.`ship_id` = `ship`.`id` LEFT JOIN `ships_i18n` AS `ship18` ON `ship18`.`foreign_key` = `ship`.`id` AND `ship18`.`lang` = 'bg' LEFT JOIN `cruise_prices_cache` AS `prices` ON `prices`.`cruise_id` = `cruise`.`id` AND IF(`cruise`.`featured_date`, (`prices`.`date` = `cruise`.`featured_date`), (`prices`.`is_lowest` = 1)) WHERE ((`cruise18`.`is_active` = 1) AND (`cruise`.`featured_id` IN (:ids0, :ids1, :ids2, :ids3, :ids4, :ids5))) AND (`cruise18`.`lang` = :lang) GROUP BY `cruise`.`id` ORDER BY `prices`.`price` ASC
SELECT `main`.`id` AS `id`, `main`.`type` AS `type`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'pageImages' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE (((`main`.`type` IN (3, 4, 7)) AND (`main`.`is_in_menu` = 1)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
1
1.87 ms
1.87 ms
1.87 ms
1.87 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
1.87 ms
0.026 MB
Duration
1.87 ms
Memory usage
0.026 MB
query
SELECT `main`.`id` AS `id`, `main`.`type` AS `type`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'pageImages' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE (((`main`.`type` IN (3, 4, 7)) AND (`main`.`is_in_menu` = 1)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` WHERE ((`main`.`id` IN (34, 35, 84, 104)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang)
1
0.28 ms
0.28 ms
0.28 ms
0.28 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.28 ms
0.019 MB
Duration
0.28 ms
Memory usage
0.019 MB
query
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`slug` AS `slug` FROM `pages` AS `main` LEFT JOIN `pages_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` WHERE ((`main`.`id` IN (34, 35, 84, 104)) AND (`main18`.`is_active` = 1)) AND (`main18`.`lang` = :lang)
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
SELECT max(date) AS date FROM `cruise_prices_cache`
1
5.72 ms
5.72 ms
5.72 ms
5.72 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
5.72 ms
0.016 MB
Duration
5.72 ms
Memory usage
0.016 MB
query
SELECT max(date) AS date FROM `cruise_prices_cache`
database
dev_crusit_bg
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'settings' AND `TABLE_SCHEMA` = DATABASE()
1
0.24 ms
0.24 ms
0.24 ms
0.24 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.24 ms
0.017 MB
Duration
0.24 ms
Memory usage
0.017 MB
query
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME` = 'settings' AND `TABLE_SCHEMA` = DATABASE()
database
dev_crusit_bg
DESCRIBE `settings`
1
0.34 ms
0.34 ms
0.34 ms
0.34 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.34 ms
0.018 MB
Duration
0.34 ms
Memory usage
0.018 MB
query
DESCRIBE `settings`
database
dev_crusit_bg
SELECT `main`.`keyword` AS `keyword`, `main`.`content` AS `content` FROM `settings` AS `main`
1
0.13 ms
0.13 ms
0.13 ms
0.13 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
0.13 ms
0.017 MB
Duration
0.13 ms
Memory usage
0.017 MB
query
SELECT `main`.`keyword` AS `keyword`, `main`.`content` AS `content` FROM `settings` AS `main`
database
dev_crusit_bg
SELECT `main`.`id` AS `id`, `main18`.`settings` AS `settings`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion` FROM `carousel` AS `main` LEFT JOIN `carousel_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'carouselImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 WHERE (`main18`.`lang` = :lang) AND (`main18`.`is_active` = 1) ORDER BY `main`.`ord` ASC
1
1.07 ms
1.07 ms
1.07 ms
1.07 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
1.07 ms
0.021 MB
Duration
1.07 ms
Memory usage
0.021 MB
query
SELECT `main`.`id` AS `id`, `main18`.`settings` AS `settings`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion` FROM `carousel` AS `main` LEFT JOIN `carousel_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'carouselImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 WHERE (`main18`.`lang` = :lang) AND (`main18`.`is_active` = 1) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
SELECT `main18`.`title` AS `title`, `main18`.`slug` AS `slug`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional` FROM `companies` AS `main` LEFT JOIN `companies_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'companySliderLogo' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE ((`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang)) AND (`upload`.`filename` IS NOT NULL) ORDER BY `main`.`ord` ASC
1
2.25 ms
2.25 ms
2.25 ms
2.25 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
2.25 ms
0.025 MB
Duration
2.25 ms
Memory usage
0.025 MB
query
SELECT `main18`.`title` AS `title`, `main18`.`slug` AS `slug`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional` FROM `companies` AS `main` LEFT JOIN `companies_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'companySliderLogo' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' WHERE ((`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang)) AND (`upload`.`filename` IS NOT NULL) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`footer_text` AS `footer_text`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional`, `page`.`type` AS `type`, `page18`.`slug` AS `slug` FROM `featured` AS `main` LEFT JOIN `featured_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'featuredIcon' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `pages` AS `page` ON `main`.`page_id` = `page`.`id` LEFT JOIN `pages_i18n` AS `page18` ON `page18`.`foreign_key` = `page`.`id` WHERE (`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
1
1.15 ms
1.15 ms
1.15 ms
1.15 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
1.15 ms
0.022 MB
Duration
1.15 ms
Memory usage
0.022 MB
query
SELECT `main`.`id` AS `id`, `main18`.`title` AS `title`, `main18`.`footer_text` AS `footer_text`, `upload`.`id` AS `uploadId`, `upload`.`filename` AS `uploadFilename`, `upload`.`ver` AS `uploadVersion`, `upload18`.`additional` AS `uploadAdditional`, `page`.`type` AS `type`, `page18`.`slug` AS `slug` FROM `featured` AS `main` LEFT JOIN `featured_i18n` AS `main18` ON `main18`.`foreign_key` = `main`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `main`.`id` AND `upload`.`section` = 'featuredIcon' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `pages` AS `page` ON `main`.`page_id` = `page`.`id` LEFT JOIN `pages_i18n` AS `page18` ON `page18`.`foreign_key` = `page`.`id` WHERE (`main18`.`is_active` = 1) AND (`main18`.`lang` = :lang) ORDER BY `main`.`ord` ASC
params
array(1) {
["lang"]=>
string(2) "bg"
}
database
dev_crusit_bg
SELECT `cruise`.`id` AS `id`, any_value(`cruise`.`featured_id`) AS `featuredId`, any_value(`cruise`.`featured_date`) AS `featuredDate`, `cruise`.`display_in_whitelabel` AS `displayInWhitelabel`, any_value(`cruise18`.`title`) AS `title`, any_value(`cruise18`.`label`) AS `label`, any_value(`cruise18`.`slug`) AS `slug`, any_value(`upload`.`id`) AS `uploadId`, any_value(`upload`.`filename`) AS `uploadFilename`, any_value(`upload`.`ver`) AS `uploadVersion`, any_value(`upload18`.`additional`) AS `uploadAdditional`, any_value(`port`.`title`) AS `startPort`, any_value(`ship`.`id`) AS `shipId`, any_value(`ship`.`rating`) AS `shipRating`, any_value(`ship18`.`title`) AS `shipTitle`, any_value(`prices`.`price_lv`) AS `price`, any_value(`prices`.`date`) AS `date` FROM `cruises` AS `cruise` LEFT JOIN `cruises_i18n` AS `cruise18` ON `cruise18`.`foreign_key` = `cruise`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `cruise`.`id` AND `upload`.`section` = 'cruiseFeaturedImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `cruise_route_points` AS `route` ON `cruise`.`id` = `route`.`cruise_id` AND `route`.`ord` = 0 LEFT JOIN `ports_i18n` AS `port` ON `port`.`foreign_key` = `route`.`port_id` AND `port`.`lang` = 'bg' LEFT JOIN `ships` AS `ship` ON `cruise`.`ship_id` = `ship`.`id` LEFT JOIN `ships_i18n` AS `ship18` ON `ship18`.`foreign_key` = `ship`.`id` AND `ship18`.`lang` = 'bg' LEFT JOIN `cruise_prices_cache` AS `prices` ON `prices`.`cruise_id` = `cruise`.`id` AND IF(`cruise`.`featured_date`, (`prices`.`date` = `cruise`.`featured_date`), (`prices`.`is_lowest` = 1)) WHERE ((`cruise18`.`is_active` = 1) AND (`cruise`.`featured_id` IN (:ids0, :ids1, :ids2, :ids3, :ids4, :ids5))) AND (`cruise18`.`lang` = :lang) GROUP BY `cruise`.`id` ORDER BY `prices`.`price` ASC
1
144.84 ms
144.84 ms
144.84 ms
144.84 ms
0 ms
25 ms
50 ms
75 ms
100 ms
125 ms
150 ms
175 ms
Name
Component
Duration
Memory
Phalcon\Db\Adapter\Pdo\Mysql::query
Database
144.84 ms
0.029 MB
Duration
144.84 ms
Memory usage
0.029 MB
query
SELECT `cruise`.`id` AS `id`, any_value(`cruise`.`featured_id`) AS `featuredId`, any_value(`cruise`.`featured_date`) AS `featuredDate`, `cruise`.`display_in_whitelabel` AS `displayInWhitelabel`, any_value(`cruise18`.`title`) AS `title`, any_value(`cruise18`.`label`) AS `label`, any_value(`cruise18`.`slug`) AS `slug`, any_value(`upload`.`id`) AS `uploadId`, any_value(`upload`.`filename`) AS `uploadFilename`, any_value(`upload`.`ver`) AS `uploadVersion`, any_value(`upload18`.`additional`) AS `uploadAdditional`, any_value(`port`.`title`) AS `startPort`, any_value(`ship`.`id`) AS `shipId`, any_value(`ship`.`rating`) AS `shipRating`, any_value(`ship18`.`title`) AS `shipTitle`, any_value(`prices`.`price_lv`) AS `price`, any_value(`prices`.`date`) AS `date` FROM `cruises` AS `cruise` LEFT JOIN `cruises_i18n` AS `cruise18` ON `cruise18`.`foreign_key` = `cruise`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `cruise`.`id` AND `upload`.`section` = 'cruiseFeaturedImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `cruise_route_points` AS `route` ON `cruise`.`id` = `route`.`cruise_id` AND `route`.`ord` = 0 LEFT JOIN `ports_i18n` AS `port` ON `port`.`foreign_key` = `route`.`port_id` AND `port`.`lang` = 'bg' LEFT JOIN `ships` AS `ship` ON `cruise`.`ship_id` = `ship`.`id` LEFT JOIN `ships_i18n` AS `ship18` ON `ship18`.`foreign_key` = `ship`.`id` AND `ship18`.`lang` = 'bg' LEFT JOIN `cruise_prices_cache` AS `prices` ON `prices`.`cruise_id` = `cruise`.`id` AND IF(`cruise`.`featured_date`, (`prices`.`date` = `cruise`.`featured_date`), (`prices`.`is_lowest` = 1)) WHERE ((`cruise18`.`is_active` = 1) AND (`cruise`.`featured_id` IN (:ids0, :ids1, :ids2, :ids3, :ids4, :ids5))) AND (`cruise18`.`lang` = :lang) GROUP BY `cruise`.`id` ORDER BY `prices`.`price` ASC
ОРГАНИЗИРАНИ КРУИЗНИ ГРУПИ С ВОДАЧ 
