Query Metrics
7
Database Queries
7
Different statements
403.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.97 ms (52.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking большой большие член"
]
|
||||||||||||||||||||||||||||||
|
169.87 ms (42.11%) |
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 210576 381927 394158 417173 437982 446868 450134 450152 455221 459393 459937 460722 464860 469362 472423 478765 480033 480175 480248 485492 491317 491377 492640 495968 498116 499327 499517 503018 509530 513766 515303 516497 519766 522615 523593 524321 530254 531264 532559 534476 534589 535272 535801 540442 541530 542608 550062 552070 554616 560910 567568 574487 583400 587829 588083 589636 595104 597978 599049 611435 617174 621700 621775 636750 637294 645048 649740 650294 659284 660090 662370 673880 675168 682882 686586 688532 692481 697631 703352 704918 707619 708909 714218 715846 722843 723288 731200 736787 740524 741877 743342 743802 744596 746488 747866 748026 748399 752414 759512 759736 761040 761997 762529 763054 763332 764647 771281 774483 779443 782319 784151 786353 787888 809256 810599 810914 814237 815343 815698 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (3.25%) |
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 763332 771281 741877 748399 746488 762529 763054 617174 697631 703352 503018 534589 450152 513766 809256 784151 522615 495968 381927 491317 480248 524321 532559 659284 662370 588083 810914 743342 394158 530254 480033 519766 534476 540442 478765 472423 446868 509530 708909 761040 460722 492640 499517 649740 688532 611435 743802 450134 459393 542608 722843 464860 455221 498116 523593 480175 541530 814237 515303 704918 660090 664379 673880 567568 637294 589636 636750 774483 761997 759736 764647 779443 782319 210576 469362 535801 459937 645048 682882 554616 736787 752414 437982 417173 499327 491377 531264 550062 583400 723288 707619 714218 595104 597978 621700 621775 587829 599049 731200 786353 747866 748026 740524 759512 787888 516497 485492 535272 552070 686586 810599 744596 815698 815343 560910 574487 650294 715846 675168 692481 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (0.74%) |
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 210576 381927 394158 417173 437982 446868 450134 450152 455221 459393 459937 460722 464860 469362 472423 478765 480033 480175 480248 485492 491317 491377 492640 495968 498116 499327 499517 503018 509530 513766 515303 516497 519766 522615 523593 524321 530254 531264 532559 534476 534589 535272 535801 540442 541530 542608 550062 552070 554616 560910 567568 574487 583400 587829 588083 589636 595104 597978 599049 611435 617174 621700 621775 636750 637294 645048 649740 650294 659284 660090 662370 673880 675168 682882 686586 688532 692481 697631 703352 704918 707619 708909 714218 715846 722843 723288 731200 736787 740524 741877 743342 743802 744596 746488 747866 748026 748399 752414 759512 759736 761040 761997 762529 763054 763332 764647 771281 774483 779443 782319 784151 786353 787888 809256 810599 810914 814237 815343 815698 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking big dick"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking большой большие член"
]
|
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.