1 | SET NAMES utf8 | No | 0.0003 sec. |
2 | SELECT websites.* FROM websites WHERE (domain = 'iframes.emerald.bg') LIMIT 1 | No | 0.0007 sec. |
3 | SELECT stores.* FROM stores WHERE (is_default = 1 AND website_id = 2) LIMIT 1 | No | 0.0007 sec. |
4 | SHOW TABLES LIKE 'transports_i18n' | No | 0.0011 sec. |
5 | SHOW TABLES LIKE 'currencies_i18n' | No | 0.0011 sec. |
6 | 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.0008 sec. |
7 | SHOW TABLES LIKE 'translations_i18n' | No | 0.001 sec. |
8 | SHOW TABLES LIKE 'newsletters_i18n' | No | 0.001 sec. |
9 | SHOW TABLES LIKE 'navigation_i18n' | No | 0.001 sec. |
10 | SHOW TABLES LIKE 'settings_i18n' | No | 0.0011 sec. |
11 | SHOW TABLES LIKE 'general_texts_i18n' | No | 0.001 sec. |
12 | SELECT custom_codes.* FROM custom_codes WHERE (active = 1) ORDER BY ord ASC | No | 0.0007 sec. |
13 | 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.0007 sec. |
14 | SELECT agents.* FROM agents WHERE (agents.id = 582) LIMIT 1 | No | 0.0006 sec. |
15 | SELECT agents.* FROM agents WHERE (agents.id = 582) LIMIT 1 | No | 0.0006 sec. |
16 | SHOW TABLES LIKE 'hotels_i18n' | No | 0.0011 sec. |
17 | 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 = 1357) LIMIT 1 | No | 0.0008 sec. |
18 | 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. |