Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.79 ms
(84.74%)
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
  155232
  263548
  396339
  400802
  411454
  414277
  423812
  425948
  429892
  433939
  434645
  435563
  435798
  437190
  439103
  439230
  439345
  440641
  446251
  448854
  448915
  449930
  450707
  452914
  454800
  457486
  467588
  469437
  469741
  473873
  475426
  490232
  509921
  513223
  513522
  518372
  522579
  523058
  534953
  535319
  536914
  547470
  554989
  569345
  584039
  584046
  584362
  585788
  586876
  589390
  589701
  592662
  595138
  595318
  598272
  598814
  602416
  606254
  607706
  608516
  617045
  623821
  626082
  638671
  638941
  651690
  654048
  667045
  670782
  672317
  678707
  691989
  705825
  705999
  706446
  706717
  707408
  708062
  709754
  714203
  719461
  736024
  738446
  739089
  746201
  757232
  757883
  758780
  767827
  772210
  772254
  774876
  776035
  777094
  779868
  782096
  782372
  783671
  785880
  785883
  786005
  788423
  788524
  791445
  796372
  796715
  796950
  798243
  798291
  801615
  801639
  803832
  807902
  808559
  808984
  810501
  811284
  811690
  811696
  812779
]
14.11 ms
(9.50%)
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
  798243
  811690
  626082
  798291
  446251
  467588
  429892
  513522
  400802
  435563
  450707
  475426
  449930
  522579
  536914
  513223
  523058
  569345
  584046
  547470
  584362
  667045
  586876
  638671
  585788
  592662
  617045
  595318
  425948
  439230
  434645
  437190
  454800
  509921
  448854
  607706
  651690
  782372
  783671
  263548
  396339
  433939
  439103
  411454
  452914
  457486
  469741
  490232
  469437
  518372
  534953
  535319
  670782
  708062
  709754
  654048
  678707
  691989
  706446
  706717
  672317
  714203
  719461
  554989
  584039
  606254
  589701
  623821
  589390
  595138
  598814
  598272
  608516
  774876
  782096
  785883
  796372
  796715
  801639
  803832
  810501
  811284
  811696
  779868
  785880
  788524
  796950
  808559
  808984
  758780
  772210
  772254
  788423
  791445
  807902
  812779
  757883
  767827
  738446
  746201
  736024
  739089
  757232
  602416
  638941
  705825
  705999
  707408
  776035
  777094
  786005
  801615
  155232
  414277
  439345
  440641
  448915
  423812
  435798
  473873
]
2.29 ms
(1.54%)
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
  155232
  263548
  396339
  400802
  411454
  414277
  423812
  425948
  429892
  433939
  434645
  435563
  435798
  437190
  439103
  439230
  439345
  440641
  446251
  448854
  448915
  449930
  450707
  452914
  454800
  457486
  467588
  469437
  469741
  473873
  475426
  490232
  509921
  513223
  513522
  518372
  522579
  523058
  534953
  535319
  536914
  547470
  554989
  569345
  584039
  584046
  584362
  585788
  586876
  589390
  589701
  592662
  595138
  595318
  598272
  598814
  602416
  606254
  607706
  608516
  617045
  623821
  626082
  638671
  638941
  651690
  654048
  667045
  670782
  672317
  678707
  691989
  705825
  705999
  706446
  706717
  707408
  708062
  709754
  714203
  719461
  736024
  738446
  739089
  746201
  757232
  757883
  758780
  767827
  772210
  772254
  774876
  776035
  777094
  779868
  782096
  782372
  783671
  785880
  785883
  786005
  788423
  788524
  791445
  796372
  796715
  796950
  798243
  798291
  801615
  801639
  803832
  807902
  808559
  808984
  810501
  811284
  811690
  811696
  812779
]
1.72 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pussy solo"
]
1.55 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pussy соло"
]
1.54 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд pussy соло"
]

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.