Query Metrics
7
Database Queries
7
Different statements
166.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.48 ms (82.56%) |
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 384807 399414 400426 400689 401116 401344 403289 404059 404765 416303 419518 422500 422609 423261 428018 431333 472179 491487 508191 529846 536766 545607 546200 547366 550236 554472 556014 556015 556022 557517 558131 558601 560191 560439 561653 561703 562373 565259 566621 571212 583677 586886 595873 596616 597066 597227 597960 598498 601877 603394 605325 605330 607125 609052 609682 615718 622402 623203 624223 628126 628406 630540 632033 632046 633733 634187 636273 636274 637094 641682 644674 646824 646838 664976 666546 670103 671640 671832 678954 679381 681843 688660 698293 699626 701012 704212 709781 714449 714464 716043 721999 722645 732001 736663 740704 742143 744259 744753 747398 747448 749338 750521 752685 753486 757643 757928 758871 760967 760975 761005 761585 763887 766858 792789 793901 798990 810032 811624 813526 819573 ] |
||||||||||||||||||||||||||||||
|
17.91 ms (10.75%) |
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 757643 763887 404059 798990 598498 630540 622402 384807 404765 422609 491487 428018 399414 623203 565259 615718 596616 558131 561703 562373 716043 664976 628126 819573 699626 709781 671640 670103 605325 609052 811624 740704 792789 752685 698293 403289 508191 597960 750521 401344 556015 556022 566621 597066 757928 419518 547366 554472 632033 597227 431333 557517 545607 571212 714464 681843 624223 636274 609682 636273 742143 644674 714449 758871 761005 766858 671832 679381 688660 701012 529846 583677 646838 666546 556014 595873 633733 628406 632046 637094 560439 416303 560191 586886 561653 400426 422500 472179 536766 423261 550236 678954 646824 722645 641682 601877 603394 605330 793901 813526 744753 753486 761585 810032 747448 749338 736663 732001 744259 747398 760967 760975 704212 721999 400689 401116 607125 546200 558601 634187 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.74%) |
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 384807 399414 400426 400689 401116 401344 403289 404059 404765 416303 419518 422500 422609 423261 428018 431333 472179 491487 508191 529846 536766 545607 546200 547366 550236 554472 556014 556015 556022 557517 558131 558601 560191 560439 561653 561703 562373 565259 566621 571212 583677 586886 595873 596616 597066 597227 597960 598498 601877 603394 605325 605330 607125 609052 609682 615718 622402 623203 624223 628126 628406 630540 632033 632046 633733 634187 636273 636274 637094 641682 644674 646824 646838 664976 666546 670103 671640 671832 678954 679381 681843 688660 698293 699626 701012 704212 709781 714449 714464 716043 721999 722645 732001 736663 740704 742143 744259 744753 747398 747448 749338 750521 752685 753486 757643 757928 758871 760967 760975 761005 761585 763887 766858 792789 793901 798990 810032 811624 813526 819573 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young anal small"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young анал маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young анал маленькая"
]
|
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.