Query Metrics
7
Database Queries
7
Different statements
180.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.61 ms (86.83%) |
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 528329 542746 545477 546223 582017 582121 587441 588464 590639 602342 605729 608818 615686 616630 617587 617606 625241 636936 645520 653698 658202 662042 662052 679500 679501 684469 686210 693801 693804 695737 698228 701604 701916 702512 702992 703603 708130 709189 709217 709586 710346 710462 710838 713735 715041 717157 718307 719207 721042 721968 726390 730149 731609 736483 739841 740544 740577 743799 746555 748287 749721 751427 755521 756797 760252 761716 764266 769550 769800 770292 770523 770958 771045 771654 771995 772383 772444 772788 773771 773797 774701 775274 776582 776960 777019 777316 779757 779951 780745 781056 783839 784885 785316 786480 787442 787926 789229 789600 790928 791227 791322 792188 795125 795887 797006 797592 797933 798327 804329 809258 810781 811528 812680 813192 814397 820187 824810 825499 827106 827706 ] |
||||||||||||||||||||||||||||||
|
13.65 ms (7.57%) |
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 769800 770958 771654 772383 726390 736483 739841 743799 746555 749721 751427 755521 760252 764266 769550 770523 771045 771995 772444 773797 730149 731609 740544 740577 748287 756797 761716 770292 772788 773771 608818 615686 617587 701604 709189 709217 709586 710346 718307 774701 775274 776960 779757 779951 783839 786480 787442 787926 789229 791227 791322 792188 795125 795887 797006 798327 804329 809258 811528 813192 528329 542746 814397 824810 827106 827706 820187 825499 545477 582017 645520 662042 679500 686210 701916 713735 721968 653698 658202 684469 693801 698228 702512 719207 662052 679501 693804 695737 702992 703603 708130 710462 710838 715041 717157 721042 546223 582121 590639 602342 588464 616630 617606 636936 587441 605729 625241 780745 781056 784885 785316 789600 790928 797592 797933 810781 812680 776582 777019 777316 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.86%) |
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 528329 542746 545477 546223 582017 582121 587441 588464 590639 602342 605729 608818 615686 616630 617587 617606 625241 636936 645520 653698 658202 662042 662052 679500 679501 684469 686210 693801 693804 695737 698228 701604 701916 702512 702992 703603 708130 709189 709217 709586 710346 710462 710838 713735 715041 717157 718307 719207 721042 721968 726390 730149 731609 736483 739841 740544 740577 743799 746555 748287 749721 751427 755521 756797 760252 761716 764266 769550 769800 770292 770523 770958 771045 771654 771995 772383 772444 772788 773771 773797 774701 775274 776582 776960 777019 777316 779757 779951 780745 781056 783839 784885 785316 786480 787442 787926 789229 789600 790928 791227 791322 792188 795125 795887 797006 797592 797933 798327 804329 809258 810781 811528 812680 813192 814397 820187 824810 825499 827106 827706 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans cum"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
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.