{{ related.coupon_discount_formatted }}

{{ related.name }}
Cargando...
Las orquídeas son flores elegantes asociadas a las almas jóvenes. Esta orquídea blanca es un regalo perfecto para llenar de vida la casa de alguien querido. Con unos cuidados básicos conseguirá florecer varias veces al año.
Maceta no incluida
Cada ramo es único y se envía puntual desde el taller de nuestros floristas. El equipo de atención al cliente garantiza la mejor experiencia.
Algunas flores se entregan un poco cerradas para garantizar su frescura, protegerlas durante el envío y poder admirar cómo florecen.
Puedes añadir gratis un mensaje personal junto con tu ramo de flores. Acorta distancias a través de las flores y las palabras.
149
Console |
1.103 s
Load Time |
459 Queries
Database |
14.95 MB
Memory Used |
247 Files
Included |
2322 Config
items loaded |
2 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
9Logs |
0 Errors |
0 Memory |
140 Speed |
speed | 0.811 msProfiler::init Start |
log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
speed | 23.779 msFuel\Core\Fuel::init End |
speed | 23.786 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
speed | 24.650 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
speed | 76.487 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
speed | 80.365 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
speed | 81.274 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
speed | 81.319 msFuel\Core\Uri::__construct Start |
speed | 81.333 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "enviar-flores/orquidea-blanca-clasica" |
speed | 85.405 msFuel\Core\Request::execute: Start of enviar-flores/orquidea-blanca-clasica |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 85.816 msController_Base::before init |
speed | 88.625 msController_Base::get_top_delivery_countries global delivery_countries init |
speed | 89.848 msController_Base::get_top_delivery_countries global delivery_countries end |
log | Fuel\Core\Request_Curl::__construct - Creating a new CURL Request with URI = "https://maps.googleapis.com/maps/api/place/details/json" |
speed | 148.411 msCatalogs::get_collection collection array chunk init |
speed | 149.751 msCatalogs::get_collection collection array chunk end |
speed | 150.059 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 150.082 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 165.840 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 165.856 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 173.750 msCatalogs::get_collection collection array chunk init |
speed | 175.820 msCatalogs::get_collection collection array chunk end |
speed | 176.166 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 176.388 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 176.977 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 177.394 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 177.841 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 178.255 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 178.666 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 179.078 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 179.093 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 179.114 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 180.700 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 180.720 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 180.917 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ7200 from collection Array
(
[a] => ES
)
|
speed | 180.930 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 182.408 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 182.432 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 182.640 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ2308 from collection Array
(
[a] => ES
)
|
speed | 182.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 182.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ2316 from collection Array
(
[a] => ES
)
|
speed | 182.842 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 183.628 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 183.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 183.879 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ2505 from collection Array
(
[a] => ES
)
|
speed | 183.902 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 831.569 msController_Base::after menu init |
speed | 838.839 msController_Base::after FOTOMENU START |
speed | 839.379 msCatalogs::get_collection collection array chunk init |
speed | 841.521 msCatalogs::get_collection collection array chunk end |
speed | 842.024 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 842.036 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 843.626 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 843.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 845.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 845.171 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 846.741 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 846.766 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 848.238 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 848.257 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 849.714 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 850.061 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 850.735 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
speed | 850.752 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 850.764 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 852.261 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 852.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 853.151 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 853.557 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 853.986 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 854.406 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 854.869 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 855.268 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 855.282 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 855.302 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 856.883 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 856.903 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 858.429 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 858.449 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 864.120 msCatalogs::get_collection collection array chunk init |
speed | 866.093 msCatalogs::get_collection collection array chunk end |
speed | 866.520 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 866.529 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 868.073 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 868.093 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 869.592 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 869.612 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 870.026 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 870.037 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 871.480 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 871.698 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 872.326 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 872.740 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 873.160 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 873.585 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 874.006 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 874.416 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 874.430 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 874.450 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 875.945 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 875.964 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 876.379 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 876.389 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 877.870 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 877.900 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 878.424 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 878.434 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 879.920 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 879.939 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 927.348 msCatalogs::get_collection collection array chunk init |
speed | 929.318 msCatalogs::get_collection collection array chunk end |
speed | 929.665 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 929.681 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 930.380 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 930.399 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 931.028 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 931.053 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 931.461 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 931.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 931.877 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 931.887 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 932.282 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 932.293 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 932.682 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 932.693 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 933.297 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 933.311 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 933.921 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 933.944 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 934.345 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 934.356 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 934.995 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 935.009 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 942.882 msController_Base::after FOTOMENU END |
speed | 965.671 msController_Base::after menu end |
speed | 965.675 msController_Base::compress_html-START |
speed | 995.423 msController_Base::compress_html-END |
speed | 995.433 msController_Base::replace_html init |
speed | 995.531 msController_Base::replace_html end |
speed | 997.765 msFuel\Core\Request::execute: End of enviar-flores/orquidea-blanca-clasica |
speed | 997.935 msEnd of Fuel Execution |
1.103 sLoad Time |
6 s Max Execution Time |
0.811 msProfiler::init Start |
23.779 msFuel\Core\Fuel::init End |
23.786 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
24.650 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
76.487 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
80.365 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
81.274 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
81.319 msFuel\Core\Uri::__construct Start |
81.333 msFuel\Core\Uri::__construct End |
85.405 msFuel\Core\Request::execute: Start of enviar-flores/orquidea-blanca-clasica |
85.816 msController_Base::before init |
88.625 msController_Base::get_top_delivery_countries global delivery_countries init |
89.848 msController_Base::get_top_delivery_countries global delivery_countries end |
148.411 msCatalogs::get_collection collection array chunk init |
149.751 msCatalogs::get_collection collection array chunk end |
150.059 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
150.082 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
165.840 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
165.856 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
173.750 msCatalogs::get_collection collection array chunk init |
175.820 msCatalogs::get_collection collection array chunk end |
176.166 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
176.388 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
176.977 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
177.394 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
177.841 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
178.255 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
178.666 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
179.078 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
179.093 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
179.114 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
180.700 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
180.720 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
180.917 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
180.930 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
182.408 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
182.432 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
182.640 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
182.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
182.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
182.842 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
183.628 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
183.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
183.879 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
183.902 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
831.569 msController_Base::after menu init |
838.839 msController_Base::after FOTOMENU START |
839.379 msCatalogs::get_collection collection array chunk init |
841.521 msCatalogs::get_collection collection array chunk end |
842.024 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
842.036 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
843.626 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
843.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
845.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
845.171 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
846.741 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
846.766 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
848.238 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
848.257 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
849.714 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
850.061 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
850.735 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
850.752 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
850.764 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
852.261 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
852.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
853.151 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
853.557 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
853.986 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
854.406 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
854.869 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
855.268 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
855.282 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
855.302 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
856.883 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
856.903 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
858.429 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
858.449 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
864.120 msCatalogs::get_collection collection array chunk init |
866.093 msCatalogs::get_collection collection array chunk end |
866.520 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
866.529 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
868.073 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
868.093 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
869.592 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
869.612 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
870.026 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
870.037 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
871.480 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
871.698 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
872.326 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
872.740 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
873.160 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
873.585 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
874.006 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
874.416 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
874.430 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
874.450 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
875.945 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
875.964 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
876.379 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
876.389 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
877.870 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
877.900 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
878.424 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
878.434 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
879.920 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
879.939 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
927.348 msCatalogs::get_collection collection array chunk init |
929.318 msCatalogs::get_collection collection array chunk end |
929.665 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
929.681 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
930.380 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
930.399 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
931.028 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
931.053 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
931.461 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
931.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
931.877 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
931.887 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
932.282 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
932.293 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
932.682 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
932.693 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
933.297 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
933.311 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
933.921 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
933.944 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
934.345 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
934.356 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
934.995 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
935.009 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
942.882 msController_Base::after FOTOMENU END |
965.671 msController_Base::after menu end |
965.675 msController_Base::compress_html-START |
995.423 msController_Base::compress_html-END |
995.433 msController_Base::replace_html init |
995.531 msController_Base::replace_html end |
997.765 msFuel\Core\Request::execute: End of enviar-flores/orquidea-blanca-clasica |
997.935 msEnd of Fuel Execution |
459Total Queries |
187.565 ms Total Time |
306 Duplicates |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.161 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.149 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 22File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default Speed: 7.302 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2957 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/config/staging/my.php, line 48File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default Speed: 0.191 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 77File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.149 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 102File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/orquidea-blanca-clasica' LIMIT 1Connection name: default Speed: 0.300 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 274File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/orquidea-blanca-clasica' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.134 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 310File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default Speed: 39.380 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27952 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 25File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('es_ES')Connection name: default Speed: 2.540 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 6270 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 38File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default Speed: 0.212 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 383File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/enviar-flores/orquidea-blanca-clasica' LIMIT 1Connection name: default Speed: 0.207 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-05-25' ORDER BY event_start_date ASCConnection name: slave Speed: 0.155 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 124File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.150 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 179File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.175 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23950 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1149File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 0.191 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75787 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'enviar-flores/orquidea-blanca-clasica' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.177 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-05-25 21:00:00') AND (date_end IS null OR date_end >= '2022-05-25 21:00:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on domain_combar · Possible keys: IDX_B514A64819EABE6 · Key Used: IDX_B514A64819EABE6 · Type: ref · Rows: 10 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/combar.php, line 95File: APPPATH/classes/controller/product.php, line 60File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE sku = '6325' LIMIT 1Connection name: slave Speed: 0.248 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 58File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.* FROM product_languages WHERE (id = '6325') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.227 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: PRIMARY,routing · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/product.php, line 81File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT i18n.* FROM i18n WHERE (id = '5540983') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.134 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/product.php, line 91File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id = 514 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave Speed: 0.866 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: const · Rows: 1 · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Type: const · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Type: const · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (514) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.160 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 2 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT groupname, name, language, text FROM i18n WHERE language IN ('es_ES')Connection name: slave Speed: 9.938 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2981 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/classes/coupons.php, line 460File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.193 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.162 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs INNER JOIN catalog_products ON (catalog_products.id_catalog = catalogs.id) WHERE catalogs.id_domain IN (19, 21) AND catalog_products.id_product = 514 LIMIT 1Connection name: slave Speed: 1.600 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37,IDX_816D8444DD7ADDD · Key Used: IDX_816D8444DD7ADDD · Type: ref · Rows: 278 (Using where) · Query: SIMPLE on catalogs · Possible keys: PRIMARY,id_domain,event_name,catalog_domain,event_domain,domain_template · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 628File: APPPATH/classes/products.php, line 28File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 514 ORDER BY product_images.default DESC LIMIT 4Connection name: slave Speed: 0.501 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 47File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_campaigns WHERE type_name = 'shipping' AND id_domain = 2Connection name: slave Speed: 0.156 ms Query analysis: · Query: SIMPLE on domain_campaigns · Possible keys: id_domain · Key Used: id_domain · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/campaign.php, line 438File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.id, product_languages.product_permalink, product_languages.language, domains.domain, domains.id AS id_domain FROM product_languages INNER JOIN domains ON (domains.language = product_languages.language) WHERE product_languages.id_product = 514 AND domains.type = 'flowers'Connection name: slave Speed: 0.157 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: id_product · Type: ref · Rows: 10 · Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 295File: APPPATH/classes/trait/product.php, line 463File: APPPATH/classes/controller/product.php, line 110File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM components INNER JOIN component_languages ON (component_languages.id_component = components.id) INNER JOIN product_component ON (product_component.id_component = components.id) WHERE component_languages.language = 'es_ES' AND product_component.id_product = 514 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave Speed: 0.238 ms Query analysis: · Query: SIMPLE on product_component · Possible keys: unique,idx_product,idx_component,idx_collection · Key Used: unique · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on components · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on component_languages · Possible keys: IDX_7E28CF28C9CB1D70 · Key Used: IDX_7E28CF28C9CB1D70 · Type: ref · Rows: 3 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 152File: APPPATH/classes/controller/product.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property WHERE id_product = 514Connection name: slave Speed: 0.225 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD · Key Used: IDX_84161CE3DD7ADDD · Type: ref · Rows: 5 (Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 186File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id FROM products INNER JOIN product_filter_property ON (product_filter_property.id_product = products.id) WHERE product_filter_property.id_property IN (3, 6, 15, 16, 20) AND products.id <> 514 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave Speed: 3.994 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 445 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_typology,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 203File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.150 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id IN (27, 318, 2098, 35, 44, 46, 50, 1552) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 27, 318, 2098, 35, 44, 46, 50, 1552) ASC LIMIT 512Connection name: slave Speed: 1.642 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 8 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (27, 318, 2098, 35, 44, 46, 50, 1552) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.154 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 25 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.128 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.121 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.130 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.158 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.143 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.125 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.141 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.129 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.129 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.166 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.183 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.165 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.128 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.152 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.146 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.154 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.129 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.128 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.120 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.121 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.167 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ119', 'FQ2002', 'FQ8006', 'FQ7030') AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 7.543 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 661 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/product.php, line 212File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ119', 'FQ2002', 'FQ8006', 'FQ7030') AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 0.181 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 661 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 238File: APPPATH/classes/review.php, line 132File: APPPATH/classes/trait/product.php, line 212File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE id = 514 LIMIT 1Connection name: slave Speed: 0.255 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 256File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 514 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.338 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/calendar.php, line 135File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave Speed: 0.161 ms Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT supplier_delivery_countries.country FROM supplier_delivery_countries INNER JOIN suppliers_delivery_methods ON (suppliers_delivery_methods.id = supplier_delivery_countries.id_method) WHERE suppliers_delivery_methods.code LIKE 'standard%' GROUP BY supplier_delivery_countries.countryConnection name: slave Speed: 0.211 ms Query analysis: · Query: SIMPLE on suppliers_delivery_methods · Possible keys: PRIMARY,code_country · Key Used: code_country · Type: range · Rows: 61 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/countries.php, line 237File: APPPATH/classes/controller/product.php, line 139File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE id = 514 LIMIT 1Connection name: slave Speed: 0.200 ms · DUPLICATE Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 256File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 514 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.155 ms · DUPLICATE Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/calendar.php, line 135File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave Speed: 0.166 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM messages WHERE messages.id_domain = 2 AND category_slug <> 'funeral'Connection name: slave Speed: 0.177 ms Query analysis: · Query: SIMPLE on messages · Possible keys: idx_domain,index3 · Key Used: idx_domain · Type: ref · Rows: 24 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 354File: APPPATH/classes/controller/product.php, line 145File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/experiment/product13/controller.php, line 18File: APPPATH/classes/controller/product.php, line 147File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku = 'FQ6001' AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 2.826 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 211 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 103File: APPPATH/classes/controller/product.php, line 150File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg FROM reviews WHERE reviews.sku = 'FQ6001' AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1)Connection name: slave Speed: 0.140 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 211 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 207File: APPPATH/classes/review.php, line 104File: APPPATH/classes/controller/product.php, line 150File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.144 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/domainconfig.php, line 20File: APPPATH/classes/controller/product.php, line 199File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 514 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/controller/product.php, line 546File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave Speed: 0.138 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM country_deliveryhourhide WHERE country_deliveryhourhide.country IN ('ALL', 'ES') AND country_deliveryhourhide.strdate_date = '2022-05-25'Connection name: slave Speed: 0.128 ms Query analysis: · Query: SIMPLE on country_deliveryhourhide · Possible keys: country_date_type,index3 · Key Used: country_date_type · Type: range · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 85File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.189 ms Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.116 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.114 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.114 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.116 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.113 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.130 ms Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.115 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.116 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.112 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.216 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.116 ms Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.113 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.112 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM country_deliveryhourhide WHERE country_deliveryhourhide.country IN ('ALL', 'ES') AND country_deliveryhourhide.strdate_date = '2022-05-26'Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on country_deliveryhourhide · Possible keys: country_date_type,index3 · Key Used: country_date_type · Type: range · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 85File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.186 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.119 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.117 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.115 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.127 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.114 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.113 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.110 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.112 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.117 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.111 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.115 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.118 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.112 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.148 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '14' AND supplier_delivery_holidays.holiday_date > '2022-05-25'Connection name: slave Speed: 0.179 ms Query analysis: · Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 390File: APPPATH/classes/controller/product.php, line 558File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM supplier_delivery_countries WHERE id_method = '14' LIMIT 1Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 262File: APPPATH/classes/controller/product.php, line 561File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '14' AND supplier_delivery_holidays.holiday_date = '2022-05-26'Connection name: slave Speed: 0.122 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 390File: APPPATH/classes/supplier.php, line 264File: APPPATH/classes/controller/product.php, line 561File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM countries WHERE countries.code = 'ES' LIMIT 1Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on countries · Possible keys: code,code_es,code_en · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/countries.php, line 253File: APPPATH/classes/controller/product.php, line 225File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT supplier_delivery_countries.country FROM supplier_delivery_countries INNER JOIN suppliers_delivery_methods ON (suppliers_delivery_methods.id = supplier_delivery_countries.id_method) WHERE suppliers_delivery_methods.code LIKE 'standard%' GROUP BY supplier_delivery_countries.countryConnection name: slave Speed: 0.159 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers_delivery_methods · Possible keys: PRIMARY,code_country · Key Used: code_country · Type: range · Rows: 61 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/countries.php, line 237File: APPPATH/classes/countries.php, line 266File: APPPATH/classes/controller/product.php, line 225File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM supplier_delivery_countries INNER JOIN suppliers_delivery_methods ON (suppliers_delivery_methods.id = supplier_delivery_countries.id_method) WHERE supplier_delivery_countries.country = 'ES' AND suppliers_delivery_methods.code = 'standard'Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on supplier_delivery_countries · Possible keys: unique,id_method · Key Used: unique · Type: ref · Rows: 17 (Using index condition) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: PRIMARY,code_country · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/countries.php, line 277File: APPPATH/classes/controller/product.php, line 225File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/experiment/product13/controller.php, line 10File: APPPATH/classes/controller/product.php, line 71File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.120 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/experiment/wbcro137/controller.php, line 10File: APPPATH/classes/controller/product.php, line 72File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menu_type.name = 'root' ORDER BY menu_item.positionConnection name: slave Speed: 0.187 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '429'Connection name: slave Speed: 0.150 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '236' ORDER BY menu_item.positionConnection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '237' ORDER BY menu_item.positionConnection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 8 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '363'Connection name: slave Speed: 0.133 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '331'Connection name: slave Speed: 0.137 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '345'Connection name: slave Speed: 0.122 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '238' ORDER BY menu_item.positionConnection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '6'Connection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '450'Connection name: slave Speed: 0.227 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '445'Connection name: slave Speed: 0.140 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608310'Connection name: slave Speed: 0.143 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500002'Connection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '3' ORDER BY menu_item.positionConnection name: slave Speed: 0.158 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4420'Connection name: slave Speed: 0.148 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608303'Connection name: slave Speed: 0.152 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608090'Connection name: slave Speed: 0.243 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608171'Connection name: slave Speed: 0.143 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4759'Connection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '239' ORDER BY menu_item.positionConnection name: slave Speed: 0.149 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '240' ORDER BY menu_item.positionConnection name: slave Speed: 0.146 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '241' ORDER BY menu_item.positionConnection name: slave Speed: 0.144 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1344'Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1343'Connection name: slave Speed: 0.137 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1341'Connection name: slave Speed: 0.152 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1516'Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1792'Connection name: slave Speed: 0.149 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '3963'Connection name: slave Speed: 0.134 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214375 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.155 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214375Connection name: slave Speed: 0.175 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product FROM catalog_products WHERE id_catalog = 429 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.264 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 28 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.143 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id IN (1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) ASC LIMIT 512Connection name: slave Speed: 1.655 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.184 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 10 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.143 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.152 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.146 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.167 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |