Query Metrics
7
Database Queries
7
Different statements
225.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.09 ms (89.02%) |
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 395676 395714 395738 401482 404568 404953 411468 413544 414077 435158 441015 447535 450226 452156 454084 465812 465902 469020 473179 478043 487708 488477 488531 488536 492232 495660 503115 504061 508442 509808 510803 511141 513328 514243 514768 518223 519218 519332 520313 522604 522611 522919 525634 527850 528088 531262 532720 533063 533380 536584 547472 551909 555004 556018 561445 564385 567743 578478 585726 592428 592805 597898 600444 604661 604832 605320 606283 643079 645365 645952 651685 652223 671725 672184 681647 688666 689614 690144 695103 699554 702621 707318 709594 710236 711628 715524 716784 716882 717072 718775 742804 744651 760841 761172 779119 781824 786197 788262 795141 798999 800285 800296 801909 802514 802519 805925 811474 811989 812014 812926 814218 815180 815890 815910 816063 816886 816991 820840 821521 822421 ] |
||||||||||||||||||||||||||||||
|
13.63 ms (6.04%) |
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 561445 597898 798999 761172 801909 395676 441015 413544 473179 488531 518223 522611 527850 510803 525634 531262 528088 533380 564385 551909 556018 699554 688666 604661 404568 395714 454084 465812 465902 469020 414077 450226 478043 401482 411468 452156 447535 522919 492232 504061 508442 513328 514243 488477 503115 487708 511141 519218 814218 707318 604832 781824 802519 742804 744651 779119 805925 578478 812014 718775 532720 533063 652223 716882 645952 643079 788262 435158 495660 520313 488536 522604 509808 681647 689614 395738 404953 514768 702621 815180 815890 816063 816991 816886 822421 815910 821521 715524 592428 795141 811989 760841 802514 811474 536584 567743 800285 585726 812926 519332 820840 547472 645365 651685 695103 709594 671725 672184 710236 690144 711628 716784 717072 555004 592805 600444 605320 606283 786197 800296 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.39%) |
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 395676 395714 395738 401482 404568 404953 411468 413544 414077 435158 441015 447535 450226 452156 454084 465812 465902 469020 473179 478043 487708 488477 488531 488536 492232 495660 503115 504061 508442 509808 510803 511141 513328 514243 514768 518223 519218 519332 520313 522604 522611 522919 525634 527850 528088 531262 532720 533063 533380 536584 547472 551909 555004 556018 561445 564385 567743 578478 585726 592428 592805 597898 600444 604661 604832 605320 606283 643079 645365 645952 651685 652223 671725 672184 681647 688666 689614 690144 695103 699554 702621 707318 709594 710236 711628 715524 716784 716882 717072 718775 742804 744651 760841 761172 779119 781824 786197 788262 795141 798999 800285 800296 801909 802514 802519 805925 811474 811989 812014 812926 814218 815180 815890 815910 816063 816886 816991 820840 821521 822421 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf beauty anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf beauty анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf beauty анал"
]
|
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.