Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.98 ms
(83.32%)
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
  346054
  365056
  382578
  415313
  415988
  416752
  428224
  429961
  432939
  439023
  439038
  441113
  441233
  444524
  447159
  449068
  452547
  459201
  460070
  465497
  479549
  480457
  483704
  487422
  487519
  497686
  506516
  508909
  508938
  512072
  512935
  514258
  514876
  519312
  519316
  519698
  519765
  529795
  529799
  530481
  530942
  531869
  531880
  534557
  534576
  534585
  536140
  536453
  537861
  538925
  547463
  547472
  547483
  547486
  547496
  547853
  548443
  550816
  554851
  554858
  559355
  568264
  571846
  572654
  576545
  576916
  581006
  581781
  583665
  586914
  595483
  599906
  600087
  600348
  605155
  610061
  614328
  628096
  633887
  634071
  642035
  648593
  648869
  658789
  660373
  660405
  660411
  660412
  660419
  661915
  666016
  669012
  669056
  669071
  671018
  671045
  672950
  680423
  686106
  705466
  713142
  717535
  719651
  723930
  725629
  727325
  742353
  744991
  745136
  770260
  770265
  782842
  786911
  788181
  788907
  791012
  800282
  805642
  817221
  827721
]
15.52 ms
(10.51%)
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
  530481
  571846
  633887
  583665
  487422
  744991
  346054
  519765
  547496
  581781
  595483
  610061
  782842
  429961
  432939
  460070
  459201
  537861
  531869
  415988
  480457
  536453
  382578
  415313
  536140
  547472
  547853
  548443
  547463
  572654
  605155
  534576
  534585
  538925
  719651
  705466
  727325
  805642
  441233
  447159
  497686
  519312
  547486
  554851
  547483
  660405
  660412
  669056
  680423
  661915
  666016
  770265
  514876
  416752
  506516
  508909
  519698
  669012
  576916
  519316
  508938
  550816
  568264
  628096
  648593
  439038
  428224
  444524
  441113
  465497
  449068
  452547
  512072
  529795
  512935
  529799
  530942
  514258
  531880
  534557
  581006
  559355
  669071
  648869
  660419
  713142
  717535
  658789
  660373
  660411
  671018
  671045
  672950
  686106
  576545
  586914
  599906
  600348
  634071
  642035
  614328
  600087
  723930
  770260
  725629
  745136
  786911
  788907
  791012
  479549
  439023
  483704
  487519
  817221
  742353
  554858
  788181
  800282
  365056
  827721
]
2.51 ms
(1.70%)
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
  346054
  365056
  382578
  415313
  415988
  416752
  428224
  429961
  432939
  439023
  439038
  441113
  441233
  444524
  447159
  449068
  452547
  459201
  460070
  465497
  479549
  480457
  483704
  487422
  487519
  497686
  506516
  508909
  508938
  512072
  512935
  514258
  514876
  519312
  519316
  519698
  519765
  529795
  529799
  530481
  530942
  531869
  531880
  534557
  534576
  534585
  536140
  536453
  537861
  538925
  547463
  547472
  547483
  547486
  547496
  547853
  548443
  550816
  554851
  554858
  559355
  568264
  571846
  572654
  576545
  576916
  581006
  581781
  583665
  586914
  595483
  599906
  600087
  600348
  605155
  610061
  614328
  628096
  633887
  634071
  642035
  648593
  648869
  658789
  660373
  660405
  660411
  660412
  660419
  661915
  666016
  669012
  669056
  669071
  671018
  671045
  672950
  680423
  686106
  705466
  713142
  717535
  719651
  723930
  725629
  727325
  742353
  744991
  745136
  770260
  770265
  782842
  786911
  788181
  788907
  791012
  800282
  805642
  817221
  827721
]
1.76 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÂðÁð¢Ðüð║ð©ð╣ Ðäð©ÐüÐéð©ð¢ð│ ð░ð¢ð░ð╗ÐÔǪ"
]
1.73 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женск фистинг анал"
]
1.42 ms
(0.96%)
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.