Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.88 ms
(82.01%)
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
  410255
  412097
  415831
  417021
  418627
  419185
  419950
  423670
  424299
  425544
  434459
  435500
  437619
  443978
  445324
  446580
  447947
  450135
  450165
  452463
  452588
  453350
  453502
  455153
  455354
  456065
  456936
  457048
  457081
  459002
  459364
  459865
  460294
  460583
  461688
  463661
  465235
  466489
  467684
  469751
  472680
  473758
  474309
  475442
  480125
  481159
  486223
  486859
  486872
  490440
  491629
  492126
  493875
  494814
  495253
  495613
  495965
  498435
  500016
  500871
  506232
  506441
  510838
  510869
  511452
  512581
  517646
  518334
  518821
  519207
  519670
  519867
  521492
  521647
  522653
  523589
  523878
  525200
  525360
  526368
  538478
  539662
  542127
  544042
  544104
  546116
  547819
  556116
  557810
  564172
  565695
  567074
  569541
  573313
  573736
  575675
  580142
  581199
  581959
  584382
  584635
  592921
  600851
  602463
  616566
  619090
  636490
  648740
  652010
  655462
  680746
  717274
  719808
  726306
  750171
  769425
  789490
  790736
  791505
  796072
]
15.99 ms
(10.67%)
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
  573313
  547819
  415831
  450135
  466489
  523589
  472680
  546116
  717274
  652010
  790736
  726306
  750171
  455354
  424299
  453502
  435500
  495965
  419185
  418627
  465235
  510838
  544042
  544104
  556116
  575675
  636490
  796072
  616566
  443978
  456065
  434459
  500871
  518821
  494814
  680746
  655462
  567074
  592921
  600851
  473758
  461688
  491629
  519867
  791505
  410255
  506441
  539662
  518334
  486859
  425544
  445324
  452588
  459364
  486872
  519207
  525200
  493875
  569541
  719808
  557810
  564172
  789490
  474309
  519670
  492126
  459002
  459865
  495253
  522653
  542127
  581959
  565695
  602463
  769425
  423670
  460583
  456936
  467684
  475442
  437619
  460294
  490440
  486223
  523878
  498435
  512581
  525360
  457081
  506232
  457048
  510869
  446580
  619090
  447947
  453350
  521492
  526368
  584635
  573736
  581199
  584382
  580142
  452463
  521647
  500016
  495613
  419950
  450165
  517646
  538478
  481159
  648740
  417021
  463661
  480125
  455153
  412097
  469751
  511452
]
3.68 ms
(2.46%)
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
  410255
  412097
  415831
  417021
  418627
  419185
  419950
  423670
  424299
  425544
  434459
  435500
  437619
  443978
  445324
  446580
  447947
  450135
  450165
  452463
  452588
  453350
  453502
  455153
  455354
  456065
  456936
  457048
  457081
  459002
  459364
  459865
  460294
  460583
  461688
  463661
  465235
  466489
  467684
  469751
  472680
  473758
  474309
  475442
  480125
  481159
  486223
  486859
  486872
  490440
  491629
  492126
  493875
  494814
  495253
  495613
  495965
  498435
  500016
  500871
  506232
  506441
  510838
  510869
  511452
  512581
  517646
  518334
  518821
  519207
  519670
  519867
  521492
  521647
  522653
  523589
  523878
  525200
  525360
  526368
  538478
  539662
  542127
  544042
  544104
  546116
  547819
  556116
  557810
  564172
  565695
  567074
  569541
  573313
  573736
  575675
  580142
  581199
  581959
  584382
  584635
  592921
  600851
  602463
  616566
  619090
  636490
  648740
  652010
  655462
  680746
  717274
  719808
  726306
  750171
  769425
  789490
  790736
  791505
  796072
]
2.11 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur swallows"
]
1.95 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск swallows"
]
1.71 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск swallows"
]

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.