Query Metrics
7
Database Queries
7
Different statements
180.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.59 ms (82.89%) |
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 233934 339392 382491 393641 396191 399088 414516 415093 417616 418419 418675 426762 427909 429818 430366 434336 437537 437558 437610 439151 444810 451696 461737 464593 471960 472728 474914 478548 478765 479403 480817 483531 483551 489583 489618 494482 499004 500700 501219 501658 503361 505905 506556 508695 510769 511235 512830 514310 515862 516425 519687 521454 521923 522057 523756 525686 526996 527797 528104 528459 529096 534172 538354 542446 544686 549475 555037 555853 556060 561905 562035 563797 563823 563887 564491 565405 566122 569197 573917 576036 577365 579958 581637 584067 590413 591077 593975 595871 596677 597947 600081 600123 600985 628363 633512 633732 635225 636869 639550 649556 659562 677957 680709 700820 717867 717898 733090 754086 756840 757423 757955 766415 768089 788405 791386 801193 806882 812145 814072 814553 ] |
||||||||||||||||||||||||||||||
|
21.49 ms (11.91%) |
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 812145 471960 542446 555037 717867 717898 677957 600081 766415 501219 565405 566122 649556 659562 591077 393641 556060 791386 733090 754086 757423 788405 801193 233934 581637 561905 573917 590413 414516 461737 483531 483551 768089 339392 528459 577365 600985 382491 538354 521454 562035 576036 680709 756840 418419 426762 515862 501658 508695 489583 512830 595871 399088 437558 480817 506556 499004 555853 549475 584067 564491 569197 396191 478548 503361 505905 516425 526996 534172 511235 521923 529096 444810 528104 593975 596677 636869 814072 633732 434336 437537 418675 814553 519687 479403 579958 635225 597947 427909 489618 757955 700820 500700 628363 514310 639550 437610 563823 633512 527797 417616 429818 472728 464593 806882 415093 451696 430366 494482 478765 544686 600123 474914 522057 523756 563797 439151 510769 525686 563887 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.36%) |
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 233934 339392 382491 393641 396191 399088 414516 415093 417616 418419 418675 426762 427909 429818 430366 434336 437537 437558 437610 439151 444810 451696 461737 464593 471960 472728 474914 478548 478765 479403 480817 483531 483551 489583 489618 494482 499004 500700 501219 501658 503361 505905 506556 508695 510769 511235 512830 514310 515862 516425 519687 521454 521923 522057 523756 525686 526996 527797 528104 528459 529096 534172 538354 542446 544686 549475 555037 555853 556060 561905 562035 563797 563823 563887 564491 565405 566122 569197 573917 576036 577365 579958 581637 584067 590413 591077 593975 595871 596677 597947 600081 600123 600985 628363 633512 633732 635225 636869 639550 649556 659562 677957 680709 700820 717867 717898 733090 754086 756840 757423 757955 766415 768089 788405 791386 801193 806882 812145 814072 814553 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small cute girl"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая cute девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая cute девушк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
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.