Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.14 ms
(85.58%)
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
  61168
  81100
  96445
  191252
  223442
  324183
  341691
  341786
  366267
  381924
  387445
  396542
  396566
  396989
  398700
  443838
  461086
  495710
  500551
  501154
  501178
  508720
  510426
  514069
  525514
  525691
  532268
  533523
  536063
  543124
  544642
  545584
  547300
  547983
  548523
  549273
  554811
  557069
  559878
  560368
  561046
  565369
  566445
  572739
  575233
  577437
  581119
  583715
  587860
  590631
  606515
  610780
  616688
  617590
  622086
  622089
  622119
  622201
  624985
  624998
  645078
  645493
  645749
  645913
  648984
  649112
  649127
  649138
  649199
  651317
  652850
  653519
  653712
  653914
  654276
  659259
  659780
  663939
  663946
  664267
  665406
  668174
  670488
  671243
  671747
  676465
  676530
  678541
  679067
  681682
  690000
  692457
  693164
  696278
  699553
  703087
  716017
  717039
  720372
  731797
  743201
  746421
  749990
  760774
  768189
  775909
  778372
  784442
  790654
  795133
  797164
  817748
  818447
  818773
  820032
  823720
  823926
  824132
  824325
  826230
]
15.49 ms
(8.44%)
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
  583715
  547983
  549273
  645749
  653914
  690000
  775909
  760774
  645078
  560368
  577437
  590631
  510426
  500551
  575233
  587860
  501154
  501178
  508720
  659259
  795133
  746421
  525691
  536063
  663939
  622089
  622119
  387445
  820032
  645913
  649112
  668174
  381924
  223442
  679067
  693164
  670488
  681682
  671747
  790654
  61168
  396989
  817748
  818447
  653712
  692457
  645493
  648984
  649127
  663946
  665406
  622201
  784442
  797164
  778372
  826230
  716017
  191252
  495710
  514069
  461086
  396542
  396566
  533523
  532268
  543124
  676465
  720372
  341786
  398700
  823926
  544642
  545584
  554811
  548523
  561046
  565369
  671243
  696278
  651317
  659780
  664267
  676530
  653519
  616688
  624998
  610780
  624985
  617590
  731797
  743201
  749990
  768189
  606515
  703087
  324183
  366267
  341691
  81100
  96445
  443838
  823720
  824132
  824325
  818773
  525514
  581119
  547300
  572739
  649138
  699553
  717039
  649199
  652850
  654276
  678541
  557069
  559878
  566445
  622086
]
3.58 ms
(1.95%)
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
  61168
  81100
  96445
  191252
  223442
  324183
  341691
  341786
  366267
  381924
  387445
  396542
  396566
  396989
  398700
  443838
  461086
  495710
  500551
  501154
  501178
  508720
  510426
  514069
  525514
  525691
  532268
  533523
  536063
  543124
  544642
  545584
  547300
  547983
  548523
  549273
  554811
  557069
  559878
  560368
  561046
  565369
  566445
  572739
  575233
  577437
  581119
  583715
  587860
  590631
  606515
  610780
  616688
  617590
  622086
  622089
  622119
  622201
  624985
  624998
  645078
  645493
  645749
  645913
  648984
  649112
  649127
  649138
  649199
  651317
  652850
  653519
  653712
  653914
  654276
  659259
  659780
  663939
  663946
  664267
  665406
  668174
  670488
  671243
  671747
  676465
  676530
  678541
  679067
  681682
  690000
  692457
  693164
  696278
  699553
  703087
  716017
  717039
  720372
  731797
  743201
  746421
  749990
  760774
  768189
  775909
  778372
  784442
  790654
  795133
  797164
  817748
  818447
  818773
  820032
  823720
  823926
  824132
  824325
  826230
]
2.12 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмм"
]
1.85 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро"
]
1.83 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.87%)
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.