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 |
540.736 ms
Load Time |
293 Queries
Database |
13.00 MB
Memory Used |
213 Files
Included |
2322 Config
items loaded |
3 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
7Logs |
0 Errors |
0 Memory |
129 Speed |
| speed | 0.536 msProfiler::init Start |
| log | Fuel\Core\Fuel::init - The configured locale en_US is not installed on your system. |
| speed | 16.945 msFuel\Core\Fuel::init End |
| speed | 16.953 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
| speed | 18.421 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
| speed | 31.232 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
| speed | 34.316 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
| speed | 35.306 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
| speed | 35.351 msFuel\Core\Uri::__construct Start |
| speed | 35.366 msFuel\Core\Uri::__construct End |
| log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "my/login/recover" |
| speed | 68.070 msFuel\Core\Request::execute: Start of my/login/recover |
| log | Fuel\Core\Request::execute - Called |
| log | Fuel\Core\Request::execute - Setting main Request |
| speed | 68.760 msController_Base::before init |
| speed | 70.047 msController_Base::get_top_delivery_countries global delivery_countries init |
| speed | 101.097 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 | 164.231 msController_Base::after menu init |
| speed | 179.084 msController_Base::after FOTOMENU START |
| speed | 179.960 msCatalogs::get_collection collection array chunk init |
| speed | 182.306 msCatalogs::get_collection collection array chunk end |
| speed | 182.934 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 183.017 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 196.336 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 196.363 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 197.660 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 197.678 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 198.924 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 198.941 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 200.273 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 200.289 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 201.550 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 201.565 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 202.827 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 203.367 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 204.681 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 205.524 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 205.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 205.558 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 206.815 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 206.830 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 208.079 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 208.094 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 209.357 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 209.375 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 220.010 msCatalogs::get_collection collection array chunk init |
| speed | 222.131 msCatalogs::get_collection collection array chunk end |
| speed | 222.723 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 222.734 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 224.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 224.168 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 225.412 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 225.428 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 226.659 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 226.674 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 227.935 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 228.457 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 229.784 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 230.617 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 230.632 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 230.649 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 231.908 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 231.929 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 232.324 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| log | Catalogs::get_collection Remove FQ20004 from collection Array
(
[a] => IT
[b] => small
)
|
| speed | 232.743 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 233.948 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 234.786 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 234.801 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 235.249 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 236.551 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 237.389 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
| speed | 237.405 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 237.420 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 238.684 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 238.702 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 279.226 msCatalogs::get_collection collection array chunk init |
| speed | 281.431 msCatalogs::get_collection collection array chunk end |
| speed | 282.030 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 282.042 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 283.341 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 283.359 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 284.619 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 284.634 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 285.473 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 285.485 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 286.749 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 287.164 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 288.385 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 289.230 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
| speed | 289.245 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 289.262 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 290.527 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 290.543 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 291.380 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 291.391 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 292.640 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 292.655 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 293.462 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 293.474 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 294.703 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 294.719 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 326.539 msCatalogs::get_collection collection array chunk init |
| speed | 328.763 msCatalogs::get_collection collection array chunk end |
| speed | 329.375 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 329.392 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 330.710 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 330.731 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 332.122 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 332.148 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 332.962 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 332.986 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 333.831 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 333.844 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 334.648 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 334.660 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 335.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 335.484 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 336.689 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 336.705 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 337.924 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 337.949 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 338.753 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 338.766 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
| speed | 339.567 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
| speed | 339.581 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
| speed | 345.586 msController_Base::after FOTOMENU END |
| speed | 386.449 msController_Base::after menu end |
| speed | 386.456 msController_Base::compress_html-START |
| speed | 407.074 msController_Base::compress_html-END |
| speed | 407.086 msController_Base::replace_html init |
| log | Replace {page|url|legal-privacy} to legal-privacy |
| speed | 408.325 msController_Base::replace_html end |
| speed | 409.731 msFuel\Core\Request::execute: End of my/login/recover |
| speed | 409.887 msEnd of Fuel Execution |
540.736 msLoad Time |
6 s Max Execution Time |
0.536 msProfiler::init Start |
16.945 msFuel\Core\Fuel::init End |
16.953 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Start |
18.421 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php Routing |
31.232 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php products |
34.316 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php catalogs |
35.306 ms/var/www/floraqueen-gifts/fuel/app/bootstrap.php End |
35.351 msFuel\Core\Uri::__construct Start |
35.366 msFuel\Core\Uri::__construct End |
68.070 msFuel\Core\Request::execute: Start of my/login/recover |
68.760 msController_Base::before init |
70.047 msController_Base::get_top_delivery_countries global delivery_countries init |
101.097 msController_Base::get_top_delivery_countries global delivery_countries end |
164.231 msController_Base::after menu init |
179.084 msController_Base::after FOTOMENU START |
179.960 msCatalogs::get_collection collection array chunk init |
182.306 msCatalogs::get_collection collection array chunk end |
182.934 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
183.017 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
196.336 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
196.363 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
197.660 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
197.678 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
198.924 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
198.941 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
200.273 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
200.289 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
201.550 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
201.565 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
202.827 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
203.367 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
204.681 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
205.524 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
205.540 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
205.558 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
206.815 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
206.830 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
208.079 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
208.094 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
209.357 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
209.375 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
220.010 msCatalogs::get_collection collection array chunk init |
222.131 msCatalogs::get_collection collection array chunk end |
222.723 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
222.734 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
224.150 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
224.168 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
225.412 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
225.428 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
226.659 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
226.674 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
227.935 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
228.457 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
229.784 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
230.617 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
230.632 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
230.649 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
231.908 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
231.929 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
232.324 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
232.743 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
233.948 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
234.786 msCoupons::apply_discount_prices_item Product 47 Apply coupon 2022WEBDISCOUNT04 MKTD |
234.801 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
235.249 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
236.551 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
237.389 msCoupons::apply_discount_prices_item Product 231 Apply coupon MKTFQ20 MKTD |
237.405 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
237.420 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
238.684 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
238.702 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
279.226 msCatalogs::get_collection collection array chunk init |
281.431 msCatalogs::get_collection collection array chunk end |
282.030 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
282.042 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
283.341 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
283.359 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
284.619 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
284.634 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
285.473 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
285.485 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
286.749 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
287.164 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
288.385 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
289.230 msCoupons::apply_discount_prices_item Product 27 Apply coupon 2022WEBDISCOUNT04 MKTD |
289.245 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
289.262 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
290.527 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
290.543 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
291.380 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
291.391 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
292.640 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
292.655 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
293.462 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
293.474 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
294.703 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
294.719 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
326.539 msCatalogs::get_collection collection array chunk init |
328.763 msCatalogs::get_collection collection array chunk end |
329.375 msCatalogs::get_collection before APPLY DISCOUNT COLLECTION OF ITEMS |
329.392 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
330.710 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
330.731 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
332.122 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
332.148 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
332.962 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
332.986 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
333.831 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
333.844 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
334.648 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
334.660 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
335.470 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
335.484 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
336.689 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
336.705 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
337.924 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
337.949 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
338.753 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
338.766 msCoupons::apply_discount_prices_item APPLY DISCOUNT PRICES |
339.567 msCoupons::apply_discount_prices_item END APPLY DISCOUNT PRICES |
339.581 msCatalogs::get_collection after APPLY DISCOUNT COLLECTION OF ITEMS |
345.586 msController_Base::after FOTOMENU END |
386.449 msController_Base::after menu end |
386.456 msController_Base::compress_html-START |
407.074 msController_Base::compress_html-END |
407.086 msController_Base::replace_html init |
408.325 msController_Base::replace_html end |
409.731 msFuel\Core\Request::execute: End of my/login/recover |
409.887 msEnd of Fuel Execution |
293Total Queries |
210.098 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.337 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.170 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.410 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.333 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.327 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/recover' LIMIT 1Connection name: default Speed: 0.484 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/recover' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.496 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: 0.388 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.184 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.391 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/recover' LIMIT 1Connection name: default Speed: 0.477 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.363 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.351 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: 29.871 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.360 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/recover' AND (`version` IS null OR `version` = '') LIMIT 1Connection name: default Speed: 0.697 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.414 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.373 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.367 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.331 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.353 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.333 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.327 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.340 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.335 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.341 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.349 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.329 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.328 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.330 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.433 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.351 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.355 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.332 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.328 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.340 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.338 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.330 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.345 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.335 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.326 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.343 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.433 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.340 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.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` = '3435'Connection name: default Speed: 0.345 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.348 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.513 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.333 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.337 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: 1.766 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.363 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.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 `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('it_IT')Connection name: default Speed: 7.179 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.376 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.354 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.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.348 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.321 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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/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.375 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.344 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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 `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.345 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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.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.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` = 'MKTFQ20' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 0.451 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.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.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 `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.420 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.345 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.328 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.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.323 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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.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.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.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.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.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 `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.359 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.352 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.350 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.338 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.624 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.359 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.459 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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.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.344 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.441 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.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 `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.409 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.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'Connection name: default Speed: 0.325 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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.329 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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 `coupons` WHERE `code` = '2022WEBDISCOUNT04' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 0.337 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.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/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 `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.331 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.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'Connection name: default Speed: 0.334 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.373 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.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/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.370 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.355 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.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 `coupons` WHERE `code` = 'MKTFQ20'Connection name: default Speed: 0.324 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.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.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.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 `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: 25.590 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.388 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.393 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.331 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: 1.661 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.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.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.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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.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.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/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.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.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.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 `coupons` WHERE `code` = '2022WEBDISCOUNT04' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 0.333 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.335 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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 `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.331 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.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 `coupons` WHERE `code` = '2022WEBDISCOUNT04'Connection name: default Speed: 0.343 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.358 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.323 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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.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.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.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.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 `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.323 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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 `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: 19.720 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.361 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.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: 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.333 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: 1.696 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.347 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.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/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.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.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.480 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.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/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.319 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.327 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.326 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.324 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.329 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.319 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: 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.325 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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.331 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/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: 3.577 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.350 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.350 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.374 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.343 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.347 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.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: 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.338 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.332 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.333 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.336 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.324 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.357 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.337 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.330 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.345 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.330 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.345 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.334 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.323 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.355 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.345 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.338 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.541 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.356 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.474 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.332 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.317 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.343 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.318 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.321 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.721 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.335 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.328 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.643 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.323 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.351 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 `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` = '40' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.356 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/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` = 219698 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.332 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` = 219698Connection name: default Speed: 0.505 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` = 889441 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.335 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` = 889441Connection name: default Speed: 0.606 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` = '41' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.352 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 355File: APPPATH/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` = 219180 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.319 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/reques |