Query Metrics
7
Database Queries
7
Different statements
144.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.62 ms (83.23%) |
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 400579 402379 403842 409224 409334 411535 417107 423324 431685 432487 438446 438605 438634 438641 441314 468260 482041 492355 513831 517707 522963 524369 554930 556096 568922 570393 574942 580893 583384 583801 596637 599283 601698 616846 616887 617073 617107 627077 627093 631298 657788 670980 672816 673191 676555 679213 689057 697543 705175 707900 711295 713750 719422 721149 722237 722328 723013 730662 736155 737939 739500 741160 741200 744162 745936 747488 748262 748509 750364 750662 751281 753207 756522 757039 760436 761968 765090 768226 768244 768916 769371 769464 773836 775402 777829 778184 780231 780325 781245 782112 782908 783029 783290 783342 783602 784644 785113 785505 787339 788057 791597 792132 792922 793061 794000 795255 799854 800044 801605 802718 803396 803411 807243 809716 809728 809911 810917 811388 816703 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (10.42%) |
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 713750 721149 673191 689057 722237 676555 719422 616846 599283 616887 627077 631298 780325 783602 785113 788057 792132 800044 802718 811388 781245 782908 783029 801605 803396 736155 744162 747488 753207 757039 760436 782112 793061 799854 809716 810917 730662 748262 748509 768226 768916 769464 737939 761968 765090 741200 751281 769371 741160 745936 750364 768244 773836 722328 723013 777829 778184 783342 785505 791597 792922 794000 795255 801457 803411 809728 809911 756522 570393 580893 679213 568922 583801 596637 784644 739500 438446 482041 513831 583384 705175 697543 627093 775402 750662 707900 409334 431685 432487 411535 438634 524369 517707 556096 574942 617073 492355 672816 783290 670980 780231 400579 438641 468260 522963 409224 441314 554930 617107 657788 816703 711295 601698 787339 807243 402379 403842 423324 417107 438605 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.82%) |
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 400579 402379 403842 409224 409334 411535 417107 423324 431685 432487 438446 438605 438634 438641 441314 468260 482041 492355 513831 517707 522963 524369 554930 556096 568922 570393 574942 580893 583384 583801 596637 599283 601698 616846 616887 617073 617107 627077 627093 631298 657788 670980 672816 673191 676555 679213 689057 697543 705175 707900 711295 713750 719422 721149 722237 722328 723013 730662 736155 737939 739500 741160 741200 744162 745936 747488 748262 748509 750364 750662 751281 753207 756522 757039 760436 761968 765090 768226 768244 768916 769371 769464 773836 775402 777829 778184 780231 780325 781245 782112 782908 783029 783290 783342 783602 784644 785113 785505 787339 788057 791597 792132 792922 793061 794000 795255 799854 800044 801605 802718 803396 803411 807243 809716 809728 809911 810917 811388 816703 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.01%) |
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.