Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.88 ms
(83.79%)
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
  7065
  7295
  150820
  187789
  187800
  187851
  187960
  187996
  188335
  188462
  188560
  382295
  382444
  384124
  385999
  386189
  387510
  387856
  391237
  392208
  393135
  395465
  398545
  401268
  403322
  403324
  403911
  405830
  406018
  408188
  408240
  409932
  413460
  413467
  439634
  439806
  439856
  440996
  442814
  460912
  465892
  466015
  466244
  466801
  470424
  483656
  486542
  497701
  499359
  518763
  526745
  536213
  557572
  573918
  591333
  591877
  593842
  601930
  605008
  630096
  663461
  681290
  698496
  706888
  709528
  710529
  715372
  718576
  720121
  725197
  726731
  727503
  727578
  727732
  727754
  727787
  728083
  728228
  730360
  731836
  733454
  736196
  739927
  742433
  742749
  744989
  744994
  746692
  759946
  761275
  765391
  768330
  770113
  774171
  777250
  780679
  788543
  788554
  795867
  796252
  799971
  800432
  800597
  800633
  802152
  802195
  806084
  807600
  808052
  808456
  810774
  811475
  814933
  817347
  818630
  819480
  823806
  824168
  825420
  826655
]
16.37 ms
(9.15%)
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
  817347
  726731
  802152
  605008
  807600
  401268
  398545
  408240
  403324
  393135
  819480
  744989
  774171
  765391
  770113
  698496
  808052
  406018
  518763
  718576
  810774
  384124
  409932
  593842
  413460
  439634
  7295
  150820
  715372
  709528
  706888
  796252
  739927
  731836
  736196
  742749
  802195
  591333
  536213
  187789
  823806
  728228
  742433
  800633
  188335
  466015
  601930
  733454
  413467
  720121
  188560
  395465
  727732
  727787
  391237
  795867
  814933
  788543
  439856
  442814
  440996
  439806
  818630
  808456
  382444
  386189
  630096
  392208
  825420
  826655
  777250
  727754
  387510
  465892
  187851
  663461
  799971
  408188
  497701
  800597
  728083
  768330
  780679
  385999
  499359
  187996
  7065
  681290
  710529
  800432
  727503
  746692
  730360
  727578
  788554
  725197
  188462
  403911
  824168
  382295
  466801
  486542
  557572
  573918
  806084
  811475
  761275
  759946
  187960
  387856
  460912
  405830
  466244
  483656
  526745
  591877
  744994
  403322
  187800
  470424
]
4.75 ms
(2.66%)
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
  7065
  7295
  150820
  187789
  187800
  187851
  187960
  187996
  188335
  188462
  188560
  382295
  382444
  384124
  385999
  386189
  387510
  387856
  391237
  392208
  393135
  395465
  398545
  401268
  403322
  403324
  403911
  405830
  406018
  408188
  408240
  409932
  413460
  413467
  439634
  439806
  439856
  440996
  442814
  460912
  465892
  466015
  466244
  466801
  470424
  483656
  486542
  497701
  499359
  518763
  526745
  536213
  557572
  573918
  591333
  591877
  593842
  601930
  605008
  630096
  663461
  681290
  698496
  706888
  709528
  710529
  715372
  718576
  720121
  725197
  726731
  727503
  727578
  727732
  727754
  727787
  728083
  728228
  730360
  731836
  733454
  736196
  739927
  742433
  742749
  744989
  744994
  746692
  759946
  761275
  765391
  768330
  770113
  774171
  777250
  780679
  788543
  788554
  795867
  796252
  799971
  800432
  800597
  800633
  802152
  802195
  806084
  807600
  808052
  808456
  810774
  811475
  814933
  817347
  818630
  819480
  823806
  824168
  825420
  826655
]
2.21 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anal sex"
]
2.01 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анал секс"
]
1.86 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анал секс"
]
1.79 ms
(1.00%)
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.