192
Console |
351.031 ms
Load Time |
435 Queries
Database |
11.24 MB
Memory Used |
247 Files
Included |
2321 Config
items loaded |
5 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
19Logs |
0 Errors |
0 Memory |
173 Speed |
| speed | 0.535 msProfiler::init Start |
| log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
| speed | 18.801 msFuel\Core\Fuel::init End |
| speed | 18.809 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
| speed | 20.005 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
| speed | 20.849 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
| speed | 20.888 msFuel\Core\Uri::__construct Start |
| speed | 20.901 msFuel\Core\Uri::__construct End |
| log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "ramos-multicolores" |
| speed | 21.198 msFuel\Core\Request::execute: Start of ramos-multicolores |
| log | Fuel\Core\Request::execute - Called |
| log | Fuel\Core\Request::execute - Setting main Request |
| speed | 21.602 msController_Base::before init |
| speed | 38.382 msController_Base::get_top_delivery_countries global delivery_countries init |
| speed | 39.540 msController_Base::get_top_delivery_countries global delivery_countries end |
| speed | 51.666 msCatalogs::get_collection collection array chunk init |
| speed | 54.107 msCatalogs::get_collection collection array chunk end |
| speed | 54.749 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 54.767 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 54.984 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ2722 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 55.002 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 55.190 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ8011 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 55.201 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 56.264 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 56.287 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 56.469 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ8004 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 56.482 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 56.717 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ129 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 56.728 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 57.368 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 57.384 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 57.568 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ2000 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 57.582 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 57.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ3002 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 57.781 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 58.767 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 58.788 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 59.014 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ7027 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 59.026 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 59.199 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ7246 from collection Array
(
[a] => ES
[b] => small
)
|
| speed | 59.213 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 70.799 msView::replace_html init |
| log | Replace {catalog|url|all-our-flowers} to all-our-flowers |
| speed | 71.497 msView::replace_html end |
| speed | 71.873 msController_Base::after menu init |
| speed | 79.344 msController_Base::after FOTOMENU START |
| speed | 79.767 msCatalogs::get_collection collection array chunk init |
| speed | 82.964 msCatalogs::get_collection collection array chunk end |
| speed | 83.367 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 83.379 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 84.501 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 84.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 85.533 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 85.551 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 86.563 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 86.814 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 87.732 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
| speed | 88.574 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
| speed | 88.590 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 88.608 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 89.671 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 89.903 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 90.719 msCoupons::apply_discount_prices_item Product 5323 Apply coupon L2MJFX7QC MKTD |
| speed | 91.376 msCoupons::apply_discount_prices_item Product 5323 Apply coupon L2MJFX7QC MKTD |
| speed | 91.392 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 91.409 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 92.039 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 92.053 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 93.051 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 93.267 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 94.051 msCoupons::apply_discount_prices_item Product 5327 Apply coupon JADPR4OJY MKTD |
| speed | 94.684 msCoupons::apply_discount_prices_item Product 5327 Apply coupon JADPR4OJY MKTD |
| speed | 94.700 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 94.716 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 95.807 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 95.828 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 102.227 msCatalogs::get_collection collection array chunk init |
| speed | 104.469 msCatalogs::get_collection collection array chunk end |
| speed | 104.861 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 104.872 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 105.555 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 105.570 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 106.844 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 106.862 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 108.026 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 108.042 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 109.062 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 109.292 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 110.107 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 110.820 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 110.836 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 111.071 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 111.959 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
| speed | 112.583 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
| speed | 112.599 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 112.617 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 113.263 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 113.276 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 113.872 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 113.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 114.899 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 114.914 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 115.931 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 115.951 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 160.719 msCatalogs::get_collection collection array chunk init |
| speed | 163.244 msCatalogs::get_collection collection array chunk end |
| speed | 163.626 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 163.638 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 164.875 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 164.897 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 165.509 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 165.524 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 166.135 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 166.148 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 166.770 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 166.782 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 167.381 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 167.394 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 168.002 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 168.015 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 168.617 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 168.630 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 169.668 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 169.685 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 170.284 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 170.297 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 170.929 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 170.944 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 174.373 msCatalogs::get_collection collection array chunk init |
| speed | 177.115 msCatalogs::get_collection collection array chunk end |
| speed | 177.519 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 177.530 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 178.567 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 178.585 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 179.577 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 179.804 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 180.618 msCoupons::apply_discount_prices_item Product 4898 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 180.636 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 180.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 181.743 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 181.768 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 182.431 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 182.445 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 183.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 183.562 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 184.209 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 184.223 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 184.825 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 184.843 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 185.452 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 185.464 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 186.132 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 186.149 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 194.494 msController_Base::after FOTOMENU END |
| speed | 212.565 msController_Base::after menu end |
| speed | 212.570 msController_Base::compress_html-START |
| speed | 218.657 ms["1019",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618e230657c6f866562207.jpg"},0] |
| speed | 219.148 ms["1020",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/624415cb1f758638654786.jpg"},0] |
| speed | 219.401 ms["2470",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182795273ca8839202741.png"},0] |
| speed | 219.697 ms["1225",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618271f03acdd773325518.png"},0] |
| speed | 220.361 ms["1226",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618275da21f76650752756.png"},0] |
| speed | 220.810 ms["1023",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618275da21f76650752756.png"},0] |
| speed | 221.115 ms["1025",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182771e83111176038787.png"},0] |
| speed | 221.426 ms["1228",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182728a26b62833456750.jpg"},0] |
| speed | 221.749 ms["2515",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6214bd976bcee162261626.jpg"},0] |
| speed | 221.981 ms["1103",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/623888b661bbf310541634.png"},0] |
| speed | 222.507 ms["13",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618e230657c6f866562207.jpg"},0] |
| speed | 223.747 ms["2385",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/620d1b9fc4bfa196909388.jpg"},0] |
| speed | 224.118 ms["1178",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618a6ea566ac4136500069.jpg"},0] |
| speed | 224.474 ms["2503",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618bc12adfbcf719534695.jpg"},0] |
| speed | 224.770 ms["2244",{"image":"https:\/\/static.yoursurprise.com\/galleryimage\/d9\/d9659af4383085f295e7d27aaca09c60.jpg?width=480&height=480"},0] |
| speed | 225.107 ms["1053",{"image":"https:\/\/static.yoursurprise.com\/galleryimage\/96\/967e72e7f8b7168333f97fcffc5ddef7.jpg?width=480&height=480"},0] |
| speed | 225.571 ms["1180",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/620d1b9fc4bfa196909388.jpg"},0] |
| speed | 242.875 msController_Base::compress_html-END |
| speed | 242.892 msView::replace_html init |
| log | Replace {catalog|url|all-our-flowers} to all-our-flowers |
| log | Replace {catalog|url|occasion-birthday} to occasion-birthday |
| log | Replace {catalog|url|occasion-love} to occasion-love |
| log | Replace {catalog|url|occasion-birth} to occasion-birth |
| log | Replace {catalog|url|occasion-funeral} to occasion-funeral |
| log | Replace {catalog|name|all-our-flowers} to all-our-flowers |
| speed | 246.778 msView::replace_html end |
| speed | 248.266 msFuel\Core\Request::execute: End of ramos-multicolores |
| speed | 248.430 msEnd of Fuel Execution |
351.031 msLoad Time |
6 s Max Execution Time |
0.535 msProfiler::init Start |
18.801 msFuel\Core\Fuel::init End |
18.809 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
20.005 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
20.849 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
20.888 msFuel\Core\Uri::__construct Start |
20.901 msFuel\Core\Uri::__construct End |
21.198 msFuel\Core\Request::execute: Start of ramos-multicolores |
21.602 msController_Base::before init |
38.382 msController_Base::get_top_delivery_countries global delivery_countries init |
39.540 msController_Base::get_top_delivery_countries global delivery_countries end |
51.666 msCatalogs::get_collection collection array chunk init |
54.107 msCatalogs::get_collection collection array chunk end |
54.749 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
54.767 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
54.984 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
55.002 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
55.190 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
55.201 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
56.264 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
56.287 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
56.469 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
56.482 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
56.717 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
56.728 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
57.368 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
57.384 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
57.568 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
57.582 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
57.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
57.781 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
58.767 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
58.788 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
59.014 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
59.026 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
59.199 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
59.213 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
70.799 msView::replace_html init |
71.497 msView::replace_html end |
71.873 msController_Base::after menu init |
79.344 msController_Base::after FOTOMENU START |
79.767 msCatalogs::get_collection collection array chunk init |
82.964 msCatalogs::get_collection collection array chunk end |
83.367 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
83.379 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
84.501 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
84.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
85.533 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
85.551 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
86.563 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
86.814 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
87.732 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
88.574 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
88.590 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
88.608 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
89.671 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
89.903 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
90.719 msCoupons::apply_discount_prices_item Product 5323 Apply coupon L2MJFX7QC MKTD |
91.376 msCoupons::apply_discount_prices_item Product 5323 Apply coupon L2MJFX7QC MKTD |
91.392 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
91.409 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
92.039 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
92.053 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
93.051 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
93.267 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
94.051 msCoupons::apply_discount_prices_item Product 5327 Apply coupon JADPR4OJY MKTD |
94.684 msCoupons::apply_discount_prices_item Product 5327 Apply coupon JADPR4OJY MKTD |
94.700 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
94.716 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
95.807 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
95.828 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
102.227 msCatalogs::get_collection collection array chunk init |
104.469 msCatalogs::get_collection collection array chunk end |
104.861 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
104.872 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
105.555 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
105.570 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
106.844 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
106.862 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
108.026 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
108.042 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
109.062 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
109.292 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
110.107 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
110.820 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
110.836 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
111.071 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
111.959 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
112.583 msCoupons::apply_discount_prices_item Product 5325 Apply coupon ER83T28I7 MKTD |
112.599 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
112.617 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
113.263 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
113.276 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
113.872 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
113.885 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
114.899 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
114.914 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
115.931 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
115.951 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
160.719 msCatalogs::get_collection collection array chunk init |
163.244 msCatalogs::get_collection collection array chunk end |
163.626 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
163.638 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
164.875 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
164.897 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
165.509 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
165.524 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
166.135 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
166.148 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
166.770 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
166.782 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
167.381 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
167.394 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
168.002 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
168.015 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
168.617 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
168.630 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
169.668 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
169.685 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
170.284 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
170.297 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
170.929 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
170.944 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
174.373 msCatalogs::get_collection collection array chunk init |
177.115 msCatalogs::get_collection collection array chunk end |
177.519 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
177.530 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
178.567 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
178.585 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
179.577 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
179.804 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
180.618 msCoupons::apply_discount_prices_item Product 4898 Apply coupon 2022WEBDISCOUNT04 MKTD |
180.636 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
180.650 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
181.743 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
181.768 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
182.431 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
182.445 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
183.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
183.562 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
184.209 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
184.223 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
184.825 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
184.843 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
185.452 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
185.464 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
186.132 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
186.149 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
194.494 msController_Base::after FOTOMENU END |
212.565 msController_Base::after menu end |
212.570 msController_Base::compress_html-START |
218.657 ms["1019",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618e230657c6f866562207.jpg"},0] |
219.148 ms["1020",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/624415cb1f758638654786.jpg"},0] |
219.401 ms["2470",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182795273ca8839202741.png"},0] |
219.697 ms["1225",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618271f03acdd773325518.png"},0] |
220.361 ms["1226",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618275da21f76650752756.png"},0] |
220.810 ms["1023",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618275da21f76650752756.png"},0] |
221.115 ms["1025",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182771e83111176038787.png"},0] |
221.426 ms["1228",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6182728a26b62833456750.jpg"},0] |
221.749 ms["2515",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/6214bd976bcee162261626.jpg"},0] |
221.981 ms["1103",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/623888b661bbf310541634.png"},0] |
222.507 ms["13",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618e230657c6f866562207.jpg"},0] |
223.747 ms["2385",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/620d1b9fc4bfa196909388.jpg"},0] |
224.118 ms["1178",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618a6ea566ac4136500069.jpg"},0] |
224.474 ms["2503",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/618bc12adfbcf719534695.jpg"},0] |
224.770 ms["2244",{"image":"https:\/\/static.yoursurprise.com\/galleryimage\/d9\/d9659af4383085f295e7d27aaca09c60.jpg?width=480&height=480"},0] |
225.107 ms["1053",{"image":"https:\/\/static.yoursurprise.com\/galleryimage\/96\/967e72e7f8b7168333f97fcffc5ddef7.jpg?width=480&height=480"},0] |
225.571 ms["1180",{"image":"https:\/\/d1mxm3s28igxxe.cloudfront.net\/480x480\/620d1b9fc4bfa196909388.jpg"},0] |
242.875 msController_Base::compress_html-END |
242.892 msView::replace_html init |
246.778 msView::replace_html end |
248.266 msFuel\Core\Request::execute: End of ramos-multicolores |
248.430 msEnd of Fuel Execution |
435Total Queries |
141.011 ms Total Time |
257 Duplicates |
| SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.183 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 54File: DOCROOT/index.php, line 232 |
| SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.154 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 22File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 54File: DOCROOT/index.php, line 232 |
| SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default Speed: 8.094 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2963 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 47File: APPPATH/config/staging/my.php, line 48File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 54File: DOCROOT/index.php, line 232 |
| SELECT * FROM `domains`Connection name: default Speed: 0.448 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 77File: DOCROOT/index.php, line 232 |
| SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.149 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 102File: DOCROOT/index.php, line 232 |
| SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.148 ms · DUPLICATE Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 232 |
| SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'ramos-multicolores' LIMIT 1Connection name: default Speed: 0.402 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 273File: DOCROOT/index.php, line 232 |
| SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default Speed: 0.149 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 382File: DOCROOT/index.php, line 232 |
| SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/ramos-multicolores' LIMIT 1Connection name: default Speed: 0.253 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 988File: APPPATH/classes/controller/base.php, line 52File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT groupname, name, language, text FROM i18n WHERE language IN ('es_ES')Connection name: slave Speed: 7.993 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2987 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 47File: APPPATH/classes/controller/base.php, line 94File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 2 AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.242 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) · Query: SIMPLE on catalog_properties · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/controller/catalog.php, line 163File: APPPATH/classes/controller/base.php, line 98File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_pages WHERE id_domain = 2 AND code = 'company-help' AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.170 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_version_code · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 54File: APPPATH/classes/controller/base.php, line 103File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_page_content WHERE id_page = 214297Connection name: slave Speed: 0.565 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 71File: APPPATH/classes/controller/base.php, line 103File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-08-11' ORDER BY event_start_date ASCConnection name: slave Speed: 0.169 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 155File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.137 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 223File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.186 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23950 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 950File: APPPATH/classes/controller/base.php, line 253File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 0.168 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75789 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 301File: APPPATH/classes/controller/base.php, line 256File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'ramos-multicolores' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 308File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 2 AND code = 'default') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.169 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) · Query: SIMPLE on catalog_properties · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/controller/catalog.php, line 163File: APPPATH/classes/controller/catalog.php, line 57File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-08-11 17:30:00') AND (date_end IS null OR date_end >= '2022-08-11 17:30:00') AND ip_countries IS null ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.166 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/catalog.php, line 58File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id = 28) LIMIT 1 OFFSET 0Connection name: slave Speed: 0.461 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on catalog_properties · 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/controller/catalog.php, line 163File: APPPATH/classes/controller/catalog.php, line 87File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.157 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/trait/catalog.php, line 37File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT filter_catalog.* FROM filter_catalog WHERE id_catalog = 28Connection name: slave Speed: 0.230 ms Query analysis: · Query: SIMPLE on filter_catalog · Possible keys: IDX_ACBC4522C5B19B37 · Key Used: IDX_ACBC4522C5B19B37 · Type: ref · Rows: 1 (Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 167File: APPPATH/classes/filters.php, line 25File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT filters.id, filters.slug, filters.type, filter_i18n.name, filter_i18n.description FROM filters INNER JOIN filter_i18n ON (filter_i18n.id_filter = filters.id) WHERE filter_i18n.language = 'es_ES' AND filters.slug IN ('flower-type', 'colour') ORDER BY filters.slug DESCConnection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on filters · Possible keys: PRIMARY,UNIQ_7877678D989D9B62 · Key Used: UNIQ_7877678D989D9B62 · Type: range · Rows: 2 (Using index condition) · Query: SIMPLE on filter_i18n · Possible keys: fk_filters,language · Key Used: fk_filters · Type: ref · Rows: 3 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 62File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT filter_properties.id, filter_properties.slug, filter_property_i18n.name FROM filter_properties INNER JOIN filter_property_i18n ON (filter_property_i18n.id_property = filter_properties.id) WHERE filter_properties.id_filter = '2' AND filter_property_i18n.language = 'es_ES'Connection name: slave Speed: 0.168 ms Query analysis: · Query: SIMPLE on filter_properties · Possible keys: PRIMARY,id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 13 · Query: SIMPLE on filter_property_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 79File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT filter_properties.id, filter_properties.slug, filter_property_i18n.name FROM filter_properties INNER JOIN filter_property_i18n ON (filter_property_i18n.id_property = filter_properties.id) WHERE filter_properties.id_filter = '1' AND filter_property_i18n.language = 'es_ES'Connection name: slave Speed: 0.158 ms Query analysis: · Query: SIMPLE on filter_properties · Possible keys: PRIMARY,id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 8 · Query: SIMPLE on filter_property_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 79File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '4' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.246 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 141 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '5' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.216 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 53 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '10' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.695 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 20 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '12' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.205 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 50 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '19' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.175 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 23 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '22' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.307 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 38 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '23' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.172 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 35 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '24' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.162 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 11 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '25' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.142 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 9 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '33' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.145 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 2 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '34' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.156 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '35' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 7 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '36' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 15 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '1' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.180 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 55 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '2' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.189 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 116 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '3' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.225 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 102 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '9' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.232 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 91 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '11' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.212 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 37 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '13' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.187 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 35 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '27' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.197 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 4 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '32' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.161 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 5 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM catalog_statics WHERE id_catalog = 28 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 0.322 ms Query analysis: · Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: id_catalog · Type: ref · Rows: 1 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 533File: APPPATH/classes/trait/catalog.php, line 110File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM catalog_statics WHERE id_catalog = 28 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: id_catalog · Type: ref · Rows: 1 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 533File: APPPATH/classes/trait/catalog.php, line 113File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product FROM catalog_products WHERE id_catalog = 28 ORDER BY position ASCConnection name: slave Speed: 0.290 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 11 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 82File: APPPATH/classes/trait/catalog.php, line 393File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.144 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 287File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') AND products.id IN (370, 695, 35, 49, 248, 54, 38, 48, 33, 615, 661) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 370, 695, 35, 49, 248, 54, 38, 48, 33, 615, 661) ASC LIMIT 512Connection name: slave Speed: 1.850 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 11 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (370, 695, 35, 49, 248, 54, 38, 48, 33, 615, 661) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.443 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: 11 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.144 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.119 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.177 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.129 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.127 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.126 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.117 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.127 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.168 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.116 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 400File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT catalogs.* FROM catalogs WHERE (id_domain = '2' AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.148 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 500File: APPPATH/classes/trait/catalog.php, line 169File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 552File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 ('FQ8006', 'FQ2322', 'FQ1065') 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.082 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 423 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/catalog.php, line 560File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ8006', 'FQ2322', 'FQ1065') 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.158 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 423 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 238File: APPPATH/classes/review.php, line 132File: APPPATH/classes/trait/catalog.php, line 560File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 = 35 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.188 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 333File: APPPATH/classes/trait/catalog.php, line 182File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 = 33 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.170 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 333File: APPPATH/classes/trait/catalog.php, line 182File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, permalink, language, id_domain, code FROM catalogs WHERE code = 'colour-mixed-colours' AND template = 'default' AND meta_robots_noindex = 0Connection name: slave Speed: 0.401 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: domain_code_language,meta_robots_noindex · Key Used: domain_code_language · Type: ref · Rows: 12 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 1137File: APPPATH/classes/trait/catalog.php, line 186File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM reviews WHERE reviews.id_domain = 2 AND (reviews.rating >= 4 OR reviews.published = 1) AND LENGTH(review) - LENGTH(REPLACE(review, ' ', '')) + 1 >= 7 ORDER BY reviews.created_datetime DESC LIMIT 9Connection name: slave Speed: 0.165 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: index6 · Key Used: search · Type: index · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 276File: APPPATH/classes/trait/catalog.php, line 195File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75789 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 301File: APPPATH/classes/trait/catalog.php, line 202File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 213File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT countries.*, countries.code, country_i18n.name FROM countries INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE (countries.code IS null AND country_i18n.language = 'es_ES') ORDER BY country_i18n.name ASC LIMIT 1 OFFSET 0Connection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE (Impossible WHERE) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/countries.php, line 309File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_domain, code, name, anchor_text, head_title, geo_country, permalink FROM catalogs WHERE id_domain = 2 AND code IN ('all-our-flowers')Connection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/view.php, line 138File: APPPATH/classes/trait/catalog.php, line 279File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT countries.code, country_i18n.name FROM countries INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE delivery = 1 AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.158 ms Query analysis: · Query: SIMPLE on countries · Possible keys: PRIMARY,delivery · Key Used: delivery · Type: ref · Rows: 95 (Using temporary; Using filesort) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/view.php, line 155File: APPPATH/classes/trait/catalog.php, line 279File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.151 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 357File: APPPATH/classes/controller/catalog.php, line 67File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menu_type.name = 'root' ORDER BY menu_item.positionConnection name: slave Speed: 0.163 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '435'Connection name: slave Speed: 0.133 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.122 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '236' ORDER BY menu_item.positionConnection name: slave Speed: 0.160 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '237' ORDER BY menu_item.positionConnection name: slave Speed: 0.175 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 9 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.114 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '363'Connection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608347'Connection name: slave Speed: 0.134 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '331'Connection name: slave Speed: 0.117 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608396'Connection name: slave Speed: 0.128 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '238' ORDER BY menu_item.positionConnection name: slave Speed: 0.151 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '6'Connection name: slave Speed: 0.143 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '450'Connection name: slave Speed: 0.135 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '445'Connection name: slave Speed: 0.148 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608459'Connection name: slave Speed: 0.263 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608310'Connection name: slave Speed: 0.131 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '515275'Connection name: slave Speed: 0.126 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '500002'Connection name: slave Speed: 0.122 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '3' ORDER BY menu_item.positionConnection name: slave Speed: 0.176 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 7 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608303'Connection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4420'Connection name: slave Speed: 0.134 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608352'Connection name: slave Speed: 0.146 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608171'Connection name: slave Speed: 0.135 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608090'Connection name: slave Speed: 0.130 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4759'Connection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '239' ORDER BY menu_item.positionConnection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '240' ORDER BY menu_item.positionConnection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '241' ORDER BY menu_item.positionConnection name: slave Speed: 0.164 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1344'Connection name: slave Speed: 0.116 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1343'Connection name: slave Speed: 0.117 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1341'Connection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1516'Connection name: slave Speed: 0.125 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1792'Connection name: slave Speed: 0.135 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '3963'Connection name: slave Speed: 0.144 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214375 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.135 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 197File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product FROM catalog_products WHERE id_catalog = 435 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.146 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 28 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.133 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 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') AND products.id IN (231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) ASC LIMIT 512Connection name: slave Speed: 2.710 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.179 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 10 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.149 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.140 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.125 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.135 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.121 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.150 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.126 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'ER83T28I7' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.160 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.151 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.146 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.156 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'ER83T28I7'Connection name: slave Speed: 0.176 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.199 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.202 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'ER83T28I7'Connection name: slave Speed: 0.211 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.138 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.141 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.146 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'L2MJFX7QC' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.126 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'L2MJFX7QC'Connection name: slave Speed: 0.137 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.173 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'L2MJFX7QC'Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.133 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.138 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.120 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.125 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'JADPR4OJY' 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 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.125 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.120 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'JADPR4OJY'Connection name: slave Speed: 0.148 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = 'JADPR4OJY'Connection name: slave Speed: 0.153 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.138 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 ('FQ120', 'FQ2001', 'FQ4049', 'FQ02218', 'FQ02217', 'FQ02216', 'FQ41013C', 'FQ41014', 'FQ02220', 'FQ4058') 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: 3.994 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 150 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/menu.php, line 47File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ120', 'FQ2001', 'FQ4049', 'FQ02218', 'FQ02217', 'FQ02216', 'FQ41013C', 'FQ41014', 'FQ02220', 'FQ4058') 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.164 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 150 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 238File: APPPATH/classes/review.php, line 132File: APPPATH/classes/trait/menu.php, line 47File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product FROM catalog_products WHERE id_catalog = 4 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.168 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 31 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.129 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 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') AND products.id IN (4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) ASC LIMIT 512Connection name: slave Speed: 1.747 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where) · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.164 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 10 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.144 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.135 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.140 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.166 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.138 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.161 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.301 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.165 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.183 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.168 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.143 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.145 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.144 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.128 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.149 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.123 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.126 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.156 ms Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.149 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
| SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.181 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php< |
