Query Metrics
7
Database Queries
7
Different statements
152.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.86 ms (80.67%) |
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 73280 391530 394031 399848 405406 407600 409220 410799 425249 429104 437274 438055 446103 462156 464553 464572 477013 477194 479215 480089 482493 486504 496688 499379 511466 513332 515310 522347 527726 530013 539243 542752 546383 548588 552804 554355 555947 556329 556768 556869 565352 574297 579434 579488 581494 582597 587065 593739 596165 600047 605046 607074 609584 610601 613153 618795 619105 619336 624869 625963 626713 627687 631876 633954 648018 670109 674478 677564 682515 682519 692616 697155 699551 701531 707082 709148 712122 724706 726348 726686 731129 732130 733545 735198 737261 737481 739622 743063 744088 744624 747044 747797 748375 750724 753442 755723 756314 758118 758629 759543 762150 762899 764954 765848 769642 775218 779757 781785 782979 789605 790892 792569 794921 800365 806353 810176 811840 814497 821902 826280 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (11.47%) |
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 712122 633954 794921 782979 522347 555947 605046 781785 739622 750724 756314 747044 731129 699551 811840 399848 391530 438055 425249 758118 530013 429104 792569 697155 806353 486504 624869 744624 480089 511466 409220 539243 513332 437274 587065 726348 748375 765848 527726 73280 394031 405406 482493 464572 462156 499379 515310 496688 464553 477013 609584 790892 762899 724706 726686 733545 743063 769642 407600 410799 477194 446103 479215 826280 821902 554355 565352 692616 701531 670109 674478 682519 707082 709148 556768 556869 596165 600047 607074 610601 593739 625963 627687 631876 775218 789605 800365 737261 755723 810176 732130 758629 759543 764954 737481 747797 753442 762150 619336 779757 814497 574297 579434 579488 542752 546383 548588 556329 581494 677564 682515 648018 552804 582597 618795 619105 626713 744088 735198 613153 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (2.36%) |
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 73280 391530 394031 399848 405406 407600 409220 410799 425249 429104 437274 438055 446103 462156 464553 464572 477013 477194 479215 480089 482493 486504 496688 499379 511466 513332 515310 522347 527726 530013 539243 542752 546383 548588 552804 554355 555947 556329 556768 556869 565352 574297 579434 579488 581494 582597 587065 593739 596165 600047 605046 607074 609584 610601 613153 618795 619105 619336 624869 625963 626713 627687 631876 633954 648018 670109 674478 677564 682515 682519 692616 697155 699551 701531 707082 709148 712122 724706 726348 726686 731129 732130 733545 735198 737261 737481 739622 743063 744088 744624 747044 747797 748375 750724 753442 755723 756314 758118 758629 759543 762150 762899 764954 765848 769642 775218 779757 781785 782979 789605 790892 792569 794921 800365 806353 810176 811840 814497 821902 826280 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock suck"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock suck"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock suck"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
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.