Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.23 ms
(86.22%)
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
  6965
  131497
  388900
  396619
  397879
  400819
  401807
  419998
  422277
  424096
  428220
  428910
  432759
  440534
  440897
  441846
  443861
  443920
  445292
  446949
  449094
  453491
  454508
  455301
  455886
  459633
  464214
  466898
  468353
  470404
  471643
  480282
  483557
  488949
  489311
  494451
  495465
  502788
  503450
  504664
  506031
  524112
  524778
  526456
  529143
  531571
  532119
  533193
  533775
  533793
  544181
  545669
  549836
  555669
  560933
  563438
  564296
  564551
  564607
  582479
  599518
  602895
  604260
  605157
  620245
  643572
  646655
  657223
  660698
  676657
  678813
  687351
  699976
  707102
  710204
  714611
  714630
  715813
  720017
  720286
  725234
  726175
  728259
  728708
  729272
  731274
  735917
  738018
  742719
  744184
  746544
  751498
  754649
  756428
  756685
  759903
  759936
  759950
  760953
  761323
  765060
  768195
  768328
  768761
  777727
  788565
  788946
  788983
  792647
  792654
  794766
  796062
  797194
  799718
  802160
  810407
  816609
  825242
  825571
  827327
]
13.84 ms
(7.54%)
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
  432759
  563438
  424096
  532119
  687351
  646655
  657223
  560933
  643572
  735917
  754649
  792647
  582479
  710204
  388900
  459633
  715813
  802160
  738018
  746544
  742719
  564551
  794766
  488949
  502788
  676657
  660698
  796062
  533793
  131497
  446949
  788565
  503450
  602895
  549836
  454508
  524778
  397879
  428220
  443861
  728259
  760953
  756685
  759936
  788983
  6965
  825242
  440534
  464214
  759950
  466898
  468353
  827327
  797194
  443920
  759903
  455301
  401807
  445292
  816609
  441846
  422277
  495465
  471643
  419998
  453491
  714630
  504664
  428910
  529143
  533775
  531571
  545669
  555669
  699976
  707102
  720017
  564296
  604260
  725234
  792654
  455886
  396619
  825571
  768195
  620245
  605157
  470404
  777727
  761323
  788946
  449094
  400819
  526456
  489311
  506031
  544181
  714611
  720286
  678813
  799718
  729272
  731274
  756428
  768328
  728708
  768761
  726175
  765060
  810407
  440897
  483557
  751498
  744184
  524112
  480282
  564607
  599518
  494451
  533193
]
4.10 ms
(2.24%)
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
  6965
  131497
  388900
  396619
  397879
  400819
  401807
  419998
  422277
  424096
  428220
  428910
  432759
  440534
  440897
  441846
  443861
  443920
  445292
  446949
  449094
  453491
  454508
  455301
  455886
  459633
  464214
  466898
  468353
  470404
  471643
  480282
  483557
  488949
  489311
  494451
  495465
  502788
  503450
  504664
  506031
  524112
  524778
  526456
  529143
  531571
  532119
  533193
  533775
  533793
  544181
  545669
  549836
  555669
  560933
  563438
  564296
  564551
  564607
  582479
  599518
  602895
  604260
  605157
  620245
  643572
  646655
  657223
  660698
  676657
  678813
  687351
  699976
  707102
  710204
  714611
  714630
  715813
  720017
  720286
  725234
  726175
  728259
  728708
  729272
  731274
  735917
  738018
  742719
  744184
  746544
  751498
  754649
  756428
  756685
  759903
  759936
  759950
  760953
  761323
  765060
  768195
  768328
  768761
  777727
  788565
  788946
  788983
  792647
  792654
  794766
  796062
  797194
  799718
  802160
  810407
  816609
  825242
  825571
  827327
]
2.03 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин домашн любительск секс"
]
1.90 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин домашн любительск секс"
]
1.77 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мама домашний секс"
]
1.65 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.