Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.42 ms
(87.85%)
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
  415736
  453470
  535893
  535996
  553327
  555295
  555353
  586209
  592908
  595066
  608628
  609765
  632284
  648697
  662536
  666685
  666707
  686373
  697222
  697731
  700897
  704622
  716710
  717997
  718450
  718844
  719859
  722992
  723138
  724579
  725313
  725388
  728105
  728122
  729434
  729758
  731572
  733372
  736278
  743575
  743608
  746073
  746553
  747202
  754368
  755044
  755046
  755395
  758412
  760340
  761657
  762469
  763030
  763374
  767411
  767535
  767903
  769656
  769913
  771802
  772895
  776179
  777701
  777803
  777946
  777962
  778073
  778305
  778617
  779337
  779827
  780171
  780213
  780479
  783427
  786621
  786821
  787540
  787924
  788665
  794057
  795293
  798381
  801983
  808843
  810325
  813600
  814325
  817987
  819263
  819327
  819746
  819797
  819934
  821791
  824001
  824045
  824260
  824337
  825246
  825321
  825363
  825364
  825399
  825609
  825624
  826196
  826583
  826584
  826641
  826907
  826995
  827118
  827141
  828234
  828317
  828342
  828431
]
11.32 ms
(6.24%)
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
  795293
  821791
  825624
  826641
  824001
  819934
  824260
  826907
  819797
  817987
  718450
  719859
  718844
  723138
  586209
  777701
  777946
  787924
  788665
  798381
  777803
  778044
  725388
  733372
  760340
  763030
  767411
  769913
  786621
  808843
  810325
  728105
  728122
  731572
  758412
  761657
  729434
  736278
  743608
  747202
  755044
  769656
  772895
  729758
  755395
  767535
  771802
  743575
  746553
  763374
  716710
  717997
  722992
  778073
  786821
  787733
  535996
  780213
  780171
  553327
  555295
  648697
  666685
  666707
  697731
  686373
  697222
  700897
  608628
  595066
  592908
  776179
  801983
  783427
  794057
  755046
  754368
  632284
  777962
  778305
  787540
  780479
  824045
  827118
  828431
  609765
  767903
  779827
  828342
  725313
  724579
  762469
  746073
  779337
  415736
  453470
  704622
  778617
  662536
  535893
  819327
  825364
  825399
  813600
  826196
  826584
  826583
  824337
  826995
  827141
  819263
  819746
  825321
  825363
  825609
  814325
  825246
  828234
  828317
  555353
]
2.51 ms
(1.39%)
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
  415736
  453470
  535893
  535996
  553327
  555295
  555353
  586209
  592908
  595066
  608628
  609765
  632284
  648697
  662536
  666685
  666707
  686373
  697222
  697731
  700897
  704622
  716710
  717997
  718450
  718844
  719859
  722992
  723138
  724579
  725313
  725388
  728105
  728122
  729434
  729758
  731572
  733372
  736278
  743575
  743608
  746073
  746553
  747202
  754368
  755044
  755046
  755395
  758412
  760340
  761657
  762469
  763030
  763374
  767411
  767535
  767903
  769656
  769913
  771802
  772895
  776179
  777701
  777803
  777946
  777962
  778073
  778305
  778617
  779337
  779827
  780171
  780213
  780479
  783427
  786621
  786821
  787540
  787924
  788665
  794057
  795293
  798381
  801983
  808843
  810325
  813600
  814325
  817987
  819263
  819327
  819746
  819797
  819934
  821791
  824001
  824045
  824260
  824337
  825246
  825321
  825363
  825364
  825399
  825609
  825624
  826196
  826583
  826584
  826641
  826907
  826995
  827118
  827141
  828234
  828317
  828342
  828431
]
2.18 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "реальная дрочка члена…"
]
2.06 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск дрочк член"
]
2.00 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.09%)
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.