Query Metrics
7
Database Queries
7
Different statements
153.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.49 ms (82.88%) |
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 209790 210576 336584 381874 384481 406688 426441 448591 452218 452663 461123 461699 466670 467785 476971 487496 494682 494715 495016 506548 506571 506704 511047 514468 515417 521447 521912 525409 525986 526404 532774 539563 541944 545798 548702 549299 550483 551118 556869 559760 559785 560166 561734 564239 564242 565352 567164 567275 569538 573214 576740 578937 580715 584482 589329 589342 599508 606265 606408 615014 618448 618795 619132 628669 632065 633052 635946 638517 639116 644706 651328 663893 664655 665067 682956 689143 690424 692402 693043 694121 694123 698171 699184 700848 708010 716472 719899 723971 725571 726886 730456 731130 733021 734895 736462 736485 736549 736559 738414 740697 745247 746356 748346 751217 758533 760751 762076 777819 789025 795215 814046 818730 819801 820913 821438 821571 822274 827054 828264 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.03%) |
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 584482 580715 521912 565352 619132 452218 511047 814046 561734 564239 589342 618795 731130 762076 559785 564242 567275 639116 606408 789025 733021 467785 506571 514468 381874 827054 820913 730456 748346 210576 628669 719899 576740 550483 567164 689143 698171 551118 606265 638517 644706 632065 777819 738414 751217 734895 740697 633052 525409 209790 336584 819801 821438 821571 822274 541944 549299 578937 716472 651328 690424 694121 682956 692402 589329 736559 746356 760751 726886 745247 384481 700848 526404 476971 494682 461699 448591 495016 525986 635946 426441 487496 506704 406688 618448 725571 818730 822647 828264 573214 665067 694123 699184 693043 736462 758533 736549 452663 506548 494715 515417 545798 556869 461123 539563 548702 736485 559760 569538 664655 615014 532774 795215 521447 466670 560166 663893 723971 708010 599508 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.96%) |
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 209790 210576 336584 381874 384481 406688 426441 448591 452218 452663 461123 461699 466670 467785 476971 487496 494682 494715 495016 506548 506571 506704 511047 514468 515417 521447 521912 525409 525986 526404 532774 539563 541944 545798 548702 549299 550483 551118 556869 559760 559785 560166 561734 564239 564242 565352 567164 567275 569538 573214 576740 578937 580715 584482 589329 589342 599508 606265 606408 615014 618448 618795 619132 628669 632065 633052 635946 638517 639116 644706 651328 663893 664655 665067 682956 689143 690424 692402 693043 694121 694123 698171 699184 700848 708010 716472 719899 723971 725571 726886 730456 731130 733021 734895 736462 736485 736549 736559 738414 740697 745247 746356 748346 751217 758533 760751 762076 777819 789025 795215 814046 818730 819801 820913 821438 821571 822274 827054 828264 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public big cock"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
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.