Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.99 ms
(85.05%)
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
  388936
  411768
  420200
  431558
  445363
  445571
  447705
  454296
  456176
  457127
  459364
  461500
  465473
  465625
  466851
  467380
  468149
  468565
  469044
  469598
  474297
  474699
  475227
  479346
  479700
  479728
  481075
  482602
  482688
  485556
  486637
  486648
  487643
  493469
  497934
  497941
  498474
  498525
  498951
  499794
  500768
  503167
  505841
  506513
  515511
  519612
  520976
  521452
  521865
  523006
  525090
  526695
  526892
  533566
  538729
  552695
  554426
  557664
  564408
  567761
  569539
  572732
  576785
  578302
  579406
  583143
  584827
  587915
  588517
  597892
  602044
  603261
  606568
  606574
  613493
  615370
  620025
  621794
  622230
  625673
  634314
  634545
  644021
  644951
  653432
  653580
  654369
  662399
  662430
  668834
  668975
  673822
  678903
  681152
  694178
  702165
  721431
  721537
  737628
  740254
  744723
  755705
  755800
  758564
  772815
  773475
  773758
  779074
  785186
  785226
  785628
  785727
  792767
  800073
  803392
  813091
  813455
  817445
  819980
  826571
]
14.84 ms
(8.59%)
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
  785186
  785727
  773758
  758564
  721431
  461500
  499794
  538729
  467380
  474297
  485556
  447705
  469598
  515511
  468565
  469044
  603261
  468149
  456176
  479346
  498951
  506513
  497934
  388936
  819980
  644951
  564408
  576785
  662399
  678903
  662430
  673822
  569539
  583143
  634314
  785628
  813455
  737628
  772815
  800073
  813091
  740254
  744723
  602044
  644021
  702165
  779074
  792767
  474699
  500768
  498525
  526892
  533566
  498474
  505841
  668834
  755800
  457127
  445571
  481075
  521865
  493469
  521452
  621794
  465473
  459364
  482688
  479728
  523006
  519612
  520976
  503167
  486648
  578302
  681152
  431558
  466851
  482602
  479700
  497941
  526695
  653580
  606574
  625673
  465625
  475227
  445363
  454296
  486637
  525090
  487643
  420200
  826571
  817445
  552695
  694178
  653432
  654369
  721537
  668975
  579406
  584827
  587915
  622230
  588517
  613493
  620025
  606568
  597892
  785226
  803392
  755705
  773475
  411768
  572732
  554426
  557664
  567761
  634545
  615370
]
3.46 ms
(2.00%)
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
  388936
  411768
  420200
  431558
  445363
  445571
  447705
  454296
  456176
  457127
  459364
  461500
  465473
  465625
  466851
  467380
  468149
  468565
  469044
  469598
  474297
  474699
  475227
  479346
  479700
  479728
  481075
  482602
  482688
  485556
  486637
  486648
  487643
  493469
  497934
  497941
  498474
  498525
  498951
  499794
  500768
  503167
  505841
  506513
  515511
  519612
  520976
  521452
  521865
  523006
  525090
  526695
  526892
  533566
  538729
  552695
  554426
  557664
  564408
  567761
  569539
  572732
  576785
  578302
  579406
  583143
  584827
  587915
  588517
  597892
  602044
  603261
  606568
  606574
  613493
  615370
  620025
  621794
  622230
  625673
  634314
  634545
  644021
  644951
  653432
  653580
  654369
  662399
  662430
  668834
  668975
  673822
  678903
  681152
  694178
  702165
  721431
  721537
  737628
  740254
  744723
  755705
  755800
  758564
  772815
  773475
  773758
  779074
  785186
  785226
  785628
  785727
  792767
  800073
  803392
  813091
  813455
  817445
  819980
  826571
]
2.10 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doll dick"
]
2.00 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doll член"
]
1.93 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doll член"
]

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.