Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.04 ms
(87.68%)
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
  143891
  365948
  412157
  428835
  443713
  444114
  444129
  444241
  455129
  466202
  470107
  470155
  470635
  474315
  477129
  483439
  484395
  485971
  488961
  490479
  491431
  495047
  502805
  509500
  513581
  522448
  533688
  539341
  539366
  539373
  543745
  544957
  546448
  548042
  548049
  550938
  552111
  555608
  557478
  558123
  562993
  566372
  571352
  571419
  573912
  574019
  598544
  598768
  614212
  641807
  644688
  650064
  666515
  668824
  683288
  706625
  709501
  713369
  713748
  714615
  715449
  728657
  728900
  729424
  731581
  733105
  733743
  736855
  739265
  739689
  741480
  741713
  741723
  741737
  741744
  745720
  755889
  755900
  761786
  776103
  777897
  778264
  781489
  785941
  788028
  788473
  790280
  791179
  791723
  791918
  794704
  796511
  799673
  799918
  799919
  801939
  803728
  803729
  803899
  804872
  805338
  805666
  814339
  816120
  816160
  817411
  817532
  817989
  819739
  824213
  824312
  824408
  825786
  825822
  826418
  826478
  826484
  827105
  827335
  827432
]
14.33 ms
(7.34%)
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
  785941
  788473
  796511
  804872
  791918
  729424
  745720
  741744
  741723
  731581
  739265
  781489
  805666
  470155
  470107
  443713
  484395
  490479
  509500
  825786
  544957
  552111
  668824
  801939
  733105
  733743
  485971
  571419
  444129
  488961
  819739
  816160
  539366
  574019
  470635
  444241
  824408
  826418
  825822
  827105
  827335
  817532
  533688
  548042
  805338
  736855
  799919
  827432
  814339
  477129
  539341
  539373
  548049
  558123
  650064
  715449
  666515
  713369
  714615
  706625
  709501
  550938
  557478
  644688
  598544
  598768
  776103
  790280
  788028
  791179
  741737
  791723
  741713
  778264
  428835
  455129
  466202
  143891
  365948
  474315
  502805
  483439
  495047
  491431
  543745
  444114
  513581
  555608
  562993
  641807
  728657
  522448
  816120
  824213
  826478
  826484
  817989
  817411
  824312
  571352
  546448
  566372
  573912
  713748
  683288
  614212
  803729
  777897
  794704
  799918
  755900
  761786
  799673
  803728
  739689
  728900
  755889
  741480
  803899
  412157
]
2.74 ms
(1.40%)
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
  143891
  365948
  412157
  428835
  443713
  444114
  444129
  444241
  455129
  466202
  470107
  470155
  470635
  474315
  477129
  483439
  484395
  485971
  488961
  490479
  491431
  495047
  502805
  509500
  513581
  522448
  533688
  539341
  539366
  539373
  543745
  544957
  546448
  548042
  548049
  550938
  552111
  555608
  557478
  558123
  562993
  566372
  571352
  571419
  573912
  574019
  598544
  598768
  614212
  641807
  644688
  650064
  666515
  668824
  683288
  706625
  709501
  713369
  713748
  714615
  715449
  728657
  728900
  729424
  731581
  733105
  733743
  736855
  739265
  739689
  741480
  741713
  741723
  741737
  741744
  745720
  755889
  755900
  761786
  776103
  777897
  778264
  781489
  785941
  788028
  788473
  790280
  791179
  791723
  791918
  794704
  796511
  799673
  799918
  799919
  801939
  803728
  803729
  803899
  804872
  805338
  805666
  814339
  816120
  816160
  817411
  817532
  817989
  819739
  824213
  824312
  824408
  825786
  825822
  826418
  826478
  826484
  827105
  827335
  827432
]
1.87 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск saggy"
]
1.77 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian saggy"
]
1.75 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск saggy"
]

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.