Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.30 ms
(83.23%)
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
  233748
  383952
  386731
  392780
  401219
  411135
  411710
  438911
  439476
  440745
  448227
  449744
  451544
  453510
  458278
  458295
  458939
  459208
  460700
  462166
  462851
  469265
  470230
  470273
  473219
  473793
  474551
  475230
  478464
  480043
  481220
  481557
  482154
  484827
  485758
  485990
  487123
  487680
  488159
  488968
  491787
  492245
  492636
  495950
  508470
  509064
  510512
  511840
  512739
  515318
  515875
  516200
  518151
  519115
  519184
  520840
  524080
  524341
  525493
  525633
  525641
  526470
  528386
  529684
  536448
  539372
  542477
  544624
  545182
  549513
  550324
  551516
  552101
  554085
  554741
  555352
  555414
  555874
  558368
  558909
  559324
  560162
  563333
  563776
  566692
  567052
  567206
  568505
  576340
  578851
  579568
  579717
  581655
  581998
  586066
  590287
  591079
  591452
  591749
  592793
  593117
  593129
  599540
  600730
  603129
  606218
  612886
  613465
  614365
  633312
  644904
  647140
  655121
  666690
  670088
  673454
  678749
  680794
  682105
  689606
]
15.98 ms
(10.37%)
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
  512739
  539372
  558909
  524080
  525641
  492245
  559324
  563333
  576340
  566692
  579717
  568505
  519115
  567052
  592793
  481557
  549513
  516200
  519184
  524341
  528386
  529684
  593129
  526470
  599540
  591079
  520840
  644904
  462851
  511840
  525633
  518151
  555874
  567206
  666690
  586066
  614365
  591452
  485990
  482154
  581655
  682105
  544624
  612886
  439476
  438911
  488968
  484827
  488159
  515318
  545182
  542477
  555352
  563776
  680794
  655121
  670088
  678749
  647140
  673454
  579568
  581998
  590287
  600730
  603129
  448227
  458278
  458939
  453510
  469265
  515875
  492636
  508470
  411135
  411710
  491787
  458295
  473219
  485758
  495950
  470230
  474551
  487123
  552101
  558368
  551516
  560162
  689606
  554085
  613465
  606218
  459208
  478464
  233748
  401219
  473793
  462166
  470273
  475230
  481220
  449744
  451544
  509064
  487680
  525493
  510512
  383952
  392780
  460700
  591749
  633312
  386731
  480043
  536448
  554741
  555414
  593117
  550324
  578851
  440745
]
2.68 ms
(1.74%)
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
  233748
  383952
  386731
  392780
  401219
  411135
  411710
  438911
  439476
  440745
  448227
  449744
  451544
  453510
  458278
  458295
  458939
  459208
  460700
  462166
  462851
  469265
  470230
  470273
  473219
  473793
  474551
  475230
  478464
  480043
  481220
  481557
  482154
  484827
  485758
  485990
  487123
  487680
  488159
  488968
  491787
  492245
  492636
  495950
  508470
  509064
  510512
  511840
  512739
  515318
  515875
  516200
  518151
  519115
  519184
  520840
  524080
  524341
  525493
  525633
  525641
  526470
  528386
  529684
  536448
  539372
  542477
  544624
  545182
  549513
  550324
  551516
  552101
  554085
  554741
  555352
  555414
  555874
  558368
  558909
  559324
  560162
  563333
  563776
  566692
  567052
  567206
  568505
  576340
  578851
  579568
  579717
  581655
  581998
  586066
  590287
  591079
  591452
  591749
  592793
  593117
  593129
  599540
  600730
  603129
  606218
  612886
  613465
  614365
  633312
  644904
  647140
  655121
  666690
  670088
  673454
  678749
  680794
  682105
  689606
]
2.22 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма на волосах"
]
1.98 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм на волос"
]
1.24 ms
(0.80%)
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.