Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.34 ms
(85.75%)
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
  118885
  186790
  212254
  381819
  382108
  385405
  386994
  389064
  389278
  390418
  399912
  401414
  402134
  414230
  414242
  417049
  418801
  419999
  422337
  422635
  422707
  423787
  424017
  425676
  428249
  429107
  430043
  435610
  439871
  445020
  447324
  449216
  450020
  455365
  457250
  459032
  461069
  469428
  470081
  471904
  472067
  475322
  475419
  475748
  475761
  475771
  478521
  479722
  479871
  483690
  485230
  485564
  487449
  487844
  492987
  495382
  495557
  498079
  508353
  515289
  519741
  521014
  526156
  528449
  534170
  536711
  556202
  557921
  563561
  564609
  577726
  579127
  581036
  590734
  593263
  599407
  599984
  601295
  604115
  637081
  639853
  642666
  651218
  652388
  661062
  670399
  670437
  676996
  706466
  709093
  722340
  736163
  737796
  738249
  740269
  740507
  749049
  754518
  757894
  758061
  758276
  759829
  768591
  773058
  773638
  774065
  774783
  777831
  781305
  783857
  786056
  786088
  790462
  791068
  791886
  796380
  802551
  811802
  819121
  821034
]
15.67 ms
(8.82%)
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
  389278
  422707
  670399
  670437
  637081
  777831
  781305
  773638
  757894
  774065
  485564
  508353
  399912
  401414
  475322
  478521
  389064
  386994
  422337
  425676
  479871
  495382
  563561
  652388
  599407
  590734
  593263
  599984
  783857
  790462
  796380
  737796
  773058
  758276
  768591
  740269
  706466
  709093
  791068
  791886
  475761
  528449
  385405
  186790
  424017
  447324
  414242
  485230
  651218
  601295
  639853
  419999
  422635
  786056
  118885
  414230
  475748
  479722
  536711
  579127
  661062
  564609
  786088
  811802
  758061
  449216
  475771
  439871
  457250
  472067
  417049
  435610
  450020
  455365
  430043
  469428
  470081
  534170
  483690
  498079
  515289
  519741
  492987
  521014
  212254
  381819
  676996
  736163
  740507
  557921
  475419
  428249
  495557
  487844
  459032
  819121
  821034
  471904
  642666
  774783
  754518
  738249
  749049
  402134
  418801
  487449
  461069
  759829
  722340
  802551
  382108
  390418
  556202
  581036
  604115
  423787
  429107
  526156
  577726
  445020
]
2.40 ms
(1.35%)
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
  118885
  186790
  212254
  381819
  382108
  385405
  386994
  389064
  389278
  390418
  399912
  401414
  402134
  414230
  414242
  417049
  418801
  419999
  422337
  422635
  422707
  423787
  424017
  425676
  428249
  429107
  430043
  435610
  439871
  445020
  447324
  449216
  450020
  455365
  457250
  459032
  461069
  469428
  470081
  471904
  472067
  475322
  475419
  475748
  475761
  475771
  478521
  479722
  479871
  483690
  485230
  485564
  487449
  487844
  492987
  495382
  495557
  498079
  508353
  515289
  519741
  521014
  526156
  528449
  534170
  536711
  556202
  557921
  563561
  564609
  577726
  579127
  581036
  590734
  593263
  599407
  599984
  601295
  604115
  637081
  639853
  642666
  651218
  652388
  661062
  670399
  670437
  676996
  706466
  709093
  722340
  736163
  737796
  738249
  740269
  740507
  749049
  754518
  757894
  758061
  758276
  759829
  768591
  773058
  773638
  774065
  774783
  777831
  781305
  783857
  786056
  786088
  790462
  791068
  791886
  796380
  802551
  811802
  819121
  821034
]
2.22 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красивые вагины соло"
]
1.71 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая вагин соло"
]
1.69 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая вагин соло"
]
1.62 ms
(0.91%)
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.