61 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
02:27:09.859 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_players` WHERE `slug`='2325-gonsalo-iguain' |
02:27:09.906 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1741649229) AND ((`EndDate` > 1741649229) OR (`EndDate`=0)) |
02:27:09.909 | 1.8 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:09.913 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
02:27:09.916 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
02:27:09.917 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
02:27:09.918 | 1.4 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:09.919 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
02:27:09.920 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
02:27:09.921 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
02:27:09.922 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
02:27:09.924 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1741649229) AND (`bottomImage` <> '') AND ((`EndDate` > 1741649229) OR (`EndDate`=0)) AND (`useBottom`=1) |
02:27:09.928 | 1.1 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 |
02:27:09.929 | 0.9 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' |
02:27:09.930 | 0.9 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='player/2325-gonsalo-iguain?page=15') AND (`Parent`='1266') |
02:27:09.931 | 1.0 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:09.933 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_position_types` WHERE `PositionID`=4 |
02:27:09.936 | 1.1 ms | SELECT | 4 | SELECT * FROM `ut_teams` WHERE `TeamID`=3333 |
02:27:09.940 | 1.1 ms | SELECT | 4 | SELECT * FROM `ut_teams` WHERE `TeamID`=3333 |
02:27:09.941 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE `DivisionID`=61 ORDER BY `SectionID` DESC |
02:27:09.946 | 1.3 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:09.947 | 1.1 ms | SELECT | 4 | SELECT * FROM `ut_teams` WHERE `TeamID`=3333 |
02:27:09.949 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_divisions` WHERE `DivisionID`=61 |
02:27:09.950 | 1.8 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `ut_divisions` |
02:27:09.952 | 1.7 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'ut_divisions' AND `kcu`.`TABLE_NAME` = 'ut_divisions' |
02:27:09.956 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=61) |
02:27:09.958 | 1.1 ms | SELECT | 4 | SELECT * FROM `ut_teams` WHERE `TeamID`=3333 |
02:27:09.959 | 1.3 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:09.961 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_7') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:09.963 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_countries` `country1` WHERE `CountryID`=6 |
02:27:09.965 | 1.6 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `ut_countries` |
02:27:09.966 | 1.5 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'ut_countries' AND `kcu`.`TABLE_NAME` = 'ut_countries' |
02:27:09.970 | 1.0 ms | SELECT | 1 | SELECT * FROM `ut_countries` `country2` WHERE `CountryID`=53 |
02:27:09.971 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_transfer_players` WHERE `PlayerID`=2325 |
02:27:09.974 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:09.975 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=50 |
02:27:09.976 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=169 |
02:27:09.977 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=169 |
02:27:09.978 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:09.980 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_50' |
02:27:09.981 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:09.982 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=49 |
02:27:09.983 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=165 |
02:27:09.984 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=165 |
02:27:09.985 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:27:09') AND ((`end_date` >= '2025-03-11 02:27:09') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:09.986 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_49' |
02:27:09.990 | 2.2 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE (`PersonID`=2325) AND (`Type`='p') |
02:27:10.001 | 6.2 ms | SELECT | 1 | SELECT * FROM `nut_news` WHERE (`NewsID` IN (435129, 435431, 435462, 435695, 436435, 436441, 436805, 437295, 437713, 441072, 441489, 443023, 443266, 443938, 446212, 446509, 446539, 446717, 447050, 448095, 448962, 449281, 449531, 450500, 450529, 451088, 451836, 452241, 452270, 452584, 452710, 452837, 453093, 453242, 454819, 455042, 455134, 455332, 455798, 456295, 457253, 457729, 458512, 459225, 459267, 459536, 459685, 460542, 461276, 462334, 462512, 462544, 462735, 462829, 463012, 463338, 463363, 463483, 463698, 463865, 464502, 465709, 465924, 466352, 467184, 467185, 467443, 467873, 467879, 468220, 468344, 468454, 468637, 469567, 470514, 470746, 471090, 471160, 471656, 471746, 471826, 471832, 471881, 472197, 472472, 472746, 472928, 472954, 474383, 474511, 474672, 474691, 474695, 474811, 474831, 474855, 474883, 474921, 474930, 474988, 474991, 475065, 475082, 475091, 475200, 475323, 475483, 475576, 475645, 475655, 475693, 475706, 475719, 475822, 475927, 475931, 475937, 475950, 476015, 476008, 476001, 476037, 476089, 476108, 476138, 476156, 476930, 477242, 477416, 477646, 477941, 478275, 478551, 478550, 478602, 478630, 478661, 478703, 478785, 480301, 480499, 480807, 481615, 482033, 483062, 483296, 485587, 486038, 486206, 486207, 486222, 487330, 488035, 488495, 489914, 490315, 490666, 491319, 491321, 491352, 492089, 492672, 493407, 493424, 494063, 494115, 494330, 494794, 494799, 496443, 497059, 497073, 498900, 499696, 500078, 501890, 502085, 502135, 502213, 502324, 502350, 502360, 502366, 502521, 502708, 503138, 505567, 505561, 505569, 505572, 505719, 505787, 506119, 507304, 507483, 508704, 508967, 510171, 510206, 513034, 513949, 514302, 518775, 520317, 524182, 524194, 524241, 524434, 527355, 527473, 527473, 527804, 528591, 528658, 529817, 530999, 531092, 533064, 533566, 534371, 534516, 535250, 535260, 535320, 535725, 535731, 536819, 536954, 537518, 537560, 537751, 537952, 538007, 538959, 541051, 542894, 542899, 544177, 544469, 544549, 544911, 545333, 545839, 546083, 546371, 546689, 547026, 548410, 549692, 549706, 549784, 550644, 550745, 550915, 550953, 551148, 551160, 551190, 551200, 551479, 551545, 551593, 551654, 551763, 551930, 551973, 552062, 552171, 552263, 552314, 552326, 552336, 552363, 552367, 552447, 552499, 552539, 552550, 552557, 552633, 552709, 553480, 553591, 554837, 554934, 555886, 556796, 557529, 558248, 559207, 560259, 562006, 562025, 562701, 562690, 562855, 563150, 563799, 564034, 565906, 566208, 566457, 566735, 567229, 567551, 567581, 567983, 568234, 568258, 568311, 568412, 568465, 568525, 568545, 568571, 568620, 568706, 568740, 568786, 568899, 568922, 568969, 569136, 569157, 569202, 569183, 569244, 569253, 569265, 569459, 569507, 569508, 569570, 569602, 569976, 569988, 570079, 570143, 570203, 570370, 570492, 570589, 570949, 571854, 574007, 574150, 574145, 574262, 574404, 574752, 575067, 575898, 576241, 576924, 577652, 577663, 578552, 579399, 579722, 579760, 580805, 580835, 580954, 580982, 581030, 581344, 581688, 582287, 582335, 585476, 586758, 587053, 589178, 589363, 589749, 590590, 590639, 590947, 593569, 599154, 600256, 602357, 602726, 603408, 604393, 604429, 604503, 605168, 605692, 607423, 607877, 609383, 610176, 610428, 610949, 610963, 611334, 611496, 611517, 611565, 611959, 612007, 612654, 613293, 627304, 635290, 643125, 647735, 647905, 650366, 650421, 652037, 658355, 658853, 658995, 659015, 659112, 669778, 671083, 671118, 672797, 672926, 673296, 676071, 704369, 714891)) AND (`Active`=1) ORDER BY `Date` DESC LIMIT 30 OFFSET 420 |
02:27:10.010 | 0.8 ms | SELECT | 3 | SELECT * FROM `nut_content_type` WHERE 0=1 |
02:27:10.011 | 1.4 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=435695) |
02:27:10.014 | 2.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `ut_news_comments` |
02:27:10.016 | 1.6 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'ut_news_comments' AND `kcu`.`TABLE_NAME` = 'ut_news_comments' |
02:27:10.020 | 1.0 ms | SELECT | 2 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=812 |
02:27:10.023 | 1.1 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=8) |
02:27:10.025 | 0.9 ms | SELECT | 3 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0 |
02:27:10.026 | 0.9 ms | SELECT | 2 | SELECT * FROM `ut_news_categories` WHERE `CategoryID`=108 |
02:27:10.029 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID`=435695 |
02:27:10.031 | 1.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_news_teams` |
02:27:10.032 | 1.5 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'nut_news_teams' AND `kcu`.`TABLE_NAME` = 'nut_news_teams' |
02:27:10.035 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_teams` WHERE `TeamID`=173 |
02:27:10.037 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID`=435695 |
02:27:10.038 | 1.0 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:10.039 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_persons` WHERE `PersonID`=23 |
02:27:10.043 | 0.9 ms | SELECT | 3 | SELECT * FROM `nut_content_type` WHERE 0=1 |
02:27:10.044 | 1.4 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=435431) |
02:27:10.046 | 0.9 ms | SELECT | 2 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=812 |
02:27:10.047 | 1.1 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=8) |
02:27:10.049 | 0.9 ms | SELECT | 3 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0 |
02:27:10.050 | 0.9 ms | SELECT | 2 | SELECT * FROM `ut_news_categories` WHERE `CategoryID`=108 |
02:27:10.051 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID`=435431 |
02:27:10.052 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_teams` WHERE `TeamID`=173 |
02:27:10.053 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID`=435431 |
02:27:10.054 | 1.1 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:10.056 | 0.9 ms | SELECT | 3 | SELECT * FROM `nut_content_type` WHERE 0=1 |
02:27:10.057 | 3.3 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=435129) |
02:27:10.065 | 1.0 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=804 |
02:27:10.066 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=9) |
02:27:10.068 | 0.9 ms | SELECT | 3 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0 |
02:27:10.069 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_news_categories` WHERE `CategoryID`=109 |
02:27:10.070 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID`=435129 |
02:27:10.071 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_teams` WHERE `TeamID`=173 |
02:27:10.072 | 1.0 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID`=61 |
02:27:10.074 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID`=435129 |
02:27:10.075 | 1.1 ms | SELECT | 6 | SELECT * FROM `ut_players` WHERE `PlayerID`=2325 |
02:27:10.085 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.087 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=57 |
02:27:10.088 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=300 |
02:27:10.089 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=300 |
02:27:10.090 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.091 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_30') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.092 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_35') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.094 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.095 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=17 |
02:27:10.096 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=303 |
02:27:10.097 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=303 |
02:27:10.098 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.099 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=17 |
02:27:10.100 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=599 |
02:27:10.101 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=599 |
02:27:10.102 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_17' |
02:27:10.107 | 1.5 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.109 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
02:27:10.110 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
02:27:10.111 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
02:27:10.112 | 1.4 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.113 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
02:27:10.114 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
02:27:10.115 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
02:27:10.116 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
02:27:10.117 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.119 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
02:27:10.120 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=159 |
02:27:10.121 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=159 |
02:27:10.122 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.123 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
02:27:10.124 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=597 |
02:27:10.125 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=597 |
02:27:10.126 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' |
02:27:10.135 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.136 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=48 |
02:27:10.137 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=305 |
02:27:10.138 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=305 |
02:27:10.139 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.140 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' |
02:27:10.144 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_61') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.146 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `desktop_column_order`=3 ORDER BY `desktop_block_order` |
02:27:10.150 | 1.2 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.151 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=3 |
02:27:10.152 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
02:27:10.153 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
02:27:10.154 | 1.2 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.155 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=3 |
02:27:10.156 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
02:27:10.157 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
02:27:10.158 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
02:27:10.159 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'ads3', 'ads4', 'ads2', 'ads30', 'ads', 'ads62', 'ads63') |
02:27:10.161 | 1.2 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.162 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=3 |
02:27:10.163 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
02:27:10.164 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
02:27:10.165 | 1.1 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.167 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=3 |
02:27:10.168 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
02:27:10.169 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
02:27:10.170 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
02:27:10.174 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_34') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.176 | 1.5 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.178 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=11 |
02:27:10.179 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=4 |
02:27:10.180 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=4 |
02:27:10.181 | 1.4 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:27:10.182 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_11' |
02:27:10.184 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_25') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:27:10.185 | 1.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_55') AND (`start_date` <= '2025-03-11 02:27:10') AND ((`end_date` >= '2025-03-11 02:27:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
Caller | No. of Calls | Total Duration | Queries | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154 | 166.7 ms |
|