Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
410.68 ms
(92.00%)
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
  414972
  418383
  418869
  421189
  422062
  424809
  434008
  437361
  438415
  442399
  442431
  442991
  445884
  446612
  449133
  457023
  458082
  459245
  459783
  460284
  460447
  460641
  463691
  469183
  473599
  474053
  475201
  477693
  478157
  478723
  480891
  483263
  488519
  492233
  497180
  499953
  500013
  504017
  514073
  517370
  517934
  518257
  524783
  525776
  532042
  538000
  540909
  548636
  549477
  549511
  552330
  552351
  552534
  554248
  557557
  557724
  559555
  561177
  562732
  566259
  568097
  568853
  569466
  571067
  579189
  579209
  579751
  583414
  589133
  593741
  598412
  598765
  599722
  605261
  606622
  616812
  619878
  620676
  622054
  626436
  647146
  650751
  651214
  670848
  689002
  697414
  699604
  717493
  718958
  723945
  723955
  724045
  724456
  727891
  744563
  757114
  764604
  769536
  770600
  772446
  775270
  779678
  779904
  788158
  790812
  793567
  802814
  805276
  808521
  809260
  812817
  813004
  813491
  816687
  821904
]
25.32 ms
(5.67%)
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
  437361
  418869
  438415
  816687
  463691
  473599
  449133
  480891
  457023
  458082
  459245
  460284
  460641
  504017
  514073
  532042
  525776
  538000
  469183
  474053
  488519
  583414
  549477
  549511
  562732
  579209
  552351
  552534
  569466
  716936
  717493
  689002
  697414
  718958
  647146
  651214
  554248
  579189
  593741
  598412
  619878
  605261
  599722
  620676
  779904
  790812
  805276
  808521
  813491
  775270
  788158
  809260
  812817
  813004
  723955
  724045
  727891
  770600
  772446
  724456
  744563
  769536
  723945
  764604
  757114
  618229
  699604
  779678
  793567
  802814
  475201
  434008
  414972
  421189
  445884
  459783
  418383
  424809
  442431
  460447
  477693
  478157
  517370
  492233
  499953
  626436
  557724
  552330
  446612
  483263
  517934
  442991
  422062
  442399
  821904
  500013
  524783
  510295
  527201
  497180
  518257
  478723
  540909
  548636
  566259
  571067
  579751
  557557
  568853
  650751
  670848
  676582
  559555
  561177
  568097
  589133
  598765
  606622
  616812
  622054
]
2.45 ms
(0.55%)
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
  414972
  418383
  418869
  421189
  422062
  424809
  434008
  437361
  438415
  442399
  442431
  442991
  445884
  446612
  449133
  457023
  458082
  459245
  459783
  460284
  460447
  460641
  463691
  469183
  473599
  474053
  475201
  477693
  478157
  478723
  480891
  483263
  488519
  492233
  497180
  499953
  500013
  504017
  514073
  517370
  517934
  518257
  524783
  525776
  532042
  538000
  540909
  548636
  549477
  549511
  552330
  552351
  552534
  554248
  557557
  557724
  559555
  561177
  562732
  566259
  568097
  568853
  569466
  571067
  579189
  579209
  579751
  583414
  589133
  593741
  598412
  598765
  599722
  605261
  606622
  616812
  619878
  620676
  622054
  626436
  647146
  650751
  651214
  670848
  689002
  697414
  699604
  717493
  718958
  723945
  723955
  724045
  724456
  727891
  744563
  757114
  764604
  769536
  770600
  772446
  775270
  779678
  779904
  788158
  790812
  793567
  802814
  805276
  808521
  809260
  812817
  813004
  813491
  816687
  821904
]
2.31 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov caught"
]
2.09 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов caught"
]
1.77 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов caught"
]
1.76 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.