Query Metrics
7
Database Queries
7
Different statements
158.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.19 ms (85.47%) |
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 440681 444907 448497 453273 491616 493363 504424 512142 523799 525690 530033 533785 534635 535322 541750 541815 558356 565512 568595 584281 585633 586295 588390 593983 599715 606447 612981 621777 623192 623670 627345 628566 633252 637869 639112 639210 643515 645604 650663 651759 661581 670938 672310 672791 674280 678837 679304 689514 696817 698386 708561 709761 711613 711777 713367 713706 721934 725526 727024 729263 733453 734030 735827 735886 738922 744081 748330 749081 749552 751412 751645 754366 754399 758375 758846 759012 760517 762900 764776 764782 772140 777691 779259 782535 782872 783602 783651 784480 785685 785965 786339 787050 787779 789196 789757 790130 790283 790725 791138 792304 792754 793803 795661 795719 796771 803082 803637 805105 807212 807240 807879 808087 810094 810165 811565 813518 816815 816878 826493 827691 ] |
||||||||||||||||||||||||||||||
|
12.82 ms (8.10%) |
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 448497 493363 525690 533785 504424 541750 541815 678837 708561 588390 585633 586295 783602 785965 795661 777691 779259 783651 791138 803082 813518 758846 784480 789196 789757 790283 790725 803637 807240 808087 810165 734030 749552 751645 733453 735827 758375 759012 735886 762900 738922 764782 698386 721934 782872 790130 796771 807212 807879 512142 645604 535322 670938 672310 679304 696817 651759 674280 713367 612981 621777 637869 593983 628566 639210 795719 633252 440681 444907 709761 711613 623670 639112 606447 787779 760517 782535 523799 826493 816878 816815 827691 453273 491616 534635 530033 558356 565512 568595 584281 650663 672791 713706 661581 711777 689514 643515 623192 599715 627345 785685 787050 792304 786339 793803 805105 811565 727024 729263 748330 749081 751412 764776 772140 792754 810094 744081 754366 754399 725526 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.96%) |
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 440681 444907 448497 453273 491616 493363 504424 512142 523799 525690 530033 533785 534635 535322 541750 541815 558356 565512 568595 584281 585633 586295 588390 593983 599715 606447 612981 621777 623192 623670 627345 628566 633252 637869 639112 639210 643515 645604 650663 651759 661581 670938 672310 672791 674280 678837 679304 689514 696817 698386 708561 709761 711613 711777 713367 713706 721934 725526 727024 729263 733453 734030 735827 735886 738922 744081 748330 749081 749552 751412 751645 754366 754399 758375 758846 759012 760517 762900 764776 764782 772140 777691 779259 782535 782872 783602 783651 784480 785685 785965 786339 787050 787779 789196 789757 790130 790283 790725 791138 792304 792754 793803 795661 795719 796771 803082 803637 805105 807212 807240 807879 808087 810094 810165 811565 813518 816815 816878 826493 827691 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.89%) |
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.