Query Metrics
7
Database Queries
7
Different statements
190.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.80 ms (86.08%) |
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 391561 397130 400102 417600 419661 535623 550535 552425 585222 585983 591164 595052 599939 600454 603601 608961 609148 610475 612289 616701 620576 628899 632441 634618 636713 642902 643836 649084 650551 654151 655747 657336 667114 676437 689405 697108 699970 702290 703306 703333 709090 710705 711267 712172 714709 717196 717913 720094 724076 728340 729063 738085 740302 740868 740984 742142 742964 745190 746949 748633 748912 749975 750035 750339 751707 754910 756761 759241 761342 761686 761876 763542 765938 766000 773773 775096 778198 778917 779867 780287 780377 780413 780494 780518 780635 781089 781434 782509 784482 786028 787113 788390 789774 790194 792075 794482 796056 796059 796786 797398 799550 800255 800289 800949 801859 803375 803811 804712 804843 804971 805648 806862 808420 810211 810270 814185 821556 826102 827923 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (9.11%) |
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 650551 667114 676437 689405 699970 710705 714709 720094 585222 585983 595052 608961 609148 634618 643836 603601 616701 628899 632441 636713 591164 610475 612289 642902 778198 779867 780377 780635 782509 792075 797398 799550 800289 800949 803811 805648 806862 808420 775096 780287 780494 780518 794482 796786 800255 801859 803375 804971 729063 742964 745190 750339 761686 763542 766000 781434 787113 789774 796059 810211 724076 740868 742142 746949 748633 748912 749975 756761 759241 761876 765938 728340 751707 754910 770675 738085 740984 750035 761342 773773 702290 703306 703333 711267 712172 717196 778917 780413 781089 786028 788390 790194 796056 804843 810270 535623 600454 552425 655747 657336 709090 550535 599939 620576 784482 804712 740302 697108 717913 391561 397130 400102 417600 419661 814185 826102 821556 827923 649084 654151 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.37%) |
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 391561 397130 400102 417600 419661 535623 550535 552425 585222 585983 591164 595052 599939 600454 603601 608961 609148 610475 612289 616701 620576 628899 632441 634618 636713 642902 643836 649084 650551 654151 655747 657336 667114 676437 689405 697108 699970 702290 703306 703333 709090 710705 711267 712172 714709 717196 717913 720094 724076 728340 729063 738085 740302 740868 740984 742142 742964 745190 746949 748633 748912 749975 750035 750339 751707 754910 756761 759241 761342 761686 761876 763542 765938 766000 773773 775096 778198 778917 779867 780287 780377 780413 780494 780518 780635 781089 781434 782509 784482 786028 787113 788390 789774 790194 792075 794482 796056 796059 796786 797398 799550 800255 800289 800949 801859 803375 803811 804712 804843 804971 805648 806862 808420 810211 810270 814185 821556 826102 827923 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard girl"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard девушк"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard девушк"
]
|
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.