Symfony Profiler

Query Metrics

26 Database Queries

19 Different statements

62.68 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
19.79 ms (31.58%)	1	SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_hotels s0_ WHERE s0_.code IN (?) AND s0_.lang = ? ORDER BY s0_.name ASC Parameters: [ 0 => [ 0 => 63, 1 => 157, 2 => 701, 3 => 702, 4 => 956, 5 => 1024, 6 => 1025, 7 => 1475, 8 => 9547, 9 => 11722, 10 => 11955, 11 => 177, 12 => 179, 13 => 958, 14 => 1026, 15 => 1027, 16 => 1028, 17 => 1364, 18 => 1564, 19 => 1681, 20 => 1733, 21 => 2054, 22 => 10351, 23 => 11706, 24 => 12413, 25 => 12594, 26 => 12635, 27 => 9054, 28 => 9244, 29 => 158, 30 => 204, 31 => 463, 32 => 1072, 33 => 2206, 34 => 2822, 35 => 10711, 36 => 10731, 37 => 10784, 38 => 10785, 39 => 12226, 40 => 12397, 41 => 186, 42 => 187, 43 => 194, 44 => 228, 45 => 392, 46 => 395, 47 => 396, 48 => 399, 49 => 961, 50 => 962, 51 => 964, 52 => 965, 53 => 989, 54 => 1041, 55 => 1336, 56 => 1484, 57 => 1486, 58 => 1487, 59 => 1488, 60 => 1633, 61 => 1687, 62 => 2081, 63 => 2113, 64 => 3209, 65 => 8599, 66 => 9282, 67 => 10252, 68 => 10386, 69 => 10460, 70 => 11246, 71 => 12161, 72 => 12628, 73 => 10638, 74 => 82, 75 => 2731, 76 => 746, 77 => 859, 78 => 948, 79 => 1060, 80 => 2729, 81 => 2846, 82 => 3366, 83 => 8565, 84 => 10062, 85 => 11680, 86 => 2734, 87 => 9885, 88 => 11099, 89 => 6755, 90 => 10774, 91 => 12252, 92 => 1059, 93 => 1330, 94 => 10898, 95 => 132, 96 => 648, 97 => 821, 98 => 880, 99 => 885, 100 => 983, 101 => 1755, 102 => 3072, 103 => 9905, 104 => 10060, 105 => 10464, 106 => 10693, 107 => 10868, 108 => 10878, 109 => 11251, 110 => 11823, 111 => 11994, 112 => 12074, 113 => 1360, 114 => 1706, 115 => 2075, 116 => 2077, 117 => 9373, 118 => 9675, 119 => 9843, 120 => 10129, 121 => 10454, 122 => 10684, 123 => 10859, 124 => 11066, 125 => 11085, 126 => 11086, 127 => 11101, 128 => 11672, 129 => 11734, 130 => 11811, 131 => 12013, 132 => 12049, 133 => 12383, 134 => 12660, 135 => 12661, 136 => 17, 137 => 18, 138 => 1677, 139 => 10390, 140 => 11699, 141 => 11895, 142 => 21, 143 => 423, 144 => 521, 145 => 884, 146 => 1011, 147 => 1476, 148 => 1592, 149 => 9998, 150 => 10120, 151 => 10944, 152 => 11321, 153 => 12058, 154 => 12270, 155 => 12372, 156 => 12412, 157 => 12696, 158 => 112, 159 => 595, 160 => 596, 161 => 597, 162 => 683, 163 => 720, 164 => 813, 165 => 984, 166 => 1013, 167 => 1014, 168 => 1399, 169 => 1419, 170 => 1737, 171 => 1853, 172 => 1998, 173 => 2003, 174 => 2026, 175 => 2027, 176 => 2052, 177 => 2057, 178 => 3073, 179 => 8691, 180 => 9048, 181 => 9512, 182 => 11294, 183 => 11304, 184 => 11758, 185 => 12009, 186 => 12075, 187 => 12108, 188 => 12149, 189 => 12314, 190 => 12456, 191 => 12524, 192 => 12662, 193 => 12697, 194 => 215, 195 => 534, 196 => 551, 197 => 11243, 198 => 11999, 199 => 518, 200 => 519, 201 => 594, 202 => 1188, 203 => 2006, 204 => 9355, 205 => 10999, 206 => 11333, 207 => 11334, 208 => 11975, 209 => 12045, 210 => 67, 211 => 68, 212 => 70, 213 => 71, 214 => 72, 215 => 74, 216 => 78, 217 => 81, 218 => 83, 219 => 212, 220 => 222, 221 => 348, 222 => 349, 223 => 440, 224 => 509, 225 => 598, 226 => 604, 227 => 635, 228 => 728, 229 => 729, 230 => 779, 231 => 814, 232 => 922, 233 => 934, 234 => 982, 235 => 997, 236 => 999, 237 => 1009, 238 => 1366, 239 => 1367, 240 => 1597, 241 => 1613, 242 => 1707, 243 => 1774, 244 => 1817, 245 => 1994, 246 => 2106, 247 => 3061, 248 => 9269, 249 => 10059, 250 => 10443, 251 => 10860, 252 => 10914, 253 => 11056, 254 => 11062, 255 => 11087, 256 => 12243, 257 => 12296, 258 => 12374, 259 => 12382, 260 => 12398, 261 => 12417, 262 => 12418, 263 => 12419, 264 => 12420, 265 => 12421, 266 => 12422, 267 => 12475, 268 => 12476, 269 => 12477, 270 => 12478, 271 => 12479, 272 => 12480, 273 => 12482, 274 => 12483, 275 => 12484, 276 => 12658, 277 => 12659, 278 => 1100, 279 => 1102, 280 => 3251, 281 => 9277, 282 => 10542, 283 => 10662, 284 => 11971, 285 => 12042, 286 => 12223, 287 => 12481, 288 => 183, 289 => 193, 290 => 969, 291 => 1075, 292 => 1076, 293 => 3193, 294 => 3259, 295 => 11813, 296 => 28, 297 => 173, 298 => 244, 299 => 1722, 300 => 2531, 301 => 8613, 302 => 8821, 303 => 11866, 304 => 12345, 305 => 12367, 306 => 12402, 307 => 98, 308 => 115, 309 => 599, 310 => 601, 311 => 1357, 312 => 1560, 313 => 1918, 314 => 1920, 315 => 1968, 316 => 2508, 317 => 2723, 318 => 2766, 319 => 2921, 320 => 3034, 321 => 3071, 322 => 3157, 323 => 8566, 324 => 8567, 325 => 9002, 326 => 10445, 327 => 10604, 328 => 10672, 329 => 10992, 330 => 11032, 331 => 11041, 332 => 11927, 333 => 11948, 334 => 12047, 335 => 12486, 336 => 59, 337 => 75, 338 => 86, 339 => 88, 340 => 200, 341 => 281, 342 => 994, 343 => 1044, 344 => 1106, 345 => 1128, 346 => 1422, 347 => 1779, 348 => 3040, 349 => 7538, 350 => 8783, 351 => 9382, 352 => 10103, 353 => 11038, 354 => 11183, 355 => 12448, 356 => 12449, 357 => 102, 358 => 113, 359 => 199, 360 => 201, 361 => 993, 362 => 1078, 363 => 1117, 364 => 2056, 365 => 195, 366 => 659, 367 => 2426, 368 => 10356, 369 => 1858, 370 => 235, 371 => 372, 372 => 545, 373 => 8586, 374 => 8693, 375 => 11867, 376 => 12010, 377 => 12011, 378 => 12386, 379 => 12389, 380 => 12454, 381 => 12607, 382 => 90, 383 => 127, 384 => 268, 385 => 280, 386 => 330, 387 => 333, 388 => 484, 389 => 498, 390 => 524, 391 => 526, 392 => 527, 393 => 528, 394 => 529, 395 => 538, 396 => 663, 397 => 664, 398 => 733, 399 => 765, 400 => 802, 401 => 834, 402 => 970, 403 => 1083, 404 => 1175, 405 => 1342, 406 => 1397, 407 => 1414, 408 => 1511, 409 => 1678, 410 => 1698, 411 => 1710, 412 => 1842, 413 => 1930, 414 => 2499, 415 => 2710, 416 => 2726, 417 => 2735, 418 => 2736, 419 => 2805, 420 => 2967, 421 => 7739, 422 => 8611, 423 => 9914, 424 => 9917, 425 => 9950, 426 => 10703, 427 => 10857, 428 => 10959, 429 => 11188, 430 => 11385, 431 => 11700, 432 => 11723, 433 => 11727, 434 => 11781, 435 => 12206, 436 => 12258, 437 => 12530, 438 => 12557, 439 => 12664, 440 => 379, 441 => 409, 442 => 569, 443 => 951, 444 => 1303, 445 => 1374, 446 => 1605, 447 => 1619, 448 => 1668, 449 => 8882, 450 => 11596, 451 => 12247, 452 => 26, 453 => 27, 454 => 155, 455 => 337, 456 => 389, 457 => 400, 458 => 517, 459 => 612, 460 => 811, 461 => 1498, 462 => 8677, 463 => 10441, 464 => 1109, 465 => 1110, 466 => 1112, 467 => 1114, 468 => 1434, 469 => 1435, 470 => 1610, 471 => 1624, 472 => 1626, 473 => 1642, 474 => 1783, 475 => 1796, 476 => 7725, 477 => 8568, 478 => 8787, 479 => 9427, 480 => 9502, 481 => 10113, 482 => 10249, 483 => 10418, 484 => 10538, 485 => 10835, 486 => 10888, 487 => 11061, 488 => 11305, 489 => 11673, 490 => 11737, 491 => 11861, 492 => 11898, 493 => 12275, 494 => 12370, 495 => 12447, 496 => 3272, 497 => 9511, 498 => 10657, 499 => 11022, 500 => 11264, 501 => 11681, 502 => 11713, 503 => 11718, 504 => 11751, 505 => 11899, 506 => 11935, 507 => 11954, 508 => 12283, 509 => 12452, 510 => 12579, 511 => 12689, 512 => 47, 513 => 48, 514 => 50, 515 => 254, 516 => 256, 517 => 264, 518 => 316, 519 => 341, 520 => 398, 521 => 407, 522 => 439, 523 => 512, 524 => 514, 525 => 582, 526 => 644, 527 => 685, 528 => 760, 529 => 891, 530 => 915, 531 => 916, 532 => 955, 533 => 985, 534 => 2173, 535 => 9289, 536 => 9290, 537 => 9346, 538 => 9840, 539 => 9841, 540 => 10101, 541 => 10562, 542 => 10767, 543 => 11745, 544 => 12219, 545 => 3, 546 => 6, 547 => 130, 548 => 163, 549 => 216, 550 => 273, 551 => 275, 552 => 411, 553 => 483, 554 => 577, 555 => 603, 556 => 666, 557 => 766, 558 => 775, 559 => 804, 560 => 822, 561 => 836, 562 => 871, 563 => 872, 564 => 873, 565 => 896, 566 => 897, 567 => 908, 568 => 940, 569 => 942, 570 => 974, 571 => 980, 572 => 1001, 573 => 1003, 574 => 1004, 575 => 1006, 576 => 1104, 577 => 1189, 578 => 1350, 579 => 1351, 580 => 1352, 581 => 1566, 582 => 1595, 583 => 1607, 584 => 1616, 585 => 1692, 586 => 1695, 587 => 1703, 588 => 1708, 589 => 1716, 590 => 1900, 591 => 1928, 592 => 2064, 593 => 2082, 594 => 2093, 595 => 2098, 596 => 2114, 597 => 2120, 598 => 2172, 599 => 2185, 600 => 2371, 601 => 2565, 602 => 2718, 603 => 2719, 604 => 2739, 605 => 2823, 606 => 3012, 607 => 3062, 608 => 3088, 609 => 7700, 610 => 7742, 611 => 8791, 612 => 9267, 613 => 9343, 614 => 9422, 615 => 9557, 616 => 9558, 617 => 9575, 618 => 9576, 619 => 10314, 620 => 10453, 621 => 10647, 622 => 10649, 623 => 10652, 624 => 10659, 625 => 10663, 626 => 10698, 627 => 10837, 628 => 10895, 629 => 10904, 630 => 10971, 631 => 11040, 632 => 11063, 633 => 11116, 634 => 11202, 635 => 11254, 636 => 11344, 637 => 11366, 638 => 11368, 639 => 11369, 640 => 11582, 641 => 11705, 642 => 11721, 643 => 11749, 644 => 11901, 645 => 11910, 646 => 12004, 647 => 12041, 648 => 12091, 649 => 12157, 650 => 12175, 651 => 12176, 652 => 12183, 653 => 12192, 654 => 12201, 655 => 12205, 656 => 12213, 657 => 12214, 658 => 12230, 659 => 12248, 660 => 12256, 661 => 12285, 662 => 12302, 663 => 12306, 664 => 12344, 665 => 12615, 666 => 12616, 667 => 12622, 668 => 12624, 669 => 12625, 670 => 12626, 671 => 12627, 672 => 12648, 673 => 217, 674 => 257, 675 => 318, 676 => 562, 677 => 584, 678 => 770, 679 => 801, 680 => 864, 681 => 1559, 682 => 1617, 683 => 2122, 684 => 2165, 685 => 2372, 686 => 2866, 687 => 8587, 688 => 10439, 689 => 11847, 690 => 11904, 691 => 11905, 692 => 12173, 693 => 12174, 694 => 12321, 695 => 12438, 696 => 2107, 697 => 8608, 698 => 9270, 699 => 9614, 700 => 1151, 701 => 1718, 702 => 9827, 703 => 10567, 704 => 10996, 705 => 1714, 706 => 11097, 707 => 84, 708 => 232, 709 => 323, 710 => 972, 711 => 1218, 712 => 1370, 713 => 3146, 714 => 9653, 715 => 10355, 716 => 11033, 717 => 11247, 718 => 11870, 719 => 12426, 720 => 12458, 721 => 32, 722 => 95, 723 => 309, 724 => 776, 725 => 1348, 726 => 1562, 727 => 1792, 728 => 2515, 729 => 10018, 730 => 10713, 731 => 10890, 732 => 11698, 733 => 114, 734 => 151, 735 => 414, 736 => 587, 737 => 645, 738 => 863, 739 => 866, 740 => 935, 741 => 977, 742 => 1016, 743 => 1029, 744 => 1073, 745 => 1116, 746 => 1127, 747 => 1163, 748 => 1164, 749 => 1354, 750 => 1355, 751 => 1596, 752 => 1639, 753 => 1702, 754 => 1786, 755 => 1901, 756 => 2085, 757 => 2089, 758 => 2096, 759 => 2153, 760 => 2513, 761 => 2706, 762 => 2722, 763 => 2725, 764 => 3016, 765 => 3039, 766 => 3233, 767 => 8569, 768 => 8612, 769 => 8742, 770 => 9263, 771 => 9411, 772 => 9488, 773 => 9544, 774 => 10032, 775 => 10078, 776 => 10398, 777 => 10686, 778 => 10798, 779 => 10938, 780 => 11006, 781 => 11019, 782 => 11023, 783 => 11027, 784 => 11037, 785 => 11045, 786 => 11048, 787 => 11216, 788 => 11266, 789 => 11738, 790 => 11739, 791 => 11759, 792 => 11783, 793 => 11784, 794 => 11808, 795 => 11882, 796 => 11903, 797 => 11919, 798 => 11949, 799 => 11957, 800 => 11974, 801 => 12022, 802 => 12037, 803 => 12084, 804 => 12193, 805 => 12235, 806 => 12292, 807 => 12310, 808 => 12416, 809 => 12425, 810 => 12444, 811 => 12445, 812 => 290, 813 => 291, 814 => 2076, 815 => 2512, 816 => 2724, 817 => 651, 818 => 819, 819 => 10889, 820 => 10899, 821 => 11415, 822 => 11416, 823 => 11417, 824 => 2756, 825 => 9383, 826 => 11959, 827 => 69, 828 => 205, 829 => 209, 830 => 210, 831 => 375, 832 => 477, 833 => 1090, 834 => 1492, 835 => 1493, 836 => 1494, 837 => 1682, 838 => 2588, 839 => 8895, 840 => 9397, 841 => 9641, 842 => 11036, 843 => 11261, 844 => 11376, 845 => 12327, 846 => 91, 847 => 144, 848 => 147, 849 => 1160, 850 => 1227, 851 => 1228, 852 => 1302, 853 => 3194, 854 => 8571, 855 => 8680, 856 => 8681, 857 => 8745, 858 => 9652, 859 => 9729, 860 => 10759, 861 => 11354, 862 => 12220, 863 => 12231, 864 => 842, 865 => 929, 866 => 1120, 867 => 1121, 868 => 1136, 869 => 1144, 870 => 1146, 871 => 1148, 872 => 1278, 873 => 2095, 874 => 3170, 875 => 3171, 876 => 3282, 877 => 9605, 878 => 11067, 879 => 11331, 880 => 12371, 881 => 12460, 882 => 249, 883 => 500, 884 => 557, 885 => 656, 886 => 1022, 887 => 1166, 888 => 1736, 889 => 2507, 890 => 10702, 891 => 12237, 892 => 12242, 893 => 11932, 894 => 11986, 895 => 12060, 896 => 12082, 897 => 12549, 898 => 55, 899 => 9342, 900 => 9451, 901 => 12276, 902 => 491, 903 => 1012, 904 => 1063, 905 => 1599, 906 => 10318, 907 => 11799, 908 => 12303, 909 => 12304, 910 => 10683, 911 => 12307, 912 => 16, 913 => 633, 914 => 1398, 915 => 11409, 916 => 12295, 917 => 12356, 918 => 104, 919 => 12358, 920 => 2063, 921 => 888, 922 => 1067, 923 => 1489, 924 => 1490, 925 => 1688, 926 => 2494, 927 => 8743, 928 => 12264, 929 => 12286, 930 => 12491, 931 => 12506, 932 => 1095, 933 => 1184, 934 => 10988, 935 => 311, 936 => 451, 937 => 475, 938 => 768, 939 => 769, 940 => 933, 941 => 1715, 942 => 9555, 943 => 12, 944 => 3197, 945 => 8998, 946 => 9949, 947 => 12012, 948 => 9662, 949 => 11605, 950 => 12218, 951 => 9663, 952 => 12457, 953 => 12504, 954 => 11353, 955 => 1363, 956 => 10708, 957 => 184, 958 => 564, 959 => 1608, 960 => 3013, 961 => 11761, 962 => 12365, 963 => 9677, 964 => 40, 965 => 12487, 966 => 12488, 967 => 12489, 968 => 12495, 969 => 12496, 970 => 12525, 971 => 12535, 972 => 11871, 973 => 12629, 974 => 12656, 975 => 1002, 976 => 9384, 977 => 9387, 978 => 272, 979 => 340, 980 => 365, 981 => 369, 982 => 973, 983 => 1618, 984 => 1615, 985 => 2090, 986 => 2091, 987 => 8588, 988 => 8589, 989 => 8605, 990 => 12323, 991 => 314, 992 => 405, 993 => 687, 994 => 868, 995 => 913, 996 => 469, 997 => 11260, 998 => 11299, 999 => 1589, 1000 => 2539, 1001 => 12542, 1002 => 12329, 1003 => 12430, 1004 => 9569, 1005 => 10144, 1006 => 12312, 1007 => 12436, 1008 => 11498, 1009 => 2721, 1010 => 11244, 1011 => 11750, 1012 => 1987, 1013 => 1989, 1014 => 2743, 1015 => 8921, 1016 => 9248, 1017 => 9659, 1018 => 12225, 1019 => 12392 ], 1 => fr ] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_hotels s0_ WHERE s0_.code IN (?) AND s0_.lang = ? ORDER BY s0_.name ASC SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_hotels s0_ WHERE s0_.code IN ('63', '157', '701', '702', '956', '1024', '1025', '1475', '9547', '11722', '11955', '177', '179', '958', '1026', '1027', '1028', '1364', '1564', '1681', '1733', '2054', '10351', '11706', '12413', '12594', '12635', '9054', '9244', '158', '204', '463', '1072', '2206', '2822', '10711', '10731', '10784', '10785', '12226', '12397', '186', '187', '194', '228', '392', '395', '396', '399', '961', '962', '964', '965', '989', '1041', '1336', '1484', '1486', '1487', '1488', '1633', '1687', '2081', '2113', '3209', '8599', '9282', '10252', '10386', '10460', '11246', '12161', '12628', '10638', '82', '2731', '746', '859', '948', '1060', '2729', '2846', '3366', '8565', '10062', '11680', '2734', '9885', '11099', '6755', '10774', '12252', '1059', '1330', '10898', '132', '648', '821', '880', '885', '983', '1755', '3072', '9905', '10060', '10464', '10693', '10868', '10878', '11251', '11823', '11994', '12074', '1360', '1706', '2075', '2077', '9373', '9675', '9843', '10129', '10454', '10684', '10859', '11066', '11085', '11086', '11101', '11672', '11734', '11811', '12013', '12049', '12383', '12660', '12661', '17', '18', '1677', '10390', '11699', '11895', '21', '423', '521', '884', '1011', '1476', '1592', '9998', '10120', '10944', '11321', '12058', '12270', '12372', '12412', '12696', '112', '595', '596', '597', '683', '720', '813', '984', '1013', '1014', '1399', '1419', '1737', '1853', '1998', '2003', '2026', '2027', '2052', '2057', '3073', '8691', '9048', '9512', '11294', '11304', '11758', '12009', '12075', '12108', '12149', '12314', '12456', '12524', '12662', '12697', '215', '534', '551', '11243', '11999', '518', '519', '594', '1188', '2006', '9355', '10999', '11333', '11334', '11975', '12045', '67', '68', '70', '71', '72', '74', '78', '81', '83', '212', '222', '348', '349', '440', '509', '598', '604', '635', '728', '729', '779', '814', '922', '934', '982', '997', '999', '1009', '1366', '1367', '1597', '1613', '1707', '1774', '1817', '1994', '2106', '3061', '9269', '10059', '10443', '10860', '10914', '11056', '11062', '11087', '12243', '12296', '12374', '12382', '12398', '12417', '12418', '12419', '12420', '12421', '12422', '12475', '12476', '12477', '12478', '12479', '12480', '12482', '12483', '12484', '12658', '12659', '1100', '1102', '3251', '9277', '10542', '10662', '11971', '12042', '12223', '12481', '183', '193', '969', '1075', '1076', '3193', '3259', '11813', '28', '173', '244', '1722', '2531', '8613', '8821', '11866', '12345', '12367', '12402', '98', '115', '599', '601', '1357', '1560', '1918', '1920', '1968', '2508', '2723', '2766', '2921', '3034', '3071', '3157', '8566', '8567', '9002', '10445', '10604', '10672', '10992', '11032', '11041', '11927', '11948', '12047', '12486', '59', '75', '86', '88', '200', '281', '994', '1044', '1106', '1128', '1422', '1779', '3040', '7538', '8783', '9382', '10103', '11038', '11183', '12448', '12449', '102', '113', '199', '201', '993', '1078', '1117', '2056', '195', '659', '2426', '10356', '1858', '235', '372', '545', '8586', '8693', '11867', '12010', '12011', '12386', '12389', '12454', '12607', '90', '127', '268', '280', '330', '333', '484', '498', '524', '526', '527', '528', '529', '538', '663', '664', '733', '765', '802', '834', '970', '1083', '1175', '1342', '1397', '1414', '1511', '1678', '1698', '1710', '1842', '1930', '2499', '2710', '2726', '2735', '2736', '2805', '2967', '7739', '8611', '9914', '9917', '9950', '10703', '10857', '10959', '11188', '11385', '11700', '11723', '11727', '11781', '12206', '12258', '12530', '12557', '12664', '379', '409', '569', '951', '1303', '1374', '1605', '1619', '1668', '8882', '11596', '12247', '26', '27', '155', '337', '389', '400', '517', '612', '811', '1498', '8677', '10441', '1109', '1110', '1112', '1114', '1434', '1435', '1610', '1624', '1626', '1642', '1783', '1796', '7725', '8568', '8787', '9427', '9502', '10113', '10249', '10418', '10538', '10835', '10888', '11061', '11305', '11673', '11737', '11861', '11898', '12275', '12370', '12447', '3272', '9511', '10657', '11022', '11264', '11681', '11713', '11718', '11751', '11899', '11935', '11954', '12283', '12452', '12579', '12689', '47', '48', '50', '254', '256', '264', '316', '341', '398', '407', '439', '512', '514', '582', '644', '685', '760', '891', '915', '916', '955', '985', '2173', '9289', '9290', '9346', '9840', '9841', '10101', '10562', '10767', '11745', '12219', '3', '6', '130', '163', '216', '273', '275', '411', '483', '577', '603', '666', '766', '775', '804', '822', '836', '871', '872', '873', '896', '897', '908', '940', '942', '974', '980', '1001', '1003', '1004', '1006', '1104', '1189', '1350', '1351', '1352', '1566', '1595', '1607', '1616', '1692', '1695', '1703', '1708', '1716', '1900', '1928', '2064', '2082', '2093', '2098', '2114', '2120', '2172', '2185', '2371', '2565', '2718', '2719', '2739', '2823', '3012', '3062', '3088', '7700', '7742', '8791', '9267', '9343', '9422', '9557', '9558', '9575', '9576', '10314', '10453', '10647', '10649', '10652', '10659', '10663', '10698', '10837', '10895', '10904', '10971', '11040', '11063', '11116', '11202', '11254', '11344', '11366', '11368', '11369', '11582', '11705', '11721', '11749', '11901', '11910', '12004', '12041', '12091', '12157', '12175', '12176', '12183', '12192', '12201', '12205', '12213', '12214', '12230', '12248', '12256', '12285', '12302', '12306', '12344', '12615', '12616', '12622', '12624', '12625', '12626', '12627', '12648', '217', '257', '318', '562', '584', '770', '801', '864', '1559', '1617', '2122', '2165', '2372', '2866', '8587', '10439', '11847', '11904', '11905', '12173', '12174', '12321', '12438', '2107', '8608', '9270', '9614', '1151', '1718', '9827', '10567', '10996', '1714', '11097', '84', '232', '323', '972', '1218', '1370', '3146', '9653', '10355', '11033', '11247', '11870', '12426', '12458', '32', '95', '309', '776', '1348', '1562', '1792', '2515', '10018', '10713', '10890', '11698', '114', '151', '414', '587', '645', '863', '866', '935', '977', '1016', '1029', '1073', '1116', '1127', '1163', '1164', '1354', '1355', '1596', '1639', '1702', '1786', '1901', '2085', '2089', '2096', '2153', '2513', '2706', '2722', '2725', '3016', '3039', '3233', '8569', '8612', '8742', '9263', '9411', '9488', '9544', '10032', '10078', '10398', '10686', '10798', '10938', '11006', '11019', '11023', '11027', '11037', '11045', '11048', '11216', '11266', '11738', '11739', '11759', '11783', '11784', '11808', '11882', '11903', '11919', '11949', '11957', '11974', '12022', '12037', '12084', '12193', '12235', '12292', '12310', '12416', '12425', '12444', '12445', '290', '291', '2076', '2512', '2724', '651', '819', '10889', '10899', '11415', '11416', '11417', '2756', '9383', '11959', '69', '205', '209', '210', '375', '477', '1090', '1492', '1493', '1494', '1682', '2588', '8895', '9397', '9641', '11036', '11261', '11376', '12327', '91', '144', '147', '1160', '1227', '1228', '1302', '3194', '8571', '8680', '8681', '8745', '9652', '9729', '10759', '11354', '12220', '12231', '842', '929', '1120', '1121', '1136', '1144', '1146', '1148', '1278', '2095', '3170', '3171', '3282', '9605', '11067', '11331', '12371', '12460', '249', '500', '557', '656', '1022', '1166', '1736', '2507', '10702', '12237', '12242', '11932', '11986', '12060', '12082', '12549', '55', '9342', '9451', '12276', '491', '1012', '1063', '1599', '10318', '11799', '12303', '12304', '10683', '12307', '16', '633', '1398', '11409', '12295', '12356', '104', '12358', '2063', '888', '1067', '1489', '1490', '1688', '2494', '8743', '12264', '12286', '12491', '12506', '1095', '1184', '10988', '311', '451', '475', '768', '769', '933', '1715', '9555', '12', '3197', '8998', '9949', '12012', '9662', '11605', '12218', '9663', '12457', '12504', '11353', '1363', '10708', '184', '564', '1608', '3013', '11761', '12365', '9677', '40', '12487', '12488', '12489', '12495', '12496', '12525', '12535', '11871', '12629', '12656', '1002', '9384', '9387', '272', '340', '365', '369', '973', '1618', '1615', '2090', '2091', '8588', '8589', '8605', '12323', '314', '405', '687', '868', '913', '469', '11260', '11299', '1589', '2539', '12542', '12329', '12430', '9569', '10144', '12312', '12436', '11498', '2721', '11244', '11750', '1987', '1989', '2743', '8921', '9248', '9659', '12225', '12392') AND s0_.lang = 'fr' ORDER BY s0_.name ASC;
7.98 ms (12.73%)	1	SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? ORDER BY s0_.name ASC Parameters: [ 0 => fr, 1 => [ 0 => 174, 1 => 27, 2 => 29, 3 => 25, 4 => 26, 5 => 182, 6 => 188, 7 => 30, 8 => 103, 9 => 57, 10 => 2577, 11 => 346578, 12 => 346767, 13 => 346792, 14 => 60, 15 => 115, 16 => 116, 17 => 162, 18 => 164, 19 => 170, 20 => 186, 21 => 1685, 22 => 4135, 23 => 347581, 24 => 347928, 25 => 349344, 26 => 349355, 27 => 349389, 28 => 350814, 29 => 11, 30 => 55, 31 => 16, 32 => 21, 33 => 22, 34 => 64, 35 => 70, 36 => 2974, 37 => 568546, 38 => 569962, 39 => 3, 40 => 4, 41 => 6, 42 => 15, 43 => 37, 44 => 47, 45 => 52, 46 => 53, 47 => 87, 48 => 92, 49 => 2217, 50 => 581510, 51 => 3049115, 52 => 3049121, 53 => 3049151, 54 => 76, 55 => 257, 56 => 56, 57 => 58, 58 => 129, 59 => 131, 60 => 134, 61 => 152, 62 => 761711, 63 => 771584, 64 => 772385, 65 => 773937, 66 => 789628, 67 => 31, 68 => 32, 69 => 43, 70 => 51, 71 => 71, 72 => 79, 73 => 81, 74 => 84, 75 => 85, 76 => 148, 77 => 154, 78 => 189, 79 => 190, 80 => 191, 81 => 192, 82 => 199, 83 => 262, 84 => 1578, 85 => 1860, 86 => 1976, 87 => 3006, 88 => 3797, 89 => 2741642, 90 => 2743497, 91 => 2750814, 92 => 3045371, 93 => 3049149, 94 => 3049153, 95 => 61, 96 => 68, 97 => 108, 98 => 110, 99 => 114, 100 => 828182, 101 => 835346, 102 => 852765, 103 => 875285, 104 => 878903, 105 => 893296, 106 => 66, 107 => 974878, 108 => 34, 109 => 28, 110 => 83, 111 => 33, 112 => 104, 113 => 45, 114 => 118, 115 => 180, 116 => 1328096, 117 => 18, 118 => 78, 119 => 1843, 120 => 4244, 121 => 1341400, 122 => 1341882, 123 => 23, 124 => 187, 125 => 265, 126 => 38, 127 => 1, 128 => 2, 129 => 7, 130 => 9, 131 => 17, 132 => 24, 133 => 44, 134 => 69, 135 => 77, 136 => 156, 137 => 2478, 138 => 3049105, 139 => 3049109, 140 => 3049111, 141 => 59, 142 => 226, 143 => 100, 144 => 259, 145 => 19, 146 => 93, 147 => 173, 148 => 3281, 149 => 2138511, 150 => 2142208, 151 => 2144022, 152 => 2145842, 153 => 46, 154 => 8, 155 => 10, 156 => 12, 157 => 13, 158 => 14, 159 => 40, 160 => 73, 161 => 710451, 162 => 74, 163 => 109, 164 => 35, 165 => 2521, 166 => 39, 167 => 36, 168 => 95, 169 => 251, 170 => 2889252, 171 => 1685, 172 => 116, 173 => 347581, 174 => 347928, 175 => 162, 176 => 349355, 177 => 349344, 178 => 349389, 179 => 186, 180 => 350814, 181 => 164, 182 => 115, 183 => 170, 184 => 4135, 185 => 3006, 186 => 189, 187 => 190, 188 => 31, 189 => 1578, 190 => 79, 191 => 2741642, 192 => 148, 193 => 2750814, 194 => 71, 195 => 84, 196 => 81, 197 => 51, 198 => 1860, 199 => 192, 200 => 199, 201 => 3797, 202 => 32, 203 => 3049153, 204 => 3049149, 205 => 85, 206 => 2743497, 207 => 262, 208 => 154, 209 => 191, 210 => 1976, 211 => 43, 212 => 3045371, 213 => 174, 214 => 27, 215 => 29, 216 => 182, 217 => 26, 218 => 188, 219 => 25, 220 => 30, 221 => 103, 222 => 57, 223 => 346578, 224 => 2577, 225 => 346767, 226 => 346792, 227 => 60, 228 => 1685, 229 => 116, 230 => 347581, 231 => 347928, 232 => 162, 233 => 349355, 234 => 349344, 235 => 349389, 236 => 186, 237 => 350814, 238 => 164, 239 => 115, 240 => 170, 241 => 4135, 242 => 11, 243 => 55, 244 => 568546, 245 => 16, 246 => 70, 247 => 22, 248 => 64, 249 => 569962, 250 => 21, 251 => 2974, 252 => 92, 253 => 3049121, 254 => 3, 255 => 3049151, 256 => 87, 257 => 2217, 258 => 4, 259 => 6, 260 => 47, 261 => 37, 262 => 3049115, 263 => 53, 264 => 52, 265 => 581510, 266 => 15, 267 => 76, 268 => 257, 269 => 131, 270 => 761711, 271 => 771584, 272 => 772385, 273 => 773937, 274 => 58, 275 => 129, 276 => 56, 277 => 134, 278 => 789628, 279 => 152, 280 => 3006, 281 => 189, 282 => 190, 283 => 31, 284 => 1578, 285 => 79, 286 => 2741642, 287 => 148, 288 => 2750814, 289 => 71, 290 => 84, 291 => 81, 292 => 51, 293 => 1860, 294 => 192, 295 => 199, 296 => 3797, 297 => 32, 298 => 3049153, 299 => 3049149, 300 => 85, 301 => 2743497, 302 => 262, 303 => 154, 304 => 191, 305 => 1976, 306 => 43, 307 => 3045371, 308 => 828182, 309 => 835346, 310 => 852765, 311 => 108, 312 => 110, 313 => 875285, 314 => 68, 315 => 61, 316 => 878903, 317 => 893296, 318 => 114, 319 => 66, 320 => 974878, 321 => 34, 322 => 28, 323 => 83, 324 => 33, 325 => 104, 326 => 180, 327 => 1328096, 328 => 45, 329 => 118, 330 => 78, 331 => 18, 332 => 4244, 333 => 1843, 334 => 1341400, 335 => 1341882, 336 => 23, 337 => 265, 338 => 187, 339 => 38, 340 => 1, 341 => 2, 342 => 17, 343 => 44, 344 => 3049105, 345 => 2478, 346 => 7, 347 => 77, 348 => 69, 349 => 3049111, 350 => 9, 351 => 3049109, 352 => 24, 353 => 156, 354 => 59, 355 => 226, 356 => 100, 357 => 259, 358 => 2138511, 359 => 2142208, 360 => 2144022, 361 => 19, 362 => 2145842, 363 => 93, 364 => 3281, 365 => 173, 366 => 46, 367 => 13, 368 => 73, 369 => 710451, 370 => 8, 371 => 10, 372 => 40, 373 => 14, 374 => 12, 375 => 74, 376 => 109, 377 => 2521, 378 => 35, 379 => 39, 380 => 36, 381 => 95, 382 => 2889252, 383 => 251, 384 => 62, 385 => 174, 386 => 27, 387 => 29, 388 => 182, 389 => 26, 390 => 188, 391 => 25, 392 => 30, 393 => 57, 394 => 346578, 395 => 2577, 396 => 346767, 397 => 346792, 398 => 60, 399 => 11, 400 => 55, 401 => 568546, 402 => 16, 403 => 70, 404 => 22, 405 => 64, 406 => 569962, 407 => 21, 408 => 2974, 409 => 92, 410 => 3049121, 411 => 3, 412 => 3049151, 413 => 87, 414 => 2217, 415 => 4, 416 => 6, 417 => 47, 418 => 37, 419 => 3049115, 420 => 53, 421 => 52, 422 => 581510, 423 => 15, 424 => 76, 425 => 34, 426 => 28, 427 => 83, 428 => 33, 429 => 78, 430 => 18, 431 => 4244, 432 => 1843, 433 => 1341400, 434 => 1341882, 435 => 38, 436 => 1, 437 => 2, 438 => 17, 439 => 44, 440 => 3049105, 441 => 2478, 442 => 7, 443 => 77, 444 => 69, 445 => 3049111, 446 => 9, 447 => 3049109, 448 => 24, 449 => 156, 450 => 59, 451 => 226, 452 => 259, 453 => 46, 454 => 13, 455 => 73, 456 => 710451, 457 => 8, 458 => 10, 459 => 40, 460 => 14, 461 => 12, 462 => 2521, 463 => 35, 464 => 39, 465 => 36, 466 => 95, 467 => 2889252, 468 => 251, 469 => 62, 470 => 103, 471 => 257, 472 => 131, 473 => 761711, 474 => 771584, 475 => 772385, 476 => 773937, 477 => 58, 478 => 129, 479 => 56, 480 => 134, 481 => 789628, 482 => 152, 483 => 828182, 484 => 835346, 485 => 852765, 486 => 108, 487 => 110, 488 => 875285, 489 => 68, 490 => 61, 491 => 878903, 492 => 893296, 493 => 114, 494 => 66, 495 => 974878, 496 => 104, 497 => 180, 498 => 1328096, 499 => 45, 500 => 118, 501 => 23, 502 => 265, 503 => 187, 504 => 100, 505 => 2138511, 506 => 2142208, 507 => 2144022, 508 => 19, 509 => 2145842, 510 => 93, 511 => 3281, 512 => 173, 513 => 74, 514 => 109, 515 => 62 ], 2 => YUL ] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? ORDER BY s0_.name ASC SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.lang = 'fr' AND s0_.code IN ('174', '27', '29', '25', '26', '182', '188', '30', '103', '57', '2577', '346578', '346767', '346792', '60', '115', '116', '162', '164', '170', '186', '1685', '4135', '347581', '347928', '349344', '349355', '349389', '350814', '11', '55', '16', '21', '22', '64', '70', '2974', '568546', '569962', '3', '4', '6', '15', '37', '47', '52', '53', '87', '92', '2217', '581510', '3049115', '3049121', '3049151', '76', '257', '56', '58', '129', '131', '134', '152', '761711', '771584', '772385', '773937', '789628', '31', '32', '43', '51', '71', '79', '81', '84', '85', '148', '154', '189', '190', '191', '192', '199', '262', '1578', '1860', '1976', '3006', '3797', '2741642', '2743497', '2750814', '3045371', '3049149', '3049153', '61', '68', '108', '110', '114', '828182', '835346', '852765', '875285', '878903', '893296', '66', '974878', '34', '28', '83', '33', '104', '45', '118', '180', '1328096', '18', '78', '1843', '4244', '1341400', '1341882', '23', '187', '265', '38', '1', '2', '7', '9', '17', '24', '44', '69', '77', '156', '2478', '3049105', '3049109', '3049111', '59', '226', '100', '259', '19', '93', '173', '3281', '2138511', '2142208', '2144022', '2145842', '46', '8', '10', '12', '13', '14', '40', '73', '710451', '74', '109', '35', '2521', '39', '36', '95', '251', '2889252', '1685', '116', '347581', '347928', '162', '349355', '349344', '349389', '186', '350814', '164', '115', '170', '4135', '3006', '189', '190', '31', '1578', '79', '2741642', '148', '2750814', '71', '84', '81', '51', '1860', '192', '199', '3797', '32', '3049153', '3049149', '85', '2743497', '262', '154', '191', '1976', '43', '3045371', '174', '27', '29', '182', '26', '188', '25', '30', '103', '57', '346578', '2577', '346767', '346792', '60', '1685', '116', '347581', '347928', '162', '349355', '349344', '349389', '186', '350814', '164', '115', '170', '4135', '11', '55', '568546', '16', '70', '22', '64', '569962', '21', '2974', '92', '3049121', '3', '3049151', '87', '2217', '4', '6', '47', '37', '3049115', '53', '52', '581510', '15', '76', '257', '131', '761711', '771584', '772385', '773937', '58', '129', '56', '134', '789628', '152', '3006', '189', '190', '31', '1578', '79', '2741642', '148', '2750814', '71', '84', '81', '51', '1860', '192', '199', '3797', '32', '3049153', '3049149', '85', '2743497', '262', '154', '191', '1976', '43', '3045371', '828182', '835346', '852765', '108', '110', '875285', '68', '61', '878903', '893296', '114', '66', '974878', '34', '28', '83', '33', '104', '180', '1328096', '45', '118', '78', '18', '4244', '1843', '1341400', '1341882', '23', '265', '187', '38', '1', '2', '17', '44', '3049105', '2478', '7', '77', '69', '3049111', '9', '3049109', '24', '156', '59', '226', '100', '259', '2138511', '2142208', '2144022', '19', '2145842', '93', '3281', '173', '46', '13', '73', '710451', '8', '10', '40', '14', '12', '74', '109', '2521', '35', '39', '36', '95', '2889252', '251', '62', '174', '27', '29', '182', '26', '188', '25', '30', '57', '346578', '2577', '346767', '346792', '60', '11', '55', '568546', '16', '70', '22', '64', '569962', '21', '2974', '92', '3049121', '3', '3049151', '87', '2217', '4', '6', '47', '37', '3049115', '53', '52', '581510', '15', '76', '34', '28', '83', '33', '78', '18', '4244', '1843', '1341400', '1341882', '38', '1', '2', '17', '44', '3049105', '2478', '7', '77', '69', '3049111', '9', '3049109', '24', '156', '59', '226', '259', '46', '13', '73', '710451', '8', '10', '40', '14', '12', '2521', '35', '39', '36', '95', '2889252', '251', '62', '103', '257', '131', '761711', '771584', '772385', '773937', '58', '129', '56', '134', '789628', '152', '828182', '835346', '852765', '108', '110', '875285', '68', '61', '878903', '893296', '114', '66', '974878', '104', '180', '1328096', '45', '118', '23', '265', '187', '100', '2138511', '2142208', '2144022', '19', '2145842', '93', '3281', '173', '74', '109', '62') AND s0_.gatewaycode = 'YUL' ORDER BY s0_.name ASC;
6.67 ms (10.65%)	1	SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1 Parameters: [0 => 2026-02-02 09:47:00, 1 => 2026-02-02 09:47:00, 2 => 1, 3 => /destination-sud/cuba/varadero] View formatted query View runnable query Explain query SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE ( p0_.publication_date_start <= ? AND ( p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ? ) ) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1 SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-02-02 09:47:00' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-02-02 09:47:00')) AND p0_.enabled = 1 AND p0_.site_id = 1 AND p0_.url = '/destination-sud/cuba/varadero' LIMIT 1;
6.06 ms (9.67%)	1	SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.route_name = ? LIMIT 1 Parameters: [0 => 2026-02-02 09:47:00, 1 => 2026-02-02 09:47:00, 2 => 1, 3 => _page_internal_global] View formatted query View runnable query Explain query SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE ( p0_.publication_date_start <= ? AND ( p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ? ) ) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.route_name = ? LIMIT 1 SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-02-02 09:47:00' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-02-02 09:47:00')) AND p0_.enabled = 1 AND p0_.site_id = 1 AND p0_.route_name = '_page_internal_global' LIMIT 1;
3.42 ms (5.46%)	1	SELECT s0_.durationsraw AS durationsraw_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? Parameters: [ 0 => fr, 1 => [ 0 => 174, 1 => 27, 2 => 29, 3 => 182, 4 => 26, 5 => 188, 6 => 25, 7 => 30, 8 => 57, 9 => 346578, 10 => 2577, 11 => 346767, 12 => 346792, 13 => 60, 14 => 11, 15 => 55, 16 => 568546, 17 => 16, 18 => 70, 19 => 22, 20 => 64, 21 => 569962, 22 => 21, 23 => 2974, 24 => 92, 25 => 3049121, 26 => 3, 27 => 3049151, 28 => 87, 29 => 2217, 30 => 4, 31 => 6, 32 => 47, 33 => 37, 34 => 3049115, 35 => 53, 36 => 52, 37 => 581510, 38 => 15, 39 => 76, 40 => 34, 41 => 28, 42 => 83, 43 => 33, 44 => 78, 45 => 18, 46 => 4244, 47 => 1843, 48 => 1341400, 49 => 1341882, 50 => 38, 51 => 1, 52 => 2, 53 => 17, 54 => 44, 55 => 3049105, 56 => 2478, 57 => 7, 58 => 77, 59 => 69, 60 => 3049111, 61 => 9, 62 => 3049109, 63 => 24, 64 => 156, 65 => 59, 66 => 226, 67 => 259, 68 => 46, 69 => 13, 70 => 73, 71 => 710451, 72 => 8, 73 => 10, 74 => 40, 75 => 14, 76 => 12, 77 => 2521, 78 => 35, 79 => 39, 80 => 36, 81 => 95, 82 => 2889252, 83 => 251, 84 => 62 ], 2 => YUL ] View formatted query View runnable query Explain query SELECT s0_.durationsraw AS durationsraw_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? SELECT s0_.durationsraw AS durationsraw_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = 'fr' AND s0_.code IN ('174', '27', '29', '182', '26', '188', '25', '30', '57', '346578', '2577', '346767', '346792', '60', '11', '55', '568546', '16', '70', '22', '64', '569962', '21', '2974', '92', '3049121', '3', '3049151', '87', '2217', '4', '6', '47', '37', '3049115', '53', '52', '581510', '15', '76', '34', '28', '83', '33', '78', '18', '4244', '1843', '1341400', '1341882', '38', '1', '2', '17', '44', '3049105', '2478', '7', '77', '69', '3049111', '9', '3049109', '24', '156', '59', '226', '259', '46', '13', '73', '710451', '8', '10', '40', '14', '12', '2521', '35', '39', '36', '95', '2889252', '251', '62') AND s0_.gatewaycode = 'YUL';
3.24 ms (5.17%)	1	SELECT s0_.hotelcodes AS hotelcodes_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? Parameters: [ 0 => fr, 1 => [ 0 => 174, 1 => 27, 2 => 29, 3 => 182, 4 => 26, 5 => 188, 6 => 25, 7 => 30, 8 => 57, 9 => 346578, 10 => 2577, 11 => 346767, 12 => 346792, 13 => 60, 14 => 11, 15 => 55, 16 => 568546, 17 => 16, 18 => 70, 19 => 22, 20 => 64, 21 => 569962, 22 => 21, 23 => 2974, 24 => 92, 25 => 3049121, 26 => 3, 27 => 3049151, 28 => 87, 29 => 2217, 30 => 4, 31 => 6, 32 => 47, 33 => 37, 34 => 3049115, 35 => 53, 36 => 52, 37 => 581510, 38 => 15, 39 => 76, 40 => 34, 41 => 28, 42 => 83, 43 => 33, 44 => 78, 45 => 18, 46 => 4244, 47 => 1843, 48 => 1341400, 49 => 1341882, 50 => 38, 51 => 1, 52 => 2, 53 => 17, 54 => 44, 55 => 3049105, 56 => 2478, 57 => 7, 58 => 77, 59 => 69, 60 => 3049111, 61 => 9, 62 => 3049109, 63 => 24, 64 => 156, 65 => 59, 66 => 226, 67 => 259, 68 => 46, 69 => 13, 70 => 73, 71 => 710451, 72 => 8, 73 => 10, 74 => 40, 75 => 14, 76 => 12, 77 => 2521, 78 => 35, 79 => 39, 80 => 36, 81 => 95, 82 => 2889252, 83 => 251, 84 => 62 ], 2 => YUL ] View formatted query View runnable query Explain query SELECT s0_.hotelcodes AS hotelcodes_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = ? AND s0_.code IN (?) AND s0_.gatewaycode = ? SELECT s0_.hotelcodes AS hotelcodes_0 FROM softvoyage_destinations s0_ WHERE s0_.lang = 'fr' AND s0_.code IN ('174', '27', '29', '182', '26', '188', '25', '30', '57', '346578', '2577', '346767', '346792', '60', '11', '55', '568546', '16', '70', '22', '64', '569962', '21', '2974', '92', '3049121', '3', '3049151', '87', '2217', '4', '6', '47', '37', '3049115', '53', '52', '581510', '15', '76', '34', '28', '83', '33', '78', '18', '4244', '1843', '1341400', '1341882', '38', '1', '2', '17', '44', '3049105', '2478', '7', '77', '69', '3049111', '9', '3049109', '24', '156', '59', '226', '259', '46', '13', '73', '710451', '8', '10', '40', '14', '12', '2521', '35', '39', '36', '95', '2889252', '251', '62') AND s0_.gatewaycode = 'YUL';
2.64 ms (4.21%)	3	SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.page_id = ? LIMIT 1 Parameters: [0 => 2026-02-02 09:47:00, 1 => 2026-02-02 09:47:00, 2 => 301] View formatted query View runnable query Explain query SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE ( p0_.publication_date_start <= ? AND ( p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ? ) ) AND p0_.enabled = 1 AND p0_.page_id = ? LIMIT 1 SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-02-02 09:47:00' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-02-02 09:47:00')) AND p0_.enabled = 1 AND p0_.page_id = 301 LIMIT 1;
2.04 ms (3.25%)	1	SELECT DISTINCT s0_.gatewaycode AS gatewaycode_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.gatewaycode = ? AND s0_.lang = ? AND s0_.name LIKE ? Parameters: [0 => YUL, 1 => fr, 2 => %Las Vegas%] View formatted query View runnable query Explain query SELECT DISTINCT s0_.gatewaycode AS gatewaycode_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.gatewaycode = ? AND s0_.lang = ? AND s0_.name LIKE ? SELECT DISTINCT s0_.gatewaycode AS gatewaycode_0, s0_.name AS name_1 FROM softvoyage_destinations s0_ WHERE s0_.gatewaycode = 'YUL' AND s0_.lang = 'fr' AND s0_.name LIKE '%Las Vegas%';
1.82 ms (2.90%)	4	SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = ? Parameters: [0 => 329] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = ? SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = 329;
1.28 ms (2.04%)	1	SELECT DISTINCT s0_.code AS code_0, s1_.name AS name_1 FROM softvoyage_gateways s0_ INNER JOIN softvoyage_destinationgroups s1_ ON (s0_.id = s1_.gatewayid) WHERE s0_.code = ? AND s0_.lang = ? Parameters: [0 => YUL, 1 => fr] View formatted query View runnable query Explain query SELECT DISTINCT s0_.code AS code_0, s1_.name AS name_1 FROM softvoyage_gateways s0_ INNER JOIN softvoyage_destinationgroups s1_ ON (s0_.id = s1_.gatewayid) WHERE s0_.code = ? AND s0_.lang = ? SELECT DISTINCT s0_.code AS code_0, s1_.name AS name_1 FROM softvoyage_gateways s0_ INNER JOIN softvoyage_destinationgroups s1_ ON (s0_.id = s1_.gatewayid) WHERE s0_.code = 'YUL' AND s0_.lang = 'fr';
1.25 ms (2.00%)	3	SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = ? AND p0_.enabled = 1 Parameters: [0 => 84] View formatted query View runnable query Explain query SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = ? AND p0_.enabled = 1 SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = '84' AND p0_.enabled = 1;
1.21 ms (1.94%)	1	SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?) AND t0.enabled = ? ORDER BY t0.is_default DESC Parameters: [ 0 => [ 0 => www.vb.dev2.intercode.ca, 1 => localhost ], 1 => 1 ] View formatted query View runnable query Explain query SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?) AND t0.enabled = ? ORDER BY t0.is_default DESC SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN ('www.vb.dev2.intercode.ca', 'localhost') AND t0.enabled = 1 ORDER BY t0.is_default DESC;
0.96 ms (1.53%)	1	SELECT s0_.name AS name_0, s0_.codes AS codes_1 FROM softvoyage_hotelchains s0_ WHERE s0_.lang = ? Parameters: [0 => fr] View formatted query View runnable query Explain query SELECT s0_.name AS name_0, s0_.codes AS codes_1 FROM softvoyage_hotelchains s0_ WHERE s0_.lang = ? SELECT s0_.name AS name_0, s0_.codes AS codes_1 FROM softvoyage_hotelchains s0_ WHERE s0_.lang = 'fr';
0.91 ms (1.45%)	1	SELECT COUNT(w0_.id) AS sclr_0 FROM wicrew_cruise w0_ WHERE w0_.locale = ? AND w0_.active = ? AND w0_.departure_date >= ? AND (w0_.published_from IS NULL OR w0_.published_from <= ?) AND (w0_.published_to IS NULL OR w0_.published_to >= ?) Parameters: [0 => fr, 1 => 1, 2 => 2026-02-02, 3 => 2026-02-02, 4 => 2026-02-02] View formatted query View runnable query Explain query SELECT COUNT(w0_.id) AS sclr_0 FROM wicrew_cruise w0_ WHERE w0_.locale = ? AND w0_.active = ? AND w0_.departure_date >= ? AND ( w0_.published_from IS NULL OR w0_.published_from <= ? ) AND ( w0_.published_to IS NULL OR w0_.published_to >= ? ) SELECT COUNT(w0_.id) AS sclr_0 FROM wicrew_cruise w0_ WHERE w0_.locale = 'fr' AND w0_.active = 1 AND w0_.departure_date >= '2026-02-02' AND (w0_.published_from IS NULL OR w0_.published_from <= '2026-02-02') AND (w0_.published_to IS NULL OR w0_.published_to >= '2026-02-02');
0.89 ms (1.42%)	1	SELECT s0_.gatewayid AS gatewayid_0, s1_.code AS code_1, s0_.name AS name_2, s0_.codesraw AS codesraw_3, s1_.name AS name_4, s0_.datecreation AS datecreation_5 FROM softvoyage_gateways s1_ INNER JOIN softvoyage_destinationgroups s0_ ON (s1_.id = s0_.gatewayid) WHERE s1_.code = ? AND s1_.lang = ? ORDER BY s0_.name ASC Parameters: [0 => YUL, 1 => fr] View formatted query View runnable query Explain query SELECT s0_.gatewayid AS gatewayid_0, s1_.code AS code_1, s0_.name AS name_2, s0_.codesraw AS codesraw_3, s1_.name AS name_4, s0_.datecreation AS datecreation_5 FROM softvoyage_gateways s1_ INNER JOIN softvoyage_destinationgroups s0_ ON (s1_.id = s0_.gatewayid) WHERE s1_.code = ? AND s1_.lang = ? ORDER BY s0_.name ASC SELECT s0_.gatewayid AS gatewayid_0, s1_.code AS code_1, s0_.name AS name_2, s0_.codesraw AS codesraw_3, s1_.name AS name_4, s0_.datecreation AS datecreation_5 FROM softvoyage_gateways s1_ INNER JOIN softvoyage_destinationgroups s0_ ON (s1_.id = s0_.gatewayid) WHERE s1_.code = 'YUL' AND s1_.lang = 'fr' ORDER BY s0_.name ASC;
0.77 ms (1.22%)	1	SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_gateways s0_ WHERE s0_.lang = ? ORDER BY s0_.name ASC Parameters: [0 => fr] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_gateways s0_ WHERE s0_.lang = ? ORDER BY s0_.name ASC SELECT s0_.code AS code_0, s0_.name AS name_1 FROM softvoyage_gateways s0_ WHERE s0_.lang = 'fr' ORDER BY s0_.name ASC;
0.71 ms (1.13%)	1	SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.message AS message_2, a0_.enabled AS enabled_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.createdDate AS createdDate_6, a0_.modifiedDate AS modifiedDate_7 FROM alert_banner a0_ WHERE a0_.locale = ? AND a0_.enabled = 1 AND a0_.start_date <= ? AND a0_.end_date >= ? Parameters: [0 => fr, 1 => 2026-02-02 09:47:00, 2 => 2026-02-02 09:47:00] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.message AS message_2, a0_.enabled AS enabled_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.createdDate AS createdDate_6, a0_.modifiedDate AS modifiedDate_7 FROM alert_banner a0_ WHERE a0_.locale = ? AND a0_.enabled = 1 AND a0_.start_date <= ? AND a0_.end_date >= ? SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.message AS message_2, a0_.enabled AS enabled_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.createdDate AS createdDate_6, a0_.modifiedDate AS modifiedDate_7 FROM alert_banner a0_ WHERE a0_.locale = 'fr' AND a0_.enabled = 1 AND a0_.start_date <= '2026-02-02 09:47:00' AND a0_.end_date >= '2026-02-02 09:47:00';
0.57 ms (0.91%)	1	SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.enabled = ? Parameters: [0 => 1] View formatted query View runnable query Explain query SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.enabled = ? SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.enabled = 1;
0.47 ms (0.75%)	1	SELECT d0_.dcode AS dcode_0, d0_.frenchtext AS frenchtext_1, d0_.englishtext AS englishtext_2, d0_.selected AS selected_3 FROM deals_departure d0_ ORDER BY d0_.dorder ASC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.dcode AS dcode_0, d0_.frenchtext AS frenchtext_1, d0_.englishtext AS englishtext_2, d0_.selected AS selected_3 FROM deals_departure d0_ ORDER BY d0_.dorder ASC SELECT d0_.dcode AS dcode_0, d0_.frenchtext AS frenchtext_1, d0_.englishtext AS englishtext_2, d0_.selected AS selected_3 FROM deals_departure d0_ ORDER BY d0_.dorder ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
FOS\UserBundle\Entity\User	No errors.
Sonata\UserBundle\Entity\BaseUser	No errors.
Application\Sonata\UserBundle\Entity\User	No errors.
Sonata\PageBundle\Entity\BaseSite	No errors.
Application\Sonata\PageBundle\Entity\Site	No errors.
Sonata\PageBundle\Entity\BaseSnapshot	No errors.
Application\Sonata\PageBundle\Entity\Snapshot	No errors.
Sonata\PageBundle\Entity\BasePage	No errors.
Application\Sonata\PageBundle\Entity\Page	No errors.
Application\Sonata\PageTranslationBundle\Entity\PageTranslate	No errors.
Sonata\PageBundle\Entity\BaseBlock	No errors.
Application\Sonata\PageBundle\Entity\Block	No errors.
BergeronBundle\Entity\AlertBanner	No errors.
Wicrew\CruiseBundle\Entity\Cruise	No errors.
Wicrew\CoreBundle\Entity\SoftvoyageGateways	No errors.
Wicrew\CoreBundle\Entity\SoftvoyageDestinationgroups	No errors.
Wicrew\CoreBundle\Entity\SoftvoyageDestinations	No errors.
Wicrew\CoreBundle\Entity\SoftvoyageHotelchains	No errors.
Wicrew\CoreBundle\Entity\SoftvoyageHotels	No errors.
BergeronBundle\Entity\DealsDeparture	No errors.

Symfony Profiler

https://www.vb.dev2.intercode.ca/destination-sud/cuba/varadero?device_view=full

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping