Query Metrics
7
Database Queries
7
Different statements
151.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.53 ms (84.26%) |
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 382585 386790 396831 401583 402730 411422 418336 420548 423949 433787 437522 438654 438672 441759 443569 443680 457325 458738 459484 461553 462597 465950 466044 466083 466187 466220 466332 466854 469776 474990 477634 481018 485602 488896 489484 497576 500704 502417 502916 505974 508865 523302 526034 526037 533657 534111 538402 549551 552203 552222 552233 552248 559032 559395 561341 562277 564068 565638 568683 570668 571401 572442 573646 573945 574000 574488 575127 577968 596673 623013 633480 644151 657282 672898 690478 691343 705436 721438 722816 722852 729440 739331 743615 743638 743905 744025 762169 762767 766101 766183 766185 766194 769072 773427 777254 778828 778965 779755 780381 781360 782210 782324 783003 785507 785923 786998 787730 788386 789921 793956 793972 799045 807284 807296 811211 814990 816182 818002 825505 825567 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (9.63%) |
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 814990 722852 564068 781360 766183 743615 466187 825505 561341 691343 779755 789921 778965 785507 807284 811211 782324 807296 743638 705436 386790 559395 420548 433787 633480 402730 722816 773427 552233 443680 552248 461553 466220 538402 571401 382585 488896 533657 825567 816182 672898 623013 769072 777254 466332 502417 568683 785923 744025 766194 552222 401583 396831 466044 466083 786998 721438 787730 489484 441759 458738 526034 762767 466854 485602 783003 743905 778828 574488 438672 423949 474990 552203 690478 644151 766185 729440 799045 477634 565638 481018 534111 782210 523302 577968 818002 502916 572442 657282 574000 780381 739331 559032 459484 438654 793956 788386 762169 766101 575127 457325 508865 437522 562277 596673 411422 469776 526037 505974 793972 549551 570668 573646 573945 462597 465950 418336 443569 500704 497576 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.85%) |
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 382585 386790 396831 401583 402730 411422 418336 420548 423949 433787 437522 438654 438672 441759 443569 443680 457325 458738 459484 461553 462597 465950 466044 466083 466187 466220 466332 466854 469776 474990 477634 481018 485602 488896 489484 497576 500704 502417 502916 505974 508865 523302 526034 526037 533657 534111 538402 549551 552203 552222 552233 552248 559032 559395 561341 562277 564068 565638 568683 570668 571401 572442 573646 573945 574000 574488 575127 577968 596673 623013 633480 644151 657282 672898 690478 691343 705436 721438 722816 722852 729440 739331 743615 743638 743905 744025 762169 762767 766101 766183 766185 766194 769072 773427 777254 778828 778965 779755 780381 781360 782210 782324 783003 785507 785923 786998 787730 788386 789921 793956 793972 799045 807284 807296 811211 814990 816182 818002 825505 825567 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с русской девушк%…"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.90%) |
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.