Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.82 ms
(85.52%)
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
  340635
  382207
  391984
  398038
  416000
  421199
  426294
  428174
  429899
  429902
  441354
  442114
  453390
  453408
  459195
  462962
  463976
  464017
  464023
  464987
  465431
  466860
  469285
  469393
  472421
  473400
  473533
  473634
  475660
  475662
  475680
  476325
  486814
  490402
  491436
  493961
  495279
  502877
  508254
  509218
  509598
  510425
  517697
  519625
  522181
  522448
  523622
  525884
  527476
  529356
  542285
  543623
  547942
  549235
  552569
  554405
  554408
  554490
  554793
  555166
  557605
  561459
  561507
  561529
  567418
  569271
  570935
  577433
  578148
  578323
  578733
  579585
  580521
  580841
  580921
  580976
  582603
  582751
  585050
  586360
  587298
  589670
  591997
  596935
  599579
  601134
  602461
  605588
  605661
  607002
  607218
  610037
  618622
  628714
  636426
  664186
  666188
  666370
  667344
  707545
  710590
  728469
  739779
  744229
  750765
  753023
  757724
  761293
  780653
  781857
  781916
  804427
  804434
  804452
  807842
  808068
  808166
  811736
  827652
  827656
]
17.05 ms
(9.30%)
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
  554405
  561529
  570935
  542285
  543623
  547942
  580976
  549235
  552569
  555166
  561459
  666370
  710590
  578148
  582751
  610037
  599579
  602461
  607002
  586360
  587298
  601134
  628714
  636426
  596935
  780653
  807842
  781916
  808068
  739779
  744229
  750765
  707545
  804434
  804452
  473634
  486814
  502877
  605661
  591997
  442114
  577433
  464023
  473400
  465431
  510425
  493961
  525884
  522448
  429899
  491436
  462962
  382207
  398038
  426294
  464987
  459195
  475662
  490402
  509598
  523622
  529356
  522181
  476325
  554793
  554490
  582603
  569271
  664186
  666188
  554408
  580521
  607218
  589670
  804427
  808166
  811736
  753023
  757724
  761293
  728469
  781857
  340635
  391984
  429902
  453390
  475680
  472421
  464017
  519625
  428174
  578323
  416000
  509218
  618622
  453408
  827656
  827652
  463976
  421199
  441354
  585050
  605588
  469285
  473533
  469393
  495279
  508254
  517697
  527476
  466860
  475660
  579585
  557605
  567418
  578733
  580921
  667344
  561507
  580841
]
2.74 ms
(1.50%)
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
  340635
  382207
  391984
  398038
  416000
  421199
  426294
  428174
  429899
  429902
  441354
  442114
  453390
  453408
  459195
  462962
  463976
  464017
  464023
  464987
  465431
  466860
  469285
  469393
  472421
  473400
  473533
  473634
  475660
  475662
  475680
  476325
  486814
  490402
  491436
  493961
  495279
  502877
  508254
  509218
  509598
  510425
  517697
  519625
  522181
  522448
  523622
  525884
  527476
  529356
  542285
  543623
  547942
  549235
  552569
  554405
  554408
  554490
  554793
  555166
  557605
  561459
  561507
  561529
  567418
  569271
  570935
  577433
  578148
  578323
  578733
  579585
  580521
  580841
  580921
  580976
  582603
  582751
  585050
  586360
  587298
  589670
  591997
  596935
  599579
  601134
  602461
  605588
  605661
  607002
  607218
  610037
  618622
  628714
  636426
  664186
  666188
  666370
  667344
  707545
  710590
  728469
  739779
  744229
  750765
  753023
  757724
  761293
  780653
  781857
  781916
  804427
  804434
  804452
  807842
  808068
  808166
  811736
  827652
  827656
]
2.02 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby hairy solo"
]
1.79 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby волосатая соло"
]
1.38 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby волосатая соло"
]

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.