Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.23 ms
(84.39%)
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
  204605
  383149
  391049
  407517
  411342
  412957
  414940
  417028
  419018
  420293
  421151
  421735
  424926
  428772
  428979
  429169
  432889
  435728
  437555
  446137
  446900
  448745
  449096
  452086
  454258
  460976
  464457
  465592
  466806
  467378
  467896
  472902
  473226
  473474
  474761
  485747
  485941
  491828
  498290
  501693
  503165
  505650
  508142
  512587
  517026
  517356
  518054
  518867
  519336
  521459
  525402
  525490
  527016
  534212
  535059
  536637
  538203
  543413
  545670
  549170
  549433
  568306
  569953
  576676
  582767
  584062
  586486
  591135
  597689
  599217
  602743
  603201
  607155
  611315
  615810
  619424
  647669
  676538
  677322
  680934
  688003
  699574
  700328
  710318
  712804
  725303
  725367
  727624
  730933
  736999
  738020
  759731
  765444
  766043
  770464
  772719
  774158
  779237
  788514
  790856
  790957
  793221
  799206
  805128
  806203
  806239
  808613
  815245
  815288
  815591
  815920
  816620
  817466
  817628
  818325
  818939
  819823
  822385
  822986
  825187
]
16.27 ms
(10.08%)
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
  437555
  446900
  448745
  525490
  534212
  518867
  582767
  545670
  710318
  474761
  454258
  491828
  521459
  446137
  535059
  619424
  766043
  383149
  421151
  591135
  725367
  576676
  549433
  676538
  699574
  808613
  825187
  816620
  818939
  817466
  712804
  788514
  793221
  738020
  806203
  817628
  819823
  680934
  700328
  615810
  727624
  765444
  736999
  770464
  790957
  460976
  677322
  725303
  464457
  569953
  429169
  465592
  508142
  498290
  473226
  512587
  538203
  452086
  467896
  518054
  519336
  411342
  435728
  584062
  815288
  822385
  815920
  391049
  428772
  407517
  417028
  414940
  815591
  818325
  822986
  525402
  517026
  543413
  647669
  599217
  607155
  730933
  774158
  428979
  473474
  419018
  467378
  449096
  421735
  485941
  688003
  586486
  602743
  603201
  527016
  779237
  799206
  805128
  806239
  204605
  412957
  505650
  790856
  759731
  472902
  815245
  466806
  772719
  517356
  568306
  549170
  611315
  597689
  424926
  503165
  501693
  536637
  485747
  432889
  420293
]
2.63 ms
(1.63%)
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
  204605
  383149
  391049
  407517
  411342
  412957
  414940
  417028
  419018
  420293
  421151
  421735
  424926
  428772
  428979
  429169
  432889
  435728
  437555
  446137
  446900
  448745
  449096
  452086
  454258
  460976
  464457
  465592
  466806
  467378
  467896
  472902
  473226
  473474
  474761
  485747
  485941
  491828
  498290
  501693
  503165
  505650
  508142
  512587
  517026
  517356
  518054
  518867
  519336
  521459
  525402
  525490
  527016
  534212
  535059
  536637
  538203
  543413
  545670
  549170
  549433
  568306
  569953
  576676
  582767
  584062
  586486
  591135
  597689
  599217
  602743
  603201
  607155
  611315
  615810
  619424
  647669
  676538
  677322
  680934
  688003
  699574
  700328
  710318
  712804
  725303
  725367
  727624
  730933
  736999
  738020
  759731
  765444
  766043
  770464
  772719
  774158
  779237
  788514
  790856
  790957
  793221
  799206
  805128
  806203
  806239
  808613
  815245
  815288
  815591
  815920
  816620
  817466
  817628
  818325
  818939
  819823
  822385
  822986
  825187
]
1.82 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits lick"
]
1.54 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ лиза"
]
1.54 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.87%)
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.