Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
348.39 ms
(92.15%)
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
  398769
  404330
  413525
  417782
  419631
  421780
  423337
  423561
  423697
  423721
  425979
  426128
  427218
  428368
  434763
  435795
  447076
  448704
  449158
  450787
  451493
  451875
  453028
  454778
  454878
  457245
  458882
  462266
  462572
  462804
  463966
  469011
  475860
  475986
  478098
  484819
  485129
  486481
  489272
  494705
  495730
  500665
  504220
  509056
  513344
  514904
  518970
  519904
  522244
  524579
  527540
  527603
  529005
  529075
  529174
  534786
  536559
  540282
  541396
  544571
  546776
  554952
  556789
  557213
  559079
  562513
  564711
  565143
  565771
  566371
  570728
  573871
  579449
  579537
  586650
  591494
  595986
  599246
  607342
  614659
  620201
  623485
  629268
  630309
  643041
  646022
  650605
  651604
  664157
  669175
  669408
  677106
  695298
  709198
  716693
  717410
  722915
  726718
  727665
  732104
  735920
  737156
  739900
  761291
  765297
  771821
  771837
  773864
  776521
  778069
  779591
  781779
  799262
  805049
  809574
  814835
  817024
  818471
  818472
  820743
]
19.95 ms
(5.28%)
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
  426128
  423721
  814835
  818472
  454778
  485129
  448704
  478098
  457245
  534786
  536559
  518970
  529174
  540282
  524579
  541396
  544571
  559079
  562513
  566371
  664157
  695298
  717410
  646022
  716693
  546776
  573871
  599246
  586650
  623485
  630309
  778069
  781779
  732104
  739900
  620201
  462804
  449158
  454878
  463966
  504220
  509056
  494705
  513344
  522244
  761291
  451493
  423337
  419631
  423561
  427218
  435795
  817024
  820743
  818471
  486481
  450787
  495730
  529005
  527540
  556789
  579449
  554952
  565143
  579537
  669408
  650605
  651604
  557213
  565771
  629268
  607342
  643041
  614659
  591494
  776521
  765297
  805049
  727665
  737156
  735920
  771837
  771821
  709198
  809574
  475860
  462266
  447076
  500665
  519904
  413525
  421780
  475986
  570728
  564711
  677106
  595986
  779591
  773864
  799262
  398769
  428368
  726718
  423697
  434763
  451875
  514904
  527603
  669175
  722915
  462572
  469011
  404330
  489272
  529075
  484819
  425979
  417782
  453028
  458882
]
2.69 ms
(0.71%)
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
  398769
  404330
  413525
  417782
  419631
  421780
  423337
  423561
  423697
  423721
  425979
  426128
  427218
  428368
  434763
  435795
  447076
  448704
  449158
  450787
  451493
  451875
  453028
  454778
  454878
  457245
  458882
  462266
  462572
  462804
  463966
  469011
  475860
  475986
  478098
  484819
  485129
  486481
  489272
  494705
  495730
  500665
  504220
  509056
  513344
  514904
  518970
  519904
  522244
  524579
  527540
  527603
  529005
  529075
  529174
  534786
  536559
  540282
  541396
  544571
  546776
  554952
  556789
  557213
  559079
  562513
  564711
  565143
  565771
  566371
  570728
  573871
  579449
  579537
  586650
  591494
  595986
  599246
  607342
  614659
  620201
  623485
  629268
  630309
  643041
  646022
  650605
  651604
  664157
  669175
  669408
  677106
  695298
  709198
  716693
  717410
  722915
  726718
  727665
  732104
  735920
  737156
  739900
  761291
  765297
  771821
  771837
  773864
  776521
  778069
  779591
  781779
  799262
  805049
  809574
  814835
  817024
  818471
  818472
  820743
]
2.03 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "porn big boobs"
]
1.78 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "porn большие boobs"
]
1.47 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "porn большие boobs"
]

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.