Query Metrics
7
Database Queries
7
Different statements
174.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.18 ms (85.90%) |
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 498554 503705 517661 541043 544033 550968 551506 552713 554693 556023 558590 559334 565702 575025 576471 577034 578171 581392 581930 583727 584830 589545 596372 602387 611260 616846 616887 622869 626731 627077 629643 631298 636496 642144 646074 647111 648931 655452 657234 658931 659429 660572 665076 667257 668814 669320 669858 671559 671693 676673 680593 680597 681513 689057 689871 689902 689981 692695 692703 693267 693695 694637 695549 696347 697668 698911 702639 702914 703022 704629 706679 710092 710802 718036 719422 720356 720507 721149 722237 725192 729193 729322 729634 736155 737868 775646 775656 777046 778155 780325 780333 780368 781099 781245 783006 783602 783651 784883 785113 785366 785367 786366 786909 788057 792132 796191 797032 797083 798287 800041 800044 800116 801536 801605 803396 806821 806991 811388 811429 ] |
||||||||||||||||||||||||||||||
|
12.94 ms (7.40%) |
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 498554 503705 517661 544033 558590 559334 565702 575025 578171 581930 584830 551506 556023 576471 541043 550968 552713 554693 655452 657234 665076 671559 680597 692695 693267 702639 703022 721149 646074 647111 660572 667257 669320 669858 689057 689981 692703 693695 698911 702914 704629 706679 710092 718036 720356 722237 648931 658931 659429 668814 671693 676673 680593 681513 689871 689902 694637 695549 696347 697668 710802 719422 720507 577034 581392 583727 611260 616846 589545 602387 622869 636496 596372 616887 629643 639224 642144 626731 627077 631298 777046 778155 780325 781099 783602 784883 785113 785366 786366 786909 788057 792132 796191 798287 800044 806821 811388 775646 775656 780333 780368 781245 783006 783651 785367 797032 797083 800041 800116 801536 801605 803396 806991 811429 725192 729193 729322 729634 736155 737868 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.15%) |
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 498554 503705 517661 541043 544033 550968 551506 552713 554693 556023 558590 559334 565702 575025 576471 577034 578171 581392 581930 583727 584830 589545 596372 602387 611260 616846 616887 622869 626731 627077 629643 631298 636496 642144 646074 647111 648931 655452 657234 658931 659429 660572 665076 667257 668814 669320 669858 671559 671693 676673 680593 680597 681513 689057 689871 689902 689981 692695 692703 693267 693695 694637 695549 696347 697668 698911 702639 702914 703022 704629 706679 710092 710802 718036 719422 720356 720507 721149 722237 725192 729193 729322 729634 736155 737868 775646 775656 777046 778155 780325 780333 780368 781099 781245 783006 783602 783651 784883 785113 785366 785367 786366 786909 788057 792132 796191 797032 797083 798287 800041 800044 800116 801536 801605 803396 806821 806991 811388 811429 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"orgasm жен"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"orgasm wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"orgasm жен"
]
|
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.