Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.22 ms
(87.97%)
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
  187847
  358453
  396568
  413518
  414125
  415143
  416365
  417080
  418121
  419599
  421471
  421974
  424200
  428583
  430393
  430526
  434371
  441004
  442629
  447671
  451112
  454524
  463764
  467886
  468149
  469514
  472581
  472611
  474699
  476295
  477068
  478462
  482532
  485363
  502866
  512219
  523994
  530481
  533594
  538870
  541394
  543846
  547453
  547465
  547475
  547486
  547501
  547890
  548153
  550925
  554271
  554851
  554866
  561019
  562961
  563533
  565164
  566684
  568560
  569919
  571035
  577344
  580207
  580653
  583501
  583739
  585968
  586975
  589208
  599872
  600314
  601542
  606185
  606618
  606633
  607296
  608122
  610040
  614935
  615946
  617825
  623608
  624197
  627338
  635450
  660369
  660405
  660412
  666016
  668690
  669016
  669017
  669056
  670366
  671002
  671038
  672138
  672925
  672942
  672952
  702463
  725553
  741541
  752656
  752687
  758141
  766669
  785934
  786115
  806947
  815062
  815087
  815093
  815094
  815126
  818613
  820542
  827259
  827829
  828380
]
19.54 ms
(8.21%)
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
  543846
  565164
  550925
  671002
  669016
  606618
  585968
  623608
  758141
  752656
  617825
  702463
  562961
  600314
  607296
  752687
  476295
  478462
  571035
  441004
  538870
  554866
  554271
  635450
  815087
  815062
  828380
  512219
  523994
  533594
  541394
  547465
  547475
  547501
  561019
  566684
  577344
  580653
  547453
  568560
  580207
  660369
  672138
  672952
  668690
  671038
  672942
  610040
  586975
  589208
  601542
  606633
  614935
  624197
  615946
  785934
  806947
  725553
  741541
  608122
  430393
  187847
  447671
  485363
  530481
  670366
  599872
  358453
  463764
  430526
  827829
  472581
  672925
  606185
  396568
  419599
  482532
  474699
  472611
  468149
  421471
  627338
  827259
  766669
  414125
  477068
  428583
  418121
  442629
  451112
  454524
  469514
  547890
  569919
  467886
  434371
  502866
  416365
  424200
  421974
  413518
  547486
  554851
  583739
  563533
  583501
  548153
  660405
  660412
  669056
  666016
  669017
  786115
  417080
  415143
  815126
  820542
  815093
  815094
  818613
]
2.59 ms
(1.09%)
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
  187847
  358453
  396568
  413518
  414125
  415143
  416365
  417080
  418121
  419599
  421471
  421974
  424200
  428583
  430393
  430526
  434371
  441004
  442629
  447671
  451112
  454524
  463764
  467886
  468149
  469514
  472581
  472611
  474699
  476295
  477068
  478462
  482532
  485363
  502866
  512219
  523994
  530481
  533594
  538870
  541394
  543846
  547453
  547465
  547475
  547486
  547501
  547890
  548153
  550925
  554271
  554851
  554866
  561019
  562961
  563533
  565164
  566684
  568560
  569919
  571035
  577344
  580207
  580653
  583501
  583739
  585968
  586975
  589208
  599872
  600314
  601542
  606185
  606618
  606633
  607296
  608122
  610040
  614935
  615946
  617825
  623608
  624197
  627338
  635450
  660369
  660405
  660412
  666016
  668690
  669016
  669017
  669056
  670366
  671002
  671038
  672138
  672925
  672942
  672952
  702463
  725553
  741541
  752656
  752687
  758141
  766669
  785934
  786115
  806947
  815062
  815087
  815093
  815094
  815126
  818613
  820542
  827259
  827829
  828380
]
1.88 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая мам анал"
]
1.53 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая мам анал"
]
1.49 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худые мамы anal"
]

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.