Query Metrics
7
Database Queries
7
Different statements
193.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.22 ms (86.90%) |
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 402929 427738 431759 432991 437784 440943 441629 444267 445998 448069 448074 453290 455881 457226 457595 457773 458344 459513 459557 460565 463565 469797 475195 481461 485847 487465 487472 488867 493017 493340 495302 497062 497834 501397 504000 505449 505622 506209 506231 506232 510608 513426 517118 520823 522208 523231 524068 524180 524359 524669 525460 525555 526308 527066 527687 527839 528931 536176 541479 542567 543133 545914 547877 550292 550688 554895 556839 557941 558983 564656 567505 568696 569261 582060 582342 588592 601444 602633 603977 605688 605855 606069 608688 611181 617025 618982 626127 626206 626381 628354 639172 652968 653096 662395 669399 670742 676591 679818 699604 701609 707464 716915 723945 723955 724045 724456 732905 742873 746497 761519 769490 770882 780760 788720 794947 798053 802091 822365 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.96%) |
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 788720 798053 802091 742873 761519 432991 481461 524180 506209 524359 510608 402929 485847 536176 505449 506231 746497 697943 458344 469797 526308 453290 568696 652968 628354 639172 611181 427738 497834 582342 504000 437784 569261 582060 669399 602633 822365 701609 653096 707464 780760 770882 522208 723955 724045 724456 723945 699604 459513 513426 676591 497062 487472 448069 550688 440943 527687 524669 524068 550292 457226 493340 457773 487465 606069 459557 527839 493017 441629 523231 525460 670742 445998 505622 501397 554895 547877 605855 626127 605688 794947 618982 520823 557941 545914 564656 588592 603977 732905 769490 697939 506232 463565 542567 608688 517118 444267 488867 457595 541479 601444 716915 431759 448074 475195 495302 679818 558983 626206 626381 525555 527066 460565 543133 567505 662395 556839 617025 455881 528931 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.40%) |
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 402929 427738 431759 432991 437784 440943 441629 444267 445998 448069 448074 453290 455881 457226 457595 457773 458344 459513 459557 460565 463565 469797 475195 481461 485847 487465 487472 488867 493017 493340 495302 497062 497834 501397 504000 505449 505622 506209 506231 506232 510608 513426 517118 520823 522208 523231 524068 524180 524359 524669 525460 525555 526308 527066 527687 527839 528931 536176 541479 542567 543133 545914 547877 550292 550688 554895 556839 557941 558983 564656 567505 568696 569261 582060 582342 588592 601444 602633 603977 605688 605855 606069 608688 611181 617025 618982 626127 626206 626381 628354 639172 652968 653096 662395 669399 670742 676591 679818 699604 701609 707464 716915 723945 723955 724045 724456 732905 742873 746497 761519 769490 770882 780760 788720 794947 798053 802091 822365 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home handjob"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home дрочк член"
]
|
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.