https://www.vb.dev2.intercode.ca/destination-sud/cuba

Method
GET
HTTP Status
200
IP
216.73.216.178
Profiled on
Fri, 03 Apr 2026 10:28:24 -0400
Token
c6ad46

Query Metrics

24 Database Queries
19 Different statements
67.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
21.92 ms
(32.57%) 		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
8.36 ms
(12.43%) 		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
8.20 ms
(12.18%) 		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-04-03 10:28:23, 1 => 2026-04-03 10:28:23, 2 => 1, 3 => /destination-sud/cuba]
View formatted query    View runnable query    Explain query
6.57 ms
(9.77%) 		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-04-03 10:28:23, 1 => 2026-04-03 10:28:23, 2 => 1, 3 => _page_internal_global]
View formatted query    View runnable query    Explain query
3.65 ms
(5.42%) 		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
3.43 ms
(5.10%) 		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
1.91 ms
(2.84%) 		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
1.85 ms
(2.74%) 		2 
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-04-03 10:28:23, 1 => 2026-04-03 10:28:23, 2 => 299]
View formatted query    View runnable query    Explain query
1.52 ms
(2.25%) 		3 
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 => 301]
View formatted query    View runnable query    Explain query
1.49 ms
(2.21%) 		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
1.39 ms
(2.07%) 		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 => 302]
View formatted query    View runnable query    Explain query
1.34 ms
(2.00%) 		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
1.31 ms
(1.94%) 		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
0.95 ms
(1.41%) 		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
0.81 ms
(1.20%) 		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
0.73 ms
(1.09%) 		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-04-03 10:28:23, 2 => 2026-04-03 10:28:23]
View formatted query    View runnable query    Explain query
0.71 ms
(1.05%) 		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-04-03, 3 => 2026-04-03, 4 => 2026-04-03]
View formatted query    View runnable query    Explain query
0.61 ms
(0.90%) 		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
0.56 ms
(0.83%) 		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

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.