Query Metrics
7
Database Queries
7
Different statements
185.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.18 ms (80.91%) |
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 205 6610 48366 145353 197757 223010 382640 385738 390974 393498 397077 401872 404027 407648 411591 411615 411927 415786 417955 420549 420588 428460 428867 439700 443687 443707 443712 443925 454211 454709 462089 464735 465338 466136 466144 466965 466979 467512 467537 470477 476264 478017 483362 484417 484605 484634 484725 485619 489405 489682 490804 491936 493889 497953 500394 502932 503489 505277 505479 508093 510824 510889 511598 511756 511757 513487 514369 514475 516382 516801 516916 518844 518876 519141 520691 520920 521879 521904 523686 524699 526045 526477 526478 526867 536635 547932 552061 583333 591054 595755 599216 599514 606031 616873 619080 623206 630596 653790 655107 658266 666065 668022 733818 735360 736510 737201 739737 745230 747263 748397 766451 768418 780478 781347 789952 791691 792386 795114 803379 807395 ] |
||||||||||||||||||||||||||||||
|
24.56 ms (13.23%) |
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 411591 411615 415786 417955 420549 420588 428460 428867 443687 443707 443712 443925 454211 462089 464735 467512 470477 476264 407648 439700 465338 466136 466144 466965 467537 478017 500394 514369 514475 521879 523686 524699 526867 484417 505277 511598 511756 516801 516916 520691 520920 526045 526477 536635 483362 484605 485619 489405 491936 493889 505479 516382 519141 521904 526478 484634 484725 489682 502932 508093 510824 510889 511757 513487 518844 518876 497953 385738 145353 393498 48366 390974 397077 404027 411927 490804 503489 583333 655107 658266 666065 653790 668022 606031 619080 591054 791691 792386 795114 807395 745230 747263 766451 781347 789952 803379 733818 768418 735360 736510 748397 737201 739737 780478 205 197757 382640 401872 6610 223010 466979 552061 547932 599514 616873 630596 595755 623206 599216 454709 ] |
||||||||||||||||||||||||||||||
|
3.20 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 205 6610 48366 145353 197757 223010 382640 385738 390974 393498 397077 401872 404027 407648 411591 411615 411927 415786 417955 420549 420588 428460 428867 439700 443687 443707 443712 443925 454211 454709 462089 464735 465338 466136 466144 466965 466979 467512 467537 470477 476264 478017 483362 484417 484605 484634 484725 485619 489405 489682 490804 491936 493889 497953 500394 502932 503489 505277 505479 508093 510824 510889 511598 511756 511757 513487 514369 514475 516382 516801 516916 518844 518876 519141 520691 520920 521879 521904 523686 524699 526045 526477 526478 526867 536635 547932 552061 583333 591054 595755 599216 599514 606031 616873 619080 623206 630596 653790 655107 658266 666065 668022 733818 735360 736510 737201 739737 745230 747263 748397 766451 768418 780478 781347 789952 791691 792386 795114 803379 807395 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"другой парень"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
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.