Query Metrics
7
Database Queries
7
Different statements
161.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.46 ms (84.42%) |
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 2808 16831 76122 147280 152529 163116 187996 382085 384543 386807 387597 388714 389745 391056 394490 396794 398179 425565 460611 500186 501384 506771 530585 532774 533173 534887 538167 539555 539573 540426 541023 547042 555491 557636 562539 562633 580953 581585 592880 603848 610549 611093 621823 624046 630957 631420 631636 634481 639125 640302 641268 641391 642155 643434 651094 651665 658512 659158 659199 665200 665373 667660 667766 667983 669216 669751 670388 680919 681776 683622 687118 692214 696354 697625 708149 708983 713127 715194 717475 718570 719043 722132 726325 726818 726820 736613 736740 739265 742612 748393 753753 760486 761886 762700 763395 768058 772141 774311 790328 790336 797761 805291 805426 811871 817745 818143 820708 821778 823955 824726 824751 827905 827914 828039 828399 828760 828852 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (8.91%) |
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 797761 394490 827843 386807 147280 187996 827905 828039 538167 557636 708149 658512 681776 717475 634481 641268 760486 398179 722132 805426 659199 500186 534887 541023 697625 631636 640302 805291 540426 501384 506771 539573 530585 683622 718570 610549 774311 163116 389745 680919 396794 821778 669216 624046 761886 762700 772141 388714 2808 76122 817745 460611 533173 562539 152529 824210 828760 532774 651665 687118 643434 641391 763395 827914 539555 818143 659158 665373 736613 16831 824751 824726 828399 828852 811871 768058 580953 547042 642155 384543 669751 665200 719043 692214 630957 603848 790336 726325 736740 748393 611093 790328 391056 382085 822687 387597 820708 823955 562633 581585 555491 667983 715194 651094 667660 667766 708983 670388 696354 592880 621823 639125 726818 726820 739265 742612 753753 631420 713127 425565 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.19%) |
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 2808 16831 76122 147280 152529 163116 187996 382085 384543 386807 387597 388714 389745 391056 394490 396794 398179 425565 460611 500186 501384 506771 530585 532774 533173 534887 538167 539555 539573 540426 541023 547042 555491 557636 562539 562633 580953 581585 592880 603848 610549 611093 621823 624046 630957 631420 631636 634481 639125 640302 641268 641391 642155 643434 651094 651665 658512 659158 659199 665200 665373 667660 667766 667983 669216 669751 670388 680919 681776 683622 687118 692214 696354 697625 708149 708983 713127 715194 717475 718570 719043 722132 726325 726818 726820 736613 736740 739265 742612 748393 753753 760486 761886 762700 763395 768058 772141 774311 790328 790336 797761 805291 805426 811871 817745 818143 820708 821778 823955 824726 824751 827905 827914 828039 828399 828760 828852 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding big tits"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding большие сиськ"
]
|
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.