Query Metrics
7
Database Queries
7
Different statements
150.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.77 ms (82.05%) |
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 31134 181096 233941 275759 370905 383354 388555 389657 397510 398965 401201 411009 423809 425510 428362 434306 443402 443690 446792 450184 456030 456867 457097 457119 460161 460404 464410 465076 465349 466350 466492 467085 471058 471060 472698 473400 475023 475656 477548 478516 478897 489924 490514 490595 491436 499842 499919 500689 502062 504005 506835 507616 512223 512513 519753 528540 535345 538861 538908 541479 549877 554459 556782 559408 559430 564480 568752 573250 578010 587961 599354 599566 607345 609071 610209 612237 615145 618228 634758 693987 694192 710063 712026 719139 724514 726848 728980 742276 753738 756487 756494 759731 760175 768121 770038 771409 780262 793516 793535 793670 794400 794427 801750 803055 804265 808671 810014 810594 811917 813575 818502 818822 820749 823862 824735 825063 825892 826393 826602 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (11.10%) |
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 693987 712026 519753 506835 587961 425510 500689 512223 275759 772079 465349 491436 490595 398965 578010 472698 554459 599354 759731 490514 825063 538908 634758 726848 793516 810014 770038 724514 753738 760175 756494 389657 825892 823862 818822 818502 801750 768121 401201 457119 478897 467085 471060 478516 370905 233941 181096 813575 820749 826393 538861 573250 811917 810594 794427 771409 794400 824735 489924 456867 475023 397510 464410 793670 808671 443690 383354 460161 446792 528540 499919 694192 610209 756487 742276 804265 460404 443402 559430 473400 388555 793535 618228 780262 477548 535345 541479 612237 456030 507616 31134 499842 559408 710063 728980 502062 568752 556782 607345 434306 423809 411009 471058 465076 504005 719139 457097 428362 475656 549877 803055 615145 450184 512513 609071 466350 466492 564480 826602 599566 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.72%) |
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 31134 181096 233941 275759 370905 383354 388555 389657 397510 398965 401201 411009 423809 425510 428362 434306 443402 443690 446792 450184 456030 456867 457097 457119 460161 460404 464410 465076 465349 466350 466492 467085 471058 471060 472698 473400 475023 475656 477548 478516 478897 489924 490514 490595 491436 499842 499919 500689 502062 504005 506835 507616 512223 512513 519753 528540 535345 538861 538908 541479 549877 554459 556782 559408 559430 564480 568752 573250 578010 587961 599354 599566 607345 609071 610209 612237 615145 618228 634758 693987 694192 710063 712026 719139 724514 726848 728980 742276 753738 756487 756494 759731 760175 768121 770038 771409 780262 793516 793535 793670 794400 794427 801750 803055 804265 808671 810014 810594 811917 813575 818502 818822 820749 823862 824735 825063 825892 826393 826602 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy milf tits"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая milf сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая milf сиськ"
]
|
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.