Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.21 ms
(84.63%)
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
  388724
  399255
  400903
  401142
  422557
  422959
  428012
  444935
  448927
  466936
  470839
  473112
  477258
  499866
  509473
  515101
  515207
  515220
  522587
  529298
  532153
  544708
  548064
  549289
  549377
  549933
  549994
  550623
  552534
  558002
  560375
  560480
  562100
  564000
  564681
  571219
  571481
  575514
  576380
  577515
  579668
  586465
  586582
  590250
  597052
  597072
  597965
  604068
  607215
  610657
  611933
  621288
  621436
  624216
  632835
  643653
  644078
  646208
  656761
  657325
  658631
  665123
  668894
  671598
  671644
  674400
  676942
  681699
  681848
  684342
  689311
  692386
  698044
  701309
  702624
  706899
  713526
  714441
  714822
  719716
  720786
  721447
  723439
  734850
  742209
  743063
  744612
  745999
  748675
  750465
  759326
  760222
  762718
  769786
  779860
  787950
  788805
  797915
  798329
  799008
  802596
  803183
  805197
  809705
  814128
  816503
  820650
  820993
  821120
  821184
  821373
  821418
  821423
  821836
  823000
  823309
  823326
  825467
  825499
  825781
]
15.56 ms
(9.39%)
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
  448927
  515220
  515207
  509473
  529298
  549377
  560375
  577515
  550623
  571481
  552534
  558002
  560480
  564000
  656761
  671598
  684342
  689311
  714822
  674400
  681699
  713526
  714441
  720786
  665123
  721447
  549933
  571219
  643653
  604068
  597072
  632835
  788805
  769786
  787950
  759326
  734850
  745999
  742209
  750465
  607215
  702624
  706899
  797915
  803183
  466936
  422959
  400903
  499866
  515101
  522587
  388724
  428012
  821120
  821836
  820993
  823000
  825467
  825499
  532153
  549994
  549289
  562100
  544708
  564681
  646208
  681848
  719716
  723439
  657325
  658631
  671644
  676942
  668894
  692386
  698044
  701309
  548064
  579668
  597052
  621436
  624216
  586582
  590250
  597965
  610657
  621288
  644078
  779860
  798329
  760222
  802596
  809705
  748675
  762718
  743063
  744612
  611933
  799008
  805197
  477258
  473112
  444935
  575514
  576380
  586465
  470839
  399255
  401142
  422557
  821373
  814128
  820650
  821184
  823326
  825781
  816503
  821418
  821423
  823309
]
2.70 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
  388724
  399255
  400903
  401142
  422557
  422959
  428012
  444935
  448927
  466936
  470839
  473112
  477258
  499866
  509473
  515101
  515207
  515220
  522587
  529298
  532153
  544708
  548064
  549289
  549377
  549933
  549994
  550623
  552534
  558002
  560375
  560480
  562100
  564000
  564681
  571219
  571481
  575514
  576380
  577515
  579668
  586465
  586582
  590250
  597052
  597072
  597965
  604068
  607215
  610657
  611933
  621288
  621436
  624216
  632835
  643653
  644078
  646208
  656761
  657325
  658631
  665123
  668894
  671598
  671644
  674400
  676942
  681699
  681848
  684342
  689311
  692386
  698044
  701309
  702624
  706899
  713526
  714441
  714822
  719716
  720786
  721447
  723439
  734850
  742209
  743063
  744612
  745999
  748675
  750465
  759326
  760222
  762718
  769786
  779860
  787950
  788805
  797915
  798329
  799008
  802596
  803183
  805197
  809705
  814128
  816503
  820650
  820993
  821120
  821184
  821373
  821418
  821423
  821836
  823000
  823309
  823326
  825467
  825499
  825781
]
2.05 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young skinny fuck"
]
1.93 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young худые секс"
]
1.80 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young худые секс"
]
1.43 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.