Query Metrics
7
Database Queries
7
Different statements
901.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
638.55 ms (70.85%) |
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 511005 496240 577340 415988 545438 548941 623277 600958 608669 744047 749264 609887 788899 468146 395284 414104 468946 511274 526504 514868 468219 680242 680816 590803 752620 429886 519712 552706 159380 444485 88476 505137 389794 416470 776035 438880 452800 467634 448791 534574 459198 824630 821781 443247 415749 452953 705451 564501 782836 749084 756776 765684 408885 451121 486773 468949 511893 669067 800442 811690 752704 441042 471122 475431 541421 711591 656891 643226 806815 807173 774878 740908 808796 739113 758777 752613 644510 812058 439031 512442 530953 532530 534772 564310 671043 709674 722395 660412 671045 545439 597691 608550 638744 598141 625227 752683 807590 808265 752632 766415 739131 739145 738496 751546 752633 752767 765712 443233 480450 509168 555714 648455 678974 515488 543061 415303 416561 416669 476674 561228 ] |
||||||||||||||||||||||||||||||
|
251.72 ms (27.93%) |
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 88476 159380 389794 395284 408885 414104 415303 415749 415988 416470 416561 416669 429886 438880 439031 441042 443233 443247 444485 448791 451121 452800 452953 459198 467634 468146 468219 468946 468949 471122 475431 476674 480450 486773 496240 505137 509168 511005 511274 511893 512442 514868 515488 519712 526504 530953 532530 534574 534772 541421 543061 545438 545439 548941 552706 555714 561228 564501 577340 590803 597691 598141 600958 608550 608669 609887 623277 625227 638744 643226 644510 648455 656891 660412 669067 671043 671045 678974 680242 680816 705451 709674 711591 722395 738496 739113 739131 739145 740908 744047 749084 749264 751546 752613 752620 752632 752633 752683 752704 752767 756776 758777 765684 765712 766415 774878 776035 782836 788899 800442 806815 807173 807590 808265 808796 811690 812058 821781 824630 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.33%) |
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 88476 159380 389794 395284 408885 414104 415303 415749 415988 416470 416561 416669 429886 438880 439031 441042 443233 443247 444485 448791 451121 452800 452953 459198 467634 468146 468219 468946 468949 471122 475431 476674 480450 486773 496240 505137 509168 511005 511274 511893 512442 514868 515488 519712 526504 530953 532530 534574 534772 541421 543061 545438 545439 548941 552706 555714 561228 564501 577340 590803 597691 598141 600958 608550 608669 609887 623277 625227 638744 643226 644510 648455 656891 660412 669067 671043 671045 678974 680242 680816 705451 709674 711591 722395 738496 739113 739131 739145 740908 744047 749084 749264 751546 752613 752620 752632 752633 752683 752704 752767 756776 758777 765684 765712 766415 774878 776035 782836 788899 800442 806815 807173 807590 808265 808796 811690 812058 821781 824630 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam dildo ass"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер дилд жоп"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер дилд жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.20%) |
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.