Amor Incondicional: Pack Completo Rosas Rojas

Name: Amor Incondicional: Pack Completo Rosas Rojas
Brand: Floraqueen
SKU: FQ2110C
Availability: InStock
Rating: 4.5 (64 reviews)

64 opiniones

Por qué este ramo es especial

Celebra un día importante regalándole a tu pareja este fabuloso ramo de 10 rosas rojas en un jarrón, acompañado de una caja de deliciosos bombones y una tarjeta dedicada para recordarle cuánto aprecias su amor y lo importante que es en tu vida.

El color y diseño del jarrón puede variar según disponibilidad.

11-03-2021

Me encantó, muchas gracias

Rica

17-02-2021

Entrega perfecta y puntual! El Ramo le ha encantado a mi pareja. Volveré a comprar sin duda en Flora Queen...

Natalia

16-02-2021

Muy bonito me encantó el detalle

Alejandra

13-02-2021

Flores preciosas y frescas. El transportista majisimo y súper educado. Recomendable 100%...

Alina

07-02-2021

Muy bonito y llego en tiempo

Monica

07-12-2020

El producto era bien. Las flores muy bien. Pero nos entregó muy tarde, casi por la. Noche y nos tenían que traer antes de mediodía ...

Rashmi

08-11-2020

Simplemente perfecto!

Sandrine

05-11-2020

Todo bien salvo por la nota. Debería poner "Dayana&Antonio" Pero el & no lo muestra bien por lo que la nota no ha quedado según lo pre...

Dayana

28-10-2020

La consegna è stata arrivata al momento giusto, le rose sono stupende ...

Ashley

02-10-2020

Bien

Azahara

11-08-2020

Las flores muy bonitas y frescas, llegaron a tiempo. Todo perfecto...

Elena CedrÃ©s Cruz

31-07-2020

Sin palabras. Flores frescas al 100% Recomendable a todo aquel que quiera regalar un ramo de flores...

Jose Javier Navarro Serrano

12-06-2020

Me ha encantado! Todo muy bien empaquetado y presentado.

Yolanda

07-06-2020

Todo perfecto, le daría 5 pero todavía se puede mejorar el florero se salió un poco de su ubicación pero todo perfecto. Gracias...

Amador Losilla Molina

04-06-2020

Todo muy correcto

MARTIN CASTANO

07-05-2020

Rapidez, eches perfecta y súper bonitas!!

Tatiana Martinez Higueras

06-03-2020

Todo llego a la hora ... muy buen servicio

Andrey Saim

29-02-2020

Todo muy bien, las flores correctas, el jarrón decente, los bombones de calidad, la entrega a tiempo y encima te van informando en tiempo re...

FCH

19-02-2020

Fantástico servicio! La presentación increible y el servicio de seguimiento del pedido inmejorable. Dandome updates desde dias antes de la e...

Maria

19-02-2020

Todo correcto

Silvestre Huertas Alcazar

17-02-2020

Puntuales,muy bien empaquetado perfecto

Alfredo FernÃ¡ndez

17-02-2020

Un gran servicio

Manuel Jesus Valderas

17-02-2020

La verdad es que envian todo muy bien y bien protegido para que no se dañe nada...Todo genial...

Sergio Rubio Lamas

16-02-2020

Sólo mejorar la nota, ya que impresa tal cual es muy feo....

Jaserre

16-02-2020

Muy bien todo muy contento

Alberto GÃ³mez Parraga

El set incluye:

Mensaje de amor
Corazón Lindor
Scarlet
Promesa Roja: 10 Rosas rojas

Datos del pedido

Ramos que también te gustarán

Novedad {{ related.reviews_text }}

Razones para confiar en nosotros

Entregas en la puerta
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.
Ramos que se disfrutan más tiempo
Algunas flores se entregan un poco cerradas para garantizar su frescura, protegerlas durante el envío y poder admirar cómo florecen.
Hazlo personal con una dedicatoria
Puedes añadir gratis un mensaje personal junto con tu ramo de flores. Acorta distancias a través de las flores y las palabras.

88

Console

1.072 s

Load Time

919 Queries

Database

15.31 MB

Memory Used

302 Files

Included

1716 Config

items loaded

1 Session

vars loaded

0 GET

vars loaded

0 POST

vars loaded

`7` Logs	`0` Errors
`0` Memory	`81` Speed

speed	0.523 ms Profiler::init Start
log	Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system.
speed	16.749 ms Fuel\Core\Fuel::init End
speed	16.756 ms /var/www/floraqueen-gifts/fuel/app/bootstrap.php Start
speed	17.698 ms /var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing
speed	56.127 ms /var/www/floraqueen-gifts/fuel/app/bootstrap.php products
speed	58.802 ms /var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs
speed	59.513 ms /var/www/floraqueen-gifts/fuel/app/bootstrap.php End
speed	59.553 ms Fuel\Core\Uri::__construct Start
speed	59.567 ms Fuel\Core\Uri::__construct End
log	Fuel\Core\Request::__construct - Creating a new main Request with URI = "enviar-flores/rosas-rojas-jarron-tarjeta"
speed	61.798 ms Fuel\Core\Request::execute: Start of enviar-flores/rosas-rojas-jarron-tarjeta
log	Fuel\Core\Request::execute - Called
log	Fuel\Core\Request::execute - Setting main Request
speed	62.227 ms Controller_Base::before init
speed	65.067 ms Controller_Base::before global delivery_countries init
speed	66.325 ms Controller_Base::before global delivery_countries end
speed	69.082 ms Catalogs::get_collection collection array chunk init
speed	70.227 ms Catalogs::get_collection collection array chunk end
speed	70.503 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	81.334 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	83.843 ms Catalogs::get_collection collection array chunk init
speed	85.344 ms Catalogs::get_collection collection array chunk end
speed	85.644 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	86.470 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	89.642 ms Catalogs::get_collection collection array chunk init
speed	91.430 ms Catalogs::get_collection collection array chunk end
speed	91.798 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
log	Catalogs::get_collection Remove FQ20000 from collection Array ( [a] => ES )
log	Catalogs::get_collection Remove FQ2361 from collection Array ( [a] => ES )
speed	94.206 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	94.589 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	94.951 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	95.320 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	95.682 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	96.048 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	96.079 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	463.364 ms Controller_Base::after product12_init
speed	463.393 ms Controller_Base::after product12_end
speed	463.500 ms Controller_Base::after menu init
speed	474.900 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT
speed	475.386 ms Catalogs::get_collection collection array chunk init
speed	476.333 ms Catalogs::get_collection collection array chunk end
speed	476.787 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	478.668 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	478.674 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END
speed	481.889 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT
speed	482.387 ms Catalogs::get_collection collection array chunk init
speed	484.756 ms Catalogs::get_collection collection array chunk end
speed	485.497 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	486.860 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	487.319 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	487.772 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	488.231 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	488.793 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	489.246 ms Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD
speed	490.596 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	491.060 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	491.524 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	491.981 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	492.435 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	492.903 ms Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD
speed	494.671 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	495.270 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	495.740 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	496.184 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	496.639 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	497.082 ms Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD
speed	498.262 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	498.270 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END
speed	563.908 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT
speed	564.461 ms Catalogs::get_collection collection array chunk init
speed	566.479 ms Catalogs::get_collection collection array chunk end
speed	566.843 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	570.464 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	570.470 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END
speed	580.397 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT
speed	580.937 ms Catalogs::get_collection collection array chunk init
speed	583.119 ms Catalogs::get_collection collection array chunk end
speed	583.569 ms Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS
speed	586.348 ms Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS
speed	586.359 ms Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END
speed	612.712 ms Controller_Base::after menu end
speed	637.568 ms Controller_Base::replace_html init
log	Replace {page\|url\|legal-privacy} to legal-privacy
speed	638.593 ms Controller_Base::replace_html end
speed	879.611 ms Fuel\Core\Request::execute: End of enviar-flores/rosas-rojas-jarron-tarjeta
speed	879.834 ms End of Fuel Execution

1.072 s

Load Time

6 s

Max Execution Time

0.523 ms

Profiler::init Start

16.749 ms

Fuel\Core\Fuel::init End

16.756 ms

/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start

17.698 ms

/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing

56.127 ms

/var/www/floraqueen-gifts/fuel/app/bootstrap.php products

58.802 ms

/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs

59.513 ms

/var/www/floraqueen-gifts/fuel/app/bootstrap.php End

59.553 ms

Fuel\Core\Uri::__construct Start

59.567 ms

Fuel\Core\Uri::__construct End

61.798 ms

Fuel\Core\Request::execute: Start of enviar-flores/rosas-rojas-jarron-tarjeta

62.227 ms

Controller_Base::before init

65.067 ms

Controller_Base::before global delivery_countries init

66.325 ms

Controller_Base::before global delivery_countries end

69.082 ms

Catalogs::get_collection collection array chunk init

70.227 ms

Catalogs::get_collection collection array chunk end

70.503 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

81.334 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

83.843 ms

Catalogs::get_collection collection array chunk init

85.344 ms

Catalogs::get_collection collection array chunk end

85.644 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

86.470 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

89.642 ms

Catalogs::get_collection collection array chunk init

91.430 ms

Catalogs::get_collection collection array chunk end

91.798 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

94.206 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

94.589 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

94.951 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

95.320 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

95.682 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

96.048 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

96.079 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

463.364 ms

Controller_Base::after product12_init

463.393 ms

Controller_Base::after product12_end

463.500 ms

Controller_Base::after menu init

474.900 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT

475.386 ms

Catalogs::get_collection collection array chunk init

476.333 ms

Catalogs::get_collection collection array chunk end

476.787 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

478.668 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

478.674 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END

481.889 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT

482.387 ms

Catalogs::get_collection collection array chunk init

484.756 ms

Catalogs::get_collection collection array chunk end

485.497 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

486.860 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

487.319 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

487.772 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

488.231 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

488.793 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

489.246 ms

Coupons::apply_discount_prices Product 43 Apply coupon ODBTUR0MR MKTD

490.596 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

491.060 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

491.524 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

491.981 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

492.435 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

492.903 ms

Coupons::apply_discount_prices Product 2669 Apply coupon OI92T3T0U MKTD

494.671 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

495.270 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

495.740 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

496.184 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

496.639 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

497.082 ms

Coupons::apply_discount_prices Product 2347 Apply coupon HQ1B5SE85 MKTD

498.262 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

498.270 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END

563.908 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT

564.461 ms

Catalogs::get_collection collection array chunk init

566.479 ms

Catalogs::get_collection collection array chunk end

566.843 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

570.464 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

570.470 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END

580.397 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU INIT

580.937 ms

Catalogs::get_collection collection array chunk init

583.119 ms

Catalogs::get_collection collection array chunk end

583.569 ms

Catalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS

586.348 ms

Catalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS

586.359 ms

Experiment_Product12_Controller::product12_photoMenu GEt Collection PHOTOMENU END

612.712 ms

Controller_Base::after menu end

637.568 ms

Controller_Base::replace_html init

638.593 ms

Controller_Base::replace_html end

879.611 ms

Fuel\Core\Request::execute: End of enviar-flores/rosas-rojas-jarron-tarjeta

879.834 ms

End of Fuel Execution

919

Total Queries

233.417 ms

Total Time

724

Duplicates

SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.159 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 50File: DOCROOT/index.php, line 238

SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.125 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 25 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 21File: 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 50File: DOCROOT/index.php, line 238

SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default
Speed: 6.411 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2691 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 124File: APPPATH/base.php, line 14File: APPPATH/config/staging/my.php, line 44File: 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 50File: DOCROOT/index.php, line 238

SELECT * FROM `domains`Connection name: default
Speed: 0.308 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 25
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 76File: DOCROOT/index.php, line 238

SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.141 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 101File: DOCROOT/index.php, line 238

SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 25 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 116File: DOCROOT/index.php, line 238

SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/rosas-rojas-jarron-tarjeta' LIMIT 1Connection name: default
Speed: 0.267 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 277File: DOCROOT/index.php, line 238

SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/rosas-rojas-jarron-tarjeta' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default
Speed: 0.269 ms
Query analysis:
· Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · Key Used: domain_version_pemalink · Type: ref_or_null · Rows: 2 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 313File: 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: 28.637 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: 28332 (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 328File: DOCROOT/index.php, line 238

SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('es_ES')Connection name: default
Speed: 2.069 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 6550 (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 328File: DOCROOT/index.php, line 238

SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default
Speed: 0.174 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 386File: DOCROOT/index.php, line 238

SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/enviar-flores/rosas-rojas-jarron-tarjeta' LIMIT 1Connection name: default
Speed: 0.239 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 1153File: APPPATH/classes/controller/base.php, line 43File: APPPATH/classes/controller/product.php, line 44File: 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 >= '2021-04-19' ORDER BY event_start_date ASCConnection name: slave
Speed: 0.149 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 121File: APPPATH/classes/controller/product.php, line 44File: 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.152 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 176File: APPPATH/classes/controller/product.php, line 44File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT countries.code, countries.name_es, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) WHERE countries.delivery = 1 AND catalogs.id_domain = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' ORDER BY countries.name_es ASCConnection name: slave
Speed: 0.161 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: code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 229File: APPPATH/classes/controller/product.php, line 44File: 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.125 ms
Query analysis:
· Query: SIMPLE on reviews · Type: ALL · Rows: 73257
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 287File: APPPATH/classes/controller/base.php, line 249File: APPPATH/classes/controller/product.php, line 44File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'enviar-flores/rosas-rojas-jarron-tarjeta' AND (version IS null OR version = '') LIMIT 1Connection name: slave
Speed: 0.438 ms
Query analysis:
· Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · Key Used: domain_version_pemalink · Type: ref_or_null · Rows: 2 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 301File: APPPATH/classes/controller/product.php, line 44File: 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 <= '2021-04-19 20:00:00') AND (date_end IS null OR date_end >= '2021-04-19 20:00:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave
Speed: 0.173 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 59File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE sku = '3470793' LIMIT 1Connection name: slave
Speed: 0.215 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 57File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT product_languages.* FROM product_languages WHERE (id = '3470793') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.149 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 80File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT i18n.* FROM i18n WHERE (id = '5537669') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.127 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 90File: APPPATH/classes/controller/product.php, line 85File: 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.112 ms
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: 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_badges.name_es AS badge_name, products_badges.url_image_es 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 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 < '2021-04-19') AND (products.date_off IS null OR products.date_off > '2021-04-19') AND products.id = 2157 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave
Speed: 0.737 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 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: 1 (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 294File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (2157) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.136 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 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.134 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: 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: 6.225 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2706 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 124File: APPPATH/base.php, line 14File: APPPATH/classes/coupons.php, line 335File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM catalogs INNER JOIN catalog_products ON (catalog_products.id_catalog = catalogs.id) WHERE catalogs.id_domain IN (19, 21) AND catalog_products.id_product = 2157 LIMIT 1Connection name: slave
Speed: 0.684 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: 53 (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 96File: APPPATH/classes/controller/product.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 2157 ORDER BY product_images.default DESC LIMIT 4Connection name: slave
Speed: 0.147 ms
Query analysis:
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where; Using filesort)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 47File: APPPATH/classes/trait/product.php, line 96File: APPPATH/classes/controller/product.php, line 85File: 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.118 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 449File: APPPATH/classes/controller/product.php, line 99File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM product_behaviors WHERE id_product = 2157 AND type_name = 'special_combo_components' LIMIT 1Connection name: slave
Speed: 0.188 ms
Query analysis:
· Query: SIMPLE on product_behaviors · Possible keys: unique,id_product · Key Used: unique · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 509File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE sku = 'CD30011' LIMIT 1Connection name: slave
Speed: 0.213 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE sku = 'CH6238' LIMIT 1Connection name: slave
Speed: 0.195 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE sku = 'CM100302' LIMIT 1Connection name: slave
Speed: 0.235 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 103File: 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.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 103File: 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_badges.name_es AS badge_name, products_badges.url_image_es 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 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 < '2021-04-19') AND (products.date_off IS null OR products.date_off > '2021-04-19') AND products.id IN (1369, 96, 1575) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 1369, 96, 1575) ASC LIMIT 512Connection name: slave
Speed: 1.131 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 3 (Using where; Using temporary; Using filesort)
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: ref · Rows: 1 (Using index condition)
· Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on 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 294File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 103File: 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 (1369, 96, 1575) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.158 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: 6 (Using index condition; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.228 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.139 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 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/products.php, line 530File: 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_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 = 1369 ORDER BY product_images.default DESC LIMIT 1Connection name: slave
Speed: 0.337 ms
Query analysis:
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where; Using filesort)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 532File: APPPATH/classes/controller/product.php, line 103File: 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 = 96 ORDER BY product_images.default DESC LIMIT 1Connection name: slave
Speed: 0.157 ms
Query analysis:
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where; Using filesort)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 532File: APPPATH/classes/controller/product.php, line 103File: 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 = 1575 ORDER BY product_images.default DESC LIMIT 1Connection name: slave
Speed: 0.146 ms
Query analysis:
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where; Using filesort)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/products.php, line 532File: APPPATH/classes/controller/product.php, line 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 = 2157 AND domains.type = 'flowers'Connection name: slave
Speed: 0.141 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: 7 (Using where)
· 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 409File: APPPATH/classes/controller/product.php, line 106File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM components INNER JOIN component_languages ON (component_languages.id_component = components.id) INNER JOIN product_component ON (product_component.id_component = components.id) WHERE component_languages.language = 'es_ES' AND product_component.id_product = 2157 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave
Speed: 0.361 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 150File: APPPATH/classes/controller/product.php, line 117File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM product_filter_property WHERE id_product = 2157Connection name: slave
Speed: 0.202 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD · Key Used: IDX_84161CE3DD7ADDD · Type: ref · Rows: 2 (Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 184File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT products.id FROM products INNER JOIN product_filter_property ON (product_filter_property.id_product = products.id) WHERE product_filter_property.id_property IN (2, 4) AND products.id <> 2157 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave
Speed: 0.856 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 236 (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 201File: APPPATH/classes/controller/product.php, line 120File: 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.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: 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_badges.name_es AS badge_name, products_badges.url_image_es 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 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 < '2021-04-19') AND (products.date_off IS null OR products.date_off > '2021-04-19') AND products.id IN (25, 306, 1264, 2835, 29, 307, 1385, 2347) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 25, 306, 1264, 2835, 29, 307, 1385, 2347) ASC LIMIT 512Connection name: slave
Speed: 1.387 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 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 294File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: 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, 306, 1264, 2835, 29, 307, 1385, 2347) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.152 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 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: 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.278 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 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.129 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: 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.139 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 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave
Speed: 0.138 ms
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.141 ms
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.138 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.129 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.130 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM coupons WHERE code = 'HQ1B5SE85'Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 138File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/product.php, line 206File: APPPATH/classes/controller/product.php, line 120File: 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', 'FQ2349', 'FQ117', 'FQ20001') AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave
Speed: 6.977 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 645 (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 58File: APPPATH/classes/review.php, line 122File: APPPATH/classes/trait/product.php, line 210File: APPPATH/classes/controller/product.php, line 120File: 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', 'FQ2349', 'FQ117', 'FQ20001') 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.141 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 645 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 225File: APPPATH/classes/review.php, line 123File: APPPATH/classes/trait/product.php, line 210File: APPPATH/classes/controller/product.php, line 120File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE id = 2157 LIMIT 1Connection name: slave
Speed: 0.263 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 254File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM product_prices WHERE product_prices.id_product = 2157 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave
Speed: 0.304 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 32File: APPPATH/classes/calendar.php, line 63File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.149 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 60File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.150 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 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.111 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.113 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.129 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 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.181 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.115 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM country_availability WHERE country_availability.strdate_date >= '2021-04-19' AND country_availability.country = 'ES' AND country_availability.action <> 'O'Connection name: slave
Speed: 0.166 ms
Query analysis:
· Query: SIMPLE on country_availability · Possible keys: country_date,action_strdate_country · Key Used: country_date · Type: range · Rows: 29 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 330File: APPPATH/classes/calendar.php, line 69File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM country_availability WHERE country_availability.strdate_date >= '2021-04-19' AND country_availability.country = 'ES' AND country_availability.action = 'O'Connection name: slave
Speed: 0.130 ms
Query analysis:
· Query: SIMPLE on country_availability · Possible keys: country_date,action_strdate_country · Key Used: action_strdate_country · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 343File: APPPATH/classes/calendar.php, line 70File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '44' AND supplier_delivery_holidays.holiday_date > '2021-04-19'Connection name: slave
Speed: 0.134 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 317File: APPPATH/classes/calendar.php, line 74File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.120 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.115 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.117 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.114 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.116 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.278 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.130 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.175 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.118 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.112 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.215 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.219 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.145 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.134 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.148 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.161 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.129 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.135 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.146 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '47' AND supplier_delivery_holidays.holiday_date > '2021-04-19'Connection name: slave
Speed: 0.123 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 317File: APPPATH/classes/calendar.php, line 74File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.130 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.129 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.139 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.151 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.137 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.118 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '47' LIMIT 1Connection name: slave
Speed: 0.138 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '401' AND supplier_delivery_holidays.holiday_date > '2021-04-19'Connection name: slave
Speed: 0.218 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 317File: APPPATH/classes/calendar.php, line 74File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.158 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.139 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.269 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.151 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.140 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.138 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.143 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.153 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '401' LIMIT 1Connection name: slave
Speed: 0.135 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '891008' AND supplier_delivery_holidays.holiday_date > '2021-04-19'Connection name: slave
Speed: 0.126 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 317File: APPPATH/classes/calendar.php, line 74File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.124 ms
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.110 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.117 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.115 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.116 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.113 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.112 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '891008' LIMIT 1Connection name: slave
Speed: 0.111 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 129File: 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.128 ms
Query analysis:
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: PRIMARY,code_country · Key Used: code_country · Type: range · Rows: 18 (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 133File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM products WHERE id = 2157 LIMIT 1Connection name: slave
Speed: 0.151 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 254File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM product_prices WHERE product_prices.id_product = 2157 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave
Speed: 0.132 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 32File: APPPATH/classes/calendar.php, line 63File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.152 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 60File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.185 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.111 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.117 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.115 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: 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.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 66File: APPPATH/classes/calendar.php, line 66File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM country_availability WHERE country_availability.strdate_date >= '2021-04-19' AND country_availability.country = 'ES' AND country_availability.action <> 'O'Connection name: slave
Speed: 0.150 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on country_availability · Possible keys: country_date,action_strdate_country · Key Used: country_date · Type: range · Rows: 29 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 330File: APPPATH/classes/calendar.php, line 69File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM country_availability WHERE country_availability.strdate_date >= '2021-04-19' AND country_availability.country = 'ES' AND country_availability.action = 'O'Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on country_availability · Possible keys: country_date,action_strdate_country · Key Used: action_strdate_country · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 343File: APPPATH/classes/calendar.php, line 70File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_holidays WHERE supplier_delivery_holidays.id_method = '44' AND supplier_delivery_holidays.holiday_date > '2021-04-19'Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_holidays · Possible keys: index2 · Key Used: index2 · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 317File: APPPATH/classes/calendar.php, line 74File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.116 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.116 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.117 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.119 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.287 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.123 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.211 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.126 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.118 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.184 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.124 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.125 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.115 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.117 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.137 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.120 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.121 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.116 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.113 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.127 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.122 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241

SELECT * FROM supplier_delivery_countries WHERE id_method = '44' LIMIT 1Connection name: slave
Speed: 0.129 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 40File: APPPATH/classes/supplier.php, line 206File: APPPATH/classes/calendar.php, line 87File: APPPATH/classes/trait/product.php, line 265File: APPPATH/classes/controller/product.php, line 134File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241