Query Metrics
7
Database Queries
7
Different statements
166.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.04 ms (82.14%) |
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 72499 80230 145591 146006 294327 354122 382006 383002 384588 386781 387150 389504 390021 397176 403109 411925 431702 433685 453275 462230 462235 462333 466984 468284 469360 470976 479771 489922 490592 492397 493228 502061 506848 520187 522098 522193 539348 539352 550514 563734 576490 580910 589707 591162 593060 596508 599737 607692 611280 615260 619791 620880 631238 635775 641807 644199 645813 650146 652163 665224 665294 666080 667395 681495 681621 700804 717144 719100 724762 724768 725395 726859 728381 729932 730813 732184 733337 736017 740662 742056 742548 744200 744208 744805 744985 748431 751507 754057 754468 756620 770114 776414 778058 778481 781972 787756 788226 788539 794161 796860 797352 801804 802382 804241 804257 804432 804441 804445 804458 807837 807850 807869 809997 810021 810101 810112 812055 814117 823978 826004 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (10.61%) |
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 635775 810112 788226 801804 804432 807837 742056 742548 770114 748431 717144 776414 796860 383002 631238 386781 620880 462230 431702 294327 462235 522098 814117 730813 810101 479771 681495 563734 729932 744805 390021 539348 539352 615260 462333 652163 644199 778481 804257 807850 522193 145591 550514 823978 740662 681621 719100 724768 744208 725395 728381 756620 700804 778058 788539 754468 804241 754057 826004 650146 589707 72499 382006 807869 389504 387150 469360 520187 468284 641807 787756 146006 403109 596508 80230 433685 502061 576490 645813 591162 607692 619791 797352 810021 794161 804441 812055 736017 744985 733337 744200 751507 781972 804458 809997 492397 470976 580910 453275 466984 397176 490592 354122 611280 411925 506848 665224 666080 665294 599737 593060 802382 726859 724762 667395 493228 732184 804445 489922 384588 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.65%) |
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 72499 80230 145591 146006 294327 354122 382006 383002 384588 386781 387150 389504 390021 397176 403109 411925 431702 433685 453275 462230 462235 462333 466984 468284 469360 470976 479771 489922 490592 492397 493228 502061 506848 520187 522098 522193 539348 539352 550514 563734 576490 580910 589707 591162 593060 596508 599737 607692 611280 615260 619791 620880 631238 635775 641807 644199 645813 650146 652163 665224 665294 666080 667395 681495 681621 700804 717144 719100 724762 724768 725395 726859 728381 729932 730813 732184 733337 736017 740662 742056 742548 744200 744208 744805 744985 748431 751507 754057 754468 756620 770114 776414 778058 778481 781972 787756 788226 788539 794161 796860 797352 801804 802382 804241 804257 804432 804441 804445 804458 807837 807850 807869 809997 810021 810101 810112 812055 814117 823978 826004 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits hairy"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.