Query Metrics

7 Database Queries
7 Different statements
205.75 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
180.98 ms
(87.96%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  38292
  187775
  214560
  328609
  387026
  390670
  397300
  402876
  406563
  407763
  410346
  415197
  421974
  423570
  428241
  428986
  429759
  430474
  432246
  436437
  436684
  439428
  440993
  445975
  446515
  447539
  448793
  462150
  463260
  463808
  463915
  465519
  465651
  469758
  470971
  471716
  471908
  473044
  474066
  477464
  479662
  480468
  482086
  483546
  490605
  490996
  494141
  495459
  497371
  497401
  502017
  504855
  505905
  509448
  510109
  510440
  510631
  513578
  514949
  515306
  515554
  517572
  518472
  520729
  522220
  522264
  522316
  526974
  528308
  542341
  543946
  546784
  555062
  555119
  557142
  559734
  561748
  561869
  566052
  568074
  571318
  577451
  579182
  584338
  590958
  612068
  619747
  621421
  631504
  636995
  646220
  678572
  685979
  688025
  709523
  718229
  729907
  738841
  742217
  744600
  754256
  759987
  763152
  777954
  778590
  783739
  789398
  790150
  793394
  793611
  793722
  801286
  805518
  807532
  814135
  814639
  816462
  817036
  817073
  824220
]
15.76 ms
(7.66%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  502017
  817036
  543946
  793394
  480468
  436437
  497371
  474066
  571318
  790150
  522220
  542341
  514949
  526974
  415197
  528308
  428986
  471908
  490996
  522316
  328609
  807532
  477464
  407763
  423570
  445975
  505905
  515554
  522264
  631504
  510109
  513578
  518472
  483546
  814639
  817073
  584338
  621421
  636995
  793722
  738841
  744600
  777954
  465519
  619747
  482086
  448793
  557142
  742217
  789398
  402876
  463915
  490605
  446515
  462150
  469758
  555119
  566052
  577451
  590958
  759987
  612068
  479662
  465651
  470971
  463260
  517572
  429759
  440993
  463808
  678572
  38292
  778590
  504855
  495459
  709523
  579182
  510631
  520729
  214560
  805518
  187775
  436684
  428241
  494141
  561748
  568074
  561869
  555062
  559734
  410346
  471716
  387026
  430474
  447539
  473044
  406563
  439428
  509448
  497401
  515306
  783739
  793611
  397300
  546784
  432246
  510440
  390670
  824220
  718229
  814135
  763152
  729907
  754256
  421974
  816462
  685979
  646220
  688025
  801286
]
2.20 ms
(1.07%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  38292
  187775
  214560
  328609
  387026
  390670
  397300
  402876
  406563
  407763
  410346
  415197
  421974
  423570
  428241
  428986
  429759
  430474
  432246
  436437
  436684
  439428
  440993
  445975
  446515
  447539
  448793
  462150
  463260
  463808
  463915
  465519
  465651
  469758
  470971
  471716
  471908
  473044
  474066
  477464
  479662
  480468
  482086
  483546
  490605
  490996
  494141
  495459
  497371
  497401
  502017
  504855
  505905
  509448
  510109
  510440
  510631
  513578
  514949
  515306
  515554
  517572
  518472
  520729
  522220
  522264
  522316
  526974
  528308
  542341
  543946
  546784
  555062
  555119
  557142
  559734
  561748
  561869
  566052
  568074
  571318
  577451
  579182
  584338
  590958
  612068
  619747
  621421
  631504
  636995
  646220
  678572
  685979
  688025
  709523
  718229
  729907
  738841
  742217
  744600
  754256
  759987
  763152
  777954
  778590
  783739
  789398
  790150
  793394
  793611
  793722
  801286
  805518
  807532
  814135
  814639
  816462
  817036
  817073
  824220
]
2.04 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "banana blowjob"
]
1.88 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бана фрукт секс игрушк минет оральн секс"
]
1.27 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бана фрукт секс игрушк минет оральн секс"
]

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

No loaded entities.