Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.73 ms
(81.95%)
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
  107606
  185353
  310758
  373897
  381775
  381871
  396781
  401084
  401100
  401944
  413258
  413544
  415151
  417701
  418270
  418530
  418597
  420331
  423615
  424312
  425121
  426153
  427992
  428238
  428742
  429223
  433137
  444841
  445837
  447494
  447537
  447538
  453081
  456069
  466455
  468166
  469528
  470511
  471779
  474590
  474601
  476143
  476176
  479759
  480135
  480306
  482075
  482081
  484819
  485031
  485160
  486077
  487370
  487708
  490863
  491457
  491569
  491941
  493399
  494386
  496725
  498536
  501649
  501831
  508876
  512770
  514386
  515867
  516848
  517106
  517580
  519555
  519565
  519573
  521899
  531194
  534060
  534218
  536256
  536861
  537934
  559951
  560642
  561632
  561829
  561834
  563647
  570462
  570537
  575723
  576314
  578478
  586546
  586601
  594164
  596649
  607093
  607900
  619552
  628090
  633746
  655084
  667026
  669717
  673767
  680146
  717832
  722478
  741249
  753480
  769325
  769793
  779706
  788119
  788901
  788911
  789308
  795163
  800545
  801284
]
19.48 ms
(11.42%)
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
  185353
  401084
  381871
  561829
  586601
  468166
  418530
  536861
  491457
  800545
  741249
  433137
  515867
  424312
  536256
  655084
  788901
  417701
  491569
  753480
  619552
  418597
  788911
  788119
  415151
  447494
  576314
  469528
  476176
  485160
  560642
  480135
  413258
  373897
  673767
  680146
  107606
  607900
  769325
  779706
  396781
  667026
  570537
  426153
  429223
  482081
  474601
  401944
  521899
  516848
  519573
  484819
  501831
  517106
  501649
  471779
  559951
  413544
  486077
  447537
  487708
  512770
  519565
  485031
  517580
  722478
  563647
  607093
  474590
  479759
  418270
  466455
  490863
  491941
  519555
  493399
  534218
  578478
  514386
  633746
  420331
  487370
  428238
  425121
  476143
  456069
  498536
  596649
  480306
  427992
  447538
  717832
  669717
  769793
  401100
  789308
  801284
  531194
  628090
  423615
  310758
  428742
  445837
  575723
  561632
  570462
  594164
  586546
  795163
  444841
  453081
  381775
  482075
  508876
  494386
  534060
  496725
  470511
  537934
  561834
]
3.44 ms
(2.02%)
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
  107606
  185353
  310758
  373897
  381775
  381871
  396781
  401084
  401100
  401944
  413258
  413544
  415151
  417701
  418270
  418530
  418597
  420331
  423615
  424312
  425121
  426153
  427992
  428238
  428742
  429223
  433137
  444841
  445837
  447494
  447537
  447538
  453081
  456069
  466455
  468166
  469528
  470511
  471779
  474590
  474601
  476143
  476176
  479759
  480135
  480306
  482075
  482081
  484819
  485031
  485160
  486077
  487370
  487708
  490863
  491457
  491569
  491941
  493399
  494386
  496725
  498536
  501649
  501831
  508876
  512770
  514386
  515867
  516848
  517106
  517580
  519555
  519565
  519573
  521899
  531194
  534060
  534218
  536256
  536861
  537934
  559951
  560642
  561632
  561829
  561834
  563647
  570462
  570537
  575723
  576314
  578478
  586546
  586601
  594164
  596649
  607093
  607900
  619552
  628090
  633746
  655084
  667026
  669717
  673767
  680146
  717832
  722478
  741249
  753480
  769325
  769793
  779706
  788119
  788901
  788911
  789308
  795163
  800545
  801284
]
2.23 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал сиськ красивая"
]
2.19 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð░ð¢ð░ð╗ Ðüð©ÐüÐîð║ð© ð║ÐÇð░Ðüð░ð▓ð©ÐåðÔÔǪ"
]
1.82 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.94%)
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.