Query Metrics
7
Database Queries
7
Different statements
175.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.23 ms (86.88%) |
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 16913 39322 79898 309234 338997 388031 394136 399936 402771 413417 422420 437994 440533 471925 523809 555162 557809 557811 620750 641227 667064 684379 697727 701255 701276 701661 702240 702629 705050 706542 707473 710822 710979 712359 714138 717123 717922 719130 719638 720083 722189 723521 726373 728853 729342 729842 734077 735307 738314 739543 740231 741672 742590 742761 743348 743775 744439 746637 748429 754253 755049 761426 761998 762529 763108 763474 763518 763573 763634 764581 765100 765386 765389 765410 766293 767358 767393 768040 768190 768560 771357 772276 773374 773757 774058 774162 775075 777612 779075 779085 779089 779619 779812 781013 781082 781482 782638 782764 786577 787888 793498 794146 794792 797931 802012 802685 806574 810161 811919 816152 817102 817209 818099 819876 825074 825384 826482 826685 827144 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (7.09%) |
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 766431 774162 738314 741672 742590 742761 761998 763474 768190 771357 726373 728853 729342 729842 744439 755049 761426 762529 765386 765389 766293 767393 768560 772276 773757 734077 735307 743348 748429 763518 765410 767358 768040 773374 774058 620750 697727 701276 701661 706542 710979 717123 717922 719130 719638 722189 777612 779085 779619 779812 781013 781082 781482 786577 787888 793498 794792 802012 802685 402771 440533 422420 79898 471925 667064 705050 701255 714138 710822 720083 779075 782638 797931 811919 739543 765100 740231 754253 743775 641227 702629 779089 806574 399936 437994 16913 723521 555162 557811 684379 702240 707473 775075 794146 782764 763573 810161 746637 763108 763634 764581 712359 413417 557809 523809 394136 309234 338997 39322 388031 817209 825384 826482 826685 818099 819876 825074 827144 816152 817102 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.95%) |
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 16913 39322 79898 309234 338997 388031 394136 399936 402771 413417 422420 437994 440533 471925 523809 555162 557809 557811 620750 641227 667064 684379 697727 701255 701276 701661 702240 702629 705050 706542 707473 710822 710979 712359 714138 717123 717922 719130 719638 720083 722189 723521 726373 728853 729342 729842 734077 735307 738314 739543 740231 741672 742590 742761 743348 743775 744439 746637 748429 754253 755049 761426 761998 762529 763108 763474 763518 763573 763634 764581 765100 765386 765389 765410 766293 767358 767393 768040 768190 768560 771357 772276 773374 773757 774058 774162 775075 777612 779075 779085 779089 779619 779812 781013 781082 781482 782638 782764 786577 787888 793498 794146 794792 797931 802012 802685 806574 810161 811919 816152 817102 817209 818099 819876 825074 825384 826482 826685 827144 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth sperm"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth сперм"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth сперм"
]
|
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.