Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.91 ms
(86.21%)
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
  389966
  390382
  397392
  400845
  401200
  411371
  418522
  419541
  421848
  421882
  421890
  422195
  422199
  422202
  422203
  422208
  422342
  424047
  424433
  424455
  424475
  429895
  429899
  433323
  439624
  439684
  439713
  439714
  439730
  439732
  439736
  439738
  439765
  439771
  439790
  439801
  439813
  439815
  443764
  443784
  444298
  444344
  444699
  450281
  451504
  452936
  452953
  453394
  453409
  454175
  454188
  454439
  454501
  455337
  457418
  457448
  457470
  457473
  463976
  464835
  465075
  465534
  465572
  465900
  466897
  467034
  470196
  470202
  470459
  473391
  478369
  481971
  482298
  483628
  484558
  484645
  485273
  485276
  485709
  489379
  493167
  493176
  494315
  506278
  507245
  509204
  510898
  521758
  525717
  526454
  526494
  526512
  526520
  526524
  528345
  533741
  536414
  536443
  537257
  537261
  539351
  539951
  556436
  560660
  563087
  564162
  565691
  567664
  586963
  587272
  590503
  608041
  622817
  625235
  668668
  700949
  742415
  758291
  766503
  766509
]
17.10 ms
(8.53%)
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
  464835
  465534
  470459
  453394
  509204
  526520
  526494
  536414
  536443
  485273
  526524
  484645
  528345
  452953
  397392
  564162
  565691
  586963
  625235
  400845
  439738
  439730
  422203
  444344
  457470
  454501
  439714
  481971
  506278
  485276
  758291
  525717
  533741
  590503
  421848
  429895
  419541
  439732
  444699
  450281
  539951
  668668
  587272
  422199
  444298
  482298
  439765
  465900
  418522
  470196
  439801
  452936
  454439
  465075
  439713
  439813
  483628
  489379
  493167
  494315
  507245
  484558
  526454
  439790
  411371
  766509
  766503
  742415
  463976
  443764
  470202
  422342
  424433
  443784
  563087
  422195
  478369
  389966
  401200
  439684
  457418
  467034
  424455
  439624
  439771
  457473
  424047
  465572
  439736
  537257
  526512
  537261
  493176
  510898
  421890
  608041
  556436
  622817
  454175
  485709
  539351
  390382
  422202
  453409
  466897
  473391
  421882
  429899
  422208
  454188
  439815
  433323
  457448
  567664
  560660
  700949
  451504
  424475
  455337
  521758
]
3.19 ms
(1.59%)
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
  389966
  390382
  397392
  400845
  401200
  411371
  418522
  419541
  421848
  421882
  421890
  422195
  422199
  422202
  422203
  422208
  422342
  424047
  424433
  424455
  424475
  429895
  429899
  433323
  439624
  439684
  439713
  439714
  439730
  439732
  439736
  439738
  439765
  439771
  439790
  439801
  439813
  439815
  443764
  443784
  444298
  444344
  444699
  450281
  451504
  452936
  452953
  453394
  453409
  454175
  454188
  454439
  454501
  455337
  457418
  457448
  457470
  457473
  463976
  464835
  465075
  465534
  465572
  465900
  466897
  467034
  470196
  470202
  470459
  473391
  478369
  481971
  482298
  483628
  484558
  484645
  485273
  485276
  485709
  489379
  493167
  493176
  494315
  506278
  507245
  509204
  510898
  521758
  525717
  526454
  526494
  526512
  526520
  526524
  528345
  533741
  536414
  536443
  537257
  537261
  539351
  539951
  556436
  560660
  563087
  564162
  565691
  567664
  586963
  587272
  590503
  608041
  622817
  625235
  668668
  700949
  742415
  758291
  766503
  766509
]
2.05 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал русское толстушк…"
]
1.87 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал русск полная"
]
1.81 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.82%)
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.