Query Metrics
7
Database Queries
7
Different statements
151.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.24 ms (79.85%) |
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 391976 392055 394031 404402 410799 418277 419324 420548 420865 433959 434541 437705 438055 460474 462284 464553 464572 477194 479110 482493 483946 485647 486973 491214 492500 498670 503462 506221 506483 514685 517835 521036 522347 522675 525296 529441 530161 532614 542439 545182 546660 552371 555075 555096 565884 567193 572675 575687 583408 586543 588365 590556 590998 591064 595308 600888 602487 605046 607481 612339 616103 617605 620238 625018 626120 626345 626713 630445 635801 636658 638181 644641 648018 648976 651408 653891 659346 668766 671679 674587 685131 691759 693331 695824 700828 700941 707483 709244 709655 710504 725687 726535 726686 731129 733545 739899 740805 741819 744818 747044 747543 750093 759722 768085 770563 771529 773022 773876 777316 781185 783256 785178 790508 791013 791134 794921 799818 800425 810176 826280 ] |
||||||||||||||||||||||||||||||
|
20.84 ms (13.72%) |
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 791013 791134 794921 777316 770563 785178 744818 773022 726535 726686 733545 747543 768085 741819 747044 759722 773876 731129 739899 740805 750093 771529 616103 620238 781185 783256 799818 391976 420548 410799 438055 477194 506221 529441 522347 648018 572675 625018 644641 525296 567193 607481 392055 404402 826280 491214 810176 485647 420865 486973 522675 530161 503462 517835 506483 521036 532614 575687 542439 545182 546660 552371 555096 565884 583408 668766 691759 700941 707483 648976 651408 653891 671679 674587 709655 588365 638181 595308 626120 630445 586543 612339 617605 626345 635801 600888 626713 636658 800425 725687 602487 709244 710504 418277 498670 394031 434541 419324 433959 437705 482493 464572 483946 492500 460474 514685 462284 464553 479110 685131 693331 700828 659346 695824 555075 590998 591064 590556 605046 790508 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.65%) |
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 391976 392055 394031 404402 410799 418277 419324 420548 420865 433959 434541 437705 438055 460474 462284 464553 464572 477194 479110 482493 483946 485647 486973 491214 492500 498670 503462 506221 506483 514685 517835 521036 522347 522675 525296 529441 530161 532614 542439 545182 546660 552371 555075 555096 565884 567193 572675 575687 583408 586543 588365 590556 590998 591064 595308 600888 602487 605046 607481 612339 616103 617605 620238 625018 626120 626345 626713 630445 635801 636658 638181 644641 648018 648976 651408 653891 659346 668766 671679 674587 685131 691759 693331 695824 700828 700941 707483 709244 709655 710504 725687 726535 726686 731129 733545 739899 740805 741819 744818 747044 747543 750093 759722 768085 770563 771529 773022 773876 777316 781185 783256 785178 790508 791013 791134 794921 799818 800425 810176 826280 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur suck"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск suck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск suck"
]
|
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.