Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.20 ms
(88.18%)
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
  170069
  232048
  238575
  272725
  385014
  386798
  390264
  390272
  393339
  413398
  415956
  416512
  419609
  423187
  423964
  429793
  429900
  433747
  435652
  436095
  441213
  444538
  444780
  446037
  446356
  449397
  449421
  450255
  450994
  452968
  453470
  454922
  457474
  460894
  461842
  471528
  471929
  479743
  479746
  479749
  483380
  486660
  488520
  490380
  493837
  493871
  495793
  510175
  510292
  510543
  513578
  513806
  513812
  515317
  517928
  519368
  520220
  521290
  523680
  525075
  527256
  528663
  529191
  529882
  530459
  546321
  550676
  552336
  553442
  568809
  573748
  575418
  580391
  581121
  585885
  588215
  592440
  602056
  612602
  615692
  616818
  619102
  623624
  626541
  630083
  637494
  638525
  642378
  666503
  674204
  678934
  707900
  727381
  733357
  734062
  738432
  741853
  741856
  742765
  745914
  746123
  746457
  756526
  769828
  771235
  779635
  779702
  780146
  783126
  783127
  787732
  787741
  787766
  792238
  793123
  793158
  796875
  810653
  826617
  827064
]
15.41 ms
(7.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
  452968
  413398
  450255
  519368
  416512
  483380
  513578
  446356
  444538
  490380
  429793
  573748
  429900
  419609
  495793
  436095
  433747
  493837
  626541
  232048
  471528
  525075
  441213
  581121
  450994
  479743
  792238
  733357
  746457
  423187
  742765
  779635
  552336
  460894
  771235
  623624
  479746
  170069
  779702
  787741
  527256
  585885
  423964
  612602
  529882
  780146
  666503
  616818
  787766
  642378
  528663
  520220
  674204
  787732
  741853
  510543
  568809
  444780
  471929
  486660
  390264
  746123
  738432
  810653
  580391
  449397
  513812
  461842
  510175
  385014
  550676
  793158
  238575
  446037
  479749
  530459
  521290
  769828
  793123
  756526
  745914
  515317
  386798
  592440
  783127
  734062
  393339
  513806
  575418
  796875
  741856
  272725
  454922
  529191
  493871
  517928
  619102
  727381
  783126
  637494
  588215
  826617
  435652
  449421
  678934
  638525
  707900
  488520
  453470
  546321
  415956
  523680
  553442
  602056
  510292
  390272
  457474
  615692
  630083
  827064
]
2.97 ms
(1.38%)
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
  170069
  232048
  238575
  272725
  385014
  386798
  390264
  390272
  393339
  413398
  415956
  416512
  419609
  423187
  423964
  429793
  429900
  433747
  435652
  436095
  441213
  444538
  444780
  446037
  446356
  449397
  449421
  450255
  450994
  452968
  453470
  454922
  457474
  460894
  461842
  471528
  471929
  479743
  479746
  479749
  483380
  486660
  488520
  490380
  493837
  493871
  495793
  510175
  510292
  510543
  513578
  513806
  513812
  515317
  517928
  519368
  520220
  521290
  523680
  525075
  527256
  528663
  529191
  529882
  530459
  546321
  550676
  552336
  553442
  568809
  573748
  575418
  580391
  581121
  585885
  588215
  592440
  602056
  612602
  615692
  616818
  619102
  623624
  626541
  630083
  637494
  638525
  642378
  666503
  674204
  678934
  707900
  727381
  733357
  734062
  738432
  741853
  741856
  742765
  745914
  746123
  746457
  756526
  769828
  771235
  779635
  779702
  780146
  783126
  783127
  787732
  787741
  787766
  792238
  793123
  793158
  796875
  810653
  826617
  827064
]
1.90 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк игрушк"
]
1.83 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочка игрушки"
]
1.76 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.69%)
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.