Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.72 ms
(87.86%)
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
  131772
  396796
  398524
  450108
  450125
  454176
  459406
  459949
  462099
  466374
  466394
  466699
  466902
  469906
  470768
  471461
  473400
  474113
  474261
  477936
  492992
  496854
  506516
  507263
  509192
  509659
  510945
  523380
  527624
  527773
  531869
  534563
  544489
  547868
  550222
  557896
  558175
  571132
  572350
  589622
  590525
  615950
  626889
  687666
  698249
  698253
  698255
  706889
  715370
  717697
  724475
  725201
  725251
  725462
  726596
  726837
  728146
  728597
  730186
  732901
  733060
  733109
  733132
  733473
  734725
  734730
  734848
  735908
  735925
  735981
  738339
  740986
  746200
  747245
  761011
  787654
  789686
  790327
  790330
  790336
  790840
  793488
  794156
  794745
  795055
  795959
  796857
  797260
  800729
  800734
  800749
  801700
  802051
  803507
  803510
  804435
  804445
  804452
  804593
  808125
  817575
  817774
  818760
  819096
  819729
  823778
  824293
  824407
  824868
  825164
  825393
  826048
  826379
  826489
  826505
  826691
  826880
  827218
  827298
  827489
]
14.89 ms
(7.05%)
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
  733109
  733132
  734848
  474261
  477936
  506516
  466374
  496854
  824868
  450125
  572350
  740986
  725462
  706889
  715370
  547868
  589622
  804445
  728146
  734725
  558175
  473400
  466699
  466394
  826489
  826691
  819096
  825393
  818760
  819729
  824293
  825164
  826379
  466902
  527773
  687666
  698255
  717697
  790327
  790330
  725201
  730186
  733473
  795055
  797260
  804593
  808125
  728597
  733060
  734730
  738339
  732901
  735981
  795959
  803510
  544489
  726837
  470768
  474113
  131772
  827489
  450108
  724475
  726596
  527624
  398524
  459949
  523380
  534563
  531869
  550222
  735908
  794745
  746200
  804435
  804452
  462099
  469906
  509192
  471461
  510945
  557896
  492992
  459406
  454176
  396796
  826048
  826505
  826880
  827298
  817575
  817774
  824407
  823778
  827218
  507263
  509659
  571132
  698253
  698249
  615950
  590525
  626889
  789686
  794156
  800729
  800749
  801700
  787654
  793488
  800734
  803507
  725251
  735925
  747245
  761011
  790336
  790840
  796857
  802051
]
2.97 ms
(1.40%)
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
  131772
  396796
  398524
  450108
  450125
  454176
  459406
  459949
  462099
  466374
  466394
  466699
  466902
  469906
  470768
  471461
  473400
  474113
  474261
  477936
  492992
  496854
  506516
  507263
  509192
  509659
  510945
  523380
  527624
  527773
  531869
  534563
  544489
  547868
  550222
  557896
  558175
  571132
  572350
  589622
  590525
  615950
  626889
  687666
  698249
  698253
  698255
  706889
  715370
  717697
  724475
  725201
  725251
  725462
  726596
  726837
  728146
  728597
  730186
  732901
  733060
  733109
  733132
  733473
  734725
  734730
  734848
  735908
  735925
  735981
  738339
  740986
  746200
  747245
  761011
  787654
  789686
  790327
  790330
  790336
  790840
  793488
  794156
  794745
  795055
  795959
  796857
  797260
  800729
  800734
  800749
  801700
  802051
  803507
  803510
  804435
  804445
  804452
  804593
  808125
  817575
  817774
  818760
  819096
  819729
  823778
  824293
  824407
  824868
  825164
  825393
  826048
  826379
  826489
  826505
  826691
  826880
  827218
  827298
  827489
]
2.15 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature вебкамер pussy"
]
2.00 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature webcam pussy"
]
1.85 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature вебкамер pussy"
]
1.80 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.