Query Metrics
7
Database Queries
7
Different statements
159.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.72 ms (86.73%) |
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 6874 89199 394630 400614 412141 419819 426117 433206 444338 445011 446874 463839 467885 478463 483615 492286 504672 529638 530698 534590 536624 538870 539030 541099 541328 541860 542624 542701 542881 544417 544844 544852 546813 547417 547432 547465 547472 547476 547488 547496 548153 554817 560639 564593 568500 570705 571357 572020 575589 576142 578325 580588 581467 588843 591003 593167 596638 597499 597502 598712 599046 604227 614880 622318 622400 623201 633440 639804 639819 642362 647634 653209 660373 662024 662200 666875 668449 669056 670366 671038 672927 672937 672945 672952 683296 685789 693291 704212 707102 713927 718647 727843 728745 734922 735112 736356 743029 743111 753503 756822 759333 759796 761740 766669 769837 769895 777077 777120 779193 782087 790203 800799 801918 804230 806044 810032 818291 818322 825557 826849 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (7.44%) |
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 633440 782087 668449 445011 542881 89199 394630 810032 707102 542624 639819 735112 825557 666875 713927 446874 547496 777120 547472 734922 779193 534590 547465 541328 672952 671038 804230 759333 536624 568500 736356 759796 426117 670366 433206 728745 547432 766669 467885 575589 548153 669056 769837 504672 693291 547488 530698 539030 572020 672937 769895 753503 777077 806044 544852 538870 761740 653209 547476 580588 672927 660373 718647 591003 704212 483615 541099 639804 542701 599046 743029 6874 478463 570705 604227 818322 623201 800799 614880 400614 544417 546813 547417 581467 578325 672945 685789 662200 576142 588843 642362 801918 743111 492286 597502 419819 544844 541860 622400 593167 554817 598712 560639 596638 463839 444338 826849 529638 571357 683296 647634 597499 622318 727843 756822 790203 564593 818291 662024 412141 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.44%) |
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 6874 89199 394630 400614 412141 419819 426117 433206 444338 445011 446874 463839 467885 478463 483615 492286 504672 529638 530698 534590 536624 538870 539030 541099 541328 541860 542624 542701 542881 544417 544844 544852 546813 547417 547432 547465 547472 547476 547488 547496 548153 554817 560639 564593 568500 570705 571357 572020 575589 576142 578325 580588 581467 588843 591003 593167 596638 597499 597502 598712 599046 604227 614880 622318 622400 623201 633440 639804 639819 642362 647634 653209 660373 662024 662200 666875 668449 669056 670366 671038 672927 672937 672945 672952 683296 685789 693291 704212 707102 713927 718647 727843 728745 734922 735112 736356 743029 743111 753503 756822 759333 759796 761740 766669 769837 769895 777077 777120 779193 782087 790203 800799 801918 804230 806044 810032 818291 818322 825557 826849 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal gape"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.97%) |
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.