Query Metrics
7
Database Queries
7
Different statements
396.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.59 ms (52.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
162.08 ms (40.89%) |
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 400162 416360 420280 423196 431540 434763 440156 441489 446038 451252 451672 452052 452897 464445 464460 467003 467867 468154 469198 469263 476088 476186 477587 480194 481877 483486 489461 492525 492703 498576 499791 499857 506904 507165 514568 523892 524534 531880 533363 534647 536550 545454 547534 547800 557387 565063 565412 568189 571039 587335 590344 591849 591959 594861 600004 608773 631641 632107 636320 639060 641996 646669 647315 648733 649991 650544 657136 658789 658797 696202 696949 698878 705099 706934 709723 713565 714183 718766 718788 720262 720740 724470 725527 728145 728200 730091 746126 747098 748264 750699 751435 756752 765628 770901 775801 775855 776621 785059 785213 786509 787484 788494 788807 788911 789647 790219 792343 792652 797447 798443 801880 801966 806850 807219 809512 810827 813346 815038 818181 825878 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (4.06%) |
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 785213 801966 770901 724470 750699 725527 728200 706934 714183 789647 801880 423196 441489 452897 440156 787484 636320 825878 815038 818181 476186 514568 531880 571039 658789 631641 786509 792343 788807 788911 807219 765628 806850 756752 776621 790219 469263 507165 557387 565412 469198 480194 547534 591959 523892 499791 492525 533363 639060 641996 464445 434763 451672 649991 492703 431540 524534 446038 464460 451252 467003 565063 705099 713565 696949 810827 746126 416360 489461 467867 481877 468154 568189 720262 720740 647315 650544 709723 594861 591849 590344 748264 728145 730091 792652 400162 476088 506904 483486 498576 499857 420280 477587 452052 534647 536550 545454 547800 696202 718766 718788 657136 646669 648733 658797 600004 632107 587335 775801 775855 797447 809512 813346 785059 788494 798443 747098 751435 608773 698878 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.70%) |
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 400162 416360 420280 423196 431540 434763 440156 441489 446038 451252 451672 452052 452897 464445 464460 467003 467867 468154 469198 469263 476088 476186 477587 480194 481877 483486 489461 492525 492703 498576 499791 499857 506904 507165 514568 523892 524534 531880 533363 534647 536550 545454 547534 547800 557387 565063 565412 568189 571039 587335 590344 591849 591959 594861 600004 608773 631641 632107 636320 639060 641996 646669 647315 648733 649991 650544 657136 658789 658797 696202 696949 698878 705099 706934 709723 713565 714183 718766 718788 720262 720740 724470 725527 728145 728200 730091 746126 747098 748264 750699 751435 756752 765628 770901 775801 775855 776621 785059 785213 786509 787484 788494 788807 788911 789647 790219 792343 792652 797447 798443 801880 801966 806850 807219 809512 810827 813346 815038 818181 825878 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs squirt"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.