Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.83 ms
(87.79%)
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
  312447
  383154
  383224
  385906
  389888
  392802
  393122
  393502
  401830
  410699
  413737
  420257
  432017
  434135
  441037
  441897
  446170
  446594
  449066
  449442
  449862
  450830
  451719
  452530
  455345
  457257
  457487
  458070
  459918
  460173
  464870
  465557
  465977
  466462
  466612
  467785
  468225
  470396
  472064
  472356
  472842
  475845
  477042
  478239
  480561
  483962
  485753
  491696
  492615
  493119
  495203
  495726
  497324
  497714
  503041
  505171
  507104
  507204
  510377
  515606
  520192
  520924
  522413
  525925
  526880
  527507
  527516
  527541
  527546
  528679
  529003
  534084
  534341
  536725
  537783
  541802
  543196
  543530
  544591
  547200
  549278
  550237
  550427
  550589
  550607
  552013
  552022
  554432
  555280
  556843
  562567
  563168
  563204
  563210
  563454
  564283
  564640
  565333
  565352
  566073
  568131
  568483
  569135
  569803
  570225
  570371
  571623
  572396
  573284
  573423
  575865
  576462
  578079
  580027
  580990
  584088
  584821
  657279
  684335
  825545
]
10.91 ms
(6.03%)
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
  465977
  466462
  470396
  472356
  478239
  468225
  495203
  497714
  525925
  526880
  491696
  492615
  385906
  383154
  383224
  393502
  393122
  392802
  312447
  389888
  401830
  413737
  420257
  441037
  410699
  432017
  434135
  441897
  825545
  446170
  449862
  451719
  452530
  455345
  457257
  457487
  458070
  460173
  464870
  466612
  472842
  477042
  493119
  449066
  450830
  459918
  467785
  472064
  475845
  485753
  446594
  449442
  480561
  483962
  495726
  510377
  515606
  520924
  534341
  503041
  507204
  529003
  534084
  536725
  497324
  505171
  507104
  520192
  527507
  527516
  527541
  537783
  522413
  527546
  528679
  465557
  550237
  550607
  556843
  563168
  568131
  570225
  570371
  573423
  576462
  580027
  584821
  541802
  543530
  549278
  550589
  554432
  555280
  562567
  564283
  564640
  568483
  569803
  573284
  578079
  580990
  584088
  543196
  544591
  547200
  550427
  552013
  552022
  563204
  563210
  563454
  565333
  565352
  566073
  569135
  571623
  572396
  575865
  657279
  684335
]
3.30 ms
(1.83%)
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
  312447
  383154
  383224
  385906
  389888
  392802
  393122
  393502
  401830
  410699
  413737
  420257
  432017
  434135
  441037
  441897
  446170
  446594
  449066
  449442
  449862
  450830
  451719
  452530
  455345
  457257
  457487
  458070
  459918
  460173
  464870
  465557
  465977
  466462
  466612
  467785
  468225
  470396
  472064
  472356
  472842
  475845
  477042
  478239
  480561
  483962
  485753
  491696
  492615
  493119
  495203
  495726
  497324
  497714
  503041
  505171
  507104
  507204
  510377
  515606
  520192
  520924
  522413
  525925
  526880
  527507
  527516
  527541
  527546
  528679
  529003
  534084
  534341
  536725
  537783
  541802
  543196
  543530
  544591
  547200
  549278
  550237
  550427
  550589
  550607
  552013
  552022
  554432
  555280
  556843
  562567
  563168
  563204
  563210
  563454
  564283
  564640
  565333
  565352
  566073
  568131
  568483
  569135
  569803
  570225
  570371
  571623
  572396
  573284
  573423
  575865
  576462
  578079
  580027
  580990
  584088
  584821
  657279
  684335
  825545
]
2.20 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с под юбки"
]
2.03 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "юбк"
]
1.78 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.