8-800-234-88-37
Пн - Пт 10:00 - 18:00 (Мск)

8-800-234-88-37

Обратный звонок

Обратная связь

История₍₉₎

Отложенные₍₀₎

Сравнение₍₁₎

Авторизация

Адрес офиса: Г. Владимир, ул. Тракторная 45

Адрес склада: Г. Владимир, ул. Куйбышева 4

Интернет магазин 8-800-234-88-37

Режим работы

Пн - Пт - 10:00 до 18:00 Сб, Вс - выходной

Вы еще не отложили товары

X

Respect VS12-168823 женские ботинки

Сравнить

Вы еще ничего не добавили в корзину

Детская обувь

Tom Miki B-9900-Y детские кроссовки

1590 руб

746 руб

Экономия: 844 руб

Бонус : 15 руб

Размеры в наличии: 23

Soter T012101B слипоны туфли

1890 руб

886 руб

Экономия: 1004 руб

Бонус : 18 руб

Размеры в наличии: 36

Soter LJM21-02A детские кроссовки

2490 руб

1013 руб

Экономия: 1477 руб

Бонус : 20 руб

Размеры в наличии: 35

KEDDO 527725/01-05 детские кеды

3490 руб

1752 руб

Экономия: 1738 руб

Бонус : 35 руб

Размеры в наличии: 36

Antilopa AL4360 детские кеды

2390 руб

1211 руб

Экономия: 1179 руб

Бонус : 24 руб

Размеры в наличии: 36

CROSBY 227077/02-04 детские слипоны

3490 руб

1752 руб

Экономия: 1738 руб

Бонус : 35 руб

Размеры в наличии: 34,35,36,37

Soter T012116W детские кеды

1790 руб

837 руб

Экономия: 953 руб

Бонус : 17 руб

Размеры в наличии: 35

KEDDO 527768/02-03 детские кеды

4190 руб

1992 руб

Экономия: 2198 руб

Бонус : 40 руб

Размеры в наличии: 37,38

CROSBY 227362/01-04 детские кроссовки

2290 руб

1058 руб

Экономия: 1232 руб

Бонус : 21 руб

Размеры в наличии: 31,32

V-Shoes - это интернет-магазин для любителей яркой, стильной, модной и комфортной обуви. Самые трендовые цвета и фасоны, акценты на детали, еженедельное пополнение коллекции, заманчивые предложения, выгодные цены, скидки - все это V-Shoes.

Предлагаем купить обувь в которой вы будете не только притягивать к себе восхищенные взгляды, подчеркивать свой статус, но и чувствовать себя комфортно весь день.

Вы недавно смотрели

Respect VS12-166727 женские сапоги

9610 руб

Respect VS12-170645 женские ботинки

5930 руб

Rieker Y4653-60 женские п/сапоги

6890 руб

Covani MKW23-BWLM3-204D женские ботинки

5970 руб

Madella XUS-23960-1S-SW женские полусапоги

5920 руб

Контакты

Адрес

600005 г. Владимир, ул. Тракторная 45

Телефон

8-800-234-88-37

Этот адрес электронной почты защищён от спам-ботов. У вас должен быть включен JavaScript для просмотра.

Консоль отладки Joomla!

Сессия

{
    "__default": {
        "session": {
            "counter": 11,
            "timer": {
                "start": 1716175066,
                "last": 1716175081,
                "now": 1716175083
            },
            "token": "27DTw1bxhYaXOgBPlkTJPH1pu3iAgZrv"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "4",
        "js_id_currency": "4",
        "js_history_sel_lang": "ru-RU",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "/shop/kids-shoes?start=108",
        "product_back_value": [],
        "last_visited_products": {
            "361012871": {
                "name": "Baden A510-012 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f/\u0441\u0430\u043f\u043e\u0433\u0438",
                "orig_image": "011123__480_.webp",
                "image": "011123__480_.webp",
                "product_thumb_image": "thumb_011123__480_.webp",
                "product_id": "361012871",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "5100.000000",
                "product_price": "5100.000000",
                "product_old_price": 6890,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "37",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "9",
                "category_id": 19310442,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "5100.000000",
                "product_price_wp": 5100,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "011123__480_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/30-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 30%",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361012871",
                "buy_link": "",
                "points_add": 102,
                "points_sub": 0
            },
            "361012317": {
                "name": "Sigma JTL02117-2G-6 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043a\u0440\u043e\u0441\u0441\u043e\u0432\u043a\u0438",
                "orig_image": "01122023__217_.webp",
                "image": "01122023__217_.webp",
                "product_thumb_image": "thumb_01122023__217_.webp",
                "product_id": "361012317",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "3980.000000",
                "product_price": "3980.000000",
                "product_old_price": 4690,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "847",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "7",
                "category_id": 19310438,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "3980.000000",
                "product_price_wp": 3980,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "01122023__217_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/20-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 20%",
                "product_link": "/shop/women-shoes/wom-kedy/product/view/19310438/361012317",
                "buy_link": "",
                "points_add": 79.599999999999994,
                "points_sub": 0
            },
            "361009637": {
                "name": "Tom Miki B-7784-A \u0434\u0435\u0442\u0441\u043a\u0438\u0435 \u0442\u0443\u0444\u043b\u0438",
                "orig_image": "DSC_0628-0000.webp",
                "image": "DSC_0628-0000.webp",
                "product_thumb_image": "thumb_DSC_0628-0000.webp",
                "product_id": "361009637",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "710.000000",
                "product_price": "710.000000",
                "product_old_price": 1550,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "912",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "14",
                "category_id": 17216259,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "710.000000",
                "product_price_wp": 710,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "DSC_0628-0000.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/55.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 55%",
                "product_link": "/shop/kids-shoes/girl/girl-tyfli/tom-miki-b-7784-a-detskie-tufli",
                "buy_link": "",
                "points_add": 14.199999999999999,
                "points_sub": 0
            },
            "361012608": {
                "name": "Niota PL19-4914-1 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "orig_image": "23102023__221_.webp",
                "image": "23102023__221_.webp",
                "product_thumb_image": "thumb_23102023__221_.webp",
                "product_id": "361012608",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "5580.000000",
                "product_price": "5580.000000",
                "product_old_price": 6590,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "1542",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "7",
                "category_id": 19310440,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "5580.000000",
                "product_price_wp": 5580,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "23102023__221_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/20-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 20%",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012608",
                "buy_link": "",
                "points_add": 111.59999999999999,
                "points_sub": 0
            },
            "361013001": {
                "name": "Madella XUS-23960-1S-SW \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f\u043e\u043b\u0443\u0441\u0430\u043f\u043e\u0433\u0438",
                "orig_image": "22012024-1__82_.webp",
                "image": "http://v-shoes.ru/components/com_jshopping/files/img_products/thumb_22012024-1__82_.webp",
                "product_thumb_image": "thumb_22012024-1__82_.webp",
                "product_id": "361013001",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "5920.000000",
                "product_price": 5920,
                "product_old_price": 6990,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "635",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "7",
                "category_id": 19310442,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "5920.000000",
                "product_price_wp": 5920,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "22012024-1__82_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/20-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 20%",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361013001",
                "buy_link": "",
                "points_add": 118.40000000000001,
                "points_sub": 0
            },
            "361012992": {
                "name": "Covani MKW23-BWLM3-204D \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "orig_image": "22012024__21_.webp",
                "image": "http://v-shoes.ru/components/com_jshopping/files/img_products/thumb_22012024__21_.webp",
                "product_thumb_image": "thumb_22012024__21_.webp",
                "product_id": "361012992",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "5970.000000",
                "product_price": 5970,
                "product_old_price": 7790,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "333",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "8",
                "category_id": 19310440,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "5970.000000",
                "product_price_wp": 5970,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "22012024__21_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/25.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 25%",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012992",
                "buy_link": "",
                "points_add": 119.40000000000001,
                "points_sub": 0
            },
            "361012872": {
                "name": "Rieker Y4653-60 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f/\u0441\u0430\u043f\u043e\u0433\u0438",
                "orig_image": "Y4653-60-223-a1.webp",
                "image": "http://v-shoes.ru/components/com_jshopping/files/img_products/thumb_Y4653-60-223-a1.webp",
                "product_thumb_image": "thumb_Y4653-60-223-a1.webp",
                "product_id": "361012872",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "6890.000000",
                "product_price": 6890,
                "product_old_price": 8990,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "18",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "8",
                "category_id": 19310442,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "6890.000000",
                "product_price_wp": 6890,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "Y4653-60-223-a1.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/25.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 25%",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361012872",
                "buy_link": "",
                "points_add": 137.80000000000001,
                "points_sub": 0
            },
            "361012603": {
                "name": "Respect VS12-170645 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "orig_image": "10112023_221_.webp",
                "image": "http://v-shoes.ru/components/com_jshopping/files/img_products/thumb_10112023_221_.webp",
                "product_thumb_image": "thumb_10112023_221_.webp",
                "product_id": "361012603",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "5930.000000",
                "product_price": 5930,
                "product_old_price": 6990,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "15",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "7",
                "category_id": 19310440,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "5930.000000",
                "product_price_wp": 5930,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "10112023_221_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/20-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 20%",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012603",
                "buy_link": "",
                "points_add": 118.59999999999999,
                "points_sub": 0
            },
            "361012942": {
                "name": "Respect VS12-166727 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0441\u0430\u043f\u043e\u0433\u0438",
                "orig_image": "22112023__161_.webp",
                "image": "http://v-shoes.ru/components/com_jshopping/files/img_products/thumb_22112023__161_.webp",
                "product_thumb_image": "thumb_22112023__161_.webp",
                "product_id": "361012942",
                "currency_id": "4",
                "tax_id": "1",
                "orig_product_price": "9610.000000",
                "product_price": 9610,
                "product_old_price": 15690,
                "min_price": "0.000000",
                "different_prices": "0",
                "product_manufacturer_id": "15",
                "vendor_id": "0",
                "delivery_times_id": "0",
                "label_id": "11",
                "category_id": 19310441,
                "_tmp_var_start": "",
                "_tmp_var_image_block": "",
                "_tmp_var_bottom_foto": "",
                "_tmp_var_old_price_ext": "",
                "_tmp_var_bottom_price": "",
                "_tmp_var_bottom_old_price": "",
                "_tmp_var_price_ext": "",
                "_tmp_var_top_buttons": "",
                "_tmp_var_buttons": "",
                "_tmp_var_bottom_buttons": "",
                "_tmp_var_end": "",
                "_original_product_price": "9610.000000",
                "product_price_wp": 9610,
                "product_price_default": 0,
                "show_price_from": 0,
                "basic_price_info": {
                    "price_show": 0
                },
                "tax": "19.00",
                "manufacturer": {
                    "name": ""
                },
                "extra_field": [],
                "vendor": "",
                "delivery_time": "",
                "_display_price": 1,
                "product_name_image": "22112023__161_.webp",
                "template_block_product": "product.php",
                "_label_image": "http://v-shoes.ru/components/com_jshopping/files/img_labels/40-1.png",
                "_label_name": "\u0421\u043a\u0438\u0434\u043a\u0430 40%",
                "product_link": "/shop/women-shoes/wom-sapogi/product/view/19310441/361012942",
                "buy_link": "",
                "points_add": 192.19999999999999,
                "points_sub": 0
            }
        },
        "shopdockbar_history": {
            "361012871": {
                "name": "Baden A510-012 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f/\u0441\u0430\u043f\u043e\u0433\u0438",
                "product_thumb_image": "thumb_011123__480_.webp",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361012871"
            },
            "361012317": {
                "name": "Sigma JTL02117-2G-6 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043a\u0440\u043e\u0441\u0441\u043e\u0432\u043a\u0438",
                "product_thumb_image": "thumb_01122023__217_.webp",
                "product_link": "/shop/women-shoes/wom-kedy/product/view/19310438/361012317"
            },
            "361009637": {
                "name": "Tom Miki B-7784-A \u0434\u0435\u0442\u0441\u043a\u0438\u0435 \u0442\u0443\u0444\u043b\u0438",
                "product_thumb_image": "thumb_DSC_0628-0000.webp",
                "product_link": "/shop/kids-shoes/girl/girl-tyfli/tom-miki-b-7784-a-detskie-tufli"
            },
            "361012608": {
                "name": "Niota PL19-4914-1 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "product_thumb_image": "thumb_23102023__221_.webp",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012608"
            },
            "361013001": {
                "name": "Madella XUS-23960-1S-SW \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f\u043e\u043b\u0443\u0441\u0430\u043f\u043e\u0433\u0438",
                "product_thumb_image": "thumb_22012024-1__82_.webp",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361013001"
            },
            "361012992": {
                "name": "Covani MKW23-BWLM3-204D \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "product_thumb_image": "thumb_22012024__21_.webp",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012992"
            },
            "361012872": {
                "name": "Rieker Y4653-60 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u043f/\u0441\u0430\u043f\u043e\u0433\u0438",
                "product_thumb_image": "thumb_Y4653-60-223-a1.webp",
                "product_link": "/shop/women-shoes/wom-polysapogi/product/view/19310442/361012872"
            },
            "361012603": {
                "name": "Respect VS12-170645 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "product_thumb_image": "thumb_10112023_221_.webp",
                "product_link": "/shop/women-shoes/wom-botinki/product/view/19310440/361012603"
            },
            "361012942": {
                "name": "Respect VS12-166727 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0441\u0430\u043f\u043e\u0433\u0438",
                "product_thumb_image": "thumb_22112023__161_.webp",
                "product_link": "/shop/women-shoes/wom-sapogi/product/view/19310441/361012942"
            }
        },
        "5ead07849d37f07e588fbf09aedaab63": 1,
        "shopdockbar_compare": {
            "361012818": {
                "name": "Respect VS12-168823 \u0436\u0435\u043d\u0441\u043a\u0438\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438",
                "image": "22112023__194_.webp",
                "href": "/shop/women-shoes/wom-botinki/product/view/19310440/361012818",
                "href_delete": "/shop/shopdockbar/removeFromCompare?category_id=19310440&amp;product_id=361012818"
            }
        },
        "jshop_end_page_list_product": "/shop/kids-shoes?start=108"
    }
}

Результаты профилирования

Время

Память

Время: 32.80 ms / 32.80 ms Память: 0.553 MB / 0.89 MB Application: afterLoad

Время: 197.28 ms / 230.07 ms Память: 7.565 MB / 8.46 MB Application: afterInitialise

Время: 42.11 ms / 272.19 ms Память: 0.443 MB / 8.90 MB Application: Before Access::preloadComponents (all components)

Время: 3.04 ms / 275.22 ms Память: 0.070 MB / 8.97 MB Application: After Access::preloadComponents (all components)

Время: 0.03 ms / 275.25 ms Память: -0.004 MB / 8.97 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Время: 0.88 ms / 276.13 ms Память: 0.008 MB / 8.98 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Время: 2.17 ms / 278.30 ms Память: 0.023 MB / 9.00 MB Application: afterRoute

Время: 1.43 ms / 279.72 ms Память: 0.023 MB / 9.02 MB Application: beforeRenderComponent com_jshopping

Время: 384.24 ms / 663.96 ms Память: 9.123 MB / 18.15 MB Application: afterRenderComponent com_jshopping

Время: 0.62 ms / 664.58 ms Память: 0.006 MB / 18.15 MB Application: afterDispatch

Время: 22.56 ms / 687.14 ms Память: 0.812 MB / 18.96 MB Application: beforeRenderModule mod_custom (Женское - меню)

Время: 1.75 ms / 688.89 ms Память: 0.020 MB / 18.98 MB Application: afterRenderModule mod_custom (Женское - меню)

Время: 9.42 ms / 698.31 ms Память: 0.023 MB / 19.01 MB Application: beforeRenderModule mod_custom (мужское - меню)

Время: 0.46 ms / 698.77 ms Память: 0.017 MB / 19.02 MB Application: afterRenderModule mod_custom (мужское - меню)

Время: 421.47 ms / 1120.25 ms Память: 0.416 MB / 19.44 MB Application: beforeRenderModule mod_custom (Footer 2 - Master Card)

Время: 0.18 ms / 1120.42 ms Память: 0.005 MB / 19.44 MB Application: afterRenderModule mod_custom (Footer 2 - Master Card)

Время: 0.05 ms / 1120.47 ms Память: -0.001 MB / 19.44 MB Application: beforeRenderModule mod_menu ({icon-10} Информация)

Время: 4.04 ms / 1124.50 ms Память: 0.066 MB / 19.51 MB Application: afterRenderModule mod_menu ({icon-10} Информация)

Время: 0.06 ms / 1124.57 ms Память: -0.004 MB / 19.50 MB Application: beforeRenderModule mod_menu ({icon-9} Партнерам)

Время: 0.89 ms / 1125.45 ms Память: 0.026 MB / 19.53 MB Application: afterRenderModule mod_menu ({icon-9} Партнерам)

Время: 0.05 ms / 1125.50 ms Память: -0.002 MB / 19.53 MB Application: beforeRenderModule mod_menu ({icon-8} Мой аккаунт)

Время: 1.46 ms / 1126.96 ms Память: 0.042 MB / 19.57 MB Application: afterRenderModule mod_menu ({icon-8} Мой аккаунт)

Время: 0.05 ms / 1127.00 ms Память: -0.003 MB / 19.57 MB Application: beforeRenderModule mod_custom ({icon-7} Контакты)

Время: 10.34 ms / 1137.35 ms Память: 0.014 MB / 19.58 MB Application: afterRenderModule mod_custom ({icon-7} Контакты)

Время: 0.08 ms / 1137.43 ms Память: -0.002 MB / 19.58 MB Application: beforeRenderModule mod_custom (Описание на главной)

Время: 0.13 ms / 1137.56 ms Память: 0.004 MB / 19.58 MB Application: afterRenderModule mod_custom (Описание на главной)

Время: 0.02 ms / 1137.58 ms Память: -0.002 MB / 19.58 MB Application: beforeRenderModule mod_jshopping_last_visit_products (Вы недавно смотрели)

Время: 2.00 ms / 1139.59 ms Память: 0.024 MB / 19.61 MB Application: afterRenderModule mod_jshopping_last_visit_products (Вы недавно смотрели)

Время: 0.06 ms / 1139.65 ms Память: 0.004 MB / 19.61 MB Application: beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced)

Время: 2.61 ms / 1142.26 ms Память: -0.022 MB / 19.59 MB Application: afterRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced)

Время: 0.07 ms / 1142.33 ms Память: -0.001 MB / 19.59 MB Application: beforeRenderModule mod_jshopping_shopdockbar (JoomShopping - Shop Dock Bar)

Время: 2.48 ms / 1144.81 ms Память: 0.031 MB / 19.62 MB Application: afterRenderModule mod_jshopping_shopdockbar (JoomShopping - Shop Dock Bar)

Время: 0.07 ms / 1144.88 ms Память: -0.012 MB / 19.61 MB Application: beforeRenderModule mod_custom (Header 2 - Cart_Search)

Время: 0.21 ms / 1145.09 ms Память: 0.045 MB / 19.65 MB Application: beforeRenderModule mod_jshopping_cart (Header Cart Small)

Время: 0.75 ms / 1145.85 ms Память: 0.009 MB / 19.66 MB Application: afterRenderModule mod_jshopping_cart (Header Cart Small)

Время: 0.21 ms / 1146.05 ms Память: -0.038 MB / 19.62 MB Application: afterRenderModule mod_custom (Header 2 - Cart_Search)

Время: 0.07 ms / 1146.12 ms Память: -0.002 MB / 19.62 MB Application: beforeRenderModule mod_jshopping_ajaxsearch (Поиск ajax)

Время: 2.53 ms / 1148.66 ms Память: 0.068 MB / 19.69 MB Application: afterRenderModule mod_jshopping_ajaxsearch (Поиск ajax)

Время: 0.06 ms / 1148.72 ms Память: -0.052 MB / 19.64 MB Application: beforeRenderModule mod_custom (Top 2)

Время: 0.20 ms / 1148.92 ms Память: 0.042 MB / 19.68 MB Application: beforeRenderModule mod_custom (google)

Время: 0.13 ms / 1149.05 ms Память: 0.004 MB / 19.68 MB Application: afterRenderModule mod_custom (google)

Время: 0.03 ms / 1149.08 ms Память: -0.001 MB / 19.68 MB Application: beforeRenderModule mod_bm_cool_menu (BM Cool Menu)

Время: 3.61 ms / 1152.69 ms Память: 0.030 MB / 19.71 MB Application: afterRenderModule mod_bm_cool_menu (BM Cool Menu)

Время: 0.12 ms / 1152.81 ms Память: -0.040 MB / 19.67 MB Application: afterRenderModule mod_custom (Top 2)

Время: 0.07 ms / 1152.88 ms Память: -0.003 MB / 19.67 MB Application: beforeRenderModule mod_custom (Top 1)

Время: 0.21 ms / 1153.09 ms Память: 0.004 MB / 19.67 MB Application: afterRenderModule mod_custom (Top 1)

Время: 17.62 ms / 1170.71 ms Память: 0.285 MB / 19.96 MB Application: afterRender

Всего SQL-запросов: 194.84 ms

Использование памяти

Запросы к базе данных

76 SQL-запросов зафиксировано 194.84 ms

4 повторяющийся запрос!

2 повторов: #28 #71

2 повторов: #36 #40

Время запроса: 0.49 ms Память запроса: 0.078 MB Память до запроса: 1.366 MB Выбрано строк: 1

SELECT `data`

  FROM `optima_session`

  WHERE `session_id` = X'3238646263316364336636336137616636626661383937386139353664623335'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.30 ms После последнего запроса: 6.14 ms Память запроса: 0.026 MB Память до запроса: 1.589 MB Выбрано строк: 54

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `optima_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_extensions	NULL	ref	extension	extension	82	const	57	1.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.58 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Так же, как вызов в строке ниже.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.83 ms После последнего запроса: 4.90 ms Память запроса: 0.021 MB Память до запроса: 1.633 MB Выбрано строк: 5

SELECT id, rules

  FROM `optima_viewlevels`

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_viewlevels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	5	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.07 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.62 ms После последнего запроса: 0.12 ms Память запроса: 0.021 MB Память до запроса: 1.645 MB Выбрано строк: 1

SELECT b.id

  FROM optima_usergroups AS a

  LEFT JOIN optima_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

Профилирование SQL-запросов

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 3.36 ms После последнего запроса: 1.95 ms Память запроса: 0.051 MB Память до запроса: 1.667 MB Выбрано строк: 149

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM optima_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_extensions	NULL	ref	extension	extension	82	const	218	0.40	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	2.58 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.08 ms После последнего запроса: 72.72 ms Память запроса: 0.025 MB Память до запроса: 2.866 MB Выбрано строк: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `optima_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.04 ms
executing	0.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Так же, как вызов в строке ниже.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:31
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:19
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:14
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 5.13 ms После последнего запроса: 0.22 ms Память запроса: 0.007 MB Память до запроса: 2.859 MB

UPDATE `optima_extensions`

  SET `params` = '{\"mediaversion\":\"3cb2bcb00755d05693082011c16d4943\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: UPDATE `optima_extensions` SET `params` = '{\"mediaversion\":\"3cb2bcb00755d05693082011c16d4943\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.14 ms
updating	0.25 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	4.47 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:31
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:19
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:14
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 17.03 ms После последнего запроса: 5.84 ms Память запроса: 1.839 MB Память до запроса: 2.906 MB Выбрано строк: 1396

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM optima_menu AS m

  LEFT JOIN optima_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	Индекс не используется	NULL	NULL	1515	10.00	Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.m.component_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.06 ms
executing	16.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
23	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Так же, как вызов в строке ниже.
22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
20	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
19	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
18	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
17	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
16	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
15	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:44
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:82
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:235
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:224
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1262
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:15
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.86 ms После последнего запроса: 21.03 ms Память запроса: 0.054 MB Память до запроса: 8.308 MB Выбрано строк: 3

SELECT id, home, template, s.params

  FROM optima_template_styles as s

  LEFT JOIN optima_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	vshoes.e.element	1	75.00	Using index condition; Using where

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.30 ms
end	0.00 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:44
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:82
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:235
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:224
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1262
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:15
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.82 ms После последнего запроса: 53.27 ms Память запроса: 0.028 MB Память до запроса: 8.907 MB Выбрано строк: 54

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `optima_assets`

  WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_advancedtemplates','com_ajax','com_argensyml','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_excel2js','com_fields','com_finder','com_installer','com_jamegafilter','com_jce','com_jcomments','com_jlsitemap','com_jmap','com_joomlaupdate','com_jshopping','com_jshopping2sms','com_jsrefsystem','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_offlajn_installer','com_osmap','com_plugins','com_postinstall','com_qf3','com_redirect','com_rstbox','com_search','com_smartforms','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	55	100.00	Using index condition

Профилирование SQL-запросов

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.48 ms
preparing	0.06 ms
executing	1.52 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:99
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.85 ms После последнего запроса: 3.30 ms Память запроса: 0.020 MB Память до запроса: 9.002 MB Выбрано строк: 2

SELECT *

  FROM optima_languages

  WHERE published=1

  ORDER BY ordering ASC

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_languages	NULL	ALL	NULL	Индекс не используется	NULL	NULL	2	50.00	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.13 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 9.31 ms После последнего запроса: 7.67 ms Память запроса: 0.046 MB Память до запроса: 9.083 MB Выбрано строк: 140

SHOW FULL COLUMNS 
  FROM `optima_jshopping_config`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_config`

Профилирование SQL-запросов

Status	Duration
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.07 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.30 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
12	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.92 ms После последнего запроса: 2.56 ms Память запроса: 0.075 MB Память до запроса: 9.300 MB Выбрано строк: 1

SELECT *

  FROM optima_jshopping_config

  WHERE `id` = '1'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_config	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.69 ms После последнего запроса: 0.95 ms Память запроса: 0.027 MB Память до запроса: 9.297 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `optima_jshopping_currencies`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_currencies`

Профилирование SQL-запросов

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.53 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
16	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
13	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
12	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.27 ms После последнего запроса: 0.15 ms Память запроса: 0.023 MB Память до запроса: 9.316 MB Выбрано строк: 1

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `optima_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_currencies	NULL	ref	currency_publish	currency_publish	1	const	1	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
14	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
13	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
12	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 4.54 ms После последнего запроса: 5.04 ms Память запроса: 0.038 MB Память до запроса: 9.330 MB Выбрано строк: 57

SHOW FULL COLUMNS 
  FROM `optima_jshopping_users`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_users`

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.48 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.16 ms
checking permissions	0.10 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.17 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
16	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
15	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
14	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:70
13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.77 ms После последнего запроса: 13.10 ms Память запроса: 0.029 MB Память до запроса: 9.521 MB Выбрано строк: 10

SHOW FULL COLUMNS 
  FROM `optima_jshopping_usergroups`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_usergroups`

Профилирование SQL-запросов

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.93 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.21 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
executing	0.13 ms
checking permissions	0.11 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.09 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
18	jshopUserGroup->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
16	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
15	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
14	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:74
13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.04 ms После последнего запроса: 0.39 ms Память запроса: 0.026 MB Память до запроса: 9.554 MB Выбрано строк: 4

SHOW FULL COLUMNS 
  FROM `optima_jshopping_config_display_prices`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_config_display_prices`

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.82 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.05 ms
Creating tmp table	0.08 ms
executing	0.10 ms
checking permissions	0.09 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:14
16	jshopConfigDisplayPrice->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:82
13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.29 ms После последнего запроса: 0.14 ms Память запроса: 0.023 MB Память до запроса: 9.569 MB Выбрано строк: 1

SELECT * 
  FROM `optima_jshopping_config_display_prices`

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_config_display_prices	NULL	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/configdisplayprice.php:33
14	jshopConfigDisplayPrice->getList()	JROOT/components/com_jshopping/tables/config.php:83
13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:15
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 4.72 ms После последнего запроса: 22.91 ms Память запроса: 0.033 MB Память до запроса: 9.658 MB Выбрано строк: 45

SHOW FULL COLUMNS 
  FROM `optima_jshopping_coupons`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_coupons`

Профилирование SQL-запросов

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.95 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.24 ms
preparing	0.06 ms
Creating tmp table	0.11 ms
executing	0.14 ms
checking permissions	0.11 ms
checking permissions	0.07 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.09 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.16 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/coupon.php:14
13	jshopCoupon->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jshoppingcheckout/extrascoupon/extrascoupon.php:454
11	plgJshoppingCheckoutExtrasCoupon->storeFreePaymentAndShipping()	JROOT/plugins/jshoppingcheckout/extrascoupon/extrascoupon.php:446
10	plgJshoppingCheckoutExtrasCoupon->onAfterLoadShopParams()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/components/com_jshopping/loadparams.php:44
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.63 ms После последнего запроса: 2.97 ms Память запроса: 0.025 MB Память до запроса: 9.787 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `optima_jshopping_addons`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_addons`

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.94 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.20 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
executing	0.13 ms
checking permissions	0.10 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/addon.php:20
12	jshopAddon->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:9
10	plgJshoppingProductsBa_more_photos_products_list->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jshopping/controllers/category.php:15
7	JshoppingControllerCategory->__construct()	JROOT/components/com_jshopping/jshopping.php:24
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.45 ms После последнего запроса: 0.19 ms Память запроса: 0.022 MB Память до запроса: 9.807 MB Выбрано строк: 1

SELECT *

  FROM optima_jshopping_addons

  WHERE `alias` = 'ba_more_photos_products_list'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_addons	NULL	ref	alias	alias	767	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/addon.php:36
11	jshopAddon->loadAlias()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:9
10	plgJshoppingProductsBa_more_photos_products_list->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jshopping/controllers/category.php:15
7	JshoppingControllerCategory->__construct()	JROOT/components/com_jshopping/jshopping.php:24
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 3.57 ms После последнего запроса: 17.80 ms Память запроса: 0.027 MB Память до запроса: 9.913 MB Выбрано строк: 25

SHOW FULL COLUMNS 
  FROM `optima_jshopping_categories`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_categories`

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.94 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.21 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
executing	0.14 ms
checking permissions	0.10 ms
checking permissions	0.06 ms
checking permissions	0.11 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.12 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
11	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/category.php:59
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.40 ms После последнего запроса: 0.20 ms Память запроса: 0.022 MB Память до запроса: 9.950 MB Выбрано строк: 1

SELECT *

  FROM optima_jshopping_categories

  WHERE `category_id` = '21481763'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/category.php:60
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.48 ms После последнего запроса: 15.07 ms Память запроса: 0.025 MB Память до запроса: 10.087 MB Выбрано строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM optima_fields AS a

  LEFT JOIN `optima_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN optima_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN optima_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN optima_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN optima_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Используется filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	vshoes.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.group_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.25 ms
preparing	0.05 ms
Creating tmp table	0.12 ms
executing	0.11 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:950
11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:254
10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:61
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.87 ms После последнего запроса: 0.60 ms Память запроса: 0.022 MB Память до запроса: 10.096 MB Выбрано строк: 2

SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `optima_jshopping_categories`
                   
  WHERE category_parent_id = '21481763'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY ordering asc

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	2	100.00	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.11 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 4.30 ms После последнего запроса: 0.17 ms Память запроса: 0.216 MB Память до запроса: 10.105 MB Выбрано строк: 1293

select id,link 
  from optima_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='ru-RU') 
  and access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_menu	NULL	ALL	idx_client_id_parent_id_alias_language,idx_language	Индекс не используется	NULL	NULL	1515	0.07	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	3.72 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
16	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
15	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
14	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:403
13	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:422
12	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:481
11	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:69
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 3.69 ms После последнего запроса: 17.20 ms Память запроса: 0.319 MB Память до запроса: 11.739 MB Выбрано строк: 53

Повторяющиеся запросы: #71

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM optima_modules AS m

  LEFT JOIN optima_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN optima_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	60	10.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	vshoes.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.m.id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.22 ms
preparing	0.09 ms
executing	2.71 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:318
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:351
14	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:34
13	JModuleHelper::getModule()	JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:473
12	plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:156
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.63 ms После последнего запроса: 37.53 ms Память запроса: 0.033 MB Память до запроса: 13.849 MB Выбрано строк: 31

SHOW FULL COLUMNS 
  FROM `optima_jshopping_vendors`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_vendors`

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.68 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.10 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/vendor.php:15
15	jshopVendor->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:435
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.26 ms После последнего запроса: 0.16 ms Память запроса: 0.023 MB Память до запроса: 13.890 MB Выбрано строк: 1

SELECT id 
  FROM optima_jshopping_vendors 
  WHERE `main`=1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_vendors	NULL	ref	main	main	1	const	1	100.00	Using index

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/vendor.php:23
13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:436
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 13.901 MB Выбрано строк: 1

SELECT *

  FROM optima_jshopping_vendors

  WHERE `id` = '1'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_vendors	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/vendor.php:24
13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:436
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1449
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:307
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.63 ms После последнего запроса: 0.52 ms Память запроса: 0.027 MB Память до запроса: 13.909 MB Выбрано строк: 11

SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_extra_fields`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_products_extra_fields`

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.54 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.08 ms
checking permissions	0.10 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
16	jshopProductField->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:496
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1136
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.60 ms После последнего запроса: 0.11 ms Память запроса: 0.028 MB Память до запроса: 13.938 MB Выбрано строк: 21

SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_ru-RU` as groupname, multilist 
  FROM `optima_jshopping_products_extra_fields` as F 
  left join `optima_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	F	NULL	ALL	NULL	Индекс не используется	NULL	NULL	21	100.00	Using temporary; Используется filesort
1	SIMPLE	G	NULL	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.11 ms
executing	0.18 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
14	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:497
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1136
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.34 ms После последнего запроса: 0.62 ms Память запроса: 0.026 MB Память до запроса: 13.967 MB Выбрано строк: 3

SHOW FULL COLUMNS 
  FROM `optima_jshopping_taxes`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_taxes`

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.52 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.07 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
17	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:369
14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:991
13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.20 ms После последнего запроса: 0.14 ms Память запроса: 0.024 MB Память до запроса: 13.982 MB Выбрано строк: 1

SELECT tax_id, tax_name, tax_value 
  FROM `optima_jshopping_taxes`

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_taxes	NULL	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
16	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:355
15	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:370
14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:991
13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:179
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.70 ms После последнего запроса: 0.14 ms Память запроса: 0.027 MB Память до запроса: 13.993 MB Выбрано строк: 80

Повторяющиеся запросы: #40

SELECT category_id, category_parent_id 
  FROM `optima_jshopping_categories`  
  where category_publish = '1' 
  and  access IN (1,1) 
  ORDER BY ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	ref	category_publish,access,category_publish_2	category_publish	1	const	80	100.00	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.40 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:115
14	jshopCategory->getAllCategories()	JROOT/plugins/jshoppingproducts/to_parent_category/to_parent_category.php:62
13	plgJshoppingProductsTo_Parent_Category->onBeforeQueryCountProductList()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/tables/category.php:182
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 22.18 ms После последнего запроса: 0.51 ms Память запроса: 0.022 MB Память до запроса: 13.998 MB Выбрано строк: 1

SELECT count(distinct prod.product_id) 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                  
  INNER JOIN `optima_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id
                   
                  
  WHERE pr_cat.category_id=21481763 
  AND prod.product_publish=1  
  AND prod.access IN (1,1) 
  AND prod.product_quantity > 0 OR (pr_cat.category_id IN (21481763,21481770,21481771,17216263,17216252,17216251,17216249,17216248,20055026,21481775,21685294,21481774,21481773,21825782,17216256,17216255,17216254,17216253,20055027,21481779,21481778,21685296,21685295,17216264,17216262,17216260,17216259,17216258,21825778) 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1) 
  AND prod.product_quantity > 0)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	range	PRIMARY,category_id,product_id,product_id_2	category_id	4	NULL	3789	100.00	Using where; Using index
1	SIMPLE	prod	NULL	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	vshoes.pr_cat.product_id	1	13.89	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.43 ms
preparing	0.06 ms
executing	21.21 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:190
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.54 ms После последнего запроса: 11.49 ms Память запроса: 0.024 MB Память до запроса: 14.035 MB Выбрано строк: 1

SELECT *

  FROM optima_jshopping_addons

  WHERE `alias` = 'addon_bonus_system'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_addons	NULL	ref	alias	alias	767	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/addon.php:36
15	jshopAddon->loadAlias()	JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:286
14	plgJshoppingProductsBonus_System->init()	JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:10
13	plgJshoppingProductsBonus_System->onBeforeQueryGetProductList()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/tables/category.php:158
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.20 ms После последнего запроса: 0.10 ms Память запроса: 0.024 MB Память до запроса: 14.057 MB Выбрано строк: 1

SELECT `usergroup_id` 
  FROM `optima_jshopping_usergroups` 
  WHERE `usergroup_is_default`= '1'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_usergroups	NULL	ref	usergroup_is_default	usergroup_is_default	1	const	1	100.00	Using index

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/usergroup.php:21
15	jshopUserGroup->getDefaultUsergroup()	JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:296
14	plgJshoppingProductsBonus_System->init()	JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:10
13	plgJshoppingProductsBonus_System->onBeforeQueryGetProductList()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/tables/category.php:158
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.88 ms После последнего запроса: 0.08 ms Память запроса: 0.027 MB Память до запроса: 14.064 MB Выбрано строк: 80

Повторяющиеся запросы: #36

SELECT category_id, category_parent_id 
  FROM `optima_jshopping_categories`  
  where category_publish = '1' 
  and  access IN (1,1) 
  ORDER BY ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	ref	category_publish,access,category_publish_2	category_publish	1	const	80	100.00	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.49 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.07 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:115
14	jshopCategory->getAllCategories()	JROOT/plugins/jshoppingproducts/to_parent_category/to_parent_category.php:29
13	plgJshoppingProductsTo_Parent_Category->onBeforeQueryGetProductList()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/tables/category.php:158
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 28.39 ms После последнего запроса: 0.78 ms Память запроса: 0.026 MB Память до запроса: 14.070 MB Выбрано строк: 9

SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_34` , prod.product_bonus_add, prod.product_bonus_sub 
  FROM `optima_jshopping_products` AS prod
                  
  LEFT JOIN `optima_jshopping_products_to_categories` AS pr_cat USING (product_id)
                  
                  
  WHERE pr_cat.category_id=21481763 
  AND prod.product_publish=1  
  AND prod.access IN (1,1) 
  AND prod.product_quantity > 0 OR (pr_cat.category_id IN (21481763,21481770,21481771,17216263,17216252,17216251,17216249,17216248,20055026,21481775,21685294,21481774,21481773,21825782,17216256,17216255,17216254,17216253,20055027,21481779,21481778,21685296,21685295,17216264,17216262,17216260,17216259,17216258,21825778) 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1) 
  AND prod.product_quantity > 0)  
  ORDER BY prod.product_date_added ASC 
  LIMIT 108, 9

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	range	PRIMARY,category_id,product_id,product_id_2	category_id	4	NULL	3789	100.00	Using where; Using index; Using temporary; Используется filesort
1	SIMPLE	prod	NULL	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	vshoes.pr_cat.product_id	1	13.89	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.65 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
executing	26.90 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:171
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.34 ms После последнего запроса: 0.60 ms Память запроса: 0.026 MB Память до запроса: 14.164 MB Выбрано строк: 5

SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_extra_field_values`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_products_extra_field_values`

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.07 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:15
16	jshopProductFieldValue->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:505
13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:821
12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:746
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:172
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.50 ms После последнего запроса: 0.08 ms Память запроса: 0.046 MB Память до запроса: 14.179 MB Выбрано строк: 266

SELECT id, `name_ru-RU` as name, field_id 
  FROM `optima_jshopping_products_extra_field_values` 
  order by ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_extra_field_values	NULL	ALL	NULL	Индекс не используется	NULL	NULL	266	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.28 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:26
14	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:506
13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:821
12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:746
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:172
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.17 ms После последнего запроса: 0.69 ms Память запроса: 0.026 MB Память до запроса: 14.253 MB Выбрано строк: 6

SHOW FULL COLUMNS 
  FROM `optima_jshopping_product_labels`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_product_labels`

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.43 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.06 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productlabel.php:14
15	jshopProductLabel->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/functions.php:633
12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:785
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:172
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 14.270 MB Выбрано строк: 22

SELECT id, image, `name_ru-RU` as name 
  FROM `optima_jshopping_product_labels` 
  ORDER BY name

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_product_labels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	22	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productlabel.php:22
13	jshopProductLabel->getListLabels()	JROOT/components/com_jshopping/lib/functions.php:634
12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:785
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:172
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 39.66 ms После последнего запроса: 0.42 ms Память запроса: 2.737 MB Память до запроса: 14.310 MB Выбрано строк: 28749

select product_id as id, `alias_ru-RU` as alias 
  from optima_jshopping_products 
  where `alias_ru-RU`!=''

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products	NULL	ALL	NULL	Индекс не используется	NULL	NULL	33269	90.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	38.95 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:303
21	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:81
20	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_jshopping/lib/functions.php:496
12	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:446
11	addLinkToProducts()	JROOT/components/com_jshopping/tables/category.php:173
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.59 ms После последнего запроса: 47.85 ms Память запроса: 0.030 MB Память до запроса: 17.812 MB Выбрано строк: 76

select category_id as id, `alias_ru-RU` as alias 
  from optima_jshopping_categories 
  where `alias_ru-RU`!=''

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	ALL	NULL	Индекс не используется	NULL	NULL	47	90.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
21	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:82
20	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_jshopping/lib/functions.php:496
12	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:446
11	addLinkToProducts()	JROOT/components/com_jshopping/tables/category.php:173
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.34 ms После последнего запроса: 2.30 ms Память запроса: 0.022 MB Память до запроса: 17.852 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361005732

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.20 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 17.860 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361005221

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	3	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.868 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361005051

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.875 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361004438

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.883 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361004128

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	3	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.23 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.890 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361004431

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.898 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361005880

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.18 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.905 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361004439

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 17.912 MB Выбрано строк: 2

SELECT image_name

  FROM optima_jshopping_products_images

  WHERE product_id = 361004795

  ORDER BY ordering ASC 
  LIMIT 2

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_products_images	NULL	ref	product_id	product_id	4	const	2	100.00	Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/jshoppingproducts/ba_more_photos_products_list/ba_more_photos_products_list.php:13
12	plgJshoppingProductsBa_more_photos_products_list->onBeforeDisplayProductList()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/models/productlist.php:187
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:76
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.70 ms После последнего запроса: 7.80 ms Память запроса: 0.026 MB Память до запроса: 17.941 MB Выбрано строк: 10

SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_reviews`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `optima_jshopping_products_reviews`

Профилирование SQL-запросов

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.62 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productlist.php:252
9	jshopProductList->getAllowReview()	JROOT/components/com_jshopping/controllers/category.php:90
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.44 ms После последнего запроса: 1.08 ms Память запроса: 0.022 MB Память до запроса: 17.968 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361005732 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 0.13 ms Память запроса: 0.022 MB Память до запроса: 17.976 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361005221 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.31 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 17.982 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361005051 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.37 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 17.989 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361004438 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.41 ms После последнего запроса: 0.16 ms Память запроса: 0.022 MB Память до запроса: 17.996 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361004128 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.40 ms После последнего запроса: 0.15 ms Память запроса: 0.022 MB Память до запроса: 18.002 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361004431 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.40 ms После последнего запроса: 0.15 ms Память запроса: 0.022 MB Память до запроса: 18.009 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361005880 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.47 ms После последнего запроса: 0.15 ms Память запроса: 0.028 MB Память до запроса: 18.025 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361004439 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.41 ms После последнего запроса: 0.16 ms Память запроса: 0.022 MB Память до запроса: 18.037 MB Выбрано строк: 1

SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=361004795 
  AND cat.category_publish=1  
  AND cat.access IN (1,1)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vshoes.pr_cat.category_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/jshopping/double_link/double_link.php:33
12	plgJshoppingDouble_link->getFirstCategoryId()	JROOT/plugins/jshopping/double_link/double_link.php:12
11	plgJshoppingDouble_link->onBeforeDisplayProductListView()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/components/com_jshopping/controllers/category.php:131
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.48 ms После последнего запроса: 31.06 ms Память запроса: 0.025 MB Память до запроса: 18.937 MB Выбрано строк: 1

SELECT id, title, module, position, content, showtitle, params

  FROM optima_modules AS m

  WHERE m.published = 1 
  AND m.id = 264 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 03:18:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 03:18:03') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/menu.php:649
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:236
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:583
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_optima/features/menu.php:32
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:168
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:935
8	Helix::Header()	JROOT/templates/vina_optima/index.php:25
7	require JROOT/templates/vina_optima/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.23 ms После последнего запроса: 1.44 ms Память запроса: 0.028 MB Память до запроса: 18.973 MB Выбрано строк: 1

SELECT a.params

  FROM optima_advancedmodules AS a

  WHERE a.moduleid = 264

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:231
25	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:214
24	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:610
23	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:390
22	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:160
21	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:235
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:236
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:583
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_optima/features/menu.php:32
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:168
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:935
8	Helix::Header()	JROOT/templates/vina_optima/index.php:25
7	require JROOT/templates/vina_optima/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.35 ms После последнего запроса: 9.17 ms Память запроса: 0.025 MB Память до запроса: 18.980 MB Выбрано строк: 1

SELECT id, title, module, position, content, showtitle, params

  FROM optima_modules AS m

  WHERE m.published = 1 
  AND m.id = 265 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 03:18:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 03:18:03') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/menu.php:649
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:236
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:583
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_optima/features/menu.php:32
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:168
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:935
8	Helix::Header()	JROOT/templates/vina_optima/index.php:25
7	require JROOT/templates/vina_optima/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.17 ms После последнего запроса: 0.22 ms Память запроса: 0.028 MB Память до запроса: 19.013 MB Выбрано строк: 1

SELECT a.params

  FROM optima_advancedmodules AS a

  WHERE a.moduleid = 265

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:231
25	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:214
24	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:610
23	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:390
22	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:160
21	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:235
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:236
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:583
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_optima/features/menu.php:32
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:168
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:935
8	Helix::Header()	JROOT/templates/vina_optima/index.php:25
7	require JROOT/templates/vina_optima/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 2.23 ms После последнего запроса: 8.91 ms Память запроса: 0.319 MB Память до запроса: 19.056 MB Выбрано строк: 53

Повторяющиеся запросы: #28

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM optima_modules AS m

  LEFT JOIN optima_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN optima_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	60	10.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	vshoes.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.m.id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
executing	1.74 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:318
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix/core/helix.php:586
11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:278
10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:354
9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:568
8	Helix::layout()	JROOT/templates/vina_optima/index.php:88
7	require JROOT/templates/vina_optima/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.82 ms После последнего запроса: 417.69 ms Память запроса: 0.026 MB Память до запроса: 19.587 MB Выбрано строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM optima_fields AS a

  LEFT JOIN `optima_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN optima_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN optima_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN optima_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN optima_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Используется filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	vshoes.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	vshoes.a.group_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.08 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.86 ms После последнего запроса: 18.35 ms Память запроса: 0.031 MB Память до запроса: 19.652 MB Выбрано строк: 80

SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish 
  FROM `optima_jshopping_categories`
				 
  where category_publish = '1' 
  and  access IN (1,1) 
  ORDER BY category_parent_id, ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jshopping_categories	NULL	ref	category_publish,access,category_publish_2	category_publish	1	const	80	100.00	Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.38 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:115
12	jshopCategory->getAllCategories()	JROOT/components/com_jshopping/lib/functions.php:349
11	buildTreeCategory()	JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php:16
10	include JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 10.21 ms Память запроса: 0.022 MB Память до запроса: 19.735 MB Выбрано строк: 0

SELECT alow_captcha

  FROM optima_baforms_forms

  WHERE alow_captcha <> '0' 
  AND published = 1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_baforms_forms	NULL	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_baforms/helpers/baforms.php:27
13	baformsHelper::addStyle()	JROOT/plugins/system/baforms/baforms.php:39
12	plgSystemBaforms->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.18 ms Память запроса: 0.022 MB Память до запроса: 19.741 MB Выбрано строк: 0

SELECT *
 
  FROM optima_jmap_metainfo
 
  WHERE `linkurl` = 'http://v-shoes.ru/shop/kids-shoes'
 
  AND `published` = 1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jmap_metainfo	NULL	ref	published	published	1	const	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:407
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 0.31 ms После последнего запроса: 10.66 ms Память запроса: 0.020 MB Память до запроса: 19.954 MB Выбрано строк: 0

SELECT *
 
  FROM optima_jmap_headings
 
  WHERE `linkurl` = 'http://v-shoes.ru/shop/kids-shoes'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	optima_jmap_headings	NULL	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:720
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

53 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

9 × SELECT image_name 
  FROM optima_jshopping_products_images

9 × SELECT pr_cat.category_id 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                 
  LEFT JOIN `optima_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `optima_extensions`

2 × SELECT * 
  FROM optima_jshopping_addons

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM optima_modules AS m 
  LEFT JOIN optima_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN optima_advancedmodules as am 
  ON am.moduleid = m.id

2 × SELECT a.params 
  FROM optima_advancedmodules AS a

2 × SELECT id, title, module, position, content, showtitle, params 
  FROM optima_modules AS m

2 × SELECT category_id, category_parent_id 
  FROM `optima_jshopping_categories`

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM optima_fields AS a 
  LEFT JOIN `optima_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN optima_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN optima_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN optima_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN optima_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT count(distinct prod.product_id) 
  FROM `optima_jshopping_products_to_categories` AS pr_cat
                   
  INNER JOIN `optima_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id

1 × SELECT `usergroup_id` 
  FROM `optima_jshopping_usergroups`

1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_34` , prod.product_bonus_add, prod.product_bonus_sub 
  FROM `optima_jshopping_products` AS prod
                   
  LEFT JOIN `optima_jshopping_products_to_categories` AS pr_cat USING (product_id)

1 × SELECT `data` 
  FROM `optima_session`

1 × SELECT id, `name_ru-RU` as name, field_id 
  FROM `optima_jshopping_products_extra_field_values`

1 × SELECT id, image, `name_ru-RU` as name 
  FROM `optima_jshopping_product_labels`

1 × select category_id as id, `alias_ru-RU` as alias 
  from optima_jshopping_categories

1 × SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish 
  FROM `optima_jshopping_categories`

1 × SELECT alow_captcha 
  FROM optima_baforms_forms

1 × SELECT *  
  FROM optima_jmap_metainfo

1 × select product_id as id, `alias_ru-RU` as alias 
  from optima_jshopping_products

1 × SELECT * 
  FROM optima_jshopping_vendors

1 × SELECT tax_id, tax_name, tax_value 
  FROM `optima_jshopping_taxes

```
1 × SELECT * 
  FROM optima_languages
```

1 × SELECT id, rules 
  FROM `optima_viewlevels

1 × SELECT b.id 
  FROM optima_usergroups AS a 
  LEFT JOIN optima_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM optima_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM optima_menu AS m 
  LEFT JOIN optima_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, home, template, s.params 
  FROM optima_template_styles as s 
  LEFT JOIN optima_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `optima_assets`

1 × SELECT * 
  FROM optima_jshopping_config

1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_ru-RU` as groupname, multilist 
  FROM `optima_jshopping_products_extra_fields` as F 
  left join `optima_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `optima_jshopping_currencies`

1 × SELECT * 
  FROM `optima_jshopping_config_display_prices

1 × SELECT * 
  FROM optima_jshopping_categories

1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `optima_jshopping_categories`

1 × select id,link 
  from optima_menu

1 × SELECT id 
  FROM optima_jshopping_vendors

1 × SELECT *  
  FROM optima_jmap_headings

Прочие SQL-запросы:

1 × UPDATE `optima_extensions` 
  SET `params` = '{\"mediaversion\":\"3cb2bcb00755d05693082011c16d4943\"}'

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_usergroups

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_config_display_prices

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_coupons

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_addons

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_vendors

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_extra_field_values

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_product_labels

1 × SHOW FULL COLUMNS 
  FROM `optima_jshopping_products_reviews