Query Metrics
7
Database Queries
7
Different statements
182.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.98 ms (88.26%) |
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 146800 154573 373995 385705 393052 396716 398097 398429 400614 409560 428570 428956 441027 441039 497030 513790 523355 547496 564593 595246 595454 622318 625796 637579 649960 666876 674966 703260 720285 723825 728373 728750 729634 732301 734859 734961 735967 736296 736318 739305 739467 740222 743087 743248 743716 745114 745139 745142 745503 746612 748011 748034 748309 749204 749679 749685 752584 752631 753503 754194 756822 758457 760019 760524 761502 762167 767054 768913 769895 770592 771331 771338 771927 772863 773099 773384 775700 775706 776048 776313 776909 777013 777033 777046 777077 777207 780662 783711 786093 786117 786203 788188 788321 788435 788529 790203 790415 790865 792729 793363 793902 796289 796397 797156 797494 801448 801763 804195 804695 804967 805661 806044 806817 807370 810168 810700 814160 814982 818867 821334 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (6.86%) |
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 637579 595246 622318 625796 775700 777013 777046 783711 786203 788321 788435 790415 793363 797156 797494 801763 804695 810700 776048 776909 777033 777207 786117 793902 801448 729634 736318 739305 739467 748034 752584 758457 760019 761502 769895 770592 772863 773099 773384 786093 788188 788529 792729 796289 796397 806817 810168 745114 746612 749204 753503 762167 771331 723825 728373 734859 734961 740222 748011 748309 752631 767054 728750 732301 735967 743716 745139 745142 754194 771338 771927 736296 743248 749679 749685 756822 760524 768913 703260 720285 775706 776313 777077 780662 790203 790865 804195 804967 805661 806044 807370 373995 146800 666876 441027 497030 513790 564593 547496 428570 523355 674966 393052 743087 745503 649960 595454 441039 385705 154573 396716 398429 398097 400614 409560 428956 814160 814982 818867 821334 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.29%) |
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 146800 154573 373995 385705 393052 396716 398097 398429 400614 409560 428570 428956 441027 441039 497030 513790 523355 547496 564593 595246 595454 622318 625796 637579 649960 666876 674966 703260 720285 723825 728373 728750 729634 732301 734859 734961 735967 736296 736318 739305 739467 740222 743087 743248 743716 745114 745139 745142 745503 746612 748011 748034 748309 749204 749679 749685 752584 752631 753503 754194 756822 758457 760019 760524 761502 762167 767054 768913 769895 770592 771331 771338 771927 772863 773099 773384 775700 775706 776048 776313 776909 777013 777033 777046 777077 777207 780662 783711 786093 786117 786203 788188 788321 788435 788529 790203 790415 790865 792729 793363 793902 796289 796397 797156 797494 801448 801763 804195 804695 804967 805661 806044 806817 807370 810168 810700 814160 814982 818867 821334 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole teen"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк teen"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дырк teen"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
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.