Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.51 ms
(87.93%)
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
  2779
  66792
  73503
  122767
  153402
  153602
  169326
  191361
  239109
  307342
  342450
  350700
  382982
  383097
  383442
  386204
  386807
  387548
  388157
  388559
  389593
  390807
  391669
  392943
  396428
  397421
  401139
  403085
  429193
  434612
  434688
  435520
  436645
  438293
  439569
  442225
  443415
  445902
  447461
  447853
  454016
  460088
  461534
  465903
  466155
  466778
  474108
  485595
  486145
  487178
  493148
  501407
  510637
  510640
  512309
  512643
  516380
  516751
  521200
  521228
  532818
  547309
  551157
  552124
  552138
  552161
  552239
  552243
  552671
  557998
  558829
  559129
  560397
  562280
  562317
  567423
  569868
  569875
  570004
  570207
  570245
  570498
  570533
  571539
  571593
  571643
  571895
  573115
  573413
  573703
  573855
  579156
  582484
  583811
  612173
  617102
  624465
  631595
  663931
  665256
  701518
  715406
  716035
  716559
  726599
  728447
  737936
  755757
  765306
  770616
  781685
  786334
  793587
  796211
  799004
  801226
  804194
  810972
  820726
  824022
]
14.02 ms
(7.02%)
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
  434688
  438293
  436645
  532818
  486145
  570245
  573703
  562280
  569868
  573115
  701518
  716559
  552239
  552243
  558829
  560397
  571895
  573855
  617102
  765306
  726599
  793587
  796211
  810972
  350700
  396428
  2779
  447461
  191361
  122767
  388559
  401139
  435520
  501407
  512309
  521228
  510637
  439569
  434612
  474108
  447853
  552671
  557998
  552124
  567423
  631595
  466155
  466778
  390807
  461534
  389593
  801226
  239109
  397421
  391669
  386807
  73503
  169326
  820726
  551157
  559129
  583811
  547309
  665256
  716035
  624465
  737936
  770616
  755757
  715406
  383442
  392943
  307342
  388157
  383097
  382982
  342450
  387548
  443415
  429193
  824022
  445902
  460088
  465903
  487178
  569875
  552161
  570004
  570207
  571643
  573413
  552138
  571539
  571593
  579156
  663931
  562317
  570498
  570533
  582484
  612173
  786334
  728447
  781685
  799004
  804194
  153402
  386204
  454016
  403085
  442225
  510640
  516751
  493148
  521200
  485595
  512643
  516380
  66792
  153602
]
2.64 ms
(1.32%)
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
  2779
  66792
  73503
  122767
  153402
  153602
  169326
  191361
  239109
  307342
  342450
  350700
  382982
  383097
  383442
  386204
  386807
  387548
  388157
  388559
  389593
  390807
  391669
  392943
  396428
  397421
  401139
  403085
  429193
  434612
  434688
  435520
  436645
  438293
  439569
  442225
  443415
  445902
  447461
  447853
  454016
  460088
  461534
  465903
  466155
  466778
  474108
  485595
  486145
  487178
  493148
  501407
  510637
  510640
  512309
  512643
  516380
  516751
  521200
  521228
  532818
  547309
  551157
  552124
  552138
  552161
  552239
  552243
  552671
  557998
  558829
  559129
  560397
  562280
  562317
  567423
  569868
  569875
  570004
  570207
  570245
  570498
  570533
  571539
  571593
  571643
  571895
  573115
  573413
  573703
  573855
  579156
  582484
  583811
  612173
  617102
  624465
  631595
  663931
  665256
  701518
  715406
  716035
  716559
  726599
  728447
  737936
  755757
  765306
  770616
  781685
  786334
  793587
  796211
  799004
  801226
  804194
  810972
  820726
  824022
]
1.98 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing парен"
]
1.88 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing boy"
]
1.83 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing парен"
]

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.