Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.11 ms
(84.21%)
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
  79720
  185296
  331119
  391938
  401117
  401144
  422167
  422205
  428879
  439692
  440889
  444168
  447959
  449096
  450544
  451506
  452324
  452327
  452388
  453750
  453838
  454527
  455989
  456507
  456832
  457472
  457858
  462136
  464808
  464811
  465156
  465193
  465572
  466797
  468307
  475004
  477188
  479058
  483639
  484970
  484981
  486374
  486581
  486751
  489293
  491350
  493176
  493181
  493337
  495325
  496865
  497161
  500574
  506787
  508784
  509439
  515320
  519034
  519355
  519360
  520474
  521819
  525017
  525027
  526329
  526454
  526514
  526578
  530003
  532820
  534603
  534678
  536478
  537257
  544509
  545089
  549237
  549829
  552817
  554495
  554514
  554995
  555118
  560666
  562421
  564561
  566854
  584059
  585028
  585518
  593061
  596787
  597184
  599429
  602672
  603363
  620254
  633819
  662650
  666404
  696213
  741799
  746136
  761750
  766624
  766864
  766872
  770493
  781459
  790504
  792664
  801063
  803428
  803434
  804765
  807194
  811152
  814783
  817298
  821036
]
16.39 ms
(10.22%)
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
  801063
  803434
  811152
  401144
  451506
  477188
  79720
  391938
  422167
  428879
  508784
  519355
  486751
  515320
  491350
  506787
  566854
  549829
  555118
  560666
  620254
  439692
  450544
  452324
  457472
  530003
  483639
  493181
  496865
  486581
  509439
  526454
  696213
  185296
  331119
  401117
  440889
  585028
  817298
  814783
  821036
  453750
  455989
  462136
  465193
  449096
  453838
  456507
  466797
  456832
  457858
  500574
  520474
  526514
  534603
  525017
  532820
  536478
  497161
  525027
  526329
  534678
  526578
  464808
  486374
  544509
  554995
  554514
  564561
  545089
  562421
  662650
  666404
  552817
  554495
  585518
  597184
  599429
  596787
  603363
  792664
  804765
  741799
  781459
  746136
  766864
  766872
  761750
  766624
  770493
  790504
  803428
  807194
  475004
  444168
  452388
  464811
  465156
  468307
  479058
  519360
  521819
  493337
  484981
  489293
  447959
  549237
  593061
  633819
  452327
  454527
  465572
  422205
  537257
  493176
  495325
  484970
  519034
  584059
  602672
]
2.34 ms
(1.46%)
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
  79720
  185296
  331119
  391938
  401117
  401144
  422167
  422205
  428879
  439692
  440889
  444168
  447959
  449096
  450544
  451506
  452324
  452327
  452388
  453750
  453838
  454527
  455989
  456507
  456832
  457472
  457858
  462136
  464808
  464811
  465156
  465193
  465572
  466797
  468307
  475004
  477188
  479058
  483639
  484970
  484981
  486374
  486581
  486751
  489293
  491350
  493176
  493181
  493337
  495325
  496865
  497161
  500574
  506787
  508784
  509439
  515320
  519034
  519355
  519360
  520474
  521819
  525017
  525027
  526329
  526454
  526514
  526578
  530003
  532820
  534603
  534678
  536478
  537257
  544509
  545089
  549237
  549829
  552817
  554495
  554514
  554995
  555118
  560666
  562421
  564561
  566854
  584059
  585028
  585518
  593061
  596787
  597184
  599429
  602672
  603363
  620254
  633819
  662650
  666404
  696213
  741799
  746136
  761750
  766624
  766864
  766872
  770493
  781459
  790504
  792664
  801063
  803428
  803434
  804765
  807194
  811152
  814783
  817298
  821036
]
1.97 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mouth"
]
1.67 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature mouth"
]
1.62 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature mouth"
]

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.