{{ related.coupon_discount_formatted }}

{{ related.name }}
Cargando...
El azul es un color que transmite serenidad y equilibrio. Con una orquídea azul conseguirás darle a cualquier ambiente un toque refinado. También es perfecta para enviar un mensaje de apoyo y demostrarle a alquien querido que estás a su lado.
Maceta no incluida
Cada ramo es único y se envía puntual desde el taller de nuestros floristas. El equipo de atención al cliente garantiza la mejor experiencia.
Algunas flores se entregan un poco cerradas para garantizar su frescura, protegerlas durante el envío y poder admirar cómo florecen.
Puedes añadir gratis un mensaje personal junto con tu ramo de flores. Acorta distancias a través de las flores y las palabras.
142
Console |
1.230 s
Load Time |
523 Queries
Database |
15.49 MB
Memory Used |
246 Files
Included |
2322 Config
items loaded |
2 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
8Logs |
0 Errors |
0 Memory |
134 Speed |
speed | 0.820 msProfiler::init Start |
log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
speed | 26.029 msFuel\Core\Fuel::init End |
speed | 26.035 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
speed | 27.512 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
speed | 72.477 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
speed | 76.282 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
speed | 77.366 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
speed | 77.412 msFuel\Core\Uri::__construct Start |
speed | 77.427 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "enviar-flores/azul-orquidea" |
speed | 79.023 msFuel\Core\Request::execute: Start of enviar-flores/azul-orquidea |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 79.681 msController_Base::before init |
speed | 86.718 msController_Base::get_top_delivery_countries global delivery_countries init |
speed | 88.101 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 | 146.643 msCatalogs::get_collection collection array chunk init |
speed | 148.202 msCatalogs::get_collection collection array chunk end |
speed | 148.694 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 148.717 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 163.085 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 163.098 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 168.553 msCatalogs::get_collection collection array chunk init |
speed | 170.632 msCatalogs::get_collection collection array chunk end |
speed | 171.213 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 171.224 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 174.235 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 174.257 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 177.097 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 177.117 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 177.496 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ20000 from collection Array
(
[a] => ES
)
|
speed | 177.511 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 177.888 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ7203 from collection Array
(
[a] => ES
)
|
speed | 177.897 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 180.692 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 180.713 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 183.504 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 183.522 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 186.450 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 186.469 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 186.859 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ02200C from collection Array
(
[a] => ES
)
|
speed | 186.869 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 766.009 msController_Base::after menu init |
speed | 779.679 msController_Base::after FOTOMENU START |
speed | 780.806 msCatalogs::get_collection collection array chunk init |
speed | 783.259 msCatalogs::get_collection collection array chunk end |
speed | 783.940 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 783.952 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 786.974 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 786.999 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 789.843 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 789.864 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 792.759 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 792.779 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 795.744 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 795.767 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 798.666 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 799.101 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 800.292 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
speed | 800.309 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 800.323 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 803.246 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 803.667 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 804.859 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 805.656 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 806.496 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 807.307 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 808.123 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 809.006 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 809.020 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 809.039 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 811.965 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 811.985 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 814.818 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 814.838 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 821.915 msCatalogs::get_collection collection array chunk init |
speed | 824.901 msCatalogs::get_collection collection array chunk end |
speed | 825.549 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 825.557 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 828.580 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 828.600 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 831.712 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 831.732 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 832.591 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 832.602 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 835.584 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 836.005 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 837.265 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 838.147 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 838.974 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 839.810 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 840.636 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 841.459 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 841.474 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 841.493 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 844.381 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 844.400 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 845.221 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 845.233 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 848.100 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 848.118 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 848.958 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 848.968 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 851.954 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 851.975 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 901.968 msCatalogs::get_collection collection array chunk init |
speed | 904.691 msCatalogs::get_collection collection array chunk end |
speed | 905.255 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 905.271 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 906.594 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 906.611 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 907.824 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 907.846 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 908.660 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 908.680 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 909.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 909.481 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 910.260 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 910.271 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 911.093 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 911.104 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 912.285 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 912.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 913.522 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 913.548 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 914.343 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 914.355 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 915.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 915.554 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 924.661 msController_Base::after FOTOMENU END |
speed | 967.040 msController_Base::after menu end |
speed | 967.046 msController_Base::compress_html-START |
speed | 997.158 msController_Base::compress_html-END |
speed | 997.167 msController_Base::replace_html init |
speed | 997.276 msController_Base::replace_html end |
speed | 999.219 msFuel\Core\Request::execute: End of enviar-flores/azul-orquidea |
speed | 999.652 msEnd of Fuel Execution |
1.230 sLoad Time |
6 s Max Execution Time |
0.820 msProfiler::init Start |
26.029 msFuel\Core\Fuel::init End |
26.035 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
27.512 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
72.477 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
76.282 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
77.366 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
77.412 msFuel\Core\Uri::__construct Start |
77.427 msFuel\Core\Uri::__construct End |
79.023 msFuel\Core\Request::execute: Start of enviar-flores/azul-orquidea |
79.681 msController_Base::before init |
86.718 msController_Base::get_top_delivery_countries global delivery_countries init |
88.101 msController_Base::get_top_delivery_countries global delivery_countries end |
146.643 msCatalogs::get_collection collection array chunk init |
148.202 msCatalogs::get_collection collection array chunk end |
148.694 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
148.717 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
163.085 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
163.098 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
168.553 msCatalogs::get_collection collection array chunk init |
170.632 msCatalogs::get_collection collection array chunk end |
171.213 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
171.224 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
174.235 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
174.257 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
177.097 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
177.117 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
177.496 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
177.511 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
177.888 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
177.897 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
180.692 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
180.713 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
183.504 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
183.522 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
186.450 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
186.469 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
186.859 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
186.869 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
766.009 msController_Base::after menu init |
779.679 msController_Base::after FOTOMENU START |
780.806 msCatalogs::get_collection collection array chunk init |
783.259 msCatalogs::get_collection collection array chunk end |
783.940 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
783.952 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
786.974 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
786.999 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
789.843 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
789.864 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
792.759 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
792.779 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
795.744 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
795.767 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
798.666 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
799.101 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
800.292 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
800.309 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
800.323 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
803.246 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
803.667 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
804.859 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
805.656 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
806.496 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
807.307 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
808.123 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
809.006 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
809.020 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
809.039 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
811.965 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
811.985 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
814.818 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
814.838 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
821.915 msCatalogs::get_collection collection array chunk init |
824.901 msCatalogs::get_collection collection array chunk end |
825.549 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
825.557 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
828.580 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
828.600 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
831.712 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
831.732 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
832.591 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
832.602 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
835.584 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
836.005 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
837.265 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
838.147 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
838.974 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
839.810 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
840.636 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
841.459 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
841.474 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
841.493 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
844.381 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
844.400 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
845.221 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
845.233 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
848.100 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
848.118 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
848.958 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
848.968 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
851.954 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
851.975 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
901.968 msCatalogs::get_collection collection array chunk init |
904.691 msCatalogs::get_collection collection array chunk end |
905.255 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
905.271 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
906.594 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
906.611 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
907.824 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
907.846 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
908.660 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
908.680 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
909.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
909.481 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
910.260 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
910.271 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
911.093 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
911.104 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
912.285 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
912.299 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
913.522 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
913.548 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
914.343 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
914.355 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
915.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
915.554 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
924.661 msController_Base::after FOTOMENU END |
967.040 msController_Base::after menu end |
967.046 msController_Base::compress_html-START |
997.158 msController_Base::compress_html-END |
997.167 msController_Base::replace_html init |
997.276 msController_Base::replace_html end |
999.219 msFuel\Core\Request::execute: End of enviar-flores/azul-orquidea |
999.652 msEnd of Fuel Execution |
523Total Queries |
298.464 ms Total Time |
373 Duplicates |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.360 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.346 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: 8.955 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.403 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.339 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.340 ms · DUPLICATE Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/azul-orquidea' LIMIT 1Connection name: default Speed: 0.493 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 274File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/azul-orquidea' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.320 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: 31.557 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.395 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.385 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 383File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/enviar-flores/azul-orquidea' LIMIT 1Connection name: default Speed: 0.462 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-05-25' ORDER BY event_start_date ASCConnection name: slave Speed: 0.346 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.341 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.379 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.369 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75787 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'enviar-flores/azul-orquidea' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.544 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-05-25 21:30:00') AND (date_end IS null OR date_end >= '2022-05-25 21:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.364 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 = '1291' LIMIT 1Connection name: slave Speed: 0.508 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 = '1291') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.371 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: PRIMARY,routing · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/product.php, line 81File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT i18n.* FROM i18n WHERE (id = '5540983') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.380 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/product.php, line 91File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.378 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id = 187 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave Speed: 1.056 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: const · Rows: 1 · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Type: const · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Type: const · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (187) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.349 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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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: 8.472 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.380 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 = 187 LIMIT 1Connection name: slave Speed: 0.955 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: 58 (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 = 187 ORDER BY product_images.default DESC LIMIT 4Connection name: slave Speed: 0.374 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 47File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_campaigns WHERE type_name = 'shipping' AND id_domain = 2Connection name: slave Speed: 0.341 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 = 187 AND domains.type = 'flowers'Connection name: slave Speed: 0.345 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: id_product · Type: ref · Rows: 10 · Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 295File: APPPATH/classes/trait/product.php, line 463File: APPPATH/classes/controller/product.php, line 110File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM components INNER JOIN component_languages ON (component_languages.id_component = components.id) INNER JOIN product_component ON (product_component.id_component = components.id) WHERE component_languages.language = 'es_ES' AND product_component.id_product = 187 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave Speed: 0.749 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 = 187Connection name: slave Speed: 0.425 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 (6, 20, 27) AND products.id <> 187 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave Speed: 1.049 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 205 (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.340 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id IN (25, 43, 306, 636, 1967, 2315, 2669, 5042) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 25, 43, 306, 636, 1967, 2315, 2669, 5042) ASC LIMIT 512Connection name: slave Speed: 1.677 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 8 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (25, 43, 306, 636, 1967, 2315, 2669, 5042) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave Speed: 0.368 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: 33 (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.348 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.341 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.361 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.345 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.357 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.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.329 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.347 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.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.328 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.321 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.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.323 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.317 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.323 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.316 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.329 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.322 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.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.317 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.320 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.343 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.348 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.385 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.344 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 ('FQ2331', 'FQ2328', 'FQ2369', 'FQ4019') 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: 12.126 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1000 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/product.php, line 212File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ2331', 'FQ2328', 'FQ2369', 'FQ4019') AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 0.351 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1000 (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 = 187 LIMIT 1Connection name: slave Speed: 0.477 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 = 187 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.523 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.350 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.333 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.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.361 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.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/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.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.336 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.329 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.332 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.340 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.323 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.341 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.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.356 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.361 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.335 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.336 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.333 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.336 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.374 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 = 187 LIMIT 1Connection name: slave Speed: 0.339 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 = 187 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.336 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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort) · Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.312 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.312 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.322 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.318 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.337 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.308 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.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/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.309 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.316 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.320 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.328 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.340 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.340 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.458 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.349 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.335 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.334 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.333 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.714 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.352 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 = 'FQ11114' AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 1.439 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 60 (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 = 'FQ11114' AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1)Connection name: slave Speed: 0.339 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 60 (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.502 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 = 187 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave Speed: 0.329 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.340 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.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 = '2' LIMIT 1Connection name: slave Speed: 0.318 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.328 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.321 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.350 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.365 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.400 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.373 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.345 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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.316 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.310 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.320 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.318 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.310 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.319 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.329 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-25'Connection name: slave Speed: 0.332 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.389 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.347 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.337 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.333 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.339 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.379 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.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.341 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.355 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.348 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.395 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.335 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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.323 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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT 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.357 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.341 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.387 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.349 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.343 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.342 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.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.313 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.313 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.328 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.337 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.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.345 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.342 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.342 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.415 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.321 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 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.319 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.334 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.371 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.323 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.336 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.311 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave Speed: 0.319 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.313 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.350 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.319 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.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.309 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave Speed: 0.313 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 countries WHERE countries.code = 'ES' LIMIT 1Connection name: slave Speed: 0.325 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.340 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.351 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.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/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.337 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.374 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.352 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.390 ms Query analysis: · Query: SIMPLE< |