Query Metrics
7
Database Queries
7
Different statements
152.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.32 ms (86.52%) |
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 497792 504424 512185 517490 519753 532202 534963 550655 550659 553439 555594 572045 579622 587961 592992 593398 597166 600288 602807 616886 626807 628694 629799 634839 636416 640108 642240 643026 643292 652173 663971 664266 665307 667397 668760 672789 675558 679701 696141 710573 711342 714220 714637 717388 717436 725426 725787 726097 732942 733422 734255 736045 740548 742574 744198 744739 748550 749552 751306 752864 752914 753702 754394 756384 758056 762016 767729 776450 776746 778581 781806 783417 784844 785644 787349 787522 788317 788516 790099 793477 793495 793624 797337 799932 800754 801986 803049 804430 807879 810025 811116 812390 812402 812469 812484 812487 812492 812736 813729 814337 817149 817159 819257 819263 819437 819641 819643 820026 822302 823774 824073 824562 825283 826388 826603 827399 ] |
||||||||||||||||||||||||||||||
|
12.23 ms (8.00%) |
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 600288 784844 799932 733422 726097 740548 762016 767729 640108 801986 823774 826388 826603 826390 827399 813729 819263 819641 824282 817149 817159 819257 819437 819643 824562 828117 497792 512185 532202 534963 550655 550659 553439 572045 664266 665307 717436 663971 672789 696141 717388 667397 675558 714220 592992 597166 628694 626807 616886 643292 642240 643026 776746 790099 793477 804430 812469 776450 778581 781806 788317 793624 734255 742574 788516 797337 810025 732942 752864 753702 725787 744198 714637 793495 812736 519753 517490 555594 587961 629799 652173 679701 711342 593398 636416 634839 787349 752914 748550 754394 758056 710573 579622 800754 814337 825283 504424 668760 602807 803049 812390 812402 785644 811116 725426 736045 756384 783417 787522 744739 749552 751306 807879 812484 812487 812492 820026 824073 822302 824264 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.59%) |
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 497792 504424 512185 517490 519753 532202 534963 550655 550659 553439 555594 572045 579622 587961 592992 593398 597166 600288 602807 616886 626807 628694 629799 634839 636416 640108 642240 643026 643292 652173 663971 664266 665307 667397 668760 672789 675558 679701 696141 710573 711342 714220 714637 717388 717436 725426 725787 726097 732942 733422 734255 736045 740548 742574 744198 744739 748550 749552 751306 752864 752914 753702 754394 756384 758056 762016 767729 776450 776746 778581 781806 783417 784844 785644 787349 787522 788317 788516 790099 793477 793495 793624 797337 799932 800754 801986 803049 804430 807879 810025 811116 812390 812402 812469 812484 812487 812492 812736 813729 814337 817149 817159 819257 819263 819437 819641 819643 820026 822302 823774 824073 824562 825283 826388 826603 827399 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ мастурбац"
]
|
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.