Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.52 ms
(85.68%)
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
  23104
  183979
  382681
  383785
  387742
  388957
  396422
  397992
  398353
  407007
  409163
  409909
  413461
  423802
  427138
  433241
  434342
  440967
  441160
  446795
  449863
  450344
  453100
  453332
  453635
  465335
  466340
  469489
  474874
  475769
  476745
  478041
  480373
  480380
  480383
  480385
  480389
  480395
  480490
  483360
  488968
  493022
  494572
  500358
  504665
  506846
  513195
  513982
  518014
  518822
  521794
  526744
  527882
  528038
  528572
  530728
  533874
  535368
  535403
  541322
  544473
  544500
  545247
  546149
  547784
  549643
  549724
  555026
  555041
  555982
  559737
  570935
  572650
  574387
  574421
  586862
  592970
  592983
  599915
  600347
  605521
  607697
  610582
  631173
  633819
  636426
  647893
  649559
  657788
  661915
  665621
  671886
  716522
  719781
  720459
  724762
  728930
  732248
  734253
  761127
  788879
  788885
  794672
  800876
  801560
  801764
  802914
  806534
  815149
  815196
  815298
  815619
  815624
  815921
  816067
  816363
  816388
  816441
  816465
  816968
]
18.11 ms
(9.05%)
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
  483360
  397992
  398353
  440967
  815149
  815298
  815619
  815921
  816388
  816441
  816465
  816363
  446795
  476745
  480490
  488968
  526744
  527882
  513982
  506846
  530728
  535403
  518014
  555982
  570935
  541322
  559737
  572650
  657788
  665621
  671886
  649559
  716522
  719781
  720459
  555041
  592970
  636426
  788879
  801764
  806534
  734253
  724762
  732248
  788885
  794672
  441160
  434342
  382681
  535368
  504665
  494572
  469489
  513195
  605521
  544500
  549643
  544473
  728930
  453100
  465335
  480373
  474874
  383785
  23104
  387742
  407007
  409909
  816067
  816968
  815624
  449863
  450344
  478041
  480389
  480383
  521794
  500358
  545247
  555026
  574387
  574421
  661915
  546149
  547784
  549724
  592983
  607697
  600347
  610582
  586862
  801560
  761127
  631173
  800876
  802914
  423802
  480395
  409163
  427138
  475769
  528572
  493022
  533874
  518822
  396422
  433241
  528038
  599915
  633819
  480380
  647893
  183979
  388957
  413461
  815196
  466340
  480385
  453332
  453635
]
3.67 ms
(1.83%)
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
  23104
  183979
  382681
  383785
  387742
  388957
  396422
  397992
  398353
  407007
  409163
  409909
  413461
  423802
  427138
  433241
  434342
  440967
  441160
  446795
  449863
  450344
  453100
  453332
  453635
  465335
  466340
  469489
  474874
  475769
  476745
  478041
  480373
  480380
  480383
  480385
  480389
  480395
  480490
  483360
  488968
  493022
  494572
  500358
  504665
  506846
  513195
  513982
  518014
  518822
  521794
  526744
  527882
  528038
  528572
  530728
  533874
  535368
  535403
  541322
  544473
  544500
  545247
  546149
  547784
  549643
  549724
  555026
  555041
  555982
  559737
  570935
  572650
  574387
  574421
  586862
  592970
  592983
  599915
  600347
  605521
  607697
  610582
  631173
  633819
  636426
  647893
  649559
  657788
  661915
  665621
  671886
  716522
  719781
  720459
  724762
  728930
  732248
  734253
  761127
  788879
  788885
  794672
  800876
  801560
  801764
  802914
  806534
  815149
  815196
  815298
  815619
  815624
  815921
  816067
  816363
  816388
  816441
  816465
  816968
]
1.93 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wet mature"
]
1.91 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мокрые mature"
]
1.38 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мокрые mature"
]

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.