| 0.0034 |
select `key`,`en` from `languages` ;
|
| 0.0005 |
SELECT GET_LOCK('286d332cb0e87c2068893990e5a016d4', 300) AS ci_session_lock
|
| 0.0052 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = '6rj8mh0etg0n6j8is9a9uk14t3sfgsp1'
|
| 0.0039 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Name'
|
| 0.0058 |
SELECT *
FROM `currencies`
WHERE `status_id` > 0
ORDER BY `id` ASC
|
| 0.0003 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Email'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Socials'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Phone'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Email'
|
| 0.0002 |
SELECT *
FROM `settings`
WHERE `key_id` = 'Site_Email'
|
| 0.0089 |
SELECT *
FROM `orders`
WHERE `id` IS NULL
|
| 0.0100 |
SELECT *
FROM `countries`
WHERE `status_id` >= 1
ORDER BY `id` ASC
|
| 0.0332 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '228'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '228'
ORDER BY `name` ASC
|
| 0.0082 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '228'
ORDER BY `name` ASC
|
| 0.0011 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '300'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '300'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '300'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '400'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '400'
ORDER BY `name` ASC
|
| 0.0008 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '400'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '422'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '422'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '422'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '458'
ORDER BY `name` ASC
|
| 0.0008 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '458'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '458'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '512'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '512'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '512'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '608'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '608'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '608'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '634'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '634'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '634'
ORDER BY `name` ASC
|
| 0.0010 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '682'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '682'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '682'
ORDER BY `name` ASC
|
| 0.0013 |
SELECT MIN(`date_from`) as 'from_date',MAX(`date_to`) as 'to_date' FROM `items` WHERE `category_id` = 3 AND `location_id` = 2891 AND `status_id` = 1;
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '724'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '724'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '724'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '764'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '764'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '764'
ORDER BY `name` ASC
|
| 0.0005 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '788'
ORDER BY `name` ASC
|
| 0.0006 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '788'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '788'
ORDER BY `name` ASC
|
| 0.0009 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '792'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '792'
ORDER BY `name` ASC
|
| 0.0007 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '792'
ORDER BY `name` ASC
|
| 0.0002 |
SELECT MIN(`date_from`) as 'from_date',MAX(`date_to`) as 'to_date' FROM `items` WHERE `category_id` = 3 AND `location_id` = 3377 AND `status_id` = 1;
|
| 0.0003 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `from_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '818'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `airports`
WHERE `id` IN(SELECT `to_id` FROM `items` WHERE `status_id` = 1 AND `date_from` > "2026-01-05")
AND `country_id` = '818'
ORDER BY `name` ASC
|
| 0.0004 |
SELECT *
FROM `subregions`
WHERE `id` IN( SELECT `location_id` FROM `items` WHERE `category_id` = 3 AND `status_id` = 1 )
AND `country_id` = '818'
ORDER BY `name` ASC
|
| 0.0071 |
SELECT *
FROM `items`
WHERE `status_id` = 1
AND `category_id` = 3
ORDER BY `id` ASC
|
| 0.0061 |
SELECT *
FROM `packages`
WHERE `status_id` = 1
AND `expire_date` > '2026-01-05'
ORDER BY `id` ASC
LIMIT 3
|
