Symfony Profiler

Query Metrics

1230 Database Queries

38 Different statements

174.50 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
59.83 ms (34.28%)	460	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: [`1775823497 "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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_03fae95109d52e1bb2ce82f8f1af9d87');
34.52 ms (19.78%)	236	SELECT * FROM object_relations_AWS_PROD WHERE src_id = ? Parameters: [`10002`] 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 = 10002;
22.20 ms (12.72%)	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: [`1775823497 "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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_258tags', 'class_AWS_CATEGORYtags', 'asset_2001tags', 'asset_24tags');
10.30 ms (5.90%)	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: [`1775823497 "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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
8.86 ms (5.08%)	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: [`1775823497 "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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
8.23 ms (4.72%)	1	SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`showEuro` = ?) AND object_localized_AWS_PROD_en.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_en.published = 1 ORDER BY `priority` ASC Parameters: [9999 10002 10005 10008 512 511 449 437 471 472 473 461 464 487 490 493 486 404 476 579 568 413 570 565 547 428 468 456 585 584 445 393 396 557 538 522 520 524 532 527 533 604 501 503 379 380 582 10001 441 462 465 451 519 401 608 450 408 452 420 550 432 559 542 425 546 562 575 494 551 390 536 534 505 391 376 499 381 377 406 603 591 421 10004 10006 510 508 10000 443 373 458 484 488 460 466 402 606 469 416 578 422 434 405 518 566 504 549 576 454 439 593 586 594 515 397 482 480 540 427 535 407 525 571 382 500 601 414 9998 10007 592 455 507 447 448 436 438 463 496 483 485 474 419 435 509 453 561 564 411 545 517 609 560 569 543 429 574 548 459 457 588 587 595 426 398 481 513 580 552 541 521 400 424 605 607 384 497 502 383 378 596 598 417 418 423 10003 577 446 440 444 475 470 495 489 491 492 467 479 403 478 599 477 555 431 433 409 410 412 572 567 516 563 544 430 581 395 389 399 394 553 554 558 556 539 523 537 526 514 392 590 573 498 442 602 583 597 600 415 1] View formatted query View runnable query Explain query SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND (`showEuro` = ?) AND object_localized_AWS_PROD_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_PROD_en.published = 1 ORDER BY `priority` ASC SELECT object_localized_AWS_PROD_en.id as id, object_localized_AWS_PROD_en.type as `type` FROM object_localized_AWS_PROD_en WHERE ((`id` IN (9999, 10002, 10005, 10008, 512, 511, 449, 437, 471, 472, 473, 461, 464, 487, 490, 493, 486, 404, 476, 579, 568, 413, 570, 565, 547, 428, 468, 456, 585, 584, 445, 393, 396, 557, 538, 522, 520, 524, 532, 527, 533, 604, 501, 503, 379, 380, 582, 10001, 441, 462, 465, 451, 519, 401, 608, 450, 408, 452, 420, 550, 432, 559, 542, 425, 546, 562, 575, 494, 551, 390, 536, 534, 505, 391, 376, 499, 381, 377, 406, 603, 591, 421, 10004, 10006, 510, 508, 10000, 443, 373, 458, 484, 488, 460, 466, 402, 606, 469, 416, 578, 422, 434, 405, 518, 566, 504, 549, 576, 454, 439, 593, 586, 594, 515, 397, 482, 480, 540, 427, 535, 407, 525, 571, 382, 500, 601, 414, 9998, 10007, 592, 455, 507, 447, 448, 436, 438, 463, 496, 483, 485, 474, 419, 435, 509, 453, 561, 564, 411, 545, 517, 609, 560, 569, 543, 429, 574, 548, 459, 457, 588, 587, 595, 426, 398, 481, 513, 580, 552, 541, 521, 400, 424, 605, 607, 384, 497, 502, 383, 378, 596, 598, 417, 418, 423, 10003, 577, 446, 440, 444, 475, 470, 495, 489, 491, 492, 467, 479, 403, 478, 599, 477, 555, 431, 433, 409, 410, 412, 572, 567, 516, 563, 544, 430, 581, 395, 389, 399, 394, 553, 554, 558, 556, 539, 523, 537, 526, 514, 392, 590, 573, 498, 442, 602, 583, 597, 600, 415)) AND (`showEuro` = 1) AND object_localized_AWS_PROD_en.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_en.published = 1 ORDER BY `priority` ASC ;
7.21 ms (4.13%)	61	SELECT * FROM object_relations_AWS_SER WHERE src_id = ? Parameters: [`9988`] 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 = 9988;
4.33 ms (2.48%)	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: [`1775823497 "object_10001\x01tags\x01" "class_AWS_PROD\x01tags\x01" "asset_3405\x01tags\x01" "asset_3406\x01tags\x01" "asset_3407\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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10001tags', 'class_AWS_PRODtags', 'asset_3405tags', 'asset_3406tags', 'asset_3407tags');
2.32 ms (1.33%)	1	SELECT DISTINCT series FROM object_localized_AWS_PROD_en WHERE ((`showEuro` = ?) AND object_localized_AWS_PROD_en.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_en.published = 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT DISTINCT series FROM object_localized_AWS_PROD_en WHERE ( (`showEuro` = ?) AND object_localized_AWS_PROD_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_PROD_en.published = 1 SELECT DISTINCT series FROM object_localized_AWS_PROD_en WHERE ((`showEuro` = 1) AND object_localized_AWS_PROD_en.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_en.published = 1;
1.72 ms (0.99%)	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.47 ms (0.84%)	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" "en" 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 = 'en' and `index` = 1 AND `type` = 'asset';
1.40 ms (0.80%)	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: [`1775823497 "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 > 1775823497 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.37 ms (0.78%)	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: [`1775823497 "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"`] 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 > 1775823497 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10005tags', 'class_AWS_PRODtags', 'asset_4344tags', 'asset_4345tags', 'asset_4346tags', 'asset_4347tags', 'asset_4348tags', 'asset_4349tags', 'asset_4350tags');
1.34 ms (0.77%)	13	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "products"`] 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 '/en/' AND `key` = BINARY 'products';
1.14 ms (0.65%)	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;
1.07 ms (0.61%)	1	SELECT DISTINCT categories FROM object_localized_AWS_SER_en WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_en.type IN ('object','variant','folder')) AND object_localized_AWS_SER_en.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_en WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND object_localized_AWS_SER_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_SER_en.published = 1 SELECT DISTINCT categories FROM object_localized_AWS_SER_en 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_en.type IN ('object','variant','folder')) AND object_localized_AWS_SER_en.published = 1;
0.86 ms (0.49%)	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: [`1775823497 "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 > 1775823497 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.73 ms (0.42%)	2	SELECT object_localized_AWS_CATEGORY_en.id as id, object_localized_AWS_CATEGORY_en.type as `type` FROM object_localized_AWS_CATEGORY_en WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_CATEGORY_en.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_en.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_en.id as id, object_localized_AWS_CATEGORY_en.type as `type` FROM object_localized_AWS_CATEGORY_en WHERE ( ( `id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND object_localized_AWS_CATEGORY_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_CATEGORY_en.published = 1 ORDER BY `orderPriority` ASC SELECT object_localized_AWS_CATEGORY_en.id as id, object_localized_AWS_CATEGORY_en.type as `type` FROM object_localized_AWS_CATEGORY_en WHERE ((`id` IN (258, 263, 259, 262, 269, 265, 266, 264, 268, 261)) AND object_localized_AWS_CATEGORY_en.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_en.published = 1 ORDER BY `orderPriority` ASC ;
0.62 ms (0.36%)	1	SELECT object_localized_AWS_SER_en.id as id, object_localized_AWS_SER_en.type as `type` FROM object_localized_AWS_SER_en WHERE ((`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_AWS_SER_en.type IN ('object','variant','folder')) AND object_localized_AWS_SER_en.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_en.id as id, object_localized_AWS_SER_en.type as `type` FROM object_localized_AWS_SER_en WHERE ( ( `id` IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND object_localized_AWS_SER_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AWS_SER_en.published = 1 ORDER BY `orderPriority` ASC SELECT object_localized_AWS_SER_en.id as id, object_localized_AWS_SER_en.type as `type` FROM object_localized_AWS_SER_en 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_en.type IN ('object','variant','folder')) AND object_localized_AWS_SER_en.published = 1 ORDER BY `orderPriority` ASC ;
0.60 ms (0.34%)	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.51 ms (0.29%)	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: [`1775823497 "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 > 1775823497 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.49 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`] 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.45 ms (0.26%)	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: [`"/en/products" "path" "auto_create" "/en/products" "path_query" "https://sunny.test.awebsys.cz/en/products" "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 = '/en/products' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/products' AND `type` = 'path_query') OR (source = 'https://sunny.test.awebsys.cz/en/products' 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.45 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: [`1775823497 "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 > 1775823497 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.40 ms (0.23%)	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: [`1775823497 "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 > 1775823497 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.37 ms (0.21%)	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.13%)	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.22 ms (0.13%)	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.16 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: [`1775823497 "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 > 1775823497 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 * 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.14 ms (0.08%)	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: [`1775823497 "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 > 1775823497 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.13 ms (0.08%)	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.13 ms (0.08%)	1	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 Parameters: [`2`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 SELECT documents.id, documents.type FROM documents WHERE (parentId = 2) AND published = 1;
0.12 ms (0.07%)	1	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 3;
0.11 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.11 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';
0.11 ms (0.06%)	1	SELECT * FROM object_url_slugs WHERE slug = '/en/products' 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 = '/en/products' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/products' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.11 ms (0.06%)	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;;

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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAccountController%253A%253AloginModalAction

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping