Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.36 ms
(82.94%)
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
  460857
  473128
  540051
  540150
  540159
  540774
  542445
  544617
  544871
  546036
  552382
  554716
  555220
  555296
  556040
  556337
  562048
  562053
  573516
  576509
  577019
  580129
  580382
  581033
  592576
  597763
  606253
  606271
  606484
  610199
  618177
  618864
  626332
  626841
  627131
  628332
  632750
  633182
  633823
  637511
  640156
  640672
  649440
  652766
  656523
  659033
  662214
  672755
  672764
  678662
  681535
  691381
  692713
  692714
  700011
  701194
  709712
  710265
  714453
  714489
  715888
  717147
  724029
  725229
  726171
  727017
  727042
  727556
  727969
  728276
  729287
  732869
  736396
  736944
  737883
  739561
  740472
  744418
  744820
  745464
  748496
  748637
  749129
  751170
  751360
  752840
  755057
  757238
  757246
  758176
  758292
  768059
  768683
  774666
  784048
  785574
  790124
  790158
  794019
  795979
  796577
  797240
  797250
  800763
  800920
  802315
  802949
  805836
  807881
  810390
  811785
  811862
  811882
  811889
  812934
  816168
  818635
  826763
  827080
  827491
]
14.45 ms
(9.64%)
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
  768059
  751360
  755057
  768683
  727042
  728276
  758292
  637511
  709712
  715888
  717147
  774666
  562053
  640672
  744820
  745464
  739561
  627131
  757246
  633823
  628332
  827491
  818635
  540774
  540150
  460857
  573516
  580382
  556040
  546036
  681535
  656523
  692713
  714489
  554716
  606253
  618864
  606484
  606271
  811882
  726171
  737883
  749129
  784048
  805836
  811785
  732869
  744418
  751170
  727017
  740472
  748637
  757238
  758176
  727969
  633182
  701194
  785574
  800920
  811862
  811889
  672764
  790158
  562048
  710265
  797240
  752840
  618177
  540051
  542445
  577019
  544617
  544871
  556337
  649440
  662214
  700011
  555296
  632750
  640156
  626332
  794019
  795979
  802949
  807881
  797250
  810390
  812934
  725229
  736396
  790124
  802315
  724029
  748496
  727556
  800763
  678662
  652766
  626841
  796577
  736944
  729287
  473128
  672755
  816168
  826763
  827080
  540159
  552382
  581033
  576509
  692714
  659033
  691381
  714453
  555220
  580129
  592576
  597763
  610199
]
3.12 ms
(2.08%)
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
  460857
  473128
  540051
  540150
  540159
  540774
  542445
  544617
  544871
  546036
  552382
  554716
  555220
  555296
  556040
  556337
  562048
  562053
  573516
  576509
  577019
  580129
  580382
  581033
  592576
  597763
  606253
  606271
  606484
  610199
  618177
  618864
  626332
  626841
  627131
  628332
  632750
  633182
  633823
  637511
  640156
  640672
  649440
  652766
  656523
  659033
  662214
  672755
  672764
  678662
  681535
  691381
  692713
  692714
  700011
  701194
  709712
  710265
  714453
  714489
  715888
  717147
  724029
  725229
  726171
  727017
  727042
  727556
  727969
  728276
  729287
  732869
  736396
  736944
  737883
  739561
  740472
  744418
  744820
  745464
  748496
  748637
  749129
  751170
  751360
  752840
  755057
  757238
  757246
  758176
  758292
  768059
  768683
  774666
  784048
  785574
  790124
  790158
  794019
  795979
  796577
  797240
  797250
  800763
  800920
  802315
  802949
  805836
  807881
  810390
  811785
  811862
  811882
  811889
  812934
  816168
  818635
  826763
  827080
  827491
]
2.25 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss wife"
]
1.93 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг жен"
]
1.92 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.