Query Metrics
7
Database Queries
7
Different statements
205.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.64 ms (87.35%) |
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 385608 398902 417709 443949 445766 456125 459902 460531 464553 470345 470360 472305 472865 472966 477156 478211 481641 484075 486274 489779 491010 491377 506978 507141 512877 523072 525062 525932 526404 526427 527596 528903 528911 532351 534569 537306 540708 551221 552823 554046 554808 560493 561629 567078 574300 577953 590606 603697 603959 606220 608683 611413 611954 616457 618005 618965 622661 622681 626143 627894 631185 633563 634276 644847 645446 648192 649870 650226 671494 673097 673996 677524 692824 695665 696049 696062 696685 698709 698819 714040 716339 718391 719907 719933 721918 727899 728276 730023 730441 731031 731147 732584 733021 733540 738421 738604 738951 740761 743615 745074 749860 757026 760902 767391 779702 780734 785103 796248 798630 798746 809333 813070 813599 813979 818738 820504 820564 828127 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (8.01%) |
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 525932 445766 472305 491010 525062 537306 527596 512877 577953 645446 574300 634276 622661 626143 796248 478211 460531 618005 526404 822647 828127 719933 477156 551221 560493 650226 692824 696049 714040 673996 695665 696062 603959 606220 590606 611413 780734 731031 749860 733021 732584 745074 728276 731147 611954 716339 489779 677524 622681 540708 696685 698709 721918 616457 757026 719907 785103 733540 464553 618965 470360 443949 671494 532351 644847 528911 631185 603697 481641 813979 470345 506978 523072 486274 649870 698819 608683 743615 561629 673097 385608 730441 552823 484075 459902 526427 738421 738951 398902 820504 820564 822935 798746 740761 633563 554808 456125 567078 491377 417709 813599 818738 472865 534569 507141 528903 472966 554046 648192 718391 627894 798630 779702 809333 730023 813070 727899 760902 767391 738604 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.24%) |
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 385608 398902 417709 443949 445766 456125 459902 460531 464553 470345 470360 472305 472865 472966 477156 478211 481641 484075 486274 489779 491010 491377 506978 507141 512877 523072 525062 525932 526404 526427 527596 528903 528911 532351 534569 537306 540708 551221 552823 554046 554808 560493 561629 567078 574300 577953 590606 603697 603959 606220 608683 611413 611954 616457 618005 618965 622661 622681 626143 627894 631185 633563 634276 644847 645446 648192 649870 650226 671494 673097 673996 677524 692824 695665 696049 696062 696685 698709 698819 714040 716339 718391 719907 719933 721918 727899 728276 730023 730441 731031 731147 732584 733021 733540 738421 738604 738951 740761 743615 745074 749860 757026 760902 767391 779702 780734 785103 796248 798630 798746 809333 813070 813599 813979 818738 820504 820564 828127 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public sucking dick"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на sucking улиц член"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на sucking улиц член"
]
|
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.