Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.15 ms
(84.74%)
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
  118450
  119987
  381805
  384082
  384462
  390686
  401414
  403843
  422069
  428932
  429155
  432335
  439022
  451453
  453355
  455248
  457057
  459490
  459821
  460425
  461489
  465065
  465918
  466909
  468118
  470818
  477255
  481376
  481801
  482678
  484120
  487475
  489429
  494379
  494482
  501622
  505285
  524691
  526094
  528115
  528340
  528945
  541517
  547842
  551586
  555947
  557787
  560807
  566129
  567106
  567130
  570409
  570410
  576020
  576292
  576327
  579342
  583669
  585254
  595519
  595592
  596621
  598041
  600172
  602069
  604033
  607073
  608070
  609381
  612438
  620453
  627507
  651926
  652131
  652258
  670997
  671832
  673057
  673448
  675821
  678662
  687913
  693013
  694533
  695770
  697242
  703713
  714580
  720096
  722890
  724824
  727811
  733847
  733861
  733873
  734832
  735103
  736142
  736345
  739423
  750196
  751110
  759667
  769158
  771177
  772579
  781824
  782094
  783709
  785554
  785777
  786052
  786973
  789845
  791134
  794030
  803267
  806635
  813466
  823000
]
15.81 ms
(8.81%)
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
  403843
  460425
  384462
  451453
  118450
  461489
  465918
  528945
  429155
  466909
  468118
  453355
  465065
  482678
  576327
  567106
  576020
  567130
  576292
  598041
  595519
  595592
  627507
  390686
  459490
  455248
  524691
  484120
  526094
  528115
  381805
  401414
  439022
  422069
  432335
  823000
  481801
  470818
  477255
  487475
  489429
  505285
  494379
  494482
  501622
  528340
  481376
  541517
  555947
  557787
  566129
  560807
  570410
  547842
  570409
  652131
  652258
  670997
  671832
  722890
  673057
  678662
  687913
  694533
  695770
  720096
  651926
  673448
  675821
  693013
  697242
  703713
  551586
  579342
  583669
  607073
  609381
  604033
  585254
  612438
  596621
  600172
  608070
  620453
  789845
  791134
  794030
  803267
  781824
  785777
  786973
  736345
  739423
  769158
  772579
  786052
  813466
  724824
  733847
  735103
  750196
  727811
  733873
  736142
  733861
  734832
  759667
  771177
  751110
  602069
  714580
  782094
  783709
  785554
  806635
  428932
  457057
  119987
  384082
  459821
]
3.73 ms
(2.08%)
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
  118450
  119987
  381805
  384082
  384462
  390686
  401414
  403843
  422069
  428932
  429155
  432335
  439022
  451453
  453355
  455248
  457057
  459490
  459821
  460425
  461489
  465065
  465918
  466909
  468118
  470818
  477255
  481376
  481801
  482678
  484120
  487475
  489429
  494379
  494482
  501622
  505285
  524691
  526094
  528115
  528340
  528945
  541517
  547842
  551586
  555947
  557787
  560807
  566129
  567106
  567130
  570409
  570410
  576020
  576292
  576327
  579342
  583669
  585254
  595519
  595592
  596621
  598041
  600172
  602069
  604033
  607073
  608070
  609381
  612438
  620453
  627507
  651926
  652131
  652258
  670997
  671832
  673057
  673448
  675821
  678662
  687913
  693013
  694533
  695770
  697242
  703713
  714580
  720096
  722890
  724824
  727811
  733847
  733861
  733873
  734832
  735103
  736142
  736345
  739423
  750196
  751110
  759667
  769158
  771177
  772579
  781824
  782094
  783709
  785554
  785777
  786052
  786973
  789845
  791134
  794030
  803267
  806635
  813466
  823000
]
2.25 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cute shaved"
]
2.12 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cute бритая"
]
1.75 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cute бритая"
]

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.