Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.18 ms
(79.99%)
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
  359011
  382304
  391562
  396330
  397879
  398719
  405528
  415004
  422134
  430374
  434358
  441106
  448002
  452638
  453332
  455793
  460208
  460218
  467047
  467872
  467893
  467908
  468142
  475647
  475649
  486126
  490232
  490831
  492732
  493606
  494231
  502064
  505724
  506516
  510395
  512029
  512057
  519316
  526894
  527409
  529213
  531181
  533598
  534734
  542280
  545451
  545460
  555035
  555133
  559377
  568189
  573760
  575336
  576925
  584267
  591476
  596929
  601535
  602259
  604537
  618855
  629962
  630793
  631937
  632107
  633237
  636320
  637036
  642032
  642315
  643027
  643100
  648820
  676549
  697628
  710360
  717550
  719902
  720249
  721750
  724153
  725598
  728145
  730015
  731142
  732627
  734038
  747098
  751637
  755958
  756614
  759847
  765349
  770501
  775817
  775853
  783278
  786604
  789710
  796071
  796306
  799695
  800656
  800672
  801206
  807589
  808614
  810675
  810892
  811296
  812564
  813568
  813706
  815317
  815448
  815969
  815975
  816007
  818371
  826880
]
18.96 ms
(11.56%)
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
  467908
  453332
  533598
  502064
  475647
  573760
  717550
  422134
  486126
  492732
  452638
  601535
  398719
  796306
  815969
  531181
  505724
  542280
  545451
  786604
  807589
  512029
  770501
  415004
  460208
  527409
  529213
  648820
  642032
  636320
  637036
  815975
  575336
  710360
  618855
  591476
  808614
  775853
  810892
  783278
  732627
  724153
  751637
  810675
  455793
  596929
  643027
  405528
  475649
  396330
  430374
  755958
  519316
  559377
  568189
  629962
  632107
  728145
  747098
  725598
  775817
  441106
  493606
  359011
  812564
  576925
  799695
  730015
  765349
  756614
  630793
  697628
  721750
  545460
  494231
  382304
  397879
  448002
  490232
  434358
  796071
  719902
  526894
  813568
  816007
  490831
  467047
  468142
  506516
  512057
  720249
  555133
  631937
  642315
  643100
  602259
  811296
  734038
  604537
  467872
  467893
  460218
  391562
  510395
  731142
  826880
  759847
  815317
  813706
  815448
  818371
  534734
  555035
  584267
  676549
  633237
  789710
  800672
  800656
  801206
]
4.71 ms
(2.87%)
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
  359011
  382304
  391562
  396330
  397879
  398719
  405528
  415004
  422134
  430374
  434358
  441106
  448002
  452638
  453332
  455793
  460208
  460218
  467047
  467872
  467893
  467908
  468142
  475647
  475649
  486126
  490232
  490831
  492732
  493606
  494231
  502064
  505724
  506516
  510395
  512029
  512057
  519316
  526894
  527409
  529213
  531181
  533598
  534734
  542280
  545451
  545460
  555035
  555133
  559377
  568189
  573760
  575336
  576925
  584267
  591476
  596929
  601535
  602259
  604537
  618855
  629962
  630793
  631937
  632107
  633237
  636320
  637036
  642032
  642315
  643027
  643100
  648820
  676549
  697628
  710360
  717550
  719902
  720249
  721750
  724153
  725598
  728145
  730015
  731142
  732627
  734038
  747098
  751637
  755958
  756614
  759847
  765349
  770501
  775817
  775853
  783278
  786604
  789710
  796071
  796306
  799695
  800656
  800672
  801206
  807589
  808614
  810675
  810892
  811296
  812564
  813568
  813706
  815317
  815448
  815969
  815975
  816007
  818371
  826880
]
3.57 ms
(2.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазм у зрелой женщине"
]
2.54 ms
(1.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "оргазм зрелая женщин"
]
1.50 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.