Query Metrics
7
Database Queries
7
Different statements
152.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.92 ms (84.66%) |
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 150261 382398 391089 391669 391898 391907 391929 396917 397111 397208 397899 399139 418264 429778 445291 450213 453612 470006 470579 470634 485516 495738 496928 499566 500565 517568 520758 528149 528670 530256 533488 533772 537970 542765 544752 544754 545414 545433 545598 547968 551040 581552 583454 593622 606584 606977 612427 614698 616698 619275 622158 622177 622661 623221 624982 635854 636576 649094 651290 651306 651408 651421 653612 653618 653888 653891 654183 654294 655489 659078 661335 661354 665928 694033 696250 698089 698104 698129 709915 710274 712654 717245 717636 718376 718885 720833 721187 721988 731323 731334 732733 736798 740161 741207 742675 742677 745548 745723 746849 748432 748781 755011 773966 785963 787379 788101 789823 790753 794247 797128 797132 801535 802488 805339 805462 807889 809510 810106 821844 824423 ] |
||||||||||||||||||||||||||||||
|
12.22 ms (8.03%) |
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 418264 496928 495738 741207 397208 622661 731323 470006 485516 391898 533488 654183 696250 710274 545433 545598 748781 785963 807889 794247 736798 742677 748432 544754 528149 821844 544752 661354 718376 593622 797128 742675 755011 718885 391669 653888 789823 429778 528670 533772 551040 653612 717636 809510 773966 731334 740161 745548 745723 619275 721988 787379 788101 581552 649094 470634 391929 445291 636576 397111 150261 391907 450213 453612 797132 623221 397899 661335 824423 732733 517568 537970 583454 545414 746849 810106 606584 399139 612427 606977 396917 499566 520758 542765 470579 651408 653891 622177 624982 712654 530256 698129 659078 709915 802488 790753 805339 805462 801535 698104 717245 382398 391089 547968 655489 694033 720833 651290 651421 653618 654294 651306 665928 698089 622158 635854 614698 616698 500565 721187 ] |
||||||||||||||||||||||||||||||
|
4.04 ms (2.65%) |
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 150261 382398 391089 391669 391898 391907 391929 396917 397111 397208 397899 399139 418264 429778 445291 450213 453612 470006 470579 470634 485516 495738 496928 499566 500565 517568 520758 528149 528670 530256 533488 533772 537970 542765 544752 544754 545414 545433 545598 547968 551040 581552 583454 593622 606584 606977 612427 614698 616698 619275 622158 622177 622661 623221 624982 635854 636576 649094 651290 651306 651408 651421 653612 653618 653888 653891 654183 654294 655489 659078 661335 661354 665928 694033 696250 698089 698104 698129 709915 710274 712654 717245 717636 718376 718885 720833 721187 721988 731323 731334 732733 736798 740161 741207 742675 742677 745548 745723 746849 748432 748781 755011 773966 785963 787379 788101 789823 790753 794247 797128 797132 801535 802488 805339 805462 807889 809510 810106 821844 824423 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро любительск секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mmf amateur threesome"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.84%) |
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.