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/show') 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.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, c3.id AS c3__id, c3.is_active AS c3__is_active, c3.title AS c3__title, c3.preview_text AS c3__preview_text, c3.description AS c3__description, c3.img AS c3__img, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c3.root_id AS c3__root_id, c3.lft AS c3__lft, c3.rgt AS c3__rgt, c3.level AS c3__level, c3.slug AS c3__slug FROM catalog_product c LEFT JOIN catalog_category_product c2 ON (c.id = c2.catalog_product_id) LEFT JOIN catalog_category c3 ON (c2.catalog_category_id = c3.id) WHERE (c.id = '34' AND c.is_active = '1' AND c3.is_active = '1' AND c2.catalog_category_id > 0)

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.code AS c__code, c.description AS c__description, c.image AS c__image FROM catalog_product_type c WHERE (c.id = '11')

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.code AS c__code, c.type AS c__type, c.sort AS c__sort, c.is_required AS c__is_required, c.is_multiple AS c__is_multiple, c.appearance AS c__appearance, c.price AS c__price, c.defaul AS c__defaul, c.help AS c__help, c2.catalog_product_type_id AS c2__catalog_product_type_id, c2.catalog_product_property_id AS c2__catalog_product_property_id FROM catalog_product_property c LEFT JOIN catalog_product_type_property c2 ON c.id = c2.catalog_product_property_id WHERE (c2.catalog_product_type_id IN ('11'))

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, c2.catalog_product_id AS c2__catalog_product_id, c2.catalog_category_id AS c2__catalog_category_id FROM catalog_category c LEFT JOIN catalog_category_product c2 ON c.id = c2.catalog_category_id WHERE (c2.catalog_product_id IN ('34'))

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.type AS c__type, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.position AS c__position, c.content_id AS c__content_id FROM catalog_content c WHERE (c.content_id = '34') ORDER BY c.sort ASC, c.id ASC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '630') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '630') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '630') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '764') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '764') ORDER BY c.sort ASC, c.id DESC

0.00s, "doctrine" connection

SELECT c.id AS c__id, c.title AS c__title, c.sort AS c__sort, c.src AS c__src, c.content AS c__content, c.content_id AS c__content_id FROM catalog_rama c WHERE (c.content_id = '764') ORDER BY c.sort ASC, c.id DESC

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 (c.sort < '220' OR (c.id > '34' AND c.sort = '220')) AND c.id <> '34' AND c2.catalog_category_id IN ('60')) ORDER BY c.sort DESC, c.id ASC

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 (c.sort < '220' OR (c.id > '34' AND c.sort = '220')) AND c.id <> '34' AND c2.catalog_category_id IN ('60')) ORDER BY c.sort DESC, c.id 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 = '60')

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 (c.sort < '220' OR (c.id > '34' AND c.sort = '220')) AND c.id <> '34' AND c2.catalog_category_id IN ('60')) ORDER BY c.sort DESC, c.id ASC

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 (c.sort > '220' OR (c.id < '34' AND c.sort = '220')) AND c.id <> '34' AND c2.catalog_category_id IN ('60')) ORDER BY c.sort ASC, c.id DESC

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 = 'protivopozharnye-lyuki-ei60' 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 < '11' AND c.rgt > '12') AND c.root_id = '1') ORDER BY c.lft asc

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 FROM catalog_product c WHERE (c.id = '34') LIMIT 1