
¿Quieres crear un momento inolvidable?
Te contamos todo lo que podemos hacer
¿Quieres crear un momento inolvidable?
Te contamos todo lo que podemos hacer
¿Buscas las flores perfectas para tu boda? Todo lo que necesitas para organizar tu boda (ramo de novia, centros de mesa...).
¿Organizas un evento y quieres que todo salga perfecto? Si organizas una feria o un evento, tenemos plantas o decoración de stands para ti.
Gracias por enviarnos tu petición.
Uno de nuestros asesores se pondrá en contacto contigo en breve.
¡Se ha producido un error!
Por favor, inténtalo otra vez.
196
Console |
579.254 ms
Load Time |
506 Queries
Database |
15.88 MB
Memory Used |
214 Files
Included |
2322 Config
items loaded |
2 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
9Logs |
0 Errors |
0 Memory |
187 Speed |
speed | 0.803 msProfiler::init Start |
log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
speed | 21.345 msFuel\Core\Fuel::init End |
speed | 21.352 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
speed | 22.230 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
speed | 23.205 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
speed | 23.244 msFuel\Core\Uri::__construct Start |
speed | 23.255 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "flores-vip" |
speed | 23.574 msFuel\Core\Request::execute: Start of flores-vip |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 23.942 msController_Base::before init |
speed | 26.725 msController_Base::get_top_delivery_countries global delivery_countries init |
speed | 27.956 msController_Base::get_top_delivery_countries global delivery_countries end |
log | Fuel\Core\Request_Curl::__construct - Creating a new CURL Request with URI = "https://maps.googleapis.com/maps/api/place/details/json" |
speed | 133.066 msFuel\Core\Uri::__construct Start |
speed | 133.072 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new HMVC Request with URI = "page/vip/737087" |
speed | 133.169 msFuel\Core\Request::execute: Start of page/vip/737087 |
log | Fuel\Core\Request::execute - Called |
speed | 133.480 msController_Base::before init |
speed | 133.977 msController_Base::get_top_delivery_countries global delivery_countries init |
speed | 135.092 msController_Base::get_top_delivery_countries global delivery_countries end |
log | Fuel\Core\Request_Curl::__construct - Creating a new CURL Request with URI = "https://maps.googleapis.com/maps/api/place/details/json" |
speed | 203.515 msController_Page::set_template init |
speed | 205.718 msController_Base::after menu init |
speed | 212.438 msController_Base::after FOTOMENU START |
speed | 212.875 msCatalogs::get_collection collection array chunk init |
speed | 215.019 msCatalogs::get_collection collection array chunk end |
speed | 215.409 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 215.424 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 216.321 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 216.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 217.089 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 217.102 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 217.755 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 217.769 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 218.367 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 218.379 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 219.008 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 219.336 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 220.012 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
speed | 220.028 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 220.039 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 220.661 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 220.960 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 221.620 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 222.045 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 222.060 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 222.075 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 222.727 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 222.741 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 223.367 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 223.381 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 228.214 msCatalogs::get_collection collection array chunk init |
speed | 230.107 msCatalogs::get_collection collection array chunk end |
speed | 230.452 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 230.461 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 231.129 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 231.143 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 231.782 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 231.796 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 232.198 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 232.208 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 232.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 233.156 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 233.890 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 234.312 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 234.326 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 234.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 235.010 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 235.024 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 235.449 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 235.460 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 236.083 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 236.096 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 236.496 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 236.506 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 237.225 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 237.239 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 282.520 msCatalogs::get_collection collection array chunk init |
speed | 284.525 msCatalogs::get_collection collection array chunk end |
speed | 284.887 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 284.898 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 285.574 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 285.590 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 286.195 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 286.218 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 286.634 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 286.654 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 287.274 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 287.285 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 287.696 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 287.706 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 288.131 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 288.142 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 288.777 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 288.791 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 289.548 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 289.570 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 289.983 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 289.995 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 290.623 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 290.636 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 298.013 msController_Base::after FOTOMENU END |
speed | 320.479 msController_Base::after menu end |
speed | 320.484 msController_Base::compress_html-START |
speed | 341.909 msController_Base::compress_html-END |
speed | 341.920 msController_Base::replace_html init |
log | Replace {page|url|legal-privacy} to legal-privacy |
speed | 342.850 msController_Base::replace_html end |
speed | 344.472 msFuel\Core\Request::execute: End of page/vip/737087 |
speed | 344.546 msController_Base::after menu init |
speed | 351.100 msController_Base::after FOTOMENU START |
speed | 351.479 msCatalogs::get_collection collection array chunk init |
speed | 353.417 msCatalogs::get_collection collection array chunk end |
speed | 353.800 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 353.810 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 354.452 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 354.470 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 355.102 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 355.116 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 355.741 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 355.754 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 356.388 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 356.401 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 357.012 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 357.216 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 357.833 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
speed | 357.848 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 357.860 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 358.503 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 358.712 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 359.298 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 359.694 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 359.708 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 359.722 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 360.327 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 360.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 361.122 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 361.136 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 365.824 msCatalogs::get_collection collection array chunk init |
speed | 367.690 msCatalogs::get_collection collection array chunk end |
speed | 368.042 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 368.051 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 368.760 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 368.774 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 369.394 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 369.408 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 369.843 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 369.854 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 370.459 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 370.695 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 371.292 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 371.703 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 371.717 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 371.732 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 372.373 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 372.387 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 372.813 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 372.823 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 373.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 373.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 373.898 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 373.908 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 374.532 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 374.546 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 419.549 msCatalogs::get_collection collection array chunk init |
speed | 421.465 msCatalogs::get_collection collection array chunk end |
speed | 421.827 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 421.840 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 422.492 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 422.511 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 423.134 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 423.157 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 423.569 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 423.589 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 424.005 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 424.016 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 424.448 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 424.458 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 424.878 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 424.889 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 425.520 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 425.535 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 426.168 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 426.190 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 426.621 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 426.633 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 427.229 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 427.242 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 436.977 msController_Base::after FOTOMENU END |
speed | 459.291 msController_Base::after menu end |
speed | 460.675 msFuel\Core\Request::execute: End of flores-vip |
speed | 461.524 msEnd of Fuel Execution |
579.254 msLoad Time |
6 s Max Execution Time |
0.803 msProfiler::init Start |
21.345 msFuel\Core\Fuel::init End |
21.352 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
22.230 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
23.205 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
23.244 msFuel\Core\Uri::__construct Start |
23.255 msFuel\Core\Uri::__construct End |
23.574 msFuel\Core\Request::execute: Start of flores-vip |
23.942 msController_Base::before init |
26.725 msController_Base::get_top_delivery_countries global delivery_countries init |
27.956 msController_Base::get_top_delivery_countries global delivery_countries end |
133.066 msFuel\Core\Uri::__construct Start |
133.072 msFuel\Core\Uri::__construct End |
133.169 msFuel\Core\Request::execute: Start of page/vip/737087 |
133.480 msController_Base::before init |
133.977 msController_Base::get_top_delivery_countries global delivery_countries init |
135.092 msController_Base::get_top_delivery_countries global delivery_countries end |
203.515 msController_Page::set_template init |
205.718 msController_Base::after menu init |
212.438 msController_Base::after FOTOMENU START |
212.875 msCatalogs::get_collection collection array chunk init |
215.019 msCatalogs::get_collection collection array chunk end |
215.409 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
215.424 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
216.321 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
216.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
217.089 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
217.102 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
217.755 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
217.769 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
218.367 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
218.379 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
219.008 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
219.336 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
220.012 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
220.028 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
220.039 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
220.661 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
220.960 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
221.620 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
222.045 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
222.060 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
222.075 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
222.727 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
222.741 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
223.367 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
223.381 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
228.214 msCatalogs::get_collection collection array chunk init |
230.107 msCatalogs::get_collection collection array chunk end |
230.452 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
230.461 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
231.129 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
231.143 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
231.782 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
231.796 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
232.198 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
232.208 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
232.830 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
233.156 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
233.890 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
234.312 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
234.326 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
234.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
235.010 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
235.024 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
235.449 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
235.460 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
236.083 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
236.096 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
236.496 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
236.506 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
237.225 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
237.239 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
282.520 msCatalogs::get_collection collection array chunk init |
284.525 msCatalogs::get_collection collection array chunk end |
284.887 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
284.898 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
285.574 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
285.590 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
286.195 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
286.218 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
286.634 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
286.654 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
287.274 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
287.285 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
287.696 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
287.706 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
288.131 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
288.142 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
288.777 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
288.791 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
289.548 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
289.570 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
289.983 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
289.995 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
290.623 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
290.636 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
298.013 msController_Base::after FOTOMENU END |
320.479 msController_Base::after menu end |
320.484 msController_Base::compress_html-START |
341.909 msController_Base::compress_html-END |
341.920 msController_Base::replace_html init |
342.850 msController_Base::replace_html end |
344.472 msFuel\Core\Request::execute: End of page/vip/737087 |
344.546 msController_Base::after menu init |
351.100 msController_Base::after FOTOMENU START |
351.479 msCatalogs::get_collection collection array chunk init |
353.417 msCatalogs::get_collection collection array chunk end |
353.800 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
353.810 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
354.452 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
354.470 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
355.102 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
355.116 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
355.741 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
355.754 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
356.388 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
356.401 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
357.012 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
357.216 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
357.833 msCoupons::apply_discount_prices_item Product 5039 Apply coupon QGCM9S16W |
357.848 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
357.860 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
358.503 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
358.712 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
359.298 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
359.694 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
359.708 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
359.722 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
360.327 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
360.340 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
361.122 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
361.136 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
365.824 msCatalogs::get_collection collection array chunk init |
367.690 msCatalogs::get_collection collection array chunk end |
368.042 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
368.051 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
368.760 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
368.774 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
369.394 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
369.408 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
369.843 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
369.854 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
370.459 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
370.695 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
371.292 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
371.703 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
371.717 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
371.732 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
372.373 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
372.387 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
372.813 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
372.823 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
373.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
373.483 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
373.898 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
373.908 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
374.532 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
374.546 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
419.549 msCatalogs::get_collection collection array chunk init |
421.465 msCatalogs::get_collection collection array chunk end |
421.827 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
421.840 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
422.492 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
422.511 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
423.134 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
423.157 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
423.569 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
423.589 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
424.005 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
424.016 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
424.448 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
424.458 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
424.878 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
424.889 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
425.520 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
425.535 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
426.168 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
426.190 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
426.621 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
426.633 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
427.229 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
427.242 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
436.977 msController_Base::after FOTOMENU END |
459.291 msController_Base::after menu end |
460.675 msFuel\Core\Request::execute: End of flores-vip |
461.524 msEnd of Fuel Execution |
506Total Queries |
175.739 ms Total Time |
381 Duplicates |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.166 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.163 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 22File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default Speed: 7.080 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2957 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/config/staging/my.php, line 48File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default Speed: 0.206 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 77File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 102File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.122 ms · DUPLICATE Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'flores-vip' LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 274File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 2 AND `permalink` = 'flores-vip' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.151 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 310File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default Speed: 0.125 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 383File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/flores-vip' LIMIT 1Connection name: default Speed: 0.218 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-05-26' ORDER BY event_start_date ASCConnection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 124File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 179File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.178 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23950 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1149File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 0.128 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75787 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'flores-vip' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.342 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 737087Connection name: slave Speed: 0.596 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 273File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-05-26 09:30:00') AND (date_end IS null OR date_end >= '2022-05-26 09:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.159 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/page.php, line 20File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT groupname, name, language, text FROM i18n WHERE language IN ('es_ES')Connection name: slave Speed: 7.164 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2981 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/classes/widgets.php, line 138File: APPPATH/classes/controller/page.php, line 25File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 737087 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.183 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/controller/page.php, line 94File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 737087Connection name: slave Speed: 0.630 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/controller/page.php, line 94File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_redirects WHERE id_domain = 2 AND path = '/page/vip/737087' LIMIT 1Connection name: slave Speed: 0.213 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-05-26' ORDER BY event_start_date ASCConnection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 124File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/controller/base.php, line 179File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.158 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23950 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1149File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 0.153 ms · DUPLICATE Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75787 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'flores-vip' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.219 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 737087Connection name: slave Speed: 0.581 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 273File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-05-26 09:30:00') AND (date_end IS null OR date_end >= '2022-05-26 09:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.161 ms · DUPLICATE 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/page.php, line 20File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 737087 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.155 ms · DUPLICATE 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/controller/page.php, line 747File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 737087Connection name: slave Speed: 0.488 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/controller/page.php, line 747File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM countries WHERE countries.delivery = 1Connection name: slave Speed: 0.714 ms Query analysis: · Query: SIMPLE on countries · Possible keys: delivery · Key Used: delivery · Type: ref · Rows: 95 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 765File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE products.sku = 'FQ20008' LIMIT 1Connection name: slave Speed: 0.320 ms Query analysis: · Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 779File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.id, product_languages.product_permalink, product_languages.language, domains.domain, domains.id AS id_domain FROM product_languages INNER JOIN domains ON (domains.language = product_languages.language) WHERE product_languages.id_product = 314 AND domains.type = 'flowers'Connection name: slave Speed: 0.159 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: id_product · Type: ref · Rows: 10 · Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 802File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, permalink, id_domain, code FROM domain_pages WHERE code = 'landing-vip' AND active = 1 AND deleted_time = 0 AND id_domain = 2Connection name: slave Speed: 0.150 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 84File: APPPATH/classes/controller/page.php, line 809File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menu_type.name = 'root' ORDER BY menu_item.positionConnection name: slave Speed: 0.189 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '429'Connection name: slave Speed: 0.192 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.157 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '236' ORDER BY menu_item.positionConnection name: slave Speed: 0.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: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '237' ORDER BY menu_item.positionConnection name: slave Speed: 0.155 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 8 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '363'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '331'Connection name: slave Speed: 0.157 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '345'Connection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '238' ORDER BY menu_item.positionConnection name: slave Speed: 0.145 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '6'Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '450'Connection name: slave Speed: 0.127 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '445'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608310'Connection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500002'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '3' ORDER BY menu_item.positionConnection name: slave Speed: 0.143 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4420'Connection name: slave Speed: 0.150 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608303'Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608090'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608171'Connection name: slave Speed: 0.124 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4759'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '239' ORDER BY menu_item.positionConnection name: slave Speed: 0.146 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '240' ORDER BY menu_item.positionConnection name: slave Speed: 0.143 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '241' ORDER BY menu_item.positionConnection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1344'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1343'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1341'Connection name: slave Speed: 0.155 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1516'Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1792'Connection name: slave Speed: 0.129 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '3963'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 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214375 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.128 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214375Connection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 343File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product FROM catalog_products WHERE id_catalog = 429 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.120 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 28 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) ASC LIMIT 512Connection name: slave Speed: 1.604 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (1518, 2660, 4269, 316, 4271, 5039, 1967, 231, 4266, 5101) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.151 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.182 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.286 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.153 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.232 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.148 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'QGCM9S16W' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.252 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'QGCM9S16W'Connection name: slave Speed: 0.199 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'MKTFQ20' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.231 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'MKTFQ20'Connection name: slave Speed: 0.199 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'MKTFQ20'Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ2370', 'FQ4049', 'FQ41014', 'FQ2001', 'FQ41016', 'FQ41015C', 'FQ2369', 'FQ120', 'FQ41011', 'FQ02201') 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: 2.844 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ2370', 'FQ4049', 'FQ41014', 'FQ2001', 'FQ41016', 'FQ41015C', 'FQ2369', 'FQ120', 'FQ41011', 'FQ02201') 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.162 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product FROM catalog_products WHERE id_catalog = 4 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.141 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 25 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (43, 193, 4635, 30, 27, 2782, 4633, 4269, 2772, 2079) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 43, 193, 4635, 30, 27, 2782, 4633, 4269, 2772, 2079) ASC LIMIT 512Connection name: slave Speed: 1.471 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (43, 193, 4635, 30, 27, 2782, 4633, 4269, 2772, 2079) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.151 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.254 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.175 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.213 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.141 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.148 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.134 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.237 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ2328', 'FQ112', 'FQ4051C', 'FQ108', 'FQ119', 'FQ4058', 'FQ2331C', 'FQ41014', 'FQ1017VIP', 'FQ1223') 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: 28.588 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ2328', 'FQ112', 'FQ4051C', 'FQ108', 'FQ119', 'FQ4058', 'FQ2331C', 'FQ41014', 'FQ1017VIP', 'FQ1223') 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.188 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product FROM catalog_products WHERE id_catalog = 500002 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.175 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 36 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'es_ES') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('es_ES') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (514, 281, 4898, 4890, 2270, 2269, 800, 174, 4978, 4294) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 514, 281, 4898, 4890, 2270, 2269, 800, 174, 4978, 4294) ASC LIMIT 512Connection name: slave Speed: 1.574 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (514, 281, 4898, 4890, 2270, 2269, 800, 174, 4978, 4294) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.169 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.129 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.338 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.147 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.252 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.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 465File: 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 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.147 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ6001', 'FQ160', 'PL30054', 'PL30046', 'FQ6006C', 'FQ7244C', 'FQ966', 'FQ11007', 'PL30055', 'PL41023') 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: 4.679 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ6001', 'FQ160', 'PL30054', 'PL30046', 'FQ6006C', 'FQ7244C', 'FQ966', 'FQ11007', 'PL30055', 'PL41023') 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.144 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 40File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 347File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menus.id FROM menus INNER JOIN menu_type ON (menu_type.id = menus.id_type) WHERE menu_type.name = 'prefooter' AND menus.id_domain = 2Connection name: slave Speed: 0.142 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) · Query: SIMPLE on menus · Possible keys: 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) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '269' ORDER BY menu_item.positionConnection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '270' ORDER BY menu_item.positionConnection name: slave Speed: 0.149 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '271' 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: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1530'Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id IS nullConnection name: slave Speed: 0.147 ms Query analysis: · Query: SIMPLE (Impossible WHERE) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1530'Connection name: slave Speed: 0.149 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1530'Connection name: slave Speed: 0.148 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '1530'Connection name: slave Speed: 0.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '272' ORDER BY menu_item.positionConnection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '282' ORDER BY menu_item.positionConnection name: slave Speed: 0.153 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '363'Connection name: slave Speed: 0.141 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '331'Connection name: slave Speed: 0.142 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '345'Connection name: slave Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id IS nullConnection name: slave Speed: 0.130 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '274' 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: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '6'Connection name: slave Speed: 0.152 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '450'Connection name: slave Speed: 0.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '445'Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '499826'Connection name: slave Speed: 0.139 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500002'Connection name: slave Speed: 0.131 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menus.id FROM menus INNER JOIN menu_type ON (menu_type.id = menus.id_type) WHERE menu_type.name = 'footer' AND menus.id_domain = 2Connection name: slave Speed: 0.127 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) · Query: SIMPLE on menus · Possible keys: 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) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '7' ORDER BY menu_item.positionConnection name: slave Speed: 0.149 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '8' ORDER BY menu_item.positionConnection name: slave Speed: 0.140 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214069 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.127 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214069Connection name: slave Speed: 0.354 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 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 215210 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.146 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 215210Connection name: slave Speed: 0.152 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 1129967 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.126 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 1129967Connection name: slave Speed: 0.118 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 0 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.154 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/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214297 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.128 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214297Connection name: slave Speed: 0.577 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 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '9' ORDER BY menu_item.positionConnection name: slave Speed: 0.157 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214615 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.132 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214615Connection name: slave Speed: 0.365 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 909191 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.138 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 909191Connection name: slave Speed: 0.127 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 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '10' ORDER BY menu_item.positionConnection name: slave Speed: 0.158 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214697 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.136 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214697Connection name: slave Speed: 0.164 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 740413 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.144 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 740413Connection name: slave Speed: 0.520 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 50 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.150 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/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '11' ORDER BY menu_item.positionConnection name: slave Speed: 0.149 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: 4 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214144 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.145 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 214144Connection name: slave Speed: 0.460 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 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/classes/controller/page.php, line 89File: COREPATH/classes/request.php, line 456File: APPPATH |