Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.72 ms
(82.44%)
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
  14328
  14534
  97688
  161485
  326134
  360065
  381941
  382662
  383439
  385784
  391386
  395402
  395503
  395504
  396594
  396614
  399320
  399710
  402153
  410057
  410780
  411681
  412419
  414681
  416869
  419483
  419862
  419989
  420307
  420695
  420762
  422732
  424937
  428432
  429088
  433047
  433762
  435515
  435624
  436118
  445733
  445740
  447143
  448200
  448987
  449933
  450204
  450224
  451560
  452282
  452283
  456109
  458625
  459668
  460501
  462390
  464194
  464345
  465698
  466552
  466858
  467583
  467632
  468009
  468035
  471723
  475630
  478527
  478672
  479709
  480417
  481663
  481664
  482800
  486214
  487747
  488897
  490132
  490574
  494277
  494290
  496314
  496330
  499332
  499336
  507944
  511713
  512903
  513005
  513736
  524859
  525948
  527447
  527659
  529360
  535013
  536910
  543881
  545828
  554392
  554525
  557557
  565916
  567139
  567141
  568059
  582376
  584720
  584754
  588285
  597121
  605545
  612792
  620499
  621612
  657296
  657361
  658082
  658405
  792627
]
17.37 ms
(10.95%)
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
  481663
  513005
  436118
  496314
  396594
  14328
  360065
  658082
  512903
  447143
  448200
  449933
  433047
  467632
  161485
  382662
  395504
  416869
  468035
  422732
  435515
  490132
  465698
  466858
  452283
  499336
  468009
  487747
  420762
  481664
  14534
  486214
  475630
  657361
  620499
  527447
  513736
  490574
  554525
  381941
  419862
  588285
  448987
  452282
  450224
  529360
  499332
  524859
  402153
  424937
  460501
  428432
  399320
  567141
  496330
  597121
  419483
  419989
  420695
  395503
  395402
  458625
  459668
  399710
  414681
  511713
  525948
  658405
  567139
  568059
  582376
  479709
  535013
  97688
  396614
  433762
  494277
  557557
  565916
  464194
  450204
  456109
  494290
  584720
  584754
  507944
  383439
  326134
  410057
  410780
  462390
  464345
  792627
  385784
  420307
  480417
  451560
  471723
  412419
  488897
  536910
  554392
  657296
  612792
  435624
  467583
  445733
  466552
  527659
  543881
  545828
  605545
  429088
  482800
  445740
  411681
  621612
  478672
  478527
  391386
]
2.75 ms
(1.74%)
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
  14328
  14534
  97688
  161485
  326134
  360065
  381941
  382662
  383439
  385784
  391386
  395402
  395503
  395504
  396594
  396614
  399320
  399710
  402153
  410057
  410780
  411681
  412419
  414681
  416869
  419483
  419862
  419989
  420307
  420695
  420762
  422732
  424937
  428432
  429088
  433047
  433762
  435515
  435624
  436118
  445733
  445740
  447143
  448200
  448987
  449933
  450204
  450224
  451560
  452282
  452283
  456109
  458625
  459668
  460501
  462390
  464194
  464345
  465698
  466552
  466858
  467583
  467632
  468009
  468035
  471723
  475630
  478527
  478672
  479709
  480417
  481663
  481664
  482800
  486214
  487747
  488897
  490132
  490574
  494277
  494290
  496314
  496330
  499332
  499336
  507944
  511713
  512903
  513005
  513736
  524859
  525948
  527447
  527659
  529360
  535013
  536910
  543881
  545828
  554392
  554525
  557557
  565916
  567139
  567141
  568059
  582376
  584720
  584754
  588285
  597121
  605545
  612792
  620499
  621612
  657296
  657361
  658082
  658405
  792627
]
2.23 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð©ðÀð╝ðÁð¢ð©ð╗ð░ ð╝ÐâðÂÐâ Ðü ð¢ðÁð│ÐÇð¥ðÔǪ"
]
1.94 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен жен чернокожий"
]
1.70 ms
(1.07%)
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.