Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
253.97 ms
(90.99%)
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
  476539
  485611
  496399
  501367
  506818
  520196
  537518
  543465
  552875
  558911
  560693
  571107
  578716
  579500
  580816
  581581
  585343
  586346
  590612
  591559
  599398
  599539
  603668
  604432
  606497
  606772
  611443
  620189
  624819
  626328
  631986
  634298
  636014
  644178
  644478
  656674
  656915
  659334
  663562
  665997
  667057
  678607
  679564
  684705
  686385
  689214
  697604
  700902
  702275
  702382
  703587
  704594
  704598
  707145
  708696
  709721
  710091
  718699
  725097
  726169
  726623
  727343
  729082
  729170
  729217
  730158
  732592
  733202
  734365
  737926
  740080
  742661
  753058
  754854
  759474
  761372
  761953
  766334
  766457
  766462
  766702
  769248
  771069
  774597
  780831
  785180
  787907
  788332
  788866
  794588
  794676
  794861
  795332
  795795
  795843
  795906
  796288
  796497
  796611
  797783
  797878
  799136
  799886
  801612
  802022
  803202
  803562
  803840
  805098
  808492
  809347
  810310
  812724
  814026
  818825
  819708
  819948
  824420
  827182
  827936
]
15.16 ms
(5.43%)
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
  679564
  703587
  665997
  684705
  689214
  571107
  591559
  644178
  586346
  606497
  611443
  794676
  805098
  740080
  794588
  761953
  733202
  734365
  754854
  787907
  796288
  537518
  814026
  827936
  636014
  753058
  819948
  827182
  476539
  496399
  581581
  702382
  700902
  697604
  552875
  634298
  585343
  795795
  803840
  809347
  785180
  810310
  729170
  730158
  726169
  766702
  726623
  759474
  732592
  737926
  620189
  709721
  819708
  543465
  578716
  686385
  710091
  678607
  644478
  590612
  780831
  796497
  788332
  794861
  796611
  803562
  795843
  801612
  769248
  704594
  799136
  812724
  603668
  729082
  761372
  704598
  656674
  520196
  824420
  560693
  702275
  708696
  599539
  626328
  802022
  803202
  766334
  766457
  729217
  742661
  771069
  795332
  797783
  506818
  818825
  485611
  501367
  579500
  580816
  659334
  663562
  707145
  718699
  656915
  667057
  558911
  606772
  599398
  604432
  624819
  631986
  774597
  788866
  797878
  799886
  808492
  727343
  795906
  725097
  766462
]
2.71 ms
(0.97%)
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
  476539
  485611
  496399
  501367
  506818
  520196
  537518
  543465
  552875
  558911
  560693
  571107
  578716
  579500
  580816
  581581
  585343
  586346
  590612
  591559
  599398
  599539
  603668
  604432
  606497
  606772
  611443
  620189
  624819
  626328
  631986
  634298
  636014
  644178
  644478
  656674
  656915
  659334
  663562
  665997
  667057
  678607
  679564
  684705
  686385
  689214
  697604
  700902
  702275
  702382
  703587
  704594
  704598
  707145
  708696
  709721
  710091
  718699
  725097
  726169
  726623
  727343
  729082
  729170
  729217
  730158
  732592
  733202
  734365
  737926
  740080
  742661
  753058
  754854
  759474
  761372
  761953
  766334
  766457
  766462
  766702
  769248
  771069
  774597
  780831
  785180
  787907
  788332
  788866
  794588
  794676
  794861
  795332
  795795
  795843
  795906
  796288
  796497
  796611
  797783
  797878
  799136
  799886
  801612
  802022
  803202
  803562
  803840
  805098
  808492
  809347
  810310
  812724
  814026
  818825
  819708
  819948
  824420
  827182
  827936
]
2.07 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my husband"
]
1.92 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my husband"
]
1.58 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my husband"
]

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.