Despertarse con olor a café y tostadas es algo increíble, y si a eso le sumas un ramo de rosas rojas, unos bombones y una tarjeta dedicada ya es todo un lujo. Este set romántico es perfecto para acompañar su desayuno favorito y disfrutar juntos de una mañana tranquila.
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.
151
Console |
1.244 s
Load Time |
468 Queries
Database |
16.21 MB
Memory Used |
248 Files
Included |
2322 Config
items loaded |
2 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
9Logs |
0 Errors |
0 Memory |
142 Speed |
| speed | 0.837 msProfiler::init Start |
| log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
| speed | 22.387 msFuel\Core\Fuel::init End |
| speed | 22.393 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
| speed | 23.872 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
| speed | 36.708 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
| speed | 40.066 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
| speed | 41.041 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
| speed | 41.084 msFuel\Core\Uri::__construct Start |
| speed | 41.098 msFuel\Core\Uri::__construct End |
| log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "enviar-flores/rosas-rojas-jarron-tarjeta" |
| speed | 56.510 msFuel\Core\Request::execute: Start of enviar-flores/rosas-rojas-jarron-tarjeta |
| log | Fuel\Core\Request::execute - Called |
| log | Fuel\Core\Request::execute - Setting main Request |
| speed | 57.230 msController_Base::before init |
| speed | 61.426 msController_Base::get_top_delivery_countries global delivery_countries init |
| speed | 63.393 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 | 135.541 msCatalogs::get_collection collection array chunk init |
| speed | 136.908 msCatalogs::get_collection collection array chunk end |
| speed | 137.588 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 137.605 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 150.783 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 150.800 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 154.797 msCatalogs::get_collection collection array chunk init |
| speed | 156.470 msCatalogs::get_collection collection array chunk end |
| speed | 157.218 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 157.233 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 158.502 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 158.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 159.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 159.734 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 164.396 msCatalogs::get_collection collection array chunk init |
| speed | 166.419 msCatalogs::get_collection collection array chunk end |
| speed | 167.553 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 167.563 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 170.518 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 170.540 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 170.921 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ20001 from collection Array
(
[a] => ES
)
|
| speed | 170.943 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 171.332 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ4024 from collection Array
(
[a] => ES
)
|
| speed | 171.341 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 174.280 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 174.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 174.681 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ20002 from collection Array
(
[a] => ES
)
|
| speed | 174.691 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 177.550 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 177.569 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 177.948 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ20003 from collection Array
(
[a] => ES
)
|
| speed | 177.959 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 180.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 180.752 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 814.677 msController_Base::after menu init |
| speed | 828.290 msController_Base::after FOTOMENU START |
| speed | 829.095 msCatalogs::get_collection collection array chunk init |
| speed | 831.492 msCatalogs::get_collection collection array chunk end |
| speed | 832.180 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 832.191 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 835.157 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 835.181 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 838.107 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 838.132 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 840.966 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 840.985 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 843.868 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 843.888 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 846.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 847.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 848.709 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
| speed | 848.726 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 848.748 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 851.798 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 852.347 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 853.646 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 854.460 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 855.279 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 856.110 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 857.084 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 857.885 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 857.900 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 857.928 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 860.864 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 860.884 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 863.773 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 863.794 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 869.580 msCatalogs::get_collection collection array chunk init |
| speed | 871.869 msCatalogs::get_collection collection array chunk end |
| speed | 872.517 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 872.525 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 875.471 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 875.491 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 878.323 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 878.343 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 879.118 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 879.129 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 881.997 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 882.614 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 883.995 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 884.848 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 885.662 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 886.512 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 887.341 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 888.145 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 888.160 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 888.186 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 891.048 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 891.068 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 891.858 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 891.869 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 894.673 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 894.692 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 895.481 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 895.493 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 898.350 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 898.373 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 944.699 msCatalogs::get_collection collection array chunk init |
| speed | 946.974 msCatalogs::get_collection collection array chunk end |
| speed | 947.522 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 947.538 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 948.782 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 948.802 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 949.995 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 950.018 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 950.816 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 950.837 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 951.706 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 951.717 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 952.525 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 952.536 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 953.329 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 953.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 954.554 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 954.569 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 955.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 955.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 956.593 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 956.605 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 957.818 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 957.832 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 966.023 msController_Base::after FOTOMENU END |
| speed | 1.008 sController_Base::after menu end |
| speed | 1.008 sController_Base::compress_html-START |
| speed | 1.041 sController_Base::compress_html-END |
| speed | 1.041 sController_Base::replace_html init |
| speed | 1.041 sController_Base::replace_html end |
| speed | 1.043 sFuel\Core\Request::execute: End of enviar-flores/rosas-rojas-jarron-tarjeta |
| speed | 1.044 sEnd of Fuel Execution |
1.244 sLoad Time |
6 s Max Execution Time |
0.837 msProfiler::init Start |
22.387 msFuel\Core\Fuel::init End |
22.393 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
23.872 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
36.708 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
40.066 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
41.041 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
41.084 msFuel\Core\Uri::__construct Start |
41.098 msFuel\Core\Uri::__construct End |
56.510 msFuel\Core\Request::execute: Start of enviar-flores/rosas-rojas-jarron-tarjeta |
57.230 msController_Base::before init |
61.426 msController_Base::get_top_delivery_countries global delivery_countries init |
63.393 msController_Base::get_top_delivery_countries global delivery_countries end |
135.541 msCatalogs::get_collection collection array chunk init |
136.908 msCatalogs::get_collection collection array chunk end |
137.588 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
137.605 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
150.783 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
150.800 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
154.797 msCatalogs::get_collection collection array chunk init |
156.470 msCatalogs::get_collection collection array chunk end |
157.218 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
157.233 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
158.502 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
158.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
159.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
159.734 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
164.396 msCatalogs::get_collection collection array chunk init |
166.419 msCatalogs::get_collection collection array chunk end |
167.553 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
167.563 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
170.518 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
170.540 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
170.921 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
170.943 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
171.332 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
171.341 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
174.280 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
174.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
174.681 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
174.691 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
177.550 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
177.569 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
177.948 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
177.959 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
180.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
180.752 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
814.677 msController_Base::after menu init |
828.290 msController_Base::after FOTOMENU START |
829.095 msCatalogs::get_collection collection array chunk init |
831.492 msCatalogs::get_collection collection array chunk end |
832.180 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
832.191 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
835.157 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
835.181 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
838.107 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
838.132 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
840.966 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
840.985 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
843.868 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
843.888 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
846.724 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
847.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
848.709 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
848.726 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
848.748 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
851.798 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
852.347 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
853.646 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
854.460 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
855.279 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
856.110 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
857.084 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
857.885 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
857.900 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
857.928 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
860.864 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
860.884 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
863.773 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
863.794 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
869.580 msCatalogs::get_collection collection array chunk init |
871.869 msCatalogs::get_collection collection array chunk end |
872.517 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
872.525 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
875.471 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
875.491 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
878.323 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
878.343 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
879.118 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
879.129 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
881.997 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
882.614 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
883.995 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
884.848 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
885.662 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
886.512 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
887.341 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
888.145 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
888.160 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
888.186 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
891.048 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
891.068 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
891.858 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
891.869 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
894.673 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
894.692 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
895.481 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
895.493 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
898.350 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
898.373 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
944.699 msCatalogs::get_collection collection array chunk init |
946.974 msCatalogs::get_collection collection array chunk end |
947.522 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
947.538 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
948.782 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
948.802 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
949.995 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
950.018 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
950.816 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
950.837 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
951.706 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
951.717 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
952.525 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
952.536 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
953.329 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
953.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
954.554 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
954.569 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
955.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
955.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
956.593 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
956.605 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
957.818 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
957.832 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
966.023 msController_Base::after FOTOMENU END |
1.008 sController_Base::after menu end |
1.008 sController_Base::compress_html-START |
1.041 sController_Base::compress_html-END |
1.041 sController_Base::replace_html init |
1.041 sController_Base::replace_html end |
1.043 sFuel\Core\Request::execute: End of enviar-flores/rosas-rojas-jarron-tarjeta |
1.044 sEnd of Fuel Execution |
468Total Queries |
251.135 ms Total Time |
309 Duplicates |
| SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.355 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.351 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.284 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.409 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.325 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.326 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/rosas-rojas-jarron-tarjeta' LIMIT 1Connection name: default Speed: 0.495 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/rosas-rojas-jarron-tarjeta' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.335 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: 0.391 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.763 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.351 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/rosas-rojas-jarron-tarjeta' LIMIT 1Connection name: default Speed: 0.489 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.356 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.336 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.377 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.358 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/rosas-rojas-jarron-tarjeta' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.654 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.363 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 = '3470793' LIMIT 1Connection name: slave Speed: 0.445 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 = '3470793') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.348 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 * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.322 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 = 2157 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave Speed: 0.898 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 (2157) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.531 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.340 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: 7.216 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.363 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.331 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 = 2157 LIMIT 1Connection name: slave Speed: 0.995 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: 83 (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 = 2157 ORDER BY product_images.default DESC LIMIT 4Connection name: slave Speed: 0.584 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.336 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 * FROM product_behaviors WHERE id_product = 2157 AND type_name = 'special_combo_components' LIMIT 1Connection name: slave Speed: 0.331 ms Query analysis: · Query: SIMPLE on product_behaviors · Possible keys: unique,id_product · Key Used: unique · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 509File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM products WHERE sku = 'CD30065' LIMIT 1Connection name: slave Speed: 0.437 ms Query analysis: · Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM products WHERE sku = 'CH30002' LIMIT 1Connection name: slave Speed: 0.434 ms Query analysis: · Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 107File: 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.331 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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: 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 (3192, 956) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 3192, 956) ASC LIMIT 512Connection name: slave Speed: 1.315 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 2 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: eq_ref · Rows: 1 (Using index condition) · 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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: 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 (3192, 956) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.620 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: 4 (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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: 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.339 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 530File: APPPATH/classes/controller/product.php, line 107File: 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.339 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 530File: APPPATH/classes/controller/product.php, line 107File: 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.331 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 530File: APPPATH/classes/controller/product.php, line 107File: 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.324 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 530File: APPPATH/classes/controller/product.php, line 107File: 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.329 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 530File: APPPATH/classes/controller/product.php, line 107File: 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.325 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 530File: APPPATH/classes/controller/product.php, line 107File: 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 = 3192 ORDER BY product_images.default DESC LIMIT 1Connection name: slave Speed: 0.352 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: 1 (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 532File: APPPATH/classes/controller/product.php, line 107File: 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 = 956 ORDER BY product_images.default DESC LIMIT 1Connection name: slave Speed: 0.335 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: 1 (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 532File: APPPATH/classes/controller/product.php, line 107File: 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 = 2157 AND domains.type = 'flowers'Connection name: slave Speed: 0.550 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 = 2157 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave Speed: 0.729 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 = 2157Connection name: slave Speed: 0.327 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD · Key Used: IDX_84161CE3DD7ADDD · Type: ref · Rows: 3 (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 (2, 4, 7) AND products.id <> 2157 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave Speed: 1.281 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 308 (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.329 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 (25, 307, 2348, 29, 308, 30, 309, 31) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 25, 307, 2348, 29, 308, 30, 309, 31) ASC LIMIT 512Connection name: slave Speed: 1.603 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 (25, 307, 2348, 29, 308, 30, 309, 31) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.927 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: 28 (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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.344 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.344 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.335 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.329 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.331 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.325 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.334 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.323 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.331 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.324 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.317 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.435 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.338 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.320 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.327 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.323 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.326 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.329 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.324 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.332 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.334 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.326 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.318 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.350 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.323 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.317 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.317 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.318 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.329 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.319 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.319 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.316 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 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 ('FQ2331', 'FQ117', 'FQ108', 'FQ2301') 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: 17.640 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1626 (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 ('FQ2331', 'FQ117', 'FQ108', 'FQ2301') 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: 6.012 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1626 (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 = 2157 LIMIT 1Connection name: slave Speed: 0.476 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 = 2157 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.528 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.359 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.394 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 = 2157 LIMIT 1Connection name: slave Speed: 0.347 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 = 2157 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.328 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.331 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.391 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.331 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 = 'FQ2110C' 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: 1.786 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 90 (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 = 'FQ2110C' AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1)Connection name: slave Speed: 0.781 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 90 (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.367 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 = 2157 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.350 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.333 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.352 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.384 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.350 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.321 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.374 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.314 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.320 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.310 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.316 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.311 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.332 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.318 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.309 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.326 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.394 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.315 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.328 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.321 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.327 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.359 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.343 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.386 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.324 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.331 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.308 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.308 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.305 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.308 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.317 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.307 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.311 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.338 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.316 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.317 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.307 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.318 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.317 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.315 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.307 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.561 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.324 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.321 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.333 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.346 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.381 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.461 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.360 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.403 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.360 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.345 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.349 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.353 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.349 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.332 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.337 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.326 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.430 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.341 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.329 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.339 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.336 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.327 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.350 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.324 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.340 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.336 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.325 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.330 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.344 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.341 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, men |
