Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.84 ms
(83.97%)
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
  9981
  50215
  390083
  401885
  411917
  417137
  427006
  429189
  438460
  439474
  442800
  452332
  458116
  458750
  460555
  469810
  484522
  484799
  502766
  506233
  506652
  523926
  527494
  527541
  529020
  529057
  533735
  534116
  534118
  534120
  535639
  538960
  540363
  544609
  551292
  555399
  560275
  568312
  573046
  573572
  573720
  573827
  573872
  574789
  577013
  584583
  588569
  589757
  593516
  594613
  600232
  603290
  604822
  605743
  605963
  620938
  620980
  621161
  623525
  636821
  641386
  641767
  643835
  645956
  661693
  663176
  664545
  666371
  671090
  672285
  673488
  675378
  679399
  692345
  696278
  698495
  698791
  707765
  709837
  711358
  712111
  712226
  712593
  716818
  729815
  733651
  735263
  738443
  740095
  744262
  744882
  747701
  747904
  749696
  749968
  750655
  751948
  758082
  778888
  779277
  781357
  781513
  784877
  785986
  790630
  794222
  799103
  800298
  801079
  801517
  805776
  807726
  810670
  813629
  814052
  816147
  822718
  823360
  824224
  825791
]
14.09 ms
(9.18%)
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
  816147
  824224
  825791
  814052
  458116
  506652
  533735
  484799
  712593
  692345
  707765
  641386
  641767
  784877
  805776
  807726
  735263
  744882
  749968
  751948
  781513
  810670
  747701
  758082
  729815
  744262
  750655
  778888
  779277
  794222
  50215
  429189
  458750
  573720
  577013
  636821
  390083
  645956
  679399
  588569
  749696
  502766
  593516
  411917
  452332
  523926
  527494
  540363
  573046
  672285
  604822
  605963
  799103
  801517
  623525
  643835
  698791
  438460
  417137
  442800
  506233
  544609
  664545
  529020
  527541
  560275
  573572
  573827
  574789
  427006
  813629
  823360
  822718
  469810
  484522
  538960
  529057
  534116
  534118
  534120
  535639
  555399
  573872
  568312
  551292
  663176
  673488
  696278
  711358
  671090
  698495
  712226
  661693
  666371
  712111
  584583
  605743
  589757
  594613
  620938
  620980
  621161
  801079
  790630
  781357
  747904
  738443
  733651
  740095
  709837
  716818
  785986
  800298
  9981
  401885
  439474
  603290
  600232
  675378
  460555
]
3.10 ms
(2.02%)
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
  9981
  50215
  390083
  401885
  411917
  417137
  427006
  429189
  438460
  439474
  442800
  452332
  458116
  458750
  460555
  469810
  484522
  484799
  502766
  506233
  506652
  523926
  527494
  527541
  529020
  529057
  533735
  534116
  534118
  534120
  535639
  538960
  540363
  544609
  551292
  555399
  560275
  568312
  573046
  573572
  573720
  573827
  573872
  574789
  577013
  584583
  588569
  589757
  593516
  594613
  600232
  603290
  604822
  605743
  605963
  620938
  620980
  621161
  623525
  636821
  641386
  641767
  643835
  645956
  661693
  663176
  664545
  666371
  671090
  672285
  673488
  675378
  679399
  692345
  696278
  698495
  698791
  707765
  709837
  711358
  712111
  712226
  712593
  716818
  729815
  733651
  735263
  738443
  740095
  744262
  744882
  747701
  747904
  749696
  749968
  750655
  751948
  758082
  778888
  779277
  781357
  781513
  784877
  785986
  790630
  794222
  799103
  800298
  801079
  801517
  805776
  807726
  810670
  813629
  814052
  816147
  822718
  823360
  824224
  825791
]
1.95 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "porn вагин"
]
1.93 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "porn vagina"
]
1.60 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "porn вагин"
]

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.