Query Metrics
7
Database Queries
7
Different statements
161.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.77 ms (85.67%) |
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 393999 418858 432745 440749 440902 440947 441192 442463 445992 447044 451629 453905 459073 461306 461830 461867 462658 463636 464853 474783 477902 478146 482774 490976 493168 499735 501411 505538 509271 514444 517979 525867 532510 538484 549648 554516 554614 559005 562484 563052 565757 569067 571996 573222 575312 577125 577679 581418 586853 590532 594167 595114 598966 601741 603761 604384 608070 608512 610309 612254 620121 621172 622856 623216 627308 631117 634066 635578 635686 636951 640656 651702 668139 674292 674916 675494 678696 685843 693796 693806 700735 710066 713208 716383 718811 718864 725230 727330 729789 730819 732242 733167 739459 745565 759608 761650 761941 764179 778492 786048 787399 787843 788007 792021 793821 793997 794168 794416 794713 795262 796734 799350 800028 801094 801182 801737 802710 805653 812437 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (8.40%) |
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 514444 549648 674916 651702 693796 674292 685843 693806 635578 598966 801737 802710 792021 727330 730819 761650 787843 793997 800028 761941 725230 745565 764179 732242 621172 631117 787399 793821 393999 440947 445992 462658 509271 461867 718811 610309 778492 571996 716383 796734 441192 477902 675594 635686 794416 795262 595114 675494 634066 794713 729789 794168 710066 517979 442463 432745 464853 453905 461306 463636 532510 501411 554516 569067 562484 575312 581418 573222 577125 718864 713208 554614 563052 590532 640656 601741 604384 594167 627308 786048 799350 461830 418858 447044 505538 668139 620121 812437 805653 482774 474783 538484 622856 499735 577679 586853 612254 759608 739459 733167 440749 440902 451629 490976 459073 478146 493168 525867 559005 565757 700735 678696 608512 623216 603761 636951 608070 788007 801094 801182 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.57%) |
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 393999 418858 432745 440749 440902 440947 441192 442463 445992 447044 451629 453905 459073 461306 461830 461867 462658 463636 464853 474783 477902 478146 482774 490976 493168 499735 501411 505538 509271 514444 517979 525867 532510 538484 549648 554516 554614 559005 562484 563052 565757 569067 571996 573222 575312 577125 577679 581418 586853 590532 594167 595114 598966 601741 603761 604384 608070 608512 610309 612254 620121 621172 622856 623216 627308 631117 634066 635578 635686 636951 640656 651702 668139 674292 674916 675494 678696 685843 693796 693806 700735 710066 713208 716383 718811 718864 725230 727330 729789 730819 732242 733167 739459 745565 759608 761650 761941 764179 778492 786048 787399 787843 788007 792021 793821 793997 794168 794416 794713 795262 796734 799350 800028 801094 801182 801737 802710 805653 812437 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real жен сперм"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real wife sperm"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real жен сперм"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.