Query Metrics
7
Database Queries
7
Different statements
359.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.01 ms (58.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
118.55 ms (32.94%) |
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 12090 46788 105005 238244 351047 382792 384902 384978 388469 391206 457951 562238 563497 566531 571544 571990 572796 596752 601279 601397 602678 627851 628152 633483 636801 641367 645861 645952 647253 648458 649904 650038 663457 666868 670540 672031 679083 703864 706897 709523 710994 716576 719790 726580 726906 728208 728911 730855 736139 736161 738147 742216 743119 744619 749980 750000 751138 752502 754375 755991 760961 762796 764081 765029 765244 765387 765919 766806 769220 769566 770340 771491 773414 774030 776704 778843 780149 780288 780518 782605 782691 786431 791459 791755 797337 798632 802434 802618 803245 804118 804176 804578 805022 805130 807076 807411 807925 810738 811346 812435 816054 816146 817110 817839 818693 818967 820358 820411 820677 820933 821127 821238 821601 823520 823571 825634 826517 827958 ] |
||||||||||||||||||||||||||||||
|
22.93 ms (6.37%) |
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 786431 798632 802618 384902 563497 807925 710994 628152 773414 728208 778843 726906 754375 572796 820358 105005 818693 384978 776704 636801 827958 826517 816054 823571 817110 820411 820677 825634 816146 601279 762796 772628 782691 726580 728911 602678 645952 627851 645861 566531 562238 780288 750000 391206 382792 706897 821127 649904 751138 765244 769220 771491 791755 736139 752502 744619 780149 388469 709523 811346 797337 766806 818967 804118 820933 719790 571990 802434 765029 782605 805022 46788 571544 742216 749980 805130 457951 804578 765919 351047 12090 601397 730855 716576 641367 791459 807076 812435 817839 821238 663457 679083 666868 823520 821601 648458 670540 672031 650038 703864 596752 803245 804176 780518 738147 743119 764081 807411 736161 765387 769566 770340 774030 760961 780862 810738 238244 647253 633483 755991 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.69%) |
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 12090 46788 105005 238244 351047 382792 384902 384978 388469 391206 457951 562238 563497 566531 571544 571990 572796 596752 601279 601397 602678 627851 628152 633483 636801 641367 645861 645952 647253 648458 649904 650038 663457 666868 670540 672031 679083 703864 706897 709523 710994 716576 719790 726580 726906 728208 728911 730855 736139 736161 738147 742216 743119 744619 749980 750000 751138 752502 754375 755991 760961 762796 764081 765029 765244 765387 765919 766806 769220 769566 770340 771491 773414 774030 776704 778843 780149 780288 780518 782605 782691 786431 791459 791755 797337 798632 802434 802618 803245 804118 804176 804578 805022 805130 807076 807411 807925 810738 811346 812435 816054 816146 817110 817839 818693 818967 820358 820411 820677 820933 821127 821238 821601 823520 823571 825634 826517 827958 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.50%) |
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.