Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.10 ms
(85.56%)
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
  187733
  282470
  387014
  389273
  390518
  390607
  391917
  391943
  391984
  391992
  392023
  398940
  400513
  401199
  415172
  418126
  418144
  421579
  421838
  423488
  423935
  424013
  426018
  427007
  427101
  429890
  430365
  431616
  434358
  434367
  439078
  439274
  439317
  439326
  439754
  445103
  446641
  450484
  450630
  452950
  453394
  455585
  456222
  456226
  456238
  460301
  461610
  461704
  462561
  462840
  464264
  467696
  467886
  467929
  469615
  470133
  470162
  471107
  473387
  475189
  483691
  483911
  484899
  487428
  489315
  493398
  495559
  498963
  504450
  506119
  508541
  509422
  509964
  509970
  510333
  511113
  511857
  513654
  517304
  517810
  519368
  521677
  533461
  542705
  542706
  544401
  544493
  546763
  547237
  547492
  548157
  551579
  555008
  556445
  561930
  565174
  565308
  569238
  574036
  577978
  581210
  582538
  595483
  595488
  619286
  627446
  653503
  661424
  696871
  705769
  716543
  718775
  722384
  741764
  742636
  760859
  765290
  785871
  814443
  814460
]
17.24 ms
(9.51%)
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
  390518
  462561
  434358
  464264
  551579
  450630
  462840
  391943
  418144
  439754
  455585
  544401
  542706
  548157
  542705
  547492
  653503
  716543
  722384
  546763
  556445
  765290
  389273
  391984
  423488
  446641
  187733
  398940
  421838
  470133
  471107
  400513
  426018
  427007
  456238
  439274
  484899
  487428
  521677
  511113
  509422
  595483
  473387
  705769
  696871
  718775
  439078
  581210
  661424
  439317
  456226
  467696
  282470
  391992
  418126
  430365
  445103
  461610
  469615
  519368
  509964
  483691
  506119
  513654
  517810
  431616
  504450
  439326
  470162
  452950
  495559
  574036
  565174
  569238
  582538
  565308
  424013
  467929
  429890
  493398
  511857
  555008
  544493
  742636
  423935
  427101
  401199
  453394
  533461
  509970
  489315
  508541
  391917
  814443
  814460
  483911
  498963
  517304
  510333
  561930
  577978
  547237
  619286
  595488
  785871
  760859
  741764
  627446
  392023
  415172
  450484
  456222
  461704
  467886
  475189
  390607
  421579
  387014
  434367
  460301
]
2.86 ms
(1.58%)
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
  187733
  282470
  387014
  389273
  390518
  390607
  391917
  391943
  391984
  391992
  392023
  398940
  400513
  401199
  415172
  418126
  418144
  421579
  421838
  423488
  423935
  424013
  426018
  427007
  427101
  429890
  430365
  431616
  434358
  434367
  439078
  439274
  439317
  439326
  439754
  445103
  446641
  450484
  450630
  452950
  453394
  455585
  456222
  456226
  456238
  460301
  461610
  461704
  462561
  462840
  464264
  467696
  467886
  467929
  469615
  470133
  470162
  471107
  473387
  475189
  483691
  483911
  484899
  487428
  489315
  493398
  495559
  498963
  504450
  506119
  508541
  509422
  509964
  509970
  510333
  511113
  511857
  513654
  517304
  517810
  519368
  521677
  533461
  542705
  542706
  544401
  544493
  546763
  547237
  547492
  548157
  551579
  555008
  556445
  561930
  565174
  565308
  569238
  574036
  577978
  581210
  582538
  595483
  595488
  619286
  627446
  653503
  661424
  696871
  705769
  716543
  718775
  722384
  741764
  742636
  760859
  765290
  785871
  814443
  814460
]
1.74 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал мастурбац"
]
1.59 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal masturbation"
]
1.41 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анал мастурбац"
]
1.34 ms
(0.74%)
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.