Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.01 ms
(88.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
  6782
  391893
  392032
  392048
  392065
  392206
  393615
  399000
  401939
  402723
  408679
  411574
  417319
  426361
  432391
  432414
  432471
  432481
  432542
  432598
  432897
  433373
  439886
  441472
  443902
  444197
  444574
  447642
  448521
  454136
  458456
  464738
  465773
  466974
  495559
  500065
  500313
  510419
  510631
  511822
  517223
  529606
  531016
  537959
  538371
  543728
  544186
  546294
  551051
  574911
  576145
  582697
  595456
  597522
  598052
  598577
  598746
  619042
  646647
  661933
  671197
  680391
  685409
  685417
  691405
  691758
  692646
  696537
  719555
  719991
  722964
  733798
  735401
  736739
  737012
  748801
  752051
  754258
  754630
  760389
  763407
  763416
  764265
  766287
  766303
  766479
  768867
  769052
  774649
  777575
  777950
  778084
  779418
  779665
  780509
  787452
  788356
  789896
  792433
  794889
  797390
  800458
  801449
  807307
  807312
  811925
  816247
  823740
  825716
  826802
  827221
  827429
  828449
  828663
  828664
  828770
  828785
]
11.35 ms
(5.81%)
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
  828664
  797390
  777575
  777950
  792433
  807307
  807312
  735401
  754258
  763416
  766287
  766303
  774649
  399000
  401939
  787452
  392206
  411574
  6782
  392065
  828449
  828663
  778084
  800458
  801449
  691758
  719555
  597522
  595456
  598577
  598746
  598052
  788356
  752051
  722964
  517223
  531016
  544186
  661933
  576145
  790453
  392032
  444197
  543728
  393615
  448521
  426361
  464738
  392048
  466974
  454136
  391893
  816247
  432414
  432598
  671197
  691405
  619042
  791935
  443902
  432391
  433373
  510419
  825716
  826802
  827221
  823740
  828770
  828785
  827429
  529606
  692646
  719991
  789896
  779418
  780509
  794889
  811925
  733798
  754630
  763407
  736739
  760389
  744999
  764265
  737012
  766479
  769052
  748801
  768867
  779665
  441472
  439886
  696537
  417319
  432542
  444574
  447642
  465773
  500313
  582697
  402723
  408679
  495559
  511822
  510631
  432471
  432897
  432481
  458456
  538371
  500065
  537959
  546294
  551051
  574911
  646647
  680391
  685409
  685417
]
3.12 ms
(1.60%)
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
  6782
  391893
  392032
  392048
  392065
  392206
  393615
  399000
  401939
  402723
  408679
  411574
  417319
  426361
  432391
  432414
  432471
  432481
  432542
  432598
  432897
  433373
  439886
  441472
  443902
  444197
  444574
  447642
  448521
  454136
  458456
  464738
  465773
  466974
  495559
  500065
  500313
  510419
  510631
  511822
  517223
  529606
  531016
  537959
  538371
  543728
  544186
  546294
  551051
  574911
  576145
  582697
  595456
  597522
  598052
  598577
  598746
  619042
  646647
  661933
  671197
  680391
  685409
  685417
  691405
  691758
  692646
  696537
  719555
  719991
  722964
  733798
  735401
  736739
  737012
  748801
  752051
  754258
  754630
  760389
  763407
  763416
  764265
  766287
  766303
  766479
  768867
  769052
  774649
  777575
  777950
  778084
  779418
  779665
  780509
  787452
  788356
  789896
  792433
  794889
  797390
  800458
  801449
  807307
  807312
  811925
  816247
  823740
  825716
  826802
  827221
  827429
  828449
  828663
  828664
  828770
  828785
]
2.58 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen russian amateur"
]
1.63 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen русск любительск"
]
1.59 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen русск любительск"
]

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.