Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.89 ms
(51.18%)
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
  386671
  404101
  410328
  463644
  468914
  480552
  504101
  506444
  513057
  514702
  516061
  520472
  522561
  523044
  524648
  527665
  530397
  533711
  540705
  540708
  541184
  541996
  546164
  549781
  552497
  553707
  554706
  554734
  555677
  555826
  556093
  560164
  560166
  562032
  565382
  569024
  575663
  577679
  582514
  589331
  616839
  617789
  618662
  618955
  621230
  622283
  623352
  626411
  628623
  631136
  633182
  633408
  644850
  648485
  649905
  661357
  661577
  663836
  663893
  669857
  669899
  681234
  685523
  685525
  695674
  696004
  696052
  696685
  696701
  698709
  701628
  713145
  714042
  718600
  718703
  719907
  720474
  721918
  723971
  730499
  734028
  736514
  744933
  748346
  748643
  757026
  758176
  760856
  768770
  769019
  769094
  769118
  774084
  777327
  778523
  779614
  780201
  780230
  782133
  783656
  785103
  785930
  791497
  792058
  792757
  793973
  798837
  798848
  798959
  802803
  804389
  809948
  809966
  810208
  811902
  811987
  812228
  813338
  814715
  828402
]
179.30 ms
(43.72%)
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
  386671
  404101
  410328
  463644
  468914
  480552
  504101
  506444
  513057
  514702
  516061
  520472
  522561
  523044
  524648
  527665
  530397
  533711
  540705
  540708
  541184
  541996
  546164
  549781
  552497
  553707
  554706
  554734
  555677
  555826
  556093
  560164
  560166
  562032
  565382
  569024
  575663
  577679
  582514
  589331
  616839
  617789
  618662
  618955
  621230
  622283
  623352
  626411
  628623
  631136
  633182
  633408
  644850
  648485
  649905
  661357
  661577
  663836
  663893
  669857
  669899
  681234
  685523
  685525
  695674
  696004
  696052
  696685
  696701
  698709
  701628
  713145
  714042
  718600
  718703
  719907
  720474
  721918
  723971
  730499
  734028
  736514
  744933
  748346
  748643
  757026
  758176
  760856
  768770
  769019
  769094
  769118
  774084
  777327
  778523
  779614
  780201
  780230
  782133
  783656
  785103
  785930
  791497
  792058
  792757
  793973
  798837
  798848
  798959
  802803
  804389
  809948
  809966
  810208
  811902
  811987
  812228
  813338
  814715
  828402
]
14.03 ms
(3.42%)
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
  812228
  783656
  813338
  774084
  730499
  760856
  618662
  798959
  524648
  522561
  527665
  582514
  569024
  714042
  649905
  577679
  633408
  463644
  555826
  661357
  780201
  734028
  648485
  513057
  540708
  506444
  552497
  553707
  560164
  556093
  696685
  718703
  661577
  698709
  721918
  626411
  622283
  757026
  793973
  802803
  768770
  769118
  719907
  778523
  785103
  792757
  565382
  386671
  404101
  644850
  814715
  530397
  540705
  533711
  504101
  523044
  549781
  560166
  562032
  575663
  546164
  555677
  685523
  685525
  695674
  663836
  663893
  669857
  669899
  696004
  696052
  713145
  720474
  701628
  718600
  628623
  616839
  631136
  617789
  618955
  623352
  779614
  780230
  792058
  810208
  785930
  791497
  804389
  723971
  736514
  769094
  798837
  798848
  809948
  744933
  748346
  769019
  758176
  748643
  621230
  633182
  696701
  777327
  782133
  809966
  811987
  468914
  589331
  811902
  514702
  480552
  554734
  828402
  410328
  516061
  520472
  541996
  554706
  541184
  681234
]
2.06 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public bathroom"
]
1.65 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц ван"
]
1.58 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.38%)
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.