Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.76 ms
(86.45%)
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
  386853
  389790
  392111
  394543
  394586
  398643
  451042
  469764
  479074
  487282
  506321
  508180
  512949
  513511
  518164
  518642
  520753
  529597
  529599
  531840
  531861
  534758
  536979
  539018
  540969
  542346
  542992
  544748
  544773
  547961
  548455
  555257
  564554
  576175
  576918
  578737
  593848
  603658
  610811
  616632
  619574
  622065
  625558
  625713
  627412
  628602
  628618
  633602
  636510
  649615
  651310
  653028
  653612
  653807
  653880
  654097
  655247
  662415
  667922
  669298
  669681
  670719
  673942
  674515
  676416
  680215
  682986
  686183
  689558
  689949
  690609
  690749
  693788
  702342
  707570
  710360
  712634
  714122
  715743
  715750
  720576
  721872
  721903
  723889
  727434
  729216
  729376
  736107
  736778
  743888
  745326
  745924
  745927
  748895
  757372
  759156
  763934
  767501
  768347
  771038
  783379
  784326
  786589
  792487
  793200
  794307
  796652
  796683
  798798
  799944
  800243
  800381
  801928
  805780
  807560
  817192
  817334
  818932
  823447
  827915
]
12.58 ms
(7.62%)
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
  534758
  531861
  547961
  564554
  710360
  720576
  576918
  633602
  793200
  800243
  783379
  798798
  807560
  736107
  745326
  759156
  745924
  745927
  714122
  518642
  712634
  689949
  636510
  578737
  727434
  674515
  386853
  673942
  693788
  662415
  669298
  653880
  682986
  689558
  616632
  628602
  622065
  603658
  628618
  593848
  619574
  627412
  792487
  394543
  398643
  817334
  823447
  513511
  529599
  529597
  531840
  715743
  686183
  786589
  801928
  796652
  796683
  723889
  771038
  763934
  702342
  784326
  667922
  520753
  743888
  451042
  653612
  817192
  539018
  542346
  653807
  715750
  576175
  548455
  729376
  818932
  540969
  653028
  655247
  676416
  680215
  721903
  555257
  794307
  805780
  768347
  799944
  736778
  748895
  767501
  721872
  800381
  487282
  649615
  625558
  690609
  690749
  757372
  469764
  506321
  518164
  508180
  654097
  827915
  536979
  544748
  670719
  651310
  707570
  669681
  610811
  729216
  512949
  544773
  625713
  389790
  479074
  542992
  394586
  392111
]
3.17 ms
(1.92%)
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
  386853
  389790
  392111
  394543
  394586
  398643
  451042
  469764
  479074
  487282
  506321
  508180
  512949
  513511
  518164
  518642
  520753
  529597
  529599
  531840
  531861
  534758
  536979
  539018
  540969
  542346
  542992
  544748
  544773
  547961
  548455
  555257
  564554
  576175
  576918
  578737
  593848
  603658
  610811
  616632
  619574
  622065
  625558
  625713
  627412
  628602
  628618
  633602
  636510
  649615
  651310
  653028
  653612
  653807
  653880
  654097
  655247
  662415
  667922
  669298
  669681
  670719
  673942
  674515
  676416
  680215
  682986
  686183
  689558
  689949
  690609
  690749
  693788
  702342
  707570
  710360
  712634
  714122
  715743
  715750
  720576
  721872
  721903
  723889
  727434
  729216
  729376
  736107
  736778
  743888
  745326
  745924
  745927
  748895
  757372
  759156
  763934
  767501
  768347
  771038
  783379
  784326
  786589
  792487
  793200
  794307
  796652
  796683
  798798
  799944
  800243
  800381
  801928
  805780
  807560
  817192
  817334
  818932
  823447
  827915
]
1.81 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur wife double"
]
1.77 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жен double"
]
1.56 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск жен double"
]

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.