Query Metrics
7
Database Queries
7
Different statements
171.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.26 ms (86.29%) |
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 88614 340567 474266 478006 485156 492658 493743 506257 509432 513672 516140 517272 524986 529658 531757 531836 533779 537171 537476 537667 538749 541790 543714 545043 545225 546147 546409 548116 548389 554487 554843 555016 555077 555288 555307 555312 555359 558718 559292 560913 563685 564281 568261 576985 583460 586407 588202 588393 593052 593184 601930 604562 604880 610006 614192 615693 619656 625738 642065 662914 665835 668561 692265 692701 711728 714694 719389 719890 720571 723659 726322 729228 729290 731758 735910 736036 739180 743934 748463 749234 752668 757438 766599 766698 768348 770149 775693 780682 780691 781485 783368 783374 784358 788185 790845 792804 794241 794859 794914 797359 797785 797969 798999 799027 801917 802365 802372 804030 804208 804215 809339 810069 810332 811691 815162 815171 817765 819253 825140 827431 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (8.26%) |
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 610006 586407 588202 642065 784358 748463 797785 801917 804208 810069 749234 735910 770149 604562 615693 799027 804215 478006 492658 516140 493743 513672 517272 555016 524986 509432 555077 555359 558718 555288 692265 619656 614192 601930 781485 804030 766698 736036 546147 554487 593052 802372 743934 568261 340567 88614 819253 723659 827431 815162 817765 815171 825140 474266 485156 529658 537667 531757 533779 537171 506257 537476 538749 531836 541790 543714 548116 548389 559292 564281 545225 546409 583460 560913 563685 668561 692701 711728 662914 665835 714694 719389 719890 545043 554843 555307 555312 576985 588393 593184 604880 780682 780691 794859 810332 811691 775693 788185 792804 794914 797969 802365 809339 729290 752668 783368 790845 794241 797359 798999 766599 729228 731758 739180 726322 757438 768348 625738 720571 783374 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.84%) |
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 88614 340567 474266 478006 485156 492658 493743 506257 509432 513672 516140 517272 524986 529658 531757 531836 533779 537171 537476 537667 538749 541790 543714 545043 545225 546147 546409 548116 548389 554487 554843 555016 555077 555288 555307 555312 555359 558718 559292 560913 563685 564281 568261 576985 583460 586407 588202 588393 593052 593184 601930 604562 604880 610006 614192 615693 619656 625738 642065 662914 665835 668561 692265 692701 711728 714694 719389 719890 720571 723659 726322 729228 729290 731758 735910 736036 739180 743934 748463 749234 752668 757438 766599 766698 768348 770149 775693 780682 780691 781485 783368 783374 784358 788185 790845 792804 794241 794859 794914 797359 797785 797969 798999 799027 801917 802365 802372 804030 804208 804215 809339 810069 810332 811691 815162 815171 817765 819253 825140 827431 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк mature"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape mature"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк mature"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.