| 1 | SET NAMES utf8 | No | 0.0004 sec. |
| 2 | SHOW TABLES LIKE 'transports_i18n' | No | 0.0012 sec. |
| 3 | SHOW TABLES LIKE 'currencies_i18n' | No | 0.001 sec. |
| 4 | SELECT currencies.*, currencies_i18n.* FROM currencies LEFT JOIN currencies_i18n
ON currencies.id = currencies_i18n.i18n_foreign_key
AND currencies_i18n.i18n_locale = 'bg-BG' WHERE (iso_code IN ('BGN', 'EUR')) | No | 0.0009 sec. |
| 5 | SHOW TABLES LIKE 'translations_i18n' | No | 0.001 sec. |
| 6 | SHOW TABLES LIKE 'newsletters_i18n' | No | 0.001 sec. |
| 7 | SHOW TABLES LIKE 'navigation_i18n' | No | 0.001 sec. |
| 8 | SHOW TABLES LIKE 'settings_i18n' | No | 0.001 sec. |
| 9 | SHOW TABLES LIKE 'general_texts_i18n' | No | 0.001 sec. |
| 10 | SELECT custom_codes.* FROM custom_codes WHERE (active = 1) ORDER BY ord ASC | No | 0.0006 sec. |
| 11 | SELECT navigation.*, navigation_i18n.* FROM navigation LEFT JOIN navigation_i18n
ON navigation.id = navigation_i18n.i18n_foreign_key
AND navigation_i18n.i18n_locale = 'bg-BG' WHERE (visibility=2) AND (navigation.store_id = '2') | No | 0.0008 sec. |
| 12 | SELECT agents.* FROM agents WHERE (agents.id = 178) LIMIT 1 | No | 0.0006 sec. |
| 13 | SELECT agents.* FROM agents WHERE (agents.id = 178) LIMIT 1 | No | 0.0007 sec. |
| 14 | SHOW TABLES LIKE 'hotels_i18n' | No | 0.0009 sec. |
| 15 | SELECT hotels.*, hotels_i18n.* FROM hotels LEFT JOIN hotels_i18n
ON hotels.id = hotels_i18n.i18n_foreign_key
AND hotels_i18n.i18n_locale = 'bg-BG' WHERE (id = 2054) LIMIT 1 | No | 0.0009 sec. |
| 16 | SELECT popups.* FROM popups WHERE (is_active = 1 AND EXISTS (SELECT 1 FROM popup_contents pc WHERE pc.popup_id = popups.id)) ORDER BY ord ASC LIMIT 1 | No | 0.0008 sec. |