Query Metrics
7
Database Queries
7
Different statements
212.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.37 ms (88.98%) |
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 398965 398972 407616 423703 427634 428932 432716 434008 439223 446789 448328 450845 456509 457413 462242 468357 471461 486175 504017 511937 513017 514073 525198 525998 526187 533599 538972 542043 547543 550451 564191 567602 568992 574050 577805 579725 579734 580129 581594 588334 589820 591320 597746 598469 599653 609644 614831 614852 617949 619856 627822 629990 637494 641593 642571 648437 653987 659192 659401 662213 666473 669665 671560 678992 685106 685509 694751 696115 700965 701237 709654 710571 714348 715175 719443 725448 725500 726805 727037 732787 736020 738001 739675 740986 741523 742319 743479 745072 746135 750579 751012 752913 754321 755343 755878 756289 768884 769380 772609 782404 784916 784969 785309 789054 793494 793877 801364 804696 809064 809548 810635 810646 811068 813136 814378 818117 818686 819058 824371 827968 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (6.70%) |
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 427634 432716 818117 818686 819058 533599 525198 525998 468357 568992 542043 653987 694751 648437 666473 659192 662213 685106 700965 579725 619856 591320 589820 614852 789054 801364 810646 784969 793494 809548 725448 732787 740986 746135 772609 804696 751012 745072 754321 739675 755343 736020 741523 609644 715175 782404 810635 398965 423703 448328 814378 446789 471461 538972 567602 726805 428932 513017 809064 678992 617949 769380 725500 709654 669665 547543 574050 577805 685509 701237 793877 755878 742319 550451 614831 462242 457413 824371 456509 504017 514073 526187 511937 564191 579734 597746 598469 629990 727037 811068 434008 398972 439223 486175 827968 450845 581594 659401 671560 719443 714348 696115 580129 641593 642571 588334 599653 637494 785309 743479 752913 768884 738001 750579 756289 627822 710571 784916 813136 407616 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.40%) |
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 398965 398972 407616 423703 427634 428932 432716 434008 439223 446789 448328 450845 456509 457413 462242 468357 471461 486175 504017 511937 513017 514073 525198 525998 526187 533599 538972 542043 547543 550451 564191 567602 568992 574050 577805 579725 579734 580129 581594 588334 589820 591320 597746 598469 599653 609644 614831 614852 617949 619856 627822 629990 637494 641593 642571 648437 653987 659192 659401 662213 666473 669665 671560 678992 685106 685509 694751 696115 700965 701237 709654 710571 714348 715175 719443 725448 725500 726805 727037 732787 736020 738001 739675 740986 741523 742319 743479 745072 746135 750579 751012 752913 754321 755343 755878 756289 768884 769380 772609 782404 784916 784969 785309 789054 793494 793877 801364 804696 809064 809548 810635 810646 811068 813136 814378 818117 818686 819058 824371 827968 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"masturbating большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbating big ass"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"masturbating большая большие жоп"
]
|
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.