Query Metrics
7
Database Queries
7
Different statements
182.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.52 ms (85.92%) |
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 181420 391490 397664 398390 398660 403166 416391 419982 424264 427808 428044 431760 431761 439909 458357 459590 461816 466789 467781 472016 474216 480955 481461 482013 486327 493286 507269 522564 528201 536897 544757 548620 575052 587968 595470 609219 620513 621887 622191 625018 626193 630619 635259 636473 642617 645626 662140 663262 668764 669679 670700 671252 673860 674743 675628 679306 680846 682851 685805 687717 691878 696395 699899 701558 703977 710317 712226 712869 714208 716502 716641 719112 721978 723189 726173 726726 726881 727038 729934 730670 740966 743788 745609 748545 749756 749878 749943 761609 761818 764692 775171 778098 779162 779489 780795 782796 785185 785235 785435 785499 788932 789496 792690 794807 799446 800816 801260 802097 802670 802948 804537 804894 805350 805717 810031 810441 812958 813538 822721 827183 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (8.23%) |
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 575052 663262 670700 682851 687717 710317 685805 712226 674743 680846 716502 630619 642617 778098 775171 779162 782796 810441 726726 761818 805350 805717 726881 730670 726173 748545 761609 792690 800816 802097 802948 812958 428044 645626 595470 804894 719112 424264 459590 536897 716641 662140 669679 779489 813538 398390 522564 439909 544757 622191 789496 181420 668764 461816 431760 466789 528201 701558 703977 712869 679306 626193 727038 625018 785499 431761 482013 419982 481461 480955 493286 691878 671252 620513 745609 391490 403166 673860 486327 587968 474216 427808 827183 507269 723189 675628 714208 636473 609219 799446 801260 743788 749878 764692 749756 749943 810031 398660 467781 548620 472016 458357 804537 785435 397664 416391 822721 699899 721978 696395 621887 635259 780795 785235 788932 729934 740966 785185 794807 802670 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (2.17%) |
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 181420 391490 397664 398390 398660 403166 416391 419982 424264 427808 428044 431760 431761 439909 458357 459590 461816 466789 467781 472016 474216 480955 481461 482013 486327 493286 507269 522564 528201 536897 544757 548620 575052 587968 595470 609219 620513 621887 622191 625018 626193 630619 635259 636473 642617 645626 662140 663262 668764 669679 670700 671252 673860 674743 675628 679306 680846 682851 685805 687717 691878 696395 699899 701558 703977 710317 712226 712869 714208 716502 716641 719112 721978 723189 726173 726726 726881 727038 729934 730670 740966 743788 745609 748545 749756 749878 749943 761609 761818 764692 775171 778098 779162 779489 780795 782796 785185 785235 785435 785499 788932 789496 792690 794807 799446 800816 801260 802097 802670 802948 804537 804894 805350 805717 810031 810441 812958 813538 822721 827183 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.