Query Metrics
7
Database Queries
7
Different statements
204.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.09 ms (90.04%) |
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 24149 34087 67200 98749 368131 390554 391049 395862 405272 415588 464373 488604 494261 494266 495709 509228 515881 517491 520162 536979 540957 546485 555152 563645 568192 571154 572202 577210 577295 577437 579304 581394 581427 583955 591167 597557 599525 603212 603507 603548 606496 609278 612383 629818 634851 649625 650643 650842 651886 651888 651889 664271 664823 664855 665876 667498 667888 670488 674091 681682 682423 686069 704540 710263 710407 710544 713635 717313 721913 724528 727917 729266 731777 731784 731954 732377 732696 732744 732786 733076 733347 736141 744212 747145 750751 752596 759766 760137 760774 766583 771453 778895 781762 785333 790802 791571 792801 793406 793555 793716 794703 794795 794826 797126 799951 800709 804504 806300 809934 811050 813018 814236 815325 817748 818169 825894 826230 827106 827416 827516 ] |
||||||||||||||||||||||||||||||
|
10.74 ms (5.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 405272 609278 793716 629818 809934 583955 603212 727917 731954 649625 793406 731784 732744 540957 651888 651889 495709 781762 368131 759766 515881 665876 717313 581427 517491 597557 670488 794826 732786 747145 710407 606496 778895 825894 581394 563645 568192 826230 790802 791571 536979 733347 817748 794703 650842 721913 793555 794795 733076 667498 732696 752596 494266 682423 464373 571154 24149 827516 674091 732377 760774 520162 634851 792801 415588 750751 67200 579304 664855 815325 681682 603507 736141 766583 731777 806300 488604 664271 827416 664823 612383 785333 744212 771453 98749 804504 572202 391049 509228 651886 704540 34087 546485 686069 577437 799951 811050 390554 713635 818169 814236 813018 395862 494261 599525 827106 710544 724528 555152 591167 797126 603548 800709 650643 760137 577295 667888 710263 729266 577210 ] |
||||||||||||||||||||||||||||||
|
2.67 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 24149 34087 67200 98749 368131 390554 391049 395862 405272 415588 464373 488604 494261 494266 495709 509228 515881 517491 520162 536979 540957 546485 555152 563645 568192 571154 572202 577210 577295 577437 579304 581394 581427 583955 591167 597557 599525 603212 603507 603548 606496 609278 612383 629818 634851 649625 650643 650842 651886 651888 651889 664271 664823 664855 665876 667498 667888 670488 674091 681682 682423 686069 704540 710263 710407 710544 713635 717313 721913 724528 727917 729266 731777 731784 731954 732377 732696 732744 732786 733076 733347 736141 744212 747145 750751 752596 759766 760137 760774 766583 771453 778895 781762 785333 790802 791571 792801 793406 793555 793716 794703 794795 794826 797126 799951 800709 804504 806300 809934 811050 813018 814236 815325 817748 818169 825894 826230 827106 827416 827516 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"trio big tits"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро большие сиськ"
]
|
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.