Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.57 ms
(83.55%)
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
  400885
  404071
  408810
  462905
  464619
  469193
  486144
  528624
  537552
  549292
  564210
  569857
  572210
  587502
  612460
  656957
  662896
  663433
  679309
  686088
  693432
  697719
  699703
  718557
  721251
  723966
  724434
  728886
  729989
  730651
  731230
  733223
  733280
  734351
  734369
  740064
  742456
  744156
  744814
  744826
  745901
  747490
  750607
  756313
  758620
  759794
  761253
  761480
  766552
  767331
  767560
  772572
  772599
  773349
  773357
  773376
  775568
  775644
  775659
  780291
  782765
  782768
  790027
  791789
  792218
  792295
  792305
  793317
  793675
  793806
  794146
  795668
  800017
  800058
  800078
  801189
  802391
  802428
  804395
  806286
  810861
  811722
  812323
  815766
  816397
  817675
  819014
  819388
  819445
  819986
  820315
  823748
  823860
  824085
  824693
  824826
  824956
  825153
  825158
  825775
  826079
  826169
  826380
  826381
  826382
  826408
  826456
  826541
  826651
  826724
  826773
  826889
  826979
  827121
  827191
  827267
  827300
  827483
  827577
  828514
]
14.08 ms
(9.44%)
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
  790027
  802391
  802428
  806286
  730651
  756313
  815766
  824085
  697719
  718557
  800058
  759794
  767560
  464619
  662896
  823860
  804395
  569857
  827483
  819445
  612460
  795668
  767331
  724434
  745901
  772599
  723966
  758620
  729989
  721251
  791789
  462905
  408810
  469193
  826541
  826651
  823748
  819388
  486144
  775659
  731230
  747490
  400885
  819014
  826380
  826079
  826724
  824693
  826381
  826889
  827300
  824956
  825775
  826169
  828514
  537552
  564210
  656957
  663433
  699703
  679309
  782765
  734351
  761480
  773376
  766552
  793675
  801189
  404071
  817675
  824826
  825153
  826456
  826408
  820315
  825158
  826382
  826773
  827121
  827191
  827267
  827577
  816397
  819986
  826979
  528624
  572210
  686088
  693432
  549292
  587502
  780291
  782768
  792305
  793806
  794146
  775568
  775644
  792295
  793317
  811722
  812323
  733280
  740064
  742456
  744156
  744814
  750607
  761253
  772572
  773349
  773357
  792218
  800017
  800078
  810861
  728886
  733223
  734369
  744826
]
2.92 ms
(1.96%)
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
  400885
  404071
  408810
  462905
  464619
  469193
  486144
  528624
  537552
  549292
  564210
  569857
  572210
  587502
  612460
  656957
  662896
  663433
  679309
  686088
  693432
  697719
  699703
  718557
  721251
  723966
  724434
  728886
  729989
  730651
  731230
  733223
  733280
  734351
  734369
  740064
  742456
  744156
  744814
  744826
  745901
  747490
  750607
  756313
  758620
  759794
  761253
  761480
  766552
  767331
  767560
  772572
  772599
  773349
  773357
  773376
  775568
  775644
  775659
  780291
  782765
  782768
  790027
  791789
  792218
  792295
  792305
  793317
  793675
  793806
  794146
  795668
  800017
  800058
  800078
  801189
  802391
  802428
  804395
  806286
  810861
  811722
  812323
  815766
  816397
  817675
  819014
  819388
  819445
  819986
  820315
  823748
  823860
  824085
  824693
  824826
  824956
  825153
  825158
  825775
  826079
  826169
  826380
  826381
  826382
  826408
  826456
  826541
  826651
  826724
  826773
  826889
  826979
  827121
  827191
  827267
  827300
  827483
  827577
  828514
]
2.27 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck pussy"
]
1.97 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс pussy"
]
1.67 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.09%)
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.