Query Metrics

9 Database Queries
9 Different statements
683.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.64 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 207.55 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в юбке и чулках"
]
3 211.21 ms
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01\x10DrÒpg‰Úx‘RrG\e"
]
4 14.55 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
  538714
  210146
  560826
  600876
  761890
  495129
  490553
  649867
  538831
  544265
  485878
  690020
  485344
  444136
  429847
  438588
  522241
  432477
  43207
  515618
  536092
  522571
  481995
  524435
  442573
  547882
  76011
  390568
  559223
  423772
  637469
  465906
  468114
  390951
  386043
  549083
  458464
  603310
  428098
  420538
  432496
  761788
  546076
  520936
  667280
  666107
  475618
  552882
  520815
  432517
  665319
  488566
  398960
  88664
  549166
  7791
  454536
  593338
  511415
  397322
  412691
  393306
  658463
  665589
  395344
  526484
  433531
  524842
  606218
  460844
  560302
  418226
  562567
  432479
  460930
  602754
  508293
  417372
  503036
  487217
  479893
  506248
  529340
  444095
  529914
  600796
  474070
  204545
  418918
  535316
  483114
  485076
  619024
  477980
  479418
  448545
  460896
  549682
  479956
  431555
  489169
  537783
  7308
  519616
  590518
  594616
  470952
  441251
  443808
  455398
  525746
  512736
  618696
  467808
  601384
  390403
  455445
  478460
  560373
  665292
]
5 2.84 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
  7308
  7791
  43207
  76011
  88664
  204545
  210146
  386043
  390403
  390568
  390951
  393306
  395344
  397322
  398960
  412691
  417372
  418226
  418918
  420538
  423772
  428098
  429847
  431555
  432477
  432479
  432496
  432517
  433531
  438588
  441251
  442573
  443808
  444095
  444136
  448545
  454536
  455398
  455445
  458464
  460844
  460896
  460930
  465906
  467808
  468114
  470952
  474070
  475618
  477980
  478460
  479418
  479893
  479956
  481995
  483114
  485076
  485344
  485878
  487217
  488566
  489169
  490553
  495129
  503036
  506248
  508293
  511415
  512736
  515618
  519616
  520815
  520936
  522241
  522571
  524435
  524842
  525746
  526484
  529340
  529914
  535316
  536092
  537783
  538714
  538831
  544265
  546076
  547882
  549083
  549166
  549682
  552882
  559223
  560302
  560373
  560826
  562567
  590518
  593338
  594616
  600796
  600876
  601384
  602754
  603310
  606218
  618696
  619024
  637469
  649867
  658463
  665292
  665319
  665589
  666107
  667280
  690020
  761788
  761890
]
6 197.99 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
  7308
  7791
  43207
  76011
  88664
  204545
  210146
  386043
  390403
  390568
  390951
  393306
  395344
  397322
  398960
  412691
  417372
  418226
  418918
  420538
  423772
  428098
  429847
  431555
  432477
  432479
  432496
  432517
  433531
  438588
  441251
  442573
  443808
  444095
  444136
  448545
  454536
  455398
  455445
  458464
  460844
  460896
  460930
  465906
  467808
  468114
  470952
  474070
  475618
  477980
  478460
  479418
  479893
  479956
  481995
  483114
  485076
  485344
  485878
  487217
  488566
  489169
  490553
  495129
  503036
  506248
  508293
  511415
  512736
  515618
  519616
  520815
  520936
  522241
  522571
  524435
  524842
  525746
  526484
  529340
  529914
  535316
  536092
  537783
  538714
  538831
  544265
  546076
  547882
  549083
  549166
  549682
  552882
  559223
  560302
  560373
  560826
  562567
  590518
  593338
  594616
  600796
  600876
  601384
  602754
  603310
  606218
  618696
  619024
  637469
  649867
  658463
  665292
  665319
  665589
  666107
  667280
  690020
  761788
  761890
]
7 1.79 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в юбк чулк нижн бел"
]
8 1.66 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в юбк чулк нижн бел"
]
9 44.71 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.