Query Metrics
8
Database Queries
8
Different statements
239.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.80 ms (84.32%) |
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 80365 101353 397397 397403 414055 463872 487248 508921 525869 531576 531587 539228 539400 540973 542341 542988 544100 545020 548512 554018 558455 581755 583357 588007 590266 599294 617072 619790 629265 631120 635788 636208 639364 639720 645720 647074 658553 661435 670576 672989 675160 675173 675536 679596 683252 692363 693158 700812 703504 703662 709523 711649 713164 713168 717261 720081 724933 729906 733007 733963 736428 738777 739554 739564 739584 740282 746298 748747 748918 749197 751149 754833 755166 759493 762426 763571 763575 763592 763609 764243 764519 765993 766873 767533 767951 769621 769636 771159 772280 774717 775496 777801 777891 778987 779435 779436 780040 780057 780148 780498 781600 783318 787612 788246 788890 790838 791137 791970 792395 793315 793800 793978 798445 802283 806864 809146 810219 814307 819728 825222 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (6.30%) |
1 |
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:
[ "homemade gagging deepthroat" "homemade gagging deepthroat" "homemade gagging deepthroat" 20 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (5.07%) |
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 508921 539400 558455 647074 713168 661435 692363 693158 639364 619790 729906 763609 825222 792395 733963 414055 675173 636208 397397 767533 531576 588007 599294 772280 635788 793315 755166 806864 754833 783318 798445 583357 819728 101353 775496 748918 769636 788246 781600 802283 777891 736428 767951 763571 764243 777801 525869 531587 544100 545020 548512 658553 629265 739564 617072 733007 748747 539228 675160 463872 542341 80365 700812 780148 778987 759493 540973 672989 581755 720081 780498 717261 790838 709523 683252 769621 675536 631120 679596 787612 780057 751149 645720 766873 791970 780040 810219 762426 763575 763592 711649 749197 713164 590266 639720 771159 764519 487248 809146 397403 814307 542988 554018 779435 791137 788890 793800 793978 724933 740282 746298 765993 738777 739554 739584 774717 779436 670576 703504 703662 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (1.51%) |
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 80365 101353 397397 397403 414055 463872 487248 508921 525869 531576 531587 539228 539400 540973 542341 542988 544100 545020 548512 554018 558455 581755 583357 588007 590266 599294 617072 619790 629265 631120 635788 636208 639364 639720 645720 647074 658553 661435 670576 672989 675160 675173 675536 679596 683252 692363 693158 700812 703504 703662 709523 711649 713164 713168 717261 720081 724933 729906 733007 733963 736428 738777 739554 739564 739584 740282 746298 748747 748918 749197 751149 754833 755166 759493 762426 763571 763575 763592 763609 764243 764519 765993 766873 767533 767951 769621 769636 771159 772280 774717 775496 777801 777891 778987 779435 779436 780040 780057 780148 780498 781600 783318 787612 788246 788890 790838 791137 791970 792395 793315 793800 793978 798445 802283 806864 809146 810219 814307 819728 825222 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade gagging deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск gagging глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск gagging глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.