Query Metrics
7
Database Queries
7
Different statements
136.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.31 ms (84.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 154675 395634 410397 410873 415855 420447 426511 428488 435570 438067 449677 453336 454368 455060 457203 463621 466360 467585 472665 477586 480707 480870 488249 488453 488927 491584 496613 498110 499383 499914 500506 500902 502578 503738 504781 513485 514578 516316 516674 517447 520270 523033 528867 530026 530763 535084 537155 540808 544001 552473 554369 554371 555591 555988 556909 561909 561910 561954 563312 567597 567600 574432 584162 584688 585343 600905 605597 606940 618592 619293 620486 620487 622066 626993 638828 644386 650818 653069 653388 657504 666967 674467 685526 689521 697024 700478 710142 711263 713031 714335 720198 733204 733320 733458 745548 745556 746515 747160 748783 756251 758216 758381 758477 759474 792383 794199 796275 796288 799705 804673 806763 811736 813020 813227 814266 816147 817572 823353 824220 826618 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (10.20%) |
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 537155 395634 653388 620486 644386 823353 758381 154675 746515 454368 817572 824220 792383 816147 563312 544001 653069 638828 622066 697024 666967 756251 554371 555591 467585 620487 733458 503738 626993 600905 826618 618592 554369 685526 657504 747160 552473 556909 811736 585343 759474 796288 605597 758477 500902 488453 435570 540808 713031 561954 466360 410873 711263 689521 555988 804673 426511 449677 733320 710142 567600 500506 480870 455060 498110 700478 606940 745548 584162 514578 796275 794199 504781 561910 561909 799705 674467 813020 453336 748783 415855 488927 567597 574432 813227 488249 584688 714335 720198 463621 502578 499914 517447 520270 499383 523033 619293 650818 428488 477586 438067 806763 516316 496613 530026 530763 480707 513485 457203 758216 745556 472665 491584 528867 410397 516674 535084 733204 814266 420447 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.49%) |
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 154675 395634 410397 410873 415855 420447 426511 428488 435570 438067 449677 453336 454368 455060 457203 463621 466360 467585 472665 477586 480707 480870 488249 488453 488927 491584 496613 498110 499383 499914 500506 500902 502578 503738 504781 513485 514578 516316 516674 517447 520270 523033 528867 530026 530763 535084 537155 540808 544001 552473 554369 554371 555591 555988 556909 561909 561910 561954 563312 567597 567600 574432 584162 584688 585343 600905 605597 606940 618592 619293 620486 620487 622066 626993 638828 644386 650818 653069 653388 657504 666967 674467 685526 689521 697024 700478 710142 711263 713031 714335 720198 733204 733320 733458 745548 745556 746515 747160 748783 756251 758216 758381 758477 759474 792383 794199 796275 796288 799705 804673 806763 811736 813020 813227 814266 816147 817572 823353 824220 826618 ] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд жен husband"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo wife husband"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд жен husband"
]
|
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.