Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.39 ms
(52.98%)
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
  381888
  382827
  388067
  404395
  406982
  409621
  414194
  431587
  433049
  436758
  438787
  439349
  442344
  443858
  444691
  446950
  447012
  447073
  447501
  447562
  447902
  449171
  449404
  452220
  452671
  452683
  452782
  452978
  453058
  455028
  455190
  458488
  459278
  459560
  460988
  461319
  461716
  462797
  464244
  465129
  471916
  473849
  475829
  476675
  478791
  482850
  484053
  484061
  487995
  489874
  494099
  499685
  499868
  501909
  504553
  504711
  507434
  513690
  527332
  545750
  548912
  552763
  564984
  565722
  567315
  574886
  575275
  578189
  578387
  586727
  587883
  587890
  592429
  598528
  610833
  622722
  623120
  624527
  625288
  626220
  635079
  636149
  636760
  658311
  658713
  659151
  659300
  666006
  684722
  692032
  695789
  722816
  732119
  743447
  751063
  751592
  754432
  754548
  754915
  755244
  759441
  766475
  768431
  771772
  773144
  778249
  778253
  778875
  779323
  780123
  785870
  788645
  790531
  791439
  794009
  797125
  799544
  803609
  816247
]
160.87 ms
(41.29%)
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
  381888
  382827
  388067
  404395
  406982
  409621
  414194
  431587
  433049
  436758
  438787
  439349
  442344
  443858
  444691
  446950
  447012
  447073
  447501
  447562
  447902
  449171
  449404
  452220
  452671
  452683
  452782
  452978
  453058
  455028
  455190
  458488
  459278
  459560
  460988
  461319
  461716
  462797
  464244
  465129
  471916
  473849
  475829
  476675
  478791
  482850
  484053
  484061
  487995
  489874
  494099
  499685
  499868
  501909
  504553
  504711
  507434
  513690
  527332
  545750
  548912
  552763
  564984
  565722
  567315
  574886
  575275
  578189
  578387
  586727
  587883
  587890
  592429
  598528
  610833
  622722
  623120
  624527
  625288
  626220
  635079
  636149
  636760
  658311
  658713
  659151
  659300
  666006
  684722
  692032
  695789
  722816
  732119
  743447
  751063
  751592
  754432
  754548
  754915
  755244
  759441
  766475
  768431
  771772
  773144
  778249
  778253
  778875
  779323
  780123
  785870
  788645
  790531
  791439
  794009
  797125
  799544
  803609
  816247
]
15.15 ms
(3.89%)
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
  684722
  658311
  658713
  659151
  692032
  695789
  636149
  636760
  624527
  625288
  635079
  778249
  788645
  791439
  754432
  790531
  797125
  766475
  765166
  771772
  773144
  754548
  759441
  743447
  755244
  778253
  778875
  785870
  799544
  388067
  504553
  442344
  504711
  578387
  574886
  439349
  464244
  381888
  382827
  431587
  452220
  507434
  449404
  575275
  565722
  659300
  587890
  587883
  404395
  465129
  436758
  447012
  460988
  447562
  501909
  482850
  487995
  494099
  527332
  545750
  751063
  754915
  751592
  768431
  779323
  780123
  484053
  499868
  598528
  803609
  732119
  414194
  458488
  452683
  459560
  476675
  447501
  489874
  484061
  513690
  816247
  475829
  409621
  471916
  499685
  446950
  452978
  666006
  548912
  722816
  592429
  794009
  433049
  443858
  452782
  478791
  447902
  564984
  567315
  552763
  578189
  610833
  622722
  586727
  626220
  623120
  438787
  455190
  444691
  447073
  449171
  452671
  453058
  455028
  459278
  461319
  461716
  462797
  473849
  406982
]
1.95 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian tattoo girl"
]
1.88 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск татуированные девушк"
]
1.59 ms
(0.41%)
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.