Query Metrics
7
Database Queries
7
Different statements
186.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.54 ms (85.47%) |
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 435233 456075 460970 475902 493201 496711 502240 503176 524575 533264 533441 533500 539435 540614 541879 542406 543645 543869 546820 546822 546823 548074 548253 548892 548893 549106 549223 550176 550564 550958 552006 556430 556432 559667 561072 561775 567389 569776 569778 570096 576519 580592 581717 581755 583562 590644 591525 593364 597215 598125 607301 610282 616400 617852 619088 623840 624511 626533 628294 630393 644214 647877 650489 660757 661957 662924 665827 668686 670540 678572 683897 698130 708930 713145 715832 716694 716742 721593 721811 726327 727531 727870 731220 731752 731802 740619 740623 744141 744998 745241 745305 745310 745943 747490 751431 758107 767096 769471 769710 777117 779679 782523 782769 783308 788615 788887 790037 793712 794501 794515 794522 803166 807033 807872 808687 809827 810234 811226 813797 817232 ] |
||||||||||||||||||||||||||||||
|
17.92 ms (9.60%) |
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 807872 493201 533264 581755 650489 793712 548253 559667 740619 502240 683897 782523 767096 788615 460970 524575 549106 623840 597215 813797 727531 496711 456075 543869 550958 670540 661957 790037 777117 540614 668686 715832 745241 533441 548074 561072 698130 591525 644214 727870 731220 731752 552006 660757 598125 788887 556430 475902 721593 803166 809827 541879 546823 550564 561775 810234 811226 543645 716694 716742 617852 794501 794522 744141 747490 758107 769710 533500 546822 662924 744998 751431 628294 569778 581717 593364 610282 782769 779679 783308 726327 740623 745943 550176 549223 576519 721811 607301 616400 542406 665827 630393 808687 794515 731802 807033 624511 435233 583562 713145 567389 817232 539435 548892 546820 708930 678572 619088 626533 745305 769471 580592 503176 569776 556432 548893 590644 745310 647877 570096 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.58%) |
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 435233 456075 460970 475902 493201 496711 502240 503176 524575 533264 533441 533500 539435 540614 541879 542406 543645 543869 546820 546822 546823 548074 548253 548892 548893 549106 549223 550176 550564 550958 552006 556430 556432 559667 561072 561775 567389 569776 569778 570096 576519 580592 581717 581755 583562 590644 591525 593364 597215 598125 607301 610282 616400 617852 619088 623840 624511 626533 628294 630393 644214 647877 650489 660757 661957 662924 665827 668686 670540 678572 683897 698130 708930 713145 715832 716694 716742 721593 721811 726327 727531 727870 731220 731752 731802 740619 740623 744141 744998 745241 745305 745310 745943 747490 751431 758107 767096 769471 769710 777117 779679 782523 782769 783308 788615 788887 790037 793712 794501 794515 794522 803166 807033 807872 808687 809827 810234 811226 813797 817232 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl slave"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.71%) |
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.