Query Metrics
7
Database Queries
7
Different statements
143.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.29 ms (82.57%) |
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 46053 387130 395427 404389 405830 407700 411809 413472 425532 439524 450117 457460 462182 467949 475842 479685 494626 494849 511117 516226 523845 531250 536408 544624 545004 545065 545254 546146 555077 555110 555411 573244 610058 636438 640879 659938 661588 662889 664557 670232 679892 698608 707404 707488 707516 714037 714587 715362 717118 718461 718830 725222 727046 730102 730191 731154 731256 731433 731552 731844 733455 735885 735927 736004 742750 743801 744405 744412 746052 746139 747083 751501 752741 752945 754161 758445 759388 759674 759688 759947 761021 761138 766698 766888 768348 780705 789192 791607 794325 794893 796040 796044 797174 797969 799713 800394 800598 800738 800751 800764 803194 803435 803442 804008 804247 808256 811923 819720 819754 820362 820377 825110 825357 825882 826927 827329 827517 827594 827669 827725 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (9.43%) |
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 730102 747083 731844 746052 404389 450117 407700 752945 531250 536408 479685 462182 494626 511117 494849 545065 546146 545004 545254 555411 573244 679892 717118 661588 664557 670232 707404 636438 780705 789192 796044 803194 796040 797969 800738 803435 803442 731256 736004 744412 754161 758445 794325 794893 800394 800598 731433 743801 759388 761138 746139 752741 735927 759688 766888 768348 727046 730191 731154 731552 735885 742750 759674 759947 761021 610058 698608 707488 707516 714037 714587 715362 791607 800751 800764 804008 804247 733455 467949 439524 475842 457460 405830 523845 395427 413472 411809 555110 516226 46053 662889 718461 544624 797174 808256 725222 744405 555077 766698 811923 387130 425532 819720 819754 820377 825110 826927 827594 827329 827517 827725 820362 825357 825882 827669 718830 659938 640879 799713 751501 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (2.13%) |
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 46053 387130 395427 404389 405830 407700 411809 413472 425532 439524 450117 457460 462182 467949 475842 479685 494626 494849 511117 516226 523845 531250 536408 544624 545004 545065 545254 546146 555077 555110 555411 573244 610058 636438 640879 659938 661588 662889 664557 670232 679892 698608 707404 707488 707516 714037 714587 715362 717118 718461 718830 725222 727046 730102 730191 731154 731256 731433 731552 731844 733455 735885 735927 736004 742750 743801 744405 744412 746052 746139 747083 751501 752741 752945 754161 758445 759388 759674 759688 759947 761021 761138 766698 766888 768348 780705 789192 791607 794325 794893 796040 796044 797174 797969 799713 800394 800598 800738 800751 800764 803194 803435 803442 804008 804247 808256 811923 819720 819754 820362 820377 825110 825357 825882 826927 827329 827517 827594 827669 827725 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sperm cum"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature сперм cum"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature сперм cum"
]
|
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.