Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.40 ms
(84.17%)
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
  185013
  226412
  327981
  337234
  339474
  382756
  383329
  383971
  385241
  385634
  389740
  391773
  398399
  406941
  423572
  444660
  472895
  482335
  489185
  491633
  494849
  499555
  499849
  500094
  501325
  510494
  513184
  515300
  516874
  519851
  523553
  525133
  540164
  541573
  542566
  543821
  545099
  546139
  552616
  554816
  555411
  557171
  557726
  559817
  564863
  565800
  567037
  567258
  567363
  569517
  572760
  577950
  584382
  589347
  601606
  613972
  621466
  636139
  636438
  644065
  650478
  652976
  656222
  670816
  686024
  698482
  701451
  703814
  706606
  708170
  715530
  720378
  721755
  726097
  726295
  726408
  728457
  733381
  736907
  740091
  745314
  746277
  748938
  754161
  757605
  760426
  763558
  764570
  765036
  766483
  777565
  777621
  779048
  779829
  780245
  780770
  781408
  782578
  783090
  785985
  786997
  787071
  790535
  791017
  791965
  792199
  794553
  795641
  797745
  798594
  799858
  800252
  800357
  807457
  810560
  811968
  813307
  814368
]
12.71 ms
(8.67%)
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
  795641
  733381
  786997
  798594
  800357
  807457
  745314
  726295
  748938
  764570
  736907
  757605
  777565
  777621
  782578
  785985
  787071
  813307
  391773
  337234
  491633
  501325
  499849
  540164
  543821
  565800
  559817
  564863
  636139
  577950
  542566
  515300
  516874
  472895
  385634
  185013
  792199
  799858
  389740
  423572
  523553
  519851
  525133
  552616
  644065
  444660
  327981
  385241
  650478
  783090
  500094
  670816
  567258
  589347
  794553
  800252
  746277
  740091
  720378
  382756
  226412
  339474
  398399
  814368
  482335
  510494
  494849
  513184
  541573
  554816
  555411
  557171
  567037
  569517
  652976
  656222
  715530
  698482
  703814
  706606
  721755
  686024
  708170
  546139
  636438
  601606
  779829
  780245
  791017
  791965
  810560
  811968
  754161
  781324
  781408
  786930
  790535
  797745
  726097
  766483
  726408
  760426
  763558
  728457
  765036
  701451
  779048
  545099
  621466
  572760
  584382
  780770
  383329
  406941
  489185
  567363
  383971
  499555
  557726
  613972
]
3.10 ms
(2.11%)
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
  185013
  226412
  327981
  337234
  339474
  382756
  383329
  383971
  385241
  385634
  389740
  391773
  398399
  406941
  423572
  444660
  472895
  482335
  489185
  491633
  494849
  499555
  499849
  500094
  501325
  510494
  513184
  515300
  516874
  519851
  523553
  525133
  540164
  541573
  542566
  543821
  545099
  546139
  552616
  554816
  555411
  557171
  557726
  559817
  564863
  565800
  567037
  567258
  567363
  569517
  572760
  577950
  584382
  589347
  601606
  613972
  621466
  636139
  636438
  644065
  650478
  652976
  656222
  670816
  686024
  698482
  701451
  703814
  706606
  708170
  715530
  720378
  721755
  726097
  726295
  726408
  728457
  733381
  736907
  740091
  745314
  746277
  748938
  754161
  757605
  760426
  763558
  764570
  765036
  766483
  777565
  777621
  779048
  779829
  780245
  780770
  781408
  782578
  783090
  785985
  786997
  787071
  790535
  791017
  791965
  792199
  794553
  795641
  797745
  798594
  799858
  800252
  800357
  807457
  810560
  811968
  813307
  814368
]
2.02 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончают нам лицо"
]
1.94 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм лиц"
]
1.67 ms
(1.14%)
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.