Query Metrics
7
Database Queries
7
Different statements
202.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.47 ms (85.71%) |
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 51911 154374 183506 248347 382304 384108 388642 390204 391916 394648 399028 411211 412830 413673 419824 426550 428711 432299 441067 441853 448115 448354 449377 455793 459331 460208 462840 463840 467939 468072 470412 471081 474126 475947 476671 477055 480502 490232 493763 493838 500787 508150 508891 514235 514706 516050 520797 529713 529714 530005 531524 531844 534372 534536 534560 536393 537864 538879 540945 541277 541317 541392 541851 541863 543871 544843 544848 545372 545395 547477 555024 555056 556044 559377 563444 564293 569150 583085 583713 590370 599865 601585 611164 620648 628104 648820 656626 656925 664166 669025 670366 676016 685701 695866 713508 724309 737578 745111 749064 749255 749264 751727 752612 752613 752642 752668 752669 753614 757350 758771 761752 770402 778172 780684 796905 799362 802899 803687 809371 827489 ] |
||||||||||||||||||||||||||||||
|
18.49 ms (9.14%) |
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 799362 183506 391916 493838 669025 428711 534372 537864 648820 544843 384108 411211 476671 555056 555024 559377 620648 758771 802899 419824 448354 470412 543871 556044 541851 656925 462840 656626 508150 676016 455793 685701 545372 599865 752668 390204 670366 770402 432299 463840 474126 516050 563444 583085 426550 471081 460208 514706 388642 467939 531524 530005 154374 394648 382304 413673 490232 449377 493763 531844 500787 477055 541277 544848 541392 564293 545395 547477 583713 664166 713508 761752 724309 751727 757350 796905 51911 475947 248347 412830 827489 459331 480502 448115 529713 534536 529714 534560 538879 569150 540945 541317 695866 590370 628104 780684 778172 803687 749064 749264 745111 752612 752669 753614 737578 749255 752613 752642 611164 809371 399028 508891 601585 468072 520797 541863 441853 441067 536393 514235 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.50%) |
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 51911 154374 183506 248347 382304 384108 388642 390204 391916 394648 399028 411211 412830 413673 419824 426550 428711 432299 441067 441853 448115 448354 449377 455793 459331 460208 462840 463840 467939 468072 470412 471081 474126 475947 476671 477055 480502 490232 493763 493838 500787 508150 508891 514235 514706 516050 520797 529713 529714 530005 531524 531844 534372 534536 534560 536393 537864 538879 540945 541277 541317 541392 541851 541863 543871 544843 544848 545372 545395 547477 555024 555056 556044 559377 563444 564293 569150 583085 583713 590370 599865 601585 611164 620648 628104 648820 656626 656925 664166 669025 670366 676016 685701 695866 713508 724309 737578 745111 749064 749255 749264 751727 752612 752613 752642 752668 752669 753614 757350 758771 761752 770402 778172 780684 796905 799362 802899 803687 809371 827489 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fisting"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал фистинг"
]
|
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.