Query Metrics
7
Database Queries
7
Different statements
293.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.31 ms (91.09%) |
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 205910 382803 384169 388740 396801 397158 397664 398383 409410 421762 423322 441570 444366 477793 483918 486632 490158 491128 501672 502999 510499 516565 519442 523061 535074 538451 544602 546698 562600 563876 564579 567005 567020 579528 580402 585346 585596 588472 592114 595231 602936 608125 610422 618494 620856 631768 638033 655193 659195 661593 664733 666041 677524 679858 682328 684012 685416 685907 687801 690568 702521 702889 702975 709661 710046 713872 722688 725200 727007 728855 729212 730970 735809 736738 738759 739792 741035 742260 743348 745809 749485 751083 757288 757567 759610 763298 763327 764560 765798 766036 767107 775209 775538 776785 779687 779973 780221 780925 783074 783617 784846 787619 787760 789801 795120 799786 800270 806866 807585 807685 808819 811244 813474 815995 816637 817200 817280 820106 824969 826609 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (4.91%) |
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 702889 655193 666041 687801 710046 588472 608125 610422 735809 811244 738759 743348 477793 501672 409410 787760 800270 729212 815995 620856 776785 789801 767107 728855 384169 544602 579528 779973 807685 727007 813474 741035 764560 519442 421762 816637 817280 491128 535074 538451 546698 661593 685907 592114 602936 618494 799786 808819 757288 787619 397664 483918 580402 567005 702521 631768 783617 730970 739792 759610 765798 783074 510499 516565 502999 490158 563876 679858 713872 664733 585596 784846 749485 745809 757567 742260 709661 779687 702975 780925 820106 685416 806866 780221 382803 486632 562600 684012 751083 775209 398383 397158 659195 677524 682328 585346 775538 725200 795120 766036 763298 763327 396801 423322 205910 444366 388740 441570 826609 824969 817200 523061 567020 690568 722688 564579 638033 595231 807585 736738 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (1.47%) |
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 205910 382803 384169 388740 396801 397158 397664 398383 409410 421762 423322 441570 444366 477793 483918 486632 490158 491128 501672 502999 510499 516565 519442 523061 535074 538451 544602 546698 562600 563876 564579 567005 567020 579528 580402 585346 585596 588472 592114 595231 602936 608125 610422 618494 620856 631768 638033 655193 659195 661593 664733 666041 677524 679858 682328 684012 685416 685907 687801 690568 702521 702889 702975 709661 710046 713872 722688 725200 727007 728855 729212 730970 735809 736738 738759 739792 741035 742260 743348 745809 749485 751083 757288 757567 759610 763298 763327 764560 765798 766036 767107 775209 775538 776785 779687 779973 780221 780925 783074 783617 784846 787619 787760 789801 795120 799786 800270 806866 807585 807685 808819 811244 813474 815995 816637 817200 817280 820106 824969 826609 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс daddy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex daddy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс daddy"
]
|
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.