Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.33 ms
(84.41%)
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
  397104
  397432
  397523
  407654
  416138
  429050
  432778
  432803
  435177
  441420
  441495
  441503
  448636
  449053
  455897
  456207
  457380
  459635
  459686
  460773
  461306
  469162
  471554
  475472
  484318
  488238
  488239
  489271
  491588
  492948
  493417
  493573
  498163
  505803
  507253
  508560
  509123
  509600
  510001
  510230
  511357
  511481
  511868
  515003
  524319
  527874
  532104
  538266
  542886
  545598
  546573
  559999
  561388
  564358
  570676
  578246
  579469
  580210
  580423
  581064
  584955
  585296
  586589
  588661
  591742
  592399
  592614
  602580
  603824
  603833
  604706
  606697
  607928
  609582
  611348
  613849
  618021
  618133
  618364
  623339
  627013
  632096
  632114
  634600
  637802
  653866
  653888
  658222
  677899
  683332
  695900
  696081
  697885
  720828
  736470
  740871
  741656
  742320
  742861
  743068
  752613
  754140
  754160
  757394
  759673
  759961
  761048
  765493
  765514
  766996
  772419
  777742
  787506
  788893
  796165
  797060
  797394
  802053
  803722
  805502
]
14.90 ms
(9.58%)
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
  754140
  459686
  618021
  532104
  653888
  653866
  586589
  607928
  592399
  592614
  637802
  623339
  632114
  493573
  515003
  559999
  697885
  441503
  484318
  469162
  471554
  546573
  564358
  545598
  580423
  777742
  797394
  805502
  742861
  765514
  759673
  772419
  797060
  397523
  460773
  397432
  448636
  507253
  561388
  581064
  720828
  618133
  585296
  796165
  802053
  803722
  757394
  759961
  752613
  787506
  441420
  456207
  407654
  602580
  606697
  498163
  491588
  509123
  509600
  524319
  542886
  578246
  580210
  658222
  696081
  683332
  695900
  611348
  603824
  603833
  613849
  618364
  588661
  591742
  627013
  632096
  538266
  489271
  492948
  511868
  505803
  511357
  510001
  455897
  579469
  570676
  677899
  736470
  432803
  435177
  432778
  510230
  488239
  493417
  527874
  397104
  416138
  429050
  441495
  449053
  461306
  457380
  459635
  475472
  488238
  508560
  511481
  584955
  604706
  609582
  634600
  788893
  740871
  742320
  754160
  761048
  741656
  743068
  765493
  766996
]
2.81 ms
(1.81%)
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
  397104
  397432
  397523
  407654
  416138
  429050
  432778
  432803
  435177
  441420
  441495
  441503
  448636
  449053
  455897
  456207
  457380
  459635
  459686
  460773
  461306
  469162
  471554
  475472
  484318
  488238
  488239
  489271
  491588
  492948
  493417
  493573
  498163
  505803
  507253
  508560
  509123
  509600
  510001
  510230
  511357
  511481
  511868
  515003
  524319
  527874
  532104
  538266
  542886
  545598
  546573
  559999
  561388
  564358
  570676
  578246
  579469
  580210
  580423
  581064
  584955
  585296
  586589
  588661
  591742
  592399
  592614
  602580
  603824
  603833
  604706
  606697
  607928
  609582
  611348
  613849
  618021
  618133
  618364
  623339
  627013
  632096
  632114
  634600
  637802
  653866
  653888
  658222
  677899
  683332
  695900
  696081
  697885
  720828
  736470
  740871
  741656
  742320
  742861
  743068
  752613
  754140
  754160
  757394
  759673
  759961
  761048
  765493
  765514
  766996
  772419
  777742
  787506
  788893
  796165
  797060
  797394
  802053
  803722
  805502
]
1.91 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur screaming"
]
1.71 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск крича вперв"
]
1.40 ms
(0.90%)
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.