Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.27 ms
(86.91%)
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
  78709
  100449
  142598
  184359
  391089
  391898
  391907
  391939
  403243
  411367
  453635
  470047
  475104
  475897
  477633
  479074
  484687
  489807
  495043
  504201
  509006
  533527
  535402
  536219
  536977
  539018
  542080
  542766
  542770
  542992
  543416
  543658
  544771
  549527
  550949
  558980
  563387
  566418
  567462
  572219
  575689
  576175
  576512
  584605
  585583
  587629
  589141
  589208
  591151
  595805
  595817
  596906
  603449
  603513
  603600
  603658
  603668
  603690
  605485
  607155
  619275
  621777
  622166
  622183
  623221
  630668
  632048
  632423
  635788
  636550
  641134
  645050
  649625
  650642
  651287
  653384
  653612
  653617
  654689
  654695
  674515
  690049
  692452
  692463
  695784
  696982
  698104
  702877
  705409
  710274
  712501
  712634
  713444
  714128
  716378
  716564
  721932
  724324
  724329
  725166
  728742
  729170
  729217
  729220
  730753
  731058
  732793
  732819
  733150
  733241
  735805
  737028
  738936
  739547
  744509
  759760
  760534
  761822
  787676
  787691
]
15.68 ms
(7.78%)
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
  495043
  78709
  619275
  535402
  509006
  533527
  566418
  654695
  730753
  632423
  705409
  484687
  595805
  475104
  550949
  591151
  542766
  695784
  589141
  725166
  744509
  759760
  536219
  567462
  572219
  587629
  630668
  184359
  543658
  651287
  716564
  575689
  632048
  603449
  787676
  721932
  142598
  732793
  787691
  391907
  623221
  411367
  542770
  475897
  470047
  549527
  453635
  391898
  654689
  710274
  603600
  622183
  641134
  536977
  692452
  712634
  724329
  761822
  712501
  621777
  724324
  636550
  713444
  544771
  585583
  735805
  584605
  653612
  733241
  698104
  391089
  589208
  737028
  504201
  716378
  605485
  477633
  731058
  645050
  690049
  542080
  738936
  728742
  607155
  391939
  635788
  733150
  576175
  729220
  760534
  603513
  596906
  729170
  403243
  603668
  729217
  563387
  576512
  649625
  714128
  650642
  692463
  603658
  603690
  739547
  622166
  702877
  543416
  595817
  653617
  696982
  489807
  479074
  558980
  542992
  653384
  674515
  732819
  100449
  539018
]
3.35 ms
(1.66%)
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
  78709
  100449
  142598
  184359
  391089
  391898
  391907
  391939
  403243
  411367
  453635
  470047
  475104
  475897
  477633
  479074
  484687
  489807
  495043
  504201
  509006
  533527
  535402
  536219
  536977
  539018
  542080
  542766
  542770
  542992
  543416
  543658
  544771
  549527
  550949
  558980
  563387
  566418
  567462
  572219
  575689
  576175
  576512
  584605
  585583
  587629
  589141
  589208
  591151
  595805
  595817
  596906
  603449
  603513
  603600
  603658
  603668
  603690
  605485
  607155
  619275
  621777
  622166
  622183
  623221
  630668
  632048
  632423
  635788
  636550
  641134
  645050
  649625
  650642
  651287
  653384
  653612
  653617
  654689
  654695
  674515
  690049
  692452
  692463
  695784
  696982
  698104
  702877
  705409
  710274
  712501
  712634
  713444
  714128
  716378
  716564
  721932
  724324
  724329
  725166
  728742
  729170
  729217
  729220
  730753
  731058
  732793
  732819
  733150
  733241
  735805
  737028
  738936
  739547
  744509
  759760
  760534
  761822
  787676
  787691
]
1.95 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife swinger sex"
]
1.94 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен свингер секс"
]
1.58 ms
(0.78%)
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.