Query Metrics
7
Database Queries
7
Different statements
148.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.79 ms (83.47%) |
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 30791 88614 248347 392937 394514 415977 416293 438478 438655 440706 450302 455591 458203 458757 465481 465482 466402 467560 468228 471082 472181 478521 495879 499587 502823 513602 517238 520911 525890 529692 531370 535985 540568 541795 546316 546972 547007 547416 547684 549031 554977 555131 555315 555963 556543 557295 558623 560028 563628 565082 570940 571708 574050 575279 576540 576599 578148 584481 586167 586199 587787 593798 595166 596194 596845 596968 601872 607118 613158 620754 629731 633092 633716 640859 649363 662897 664535 678780 699534 700830 700907 707236 710224 710465 710564 714399 715413 718036 733415 738694 740569 752194 759132 761944 766450 778866 781928 784005 791033 794019 797336 801799 801810 804448 804614 811215 812751 813791 813963 819349 819810 823890 823990 824000 824103 824563 824663 827182 827297 827627 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (9.80%) |
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 781928 784005 791033 804448 478521 517238 472181 30791 557295 794019 811215 797336 801799 450302 804614 620754 394514 438655 416293 415977 438478 468228 471082 455591 465482 495879 546316 570940 571708 574050 546972 554977 555131 664535 578148 586167 596968 629731 586199 607118 778866 759132 812751 733415 640859 440706 458757 248347 465481 466402 502823 392937 88614 824103 824663 827627 813791 823890 824000 458203 513602 560028 565082 547007 547416 547684 549031 563628 541795 555315 576540 576599 700907 714399 700830 707236 710465 715413 718036 649363 678780 710224 556543 558623 593798 596194 595166 587787 613158 601872 752194 761944 740569 766450 738694 633092 633716 801810 499587 584481 662897 555963 575279 596845 467560 529692 699534 710564 525890 520911 813963 823990 819810 827182 827297 819349 824563 535985 531370 540568 ] |
||||||||||||||||||||||||||||||
|
2.76 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 30791 88614 248347 392937 394514 415977 416293 438478 438655 440706 450302 455591 458203 458757 465481 465482 466402 467560 468228 471082 472181 478521 495879 499587 502823 513602 517238 520911 525890 529692 531370 535985 540568 541795 546316 546972 547007 547416 547684 549031 554977 555131 555315 555963 556543 557295 558623 560028 563628 565082 570940 571708 574050 575279 576540 576599 578148 584481 586167 586199 587787 593798 595166 596194 596845 596968 601872 607118 613158 620754 629731 633092 633716 640859 649363 662897 664535 678780 699534 700830 700907 707236 710224 710465 710564 714399 715413 718036 733415 738694 740569 752194 759132 761944 766450 778866 781928 784005 791033 794019 797336 801799 801810 804448 804614 811215 812751 813791 813963 819349 819810 823890 823990 824000 824103 824563 824663 827182 827297 827627 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf ван"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf ван"
]
|
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.