Query Metrics
7
Database Queries
7
Different statements
192.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.09 ms (88.22%) |
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 394282 395189 399607 400396 413335 419280 434623 434894 439470 442057 447792 451517 451765 458385 459442 459600 465276 468516 470004 477067 493035 494587 501434 507141 514219 516229 520637 524363 525687 538081 557678 558459 558583 563680 563762 565882 566359 567215 572686 585176 585554 588653 590673 591015 595378 598966 599330 603112 606238 606904 612243 613368 616136 618247 620371 622791 623230 625727 625895 635307 635356 648483 663185 664569 672322 677419 687128 692616 695338 703969 705043 705812 707233 709190 709739 712421 713938 714217 716529 717461 717580 723369 727519 736897 740051 741778 741788 747170 753774 754054 756655 757994 759348 762470 764266 767611 768246 769795 770987 771289 772788 780805 784970 785225 785538 787090 787708 789921 790498 791690 792468 793560 794930 798020 802958 806596 811042 812703 825328 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (7.05%) |
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 712421 625727 439470 394282 538081 565882 709190 622791 606238 591015 740051 757994 566359 606904 612243 664569 717461 672322 785538 741778 741788 759348 780805 811042 413335 563680 588653 785225 789921 802958 762470 756655 770987 717580 791690 798020 477067 442057 468516 692616 705812 563762 613368 595378 603112 493035 399607 516229 794930 465276 557678 784970 753774 558459 585176 709739 451517 787090 635307 616136 769795 792468 812703 514219 716529 793560 400396 648483 623230 625895 494587 572686 705043 677419 618247 635356 507141 787708 434894 447792 567215 707233 790498 747170 754054 764266 767611 703969 695338 585554 598966 736897 771289 772788 419280 458385 459600 520637 525687 663185 714217 599330 620371 741836 470004 395189 825328 524363 558583 727519 768246 459442 806596 434623 451765 501434 590673 687128 713938 723369 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.31%) |
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 394282 395189 399607 400396 413335 419280 434623 434894 439470 442057 447792 451517 451765 458385 459442 459600 465276 468516 470004 477067 493035 494587 501434 507141 514219 516229 520637 524363 525687 538081 557678 558459 558583 563680 563762 565882 566359 567215 572686 585176 585554 588653 590673 591015 595378 598966 599330 603112 606238 606904 612243 613368 616136 618247 620371 622791 623230 625727 625895 635307 635356 648483 663185 664569 672322 677419 687128 692616 695338 703969 705043 705812 707233 709190 709739 712421 713938 714217 716529 717461 717580 723369 727519 736897 740051 741778 741788 747170 753774 754054 756655 757994 759348 762470 764266 767611 768246 769795 770987 771289 772788 780805 784970 785225 785538 787090 787708 789921 790498 791690 792468 793560 794930 798020 802958 806596 811042 812703 825328 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"morning sex amateur"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"morning секс любительск"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"morning секс любительск"
]
|
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.