Symfony Profiler

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.company_kana AS company_kana_3,
  t0.postal_code AS postal_code_4,
  t0.addr01 AS addr01_5,
  t0.addr02 AS addr02_6,
  t0.phone_number AS phone_number_7,
  t0.business_hour AS business_hour_8,
  t0.email01 AS email01_9,
  t0.email02 AS email02_10,
  t0.email03 AS email03_11,
  t0.email04 AS email04_12,
  t0.shop_name AS shop_name_13,
  t0.shop_kana AS shop_kana_14,
  t0.shop_name_eng AS shop_name_eng_15,
  t0.update_date AS update_date_16,
  t0.good_traded AS good_traded_17,
  t0.message AS message_18,
  t0.delivery_free_amount AS delivery_free_amount_19,
  t0.delivery_free_quantity AS delivery_free_quantity_20,
  t0.option_mypage_order_status_display AS option_mypage_order_status_display_21,
  t0.option_nostock_hidden AS option_nostock_hidden_22,
  t0.option_favorite_product AS option_favorite_product_23,
  t0.option_product_delivery_fee AS option_product_delivery_fee_24,
  t0.invoice_registration_number AS invoice_registration_number_25,
  t0.option_product_tax_rule AS option_product_tax_rule_26,
  t0.option_customer_activate AS option_customer_activate_27,
  t0.option_remember_me AS option_remember_me_28,
  t0.option_mail_notifier AS option_mail_notifier_29,
  t0.authentication_key AS authentication_key_30,
  t0.php_path AS php_path_31,
  t0.option_point AS option_point_32,
  t0.basic_point_rate AS basic_point_rate_33,
  t0.point_conversion_rate AS point_conversion_rate_34,
  t0.country_id AS country_id_35,
  t0.pref_id AS pref_id_36,
  t0.discriminator_type
FROM
  dtb_base_info t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('baseinfo')

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');

SELECT
  d0_.id AS id_0,
  d0_.page_name AS page_name_1,
  d0_.url AS url_2,
  d0_.file_name AS file_name_3,
  d0_.edit_type AS edit_type_4,
  d0_.author AS author_5,
  d0_.description AS description_6,
  d0_.keyword AS keyword_7,
  d0_.create_date AS create_date_8,
  d0_.update_date AS update_date_9,
  d0_.meta_robots AS meta_robots_10,
  d0_.meta_tags AS meta_tags_11,
  d1_.page_id AS page_id_12,
  d1_.layout_id AS layout_id_13,
  d1_.sort_no AS sort_no_14,
  d2_.id AS id_15,
  d2_.layout_name AS layout_name_16,
  d2_.create_date AS create_date_17,
  d2_.update_date AS update_date_18,
  d0_.discriminator_type AS discriminator_type_19,
  d0_.master_page_id AS master_page_id_20,
  d1_.discriminator_type AS discriminator_type_21,
  d1_.page_id AS page_id_22,
  d1_.layout_id AS layout_id_23,
  d2_.discriminator_type AS discriminator_type_24,
  d2_.device_type_id AS device_type_id_25
FROM
  dtb_page d0_
  LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id
  AND d1_.discriminator_type IN ('pagelayout')
  LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id
  AND d2_.discriminator_type IN ('layout')
WHERE
  (d0_.url = ?)
  AND d0_.discriminator_type IN ('page')

SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = 'sitemap_product_xml') AND d0_.discriminator_type IN ('page');

SET
  SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_no AS sort_no_3,
  t0.discriminator_type
FROM
  mtb_product_list_order_by t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('productlistorderby')

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.id = 2 AND t0.discriminator_type IN ('productlistorderby');

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  dtb_product d0_
WHERE
  (d0_.product_status_id = 1)
  AND d0_.discriminator_type IN ('product')

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product');

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.create_date AS create_date_1,
  d0_.id AS id_2
FROM
  dtb_product d0_
WHERE
  (d0_.product_status_id = 1)
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC
LIMIT
  1000 OFFSET 6000

SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 1000 OFFSET 6000;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.note AS note_2,
  d0_.description_list AS description_list_3,
  d0_.description_detail AS description_detail_4,
  d0_.search_word AS search_word_5,
  d0_.free_area AS free_area_6,
  d0_.create_date AS create_date_7,
  d0_.update_date AS update_date_8,
  d0_.maker_prices AS maker_prices_9,
  d0_.option_area AS option_area_10,
  d0_.option_item_area AS option_item_area_11,
  d0_.recommend_point AS recommend_point_12,
  d0_.sales_infomation AS sales_infomation_13,
  d0_.list_spec AS list_spec_14,
  d0_.maker_url AS maker_url_15,
  d0_.discriminator_type AS discriminator_type_16,
  d0_.creator_id AS creator_id_17,
  d0_.product_status_id AS product_status_id_18,
  d0_.maker_id AS maker_id_19
FROM
  dtb_product d0_
WHERE
  (
    d0_.product_status_id = 1
    AND d0_.id IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d0_.maker_id AS maker_id_19 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1 AND d0_.id IN (767, 766, 765, 764, 763, 762, 761, 760, 759, 758, 757, 756, 755, 754, 753, 752, 751, 750, 749, 748, 747, 746, 745, 744, 743, 742, 741, 740, 739, 738, 737, 736, 735, 734, 733, 732, 731, 730, 729, 728, 727, 726, 725, 724, 723, 722, 721, 720, 719, 718, 717, 716, 715, 714, 713, 712, 711, 710, 709, 708, 707, 706, 705, 704, 703, 702, 701, 700, 699, 698, 697, 696, 695, 694, 693, 692, 691, 690, 689, 688, 687, 686, 685, 684, 683, 682, 681, 680, 679, 678, 677, 676, 675, 674, 673, 672, 671, 670, 669, 668, 667, 666, 665, 664, 663, 662, 661, 660, 659, 658, 657, 656, 655, 654, 653, 652, 651, 650, 649, 648, 647, 646, 645, 644, 643, 642, 641, 640, 639, 638, 637, 636, 635, 634, 633, 632, 631, 630, 629, 628, 627, 626, 625, 624, 623, 622, 621, 620, 619, 618, 617, 616, 615, 614, 613, 612, 611, 610, 609, 608, 607, 606, 605, 604, 603, 602, 601, 600, 599, 598, 597, 596, 595, 594, 593, 592, 591, 590, 589, 588, 587, 586, 585, 584, 583, 582, 581, 580, 579, 578, 577, 576, 575, 574, 573, 572, 571, 570, 569, 568, 567, 566, 565, 564, 563, 562, 561, 560, 559, 558, 557, 556, 555, 554, 553, 552, 551, 550, 549, 548, 547, 546, 545, 544, 543, 542, 541, 540, 539, 538, 537, 536, 535, 534, 533, 532, 531, 530, 529, 528, 527, 526, 525, 524, 523, 522, 521, 520, 519, 518, 517, 516, 515, 514, 513, 512, 511, 510, 509, 508, 507, 506, 505, 504, 503, 502, 501, 500, 499, 498, 497, 496, 495, 494, 493, 492, 491, 490, 489, 488, 487, 486, 485, 484, 483, 482, 481, 480, 479, 478, 477, 476, 475, 474, 473, 472, 471, 470, 469, 468, 467, 466, 465, 464, 463, 462, 461, 460, 459, 458, 457, 456, 455, 454, 453, 452, 451, 450, 449, 448, 447, 446, 445, 444, 443, 442, 441, 440, 439, 438, 437, 436, 435, 434, 433, 432, 431, 430, 429, 428, 427, 426, 425, 424, 423, 422, 421, 420, 419, 418, 417, 416, 415, 414, 413, 412, 411, 410, 409, 408, 407, 406, 405, 404, 403, 402, 401, 400, 399, 398, 397, 396, 395, 394, 393, 392, 391, 390, 389, 388, 387, 386, 385, 384, 383, 382, 381, 380, 379, 378, 377, 376, 375, 374, 373, 372, 371, 370, 369, 368, 367, 366, 365, 364, 363, 362, 361, 360, 359, 358, 357, 356, 355, 354, 353, 352, 351, 350, 349, 348, 347, 346, 345, 344, 343, 342, 341, 340, 339, 338, 337, 336, 335, 334, 333, 332, 331, 330, 329, 328, 327, 326, 325, 324, 323, 322, 321, 320, 319, 318, 317, 316, 315, 314, 313, 312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 285, 284, 283, 282, 281, 280, 279, 278, 277, 276, 275, 274, 273, 272, 271, 270, 269, 268, 267, 266, 265, 264, 263, 262, 261, 260, 259, 258, 257, 256, 255, 254, 253, 252, 251, 250, 249, 248, 247, 246, 245, 244, 243, 242, 241, 240, 239, 238, 237, 236, 235, 234, 233, 232, 231, 230, 229, 228, 227, 226, 225, 224, 223, 222, 221, 220, 219, 218, 217, 216, 215, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 190, 189, 188, 187, 186, 185, 184, 183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 173, 172, 171, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114, 113, 112, 111, 110, 109, 108, 107, 106, 105, 104, 103, 102, 101, 100, 99, 98, 97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84, 83, 82, 81, 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC;