Query Metrics
1223
Database Queries
38
Different statements
152.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
51.86 ms (33.99%) |
452 |
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:
[ 1765781551 "site_domain_03fae95109d52e1bb2ce82f8f1af9d87" ] |
|
31.35 ms (20.55%) |
236 |
SELECT * FROM object_relations_AWS_PROD WHERE src_id = ?
Parameters:
[
9998
]
|
|
21.42 ms (14.04%) |
176 |
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:
[ 1765781551 "object_258\x01tags\x01" "class_AWS_CATEGORY\x01tags\x01" "asset_2001\x01tags\x01" "asset_24\x01tags\x01" ] |
|
10.44 ms (6.84%) |
86 |
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:
[ 1765781551 "system\x01tags\x01" "site\x01tags\x01" ] |
|
7.69 ms (5.04%) |
67 |
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:
[ 1765781551 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
6.46 ms (4.23%) |
61 |
SELECT * FROM object_relations_AWS_SER WHERE src_id = ?
Parameters:
[
9997
]
|
|
4.30 ms (2.82%) |
33 |
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:
[ 1765781551 "object_9998\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3387\x01tags\x01" "asset_3388\x01tags\x01" "asset_3389\x01tags\x01" ] |
|
1.97 ms (1.29%) |
1 |
SELECT DISTINCT series FROM object_localized_AWS_PROD_fr WHERE ((`showEuro` = ?) AND object_localized_AWS_PROD_fr.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_fr.published = 1
Parameters:
[
1
]
|
|
1.47 ms (0.96%) |
14 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/fr/" "produits" ] |
|
1.42 ms (0.93%) |
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" "fr" 1 ] |
|
1.37 ms (0.90%) |
11 |
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:
[ 1765781551 "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" ] |
|
1.37 ms (0.90%) |
1 |
SELECT object_localized_AWS_PROD_fr.id as id, object_localized_AWS_PROD_fr.type as `type` FROM object_localized_AWS_PROD_fr WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`showEuro` = ?) AND object_localized_AWS_PROD_fr.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_fr.published = 1 ORDER BY `priority` ASC
Parameters:
[ 9999 10002 10005 10008 393 396 404 520 522 524 527 532 533 538 413 604 547 428 557 585 584 582 565 568 570 456 579 437 445 449 461 464 468 471 472 473 476 486 487 490 493 512 511 503 501 379 380 10001 390 391 519 401 406 505 408 534 536 542 421 420 425 591 546 550 551 559 562 432 575 441 450 451 452 462 465 603 608 494 376 499 381 377 10000 10004 10006 405 518 402 407 525 397 515 535 540 414 416 422 593 594 601 549 427 586 566 504 571 434 576 460 458 578 373 439 443 454 469 466 482 480 606 484 488 510 508 500 382 9998 10007 513 517 609 400 521 398 541 605 411 418 423 419 417 424 426 429 592 595 596 598 543 545 548 552 560 561 588 587 564 569 455 574 457 459 435 580 436 438 447 448 453 463 474 481 607 483 485 496 507 509 384 497 502 383 378 10003 389 392 514 394 395 516 403 523 526 399 537 539 409 410 412 415 430 590 597 600 544 553 554 555 556 558 602 583 563 567 572 573 433 431 577 442 444 440 446 581 467 470 477 479 475 478 599 489 491 492 495 498 1 ] |
|
1.35 ms (0.88%) |
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:
[ 1765781551 "object_10006\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_4354\x01tags\x01" "asset_4355\x01tags\x01" "asset_4356\x01tags\x01" "asset_4357\x01tags\x01" "asset_4358\x01tags\x01" "asset_4359\x01tags\x01" "asset_4360\x01tags\x01" ] |
|
1.03 ms (0.67%) |
10 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2001
]
|
|
1.02 ms (0.67%) |
1 |
SELECT DISTINCT categories FROM object_localized_AWS_SER_fr WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_fr.type IN ('object','variant','folder')) AND object_localized_AWS_SER_fr.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 ] |
|
1.01 ms (0.66%) |
10 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2001
]
|
|
0.82 ms (0.54%) |
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:
[ 1765781551 "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.73 ms (0.48%) |
2 |
SELECT object_localized_AWS_CATEGORY_fr.id as id, object_localized_AWS_CATEGORY_fr.type as `type` FROM object_localized_AWS_CATEGORY_fr WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_CATEGORY_fr.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_fr.published = 1 ORDER BY `orderPriority` ASC
Parameters:
[ 258 263 259 262 269 265 266 264 268 261 ] |
|
0.64 ms (0.42%) |
1 |
SELECT object_localized_AWS_SER_fr.id as id, object_localized_AWS_SER_fr.type as `type` FROM object_localized_AWS_SER_fr WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_fr.type IN ('object','variant','folder')) AND object_localized_AWS_SER_fr.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.60 ms (0.40%) |
6 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"AWS_PROD"
]
|
|
0.52 ms (0.34%) |
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:
[ 1765781551 "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.44 ms (0.29%) |
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:
[ 1765781551 "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.43 ms (0.28%) |
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.43 ms (0.28%) |
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:
[ "/fr/produits" "path" "auto_create" "/fr/produits" "path_query" "https://sunny.test.awebsys.cz/fr/produits" "entire_uri" ] |
|
0.39 ms (0.25%) |
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:
[ 1765781551 "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.34 ms (0.22%) |
3 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.25 ms (0.16%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Filters/" "ProductFilter" ] |
|
0.19 ms (0.13%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
3
]
|
|
0.16 ms (0.10%) |
1 |
SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = ?
Parameters:
[
4
]
|
|
0.15 ms (0.10%) |
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:
[ 1765781551 "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.14 ms (0.09%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.14 ms (0.09%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
27
]
|
|
0.13 ms (0.09%) |
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:
[ 1765781551 "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.08%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
611
]
|
|
0.12 ms (0.08%) |
1 |
SELECT id FROM assets WHERE id IN (1874,1879,1878,1877,1875,1876,1880,2078)
Parameters:
[] |
|
0.11 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/fr/produits' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.11 ms (0.07%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/fr/produits"
]
|
|
0.10 ms (0.07%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.