Query Metrics
8
Database Queries
8
Different statements
236.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.93 ms (74.31%) |
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 391925 412852 414277 416523 418356 420003 420700 423345 427656 428758 435275 436685 440761 441295 444647 445012 446240 447070 447347 449546 450367 452540 452847 454744 454840 457966 458252 461962 464200 464636 471057 475597 477948 482609 495467 498552 498641 502583 505722 509147 519350 523175 526563 528320 531599 536377 537026 538750 540894 544057 545167 545682 549153 556755 558464 559973 561756 564686 566595 566599 568257 571393 580216 583542 586294 594820 598136 599472 605686 605874 608516 608534 609198 609582 612848 624941 643226 644018 658797 664504 664524 666133 675297 687430 694967 699487 709754 712242 713990 714322 714346 714443 714479 714493 714511 720186 726503 726520 726558 727040 730367 732165 739117 739909 744966 747885 748416 749520 751307 752359 769405 771355 776248 778699 788039 792147 799081 806584 808690 824427 ] |
||||||||||||||||||||||||||||||
|
32.32 ms (13.65%) |
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:
[ "young masturbation homemade" "young masturbation homemade" "young masturbation homemade" 20 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (7.46%) |
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 427656 440761 423345 526563 549153 544057 558464 594820 732165 416523 495467 713990 624941 444647 482609 458252 447070 509147 464636 571393 699487 714479 664524 643226 806584 752359 769405 391925 537026 714511 556755 454840 428758 788039 450367 498641 519350 523175 612848 412852 441295 824427 449546 452847 528320 538750 536377 540894 545682 566599 580216 709754 714346 675297 714322 545167 566595 586294 605686 609198 599472 609582 776248 778699 726503 739909 792147 726558 739117 744966 747885 751307 771355 727040 748416 712242 414277 445012 420700 452540 454744 559973 598136 666133 658797 564686 608534 531599 446240 502583 505722 498552 464200 471057 568257 583542 714493 720186 664504 687430 694967 714443 561756 605874 644018 608516 799081 726520 730367 749520 808690 420003 435275 436685 418356 447347 461962 477948 457966 475597 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.44%) |
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 391925 412852 414277 416523 418356 420003 420700 423345 427656 428758 435275 436685 440761 441295 444647 445012 446240 447070 447347 449546 450367 452540 452847 454744 454840 457966 458252 461962 464200 464636 471057 475597 477948 482609 495467 498552 498641 502583 505722 509147 519350 523175 526563 528320 531599 536377 537026 538750 540894 544057 545167 545682 549153 556755 558464 559973 561756 564686 566595 566599 568257 571393 580216 583542 586294 594820 598136 599472 605686 605874 608516 608534 609198 609582 612848 624941 643226 644018 658797 664504 664524 666133 675297 687430 694967 699487 709754 712242 713990 714322 714346 714443 714479 714493 714511 720186 726503 726520 726558 727040 730367 732165 739117 739909 744966 747885 748416 749520 751307 752359 769405 771355 776248 778699 788039 792147 799081 806584 808690 824427 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young masturbation homemade"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young мастурбац домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young мастурбац домашн любительск"
]
|
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.