Query Metrics
7
Database Queries
7
Different statements
211.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.93 ms (88.01%) |
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 413718 417942 418442 420677 421412 425309 426011 426844 440339 440696 442171 443866 444838 451216 452370 452622 454404 454665 457318 459113 460988 477401 492238 497038 497211 499043 500769 502648 505359 505720 520026 523218 528215 531269 532668 534819 536268 542539 543431 543913 546435 547180 549808 555025 555866 558580 564707 564727 566828 566983 567254 577688 577991 578247 582568 583512 588555 588814 592224 594278 595025 595816 596242 598207 598907 599115 607621 615507 615644 615690 617614 618545 630541 639702 646436 651606 652773 665678 666459 667909 668633 669399 682640 695908 706567 729194 732898 757027 763561 764307 764923 772618 773335 773758 773825 775004 778277 779258 779425 780177 781814 782931 783431 784447 785764 786381 786573 787320 791356 791956 793368 799818 802750 803036 809668 810117 811924 813615 818185 825672 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (7.22%) |
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 781814 785764 763561 803036 499043 558580 577991 782931 426844 592224 443866 811924 578247 477401 523218 442171 426011 732898 802750 534819 543913 582568 646436 567254 617614 599115 413718 531269 651606 667909 775004 786381 787320 810117 420677 505359 502648 566828 588555 454665 492238 500769 666459 615507 505720 532668 546435 547180 665678 594278 444838 528215 615644 555866 669399 457318 598907 639702 809668 417942 543431 618545 615690 596242 630541 783431 791356 773758 772618 773335 778277 542539 536268 549808 440339 452622 555025 564707 460988 459113 497038 497211 440696 520026 564727 595025 607621 793368 764307 425309 706567 595816 695908 588814 598207 780177 418442 825672 813615 818185 668633 577688 779258 779425 786573 729194 757027 784447 791956 764923 773825 799818 421412 452370 566983 682640 583512 454404 451216 652773 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.25%) |
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 413718 417942 418442 420677 421412 425309 426011 426844 440339 440696 442171 443866 444838 451216 452370 452622 454404 454665 457318 459113 460988 477401 492238 497038 497211 499043 500769 502648 505359 505720 520026 523218 528215 531269 532668 534819 536268 542539 543431 543913 546435 547180 549808 555025 555866 558580 564707 564727 566828 566983 567254 577688 577991 578247 582568 583512 588555 588814 592224 594278 595025 595816 596242 598207 598907 599115 607621 615507 615644 615690 617614 618545 630541 639702 646436 651606 652773 665678 666459 667909 668633 669399 682640 695908 706567 729194 732898 757027 763561 764307 764923 772618 773335 773758 773825 775004 778277 779258 779425 780177 781814 782931 783431 784447 785764 786381 786573 787320 791356 791956 793368 799818 802750 803036 809668 810117 811924 813615 818185 825672 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов домашн любительск глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov homemade deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.76%) |
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.