Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.58 ms
(34.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анал butt"
]
205.08 ms
(33.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
171.48 ms
(28.18%)
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
  402746
  424129
  428052
  447530
  454625
  466196
  524502
  539559
  541303
  541686
  543577
  549782
  550236
  552091
  552131
  552514
  554215
  558247
  560038
  560478
  560645
  561621
  561653
  561668
  561844
  561880
  565327
  565614
  567735
  568897
  570135
  570199
  570310
  570469
  570494
  571904
  572816
  573078
  573083
  574540
  574848
  574910
  575475
  575566
  575770
  575798
  578361
  579024
  581617
  584706
  588878
  591747
  592418
  595418
  595512
  596594
  597017
  597059
  597073
  597951
  597969
  597987
  598084
  598508
  598554
  598584
  600128
  604350
  608015
  609645
  614935
  616046
  620785
  622765
  623175
  623406
  635902
  641737
  643602
  644670
  652179
  652612
  652898
  652923
  652939
  652978
  653215
  653229
  655346
  659324
  665642
  665771
  677338
  677339
  677343
  677356
  677367
  679051
  714431
  718638
  721366
  721394
  722222
  722535
  722542
  722621
  725390
  727669
  729176
  736101
  747447
  747454
  753155
  753435
  753456
  755178
  758984
  769765
  800562
  820410
]
13.51 ms
(2.22%)
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
  565614
  565327
  560038
  561668
  567735
  592418
  447530
  570135
  554215
  653229
  659324
  596594
  747447
  609645
  561880
  595418
  549782
  597073
  597951
  597059
  597969
  568897
  677339
  718638
  655346
  727669
  641737
  570469
  573083
  574848
  573078
  652939
  722621
  652612
  652898
  653215
  714431
  570310
  597987
  623175
  591747
  729176
  753435
  753456
  643602
  571904
  541686
  561653
  616046
  800562
  769765
  466196
  550236
  574910
  575798
  561844
  578361
  584706
  588878
  598554
  597017
  424129
  402746
  454625
  524502
  581617
  558247
  677338
  721394
  722222
  579024
  747454
  722535
  552131
  570494
  575566
  552091
  543577
  552514
  575475
  665642
  665771
  652179
  652923
  570199
  572816
  595512
  614935
  644670
  604350
  622765
  598584
  608015
  623406
  725390
  736101
  428052
  820410
  677367
  679051
  721366
  722542
  677343
  598508
  758984
  755178
  753155
  620785
  635902
  539559
  541303
  652978
  600128
  598084
  560645
  561621
  574540
  575770
  677356
  560478
]
2.56 ms
(0.42%)
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
  402746
  424129
  428052
  447530
  454625
  466196
  524502
  539559
  541303
  541686
  543577
  549782
  550236
  552091
  552131
  552514
  554215
  558247
  560038
  560478
  560645
  561621
  561653
  561668
  561844
  561880
  565327
  565614
  567735
  568897
  570135
  570199
  570310
  570469
  570494
  571904
  572816
  573078
  573083
  574540
  574848
  574910
  575475
  575566
  575770
  575798
  578361
  579024
  581617
  584706
  588878
  591747
  592418
  595418
  595512
  596594
  597017
  597059
  597073
  597951
  597969
  597987
  598084
  598508
  598554
  598584
  600128
  604350
  608015
  609645
  614935
  616046
  620785
  622765
  623175
  623406
  635902
  641737
  643602
  644670
  652179
  652612
  652898
  652923
  652939
  652978
  653215
  653229
  655346
  659324
  665642
  665771
  677338
  677339
  677343
  677356
  677367
  679051
  714431
  718638
  721366
  721394
  722222
  722535
  722542
  722621
  725390
  727669
  729176
  736101
  747447
  747454
  753155
  753435
  753456
  755178
  758984
  769765
  800562
  820410
]
1.72 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал butt"
]
1.50 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal butt"
]

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.