Query Metrics

8 Database Queries
8 Different statements
275.75 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.52 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.88 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "парень и две"
]
3 14.69 ms
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
  455265
  492331
  568125
  522901
  516141
  431376
  464623
  416098
  452513
  431022
  520793
  514815
  412288
  466994
  477890
  468599
  593875
  473920
  476921
  438018
  462209
  490762
  492269
  503967
  404876
  422028
  489738
  652931
  602017
  554004
  653471
  425523
  472513
  508454
  395818
  395718
  414131
  466561
  602966
  484673
  520445
  549246
  528435
  659328
  327121
  387391
  343398
  410124
  413246
  229460
  447164
  398040
  396692
  405850
  474923
  471174
  396279
  445515
  576358
  407687
  428117
  383392
  420094
  506782
  520440
  105093
  230935
  447733
  742207
  405786
  477434
  402683
  444400
  442301
  450224
  381940
  523535
  510216
  285923
  123741
  114536
  39142
  506414
  557145
  221923
  389782
  382368
  6864
  387798
  405479
  142253
  281927
  721570
  381955
  461966
  417386
  382977
  454496
  311697
  3320
  407058
  365861
  405820
  28591
  233547
  385704
  383495
  409276
  521816
  398628
  129857
  152276
  569448
  544395
  345630
  401959
  508093
  511757
  395580
  358757
]
4 2.67 ms
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
  3320
  6864
  28591
  39142
  105093
  114536
  123741
  129857
  142253
  152276
  221923
  229460
  230935
  233547
  281927
  285923
  311697
  327121
  343398
  345630
  358757
  365861
  381940
  381955
  382368
  382977
  383392
  383495
  385704
  387391
  387798
  389782
  395580
  395718
  395818
  396279
  396692
  398040
  398628
  401959
  402683
  404876
  405479
  405786
  405820
  405850
  407058
  407687
  409276
  410124
  412288
  413246
  414131
  416098
  417386
  420094
  422028
  425523
  428117
  431022
  431376
  438018
  442301
  444400
  445515
  447164
  447733
  450224
  452513
  454496
  455265
  461966
  462209
  464623
  466561
  466994
  468599
  471174
  472513
  473920
  474923
  476921
  477434
  477890
  484673
  489738
  490762
  492269
  492331
  503967
  506414
  506782
  508093
  508454
  510216
  511757
  514815
  516141
  520440
  520445
  520793
  521816
  522901
  523535
  528435
  544395
  549246
  554004
  557145
  568125
  569448
  576358
  593875
  602017
  602966
  652931
  653471
  659328
  721570
  742207
]
5 218.42 ms
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
  3320
  6864
  28591
  39142
  105093
  114536
  123741
  129857
  142253
  152276
  221923
  229460
  230935
  233547
  281927
  285923
  311697
  327121
  343398
  345630
  358757
  365861
  381940
  381955
  382368
  382977
  383392
  383495
  385704
  387391
  387798
  389782
  395580
  395718
  395818
  396279
  396692
  398040
  398628
  401959
  402683
  404876
  405479
  405786
  405820
  405850
  407058
  407687
  409276
  410124
  412288
  413246
  414131
  416098
  417386
  420094
  422028
  425523
  428117
  431022
  431376
  438018
  442301
  444400
  445515
  447164
  447733
  450224
  452513
  454496
  455265
  461966
  462209
  464623
  466561
  466994
  468599
  471174
  472513
  473920
  474923
  476921
  477434
  477890
  484673
  489738
  490762
  492269
  492331
  503967
  506414
  506782
  508093
  508454
  510216
  511757
  514815
  516141
  520440
  520445
  520793
  521816
  522901
  523535
  528435
  544395
  549246
  554004
  557145
  568125
  569448
  576358
  593875
  602017
  602966
  652931
  653471
  659328
  721570
  742207
]
6 1.82 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен две"
]
7 1.73 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен две"
]
8 33.03 ms
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "парень и две"
  "парень и две"
  "парень и две"
  20
]

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.