Un regalo de esos que acaban convirtiéndose en uno de los tesoros de la familia. Este álbum de fotos no es uno cualquiera, sino que puede personalizarse gracias a la masilla de su cubierta, donde podrán conservar las primeras huellas del bebé. Envíale este increíble detalle en color rosa.
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.
144
Console |
1.241 s
Load Time |
511 Queries
Database |
14.65 MB
Memory Used |
246 Files
Included |
2322 Config
items loaded |
2 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
9Logs |
0 Errors |
0 Memory |
135 Speed |
| speed | 0.833 msProfiler::init Start |
| log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
| speed | 31.309 msFuel\Core\Fuel::init End |
| speed | 31.320 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
| speed | 32.577 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
| speed | 81.746 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
| speed | 85.625 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
| speed | 86.766 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
| speed | 86.815 msFuel\Core\Uri::__construct Start |
| speed | 86.831 msFuel\Core\Uri::__construct End |
| log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "regalos-para-bebes/mis-primeras-huellas-para-nina" |
| speed | 99.993 msFuel\Core\Request::execute: Start of regalos-para-bebes/mis-primeras-huellas-para-nina |
| log | Fuel\Core\Request::execute - Called |
| log | Fuel\Core\Request::execute - Setting main Request |
| speed | 100.579 msController_Base::before init |
| speed | 104.197 msController_Base::get_top_delivery_countries global delivery_countries init |
| speed | 105.572 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 | 161.860 msCatalogs::get_collection collection array chunk init |
| speed | 163.305 msCatalogs::get_collection collection array chunk end |
| speed | 163.876 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 164.346 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 178.313 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 178.330 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 183.201 msCatalogs::get_collection collection array chunk init |
| speed | 185.263 msCatalogs::get_collection collection array chunk end |
| speed | 186.338 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 186.357 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 186.671 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ4026 from collection Array
(
[a] => ES
)
|
| speed | 186.691 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 188.959 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 189.443 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 190.582 msCoupons::apply_discount_prices_item Product 3051 Apply coupon EKW56XXL7 MKTD |
| speed | 190.601 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 190.615 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 192.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 192.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 193.536 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 193.556 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 193.870 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ7028 from collection Array
(
[a] => ES
)
|
| speed | 193.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 194.185 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ2000 from collection Array
(
[a] => ES
)
|
| speed | 194.200 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 194.513 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ7211 from collection Array
(
[a] => ES
)
|
| speed | 194.524 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 846.859 msController_Base::after menu init |
| speed | 857.090 msController_Base::after FOTOMENU START |
| speed | 857.853 msCatalogs::get_collection collection array chunk init |
| speed | 860.286 msCatalogs::get_collection collection array chunk end |
| speed | 860.872 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 860.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 863.170 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 863.197 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 865.497 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 865.519 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 867.827 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 867.852 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 870.068 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 870.089 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 872.515 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 872.994 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 873.985 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
| speed | 874.002 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 874.016 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 876.213 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 876.643 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 877.654 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 878.285 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 878.881 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 879.463 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 880.126 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 880.700 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 880.715 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 880.738 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 882.959 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 882.980 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 885.407 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 885.436 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 892.285 msCatalogs::get_collection collection array chunk init |
| speed | 894.716 msCatalogs::get_collection collection array chunk end |
| speed | 895.383 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 895.394 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 897.792 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 897.815 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 900.179 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 900.200 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 900.798 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 900.810 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 902.966 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 903.395 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 904.390 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 904.988 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 905.594 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 906.197 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 906.781 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 907.394 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 907.413 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 907.435 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 909.569 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 909.588 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 910.197 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 910.213 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 912.478 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 912.501 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 913.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 913.163 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 915.294 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 915.319 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 974.174 msCatalogs::get_collection collection array chunk init |
| speed | 976.347 msCatalogs::get_collection collection array chunk end |
| speed | 976.800 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 976.818 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 977.850 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 977.871 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 978.847 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 978.873 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 979.518 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 979.543 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 980.133 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 980.146 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 980.742 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 980.754 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 981.351 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 981.365 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 982.261 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 982.278 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 983.221 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 983.245 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 983.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 983.844 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 984.754 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 984.773 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 993.476 msController_Base::after FOTOMENU END |
| speed | 1.027 sController_Base::after menu end |
| speed | 1.027 sController_Base::compress_html-START |
| speed | 1.055 sController_Base::compress_html-END |
| speed | 1.055 sController_Base::replace_html init |
| speed | 1.055 sController_Base::replace_html end |
| speed | 1.057 sFuel\Core\Request::execute: End of regalos-para-bebes/mis-primeras-huellas-para-nina |
| speed | 1.057 sEnd of Fuel Execution |
1.241 sLoad Time |
6 s Max Execution Time |
0.833 msProfiler::init Start |
31.309 msFuel\Core\Fuel::init End |
31.320 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
32.577 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
81.746 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
85.625 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
86.766 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
86.815 msFuel\Core\Uri::__construct Start |
86.831 msFuel\Core\Uri::__construct End |
99.993 msFuel\Core\Request::execute: Start of regalos-para-bebes/mis-primeras-huellas-para-nina |
100.579 msController_Base::before init |
104.197 msController_Base::get_top_delivery_countries global delivery_countries init |
105.572 msController_Base::get_top_delivery_countries global delivery_countries end |
161.860 msCatalogs::get_collection collection array chunk init |
163.305 msCatalogs::get_collection collection array chunk end |
163.876 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
164.346 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
178.313 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
178.330 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
183.201 msCatalogs::get_collection collection array chunk init |
185.263 msCatalogs::get_collection collection array chunk end |
186.338 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
186.357 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
186.671 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
186.691 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
188.959 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
189.443 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
190.582 msCoupons::apply_discount_prices_item Product 3051 Apply coupon EKW56XXL7 MKTD |
190.601 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
190.615 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
192.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
192.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
193.536 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
193.556 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
193.870 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
193.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
194.185 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
194.200 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
194.513 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
194.524 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
846.859 msController_Base::after menu init |
857.090 msController_Base::after FOTOMENU START |
857.853 msCatalogs::get_collection collection array chunk init |
860.286 msCatalogs::get_collection collection array chunk end |
860.872 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
860.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
863.170 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
863.197 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
865.497 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
865.519 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
867.827 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
867.852 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
870.068 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
870.089 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
872.515 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
872.994 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
873.985 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
874.002 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
874.016 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
876.213 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
876.643 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
877.654 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
878.285 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
878.881 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
879.463 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
880.126 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
880.700 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
880.715 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
880.738 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
882.959 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
882.980 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
885.407 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
885.436 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
892.285 msCatalogs::get_collection collection array chunk init |
894.716 msCatalogs::get_collection collection array chunk end |
895.383 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
895.394 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
897.792 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
897.815 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
900.179 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
900.200 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
900.798 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
900.810 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
902.966 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
903.395 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
904.390 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
904.988 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
905.594 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
906.197 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
906.781 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
907.394 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
907.413 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
907.435 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
909.569 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
909.588 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
910.197 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
910.213 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
912.478 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
912.501 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
913.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
913.163 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
915.294 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
915.319 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
974.174 msCatalogs::get_collection collection array chunk init |
976.347 msCatalogs::get_collection collection array chunk end |
976.800 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
976.818 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
977.850 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
977.871 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
978.847 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
978.873 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
979.518 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
979.543 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
980.133 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
980.146 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
980.742 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
980.754 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
981.351 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
981.365 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
982.261 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
982.278 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
983.221 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
983.245 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
983.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
983.844 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
984.754 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
984.773 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
993.476 msController_Base::after FOTOMENU END |
1.027 sController_Base::after menu end |
1.027 sController_Base::compress_html-START |
1.055 sController_Base::compress_html-END |
1.055 sController_Base::replace_html init |
1.055 sController_Base::replace_html end |
1.057 sFuel\Core\Request::execute: End of regalos-para-bebes/mis-primeras-huellas-para-nina |
1.057 sEnd of Fuel Execution |
511Total Queries |
253.470 ms Total Time |
357 Duplicates |
| SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 1.018 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.261 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: 11.836 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.301 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.274 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.233 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` = 'regalos-para-bebes/mis-primeras-huellas-para-nina' LIMIT 1Connection name: default Speed: 0.438 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` = 'regalos-para-bebes/mis-primeras-huellas-para-nina' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.482 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: 35.008 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: 3.054 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.294 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` = '/regalos-para-bebes/mis-primeras-huellas-para-nina' LIMIT 1Connection name: default Speed: 0.344 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-26' ORDER BY event_start_date ASCConnection name: slave Speed: 0.233 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.223 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.269 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.245 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 = 'regalos-para-bebes/mis-primeras-huellas-para-nina' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.281 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-26 09:30:00') AND (date_end IS null OR date_end >= '2022-05-26 09:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.435 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 = '1768705' LIMIT 1Connection name: slave Speed: 0.469 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 = '1768705') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.457 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.319 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-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id = 1657 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave Speed: 0.905 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: 2 (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 (1657) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.412 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: 1 (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.271 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.900 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.267 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 = 1657 LIMIT 1Connection name: slave Speed: 0.756 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: 37 (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 = 1657 ORDER BY product_images.default DESC LIMIT 4Connection name: slave Speed: 0.444 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: 2 (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.227 ms Query analysis: · Query: SIMPLE on domain_campaigns · Possible keys: id_domain · Key Used: id_domain · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/campaign.php, line 438File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT product_languages.id, product_languages.product_permalink, product_languages.language, domains.domain, domains.id AS id_domain FROM product_languages INNER JOIN domains ON (domains.language = product_languages.language) WHERE product_languages.id_product = 1657 AND domains.type = 'flowers'Connection name: slave Speed: 0.227 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: 6 · 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 = 1657 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave Speed: 0.808 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 = 1657Connection name: slave Speed: 0.305 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 (8, 9, 30) AND products.id <> 1657 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave Speed: 0.894 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 152 (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.217 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-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (2350, 2669, 3051, 36, 4634, 37, 38, 39) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 2350, 2669, 3051, 36, 4634, 37, 38, 39) ASC LIMIT 512Connection name: slave Speed: 1.623 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 (2350, 2669, 3051, 36, 4634, 37, 38, 39) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.884 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: 18 (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.234 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.222 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.231 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.216 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.252 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.240 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.228 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.237 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM coupons WHERE code = 'EKW56XXL7' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.387 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.256 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.259 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM coupons WHERE code = 'EKW56XXL7'Connection name: slave Speed: 0.373 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.238 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.220 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.241 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.215 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.214 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.216 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.205 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.346 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.236 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.254 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.240 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.255 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ4051', 'FQ1029VIP', 'FQ3013', 'FQ2328C2') 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: 6.356 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 529 (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 ('FQ4051', 'FQ1029VIP', 'FQ3013', 'FQ2328C2') 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: 3.399 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 529 (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 = 1657 LIMIT 1Connection name: slave Speed: 0.383 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 = 1657 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.431 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: 1 (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.235 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.216 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.220 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.205 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.207 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.202 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.210 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 68File: 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 * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.201 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.205 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.200 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.200 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.201 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.208 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.203 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.202 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 68File: 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 * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.204 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 68File: 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 * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.209 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 68File: 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 * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.206 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 68File: 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 * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.210 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 68File: 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.540 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 = 1657 LIMIT 1Connection name: slave Speed: 0.251 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 = 1657 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.218 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: 1 (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.217 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.210 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 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.216 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.203 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 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.210 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 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.202 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 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.193 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 68File: 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.191 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.201 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.198 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.195 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.193 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.200 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.201 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.193 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 68File: 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 suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.203 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 68File: 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 suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.197 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 68File: 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 suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.198 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 68File: 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 suppliers WHERE id = '1' LIMIT 1Connection name: slave Speed: 0.199 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 68File: 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.286 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.460 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 = 'BBDPA58rosa' 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: 0.632 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 1 (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 = 'BBDPA58rosa' AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1)Connection name: slave Speed: 0.240 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 1 (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.240 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 = 1657 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.212 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: 1 (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.224 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.210 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 68File: 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.202 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 68File: 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.203 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 68File: 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.201 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 68File: 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.195 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 68File: 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.205 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 68File: 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.204 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 68File: 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.202 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 68File: 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.197 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 68File: 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.204 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 68File: 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.197 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 68File: 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.194 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 68File: 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.197 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 68File: 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.200 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 68File: 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.191 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 68File: 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.193 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 68File: 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.198 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 68File: 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.195 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 68File: 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.228 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.263 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.205 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.206 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.192 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.192 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.204 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.209 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.222 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.222 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.418 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: 1.118 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.220 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.210 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.212 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.224 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.246 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 suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.219 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 68File: 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.194 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 68File: 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.193 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 68File: 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.222 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 68File: 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.211 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 68File: 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.199 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 68File: 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.208 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 68File: 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.208 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 68File: 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.194 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 68File: 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.196 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 68File: 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.195 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 68File: 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.201 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 68File: 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.190 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 68File: 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.200 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 68File: 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.325 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 68File: 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.222 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 68File: 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.205 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 68File: 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.190 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 68File: 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-27'Connection name: slave Speed: 0.203 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.258 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.206 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.208 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.194 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.209 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.205 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.237 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.214 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.233 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.218 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.239 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.220 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.220 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.303 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.220 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 = '44' AND supplier_delivery_holidays.holiday_date > '2022-05-26'Connection name: slave Speed: 0.229 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 = '44' LIMIT 1Connection name: slave Speed: 0.222 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 = '44' AND supplier_delivery_holidays.holiday_date = '2022-05-27'Connection name: slave Speed: 0.219 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.237 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.332 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.266 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.228 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.236 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.272 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.225 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.235 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.225 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.251 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.227 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.215 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.223 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.227 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT 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.240 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.220 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.212 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.205 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.222 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.220 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.241 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.212 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.232 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.229 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.206 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.233 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.245 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.231 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '241' ORDER BY menu_item.positionConnection name: slave Speed: 0.225 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '1344'Connection name: slave Speed: 0.214 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '1343'Connection name: slave Speed: 0.212 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '1341'Connection name: slave Speed: 0.231 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '1516'Connection name: slave Speed: 0.254 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '1792'Connection name: slave Speed: 0.240 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM catalogs WHERE id = '3963'Connection name: slave Speed: 0.223 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214375 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.313 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM domain_page_content WHERE id_page = 214375Connection name: slave Speed: 0.454 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT id_product FROM catalog_products WHERE id_catalog = 429 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.401 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 28 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.214 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/product.php, line 78File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
| SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) ASC LIMIT 512Connection name: slave Speed: 1.931 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product &mid |
