Query Metrics
7
Database Queries
7
Different statements
354.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.38 ms (59.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
121.75 ms (34.34%) |
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 395311 397904 400428 415815 420308 423311 425727 427790 440250 440274 440414 440798 440805 440859 440867 440890 440967 440977 447090 451494 455745 458443 458450 460857 465718 469496 474782 474801 474806 475196 481238 487047 488337 491336 492135 492318 507456 513817 515263 521763 522935 525848 528848 529972 534848 545848 546592 549662 554929 557810 565007 574169 577087 577111 577551 577600 583091 583096 586862 590485 591052 595137 600227 600704 603578 605956 606860 607964 613172 620115 620116 624099 631503 659956 660048 670084 671220 674907 675495 679294 679297 679657 682320 685061 688203 700299 707569 709919 712393 712875 721867 729226 729357 733672 734383 738175 751958 752029 757128 758247 761788 765394 765959 767722 768790 769291 774994 776581 779806 789437 790188 793279 794381 795143 795686 796794 800975 802225 809592 811627 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (4.25%) |
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 779806 795143 809592 789437 734383 768790 733672 757128 729226 758247 761788 707569 776581 796794 455745 451494 481238 440805 474801 492135 491336 440867 721867 605956 769291 447090 397904 425727 525848 427790 554929 565007 712875 492318 507456 521763 515263 545848 679657 679294 682320 577111 583091 591052 631503 586862 420308 577600 606860 577087 469496 460857 574169 675495 659956 595137 800975 802225 729357 767722 765394 607964 712393 557810 465718 474782 620116 395311 400428 440977 440274 440414 440967 440798 440890 423311 440859 487047 488337 458450 534848 522935 528848 529972 513817 549662 577551 583096 660048 674907 685061 700299 670084 671220 679297 688203 709919 546592 590485 600227 603578 613172 600704 620115 624099 774994 793279 794381 795686 811627 738175 765959 751958 752029 790188 475196 440250 458443 474806 415815 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.67%) |
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 395311 397904 400428 415815 420308 423311 425727 427790 440250 440274 440414 440798 440805 440859 440867 440890 440967 440977 447090 451494 455745 458443 458450 460857 465718 469496 474782 474801 474806 475196 481238 487047 488337 491336 492135 492318 507456 513817 515263 521763 522935 525848 528848 529972 534848 545848 546592 549662 554929 557810 565007 574169 577087 577111 577551 577600 583091 583096 586862 590485 591052 595137 600227 600704 603578 605956 606860 607964 613172 620115 620116 624099 631503 659956 660048 670084 671220 674907 675495 679294 679297 679657 682320 685061 688203 700299 707569 709919 712393 712875 721867 729226 729357 733672 734383 738175 751958 752029 757128 758247 761788 765394 765959 767722 768790 769291 774994 776581 779806 789437 790188 793279 794381 795143 795686 796794 800975 802225 809592 811627 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real wife sperm"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real жен сперм"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real жен сперм"
]
|
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.