Symfony Profiler

Query Metrics

1223 Database Queries

38 Different statements

161.93 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
56.69 ms (35.01%)	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: [`1770643957 "site_domain_03fae95109d52e1bb2ce82f8f1af9d87"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_03fae95109d52e1bb2ce82f8f1af9d87');
33.94 ms (20.96%)	236	SELECT * FROM object_relations_AWS_PROD WHERE src_id = ? Parameters: [`9998`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AWS_PROD WHERE src_id = ? SELECT * FROM object_relations_AWS_PROD WHERE src_id = 9998;
21.58 ms (13.33%)	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: [`1770643957 "object_258\x01tags\x01" "class_AWS_CATEGORY\x01tags\x01" "asset_2001\x01tags\x01" "asset_24\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_258tags', 'class_AWS_CATEGORYtags', 'asset_2001tags', 'asset_24tags');
10.02 ms (6.19%)	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: [`1770643957 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
7.95 ms (4.91%)	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: [`1770643957 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
6.56 ms (4.05%)	61	SELECT * FROM object_relations_AWS_SER WHERE src_id = ? Parameters: [`9997`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AWS_SER WHERE src_id = ? SELECT * FROM object_relations_AWS_SER WHERE src_id = 9997;
4.33 ms (2.67%)	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: [`1770643957 "object_9998\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3387\x01tags\x01" "asset_3388\x01tags\x01" "asset_3389\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_9998tags', 'class_AWS_PRODtags', 'asset_3387tags', 'asset_3388tags', 'asset_3389tags');
2.17 ms (1.34%)	1	SELECT DISTINCT series FROM object_localized_AWS_PROD_de WHERE ((`showEuro` = ?) AND object_localized_AWS_PROD_de.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_de.published = 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT DISTINCT series FROM object_localized_AWS_PROD_de WHERE ( (`showEuro` = ?) AND object_localized_AWS_PROD_de.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_PROD_de.published = 1 SELECT DISTINCT series FROM object_localized_AWS_PROD_de WHERE ((`showEuro` = 1) AND object_localized_AWS_PROD_de.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_de.published = 1;
2.05 ms (1.27%)	1	SELECT DISTINCT categories FROM object_localized_AWS_SER_de WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_de.type IN ('object','variant','folder')) AND object_localized_AWS_SER_de.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`] View formatted query View runnable query Explain query SELECT DISTINCT categories FROM object_localized_AWS_SER_de WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND object_localized_AWS_SER_de.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_SER_de.published = 1 SELECT DISTINCT categories FROM object_localized_AWS_SER_de WHERE ((`id` IN (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)) AND object_localized_AWS_SER_de.type IN ('object','variant','folder')) AND object_localized_AWS_SER_de.published = 1;
1.51 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" "de" 1`] View formatted query View runnable query Explain query 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' SELECT * FROM object_metadata_AWS_SETTINGS WHERE object_metadata_AWS_SETTINGS.id = 4 AND dest_id = 1874 AND fieldname = 'footerLinks' AND ownertype = 'localizedfield' AND ownername = 'localizedfield' and position = 'de' and `index` = 1 AND `type` = 'asset';
1.48 ms (0.92%)	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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_592tags', 'class_AWS_PRODtags', 'asset_4715tags', 'asset_4716tags', 'asset_4717tags', 'asset_4718tags');
1.45 ms (0.90%)	14	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/" "produkte"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'produkte';
1.37 ms (0.85%)	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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10006tags', 'class_AWS_PRODtags', 'asset_4354tags', 'asset_4355tags', 'asset_4356tags', 'asset_4357tags', 'asset_4358tags', 'asset_4359tags', 'asset_4360tags');
1.26 ms (0.78%)	1	SELECT object_localized_AWS_PROD_de.id as id, object_localized_AWS_PROD_de.type as `type` FROM object_localized_AWS_PROD_de WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`showEuro` = ?) AND object_localized_AWS_PROD_de.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_de.published = 1 ORDER BY `priority` ASC Parameters: [493 557 379 380 565 501 503 568 437 570 512 511 393 445 396 579 10002 10005 10008 9999 486 487 604 547 490 428 449 520 582 522 584 524 404 585 456 461 527 464 468 471 472 473 476 532 533 538 413 559 377 381 562 432 499 505 390 391 441 575 420 421 542 603 546 425 550 551 608 494 10001 519 450 401 451 452 462 406 465 408 591 534 536 376 10000 10004 10006 416 601 422 488 606 549 427 373 382 500 434 566 504 439 571 515 443 576 578 397 518 402 454 525 586 458 460 405 407 466 469 593 594 535 480 482 414 484 540 508 510 10007 9998 417 418 419 423 543 424 545 605 548 426 607 552 429 609 496 560 378 497 561 383 564 502 435 436 569 438 513 574 517 447 398 580 448 400 521 453 455 457 459 587 588 463 592 474 595 411 596 481 598 483 485 541 384 507 509 555 556 558 495 430 431 498 563 433 567 389 392 572 440 573 514 394 442 516 395 444 577 446 399 10003 602 544 489 491 492 553 554 581 583 523 403 526 467 590 470 409 410 475 477 478 479 597 412 537 539 599 415 600 1] View formatted query View runnable query Explain query SELECT object_localized_AWS_PROD_de.id as id, object_localized_AWS_PROD_de.type as `type` FROM object_localized_AWS_PROD_de WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND (`showEuro` = ?) AND object_localized_AWS_PROD_de.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_PROD_de.published = 1 ORDER BY `priority` ASC SELECT object_localized_AWS_PROD_de.id as id, object_localized_AWS_PROD_de.type as `type` FROM object_localized_AWS_PROD_de WHERE ((`id` IN (493, 557, 379, 380, 565, 501, 503, 568, 437, 570, 512, 511, 393, 445, 396, 579, 10002, 10005, 10008, 9999, 486, 487, 604, 547, 490, 428, 449, 520, 582, 522, 584, 524, 404, 585, 456, 461, 527, 464, 468, 471, 472, 473, 476, 532, 533, 538, 413, 559, 377, 381, 562, 432, 499, 505, 390, 391, 441, 575, 420, 421, 542, 603, 546, 425, 550, 551, 608, 494, 10001, 519, 450, 401, 451, 452, 462, 406, 465, 408, 591, 534, 536, 376, 10000, 10004, 10006, 416, 601, 422, 488, 606, 549, 427, 373, 382, 500, 434, 566, 504, 439, 571, 515, 443, 576, 578, 397, 518, 402, 454, 525, 586, 458, 460, 405, 407, 466, 469, 593, 594, 535, 480, 482, 414, 484, 540, 508, 510, 10007, 9998, 417, 418, 419, 423, 543, 424, 545, 605, 548, 426, 607, 552, 429, 609, 496, 560, 378, 497, 561, 383, 564, 502, 435, 436, 569, 438, 513, 574, 517, 447, 398, 580, 448, 400, 521, 453, 455, 457, 459, 587, 588, 463, 592, 474, 595, 411, 596, 481, 598, 483, 485, 541, 384, 507, 509, 555, 556, 558, 495, 430, 431, 498, 563, 433, 567, 389, 392, 572, 440, 573, 514, 394, 442, 516, 395, 444, 577, 446, 399, 10003, 602, 544, 489, 491, 492, 553, 554, 581, 583, 523, 403, 526, 467, 590, 470, 409, 410, 475, 477, 478, 479, 597, 412, 537, 539, 599, 415, 600)) AND (`showEuro` = 1) AND object_localized_AWS_PROD_de.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_de.published = 1 ORDER BY `priority` ASC ;
1.12 ms (0.69%)	10	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2001`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2001;
1.11 ms (0.69%)	10	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2001`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2001;
0.92 ms (0.57%)	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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_409tags', 'class_AWS_PRODtags', 'asset_3633tags', 'asset_3634tags', 'asset_3635tags', 'asset_3636tags', 'asset_3637tags', 'asset_3638tags', 'asset_3639tags', 'asset_3640tags', 'asset_3641tags', 'asset_3642tags', 'asset_3643tags');
0.76 ms (0.47%)	2	SELECT object_localized_AWS_CATEGORY_de.id as id, object_localized_AWS_CATEGORY_de.type as `type` FROM object_localized_AWS_CATEGORY_de WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_CATEGORY_de.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_de.published = 1 ORDER BY `orderPriority` ASC Parameters: [`258 263 259 262 269 265 266 264 268 261`] View formatted query View runnable query Explain query SELECT object_localized_AWS_CATEGORY_de.id as id, object_localized_AWS_CATEGORY_de.type as `type` FROM object_localized_AWS_CATEGORY_de WHERE ( ( `id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND object_localized_AWS_CATEGORY_de.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_CATEGORY_de.published = 1 ORDER BY `orderPriority` ASC SELECT object_localized_AWS_CATEGORY_de.id as id, object_localized_AWS_CATEGORY_de.type as `type` FROM object_localized_AWS_CATEGORY_de WHERE ((`id` IN (258, 263, 259, 262, 269, 265, 266, 264, 268, 261)) AND object_localized_AWS_CATEGORY_de.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_de.published = 1 ORDER BY `orderPriority` ASC ;
0.65 ms (0.40%)	1	SELECT object_localized_AWS_SER_de.id as id, object_localized_AWS_SER_de.type as `type` FROM object_localized_AWS_SER_de WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_de.type IN ('object','variant','folder')) AND object_localized_AWS_SER_de.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`] View formatted query View runnable query Explain query SELECT object_localized_AWS_SER_de.id as id, object_localized_AWS_SER_de.type as `type` FROM object_localized_AWS_SER_de WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND object_localized_AWS_SER_de.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_SER_de.published = 1 ORDER BY `orderPriority` ASC SELECT object_localized_AWS_SER_de.id as id, object_localized_AWS_SER_de.type as `type` FROM object_localized_AWS_SER_de WHERE ((`id` IN (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)) AND object_localized_AWS_SER_de.type IN ('object','variant','folder')) AND object_localized_AWS_SER_de.published = 1 ORDER BY `orderPriority` ASC ;
0.61 ms (0.37%)	6	SELECT name FROM classes WHERE id = ? Parameters: [`"AWS_PROD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AWS_PROD';
0.54 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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_425tags', 'class_AWS_PRODtags', 'asset_3758tags', 'asset_3759tags', 'asset_3760tags', 'asset_3761tags', 'asset_3762tags', 'asset_3763tags');
0.46 ms (0.28%)	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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_516tags', 'class_AWS_PRODtags', 'asset_4258tags', 'asset_4259tags', 'asset_4260tags', 'asset_4261tags', 'asset_4262tags', 'asset_4263tags', 'asset_4264tags', 'asset_4265tags', 'asset_4266tags', 'asset_4267tags', 'asset_4268tags', 'asset_4269tags');
0.43 ms (0.26%)	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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_593tags', 'class_AWS_PRODtags', 'asset_4722tags', 'asset_4723tags', 'asset_4724tags', 'asset_4725tags', 'asset_4726tags', 'asset_4727tags', 'asset_4728tags', 'asset_4729tags');
0.42 ms (0.26%)	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`] View formatted query View runnable query Explain query 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 SELECT * FROM website_settings WHERE name = 'productPriorityOrder' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
0.41 ms (0.25%)	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: [`"/de/produkte" "path" "auto_create" "/de/produkte" "path_query" "https://sunny.test.awebsys.cz/de/produkte" "entire_uri"`] View formatted query View runnable query Explain query 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 SELECT * FROM redirects WHERE ( (source = '/de/produkte' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/produkte' AND `type` = 'path_query') OR (source = 'https://sunny.test.awebsys.cz/de/produkte' AND `type` = 'entire_uri') ) 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;
0.37 ms (0.23%)	3	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
0.23 ms (0.14%)	2	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Filters/" "ProductFilter"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Filters/' AND `key` = BINARY 'ProductFilter';
0.20 ms (0.12%)	2	SELECT * FROM website_settings WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 3;
0.18 ms (0.11%)	1	SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = ? SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = 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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_609tags', 'class_AWS_PRODtags', 'asset_4839tags', 'asset_4840tags', 'asset_4841tags', 'asset_4842tags', 'asset_4843tags', 'asset_4844tags', 'asset_4845tags', 'asset_4846tags', 'asset_4847tags', 'asset_4848tags', 'asset_4849tags', 'asset_4850tags', 'asset_4851tags');
0.15 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: [`1770643957 "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"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1770643957 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_598tags', 'class_AWS_PRODtags', 'asset_4771tags', 'asset_4772tags', 'asset_4773tags', 'asset_4774tags', 'asset_4775tags', 'asset_4776tags', 'asset_4777tags', 'asset_4778tags', 'asset_4779tags', 'asset_4780tags');
0.15 ms (0.09%)	1	SELECT * FROM object_relations_EF_FD WHERE src_id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM object_relations_EF_FD WHERE src_id = ? SELECT * FROM object_relations_EF_FD WHERE src_id = 611;
0.14 ms (0.08%)	1	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
0.13 ms (0.08%)	1	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 15;
0.12 ms (0.07%)	1	SELECT id FROM assets WHERE id IN (1874,1879,1878,1877,1875,1876,1880,2078) Parameters: [] View formatted query View runnable query Explain query SELECT id FROM assets WHERE id IN ( 1874, 1879, 1878, 1877, 1875, 1876, 1880, 2078 ) SELECT id FROM assets WHERE id IN (1874,1879,1878,1877,1875,1876,1880,2078);
0.12 ms (0.07%)	1	SELECT * FROM object_url_slugs WHERE slug = '/de/produkte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/de/produkte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/produkte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.11 ms (0.07%)	1	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/produkte"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/produkte';
0.10 ms (0.06%)	1	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = '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.

Symfony Profiler

GET https://sunny.test.awebsys.cz/de/produkte

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping