Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.80 ms
(83.54%)
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
  7365
  37057
  46186
  150507
  324183
  338149
  383477
  390024
  392238
  395895
  396069
  396708
  397980
  398388
  399016
  404272
  405054
  405178
  407444
  408439
  408460
  408462
  414364
  414368
  414448
  416351
  421200
  423654
  429766
  429775
  437519
  443994
  453747
  458920
  459229
  468344
  470427
  476138
  477464
  491272
  497901
  512453
  514139
  524193
  531699
  541668
  564184
  566816
  583540
  586933
  588606
  617411
  617417
  630030
  630160
  640807
  654974
  655719
  656321
  658826
  669403
  671628
  681312
  683875
  683932
  685633
  690450
  690885
  691509
  695242
  697607
  699451
  700678
  704179
  707738
  711281
  712782
  715090
  719950
  720123
  720386
  720780
  720827
  721870
  725171
  725606
  728152
  729160
  729247
  738241
  740637
  743165
  744593
  750277
  750290
  755588
  768198
  771146
  778038
  780601
  780662
  796899
  796904
  799126
  803669
  805277
  806198
  810700
  815910
  817062
  817163
  818439
  822421
  824938
  825955
  826176
  826287
  827434
  827852
]
14.82 ms
(9.84%)
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
  408460
  396069
  383477
  338149
  397980
  683932
  630030
  799126
  738241
  390024
  405054
  407444
  497901
  429775
  512453
  404272
  640807
  416351
  491272
  617417
  429766
  443994
  477464
  396708
  476138
  617411
  453747
  531288
  681312
  658826
  588606
  750290
  728152
  768198
  468344
  541668
  671628
  712782
  719950
  398388
  690450
  707738
  720386
  778038
  725606
  743165
  803669
  408462
  150507
  683875
  796904
  755588
  740637
  729160
  826176
  827852
  817062
  817163
  654974
  720780
  685633
  630160
  810700
  750277
  805277
  700678
  711281
  780601
  780662
  395895
  421200
  423654
  586933
  825955
  414368
  715090
  720827
  7365
  514139
  697607
  564184
  704179
  583540
  796899
  458920
  37057
  824938
  690885
  725171
  392238
  414364
  818439
  524193
  669403
  720123
  744593
  721870
  806198
  470427
  405178
  414448
  408439
  656321
  46186
  459229
  437519
  399016
  324183
  822421
  815910
  826287
  827434
  531699
  566816
  695242
  655719
  691509
  699451
  729247
  771146
]
3.00 ms
(1.99%)
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
  7365
  37057
  46186
  150507
  324183
  338149
  383477
  390024
  392238
  395895
  396069
  396708
  397980
  398388
  399016
  404272
  405054
  405178
  407444
  408439
  408460
  408462
  414364
  414368
  414448
  416351
  421200
  423654
  429766
  429775
  437519
  443994
  453747
  458920
  459229
  468344
  470427
  476138
  477464
  491272
  497901
  512453
  514139
  524193
  531699
  541668
  564184
  566816
  583540
  586933
  588606
  617411
  617417
  630030
  630160
  640807
  654974
  655719
  656321
  658826
  669403
  671628
  681312
  683875
  683932
  685633
  690450
  690885
  691509
  695242
  697607
  699451
  700678
  704179
  707738
  711281
  712782
  715090
  719950
  720123
  720386
  720780
  720827
  721870
  725171
  725606
  728152
  729160
  729247
  738241
  740637
  743165
  744593
  750277
  750290
  755588
  768198
  771146
  778038
  780601
  780662
  796899
  796904
  799126
  803669
  805277
  806198
  810700
  815910
  817062
  817163
  818439
  822421
  824938
  825955
  826176
  826287
  827434
  827852
]
2.29 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial anal sex"
]
1.73 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов анал секс"
]
1.38 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.