Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.04 ms
(85.15%)
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
  7295
  382381
  390204
  391868
  391916
  391994
  393050
  395162
  396186
  396231
  410884
  422635
  423994
  426689
  428282
  429890
  431432
  432949
  441925
  442997
  453585
  454983
  458819
  460293
  467855
  471664
  475103
  495937
  496152
  503379
  505281
  505470
  508986
  509501
  511923
  512065
  512365
  514440
  516551
  517552
  518671
  519313
  519604
  519700
  523726
  526653
  528939
  534114
  534953
  535438
  540911
  542701
  544961
  548387
  555033
  556890
  556906
  556907
  561273
  571194
  571726
  582221
  582511
  590520
  591221
  595860
  600144
  602697
  605378
  608869
  620017
  621496
  626399
  630511
  653216
  666490
  672944
  677322
  677333
  684706
  685061
  695386
  706631
  718701
  718745
  719461
  723885
  725392
  741247
  742290
  742291
  742304
  742318
  742320
  742359
  744427
  745100
  745104
  747153
  751609
  752750
  755878
  757883
  761608
  777797
  782789
  782792
  782854
  788107
  788908
  791501
  791930
  792741
  794048
  797001
  801610
  804319
  805227
  827918
  827973
]
15.78 ms
(8.78%)
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
  777797
  794048
  432949
  827918
  827973
  509501
  512365
  517552
  534114
  534953
  535438
  503379
  519700
  467855
  556906
  571194
  540911
  542701
  548387
  653216
  672944
  677322
  677333
  684706
  685061
  695386
  706631
  666490
  718701
  719461
  544961
  555033
  556890
  556907
  582221
  582511
  591221
  595860
  590520
  608869
  621496
  620017
  600144
  804319
  782789
  782792
  782854
  791501
  742320
  805227
  744427
  747153
  757883
  723885
  745100
  755878
  742304
  742318
  745104
  751609
  752750
  761608
  742290
  742291
  742359
  788107
  788908
  791930
  792741
  797001
  391994
  393050
  395162
  423994
  453585
  382381
  396186
  396231
  426689
  471664
  391868
  422635
  391916
  410884
  431432
  441925
  454983
  458819
  460293
  512065
  523726
  508986
  514440
  519313
  519604
  496152
  526653
  505281
  505470
  511923
  495937
  571726
  561273
  718745
  626399
  605378
  630511
  725392
  741247
  602697
  801610
  442997
  428282
  429890
  7295
  528939
  516551
  390204
  475103
  518671
]
3.08 ms
(1.71%)
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
  7295
  382381
  390204
  391868
  391916
  391994
  393050
  395162
  396186
  396231
  410884
  422635
  423994
  426689
  428282
  429890
  431432
  432949
  441925
  442997
  453585
  454983
  458819
  460293
  467855
  471664
  475103
  495937
  496152
  503379
  505281
  505470
  508986
  509501
  511923
  512065
  512365
  514440
  516551
  517552
  518671
  519313
  519604
  519700
  523726
  526653
  528939
  534114
  534953
  535438
  540911
  542701
  544961
  548387
  555033
  556890
  556906
  556907
  561273
  571194
  571726
  582221
  582511
  590520
  591221
  595860
  600144
  602697
  605378
  608869
  620017
  621496
  626399
  630511
  653216
  666490
  672944
  677322
  677333
  684706
  685061
  695386
  706631
  718701
  718745
  719461
  723885
  725392
  741247
  742290
  742291
  742304
  742318
  742320
  742359
  744427
  745100
  745104
  747153
  751609
  752750
  755878
  757883
  761608
  777797
  782789
  782792
  782854
  788107
  788908
  791501
  791930
  792741
  794048
  797001
  801610
  804319
  805227
  827918
  827973
]
2.14 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское жестко"
]
2.00 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск хардкор"
]
1.90 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск хардкор"
]
1.80 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.