Query Metrics
7
Database Queries
7
Different statements
189.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.16 ms (87.74%) |
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 18 5565 34645 38909 40051 142735 146547 177285 210349 337234 395731 396210 399021 400467 400967 403076 403340 413109 425884 482253 483998 510934 529845 536702 538241 539610 539649 540472 542677 544312 550407 563470 599782 600311 601026 608386 608432 613359 616709 625451 640877 644705 680878 687471 688107 697732 699580 704887 711878 724862 725306 732144 740171 741052 741620 744281 747762 751491 754212 760658 762062 765190 769349 769877 771000 771368 772188 772401 772551 775362 776970 779467 779613 779829 779846 781075 781363 781438 781444 782391 782677 783153 783193 785232 789729 791103 793412 795674 796416 796451 797754 798043 798593 799411 799436 799738 805072 806229 814382 815225 815249 815546 816080 816587 816853 817058 817923 818902 819110 821039 821653 822278 823537 823620 825688 827832 827833 827954 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (6.41%) |
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 613359 396210 38909 5565 400967 744281 337234 399021 697732 791103 797754 142735 782391 795674 413109 608386 747762 781444 563470 146547 539610 536702 779846 425884 815249 815546 823620 816587 816853 827954 483998 539649 540472 542677 704887 640877 608432 616709 779829 781438 783193 781075 782677 793412 799436 762062 771368 765190 760658 806229 403076 814382 510934 779467 796451 799411 210349 400467 403340 822278 18 680878 687471 751491 771000 776970 40051 395731 177285 34645 600311 818902 819110 821653 815225 825688 816080 817058 817923 821039 823537 827832 827833 482253 529845 538241 544312 550407 688107 699580 711878 599782 601026 644705 625451 775362 779276 783153 785232 798043 798593 741052 754212 781363 789729 796416 799738 805072 725306 772401 724862 741620 769877 732144 769349 771846 772188 772551 740171 779613 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.91%) |
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 18 5565 34645 38909 40051 142735 146547 177285 210349 337234 395731 396210 399021 400467 400967 403076 403340 413109 425884 482253 483998 510934 529845 536702 538241 539610 539649 540472 542677 544312 550407 563470 599782 600311 601026 608386 608432 613359 616709 625451 640877 644705 680878 687471 688107 697732 699580 704887 711878 724862 725306 732144 740171 741052 741620 744281 747762 751491 754212 760658 762062 765190 769349 769877 771000 771368 772188 772401 772551 775362 776970 779467 779613 779829 779846 781075 781363 781438 781444 782391 782677 783153 783193 785232 789729 791103 793412 795674 796416 796451 797754 798043 798593 799411 799436 799738 805072 806229 814382 815225 815249 815546 816080 816587 816853 817058 817923 818902 819110 821039 821653 822278 823537 823620 825688 827832 827833 827954 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.85%) |
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.