Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.08 ms
(83.51%)
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
  7286
  324916
  373416
  391423
  402598
  417722
  417731
  417744
  420232
  424014
  425018
  429256
  429263
  429273
  429275
  443645
  450646
  450653
  450861
  451580
  451601
  453139
  454075
  454335
  460030
  461005
  461314
  461621
  463240
  464582
  466110
  466786
  467300
  468867
  468879
  470345
  471786
  471971
  472332
  472356
  472370
  472801
  475282
  477567
  478087
  478905
  480717
  480922
  481641
  483992
  484072
  485903
  488219
  491566
  491696
  491724
  491865
  499805
  501865
  504613
  508818
  510082
  511299
  512464
  513445
  516993
  517254
  519657
  520461
  521923
  522807
  548650
  551173
  551565
  552661
  559022
  559236
  562290
  562319
  565391
  565424
  566576
  569843
  570033
  570034
  570037
  570256
  570289
  570338
  570340
  570351
  570370
  570478
  570526
  570528
  570559
  570605
  570609
  570647
  571630
  571646
  571854
  572134
  572442
  572504
  573004
  573858
  574598
  574861
  575208
  589758
  590573
  597836
  605913
  665513
  669457
  669641
  820628
  828269
  828338
]
17.22 ms
(10.34%)
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
  548650
  574861
  575208
  551565
  572134
  570605
  574598
  472801
  464582
  391423
  402598
  450646
  450653
  463240
  461005
  466110
  471971
  417722
  425018
  451580
  491566
  510082
  488219
  828269
  461621
  665513
  597836
  417744
  429256
  471786
  483992
  559236
  565391
  566576
  589758
  424014
  443645
  481641
  472370
  478905
  429263
  480717
  472332
  511299
  513445
  516993
  491865
  501865
  521923
  491724
  508818
  828338
  324916
  7286
  477567
  571630
  570609
  570370
  573858
  669457
  551173
  571646
  454335
  451601
  470345
  475282
  512464
  517254
  468867
  565424
  570351
  571854
  572504
  570256
  570289
  559022
  562319
  570037
  570033
  570478
  417731
  468879
  429273
  472356
  504613
  522807
  491696
  590573
  453139
  450861
  478087
  420232
  499805
  519657
  520461
  820628
  669641
  605913
  373416
  429275
  466786
  485903
  454075
  480922
  484072
  460030
  461314
  467300
  570526
  570559
  572442
  562290
  569843
  570034
  570338
  570340
  570528
  570647
  573004
  552661
]
3.21 ms
(1.93%)
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
  7286
  324916
  373416
  391423
  402598
  417722
  417731
  417744
  420232
  424014
  425018
  429256
  429263
  429273
  429275
  443645
  450646
  450653
  450861
  451580
  451601
  453139
  454075
  454335
  460030
  461005
  461314
  461621
  463240
  464582
  466110
  466786
  467300
  468867
  468879
  470345
  471786
  471971
  472332
  472356
  472370
  472801
  475282
  477567
  478087
  478905
  480717
  480922
  481641
  483992
  484072
  485903
  488219
  491566
  491696
  491724
  491865
  499805
  501865
  504613
  508818
  510082
  511299
  512464
  513445
  516993
  517254
  519657
  520461
  521923
  522807
  548650
  551173
  551565
  552661
  559022
  559236
  562290
  562319
  565391
  565424
  566576
  569843
  570033
  570034
  570037
  570256
  570289
  570338
  570340
  570351
  570370
  570478
  570526
  570528
  570559
  570605
  570609
  570647
  571630
  571646
  571854
  572134
  572442
  572504
  573004
  573858
  574598
  574861
  575208
  589758
  590573
  597836
  605913
  665513
  669457
  669641
  820628
  828269
  828338
]
1.97 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап ххх"
]
1.95 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пикап ххх"
]
1.61 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.90%)
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.