Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.85 ms
(81.94%)
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
  387160
  388856
  404478
  404698
  404740
  407532
  408928
  409630
  411899
  415177
  415591
  415615
  418955
  420219
  424933
  425164
  425330
  430002
  431716
  433058
  433501
  433592
  440644
  441985
  444978
  446011
  446022
  446135
  447959
  448427
  449020
  449022
  450184
  450241
  450371
  452052
  453378
  454714
  454909
  456938
  457279
  457434
  460191
  464018
  465079
  465500
  465630
  465912
  466462
  467627
  468538
  469389
  469519
  472484
  472543
  478039
  479860
  480397
  480510
  481971
  483725
  494771
  499921
  502809
  503792
  509476
  509720
  510049
  513852
  514935
  517535
  517933
  523394
  526824
  532817
  533937
  536282
  536728
  537261
  549723
  562398
  565275
  570936
  585663
  591115
  592922
  599004
  601113
  601115
  601670
  602229
  604909
  623263
  625452
  669213
  676890
  702268
  720357
  737554
  745979
  749522
  764414
  770007
  773420
  776638
  782003
  783452
  791148
  797580
  801121
  802302
  803784
  804585
  807906
  808265
  809076
  812547
  812732
  814754
  818456
]
16.97 ms
(11.14%)
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
  807906
  812547
  737554
  749522
  745979
  764414
  773420
  770007
  602229
  702268
  720357
  782003
  791148
  802302
  804585
  812732
  387160
  431716
  409630
  456938
  466462
  483725
  447959
  446135
  676890
  585663
  599004
  801121
  440644
  415591
  433592
  441985
  433058
  433501
  814754
  818456
  478039
  454714
  472543
  452052
  454909
  533937
  514935
  526824
  472484
  549723
  562398
  601113
  388856
  446022
  469389
  480510
  446011
  457279
  465912
  479860
  411899
  415177
  418955
  425330
  444978
  465079
  408928
  465500
  468538
  480397
  430002
  453378
  494771
  509720
  536728
  502809
  404740
  415615
  425164
  481971
  537261
  404698
  457434
  404478
  407532
  420219
  424933
  448427
  450184
  450241
  450371
  465630
  469519
  449020
  449022
  503792
  510049
  532817
  536282
  499921
  517933
  513852
  509476
  517535
  523394
  467627
  669213
  565275
  570936
  592922
  601670
  604909
  623263
  601115
  591115
  803784
  809076
  783452
  797580
  808265
  625452
  776638
  460191
  464018
]
2.78 ms
(1.82%)
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
  387160
  388856
  404478
  404698
  404740
  407532
  408928
  409630
  411899
  415177
  415591
  415615
  418955
  420219
  424933
  425164
  425330
  430002
  431716
  433058
  433501
  433592
  440644
  441985
  444978
  446011
  446022
  446135
  447959
  448427
  449020
  449022
  450184
  450241
  450371
  452052
  453378
  454714
  454909
  456938
  457279
  457434
  460191
  464018
  465079
  465500
  465630
  465912
  466462
  467627
  468538
  469389
  469519
  472484
  472543
  478039
  479860
  480397
  480510
  481971
  483725
  494771
  499921
  502809
  503792
  509476
  509720
  510049
  513852
  514935
  517535
  517933
  523394
  526824
  532817
  533937
  536282
  536728
  537261
  549723
  562398
  565275
  570936
  585663
  591115
  592922
  599004
  601113
  601115
  601670
  602229
  604909
  623263
  625452
  669213
  676890
  702268
  720357
  737554
  745979
  749522
  764414
  770007
  773420
  776638
  782003
  783452
  791148
  797580
  801121
  802302
  803784
  804585
  807906
  808265
  809076
  812547
  812732
  814754
  818456
]
2.65 ms
(1.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf boobs oil"
]
1.71 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf boobs масл"
]
1.50 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf boobs масл"
]

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.