SQL queries

Doctrine Version: 1.2.4

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.full_slug = '/catalog/category') LIMIT 1

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.full_slug = '/catalog') LIMIT 1

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.slug AS m__slug, m.type AS m__type, m.title AS m__title, m.sort AS m__sort, m.page_id AS m__page_id, m.is_local AS m__is_local, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM menu m WHERE (m.slug = 'top') LIMIT 1

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.title AS m__title, m.sort AS m__sort, m.menu_id AS m__menu_id, m.link_url AS m__link_url, m.link_page_id AS m__link_page_id, m.is_new_window AS m__is_new_window, m.root_id AS m__root_id, m.lft AS m__lft, m.rgt AS m__rgt, m.level AS m__level FROM menu_item m WHERE (m.lft = '1')

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.title AS m__title, m.sort AS m__sort, m.menu_id AS m__menu_id, m.link_url AS m__link_url, m.link_page_id AS m__link_page_id, m.is_new_window AS m__is_new_window, m.root_id AS m__root_id, m.lft AS m__lft, m.rgt AS m__rgt, m.level AS m__level FROM menu_item m WHERE (m.lft >= '1' AND m.root_id = '1') ORDER BY m.lft ASC

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.lft = '1')

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.lft >= '1' AND p.root_id = '1') ORDER BY p.lft ASC

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.slug AS m__slug, m.type AS m__type, m.title AS m__title, m.sort AS m__sort, m.page_id AS m__page_id, m.is_local AS m__is_local, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM menu m WHERE (m.slug = 'top') LIMIT 1

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.title AS m__title, m.sort AS m__sort, m.menu_id AS m__menu_id, m.link_url AS m__link_url, m.link_page_id AS m__link_page_id, m.is_new_window AS m__is_new_window, m.root_id AS m__root_id, m.lft AS m__lft, m.rgt AS m__rgt, m.level AS m__level FROM menu_item m WHERE (m.lft = '1')

0.00s, "doctrine" connection

SELECT m.id AS m__id, m.is_active AS m__is_active, m.title AS m__title, m.sort AS m__sort, m.menu_id AS m__menu_id, m.link_url AS m__link_url, m.link_page_id AS m__link_page_id, m.is_new_window AS m__is_new_window, m.root_id AS m__root_id, m.lft AS m__lft, m.rgt AS m__rgt, m.level AS m__level FROM menu_item m WHERE (m.lft >= '1' AND m.root_id = '1') ORDER BY m.lft ASC

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.lft = '1')

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.lft >= '1' AND p.root_id = '1') ORDER BY p.lft ASC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.is_active = '1') ORDER BY c.root_id ASC,c.lft ASC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.slug = 'uslugi' AND c.is_active = '1')

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.is_active = '1' AND (c.level <= '3' AND c.level <> '0') AND c.lft > '20' AND c.rgt < '21') ORDER BY c.lft, c.id

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.is_select AS c__is_select, c.is_promo AS c__is_promo, c.title AS c__title, c.sort AS c__sort, c.img AS c__img, c.preview_text AS c__preview_text, c.description AS c__description, c.product_type_id AS c__product_type_id, c.price AS c__price, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug, c2.catalog_product_id AS c2__catalog_product_id, c2.catalog_category_id AS c2__catalog_category_id FROM catalog_product c LEFT JOIN catalog_category_product c2 ON c.id = c2.catalog_product_id WHERE (c.is_active = '1' AND c2.catalog_category_id = '46') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECTCOUNT(*) AS num_results FROM (SELECT c.id FROM catalog_product c LEFT JOIN catalog_category_product c2 ON c.id = c2.catalog_product_id WHERE c.is_active = '1' AND c2.catalog_category_id = '46' GROUP BY c.id) dctrn_count_query

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.is_active = '1') ORDER BY c.root_id ASC,c.lft ASC

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.id = '46')

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.full_slug = '/catalog/catalog') LIMIT 1

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE (p.full_slug = '/catalog') LIMIT 1

0.00s, "doctrine" connection

SELECT p.id AS p__id, p.is_public AS p__is_public, p.is_sitemap AS p__is_sitemap, p.title AS p__title, p.full_slug AS p__full_slug, p.slug AS p__slug, p.type AS p__type, p.description AS p__description, p.keywords AS p__keywords, p.preview_text AS p__preview_text, p.root_id AS p__root_id, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level FROM page p WHERE ((p.lft < '10' AND p.rgt > '13') AND p.root_id = '1') ORDER BY p.lft asc

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE (c.slug = 'uslugi' AND c.is_active = '1')

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.is_active AS c__is_active, c.title AS c__title, c.preview_text AS c__preview_text, c.description AS c__description, c.img AS c__img, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug FROM catalog_category c WHERE ((c.lft < '20' AND c.rgt > '21') AND c.root_id = '1') ORDER BY c.lft asc

0.00s, "doctrine" connection

SELECT o.id AS o__id, o.is_active AS o__is_active, o.is_head AS o__is_head, o.sort AS o__sort, o.title AS o__title, o.city AS o__city, o.street AS o__street, o.house AS o__house, o.office AS o__office, o.postal AS o__postal, o.phone_code AS o__phone_code, o.phone AS o__phone, o.email AS o__email, o.description AS o__description, o.latitude AS o__latitude, o.longitude AS o__longitude, o.x_coord AS o__x_coord, o.y_coord AS o__y_coord, o.created_at AS o__created_at, o.updated_at AS o__updated_at FROM office o WHERE (o.is_active = '1') LIMIT 1