Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.41 ms
(82.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
  6937
  177447
  278428
  350425
  383408
  384423
  385563
  394116
  395460
  395612
  402777
  402882
  403663
  404734
  405725
  406841
  407293
  408024
  412066
  413816
  414085
  419078
  420064
  427336
  429043
  429757
  431918
  433582
  433781
  438816
  439899
  444746
  452126
  453367
  456302
  456340
  457877
  457898
  458513
  458639
  458872
  459969
  459973
  459989
  460620
  460997
  461101
  463381
  463562
  463590
  463595
  465122
  467942
  469931
  470121
  471173
  471386
  473518
  473532
  476029
  476110
  476818
  477973
  478609
  478861
  480134
  480895
  482014
  483336
  483683
  484520
  489897
  494378
  495653
  499012
  507755
  508947
  514623
  516915
  517786
  517905
  521890
  522524
  522766
  523700
  524367
  525676
  526078
  526770
  527068
  527107
  528777
  529087
  530823
  531668
  531689
  537794
  551409
  553751
  554098
  557657
  561411
  567706
  581922
  584466
  585437
  588037
  601179
  611181
  618747
  647983
  730884
  809410
  811052
  811076
  818925
  825142
]
17.16 ms
(10.76%)
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
  809410
  427336
  460620
  412066
  471386
  395612
  406841
  438816
  494378
  524367
  483683
  526078
  527107
  507755
  517786
  825142
  818925
  531689
  530823
  531668
  537794
  730884
  413816
  588037
  429757
  463562
  459983
  452126
  405725
  459987
  508947
  529087
  495653
  513753
  514623
  525676
  528777
  557657
  567706
  647983
  554098
  585437
  601179
  611181
  478861
  618747
  383408
  394116
  395460
  278428
  350425
  403663
  419078
  407293
  431918
  429043
  433582
  444746
  473518
  476110
  480134
  456340
  459973
  459989
  461101
  463595
  482014
  483336
  489897
  459969
  463590
  473532
  476818
  484520
  499012
  527068
  553751
  581922
  551409
  561411
  584466
  811052
  811076
  6937
  177447
  404734
  408024
  453367
  470121
  402882
  414085
  433781
  458639
  458872
  384423
  385563
  420064
  439899
  465122
  471173
  477973
  478609
  402777
  457877
  457898
  458513
  460997
  463381
  469931
  480895
  456302
  467942
  476029
  516915
  517905
  521890
  522524
  522766
  523700
  526770
]
2.91 ms
(1.82%)
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
  6937
  177447
  278428
  350425
  383408
  384423
  385563
  394116
  395460
  395612
  402777
  402882
  403663
  404734
  405725
  406841
  407293
  408024
  412066
  413816
  414085
  419078
  420064
  427336
  429043
  429757
  431918
  433582
  433781
  438816
  439899
  444746
  452126
  453367
  456302
  456340
  457877
  457898
  458513
  458639
  458872
  459969
  459973
  459989
  460620
  460997
  461101
  463381
  463562
  463590
  463595
  465122
  467942
  469931
  470121
  471173
  471386
  473518
  473532
  476029
  476110
  476818
  477973
  478609
  478861
  480134
  480895
  482014
  483336
  483683
  484520
  489897
  494378
  495653
  499012
  507755
  508947
  514623
  516915
  517786
  517905
  521890
  522524
  522766
  523700
  524367
  525676
  526078
  526770
  527068
  527107
  528777
  529087
  530823
  531668
  531689
  537794
  551409
  553751
  554098
  557657
  561411
  567706
  581922
  584466
  585437
  588037
  601179
  611181
  618747
  647983
  730884
  809410
  811052
  811076
  818925
  825142
]
2.29 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спортивные с большой %…"
]
2.14 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спортивная большой большие"
]
1.88 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.11%)
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.