Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.65 ms
(82.83%)
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
  65760
  161887
  260158
  301977
  313463
  381966
  389144
  389630
  390406
  397478
  398376
  401334
  405690
  407398
  408911
  411896
  414094
  414119
  414130
  416575
  416613
  416690
  417241
  418577
  418762
  419818
  419998
  425610
  428216
  428250
  429692
  430369
  431381
  435512
  439027
  439307
  439396
  439868
  440068
  441124
  441233
  443245
  443250
  443874
  445428
  446788
  448585
  451650
  452792
  453787
  454368
  454511
  457698
  459331
  462681
  466391
  467089
  469139
  473446
  475431
  479530
  480502
  480656
  487416
  490529
  495170
  498226
  499927
  505385
  510549
  517578
  519361
  522109
  530436
  533042
  535277
  540366
  541797
  541858
  547241
  548185
  556167
  563647
  563866
  564500
  568262
  571553
  582032
  582277
  584323
  591533
  592712
  596402
  598525
  606365
  610035
  636948
  639225
  660578
  661987
  669303
  674943
  681501
  687083
  691204
  705466
  735140
  742305
  742338
  750301
  752589
  758538
  761621
  772717
  796204
  801643
  803108
  809752
  814492
]
17.48 ms
(11.00%)
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
  761621
  735140
  742305
  758538
  772717
  639225
  801643
  381966
  445428
  448585
  390406
  65760
  389630
  398376
  439307
  533042
  547241
  563866
  674943
  582277
  610035
  498226
  563647
  260158
  301977
  313463
  405690
  428216
  431381
  416575
  407398
  408911
  416690
  439396
  417241
  441124
  443874
  418762
  440068
  814492
  446788
  459331
  462681
  475431
  480502
  453787
  457698
  473446
  499927
  517578
  522109
  505385
  510549
  540366
  530436
  535277
  541797
  548185
  582032
  564500
  568262
  541858
  571553
  661987
  660578
  681501
  687083
  691204
  669303
  705466
  556167
  584323
  591533
  592712
  598525
  606365
  596402
  636948
  796204
  809752
  766889
  742338
  752589
  750301
  803108
  161887
  397478
  411896
  419818
  425610
  479530
  401334
  419998
  441233
  451650
  466391
  469139
  429692
  452792
  454368
  487416
  495170
  519361
  389144
  414119
  418577
  430369
  443245
  414094
  435512
  439027
  439868
  443250
  414130
  428250
  416613
  454511
  480656
  490529
  467089
]
2.38 ms
(1.50%)
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
  65760
  161887
  260158
  301977
  313463
  381966
  389144
  389630
  390406
  397478
  398376
  401334
  405690
  407398
  408911
  411896
  414094
  414119
  414130
  416575
  416613
  416690
  417241
  418577
  418762
  419818
  419998
  425610
  428216
  428250
  429692
  430369
  431381
  435512
  439027
  439307
  439396
  439868
  440068
  441124
  441233
  443245
  443250
  443874
  445428
  446788
  448585
  451650
  452792
  453787
  454368
  454511
  457698
  459331
  462681
  466391
  467089
  469139
  473446
  475431
  479530
  480502
  480656
  487416
  490529
  495170
  498226
  499927
  505385
  510549
  517578
  519361
  522109
  530436
  533042
  535277
  540366
  541797
  541858
  547241
  548185
  556167
  563647
  563866
  564500
  568262
  571553
  582032
  582277
  584323
  591533
  592712
  596402
  598525
  606365
  610035
  636948
  639225
  660578
  661987
  669303
  674943
  681501
  687083
  691204
  705466
  735140
  742305
  742338
  750301
  752589
  758538
  761621
  772717
  796204
  801643
  803108
  809752
  814492
]
2.22 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anus masturbation"
]
1.87 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анус мастурбац"
]
1.71 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.03%)
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.