Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.06 ms
(83.34%)
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
  95742
  118098
  184359
  388755
  398567
  398634
  400943
  400962
  401764
  405421
  406304
  413505
  413826
  416772
  417250
  421580
  422166
  425910
  428334
  428397
  429342
  430561
  431448
  432674
  432823
  433137
  433166
  433212
  433227
  433297
  441994
  443249
  443323
  445869
  445941
  445974
  446991
  447022
  447471
  448816
  448820
  452329
  461848
  463798
  463840
  467958
  469852
  470385
  475698
  482291
  486515
  486868
  487750
  489489
  493334
  495218
  511357
  516383
  516842
  517374
  518290
  523544
  526300
  527091
  534567
  534682
  537198
  541650
  543872
  549027
  555023
  555133
  556535
  557072
  558875
  560902
  562964
  564337
  565504
  568287
  569179
  571216
  575890
  580340
  586623
  593487
  596991
  597501
  597876
  598675
  598723
  600016
  603436
  609097
  617421
  627803
  630245
  630678
  636998
  639722
  640772
  643109
  645004
  647349
  668377
  688617
  699624
  699697
  702866
  741539
  746995
  748349
  775801
  788570
  788780
  788794
  815002
  818235
  819506
  820775
]
18.55 ms
(10.58%)
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
  447471
  422166
  405421
  430561
  448816
  495218
  586623
  443249
  417250
  428334
  815002
  818235
  645004
  820775
  819506
  526300
  568287
  647349
  668377
  598675
  630678
  596991
  600016
  775801
  788780
  788794
  748349
  741539
  746995
  603436
  627803
  702866
  788570
  400943
  445941
  475698
  517374
  433166
  433297
  487750
  448820
  482291
  534567
  516383
  558875
  549027
  543872
  555023
  569179
  598723
  609097
  630245
  643109
  636998
  425910
  433137
  421580
  617421
  541650
  537198
  95742
  431448
  428397
  398567
  441994
  467958
  493334
  184359
  597876
  593487
  688617
  597501
  406304
  432674
  445869
  463798
  463840
  486515
  527091
  518290
  564337
  560902
  557072
  571216
  699697
  555133
  562964
  413505
  461848
  432823
  446991
  452329
  534682
  400962
  429342
  443323
  433227
  486868
  413826
  388755
  447022
  699624
  469852
  523544
  639722
  489489
  401764
  511357
  556535
  565504
  118098
  516842
  470385
  445974
  580340
  433212
  575890
  640772
  398634
  416772
]
2.66 ms
(1.51%)
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
  95742
  118098
  184359
  388755
  398567
  398634
  400943
  400962
  401764
  405421
  406304
  413505
  413826
  416772
  417250
  421580
  422166
  425910
  428334
  428397
  429342
  430561
  431448
  432674
  432823
  433137
  433166
  433212
  433227
  433297
  441994
  443249
  443323
  445869
  445941
  445974
  446991
  447022
  447471
  448816
  448820
  452329
  461848
  463798
  463840
  467958
  469852
  470385
  475698
  482291
  486515
  486868
  487750
  489489
  493334
  495218
  511357
  516383
  516842
  517374
  518290
  523544
  526300
  527091
  534567
  534682
  537198
  541650
  543872
  549027
  555023
  555133
  556535
  557072
  558875
  560902
  562964
  564337
  565504
  568287
  569179
  571216
  575890
  580340
  586623
  593487
  596991
  597501
  597876
  598675
  598723
  600016
  603436
  609097
  617421
  627803
  630245
  630678
  636998
  639722
  640772
  643109
  645004
  647349
  668377
  688617
  699624
  699697
  702866
  741539
  746995
  748349
  775801
  788570
  788780
  788794
  815002
  818235
  819506
  820775
]
2.32 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин анал дырк"
]
2.01 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин анал дырк"
]
2.01 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мужчины анальная дыра…"
]
1.66 ms
(0.95%)
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.