Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.87 ms
(78.77%)
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
  421833
  439748
  443634
  446314
  455460
  458346
  459159
  462262
  462289
  462950
  465933
  466778
  467166
  470551
  470614
  470628
  470691
  472128
  473293
  474003
  478553
  479378
  479394
  479400
  479531
  481043
  484628
  486336
  490296
  492696
  496591
  496599
  496690
  502201
  503000
  504158
  508835
  511938
  512411
  512560
  516780
  517124
  517447
  518781
  520127
  520468
  522439
  525848
  525918
  527030
  527032
  527886
  544459
  545187
  547946
  547947
  548319
  549136
  552588
  554222
  554414
  555653
  555969
  562202
  562714
  563007
  563679
  565015
  575802
  576023
  577428
  590482
  590622
  594835
  598867
  606695
  609652
  610695
  611984
  619292
  620754
  621582
  621980
  625322
  625713
  627652
  650539
  654474
  654518
  654740
  654753
  655056
  655647
  655694
  655697
  655714
  656371
  656477
  656984
  657033
  657405
  657670
  658281
  658405
  659593
  662474
  671395
  731233
  731378
  734252
  735871
  752965
  756244
  756247
  756251
  760859
  767804
  796797
  796811
  819767
]
25.25 ms
(14.86%)
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
  627652
  496690
  462262
  554414
  555653
  655056
  657670
  658281
  467166
  547946
  756244
  479378
  492696
  796811
  562202
  421833
  484628
  474003
  594835
  656477
  656371
  658405
  619292
  547947
  458346
  655697
  654518
  625322
  620754
  611984
  563679
  731233
  486336
  479400
  576023
  508835
  527886
  671395
  819767
  609652
  734252
  796797
  502201
  470691
  552588
  525848
  767804
  657033
  606695
  443634
  522439
  478553
  565015
  621980
  575802
  659593
  756251
  525918
  470551
  590482
  654740
  654474
  625713
  756247
  479394
  655694
  657405
  554222
  517447
  662474
  598867
  752965
  466778
  563007
  577428
  562714
  544459
  590622
  481043
  446314
  472128
  735871
  655714
  654753
  479531
  470628
  549136
  731378
  512411
  527030
  503000
  496591
  455460
  459159
  496599
  545187
  512560
  516780
  610695
  555969
  650539
  490296
  470614
  520468
  548319
  760859
  462950
  655647
  656984
  462289
  518781
  527032
  504158
  465933
  473293
  511938
  621582
  520127
  517124
  439748
]
2.99 ms
(1.76%)
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
  421833
  439748
  443634
  446314
  455460
  458346
  459159
  462262
  462289
  462950
  465933
  466778
  467166
  470551
  470614
  470628
  470691
  472128
  473293
  474003
  478553
  479378
  479394
  479400
  479531
  481043
  484628
  486336
  490296
  492696
  496591
  496599
  496690
  502201
  503000
  504158
  508835
  511938
  512411
  512560
  516780
  517124
  517447
  518781
  520127
  520468
  522439
  525848
  525918
  527030
  527032
  527886
  544459
  545187
  547946
  547947
  548319
  549136
  552588
  554222
  554414
  555653
  555969
  562202
  562714
  563007
  563679
  565015
  575802
  576023
  577428
  590482
  590622
  594835
  598867
  606695
  609652
  610695
  611984
  619292
  620754
  621582
  621980
  625322
  625713
  627652
  650539
  654474
  654518
  654740
  654753
  655056
  655647
  655694
  655697
  655714
  656371
  656477
  656984
  657033
  657405
  657670
  658281
  658405
  659593
  662474
  671395
  731233
  731378
  734252
  735871
  752965
  756244
  756247
  756251
  760859
  767804
  796797
  796811
  819767
]
2.12 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rus wife cuckold"
]
2.03 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен куколд"
]
1.88 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.