Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.00 ms
(79.51%)
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
  394376
  396280
  401378
  402079
  406041
  409585
  409682
  413890
  414177
  424798
  424917
  425079
  432715
  437996
  440771
  441692
  442204
  442301
  444468
  446587
  446713
  446968
  447828
  449228
  449897
  450319
  459225
  460197
  460262
  462994
  463623
  463624
  463630
  463691
  465312
  466812
  467662
  468629
  476861
  478186
  482629
  484300
  485460
  489325
  492268
  496266
  497104
  497117
  503075
  506829
  507890
  510233
  514263
  515877
  516444
  516886
  518054
  518847
  523478
  524262
  524397
  526591
  526611
  527066
  527088
  529170
  529335
  537130
  543773
  548489
  549739
  551816
  554253
  555971
  559678
  560512
  560879
  561948
  564173
  565195
  565631
  568098
  575272
  577811
  580061
  581092
  587072
  588755
  591442
  598999
  602742
  606621
  610828
  611977
  613864
  619717
  620300
  621356
  623754
  624288
  625088
  659986
  719353
  736627
  748210
  748244
  756209
  756714
  761275
  790015
  790022
  799360
  803055
  804988
  808675
  825662
  827880
  828545
  828730
]
23.65 ms
(14.14%)
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
  543773
  577811
  659986
  748210
  619717
  437996
  449897
  529170
  485460
  526611
  554253
  478186
  527066
  402079
  401378
  441692
  463691
  581092
  548489
  623754
  719353
  396280
  828730
  432715
  444468
  424798
  446968
  446587
  449228
  476861
  462994
  516444
  518847
  497117
  510233
  524262
  529335
  507890
  537130
  460262
  555971
  561948
  549739
  588755
  606621
  613864
  620300
  808675
  790022
  761275
  756209
  756714
  621356
  625088
  790015
  799360
  424917
  440771
  463624
  425079
  414177
  463623
  526591
  516886
  484300
  503075
  506829
  527088
  460197
  560512
  560879
  587072
  447828
  465312
  489325
  523478
  496266
  524397
  803055
  442301
  467662
  510295
  580061
  568098
  591442
  736627
  611977
  459225
  482629
  497104
  514263
  492268
  409682
  825662
  827880
  828545
  804988
  394376
  409585
  413890
  442204
  446713
  466812
  468629
  450319
  515877
  518054
  565195
  575272
  564173
  551816
  559678
  565631
  602742
  610828
  598999
  624288
  748244
  463630
  406041
]
2.73 ms
(1.63%)
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
  394376
  396280
  401378
  402079
  406041
  409585
  409682
  413890
  414177
  424798
  424917
  425079
  432715
  437996
  440771
  441692
  442204
  442301
  444468
  446587
  446713
  446968
  447828
  449228
  449897
  450319
  459225
  460197
  460262
  462994
  463623
  463624
  463630
  463691
  465312
  466812
  467662
  468629
  476861
  478186
  482629
  484300
  485460
  489325
  492268
  496266
  497104
  497117
  503075
  506829
  507890
  510233
  514263
  515877
  516444
  516886
  518054
  518847
  523478
  524262
  524397
  526591
  526611
  527066
  527088
  529170
  529335
  537130
  543773
  548489
  549739
  551816
  554253
  555971
  559678
  560512
  560879
  561948
  564173
  565195
  565631
  568098
  575272
  577811
  580061
  581092
  587072
  588755
  591442
  598999
  602742
  606621
  610828
  611977
  613864
  619717
  620300
  621356
  623754
  624288
  625088
  659986
  719353
  736627
  748210
  748244
  756209
  756714
  761275
  790015
  790022
  799360
  803055
  804988
  808675
  825662
  827880
  828545
  828730
]
2.18 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step ass"
]
2.03 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step жоп"
]
1.78 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step жоп"
]

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.