(default) 2 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id` FROM `jmuv3`.`recommends_categories` AS `RecommendsCategory` LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`RecommendsCategory`.`category_id` = `Category`.`id`) LEFT JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`type` = 3 AND `RecommendsCategory`.`recommend_id` = `Recommend`.`id`) WHERE `Recommend`.`code` = 'indexv2_hot_categories' AND `Recommend`.`type` = 3 ORDER BY `RecommendsCategory`.`sort_order` ASC, `RecommendsCategory`.`modified` DESC LIMIT 6003593594
2SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` IN (7, 55, 34, 38, 26, 59, 11, 52, 17, 48, 23, 18, 41, 49, 12, 56, 61, 27, 53, 5, 24, 35, 62, 50, 21, 32, 43, 57, 13, 51, 25, 6, 36, 1, 2, 4, 9, 10, 8, 3, 564, 590, 471, 211, 477, 759, 791, 776, 123, 460, 462, 574, 215, 286, 461, 530, 742, 456, 589, 208, 561, 811, 181, 582, 188, 578, 575, 735, 793, 473, 504, 788, 548, 708, 84, 738, 591, 599, 605, 815, 262, 513, 1891, 596, 706, 758, 765, 121, 282, 537, 122, 527, 289, 757, 209, 260, 586, 207, 455, 790, 265, 463, 577, 737, 762, 284, 486, 810, 291, 294, 459, 103, 570, 764, 190, 281, 545, 1894, 569, 576, 608, 714, 792, 115, 549, 585, 761, 734, 766, 808, 69, 285, 541, 496, 542, 567, 593, 760, 457, 264, 292, 492, 579, 503, 547, 602, 523, 552, 607, 744, 494, 495, 287, 521, 555, 711, 733, 107, 507, 466, 709, 263, 280, 467, 80, 288, 559, 787, 184, 189, 192, 202, 329, 510, 786, 106, 335, 543, 566, 111, 261, 293, 512, 266, 595, 501, 583, 95, 191, 789, 180, 517, 195, 782, 290, 568, 210, 212, 465, 778, 719, 739, 279, 81, 532, 713, 783, 177, 472, 538, 478, 505, 610, 327, 479, 604, 720, 816, 119, 179, 468, 194, 213, 324, 328, 707, 108, 544, 546, 458, 539, 515, 743, 217, 336, 514, 712, 491, 522, 554, 598, 497, 587, 185, 332, 518, 535, 556, 777, 785, 186, 296, 562, 813, 114, 295, 196, 480, 526, 531, 588, 104, 258, 297, 536, 259, 520, 563, 124, 183, 278, 736, 193, 197, 529, 774, 814, 83, 334, 609, 557, 763, 276, 525, 715, 267, 499, 558, 109, 592, 812, 326, 779, 117, 298, 581, 594, 64, 551, 1895, 584, 126, 571, 780, 603, 485, 565, 809, 216, 330, 475, 519, 550, 92, 474, 118, 489, 533, 597, 127, 516, 775, 66, 469, 553, 560, 67, 257, 331, 710, 93, 214, 325, 65, 182, 534, 572, 781, 283, 125, 524, 573, 580, 741, 784, 277, 333, 498, 187, 606, 68, 82, 178, 540, 718, 464, 493, 740, 120) ORDER BY FIELD(`Category`.`id`, 7,55,34,38,26,59,11,52,17,48,23,18,41,49,12,56,61,27,53,5,24,35,62,50,21,32,43,57,13,51,25,6,36,1,2,4,9,10,8,3,564,590,471,211,477,759,791,776,123,460,462,574,215,286,461,530,742,456,589,208,561,811,181,582,188,578,575,735,793,473,504,788,548,708,84,738,591,599,605,815,262,513,1891,596,706,758,765,121,282,537,122,527,289,757,209,260,586,207,455,790,265,463,577,737,762,284,486,810,291,294,459,103,570,764,190,281,545,1894,569,576,608,714,792,115,549,585,761,734,766,808,69,285,541,496,542,567,593,760,457,264,292,492,579,503,547,602,523,552,607,744,494,495,287,521,555,711,733,107,507,466,709,263,280,467,80,288,559,787,184,189,192,202,329,510,786,106,335,543,566,111,261,293,512,266,595,501,583,95,191,789,180,517,195,782,290,568,210,212,465,778,719,739,279,81,532,713,783,177,472,538,478,505,610,327,479,604,720,816,119,179,468,194,213,324,328,707,108,544,546,458,539,515,743,217,336,514,712,491,522,554,598,497,587,185,332,518,535,556,777,785,186,296,562,813,114,295,196,480,526,531,588,104,258,297,536,259,520,563,124,183,278,736,193,197,529,774,814,83,334,609,557,763,276,525,715,267,499,558,109,592,812,326,779,117,298,581,594,64,551,1895,584,126,571,780,603,485,565,809,216,330,475,519,550,92,474,118,489,533,597,127,516,775,66,469,553,560,67,257,331,710,93,214,325,65,182,534,572,781,283,125,524,573,580,741,784,277,333,498,187,606,68,82,178,540,718,464,493,740,120) ASC3593596