Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.76 ms
(84.36%)
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
  41776
  66938
  80801
  181242
  198001
  382285
  382575
  388424
  390807
  391527
  393759
  398212
  399865
  411262
  412691
  417099
  417878
  420278
  420700
  421575
  426078
  427089
  428998
  429249
  431205
  434447
  435510
  442546
  457146
  458267
  459434
  459578
  459875
  459993
  461943
  462259
  465118
  466123
  466712
  468111
  469769
  469901
  473617
  473819
  475260
  476547
  477870
  480620
  480867
  544610
  550021
  551810
  552668
  552794
  554979
  557000
  560467
  563718
  564145
  565794
  567676
  570413
  570643
  570690
  571381
  572689
  573100
  579218
  582016
  584051
  585345
  586220
  587054
  588379
  589673
  591422
  591974
  592027
  593838
  597593
  598341
  599240
  599492
  599742
  601857
  602625
  606197
  606668
  609192
  611331
  614803
  615535
  615945
  618300
  618970
  621044
  625150
  627103
  629742
  631583
  636429
  640905
  670034
  672975
  687937
  727668
  741929
  744602
  745728
  758880
  762886
  770444
  775379
  775385
  775630
  780463
  781959
  810392
  810539
  812792
]
16.72 ms
(9.35%)
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
  670034
  672975
  687937
  544610
  550021
  551810
  552668
  552794
  554979
  557000
  560467
  563718
  564145
  565794
  567676
  570413
  570643
  570690
  571381
  572689
  573100
  579218
  582016
  584051
  585345
  586220
  589673
  593838
  598341
  599742
  611331
  625150
  588379
  591974
  599240
  602625
  606668
  609192
  615535
  629742
  631583
  615945
  587054
  591422
  592027
  597593
  599492
  601857
  606197
  614803
  618300
  618970
  627103
  636429
  775379
  775630
  812792
  727668
  770444
  781959
  745728
  741929
  758880
  762886
  744602
  621044
  640905
  775385
  780463
  810392
  810539
  66938
  382285
  382575
  427089
  428998
  429249
  431205
  459578
  459875
  461943
  462259
  468111
  476547
  480867
  80801
  393759
  398212
  411262
  417099
  417878
  420278
  421575
  435510
  442546
  458267
  459434
  459993
  466123
  466712
  469769
  477870
  480620
  390807
  391527
  399865
  412691
  420700
  426078
  434447
  457146
  465118
  469901
  473617
  473819
  475260
  41776
  181242
  198001
  388424
]
3.33 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
  41776
  66938
  80801
  181242
  198001
  382285
  382575
  388424
  390807
  391527
  393759
  398212
  399865
  411262
  412691
  417099
  417878
  420278
  420700
  421575
  426078
  427089
  428998
  429249
  431205
  434447
  435510
  442546
  457146
  458267
  459434
  459578
  459875
  459993
  461943
  462259
  465118
  466123
  466712
  468111
  469769
  469901
  473617
  473819
  475260
  476547
  477870
  480620
  480867
  544610
  550021
  551810
  552668
  552794
  554979
  557000
  560467
  563718
  564145
  565794
  567676
  570413
  570643
  570690
  571381
  572689
  573100
  579218
  582016
  584051
  585345
  586220
  587054
  588379
  589673
  591422
  591974
  592027
  593838
  597593
  598341
  599240
  599492
  599742
  601857
  602625
  606197
  606668
  609192
  611331
  614803
  615535
  615945
  618300
  618970
  621044
  625150
  627103
  629742
  631583
  636429
  640905
  670034
  672975
  687937
  727668
  741929
  744602
  745728
  758880
  762886
  770444
  775379
  775385
  775630
  780463
  781959
  810392
  810539
  812792
]
2.26 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сину"
]
1.93 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "син"
]
1.80 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.