Uno spazio per i rivenditori al dettaglio come te.
Spedizioni gratuite
per tutti i tuoi ordini.
Calendario personalizzato
con le tue date più importanti.
Offerte esclusive
per i membri.
Utilizziamo i cookie per migliorare la tua esperienza di acquisto. Se continui a navigare, considereremo che accetti l'uso degli stessi. Per ulteriori opzioni e informazioni su come li utilizziamo, fai clic su qui.
136
Console |
638.529 ms
Load Time |
293 Queries
Database |
13.05 MB
Memory Used |
218 Files
Included |
2322 Config
items loaded |
3 Session
vars loaded |
1 GET
vars loaded |
0 POST
vars loaded |
7Logs |
0 Errors |
0 Memory |
129 Speed |
speed | 0.673 msProfiler::init Start |
log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
speed | 18.728 msFuel\Core\Fuel::init End |
speed | 18.735 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
speed | 20.240 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
speed | 64.261 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
speed | 67.363 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
speed | 68.447 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
speed | 68.498 msFuel\Core\Uri::__construct Start |
speed | 68.514 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "my/login" |
speed | 101.918 msFuel\Core\Request::execute: Start of my/login |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 102.563 msController_Base::before init |
speed | 104.233 msController_Base::get_top_delivery_countries global delivery_countries init |
speed | 137.197 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 | 224.616 msController_Base::after menu init |
speed | 241.167 msController_Base::after FOTOMENU START |
speed | 242.042 msCatalogs::get_collection collection array chunk init |
speed | 244.887 msCatalogs::get_collection collection array chunk end |
speed | 245.626 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 245.707 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 260.132 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 260.158 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 261.483 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 261.502 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 262.771 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 262.787 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 264.037 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 264.052 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 265.303 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 265.324 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 266.592 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 267.140 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 268.454 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 269.377 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 269.393 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 269.411 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 270.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 270.788 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 272.051 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 272.066 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 273.393 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 273.410 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 284.567 msCatalogs::get_collection collection array chunk init |
speed | 286.904 msCatalogs::get_collection collection array chunk end |
speed | 287.508 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 287.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 288.860 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 288.878 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 290.162 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 290.178 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 291.492 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 291.507 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 292.797 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 293.350 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 294.727 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 295.614 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 295.629 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 295.645 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 296.981 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 297.004 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 297.410 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
log | Catalogs::get_collection Remove FQ20004 from collection Array
(
[a] => IT
[b] => small
)
|
speed | 297.847 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 299.145 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 300.085 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 300.115 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 300.618 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 301.895 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 302.742 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
speed | 302.760 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 302.776 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 304.052 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 304.072 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 346.638 msCatalogs::get_collection collection array chunk init |
speed | 349.715 msCatalogs::get_collection collection array chunk end |
speed | 350.335 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 350.347 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 351.775 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 351.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 353.180 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 353.197 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 354.071 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 354.083 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 355.366 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 355.835 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 357.093 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 357.929 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
speed | 357.945 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 357.962 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 359.441 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 359.457 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 360.328 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 360.342 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 361.626 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 361.644 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 362.676 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 362.697 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 364.216 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 364.243 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 399.537 msCatalogs::get_collection collection array chunk init |
speed | 402.367 msCatalogs::get_collection collection array chunk end |
speed | 402.969 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 402.984 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 404.329 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 404.350 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 405.674 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 405.698 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 406.557 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 406.581 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 407.417 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 407.429 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 408.250 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 408.261 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 409.098 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 409.111 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 410.477 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 410.494 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 411.841 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 411.867 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 412.751 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 412.764 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
speed | 413.641 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
speed | 413.656 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
speed | 420.961 msController_Base::after FOTOMENU END |
speed | 468.076 msController_Base::after menu end |
speed | 468.083 msController_Base::compress_html-START |
speed | 490.907 msController_Base::compress_html-END |
speed | 490.925 msController_Base::replace_html init |
log | Replace {page|url|legal-privacy} to legal-privacy |
speed | 492.240 msController_Base::replace_html end |
speed | 493.659 msFuel\Core\Request::execute: End of my/login |
speed | 493.815 msEnd of Fuel Execution |
638.529 msLoad Time |
6 s Max Execution Time |
0.673 msProfiler::init Start |
18.728 msFuel\Core\Fuel::init End |
18.735 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
20.240 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
64.261 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
67.363 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
68.447 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
68.498 msFuel\Core\Uri::__construct Start |
68.514 msFuel\Core\Uri::__construct End |
101.918 msFuel\Core\Request::execute: Start of my/login |
102.563 msController_Base::before init |
104.233 msController_Base::get_top_delivery_countries global delivery_countries init |
137.197 msController_Base::get_top_delivery_countries global delivery_countries end |
224.616 msController_Base::after menu init |
241.167 msController_Base::after FOTOMENU START |
242.042 msCatalogs::get_collection collection array chunk init |
244.887 msCatalogs::get_collection collection array chunk end |
245.626 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
245.707 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
260.132 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
260.158 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
261.483 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
261.502 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
262.771 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
262.787 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
264.037 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
264.052 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
265.303 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
265.324 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
266.592 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
267.140 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
268.454 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
269.377 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
269.393 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
269.411 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
270.772 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
270.788 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
272.051 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
272.066 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
273.393 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
273.410 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
284.567 msCatalogs::get_collection collection array chunk init |
286.904 msCatalogs::get_collection collection array chunk end |
287.508 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
287.521 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
288.860 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
288.878 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
290.162 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
290.178 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
291.492 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
291.507 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
292.797 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
293.350 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
294.727 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
295.614 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
295.629 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
295.645 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
296.981 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
297.004 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
297.410 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
297.847 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
299.145 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
300.085 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
300.115 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
300.618 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
301.895 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
302.742 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
302.760 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
302.776 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
304.052 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
304.072 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
346.638 msCatalogs::get_collection collection array chunk init |
349.715 msCatalogs::get_collection collection array chunk end |
350.335 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
350.347 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
351.775 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
351.795 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
353.180 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
353.197 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
354.071 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
354.083 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
355.366 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
355.835 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
357.093 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
357.929 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
357.945 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
357.962 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
359.441 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
359.457 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
360.328 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
360.342 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
361.626 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
361.644 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
362.676 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
362.697 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
364.216 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
364.243 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
399.537 msCatalogs::get_collection collection array chunk init |
402.367 msCatalogs::get_collection collection array chunk end |
402.969 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
402.984 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
404.329 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
404.350 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
405.674 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
405.698 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
406.557 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
406.581 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
407.417 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
407.429 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
408.250 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
408.261 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
409.098 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
409.111 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
410.477 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
410.494 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
411.841 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
411.867 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
412.751 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
412.764 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
413.641 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
413.656 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
420.961 msController_Base::after FOTOMENU END |
468.076 msController_Base::after menu end |
468.083 msController_Base::compress_html-START |
490.907 msController_Base::compress_html-END |
490.925 msController_Base::replace_html init |
492.240 msController_Base::replace_html end |
493.659 msFuel\Core\Request::execute: End of my/login |
493.815 msEnd of Fuel Execution |
293Total Queries |
259.458 ms Total Time |
172 Duplicates |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default Speed: 0.359 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-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.362 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.726 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.412 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-it.floraqueen.net'Connection name: default Speed: 0.337 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-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.342 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` = 5 AND `permalink` = 'my/login' LIMIT 1Connection name: default Speed: 0.489 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` = 5 AND `permalink` = 'my/login' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.499 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 310File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 5 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default Speed: 31.273 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27400 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 25File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('it_IT')Connection name: default Speed: 3.111 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 5966 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 38File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5Connection name: default Speed: 0.424 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` = 5 AND `path` = '/my/login' LIMIT 1Connection name: default Speed: 0.395 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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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` = 5 AND `event_start_date` IS NOT null AND `event_start_date` >= '2022-05-26' ORDER BY `event_start_date` ASCConnection name: default Speed: 0.638 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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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` = 5 LIMIT 1Connection name: default Speed: 0.402 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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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` = 5 AND `catalogs`.`template` = 'browsing-directory-flowers' AND `catalogs`.`geo_type` = 'cn' AND `country_i18n`.`language` = 'it_IT' ORDER BY `country_i18n`.`name` ASCConnection name: default Speed: 31.182 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23658 (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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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 `reviews`Connection name: default Speed: 0.384 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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `deleted_time` = 0 AND `active` = 1 AND `permalink` = 'my/login' AND (`version` IS null OR `version` = '') LIMIT 1Connection name: default Speed: 0.620 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/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: COREPATH/classes/request.php, line 452File: 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` = 5 AND `menu_type`.`name` = 'root' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.383 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '432'Connection name: default Speed: 0.464 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '328'Connection name: default Speed: 0.459 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '339'Connection name: default Speed: 0.439 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '188' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.385 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '189' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.339 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '339'Connection name: default Speed: 0.340 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '367'Connection name: default Speed: 0.426 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '335'Connection name: default Speed: 0.422 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '349'Connection name: default Speed: 0.419 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '190' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.363 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '471'Connection name: default Speed: 0.424 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '454'Connection name: default Speed: 0.400 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '448'Connection name: default Speed: 0.408 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608308'Connection name: default Speed: 0.430 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500001'Connection name: default Speed: 0.408 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '14' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.362 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4706'Connection name: default Speed: 0.406 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608299'Connection name: default Speed: 0.418 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608093'Connection name: default Speed: 0.405 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608172'Connection name: default Speed: 0.411 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4589'Connection name: default Speed: 0.408 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '248' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.351 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '249' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.361 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '250' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.351 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3108'Connection name: default Speed: 0.443 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1337'Connection name: default Speed: 0.417 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3433'Connection name: default Speed: 0.410 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1335'Connection name: default Speed: 0.409 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1334'Connection name: default Speed: 0.425 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3435'Connection name: default Speed: 0.407 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 219396 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.354 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 219396Connection name: default Speed: 0.479 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 432 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 23 (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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.321 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badge_i18n`.`name` AS `badge_name`, `products_badge_i18n`.`url` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default_collection` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `products_badge_i18n` ON (`products_badge_i18n`.`id_badge` = `products_badges`.`id` AND `products_badge_i18n`.`language` = 'it_IT') 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 ('it_IT') 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, 1967, 231, 4266, 5101, 43) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 1518, 2660, 4269, 316, 4271, 1967, 231, 4266, 5101, 43) ASC LIMIT 512Connection name: default Speed: 2.210 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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, 1967, 231, 4266, 5101, 43) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.384 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('it_IT')Connection name: default Speed: 8.307 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2961 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/classes/coupons.php, line 460File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.379 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.346 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.333 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.361 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.360 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.348 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.337 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.330 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.333 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.328 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.341 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.339 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.329 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.353 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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: default Speed: 0.455 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.341 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.333 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.412 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.372 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.384 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.379 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.356 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.348 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.336 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.337 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.353 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.349 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.378 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' AND `reviews`.`sku` IN ('FQ2370', 'FQ4049', 'FQ41014', 'FQ2001', 'FQ41016', 'FQ2369', 'FQ120', 'FQ41011', 'FQ02201', 'FQ2328') 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: default Speed: 6.814 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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', 'FQ2369', 'FQ120', 'FQ41011', 'FQ02201', 'FQ2328') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.360 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 328 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.373 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 22 (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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.326 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badge_i18n`.`name` AS `badge_name`, `products_badge_i18n`.`url` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default_collection` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `products_badge_i18n` ON (`products_badge_i18n`.`id_badge` = `products_badges`.`id` AND `products_badge_i18n`.`language` = 'it_IT') 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 ('it_IT') 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 (29, 30, 2157, 43, 27, 2782, 310, 47, 231, 193) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 29, 30, 2157, 43, 27, 2782, 310, 47, 231, 193) ASC LIMIT 512Connection name: default Speed: 1.835 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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 (29, 30, 2157, 43, 27, 2782, 310, 47, 231, 193) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.364 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.348 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.336 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.336 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.340 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.357 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.356 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.343 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.359 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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: default Speed: 0.464 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.343 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.347 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.463 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.365 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.351 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.390 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.350 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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: default Speed: 0.354 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 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.360 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.355 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.365 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.357 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.385 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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: default Speed: 0.367 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 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.363 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.341 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.337 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.341 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.334 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.333 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' AND `reviews`.`sku` IN ('FQ117', 'FQ108', 'FQ2110C', 'FQ2328', 'FQ119', 'FQ4058', 'FQ8008', 'FQ120', 'FQ112') 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: default Speed: 27.487 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 2663 (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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS `avg`, `reviews`.`sku` FROM `reviews` WHERE `reviews`.`sku` IN ('FQ117', 'FQ108', 'FQ2110C', 'FQ2328', 'FQ119', 'FQ4058', 'FQ8008', 'FQ120', 'FQ112') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.371 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 2663 (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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 339 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.437 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.347 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badge_i18n`.`name` AS `badge_name`, `products_badge_i18n`.`url` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default_collection` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `products_badge_i18n` ON (`products_badge_i18n`.`id_badge` = `products_badges`.`id` AND `products_badge_i18n`.`language` = 'it_IT') 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 ('it_IT') 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: default Speed: 2.543 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.370 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.379 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.369 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.364 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.407 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.361 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.339 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.348 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.352 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.346 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.334 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.332 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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: default Speed: 0.361 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 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.346 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.335 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.341 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.329 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.350 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.353 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.515 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.361 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.355 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.344 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.333 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.361 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.392 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.356 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.345 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.371 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.383 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' 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: default Speed: 22.845 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.379 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 500001 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.492 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.381 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badge_i18n`.`name` AS `badge_name`, `products_badge_i18n`.`url` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default_collection` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `products_badge_i18n` ON (`products_badge_i18n`.`id_badge` = `products_badges`.`id` AND `products_badge_i18n`.`language` = 'it_IT') 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 ('it_IT') 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: default Speed: 2.315 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.358 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.336 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.353 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.403 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.328 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.353 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.345 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.355 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.357 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.342 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.330 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.339 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.350 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.346 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 347File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.332 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.433 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.351 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.381 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.384 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.359 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5 LIMIT 1Connection name: default Speed: 0.369 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' 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: default Speed: 4.187 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.389 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 5Connection name: default Speed: 0.362 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '283' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.380 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '284' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.386 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '285' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.378 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '286' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.385 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '287' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.387 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '339'Connection name: default Speed: 0.365 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '367'Connection name: default Speed: 0.403 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '335'Connection name: default Speed: 0.382 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '349'Connection name: default Speed: 0.388 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '288' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.434 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 31File: APPPATH/classes/controller/base.php, line 352File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '471'Connection name: default Speed: 0.362 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '454'Connection name: default Speed: 0.371 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '448'Connection name: default Speed: 0.366 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '499825'Connection name: default Speed: 0.509 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500001'Connection name: default Speed: 0.409 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '607466'Connection name: default Speed: 0.510 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: 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` = 5Connection name: default Speed: 0.557 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '27' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.389 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 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '28' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.378 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 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 219110 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.374 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 219110Connection name: default Speed: 0.609 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 220181 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.387 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 220181Connection name: default Speed: 0.571 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 1129972 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.366 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 1129972Connection name: default Speed: 0.366 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 0 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.364 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 0 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.376 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/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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 219323 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.532 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 219323Connection name: default Speed: 0.935 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 5 AND `menus`.`id` = '29' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.402 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 219621 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.343 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 219621Connection name: default Speed: 0.629 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 5 AND `id` = 914185 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.374 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/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 914185Connection name: default Speed: 0.480 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · |