Query Metrics
733
Database Queries
44
Different statements
103.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
33.97 ms (32.78%) |
258 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1770644189 "site_domain_03fae95109d52e1bb2ce82f8f1af9d87" ] |
|
14.85 ms (14.33%) |
104 |
SELECT * FROM object_relations_AWS_PROD WHERE src_id = ?
Parameters:
[
9998
]
|
|
8.68 ms (8.38%) |
61 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[ 1770644189 "object_258\x01tags\x01" "class_AWS_CATEGORY\x01tags\x01" "asset_2001\x01tags\x01" "asset_24\x01tags\x01" ] |
|
7.87 ms (7.60%) |
65 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1770644189 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
7.41 ms (7.15%) |
61 |
SELECT * FROM object_relations_AWS_SER WHERE src_id = ?
Parameters:
[
9997
]
|
|
4.06 ms (3.92%) |
36 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1770644189 "system\x01tags\x01" "site\x01tags\x01" ] |
|
3.03 ms (2.92%) |
9 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_592\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4715\x01tags\x01" "asset_4716\x01tags\x01" "asset_4717\x01tags\x01" "asset_4718\x01tags\x01" ] |
|
2.29 ms (2.21%) |
18 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_9998\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3387\x01tags\x01" "asset_3388\x01tags\x01" "asset_3389\x01tags\x01" ] |
|
1.99 ms (1.92%) |
1 |
SELECT DISTINCT series FROM object_localized_AWS_PROD_cs WHERE ((`showEuro` = ?) AND object_localized_AWS_PROD_cs.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_cs.published = 1
Parameters:
[
1
]
|
|
1.97 ms (1.90%) |
19 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
63
]
|
|
1.92 ms (1.86%) |
19 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
63
]
|
|
1.49 ms (1.43%) |
8 |
SELECT * FROM object_metadata_AWS_SETTINGS WHERE object_metadata_AWS_SETTINGS.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset'
Parameters:
[ 4 1874 "footerLinks" "localizedfield" "localizedfield" "cs" 1 ] |
|
1.44 ms (1.39%) |
10 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_10005\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4344\x01tags\x01" "asset_4345\x01tags\x01" "asset_4346\x01tags\x01" "asset_4347\x01tags\x01" "asset_4348\x01tags\x01" "asset_4349\x01tags\x01" "asset_4350\x01tags\x01" ] |
|
1.12 ms (1.08%) |
10 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/cs/produkty/" "napajeci-zdroje-do-zasuvky" ] |
|
1.11 ms (1.07%) |
1 |
SELECT object_localized_AWS_PROD_cs.id as id, object_localized_AWS_PROD_cs.type as `type` FROM object_localized_AWS_PROD_cs WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`showEuro` = ?) AND object_localized_AWS_PROD_cs.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_cs.published = 1 ORDER BY `priority` ASC
Parameters:
[ 393 396 579 10002 10005 10008 9999 604 520 582 522 584 524 404 585 527 532 533 538 413 432 505 390 391 420 421 542 425 10001 519 401 406 408 591 534 536 10000 10006 416 601 422 434 515 578 397 518 402 525 586 405 407 593 594 535 414 540 10007 9998 417 418 419 423 424 605 426 429 609 435 513 517 398 400 521 587 588 592 595 411 596 598 541 430 431 433 389 392 514 394 516 395 399 583 523 403 526 590 409 410 597 412 537 539 415 600 1 ] |
|
1.05 ms (1.02%) |
1 |
SELECT DISTINCT categories FROM object_localized_AWS_SER_cs WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_cs.type IN ('object','variant','folder')) AND object_localized_AWS_SER_cs.published = 1
Parameters:
[ 9991 307 325 324 301 303 340 342 343 344 345 347 349 350 351 355 356 352 337 299 311 365 298 297 296 310 279 277 336 326 278 327 332 328 329 331 318 317 313 360 272 346 348 292 291 353 354 357 358 359 280 361 362 306 338 333 364 9995 339 285 9997 9993 9988 9987 9996 ] |
|
0.94 ms (0.91%) |
6 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_409\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3633\x01tags\x01" "asset_3634\x01tags\x01" "asset_3635\x01tags\x01" "asset_3636\x01tags\x01" "asset_3637\x01tags\x01" "asset_3638\x01tags\x01" "asset_3639\x01tags\x01" "asset_3640\x01tags\x01" "asset_3641\x01tags\x01" "asset_3642\x01tags\x01" "asset_3643\x01tags\x01" ] |
|
0.71 ms (0.68%) |
1 |
SELECT object_localized_AWS_CATEGORY_cs.id as id, object_localized_AWS_CATEGORY_cs.type as `type` FROM object_localized_AWS_CATEGORY_cs WHERE (`urlSlug` = 'napajeci-zdroje-do-zasuvky' AND object_localized_AWS_CATEGORY_cs.type IN ('variant','object')) AND object_localized_AWS_CATEGORY_cs.published = 1
Parameters:
[] |
|
0.68 ms (0.66%) |
1 |
SELECT object_localized_AWS_SER_cs.id as id, object_localized_AWS_SER_cs.type as `type` FROM object_localized_AWS_SER_cs WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_cs.type IN ('object','variant','folder')) AND object_localized_AWS_SER_cs.published = 1 ORDER BY `orderPriority` ASC
Parameters:
[ 9991 307 325 324 301 303 340 342 343 344 345 347 349 350 351 355 356 352 337 299 311 365 298 297 296 310 279 277 336 326 278 327 332 328 329 331 318 317 313 360 272 346 348 292 291 353 354 357 358 359 280 361 362 306 338 333 364 9995 339 285 9997 9993 9988 9987 9996 ] |
|
0.61 ms (0.58%) |
1 |
SELECT object_localized_AWS_SER_cs.id as id, object_localized_AWS_SER_cs.type as `type` FROM object_localized_AWS_SER_cs WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`categories` LIKE ?) AND object_localized_AWS_SER_cs.type IN ('object','variant','folder')) AND object_localized_AWS_SER_cs.published = 1 ORDER BY `orderPriority` ASC
Parameters:
[ 9991 307 325 324 301 303 340 342 343 344 345 347 349 350 351 355 356 352 337 299 311 365 298 297 296 310 279 277 336 326 278 327 332 328 329 331 318 317 313 360 272 346 348 292 291 353 354 357 358 359 280 361 362 306 338 333 364 9995 339 285 9997 9993 9988 9987 9996 "%,258,%" ] |
|
0.60 ms (0.57%) |
3 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_425\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3758\x01tags\x01" "asset_3759\x01tags\x01" "asset_3760\x01tags\x01" "asset_3761\x01tags\x01" "asset_3762\x01tags\x01" "asset_3763\x01tags\x01" ] |
|
0.58 ms (0.56%) |
6 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"AWS_CATEGORY"
]
|
|
0.57 ms (0.55%) |
4 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_593\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4722\x01tags\x01" "asset_4723\x01tags\x01" "asset_4724\x01tags\x01" "asset_4725\x01tags\x01" "asset_4726\x01tags\x01" "asset_4727\x01tags\x01" "asset_4728\x01tags\x01" "asset_4729\x01tags\x01" ] |
|
0.50 ms (0.48%) |
3 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_516\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4258\x01tags\x01" "asset_4259\x01tags\x01" "asset_4260\x01tags\x01" "asset_4261\x01tags\x01" "asset_4262\x01tags\x01" "asset_4263\x01tags\x01" "asset_4264\x01tags\x01" "asset_4265\x01tags\x01" "asset_4266\x01tags\x01" "asset_4267\x01tags\x01" "asset_4268\x01tags\x01" "asset_4269\x01tags\x01" ] |
|
0.41 ms (0.40%) |
2 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/cs/produkty/napajeci-zdroje-do-zasuvky" "path" "auto_create" "/cs/produkty/napajeci-zdroje-do-zasuvky" "path_query" "https://sunny.test.awebsys.cz/cs/produkty/napajeci-zdroje-do-zasuvky" "entire_uri" ] |
|
0.40 ms (0.38%) |
2 |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "productPriorityOrder" null null ] |
|
0.39 ms (0.38%) |
3 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.38 ms (0.36%) |
1 |
SELECT object_localized_AWS_CATEGORY_cs.id as id, object_localized_AWS_CATEGORY_cs.type as `type` FROM object_localized_AWS_CATEGORY_cs WHERE (`urlSlug` = 'napajeci-zdroje-do-zasuvky' AND object_localized_AWS_CATEGORY_cs.type IN ('variant','object')) AND object_localized_AWS_CATEGORY_cs.published = 1 LIMIT 1
Parameters:
[] |
|
0.32 ms (0.31%) |
1 |
SELECT object_localized_AWS_CATEGORY_cs.id as id, object_localized_AWS_CATEGORY_cs.type as `type` FROM object_localized_AWS_CATEGORY_cs WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_CATEGORY_cs.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_cs.published = 1 ORDER BY `orderPriority` ASC
Parameters:
[ 258 263 259 262 269 265 266 264 268 261 ] |
|
0.25 ms (0.25%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/cs/produkty/napajeci-zdroje-do-zasuvky"
]
|
|
0.23 ms (0.22%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Filters/" "ProductFilter" ] |
|
0.21 ms (0.20%) |
1 |
SELECT * FROM object_metadata_AWS_SETTINGS WHERE object_metadata_AWS_SETTINGS.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'document'
Parameters:
[ 4 288 "footerLinks" "localizedfield" "localizedfield" "cs" 9 ] |
|
0.19 ms (0.19%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
3
]
|
|
0.18 ms (0.18%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_609\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4839\x01tags\x01" "asset_4840\x01tags\x01" "asset_4841\x01tags\x01" "asset_4842\x01tags\x01" "asset_4843\x01tags\x01" "asset_4844\x01tags\x01" "asset_4845\x01tags\x01" "asset_4846\x01tags\x01" "asset_4847\x01tags\x01" "asset_4848\x01tags\x01" "asset_4849\x01tags\x01" "asset_4850\x01tags\x01" "asset_4851\x01tags\x01" ] |
|
0.17 ms (0.16%) |
1 |
SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = ?
Parameters:
[
4
]
|
|
0.16 ms (0.15%) |
1 |
SELECT * FROM object_relations_AWS_SER WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 258 "categories" ] |
|
0.14 ms (0.13%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1770644189 "object_598\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4771\x01tags\x01" "asset_4772\x01tags\x01" "asset_4773\x01tags\x01" "asset_4774\x01tags\x01" "asset_4775\x01tags\x01" "asset_4776\x01tags\x01" "asset_4777\x01tags\x01" "asset_4778\x01tags\x01" "asset_4779\x01tags\x01" "asset_4780\x01tags\x01" ] |
|
0.13 ms (0.13%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
611
]
|
|
0.11 ms (0.11%) |
1 |
SELECT id FROM assets WHERE id IN (1874,1879,1878,1877,1875,1876,1880,2078)
Parameters:
[] |
|
0.11 ms (0.11%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.10 ms (0.10%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.10 ms (0.10%) |
1 |
SELECT id FROM documents WHERE published=1 AND id IN (288);
Parameters:
[] |
|
0.09 ms (0.09%) |
1 |
SELECT id FROM documents WHERE id IN (288)
Parameters:
[] |
|
0.09 ms (0.09%) |
1 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Series"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore_generic_data_index | doctrine.orm.pimcore_generic_data_index_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.