Query Metrics
7
Database Queries
7
Different statements
183.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.15 ms (85.99%) |
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 381921 405990 416153 416634 417674 418068 418623 425820 428741 440710 440876 452382 452807 458466 466688 468574 469465 474902 478998 492719 497878 501958 502770 519872 531201 535056 536571 537467 545459 550922 559178 567527 575610 580188 581609 589856 594136 594221 596621 598720 602395 602627 606346 613513 619175 626547 630830 633435 633796 634804 641837 644018 653560 665898 669410 670534 674430 692599 698866 701292 702048 704916 710903 713185 720069 722420 727052 733841 733851 740922 741241 744033 747313 750426 751433 752605 752623 752645 752670 754127 754902 757566 758780 760612 766770 767286 767325 770370 770376 771510 776997 778593 781006 785568 785589 785603 786879 787438 787818 787931 789516 799762 799768 801311 803450 803494 803628 804972 805300 805642 805900 806514 806919 810382 813899 815778 815816 816555 818475 821195 ] |
||||||||||||||||||||||||||||||
|
14.32 ms (7.78%) |
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 594136 596621 598720 634804 785568 805900 801311 803628 785603 804972 766770 727052 751433 752623 767325 733851 710903 776997 803494 805642 428741 381921 416634 754127 468574 531201 559178 653560 633435 469465 501958 535056 633796 417674 418068 440876 425820 405990 416153 519872 669410 613513 452382 492719 619175 418623 440710 818475 821195 815778 815816 816555 813899 458466 474902 466688 452807 478998 497878 536571 502770 537467 550922 575610 545459 580188 567527 698866 702048 713185 720069 722420 665898 674430 701292 670534 692599 581609 594221 602395 602627 641837 644018 589856 606346 630830 626547 781006 785589 786879 806919 778593 787438 787931 803450 806514 810382 740922 741241 744033 758780 760612 770370 787818 789516 799762 799768 805300 733841 750426 757566 771510 747313 767286 752605 752645 752670 754902 770376 704916 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.87%) |
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 381921 405990 416153 416634 417674 418068 418623 425820 428741 440710 440876 452382 452807 458466 466688 468574 469465 474902 478998 492719 497878 501958 502770 519872 531201 535056 536571 537467 545459 550922 559178 567527 575610 580188 581609 589856 594136 594221 596621 598720 602395 602627 606346 613513 619175 626547 630830 633435 633796 634804 641837 644018 653560 665898 669410 670534 674430 692599 698866 701292 702048 704916 710903 713185 720069 722420 727052 733841 733851 740922 741241 744033 747313 750426 751433 752605 752623 752645 752670 754127 754902 757566 758780 760612 766770 767286 767325 770370 770376 771510 776997 778593 781006 785568 785589 785603 786879 787438 787818 787931 789516 799762 799768 801311 803450 803494 803628 804972 805300 805642 805900 806514 806919 810382 813899 815778 815816 816555 818475 821195 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen squirt"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen сквирт оргазм"
]
|
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.