Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.75 ms
(84.03%)
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
  239808
  397962
  402912
  411133
  412857
  418389
  419999
  420864
  421552
  425294
  427341
  429259
  433940
  439169
  443448
  445012
  447310
  453221
  458238
  458639
  459664
  460542
  461873
  462540
  465754
  467645
  472739
  475584
  477206
  479980
  482258
  482699
  484350
  484952
  484960
  485230
  485298
  495030
  497262
  498479
  498603
  498972
  512702
  516740
  519125
  519873
  521368
  521752
  522226
  529087
  538739
  547726
  551732
  552169
  559199
  565289
  565296
  567190
  570142
  571986
  576154
  576544
  586601
  588846
  589979
  594280
  598043
  598549
  598914
  599460
  613247
  617312
  620566
  627310
  627656
  627794
  631598
  637369
  641207
  642155
  661046
  676194
  678620
  693433
  693944
  706173
  709093
  717502
  722405
  723007
  725183
  735036
  735699
  736639
  737095
  739332
  740500
  748437
  749995
  754000
  754580
  756204
  757857
  766131
  766429
  766854
  770476
  774266
  777899
  784679
  785207
  786756
  797718
  799499
  809323
  810741
  814499
  819932
  824602
  825488
]
19.78 ms
(10.47%)
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
  498479
  482699
  522226
  397962
  693433
  749995
  766854
  552169
  461873
  465754
  485298
  598914
  512702
  453221
  462540
  516740
  706173
  484952
  411133
  475584
  482258
  497262
  571986
  661046
  576154
  479980
  676194
  589979
  613247
  617312
  642155
  598549
  627656
  641207
  814499
  819932
  458238
  538739
  735036
  774266
  485230
  559199
  567190
  547726
  588846
  599460
  425294
  419999
  439169
  445012
  458639
  421552
  519873
  620566
  484350
  521368
  460542
  433940
  757857
  576544
  722405
  627794
  723007
  586601
  521752
  766429
  420864
  784679
  498603
  565296
  551732
  598043
  637369
  627310
  570142
  427341
  472739
  529087
  565289
  631598
  447310
  484960
  459664
  678620
  594280
  467645
  477206
  519125
  693944
  824602
  717502
  754580
  735699
  740500
  725183
  737095
  754000
  785207
  756204
  736639
  766131
  739332
  748437
  770476
  777899
  797718
  799499
  809323
  402912
  418389
  239808
  498972
  495030
  786756
  709093
  810741
  412857
  429259
  443448
  825488
]
2.45 ms
(1.30%)
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
  239808
  397962
  402912
  411133
  412857
  418389
  419999
  420864
  421552
  425294
  427341
  429259
  433940
  439169
  443448
  445012
  447310
  453221
  458238
  458639
  459664
  460542
  461873
  462540
  465754
  467645
  472739
  475584
  477206
  479980
  482258
  482699
  484350
  484952
  484960
  485230
  485298
  495030
  497262
  498479
  498603
  498972
  512702
  516740
  519125
  519873
  521368
  521752
  522226
  529087
  538739
  547726
  551732
  552169
  559199
  565289
  565296
  567190
  570142
  571986
  576154
  576544
  586601
  588846
  589979
  594280
  598043
  598549
  598914
  599460
  613247
  617312
  620566
  627310
  627656
  627794
  631598
  637369
  641207
  642155
  661046
  676194
  678620
  693433
  693944
  706173
  709093
  717502
  722405
  723007
  725183
  735036
  735699
  736639
  737095
  739332
  740500
  748437
  749995
  754000
  754580
  756204
  757857
  766131
  766429
  766854
  770476
  774266
  777899
  784679
  785207
  786756
  797718
  799499
  809323
  810741
  814499
  819932
  824602
  825488
]
2.34 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодежь красотки домашнее"
]
2.06 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые молодая девушк молодой красивая домашн любительск"
]
1.81 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.92%)
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.