Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.50 ms
(87.42%)
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
  80332
  95788
  96933
  97231
  241603
  346150
  346188
  384923
  386336
  386535
  386567
  388094
  389519
  389791
  390305
  390746
  390956
  391326
  391978
  392477
  392721
  392817
  393743
  393765
  394004
  394597
  395472
  396568
  396701
  396780
  397027
  397739
  398384
  398715
  400592
  402032
  403060
  404212
  404470
  409795
  411744
  411820
  414271
  415313
  418351
  421264
  423428
  441849
  442157
  445406
  470020
  476296
  478779
  491368
  492484
  515559
  526223
  528939
  531268
  532658
  532741
  534386
  534567
  534664
  538253
  539239
  543389
  544835
  550264
  550929
  556331
  556476
  560417
  561273
  597251
  597275
  605378
  619281
  620487
  626399
  629832
  631209
  633444
  634161
  639810
  647979
  666549
  666897
  668537
  674087
  677986
  678066
  678067
  678144
  678600
  680179
  693502
  704352
  719765
  723094
  725627
  731200
  735345
  744163
  747151
  757061
  757905
  770117
  773885
  780040
  782091
  788093
  792395
  800031
  801925
  802297
  809225
  811926
  812562
]
11.87 ms
(6.59%)
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
  811926
  780040
  792395
  731200
  788093
  762121
  770117
  773885
  725627
  757061
  723094
  801925
  812562
  391978
  402032
  384923
  398384
  411744
  392721
  392817
  397739
  404470
  704352
  241603
  394597
  390956
  391326
  396701
  396780
  396568
  397027
  409795
  421264
  442157
  411820
  423428
  445406
  492484
  491368
  515559
  476296
  556331
  556476
  543389
  693502
  719765
  668537
  680179
  619281
  597251
  634161
  597275
  809225
  800031
  747151
  757905
  393765
  441849
  386535
  393743
  526223
  647979
  639810
  631209
  560417
  802297
  398715
  400592
  418351
  538253
  550929
  674087
  550264
  620487
  403060
  390746
  96933
  404212
  470020
  80332
  414271
  478779
  534386
  561273
  544835
  626399
  605378
  782091
  389519
  528939
  539239
  532741
  534567
  534664
  532658
  678067
  678144
  677986
  666549
  666897
  678066
  633444
  531268
  735345
  744163
  678600
  629832
  386336
  386567
  394004
  392477
  395472
  346150
  346188
  97231
  95788
  389791
  388094
  390305
  415313
]
2.95 ms
(1.64%)
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
  80332
  95788
  96933
  97231
  241603
  346150
  346188
  384923
  386336
  386535
  386567
  388094
  389519
  389791
  390305
  390746
  390956
  391326
  391978
  392477
  392721
  392817
  393743
  393765
  394004
  394597
  395472
  396568
  396701
  396780
  397027
  397739
  398384
  398715
  400592
  402032
  403060
  404212
  404470
  409795
  411744
  411820
  414271
  415313
  418351
  421264
  423428
  441849
  442157
  445406
  470020
  476296
  478779
  491368
  492484
  515559
  526223
  528939
  531268
  532658
  532741
  534386
  534567
  534664
  538253
  539239
  543389
  544835
  550264
  550929
  556331
  556476
  560417
  561273
  597251
  597275
  605378
  619281
  620487
  626399
  629832
  631209
  633444
  634161
  639810
  647979
  666549
  666897
  668537
  674087
  677986
  678066
  678067
  678144
  678600
  680179
  693502
  704352
  719765
  723094
  725627
  731200
  735345
  744163
  747151
  757061
  757905
  770117
  773885
  780040
  782091
  788093
  792395
  800031
  801925
  802297
  809225
  811926
  812562
]
2.30 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончает жестко"
]
2.00 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм хардкор"
]
1.66 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.