Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.36 ms
(84.17%)
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
  34296
  188437
  337012
  360439
  384382
  387016
  388792
  388907
  397923
  404587
  408616
  411107
  424742
  430712
  432639
  432663
  432852
  436138
  439577
  448951
  452772
  453157
  454544
  456563
  461767
  465532
  466254
  470158
  470402
  470424
  472857
  473457
  475825
  478041
  478460
  478530
  478702
  479105
  482549
  489975
  490898
  490905
  496743
  499830
  501643
  506518
  509988
  513963
  514245
  516481
  519760
  523204
  535340
  536454
  538925
  547584
  548443
  550366
  552585
  558441
  565491
  568514
  573175
  574109
  580611
  581013
  582222
  590150
  593365
  596851
  604426
  617807
  655298
  683012
  702033
  705466
  705630
  717677
  724614
  725362
  726957
  727792
  727805
  734324
  735768
  740844
  743510
  744970
  759793
  761048
  761749
  765376
  766650
  778091
  779744
  782559
  784158
  784528
  786115
  788980
  791155
  791589
  795140
  797151
  799964
  800529
  801254
  802160
  802202
  802208
  802493
  805594
  809648
  815074
  815179
  815485
  815806
  818290
  820118
  822511
]
12.86 ms
(9.30%)
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
  815806
  820118
  514245
  465532
  717677
  779744
  778091
  788980
  734324
  744970
  761048
  743510
  809648
  461767
  727805
  478702
  430712
  802160
  740844
  702033
  765376
  478041
  786115
  761749
  387016
  388907
  818290
  822511
  815074
  815179
  815485
  472857
  538925
  582222
  655298
  705466
  802202
  797151
  802208
  799964
  800529
  805594
  724614
  725362
  735768
  759793
  705630
  802493
  456563
  791155
  479105
  432663
  436138
  547584
  574109
  519760
  596851
  432639
  448951
  604426
  568514
  552585
  784158
  408616
  536454
  593365
  470402
  388792
  470424
  473457
  482549
  489975
  501643
  523204
  573175
  565491
  590150
  478530
  439577
  360439
  516481
  509988
  581013
  188437
  784528
  548443
  683012
  801254
  795140
  766650
  726957
  727792
  617807
  782559
  475825
  490905
  397923
  506518
  791589
  452772
  384382
  337012
  404587
  411107
  432852
  424742
  496743
  535340
  550366
  580611
  34296
  454544
  478460
  466254
  490898
  558441
  499830
  513963
  453157
  470158
]
2.76 ms
(2.00%)
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
  34296
  188437
  337012
  360439
  384382
  387016
  388792
  388907
  397923
  404587
  408616
  411107
  424742
  430712
  432639
  432663
  432852
  436138
  439577
  448951
  452772
  453157
  454544
  456563
  461767
  465532
  466254
  470158
  470402
  470424
  472857
  473457
  475825
  478041
  478460
  478530
  478702
  479105
  482549
  489975
  490898
  490905
  496743
  499830
  501643
  506518
  509988
  513963
  514245
  516481
  519760
  523204
  535340
  536454
  538925
  547584
  548443
  550366
  552585
  558441
  565491
  568514
  573175
  574109
  580611
  581013
  582222
  590150
  593365
  596851
  604426
  617807
  655298
  683012
  702033
  705466
  705630
  717677
  724614
  725362
  726957
  727792
  727805
  734324
  735768
  740844
  743510
  744970
  759793
  761048
  761749
  765376
  766650
  778091
  779744
  782559
  784158
  784528
  786115
  788980
  791155
  791589
  795140
  797151
  799964
  800529
  801254
  802160
  802202
  802208
  802493
  805594
  809648
  815074
  815179
  815485
  815806
  818290
  820118
  822511
]
1.70 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf stockings anal"
]
1.59 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf чулк нижн бел анал"
]
1.54 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf чулк нижн бел анал"
]

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.