Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.83 ms
(58.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамка с син"
]
114.49 ms
(32.62%)
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
  404598
  420262
  428814
  431376
  440581
  449721
  453565
  453721
  462481
  471494
  487749
  492134
  494867
  495096
  503098
  505796
  505965
  507944
  511066
  514924
  516742
  517059
  517287
  518751
  519337
  519392
  519520
  520683
  520819
  523154
  523256
  523767
  525121
  526630
  526751
  526761
  527226
  527281
  527933
  528584
  528607
  528716
  528719
  528931
  530528
  532164
  534239
  536726
  536868
  539742
  541230
  542861
  545982
  550433
  552350
  553314
  556049
  557611
  562831
  562905
  563035
  566082
  566951
  568125
  570998
  580149
  580340
  583052
  584667
  587681
  588078
  590425
  591706
  591739
  592046
  593294
  593812
  596973
  599703
  599938
  600837
  601806
  607620
  608376
  612863
  616800
  617370
  618793
  620851
  625440
  640710
  642006
  642037
  643370
  648466
  657775
  667795
  668804
  673537
  675081
  681681
  690783
  719326
  785388
  809396
]
21.83 ms
(6.22%)
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
  552350
  563035
  541230
  584667
  690783
  648466
  681681
  553314
  601806
  428814
  527933
  545982
  556049
  593294
  588078
  640710
  511066
  600837
  591706
  612863
  462481
  494867
  505796
  519520
  526751
  536868
  525121
  527226
  516742
  526630
  528584
  530528
  487749
  583052
  562905
  673537
  667795
  668804
  514924
  528607
  617370
  657775
  518751
  642006
  642037
  534239
  453721
  431376
  404598
  520683
  539742
  520819
  607620
  643370
  785388
  440581
  495096
  523767
  580149
  599938
  453565
  492134
  527281
  536726
  526761
  557611
  542861
  675081
  566951
  592046
  593812
  596973
  449721
  517059
  503098
  519337
  517287
  562831
  599703
  616800
  505965
  532164
  590425
  719326
  809396
  620851
  566082
  528931
  528719
  568125
  523154
  523256
  570998
  420262
  550433
  507944
  528716
  519392
  587681
  580340
  618793
  625440
  591739
  608376
  471494
]
3.24 ms
(0.92%)
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
  404598
  420262
  428814
  431376
  440581
  449721
  453565
  453721
  462481
  471494
  487749
  492134
  494867
  495096
  503098
  505796
  505965
  507944
  511066
  514924
  516742
  517059
  517287
  518751
  519337
  519392
  519520
  520683
  520819
  523154
  523256
  523767
  525121
  526630
  526751
  526761
  527226
  527281
  527933
  528584
  528607
  528716
  528719
  528931
  530528
  532164
  534239
  536726
  536868
  539742
  541230
  542861
  545982
  550433
  552350
  553314
  556049
  557611
  562831
  562905
  563035
  566082
  566951
  568125
  570998
  580149
  580340
  583052
  584667
  587681
  588078
  590425
  591706
  591739
  592046
  593294
  593812
  596973
  599703
  599938
  600837
  601806
  607620
  608376
  612863
  616800
  617370
  618793
  620851
  625440
  640710
  642006
  642037
  643370
  648466
  657775
  667795
  668804
  673537
  675081
  681681
  690783
  719326
  785388
  809396
]
2.50 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин син"
]
1.48 ms
(0.42%)
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.