Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.53 ms
(82.78%)
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
  413898
  417888
  420220
  420685
  425020
  429232
  429791
  430320
  430428
  438715
  441258
  445699
  446460
  448095
  449000
  450652
  452527
  453606
  455527
  455653
  459459
  461772
  470729
  472451
  489616
  490018
  492103
  492583
  495987
  496971
  497567
  499233
  499362
  499502
  501829
  502082
  516915
  518321
  520009
  522008
  522817
  523264
  526123
  526158
  528389
  529471
  534707
  538405
  542105
  542567
  542994
  546627
  547877
  548668
  549401
  549802
  551273
  552471
  557170
  558606
  559219
  560434
  561056
  562716
  564067
  568892
  570084
  570266
  570311
  571254
  578939
  581692
  586482
  596267
  596996
  599929
  622613
  654473
  654771
  655624
  657370
  659280
  660910
  665404
  667138
  668849
  670414
  680112
  702601
  717904
  722181
  724593
  725380
  729867
  730582
  744564
  773090
  779623
  781219
  783191
  783734
  785444
  787409
  791032
  792694
  807101
  809231
  814139
  817616
  819174
  819531
  819951
  824051
  825246
  825307
  828152
  828854
]
15.87 ms
(10.55%)
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
  596996
  449000
  825307
  783734
  561056
  526123
  470729
  828854
  828152
  654771
  430428
  413898
  570084
  425020
  420685
  438715
  546627
  489616
  548668
  558606
  586482
  453606
  446460
  523264
  448095
  445699
  559219
  717904
  599929
  785444
  495987
  502082
  542105
  516915
  496971
  538405
  452527
  660910
  655624
  722181
  557170
  670414
  668849
  667138
  549401
  578939
  783191
  744564
  729867
  773090
  725380
  779623
  809231
  501829
  497567
  441258
  472451
  552471
  562716
  518321
  522817
  492103
  499233
  499362
  571254
  564067
  596267
  455527
  430320
  499502
  526158
  522008
  560434
  417888
  680112
  490018
  429791
  455653
  542994
  702601
  781219
  819174
  826039
  779967
  819531
  825246
  807101
  787409
  542567
  657370
  549802
  461772
  814139
  568892
  570311
  547877
  528389
  534707
  551273
  659280
  581692
  570266
  492583
  529471
  450652
  622613
  824051
  654473
  459459
  520009
  665404
  420220
  429232
  819951
  817616
  822676
  791032
  730582
  724593
  792694
]
2.79 ms
(1.86%)
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
  413898
  417888
  420220
  420685
  425020
  429232
  429791
  430320
  430428
  438715
  441258
  445699
  446460
  448095
  449000
  450652
  452527
  453606
  455527
  455653
  459459
  461772
  470729
  472451
  489616
  490018
  492103
  492583
  495987
  496971
  497567
  499233
  499362
  499502
  501829
  502082
  516915
  518321
  520009
  522008
  522817
  523264
  526123
  526158
  528389
  529471
  534707
  538405
  542105
  542567
  542994
  546627
  547877
  548668
  549401
  549802
  551273
  552471
  557170
  558606
  559219
  560434
  561056
  562716
  564067
  568892
  570084
  570266
  570311
  571254
  578939
  581692
  586482
  596267
  596996
  599929
  622613
  654473
  654771
  655624
  657370
  659280
  660910
  665404
  667138
  668849
  670414
  680112
  702601
  717904
  722181
  724593
  725380
  729867
  730582
  744564
  773090
  779623
  781219
  783191
  783734
  785444
  787409
  791032
  792694
  807101
  809231
  814139
  817616
  819174
  819531
  819951
  824051
  825246
  825307
  828152
  828854
]
2.14 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая дрочит минет"
]
1.81 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая дрочк минет оральн секс"
]
1.72 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.04%)
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.