Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.55 ms
(82.60%)
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
  6699
  25053
  96239
  117221
  123994
  130126
  220912
  314541
  321806
  383103
  383348
  384593
  384808
  385710
  387039
  390875
  394636
  396115
  397057
  398634
  400944
  402015
  402666
  403966
  404384
  410163
  428383
  428786
  445568
  452609
  466419
  479000
  484827
  484839
  484857
  487116
  488719
  509400
  518470
  520224
  530018
  530493
  533384
  533949
  535644
  535724
  536579
  537206
  540187
  540195
  542964
  545600
  548609
  548625
  564392
  565249
  565255
  566689
  566808
  574166
  578366
  598057
  603172
  606200
  606821
  614992
  624173
  626733
  628086
  628379
  628380
  628388
  632674
  632697
  632975
  633508
  633768
  635185
  637049
  639762
  641667
  644264
  644995
  645232
  649151
  650762
  651199
  666866
  672766
  672767
  673353
  676342
  677705
  680195
  684126
  684312
  701501
  702164
  702927
  705519
  706949
  708421
  711899
  713023
  719335
  721835
  773553
  775915
  775934
  788973
  792059
  809493
  817446
  817450
  818475
  818527
  819272
  820774
  822061
  822845
]
16.33 ms
(10.92%)
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
  390875
  397057
  403966
  479000
  402666
  484839
  484857
  545600
  680195
  624173
  637049
  628380
  614992
  387039
  398634
  452609
  530018
  533949
  536579
  535644
  537206
  548609
  565249
  565255
  666866
  650762
  702164
  684312
  702927
  632975
  598057
  632697
  639762
  628086
  628379
  628388
  641667
  633768
  520224
  518470
  530493
  385710
  383348
  384808
  384593
  383103
  130126
  123994
  220912
  394636
  321806
  314541
  96239
  25053
  6699
  117221
  396115
  402015
  400944
  404384
  410163
  428786
  428383
  817446
  817450
  818475
  822061
  822845
  644995
  818527
  819272
  820774
  466419
  445568
  487116
  484827
  533384
  535724
  540187
  509400
  540195
  488719
  564392
  574166
  566808
  542964
  566689
  672767
  673353
  706949
  708421
  711899
  721835
  649151
  651199
  672766
  676342
  677705
  701501
  705519
  713023
  645232
  684126
  719335
  548625
  578366
  626733
  644264
  632674
  635185
  603172
  606200
  606821
  633508
  792059
  809493
  775915
  775934
  788973
  773553
]
2.67 ms
(1.78%)
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
  6699
  25053
  96239
  117221
  123994
  130126
  220912
  314541
  321806
  383103
  383348
  384593
  384808
  385710
  387039
  390875
  394636
  396115
  397057
  398634
  400944
  402015
  402666
  403966
  404384
  410163
  428383
  428786
  445568
  452609
  466419
  479000
  484827
  484839
  484857
  487116
  488719
  509400
  518470
  520224
  530018
  530493
  533384
  533949
  535644
  535724
  536579
  537206
  540187
  540195
  542964
  545600
  548609
  548625
  564392
  565249
  565255
  566689
  566808
  574166
  578366
  598057
  603172
  606200
  606821
  614992
  624173
  626733
  628086
  628379
  628380
  628388
  632674
  632697
  632975
  633508
  633768
  635185
  637049
  639762
  641667
  644264
  644995
  645232
  649151
  650762
  651199
  666866
  672766
  672767
  673353
  676342
  677705
  680195
  684126
  684312
  701501
  702164
  702927
  705519
  706949
  708421
  711899
  713023
  719335
  721835
  773553
  775915
  775934
  788973
  792059
  809493
  817446
  817450
  818475
  818527
  819272
  820774
  822061
  822845
]
2.21 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "group teen"
]
1.71 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "group teen"
]
1.58 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "group teen"
]

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.