Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.98 ms
(88.85%)
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
  54149
  207970
  339474
  341118
  378309
  383906
  386758
  397642
  407357
  414364
  418052
  464704
  466552
  467615
  468694
  471317
  477464
  485168
  561265
  576530
  583067
  585352
  586315
  590172
  591685
  599808
  604451
  613854
  615423
  616589
  628827
  629279
  629375
  631063
  631711
  632497
  632813
  633926
  633979
  634036
  634194
  635501
  643844
  648490
  649092
  652119
  652641
  654547
  656444
  657316
  657623
  658006
  658162
  658333
  659667
  659701
  660472
  665338
  668371
  669216
  671409
  671855
  673746
  673809
  681461
  682023
  682275
  683592
  686769
  692069
  692104
  692240
  697303
  697736
  707360
  714549
  716346
  717076
  719804
  719830
  719915
  719954
  722491
  723357
  725443
  725563
  725712
  729293
  729570
  730105
  730441
  730717
  731302
  731316
  732002
  732451
  734073
  738179
  739637
  740466
  740761
  741571
  746598
  749034
  750648
  751681
  753253
  764343
  769978
  787015
  796424
  798393
  803333
  803407
  807969
  815564
  818490
  826231
]
10.19 ms
(5.42%)
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
  654547
  657316
  657623
  658006
  658333
  659701
  660472
  682023
  692104
  692240
  697736
  719830
  648490
  652119
  652641
  656444
  658162
  659667
  668371
  671855
  673746
  673809
  681461
  683592
  686769
  692069
  719804
  719954
  576530
  586315
  616589
  628827
  632813
  633979
  634194
  631711
  633926
  634036
  591685
  585352
  590172
  599808
  613854
  615423
  631063
  798393
  807969
  803333
  803407
  725563
  725712
  729293
  730105
  730717
  740761
  741571
  749034
  753253
  769978
  787015
  796424
  725443
  732451
  738179
  740466
  730441
  731302
  751681
  764343
  729570
  732002
  731316
  734073
  739637
  746598
  750648
  629375
  632497
  635501
  643844
  697303
  397642
  477464
  464704
  471317
  466552
  407357
  467615
  386758
  414364
  468694
  604451
  714549
  383906
  207970
  339474
  341118
  378309
  54149
  418052
  826231
  815564
  818490
  485168
  561265
  583067
  649092
  667269
  719915
  665338
  666827
  669216
  671409
  682275
  716346
  717076
  707360
  722491
  723357
  629279
]
4.29 ms
(2.28%)
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
  54149
  207970
  339474
  341118
  378309
  383906
  386758
  397642
  407357
  414364
  418052
  464704
  466552
  467615
  468694
  471317
  477464
  485168
  561265
  576530
  583067
  585352
  586315
  590172
  591685
  599808
  604451
  613854
  615423
  616589
  628827
  629279
  629375
  631063
  631711
  632497
  632813
  633926
  633979
  634036
  634194
  635501
  643844
  648490
  649092
  652119
  652641
  654547
  656444
  657316
  657623
  658006
  658162
  658333
  659667
  659701
  660472
  665338
  668371
  669216
  671409
  671855
  673746
  673809
  681461
  682023
  682275
  683592
  686769
  692069
  692104
  692240
  697303
  697736
  707360
  714549
  716346
  717076
  719804
  719830
  719915
  719954
  722491
  723357
  725443
  725563
  725712
  729293
  729570
  730105
  730441
  730717
  731302
  731316
  732002
  732451
  734073
  738179
  739637
  740466
  740761
  741571
  746598
  749034
  750648
  751681
  753253
  764343
  769978
  787015
  796424
  798393
  803333
  803407
  807969
  815564
  818490
  826231
]
1.92 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big interracial"
]
1.63 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие межрасов"
]
1.46 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.78%)
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.