Query Metrics
7
Database Queries
7
Different statements
158.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.52 ms (83.99%) |
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 192814 253445 345303 366036 382692 384480 386611 389858 390624 393016 396396 397026 398421 398564 398747 400684 404404 409077 415736 424192 450950 453921 454506 455197 459105 460586 466104 478350 512030 513816 514875 519899 525182 526136 527347 531632 533190 534355 535082 536753 538044 553263 553831 558309 561181 567500 575897 581482 584342 591277 591496 591971 595540 605923 613593 625462 627738 634275 637481 639912 648422 652300 656514 659210 660061 660336 662839 663237 665451 666832 667179 667757 668100 671497 673209 675203 676759 677136 677557 695547 697458 701047 701581 710224 717660 717955 718071 720356 726038 726338 726899 728253 728832 730645 730780 733061 734097 734212 735448 739207 753565 753613 753620 754660 754852 756461 763042 763879 764395 766179 768570 778667 780882 792679 793764 794475 797476 804779 814717 827878 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (9.49%) |
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 804779 726338 730645 734097 734212 753565 756461 726899 730780 735448 739207 763042 753620 754660 754852 766179 768570 728832 753613 763879 764395 717660 778667 780882 792679 793764 797476 366036 398421 396396 398747 345303 384480 386611 253445 794475 733061 398564 409077 814717 535082 558309 634275 726038 728253 192814 666832 665451 455197 400684 450950 459105 453921 460586 531632 513816 667757 591277 389858 390624 466104 512030 527347 393016 382692 397026 404404 424192 415736 827878 454506 525182 526136 519899 536753 533190 534355 538044 514875 478350 553263 561181 575897 581482 553831 567500 659210 660061 660336 662839 663237 675203 676759 677136 677557 717955 673209 695547 701581 720356 648422 652300 656514 667179 668100 671497 697458 701047 710224 718071 584342 605923 625462 637481 591496 591971 639912 613593 627738 595540 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.81%) |
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 192814 253445 345303 366036 382692 384480 386611 389858 390624 393016 396396 397026 398421 398564 398747 400684 404404 409077 415736 424192 450950 453921 454506 455197 459105 460586 466104 478350 512030 513816 514875 519899 525182 526136 527347 531632 533190 534355 535082 536753 538044 553263 553831 558309 561181 567500 575897 581482 584342 591277 591496 591971 595540 605923 613593 625462 627738 634275 637481 639912 648422 652300 656514 659210 660061 660336 662839 663237 665451 666832 667179 667757 668100 671497 673209 675203 676759 677136 677557 695547 697458 701047 701581 710224 717660 717955 718071 720356 726038 726338 726899 728253 728832 730645 730780 733061 734097 734212 735448 739207 753565 753613 753620 754660 754852 756461 763042 763879 764395 766179 768570 778667 780882 792679 793764 794475 797476 804779 814717 827878 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde wife"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.