Query Metrics
7
Database Queries
7
Different statements
153.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.62 ms (82.24%) |
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 397953 398901 411513 417350 421802 421940 436372 438004 453633 458167 459067 460493 466169 467930 477533 477536 490100 496120 497296 503155 508680 518337 523674 524697 533464 536146 540312 545058 545599 548195 551834 558187 558379 559148 559387 561437 564125 568687 574329 574356 575234 577627 578810 579788 581195 583252 585167 585987 586965 593776 595115 596036 597530 604453 605704 605882 606617 609109 617997 618368 623385 626577 631735 653327 658810 661306 666445 682963 689454 689520 689542 689967 689970 703564 717336 717580 722154 723236 736134 749059 751570 752137 755907 757297 758417 759561 761889 761997 762028 762324 762383 762684 762914 763062 763962 765170 766294 766354 768186 768812 772344 777103 778543 779896 780995 783507 787455 794083 794674 794894 794921 795822 797724 799057 799548 804566 809210 812073 812670 825373 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (10.73%) |
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 536146 561437 794083 804566 797724 761997 717580 799057 421802 558379 722154 778543 766354 533464 545599 577627 583252 596036 626577 723236 762914 759561 558187 787455 762684 579788 809210 421940 794894 757297 783507 825373 581195 794674 772344 762324 761889 609109 703564 477536 755907 763962 766294 548195 508680 578810 689542 631735 605704 617997 717336 523674 758417 453633 606617 777103 762028 623385 795822 812670 460493 794921 689454 605882 618368 559387 458167 762383 812073 398901 417350 779896 518337 689967 597530 595115 689970 765170 780995 653327 593776 397953 467930 749059 763062 768186 689520 585167 436372 736134 497296 666445 604453 545058 682963 564125 477533 496120 661306 568687 575234 503155 586965 490100 540312 551834 658810 559148 438004 459067 574329 585987 752137 799548 751570 768812 411513 466169 524697 574356 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.93%) |
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 397953 398901 411513 417350 421802 421940 436372 438004 453633 458167 459067 460493 466169 467930 477533 477536 490100 496120 497296 503155 508680 518337 523674 524697 533464 536146 540312 545058 545599 548195 551834 558187 558379 559148 559387 561437 564125 568687 574329 574356 575234 577627 578810 579788 581195 583252 585167 585987 586965 593776 595115 596036 597530 604453 605704 605882 606617 609109 617997 618368 623385 626577 631735 653327 658810 661306 666445 682963 689454 689520 689542 689967 689970 703564 717336 717580 722154 723236 736134 749059 751570 752137 755907 757297 758417 759561 761889 761997 762028 762324 762383 762684 762914 763062 763962 765170 766294 766354 768186 768812 772344 777103 778543 779896 780995 783507 787455 794083 794674 794894 794921 795822 797724 799057 799548 804566 809210 812073 812670 825373 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"just homemade fuck"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"just домашн любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"just домашн любительск секс"
]
|
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.