Query Metrics
7
Database Queries
7
Different statements
200.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.49 ms (86.51%) |
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 98843 231375 273080 298572 382897 384783 390253 398433 419666 458376 461962 464055 466804 469068 471904 485230 511937 513258 516373 522641 524842 524942 526567 526989 528943 529047 530195 531032 531652 533132 533142 533484 534734 537466 538781 539262 542769 547339 548271 549374 549519 550306 552020 553164 553413 554068 556549 562717 563918 564769 567793 568607 571729 572773 577219 579466 581514 584800 585589 586349 590110 592035 596306 597118 597205 599656 600908 602301 603333 604422 605073 606795 606921 609228 615572 624354 628466 632859 643699 646801 652974 658690 659585 663020 666604 673045 698932 704288 730687 733384 733400 735928 743281 744220 751395 752992 753994 754552 754657 758944 768823 774039 777153 778381 783188 783295 786777 787245 794054 811601 812240 812246 812248 814199 816866 818535 818752 823241 825726 825856 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (7.36%) |
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 754552 783295 786777 398433 231375 419666 485230 516373 529047 511937 522641 524842 524942 533132 564769 579466 549519 568607 571729 554068 567793 652974 550306 552020 577219 581514 602301 596306 597205 599656 609228 461962 513258 98843 823241 825726 814199 818535 818752 825856 537466 531032 531652 666604 646801 663020 673045 698932 658690 606795 624354 628466 643699 592035 615572 787245 812240 812246 812248 733384 733400 758944 768823 774039 730687 735928 743281 754657 752992 704288 778381 783188 794054 811601 273080 384783 298572 458376 466804 464055 526567 533142 539262 534734 538781 526989 530195 533484 469068 547339 563918 542769 549374 562717 548271 553413 572773 584800 553164 556549 600908 603333 604422 606921 632859 585589 586349 590110 597118 744220 605073 390253 382897 816866 528943 471904 659585 777153 753994 751395 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.70%) |
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 98843 231375 273080 298572 382897 384783 390253 398433 419666 458376 461962 464055 466804 469068 471904 485230 511937 513258 516373 522641 524842 524942 526567 526989 528943 529047 530195 531032 531652 533132 533142 533484 534734 537466 538781 539262 542769 547339 548271 549374 549519 550306 552020 553164 553413 554068 556549 562717 563918 564769 567793 568607 571729 572773 577219 579466 581514 584800 585589 586349 590110 592035 596306 597118 597205 599656 600908 602301 603333 604422 605073 606795 606921 609228 615572 624354 628466 632859 643699 646801 652974 658690 659585 663020 666604 673045 698932 704288 730687 733384 733400 735928 743281 744220 751395 752992 753994 754552 754657 758944 768823 774039 777153 778381 783188 783295 786777 787245 794054 811601 812240 812246 812248 814199 816866 818535 818752 823241 825726 825856 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic girl"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик девушк"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.