Query Metrics
7
Database Queries
7
Different statements
158.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.35 ms (83.74%) |
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 382578 403215 426510 427716 441080 441849 456244 458379 460860 462377 464727 497667 509919 514240 535411 538854 539319 541575 542425 542434 542724 545982 546993 547805 547815 548422 550864 553674 554826 554998 555055 555154 555784 562049 567277 567457 567725 568777 570735 571135 574369 578642 578718 579707 580368 581929 582666 584539 584950 588202 588398 590716 592890 595699 597224 597873 598193 598658 599987 600438 600636 601655 606235 606317 607238 610012 612904 613644 614346 615602 615605 618177 618622 619091 619204 620395 623135 628332 628632 629967 630850 637245 637592 639060 641644 641778 647995 650109 659034 672761 673941 677892 681546 683054 685127 687960 692042 696202 704952 707557 716765 718745 718766 718782 725461 729251 749087 751567 752667 758797 763741 775212 786525 790193 795723 811466 812564 825762 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (9.65%) |
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 677892 685127 692042 704952 673941 681546 562049 574369 592890 600636 613644 615605 619091 630850 610012 615602 614346 619204 588202 597224 606235 790193 812564 751567 795723 725461 758797 752667 607238 403215 427716 382578 441080 441849 590716 672761 547815 729251 553674 775212 542724 426510 825762 568777 584950 555055 582666 542434 547805 548422 555784 578718 696202 716765 718766 659034 554998 578642 588398 600438 628632 606317 620395 637245 598658 786525 623135 509919 535411 595699 687960 641778 460860 458379 471695 542425 554826 567457 541575 567725 550864 581929 718745 647995 612904 597873 598193 749087 763741 718782 462377 456244 497667 464727 580368 579707 545982 567277 683054 650109 555154 571135 618622 811466 570735 514240 546993 601655 641644 637592 629967 538854 707557 539319 599987 639060 584539 628332 618177 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.76%) |
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 382578 403215 426510 427716 441080 441849 456244 458379 460860 462377 464727 497667 509919 514240 535411 538854 539319 541575 542425 542434 542724 545982 546993 547805 547815 548422 550864 553674 554826 554998 555055 555154 555784 562049 567277 567457 567725 568777 570735 571135 574369 578642 578718 579707 580368 581929 582666 584539 584950 588202 588398 590716 592890 595699 597224 597873 598193 598658 599987 600438 600636 601655 606235 606317 607238 610012 612904 613644 614346 615602 615605 618177 618622 619091 619204 620395 623135 628332 628632 629967 630850 637245 637592 639060 641644 641778 647995 650109 659034 672761 673941 677892 681546 683054 685127 687960 692042 696202 704952 707557 716765 718745 718766 718782 725461 729251 749087 751567 752667 758797 763741 775212 786525 790193 795723 811466 812564 825762 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pissing wife"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pissing жен"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pissing жен"
]
|
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.