Query Metrics
7
Database Queries
7
Different statements
205.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.11 ms (86.60%) |
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 246506 382105 391583 391676 400945 412609 418893 427737 432413 432508 438369 443070 444987 446604 448306 448508 449829 450503 452557 452769 455114 455190 455406 455971 456738 459499 459511 460905 463725 464135 464548 464753 465154 467016 468209 469164 470060 470145 470208 470737 471053 473679 474780 475014 477862 478304 478390 479148 480668 481245 491103 492841 493042 493909 494095 494400 494413 495182 499257 499742 500157 500437 501801 503383 503640 507452 508562 509650 512231 518778 518789 519079 521170 521976 522812 522824 523282 525389 525452 525814 528057 528284 538423 546632 547229 551619 555994 555996 556715 560438 560793 562795 565019 571335 572812 573817 574628 579215 582321 582369 584424 594638 598466 619903 699444 713731 714474 718876 725476 727138 736978 738926 755838 758158 759097 761247 763744 764215 790517 797060 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (8.37%) |
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 738926 755838 759097 758158 763744 725476 727138 736978 761247 764215 619903 699444 713731 714474 718876 790517 797060 391676 475014 459511 460905 448508 246506 470060 481245 468209 518778 522812 525814 528284 499257 509650 521976 523282 538423 493042 493909 499742 519079 522824 562795 450503 525452 512231 494095 494413 503640 547229 551619 555994 560438 555996 556715 572812 582321 582369 584424 546632 560793 571335 573817 574628 565019 579215 594638 598466 427737 432413 432508 455190 456738 464548 469164 471053 478304 478390 480668 382105 412609 446604 452557 467016 473679 479148 391583 448306 452769 455114 455971 470145 470208 470737 474780 400945 418893 438369 443070 444987 449829 455406 463725 464135 464753 459499 465154 477862 500157 500437 501801 507452 508562 518789 492841 494400 495182 503383 521170 525389 528057 491103 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.51%) |
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 246506 382105 391583 391676 400945 412609 418893 427737 432413 432508 438369 443070 444987 446604 448306 448508 449829 450503 452557 452769 455114 455190 455406 455971 456738 459499 459511 460905 463725 464135 464548 464753 465154 467016 468209 469164 470060 470145 470208 470737 471053 473679 474780 475014 477862 478304 478390 479148 480668 481245 491103 492841 493042 493909 494095 494400 494413 495182 499257 499742 500157 500437 501801 503383 503640 507452 508562 509650 512231 518778 518789 519079 521170 521976 522812 522824 523282 525389 525452 525814 528057 528284 538423 546632 547229 551619 555994 555996 556715 560438 560793 562795 565019 571335 572812 573817 574628 579215 582321 582369 584424 594638 598466 619903 699444 713731 714474 718876 725476 727138 736978 738926 755838 758158 759097 761247 763744 764215 790517 797060 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy russian"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy русск"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy русск"
]
|
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.