Query Metrics
7
Database Queries
7
Different statements
145.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.93 ms (80.38%) |
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 389551 465019 482891 485389 496582 499971 512750 515314 521327 528511 533084 534649 534925 535527 539679 540887 542303 542612 542636 548270 553887 564185 576780 579300 584202 587239 587683 589238 590761 592215 592987 607481 614043 615190 617602 622869 622961 625319 628152 628843 635610 636758 638009 638792 639443 640156 641038 644478 646137 646610 647468 651396 658769 659055 663202 665939 666670 667406 670977 674524 674585 676682 678205 687078 693021 693612 695179 698902 700717 708701 710372 710493 711076 715787 718278 718421 721462 721936 723907 723938 725323 726397 727002 730628 731377 732433 734059 734062 734792 734795 736145 737486 737653 740096 740707 743841 745480 748035 748112 749833 750395 752266 762741 762993 763771 767547 771391 785496 787148 792189 797467 811334 813167 819770 819946 823640 824688 826215 826664 828118 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (10.14%) |
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 676682 640156 635610 614043 792189 638009 465019 826664 826215 726397 589238 725323 693021 534925 670977 819946 534649 667406 592215 730628 723938 736145 762993 763771 767547 785496 540887 521327 533084 535527 584202 542636 576780 579300 646137 647468 666670 659055 687078 646610 651396 663202 674585 711076 617602 625319 628152 797467 734792 740707 748112 641038 700717 710372 740096 750395 745480 727002 734795 749833 734062 734059 737486 698902 485389 665939 622869 828118 693612 695179 515314 389551 496582 528511 542303 542612 564185 708701 658769 710493 587683 615190 622961 636758 592987 644478 824688 823640 732433 748035 723907 771391 737653 718278 638792 819770 499971 715787 721462 721936 787148 811334 752266 731377 743841 512750 548270 607481 813167 674524 553887 628843 482891 678205 590761 762741 718421 539679 639443 587239 ] |
||||||||||||||||||||||||||||||
|
4.66 ms (3.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск большие cock"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (1.84%) |
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 389551 465019 482891 485389 496582 499971 512750 515314 521327 528511 533084 534649 534925 535527 539679 540887 542303 542612 542636 548270 553887 564185 576780 579300 584202 587239 587683 589238 590761 592215 592987 607481 614043 615190 617602 622869 622961 625319 628152 628843 635610 636758 638009 638792 639443 640156 641038 644478 646137 646610 647468 651396 658769 659055 663202 665939 666670 667406 670977 674524 674585 676682 678205 687078 693021 693612 695179 698902 700717 708701 710372 710493 711076 715787 718278 718421 721462 721936 723907 723938 725323 726397 727002 730628 731377 732433 734059 734062 734792 734795 736145 737486 737653 740096 740707 743841 745480 748035 748112 749833 750395 752266 762741 762993 763771 767547 771391 785496 787148 792189 797467 811334 813167 819770 819946 823640 824688 826215 826664 828118 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur big cock"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск большие cock"
]
|
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.