Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.78 ms
(83.96%)
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
  160233
  384070
  384282
  392277
  394552
  397255
  398564
  400134
  402972
  403900
  408278
  408293
  409374
  412288
  412311
  413889
  420912
  425998
  427536
  428807
  428822
  430095
  430835
  434609
  437583
  439186
  443921
  449740
  450995
  451711
  454048
  456736
  460273
  463625
  467656
  476534
  481874
  492268
  497104
  507115
  511369
  515031
  518735
  521359
  529202
  532028
  532060
  532063
  532095
  532114
  533965
  535010
  536472
  544513
  549719
  549742
  550976
  553278
  555958
  557155
  559173
  561465
  562600
  563157
  563224
  563421
  563454
  573990
  591155
  598311
  599565
  601089
  604157
  606791
  612922
  628653
  652010
  684308
  688100
  688313
  703977
  710146
  710310
  713262
  714188
  718560
  719299
  725402
  727190
  728447
  731464
  746107
  748892
  757866
  758649
  760616
  763280
  764185
  769163
  770006
  771749
  779584
  784304
  793547
  803217
  804071
  804073
  804620
  804675
  806164
  806741
  807394
  807452
  807454
  815353
  820096
  823263
  823803
  823976
  824434
]
17.69 ms
(9.59%)
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
  463625
  823803
  449740
  532060
  555958
  758649
  779584
  430095
  511369
  731464
  402972
  476534
  425998
  467656
  823976
  688100
  806741
  521359
  536472
  497104
  532095
  492268
  549742
  559173
  760616
  563224
  428822
  412288
  403900
  450995
  443921
  561465
  806164
  628653
  713262
  804071
  532114
  573990
  532028
  688313
  714188
  394552
  392277
  409374
  820096
  507115
  532063
  549719
  807394
  725402
  757866
  769163
  770006
  746107
  612922
  803217
  456736
  481874
  437583
  553278
  563454
  718560
  563157
  804620
  728447
  428807
  384282
  544513
  434609
  420912
  427536
  515031
  824434
  823263
  710310
  807452
  727190
  764185
  771749
  763280
  793547
  807454
  397255
  398564
  384070
  460273
  684308
  703977
  599565
  598311
  604157
  451711
  400134
  815353
  710146
  804073
  529202
  408293
  533965
  784304
  454048
  557155
  160233
  652010
  408278
  748892
  591155
  430835
  413889
  719299
  535010
  804675
  439186
  563421
  518735
  606791
  550976
  562600
  601089
  412311
]
4.38 ms
(2.37%)
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
  160233
  384070
  384282
  392277
  394552
  397255
  398564
  400134
  402972
  403900
  408278
  408293
  409374
  412288
  412311
  413889
  420912
  425998
  427536
  428807
  428822
  430095
  430835
  434609
  437583
  439186
  443921
  449740
  450995
  451711
  454048
  456736
  460273
  463625
  467656
  476534
  481874
  492268
  497104
  507115
  511369
  515031
  518735
  521359
  529202
  532028
  532060
  532063
  532095
  532114
  533965
  535010
  536472
  544513
  549719
  549742
  550976
  553278
  555958
  557155
  559173
  561465
  562600
  563157
  563224
  563421
  563454
  573990
  591155
  598311
  599565
  601089
  604157
  606791
  612922
  628653
  652010
  684308
  688100
  688313
  703977
  710146
  710310
  713262
  714188
  718560
  719299
  725402
  727190
  728447
  731464
  746107
  748892
  757866
  758649
  760616
  763280
  764185
  769163
  770006
  771749
  779584
  784304
  793547
  803217
  804071
  804073
  804620
  804675
  806164
  806741
  807394
  807452
  807454
  815353
  820096
  823263
  823803
  823976
  824434
]
2.02 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mom blowjob"
]
1.94 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step mom минет оральн секс"
]
1.85 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step mom минет оральн секс"
]

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.