Query Metrics
7
Database Queries
7
Different statements
189.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.39 ms (84.00%) |
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 223663 383434 386904 388124 395252 396844 397068 411729 413062 413283 425942 443843 450713 452532 452908 461151 463137 463784 464546 469360 471017 473096 483675 483906 489340 490637 490733 492622 492664 493744 507441 510895 539241 540862 541030 541116 543734 544877 546146 550788 559313 561725 562153 571094 576597 578510 582836 589467 593634 599238 600455 604552 610078 612636 614833 614844 620880 630129 635775 642273 650618 652163 660061 660383 661534 661535 662823 663353 664968 666050 666155 693254 694619 694638 694926 694935 696129 697298 706041 707496 709367 710570 713115 715420 716293 717144 720344 722149 728563 729049 730936 733549 739749 741980 742056 746848 748431 749593 752848 754770 756324 776414 776473 789444 794420 796343 796860 799636 801804 802621 804713 807850 807869 808480 809993 810112 810306 810383 819347 823744 ] |
||||||||||||||||||||||||||||||
|
20.08 ms (10.58%) |
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 223663 386904 396844 463784 510895 539241 507441 546146 543734 578510 541116 544877 559313 582836 660061 652163 660383 661534 664968 696129 709367 576597 589467 604552 600455 599238 802621 807850 746848 754770 749593 716293 776473 388124 562153 819347 823744 612636 473096 483675 463137 471017 490733 461151 561725 541030 571094 693254 707496 661535 662823 663353 694619 694638 694926 697298 706041 715420 720344 722149 650618 666050 666155 694935 713115 550788 593634 614833 610078 620880 642273 635775 789444 794420 808480 809993 810112 810306 728563 756324 796343 799636 801804 804713 810383 730936 741980 742056 729049 733549 739749 752848 748431 614844 630129 710570 717144 776414 796860 807869 397068 443843 450713 383434 395252 492664 413283 411729 413062 425942 540862 452532 452908 469360 492622 464546 483906 490637 489340 493744 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.47%) |
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 223663 383434 386904 388124 395252 396844 397068 411729 413062 413283 425942 443843 450713 452532 452908 461151 463137 463784 464546 469360 471017 473096 483675 483906 489340 490637 490733 492622 492664 493744 507441 510895 539241 540862 541030 541116 543734 544877 546146 550788 559313 561725 562153 571094 576597 578510 582836 589467 593634 599238 600455 604552 610078 612636 614833 614844 620880 630129 635775 642273 650618 652163 660061 660383 661534 661535 662823 663353 664968 666050 666155 693254 694619 694638 694926 694935 696129 697298 706041 707496 709367 710570 713115 715420 716293 717144 720344 722149 728563 729049 730936 733549 739749 741980 742056 746848 748431 749593 752848 754770 756324 776414 776473 789444 794420 796343 796860 799636 801804 802621 804713 807850 807869 808480 809993 810112 810306 810383 819347 823744 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina hairy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
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.