Query Metrics
7
Database Queries
7
Different statements
146.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.67 ms (83.45%) |
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 6804 162405 392623 397785 398261 405777 410318 411455 412790 414138 415329 424129 426352 428055 436393 441031 443911 446126 453799 458420 459331 459499 461261 462019 464202 464795 465615 468269 474994 475088 475961 476975 476981 482338 488757 493679 494438 497449 499860 502462 506077 509953 510544 516043 516511 525559 527882 534585 535746 536406 536801 537220 550824 551132 554485 566853 566901 567056 569146 571031 578207 587108 591082 592187 592402 593625 596208 604330 620211 620237 620259 661570 663207 674269 680443 680816 690919 693628 694715 698352 700851 704206 707840 707867 712564 714620 731681 733266 736369 739577 741578 743935 745478 749298 751433 754158 758567 761125 761137 761850 765638 765744 770397 783745 784256 784280 784303 784744 786506 787943 791012 792088 792137 794510 800497 803040 811711 814212 814431 814987 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (8.95%) |
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 566853 765744 749298 743935 751433 761125 784744 794510 493679 537220 620237 620259 800497 784280 397785 462019 488757 510544 502462 567056 661570 604330 690919 468269 465615 494438 536406 578207 663207 712564 792088 733266 736369 761850 412790 424129 441031 162405 459499 516043 569146 592402 411455 525559 428055 593625 694715 680443 693628 6804 698352 506077 535746 680816 591082 571031 587108 405777 459331 534585 707867 620211 792137 811711 739577 765638 783745 784256 707840 398261 410318 814431 814987 458420 461261 497449 499860 536801 474994 475961 551132 704206 592187 784303 741578 761137 786506 791012 475088 415329 453799 464795 509953 516511 476981 554485 446126 482338 476975 464202 674269 770397 436393 414138 596208 566901 758567 392623 426352 443911 814212 527882 714620 700851 550824 803040 787943 731681 754158 745478 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.12%) |
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 6804 162405 392623 397785 398261 405777 410318 411455 412790 414138 415329 424129 426352 428055 436393 441031 443911 446126 453799 458420 459331 459499 461261 462019 464202 464795 465615 468269 474994 475088 475961 476975 476981 482338 488757 493679 494438 497449 499860 502462 506077 509953 510544 516043 516511 525559 527882 534585 535746 536406 536801 537220 550824 551132 554485 566853 566901 567056 569146 571031 578207 587108 591082 592187 592402 593625 596208 604330 620211 620237 620259 661570 663207 674269 680443 680816 690919 693628 694715 698352 700851 704206 707840 707867 712564 714620 731681 733266 736369 739577 741578 743935 745478 749298 751433 754158 758567 761125 761137 761850 765638 765744 770397 783745 784256 784280 784303 784744 786506 787943 791012 792088 792137 794510 800497 803040 811711 814212 814431 814987 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск hot анал"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hot anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск hot анал"
]
|
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.