Query Metrics
7
Database Queries
7
Different statements
177.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.41 ms (86.57%) |
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 68825 386701 401684 412721 419221 434900 495800 503745 508564 518785 521182 529661 529709 530118 533899 534007 538289 539470 540459 545288 548143 574741 578349 580027 584508 592245 592656 596954 597464 607508 609633 613498 614253 617596 621301 622579 623279 627794 633475 636071 660849 661055 661674 672272 675299 680542 681746 683011 699487 706727 708698 709838 710044 717653 719647 721003 721311 724130 724937 736971 738071 738104 738451 740243 741526 743208 745121 750361 750407 751283 751291 752229 752332 752835 753543 756781 757275 757483 758072 758093 758621 758806 759165 764282 767070 767209 772581 773678 773680 780332 780827 782141 783968 784651 787977 789371 791122 791725 793292 794066 794782 795602 795619 795760 799938 800595 803991 806114 806527 806551 811551 811620 811622 812031 812166 812584 814448 818535 824888 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (7.42%) |
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 578349 717653 545288 738071 633475 538289 683011 794066 780332 791122 738451 721311 752229 814448 680542 811622 508564 401684 521182 539470 533899 597464 773680 811551 759165 724130 787977 752332 795619 681746 757483 613498 800595 767209 592245 706727 713291 617596 621301 627794 623279 503745 719647 609633 622579 750407 758806 743208 756781 709838 799938 784651 518785 68825 540459 574741 661674 721003 636071 607508 780827 753543 758621 750361 758093 764282 803991 811620 812031 812166 795760 745121 773678 818535 672272 529661 675299 614253 782141 806114 812584 757275 783968 789371 794782 740243 724937 752835 767070 772581 738104 795602 710044 699487 386701 434900 495800 529709 758072 419221 660849 530118 791725 592656 736971 741526 751283 806527 534007 584508 806551 751291 793292 824888 596954 412721 580027 661055 548143 708698 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.73%) |
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 68825 386701 401684 412721 419221 434900 495800 503745 508564 518785 521182 529661 529709 530118 533899 534007 538289 539470 540459 545288 548143 574741 578349 580027 584508 592245 592656 596954 597464 607508 609633 613498 614253 617596 621301 622579 623279 627794 633475 636071 660849 661055 661674 672272 675299 680542 681746 683011 699487 706727 708698 709838 710044 717653 719647 721003 721311 724130 724937 736971 738071 738104 738451 740243 741526 743208 745121 750361 750407 751283 751291 752229 752332 752835 753543 756781 757275 757483 758072 758093 758621 758806 759165 764282 767070 767209 772581 773678 773680 780332 780827 782141 783968 784651 787977 789371 791122 791725 793292 794066 794782 795602 795619 795760 799938 800595 803991 806114 806527 806551 811551 811620 811622 812031 812166 812584 814448 818535 824888 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп девушк"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.