Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.96 ms
(84.12%)
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
  17190
  205910
  235834
  385303
  385913
  387377
  388723
  389631
  390894
  392678
  393458
  393727
  393738
  393741
  396013
  396473
  396891
  400423
  400465
  401559
  402078
  402252
  404059
  407320
  410573
  411769
  413288
  414385
  415906
  416377
  418485
  423398
  424074
  430713
  443018
  445938
  447417
  447955
  461973
  462500
  466966
  468756
  469910
  474719
  476951
  482174
  487921
  492610
  509025
  512049
  515290
  518933
  522587
  523487
  543863
  550601
  555885
  560219
  560480
  560541
  562109
  566507
  566536
  569683
  570048
  570066
  571686
  574808
  577794
  578470
  580029
  581668
  583976
  587929
  591600
  596669
  597264
  603145
  608042
  610232
  617405
  617759
  618873
  621317
  621686
  622216
  622540
  626752
  663524
  670476
  673607
  676469
  676951
  676977
  682523
  684947
  696964
  696970
  696972
  720429
  722686
  722913
  724710
  727801
  734572
  741652
  746081
  759591
  759650
  771365
  773620
  775825
  788649
  800563
  806031
  812129
  814125
  819191
  821026
  821798
]
13.29 ms
(9.02%)
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
  571686
  416377
  492610
  591600
  392678
  673607
  621686
  622216
  626752
  543863
  569683
  722686
  682523
  684947
  610232
  387377
  583976
  722913
  759650
  814125
  555885
  487921
  482174
  393741
  580029
  566536
  597264
  447955
  570066
  400423
  821026
  476951
  581668
  509025
  390894
  670476
  676469
  720429
  696964
  618873
  806031
  812129
  773620
  746081
  560480
  235834
  411769
  522587
  518933
  515290
  385303
  400465
  574808
  560541
  727801
  423398
  393727
  617759
  734572
  771365
  562109
  570048
  596669
  415906
  402078
  560219
  676977
  443018
  389631
  401559
  418485
  413288
  462500
  523487
  621317
  410573
  550601
  676951
  587929
  17190
  205910
  447417
  566507
  800563
  407320
  424074
  445938
  393738
  775825
  819191
  788649
  402252
  393458
  724710
  396473
  663524
  404059
  821798
  578470
  696972
  696970
  603145
  622540
  741652
  759591
  608042
  469910
  388723
  385913
  396891
  430713
  461973
  474719
  414385
  396013
  512049
  577794
  466966
  468756
  617405
]
3.31 ms
(2.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old мужчин минет оральн секс"
]
1.94 ms
(1.32%)
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
  17190
  205910
  235834
  385303
  385913
  387377
  388723
  389631
  390894
  392678
  393458
  393727
  393738
  393741
  396013
  396473
  396891
  400423
  400465
  401559
  402078
  402252
  404059
  407320
  410573
  411769
  413288
  414385
  415906
  416377
  418485
  423398
  424074
  430713
  443018
  445938
  447417
  447955
  461973
  462500
  466966
  468756
  469910
  474719
  476951
  482174
  487921
  492610
  509025
  512049
  515290
  518933
  522587
  523487
  543863
  550601
  555885
  560219
  560480
  560541
  562109
  566507
  566536
  569683
  570048
  570066
  571686
  574808
  577794
  578470
  580029
  581668
  583976
  587929
  591600
  596669
  597264
  603145
  608042
  610232
  617405
  617759
  618873
  621317
  621686
  622216
  622540
  626752
  663524
  670476
  673607
  676469
  676951
  676977
  682523
  684947
  696964
  696970
  696972
  720429
  722686
  722913
  724710
  727801
  734572
  741652
  746081
  759591
  759650
  771365
  773620
  775825
  788649
  800563
  806031
  812129
  814125
  819191
  821026
  821798
]
1.85 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old man blowjob"
]
1.53 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old мужчин минет оральн секс"
]

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.