Query Metrics
7
Database Queries
7
Different statements
197.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.35 ms (87.17%) |
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 392994 399908 402648 415311 417272 417560 418852 421137 427714 432487 434488 435412 436862 439257 441092 441159 445717 448057 448304 449502 449517 449940 450015 450038 451082 452743 456817 459641 459648 461306 462223 469716 475173 475816 476475 481121 486136 490965 494313 494894 495747 499083 500313 500332 514483 521145 522188 522196 524839 527380 532727 538537 541322 547593 553441 564557 565004 568493 576785 577018 583510 587587 588879 594282 596402 597519 603294 604226 604229 625960 630239 633241 634029 639184 648444 648669 655159 657543 658787 661991 662090 674475 677240 687844 690066 692127 692817 696250 703945 706765 707867 712433 713240 721249 721875 727844 735772 759005 759795 766716 767416 767758 767786 776327 777882 782539 784732 784743 784770 786088 787506 789771 790632 798243 803504 803827 812073 813009 813189 813369 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.80%) |
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 813369 784770 767416 415311 399908 481121 441159 521145 522188 514483 494313 583510 662090 655159 661991 633241 759005 604229 500313 449517 452743 648669 713240 784743 475816 436862 449502 445717 786088 735772 703945 803504 812073 475173 418852 456817 486136 798243 594282 596402 392994 417272 499083 597519 790632 813009 727844 782539 767758 759795 784732 450038 538537 565004 706765 625960 604226 449940 417560 532727 459641 469716 527380 674475 696250 648444 687844 658787 564557 587587 588879 789771 766716 721875 776327 494894 690066 434488 441092 495747 630239 432487 448304 522196 707867 777882 803827 767786 639184 787506 813189 439257 476475 490965 677240 692817 692127 657543 603294 634029 435412 500332 427714 459648 547593 541322 576785 421137 524839 402648 448057 451082 461306 450015 462223 553441 577018 568493 712433 721249 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.42%) |
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 392994 399908 402648 415311 417272 417560 418852 421137 427714 432487 434488 435412 436862 439257 441092 441159 445717 448057 448304 449502 449517 449940 450015 450038 451082 452743 456817 459641 459648 461306 462223 469716 475173 475816 476475 481121 486136 490965 494313 494894 495747 499083 500313 500332 514483 521145 522188 522196 524839 527380 532727 538537 541322 547593 553441 564557 565004 568493 576785 577018 583510 587587 588879 594282 596402 597519 603294 604226 604229 625960 630239 633241 634029 639184 648444 648669 655159 657543 658787 661991 662090 674475 677240 687844 690066 692127 692817 696250 703945 706765 707867 712433 713240 721249 721875 727844 735772 759005 759795 766716 767416 767758 767786 776327 777882 782539 784732 784743 784770 786088 787506 789771 790632 798243 803504 803827 812073 813009 813189 813369 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen orgasm"
]
|
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.