Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.50 ms
(87.27%)
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
  40927
  146414
  239808
  281380
  307633
  314397
  368536
  383326
  384847
  385782
  389882
  391559
  391600
  393496
  395498
  396192
  396225
  396584
  397648
  398010
  398281
  399378
  399639
  403050
  403086
  403151
  408998
  413296
  413484
  415200
  417813
  418430
  420478
  423333
  430132
  442555
  445026
  445737
  454072
  458840
  473775
  475873
  481625
  482730
  506144
  511648
  521942
  522650
  524353
  527488
  547203
  548604
  554472
  568524
  595978
  597599
  609812
  611948
  614950
  630583
  637582
  645915
  650096
  651875
  660108
  661709
  663917
  665373
  665763
  671060
  679228
  683604
  688129
  690329
  698120
  698614
  708454
  711850
  713331
  717233
  719274
  723687
  724205
  731657
  731880
  733523
  742458
  743818
  744270
  748192
  754438
  754844
  755409
  760426
  767843
  769872
  778987
  779848
  780226
  781434
  783776
  785277
  788496
  793753
  794001
  797669
  799371
  799613
  799819
  800119
  804577
  804879
  805939
  808351
  811968
  812435
  818725
  820649
  822203
  822883
]
11.98 ms
(6.99%)
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
  671060
  698120
  281380
  146414
  408998
  521942
  403151
  391559
  812435
  778987
  651875
  663917
  665373
  383326
  473775
  420478
  522650
  717233
  368536
  527488
  688129
  630583
  788496
  785277
  396225
  481625
  391600
  793753
  731880
  799613
  445026
  548604
  799371
  403050
  397648
  820649
  713331
  754438
  475873
  458840
  595978
  781434
  731657
  780226
  40927
  744270
  661709
  748192
  393496
  482730
  650096
  755409
  660108
  804879
  769872
  399378
  396192
  742458
  413296
  445737
  395498
  396584
  708454
  723687
  665763
  609812
  430132
  399639
  239808
  511648
  307633
  415200
  524353
  645915
  724205
  783776
  683604
  389882
  794001
  597599
  385782
  568524
  637582
  398010
  822203
  698614
  711850
  614950
  611948
  779848
  797669
  799819
  808351
  811968
  760426
  733523
  418430
  384847
  413484
  417813
  314397
  398281
  454072
  442555
  403086
  818725
  822883
  719274
  690329
  547203
  804577
  805939
  767843
  743818
  754844
  554472
  423333
  506144
  679228
  800119
]
3.14 ms
(1.83%)
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
  40927
  146414
  239808
  281380
  307633
  314397
  368536
  383326
  384847
  385782
  389882
  391559
  391600
  393496
  395498
  396192
  396225
  396584
  397648
  398010
  398281
  399378
  399639
  403050
  403086
  403151
  408998
  413296
  413484
  415200
  417813
  418430
  420478
  423333
  430132
  442555
  445026
  445737
  454072
  458840
  473775
  475873
  481625
  482730
  506144
  511648
  521942
  522650
  524353
  527488
  547203
  548604
  554472
  568524
  595978
  597599
  609812
  611948
  614950
  630583
  637582
  645915
  650096
  651875
  660108
  661709
  663917
  665373
  665763
  671060
  679228
  683604
  688129
  690329
  698120
  698614
  708454
  711850
  713331
  717233
  719274
  723687
  724205
  731657
  731880
  733523
  742458
  743818
  744270
  748192
  754438
  754844
  755409
  760426
  767843
  769872
  778987
  779848
  780226
  781434
  783776
  785277
  788496
  793753
  794001
  797669
  799371
  799613
  799819
  800119
  804577
  804879
  805939
  808351
  811968
  812435
  818725
  820649
  822203
  822883
]
2.03 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde girl blowjob"
]
1.67 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая девушк минет оральн секс"
]
1.56 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.84%)
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.