Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.28 ms
(59.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
117.96 ms
(33.08%)
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
  24149
  36832
  78926
  142471
  190773
  251363
  381776
  384789
  390967
  393429
  396171
  396270
  396522
  399038
  399089
  399511
  400439
  400446
  400450
  400455
  400927
  401091
  401922
  402012
  402088
  403045
  403331
  404746
  404845
  411956
  412966
  413296
  415573
  418883
  418946
  420104
  421871
  423412
  433143
  443138
  444784
  445439
  446165
  446536
  447718
  448310
  449019
  450612
  453000
  453669
  454687
  454790
  455332
  458992
  459191
  459798
  460771
  461936
  463725
  463862
  465461
  467163
  468579
  469874
  470941
  472469
  472567
  474066
  474844
  476288
  476453
  478756
  479967
  480901
  482074
  484203
  489328
  489470
  492393
  495158
  499270
  501500
  506824
  510629
  513606
  520551
  521375
  522919
  523050
  523562
  524176
  528463
  529248
  550354
  556969
  559684
  560113
  566623
  566783
  566786
  569666
  569933
  575176
  581613
  594231
  596543
  597791
  720487
  722705
  736917
  743142
  765445
  765446
  766990
  767961
  774155
  774160
  784908
  807772
  812150
]
18.26 ms
(5.12%)
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
  24149
  381776
  418946
  523050
  559684
  455332
  420104
  190773
  445439
  399038
  510629
  566623
  449019
  448310
  596543
  463725
  423412
  479967
  499270
  569933
  454790
  404746
  482074
  521375
  459798
  484203
  566783
  399089
  492393
  468579
  522919
  784908
  433143
  458992
  575176
  523562
  415573
  520551
  524176
  476453
  474844
  412966
  446536
  402012
  450612
  489470
  401091
  550354
  506824
  465461
  476288
  463862
  461936
  418883
  528463
  467163
  459191
  480901
  478756
  560113
  142471
  472469
  454687
  453669
  411956
  443138
  453000
  446165
  472567
  470941
  566786
  447718
  444784
  501500
  474066
  513606
  421871
  460771
  489328
  597791
  594231
  767961
  495158
  403045
  400455
  400450
  402088
  401922
  743142
  720487
  399511
  556969
  393429
  396522
  529248
  722705
  400439
  736917
  774160
  569666
  400927
  251363
  396171
  78926
  396270
  390967
  403331
  400446
  36832
  766990
  469874
  581613
  812150
  765445
  765446
  774155
  413296
  404845
  807772
  384789
]
3.15 ms
(0.88%)
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
  24149
  36832
  78926
  142471
  190773
  251363
  381776
  384789
  390967
  393429
  396171
  396270
  396522
  399038
  399089
  399511
  400439
  400446
  400450
  400455
  400927
  401091
  401922
  402012
  402088
  403045
  403331
  404746
  404845
  411956
  412966
  413296
  415573
  418883
  418946
  420104
  421871
  423412
  433143
  443138
  444784
  445439
  446165
  446536
  447718
  448310
  449019
  450612
  453000
  453669
  454687
  454790
  455332
  458992
  459191
  459798
  460771
  461936
  463725
  463862
  465461
  467163
  468579
  469874
  470941
  472469
  472567
  474066
  474844
  476288
  476453
  478756
  479967
  480901
  482074
  484203
  489328
  489470
  492393
  495158
  499270
  501500
  506824
  510629
  513606
  520551
  521375
  522919
  523050
  523562
  524176
  528463
  529248
  550354
  556969
  559684
  560113
  566623
  566783
  566786
  569666
  569933
  575176
  581613
  594231
  596543
  597791
  720487
  722705
  736917
  743142
  765445
  765446
  766990
  767961
  774155
  774160
  784908
  807772
  812150
]
2.26 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man blowjob"
]
1.84 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин минет оральн секс"
]
1.83 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.