Query Metrics
7
Database Queries
7
Different statements
181.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.18 ms (84.50%) |
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 61051 88436 382578 386156 388803 398308 400571 414071 414137 414259 416539 416635 418135 419644 420855 420864 423787 426284 427132 428299 431038 438752 439169 445012 448263 452920 452933 453649 456937 457071 457103 463435 465148 468165 471122 475597 476059 476666 477761 484754 485297 491007 493807 497799 499934 502641 504144 509446 510729 512938 513629 516807 518884 531579 531583 532560 547468 547482 547795 551531 552731 553659 554980 557650 560679 568646 579127 589166 593267 594136 598940 599104 599359 602109 602194 605026 622720 623793 624745 639624 642112 659057 665083 669080 669268 692943 700042 700259 712511 721805 742681 747316 750423 752683 752921 753612 757448 758633 760538 762062 777694 778172 779718 784030 785841 785967 786416 788953 792700 793923 802549 803624 803767 803831 807590 807611 808337 808998 809236 812189 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (9.80%) |
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 560679 752683 807590 808998 423787 382578 518884 531579 400571 420864 554980 599104 463435 88436 445012 502641 510729 388803 414259 386156 477761 427132 468165 416539 700259 431038 491007 513629 485297 438752 452920 453649 499934 551531 593267 439169 428299 475597 509446 484754 579127 557650 659057 692943 721805 700042 553659 623793 642112 777694 779718 785967 803624 803831 752921 757448 786416 803767 808337 760538 742681 747316 750423 758633 602109 622720 624745 784030 785841 792700 456937 516807 414071 448263 532560 598940 493807 497799 398308 418135 552731 476666 416635 504144 599359 457103 639624 762062 753612 802549 547795 602194 452933 512938 414137 465148 476059 547482 547468 669080 589166 605026 788953 61051 457071 471122 426284 419644 420855 531583 568646 669268 665083 712511 594136 812189 778172 793923 807611 809236 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.80%) |
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 61051 88436 382578 386156 388803 398308 400571 414071 414137 414259 416539 416635 418135 419644 420855 420864 423787 426284 427132 428299 431038 438752 439169 445012 448263 452920 452933 453649 456937 457071 457103 463435 465148 468165 471122 475597 476059 476666 477761 484754 485297 491007 493807 497799 499934 502641 504144 509446 510729 512938 513629 516807 518884 531579 531583 532560 547468 547482 547795 551531 552731 553659 554980 557650 560679 568646 579127 589166 593267 594136 598940 599104 599359 602109 602194 605026 622720 623793 624745 639624 642112 659057 665083 669080 669268 692943 700042 700259 712511 721805 742681 747316 750423 752683 752921 753612 757448 758633 760538 762062 777694 778172 779718 784030 785841 785967 786416 788953 792700 793923 802549 803624 803767 803831 807590 807611 808337 808998 809236 812189 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty dildo webcam"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty дилд вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty дилд вебкамер"
]
|
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.