Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.36 ms
(88.81%)
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
  725269
  731370
  732093
  736163
  736340
  736725
  736812
  736833
  736903
  737858
  737866
  738278
  739805
  740228
  740270
  740520
  741225
  742823
  743094
  744770
  744796
  745295
  745484
  746711
  748511
  749074
  749085
  749591
  749696
  749885
  750357
  750371
  751020
  751342
  752074
  752440
  753004
  754153
  754423
  754598
  755045
  756492
  758018
  758508
  758525
  758664
  759068
  759338
  761246
  764791
  768471
  769097
  770811
  770880
  776823
  778730
  781024
  782092
  782100
  782523
  782590
  782656
  782950
  783183
  783255
  783835
  784547
  784645
  784660
  784985
  785095
  785221
  785296
  786069
  786285
  786336
  786864
  787163
  787238
  787813
  790414
  791882
  791888
  791890
  791920
  792458
  793092
  793108
  795401
  795405
  796367
  796370
  796386
  796390
  796411
  798331
  798455
  800648
  801830
  802279
  804806
  805253
  805394
  805480
  806515
  807024
  807242
  808125
  809555
  810073
  810141
  810163
  810514
  810958
  811573
  812231
  812249
  812252
  812474
  813341
]
12.06 ms
(5.94%)
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
  790414
  791882
  791890
  792458
  796390
  796411
  801830
  804806
  806515
  807024
  810514
  812474
  813341
  776823
  778730
  781024
  782100
  782590
  782656
  782950
  783835
  784547
  785221
  785296
  786069
  786864
  787163
  787813
  791888
  791920
  793108
  795401
  795405
  796367
  796386
  798331
  798455
  802279
  805394
  805480
  807242
  810073
  810958
  812252
  732093
  736725
  736903
  737866
  740520
  741225
  742823
  743094
  744770
  745484
  746711
  749074
  749085
  749591
  750357
  750371
  752074
  752440
  754153
  758508
  761246
  770880
  782092
  782523
  783183
  783255
  784645
  784660
  784985
  785095
  786285
  786336
  787238
  793092
  796370
  800648
  805253
  808125
  809555
  810141
  810163
  811573
  812231
  812249
  725269
  731370
  736163
  736340
  736833
  737858
  740228
  744796
  745295
  748511
  749696
  749885
  751020
  751342
  756492
  758664
  759068
  759338
  764791
  768471
  770811
  736812
  738278
  739805
  740270
  753004
  754423
  754598
  755045
  758018
  758525
  769097
]
2.92 ms
(1.44%)
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
  725269
  731370
  732093
  736163
  736340
  736725
  736812
  736833
  736903
  737858
  737866
  738278
  739805
  740228
  740270
  740520
  741225
  742823
  743094
  744770
  744796
  745295
  745484
  746711
  748511
  749074
  749085
  749591
  749696
  749885
  750357
  750371
  751020
  751342
  752074
  752440
  753004
  754153
  754423
  754598
  755045
  756492
  758018
  758508
  758525
  758664
  759068
  759338
  761246
  764791
  768471
  769097
  770811
  770880
  776823
  778730
  781024
  782092
  782100
  782523
  782590
  782656
  782950
  783183
  783255
  783835
  784547
  784645
  784660
  784985
  785095
  785221
  785296
  786069
  786285
  786336
  786864
  787163
  787238
  787813
  790414
  791882
  791888
  791890
  791920
  792458
  793092
  793108
  795401
  795405
  796367
  796370
  796386
  796390
  796411
  798331
  798455
  800648
  801830
  802279
  804806
  805253
  805394
  805480
  806515
  807024
  807242
  808125
  809555
  810073
  810141
  810163
  810514
  810958
  811573
  812231
  812249
  812252
  812474
  813341
]
2.27 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy solo"
]
1.96 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy соло"
]
1.85 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy соло"
]

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.