Query Metrics
7
Database Queries
7
Different statements
293.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.91 ms (91.20%) |
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 73052 90979 385948 388957 413662 414240 418269 425281 435409 435618 438396 444956 446560 452735 456525 460003 463021 482036 485365 490002 490040 492573 496462 505992 519057 521615 522790 523235 528500 546040 546046 554307 558273 560276 564742 567150 569854 572480 572737 572801 573297 575844 578530 578845 584465 588169 591762 599538 603817 606604 612211 613255 617756 619570 621043 626298 639124 641418 641461 644655 660942 662469 678697 679099 680588 690524 693313 698801 698847 699599 700919 702961 706422 706467 706727 718344 722149 722917 727554 727571 729382 730144 734108 734164 734413 750702 753190 753774 763886 768497 771782 773317 776435 779153 779420 780104 782054 784704 789756 790568 791395 792216 792980 793638 795398 799407 801627 803401 803605 805398 809675 809924 814356 815089 815196 815839 817743 823884 825758 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (5.31%) |
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 803401 805398 809675 734108 789756 791395 768497 773317 784704 792980 793638 523235 680588 641418 490040 718344 626298 641461 679099 706467 799407 485365 815196 388957 567150 385948 817743 505992 564742 699599 700919 662469 613255 612211 803605 730144 763886 425281 554307 606604 795398 617756 519057 578845 727554 444956 438396 413662 823884 452735 521615 546040 572801 573297 578530 660942 706422 706727 713291 678697 693313 698801 698847 690524 546046 639124 588169 619570 780104 801627 782054 727571 753190 734413 702961 779420 792216 456525 460003 722917 73052 418269 435618 814356 569854 603817 644655 591762 621043 776435 779153 809924 729382 734164 750702 753774 771782 790568 446560 463021 435409 558273 572737 584465 599538 492573 490002 90979 414240 815089 825758 815839 482036 496462 522790 528500 572480 560276 575844 722149 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (0.88%) |
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 73052 90979 385948 388957 413662 414240 418269 425281 435409 435618 438396 444956 446560 452735 456525 460003 463021 482036 485365 490002 490040 492573 496462 505992 519057 521615 522790 523235 528500 546040 546046 554307 558273 560276 564742 567150 569854 572480 572737 572801 573297 575844 578530 578845 584465 588169 591762 599538 603817 606604 612211 613255 617756 619570 621043 626298 639124 641418 641461 644655 660942 662469 678697 679099 680588 690524 693313 698801 698847 699599 700919 702961 706422 706467 706727 718344 722149 722917 727554 727571 729382 730144 734108 734164 734413 750702 753190 753774 763886 768497 771782 773317 776435 779153 779420 780104 782054 784704 789756 790568 791395 792216 792980 793638 795398 799407 801627 803401 803605 805398 809675 809924 814356 815089 815196 815839 817743 823884 825758 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet pussy fuck"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые pussy секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мокрые pussy секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.