Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.27 ms
(84.99%)
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
  210768
  388436
  406881
  409143
  422488
  424153
  428334
  429901
  440890
  444928
  445930
  446534
  447656
  448375
  453773
  456530
  457776
  458013
  469644
  470273
  471664
  474283
  474969
  477742
  478088
  478464
  478774
  493571
  535508
  537393
  540478
  542173
  551164
  558718
  568251
  569981
  576671
  577381
  588507
  599400
  612039
  614434
  619012
  620234
  626291
  626292
  628111
  628171
  630279
  630435
  631187
  633238
  642029
  642697
  644296
  659009
  662916
  672145
  685479
  686152
  690865
  693051
  694222
  695993
  703547
  706930
  707497
  712567
  714036
  717834
  720444
  720445
  721103
  722190
  722212
  723549
  735130
  748982
  751510
  752759
  760055
  761155
  761193
  761466
  763396
  770532
  773324
  773907
  776320
  784419
  784567
  788030
  792246
  793182
  793185
  794331
  798344
  799002
  799362
  800288
  800492
  802412
  805935
  806057
  807994
  810402
  810769
  810945
  812979
  814434
  815071
  815142
  815165
  816602
  817169
  818828
  819119
  819490
  823584
  826020
]
14.55 ms
(9.14%)
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
  588507
  628111
  642029
  776320
  798344
  802412
  793185
  800288
  800492
  810402
  748982
  760055
  761466
  810945
  752759
  773324
  751510
  620234
  626291
  626292
  642697
  644296
  703547
  717834
  784419
  793182
  799002
  799362
  807994
  810769
  424153
  456530
  474969
  493571
  388436
  406881
  440890
  469644
  445930
  457776
  478088
  577381
  714036
  630435
  806057
  784567
  788030
  812979
  444928
  478464
  471664
  474283
  422488
  470273
  614434
  458013
  599400
  540478
  662916
  628171
  817169
  723549
  816602
  819119
  823584
  826020
  815071
  815165
  819490
  815142
  818828
  535508
  537393
  542173
  558718
  576671
  659009
  693051
  694222
  712567
  720444
  722212
  672145
  686152
  690865
  695993
  706930
  720445
  722190
  568251
  633238
  630279
  631187
  792246
  773907
  805935
  735130
  761155
  761193
  763396
  770532
  707497
  794331
  428334
  814434
  478774
  551164
  721103
  429901
  569981
  619012
  612039
  448375
  446534
  477742
  453773
  447656
  685479
  409143
  210768
]
2.66 ms
(1.67%)
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
  210768
  388436
  406881
  409143
  422488
  424153
  428334
  429901
  440890
  444928
  445930
  446534
  447656
  448375
  453773
  456530
  457776
  458013
  469644
  470273
  471664
  474283
  474969
  477742
  478088
  478464
  478774
  493571
  535508
  537393
  540478
  542173
  551164
  558718
  568251
  569981
  576671
  577381
  588507
  599400
  612039
  614434
  619012
  620234
  626291
  626292
  628111
  628171
  630279
  630435
  631187
  633238
  642029
  642697
  644296
  659009
  662916
  672145
  685479
  686152
  690865
  693051
  694222
  695993
  703547
  706930
  707497
  712567
  714036
  717834
  720444
  720445
  721103
  722190
  722212
  723549
  735130
  748982
  751510
  752759
  760055
  761155
  761193
  761466
  763396
  770532
  773324
  773907
  776320
  784419
  784567
  788030
  792246
  793182
  793185
  794331
  798344
  799002
  799362
  800288
  800492
  802412
  805935
  806057
  807994
  810402
  810769
  810945
  812979
  814434
  815071
  815142
  815165
  816602
  817169
  818828
  819119
  819490
  823584
  826020
]
1.80 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public cuckold anal"
]
1.62 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц куколд анал"
]
1.51 ms
(0.95%)
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.