Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.51 ms
(87.48%)
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
  414212
  427388
  434491
  456215
  456818
  460209
  470087
  470141
  479225
  486969
  491666
  497904
  501209
  505748
  514147
  518628
  521693
  521789
  522521
  523498
  523778
  526233
  526767
  530431
  535086
  535585
  539435
  541767
  542386
  545649
  549112
  550935
  557437
  558620
  559048
  560987
  565842
  570927
  575769
  579872
  581366
  582728
  583360
  586554
  593843
  601472
  605583
  615658
  617738
  618531
  628245
  633340
  643601
  646682
  661652
  689964
  699480
  710339
  713964
  716699
  717420
  719829
  722349
  722667
  725384
  726055
  726241
  727423
  732816
  733759
  734222
  738939
  750940
  751437
  754700
  761996
  764485
  765752
  767751
  773291
  777113
  777204
  778569
  779468
  782773
  785472
  786515
  787820
  788575
  789898
  790819
  793117
  793201
  793722
  795002
  796724
  797110
  800526
  801067
  806853
  806864
  809808
  810045
  810582
  811806
  813253
  814281
  817073
  817105
  817128
  817168
  818069
  819636
  819720
  820069
  825762
  826863
  827308
  827488
  827871
]
16.74 ms
(7.49%)
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
  479225
  570927
  601472
  813253
  722667
  788575
  738939
  710339
  530431
  560987
  565842
  427388
  505748
  545649
  521693
  810045
  809808
  689964
  633340
  716699
  819636
  814281
  800526
  806853
  734222
  434491
  470087
  582728
  559048
  523498
  819720
  818069
  722349
  581366
  725384
  785472
  733759
  777204
  827871
  646682
  526767
  550935
  615658
  817128
  820069
  796724
  761996
  787820
  557437
  414212
  765752
  486969
  491666
  719829
  810582
  817105
  535086
  713964
  643601
  750940
  579872
  514147
  526233
  825762
  460209
  790819
  501209
  826863
  827488
  754700
  779468
  717420
  586554
  583360
  661652
  699480
  811806
  549112
  539435
  628245
  605583
  617738
  817168
  521789
  777113
  778569
  786515
  789898
  795002
  801067
  782773
  793117
  726055
  767751
  773291
  793201
  456818
  456215
  542386
  558620
  522521
  497904
  575769
  541767
  523778
  518628
  797110
  470141
  535585
  817073
  793722
  764485
  806864
  727423
  827308
  593843
  618531
  732816
  751437
  726241
]
3.25 ms
(1.45%)
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
  414212
  427388
  434491
  456215
  456818
  460209
  470087
  470141
  479225
  486969
  491666
  497904
  501209
  505748
  514147
  518628
  521693
  521789
  522521
  523498
  523778
  526233
  526767
  530431
  535086
  535585
  539435
  541767
  542386
  545649
  549112
  550935
  557437
  558620
  559048
  560987
  565842
  570927
  575769
  579872
  581366
  582728
  583360
  586554
  593843
  601472
  605583
  615658
  617738
  618531
  628245
  633340
  643601
  646682
  661652
  689964
  699480
  710339
  713964
  716699
  717420
  719829
  722349
  722667
  725384
  726055
  726241
  727423
  732816
  733759
  734222
  738939
  750940
  751437
  754700
  761996
  764485
  765752
  767751
  773291
  777113
  777204
  778569
  779468
  782773
  785472
  786515
  787820
  788575
  789898
  790819
  793117
  793201
  793722
  795002
  796724
  797110
  800526
  801067
  806853
  806864
  809808
  810045
  810582
  811806
  813253
  814281
  817073
  817105
  817128
  817168
  818069
  819636
  819720
  820069
  825762
  826863
  827308
  827488
  827871
]
2.33 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск бдсм секс"
]
2.00 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade bondage sex"
]
1.83 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск бдсм секс"
]
1.83 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.