Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.01 ms
(86.80%)
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
  317866
  388825
  391115
  391812
  396863
  434688
  445211
  449361
  450289
  452845
  454390
  468379
  473757
  476168
  477221
  480004
  482437
  484233
  486808
  488550
  496621
  498247
  500040
  507422
  509202
  511004
  521831
  525042
  528094
  532126
  532599
  542139
  542700
  545810
  547042
  553619
  559495
  560537
  562536
  575334
  582656
  585318
  588118
  590887
  591777
  595314
  595943
  601166
  605505
  617329
  622878
  625465
  636574
  637161
  640411
  643683
  645207
  651548
  655529
  659435
  659931
  663818
  663834
  675930
  677245
  678696
  679653
  682364
  693680
  697608
  711580
  721129
  721479
  725709
  726841
  728203
  742074
  742560
  743559
  750448
  750833
  751438
  753550
  756840
  758731
  758754
  761754
  764234
  766737
  767280
  769291
  769494
  769533
  774883
  778124
  778298
  778434
  780938
  783194
  784072
  784477
  784753
  785422
  790045
  795843
  797796
  799567
  801115
  801481
  803904
  805310
  806892
  807631
  809397
  812857
  813219
  813749
  814483
  816617
  825457
]
14.81 ms
(7.43%)
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
  663818
  655529
  764234
  521831
  590887
  396863
  434688
  825457
  452845
  511004
  532126
  528094
  532599
  542139
  559495
  575334
  582656
  560537
  677245
  645207
  675930
  721479
  553619
  588118
  803904
  778124
  778298
  784477
  742074
  750448
  751438
  761754
  767280
  784753
  797796
  753550
  766737
  728203
  758731
  769494
  769533
  750833
  726841
  743559
  778434
  812857
  813219
  496621
  488550
  721129
  756840
  477221
  480004
  445211
  450289
  484233
  636574
  317866
  678696
  388825
  622878
  643683
  769291
  500040
  637161
  813749
  814483
  816617
  482437
  454390
  473757
  486808
  507422
  547042
  711580
  562536
  640411
  774883
  784072
  799567
  805310
  807631
  785422
  806892
  809397
  725709
  783194
  795843
  801115
  742560
  758754
  780938
  790045
  801481
  391812
  509202
  391115
  542700
  545810
  651548
  659931
  682364
  697608
  663834
  659435
  693680
  591777
  595314
  617329
  585318
  601166
  605505
  595943
  625465
  498247
  476168
  449361
  525042
  468379
  679653
]
4.19 ms
(2.10%)
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
  317866
  388825
  391115
  391812
  396863
  434688
  445211
  449361
  450289
  452845
  454390
  468379
  473757
  476168
  477221
  480004
  482437
  484233
  486808
  488550
  496621
  498247
  500040
  507422
  509202
  511004
  521831
  525042
  528094
  532126
  532599
  542139
  542700
  545810
  547042
  553619
  559495
  560537
  562536
  575334
  582656
  585318
  588118
  590887
  591777
  595314
  595943
  601166
  605505
  617329
  622878
  625465
  636574
  637161
  640411
  643683
  645207
  651548
  655529
  659435
  659931
  663818
  663834
  675930
  677245
  678696
  679653
  682364
  693680
  697608
  711580
  721129
  721479
  725709
  726841
  728203
  742074
  742560
  743559
  750448
  750833
  751438
  753550
  756840
  758731
  758754
  761754
  764234
  766737
  767280
  769291
  769494
  769533
  774883
  778124
  778298
  778434
  780938
  783194
  784072
  784477
  784753
  785422
  790045
  795843
  797796
  799567
  801115
  801481
  803904
  805310
  806892
  807631
  809397
  812857
  813219
  813749
  814483
  816617
  825457
]
2.10 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette riding homemade"
]
1.89 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая riding домашн любительск"
]
1.51 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая riding домашн любительск"
]

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.