Query Metrics
7
Database Queries
7
Different statements
249.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.63 ms (89.33%) |
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 12775 145988 373905 384758 385389 387522 389891 390388 395839 396218 396592 397352 397780 404318 404778 404831 405123 408207 408245 409165 411700 415148 419220 420530 428224 428476 428571 434070 441320 441864 445340 445661 448829 449060 449425 450371 450455 450965 451849 452080 452834 457480 457947 459226 460317 462911 464601 465302 468849 469084 469294 469540 472208 473223 474593 478480 482231 484298 487414 494927 501551 511856 512818 517007 544639 559139 583485 585726 586917 604489 605256 612816 622991 649833 660422 671389 674688 681515 682208 697298 699026 706930 706935 707472 709594 716321 716986 720117 720397 731245 733317 738528 751503 766613 769291 770514 788248 789516 799692 802357 805439 809133 814910 815054 815241 815287 815778 817054 818867 819230 820686 820953 821068 821476 821599 821716 823136 823322 823341 826117 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (6.13%) |
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 145988 389891 396218 605256 457947 788248 441864 697298 821599 12775 473223 450455 494927 819230 464601 544639 384758 815241 820686 583485 699026 511856 405123 428571 462911 460317 707472 799692 731245 397352 818867 817054 823136 512818 487414 733317 459226 709594 469540 766613 451849 660422 805439 585726 649833 457480 681515 385389 823341 671389 586917 408207 409165 821716 420530 821476 449060 441320 468849 469084 465302 720397 682208 706930 809133 720117 434070 373905 397780 404831 674688 559139 769291 404778 404318 823322 826117 622991 387522 815054 482231 612816 751503 738528 716321 445661 450965 484298 415148 449425 448829 395839 821068 814910 815287 770514 706935 716986 452080 452834 428224 445340 802357 815778 820953 517007 789516 419220 428476 501551 472208 396592 408245 450371 604489 411700 478480 390388 469294 474593 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.28%) |
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 12775 145988 373905 384758 385389 387522 389891 390388 395839 396218 396592 397352 397780 404318 404778 404831 405123 408207 408245 409165 411700 415148 419220 420530 428224 428476 428571 434070 441320 441864 445340 445661 448829 449060 449425 450371 450455 450965 451849 452080 452834 457480 457947 459226 460317 462911 464601 465302 468849 469084 469294 469540 472208 473223 474593 478480 482231 484298 487414 494927 501551 511856 512818 517007 544639 559139 583485 585726 586917 604489 605256 612816 622991 649833 660422 671389 674688 681515 682208 697298 699026 706930 706935 707472 709594 716321 716986 720117 720397 731245 733317 738528 751503 766613 769291 770514 788248 789516 799692 802357 805439 809133 814910 815054 815241 815287 815778 817054 818867 819230 820686 820953 821068 821476 821599 821716 823136 823322 823341 826117 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina hairy anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская волосатая анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.