Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.66 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.68 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "попы голые"
]
3 14.50 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
  454309
  452815
  462180
  418920
  423642
  437341
  450296
  471036
  473325
  453147
  458319
  460272
  477891
  586421
  404734
  409844
  433016
  416902
  477519
  440393
  448143
  478242
  464667
  448424
  455322
  442979
  414595
  665908
  444841
  453477
  456307
  450640
  445747
  442218
  425925
  443074
  476330
  396033
  397531
  408528
  431439
  424655
  426042
  419570
  482811
  476670
  477636
  481025
  452809
  466711
  477387
  417395
  450256
  423558
  448837
  462271
  483762
  432532
  407266
  421547
  439469
  440691
  440639
  446497
  453220
  468946
  479931
  447846
  453976
  454172
  474273
  464814
  432731
  445720
  446641
  454623
  443239
  471480
  519960
  419631
  451022
  452374
  515675
  473429
  473531
  427357
  453348
  455782
  466185
  402240
  429929
  440927
  447936
  458786
  466259
  581001
  424173
  401116
  417295
  404030
  414317
  419445
  425023
  439382
  425175
  470737
  454111
  472188
  419245
  446900
  454051
  468388
  432685
  457564
  469294
  450334
  450088
  450666
  471435
  402092
]
4 2.90 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
  396033
  397531
  401116
  402092
  402240
  404030
  404734
  407266
  408528
  409844
  414317
  414595
  416902
  417295
  417395
  418920
  419245
  419445
  419570
  419631
  421547
  423558
  423642
  424173
  424655
  425023
  425175
  425925
  426042
  427357
  429929
  431439
  432532
  432685
  432731
  433016
  437341
  439382
  439469
  440393
  440639
  440691
  440927
  442218
  442979
  443074
  443239
  444841
  445720
  445747
  446497
  446641
  446900
  447846
  447936
  448143
  448424
  448837
  450088
  450256
  450296
  450334
  450640
  450666
  451022
  452374
  452809
  452815
  453147
  453220
  453348
  453477
  453976
  454051
  454111
  454172
  454309
  454623
  455322
  455782
  456307
  457564
  458319
  458786
  460272
  462180
  462271
  464667
  464814
  466185
  466259
  466711
  468388
  468946
  469294
  470737
  471036
  471435
  471480
  472188
  473325
  473429
  473531
  474273
  476330
  476670
  477387
  477519
  477636
  477891
  478242
  479931
  481025
  482811
  483762
  515675
  519960
  581001
  586421
  665908
]
5 173.82 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
  396033
  397531
  401116
  402092
  402240
  404030
  404734
  407266
  408528
  409844
  414317
  414595
  416902
  417295
  417395
  418920
  419245
  419445
  419570
  419631
  421547
  423558
  423642
  424173
  424655
  425023
  425175
  425925
  426042
  427357
  429929
  431439
  432532
  432685
  432731
  433016
  437341
  439382
  439469
  440393
  440639
  440691
  440927
  442218
  442979
  443074
  443239
  444841
  445720
  445747
  446497
  446641
  446900
  447846
  447936
  448143
  448424
  448837
  450088
  450256
  450296
  450334
  450640
  450666
  451022
  452374
  452809
  452815
  453147
  453220
  453348
  453477
  453976
  454051
  454111
  454172
  454309
  454623
  455322
  455782
  456307
  457564
  458319
  458786
  460272
  462180
  462271
  464667
  464814
  466185
  466259
  466711
  468388
  468946
  469294
  470737
  471036
  471435
  471480
  472188
  473325
  473429
  473531
  474273
  476330
  476670
  477387
  477519
  477636
  477891
  478242
  479931
  481025
  482811
  483762
  515675
  519960
  581001
  586421
  665908
]
6 1.59 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп голые"
]
7 209.94 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп голые"
]
8 17.43 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.