Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.62 ms
(84.39%)
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
  433269
  440801
  442975
  444708
  450122
  452421
  454548
  457443
  457852
  460016
  462605
  463790
  465385
  465567
  466138
  466869
  468355
  472611
  472652
  473949
  483644
  488464
  489847
  490212
  492293
  493174
  493681
  495059
  495222
  498454
  507245
  511257
  513194
  514007
  514445
  516043
  516485
  517711
  517723
  523836
  523842
  526516
  526526
  531992
  538007
  539372
  542986
  543983
  544878
  546453
  547420
  549846
  555048
  555062
  555142
  555334
  555425
  557244
  558914
  561447
  563025
  563090
  564294
  564301
  566767
  567683
  571103
  583539
  588393
  603890
  605026
  609825
  612989
  629256
  644447
  655186
  657159
  680284
  705358
  711728
  714466
  716057
  717085
  718119
  720888
  724523
  726242
  726934
  729074
  731084
  733073
  734440
  734456
  743934
  746454
  747095
  756666
  759571
  761596
  761598
  765792
  777953
  778133
  778215
  782029
  784303
  784315
  787479
  792631
  796184
  797178
  798801
  800697
  800712
  802056
  805736
  812973
  817747
  826659
  827632
]
13.15 ms
(8.90%)
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
  472611
  561447
  555334
  558914
  792631
  796184
  761598
  784303
  609825
  462605
  452421
  457443
  468355
  513194
  516485
  523836
  498454
  514007
  526516
  523842
  490212
  547420
  543983
  567683
  655186
  612989
  761596
  714466
  511257
  454548
  460016
  465385
  488464
  457852
  516043
  539372
  557244
  563025
  549846
  555048
  555062
  555142
  605026
  603890
  517711
  489847
  493174
  517723
  526526
  495222
  514445
  538007
  733073
  747095
  726242
  729074
  782029
  802056
  466869
  657159
  680284
  711728
  583539
  588393
  629256
  472652
  798801
  759571
  718119
  800712
  444708
  563090
  827632
  720888
  778133
  743934
  756666
  724523
  778215
  492293
  450122
  442975
  784315
  433269
  463790
  507245
  531992
  546453
  705358
  644447
  717085
  466138
  777953
  493681
  495059
  542986
  566767
  544878
  564294
  564301
  765792
  571103
  483644
  440801
  826659
  817747
  465567
  473949
  555425
  716057
  800697
  812973
  734456
  787479
  797178
  805736
  734440
  726934
  746454
  731084
]
2.77 ms
(1.88%)
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
  433269
  440801
  442975
  444708
  450122
  452421
  454548
  457443
  457852
  460016
  462605
  463790
  465385
  465567
  466138
  466869
  468355
  472611
  472652
  473949
  483644
  488464
  489847
  490212
  492293
  493174
  493681
  495059
  495222
  498454
  507245
  511257
  513194
  514007
  514445
  516043
  516485
  517711
  517723
  523836
  523842
  526516
  526526
  531992
  538007
  539372
  542986
  543983
  544878
  546453
  547420
  549846
  555048
  555062
  555142
  555334
  555425
  557244
  558914
  561447
  563025
  563090
  564294
  564301
  566767
  567683
  571103
  583539
  588393
  603890
  605026
  609825
  612989
  629256
  644447
  655186
  657159
  680284
  705358
  711728
  714466
  716057
  717085
  718119
  720888
  724523
  726242
  726934
  729074
  731084
  733073
  734440
  734456
  743934
  746454
  747095
  756666
  759571
  761596
  761598
  765792
  777953
  778133
  778215
  782029
  784303
  784315
  787479
  792631
  796184
  797178
  798801
  800697
  800712
  802056
  805736
  812973
  817747
  826659
  827632
]
2.06 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые мамки домашнее"
]
1.83 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин мам женщин домашн любительск"
]
1.50 ms
(1.02%)
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.