Query Metrics
7
Database Queries
7
Different statements
717.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.69 ms (57.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet ass fuck"
]
|
||||||||||||||||||||||||||||||
|
282.43 ms (39.36%) |
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 24255 131602 189380 226412 385671 386532 388118 398523 400507 411335 426395 457205 461362 467847 473484 524187 544826 555217 560070 576540 586618 592080 596191 604208 605923 620607 638871 641627 647530 649937 650634 652878 652881 655295 656660 663303 663960 665289 665489 665880 667682 672844 679399 680279 689566 700815 700818 707088 712236 714958 716707 717076 723887 724009 724086 724320 726289 731590 740289 742814 744094 745954 746059 755608 756673 759522 760690 762167 765313 767081 769580 775720 780614 781907 781967 782696 784300 784810 785479 789363 789414 789814 791886 791932 792123 792440 795364 796656 796730 799075 801345 801576 807318 811014 812267 814772 814804 815363 815497 815844 815989 816185 818308 818971 818993 819423 819505 820228 820733 821023 821593 821718 823451 823599 823773 824171 824215 824319 825196 827202 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (1.88%) |
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 818308 824319 461362 576540 652878 652881 665289 665880 700815 717076 665489 667682 555217 605923 604208 791932 807318 811014 780614 789814 726289 789363 762167 756673 769580 781967 801345 467847 398523 680279 801576 524187 815363 544826 656660 755608 765313 784810 814804 707088 411335 679399 789414 426395 716707 386532 824215 457205 689566 586618 799075 796656 731590 791886 473484 655295 649937 663303 560070 592080 775720 723887 785479 796730 724086 745954 792123 24255 792440 744094 781907 400507 596191 742814 385671 131602 816185 820733 821593 824171 647530 700818 663960 672844 641627 620607 638871 782696 784300 759522 724009 740289 746059 767081 760690 712236 795364 812267 388118 650634 714958 724320 226412 189380 815844 815989 818971 818993 819423 820228 823599 814772 827202 815497 819505 821718 823773 821023 823451 825196 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.35%) |
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 24255 131602 189380 226412 385671 386532 388118 398523 400507 411335 426395 457205 461362 467847 473484 524187 544826 555217 560070 576540 586618 592080 596191 604208 605923 620607 638871 641627 647530 649937 650634 652878 652881 655295 656660 663303 663960 665289 665489 665880 667682 672844 679399 680279 689566 700815 700818 707088 712236 714958 716707 717076 723887 724009 724086 724320 726289 731590 740289 742814 744094 745954 746059 755608 756673 759522 760690 762167 765313 767081 769580 775720 780614 781907 781967 782696 784300 784810 785479 789363 789414 789814 791886 791932 792123 792440 795364 796656 796730 799075 801345 801576 807318 811014 812267 814772 814804 815363 815497 815844 815989 816185 818308 818971 818993 819423 819505 820228 820733 821023 821593 821718 823451 823599 823773 824171 824215 824319 825196 827202 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"туалет жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.23%) |
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.