Query Metrics
7
Database Queries
7
Different statements
145.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.88 ms (82.84%) |
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 107102 145335 145353 145503 145757 382388 386257 387070 389347 395938 400348 415430 418268 418334 441955 442709 450108 464567 476266 487871 490665 528557 542320 544518 554307 561736 561759 566833 569661 581291 581408 587502 589683 589691 610166 614805 617568 624466 681621 698906 711828 714927 719095 719144 719173 719228 724748 724768 725582 725616 726596 726629 728506 728958 728995 729884 729989 730849 732220 732264 733217 733227 733271 733282 733307 733337 733342 734049 734283 734664 736011 739940 739969 744158 744159 746044 751799 763966 772355 773621 781962 783799 790388 793565 794196 794632 794676 796307 796466 800054 802039 802290 803918 804233 804463 809907 810057 812116 814376 814404 814727 817800 818408 823689 823754 824077 824790 824892 824893 824906 824952 825055 826059 826435 826620 826651 826773 826894 827155 827577 ] |
||||||||||||||||||||||||||||||
|
13.65 ms (9.36%) |
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 733282 826894 826059 744158 581291 610166 733271 528557 589683 387070 826435 802039 796307 796466 781962 827155 824790 823689 734283 728958 824952 733337 825055 824906 824893 587502 724768 561759 145757 733342 826651 442709 739969 724748 732220 814727 726629 729989 772355 751799 450108 698906 711828 794196 802290 726596 827577 624466 589691 725582 719095 389347 464567 804233 415430 824077 490665 614805 733307 395938 487871 714927 542320 581408 803918 145335 107102 719228 729884 145503 382388 826773 730849 386257 544518 719173 793565 783799 804463 728995 736011 746044 400348 812116 744159 728506 732264 800054 554307 569661 719144 794632 733217 145353 814376 566833 561736 824892 476266 681621 790388 794676 725616 734049 773621 617568 809907 810057 823754 441955 826620 817800 734664 763966 418334 814404 733227 418268 739940 818408 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.67%) |
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 107102 145335 145353 145503 145757 382388 386257 387070 389347 395938 400348 415430 418268 418334 441955 442709 450108 464567 476266 487871 490665 528557 542320 544518 554307 561736 561759 566833 569661 581291 581408 587502 589683 589691 610166 614805 617568 624466 681621 698906 711828 714927 719095 719144 719173 719228 724748 724768 725582 725616 726596 726629 728506 728958 728995 729884 729989 730849 732220 732264 733217 733227 733271 733282 733307 733337 733342 734049 734283 734664 736011 739940 739969 744158 744159 746044 751799 763966 772355 773621 781962 783799 790388 793565 794196 794632 794676 796307 796466 800054 802039 802290 803918 804233 804463 809907 810057 812116 814376 814404 814727 817800 818408 823689 823754 824077 824790 824892 824893 824906 824952 825055 826059 826435 826620 826651 826773 826894 827155 827577 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза волосатая pussy"
]
|
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.