Query Metrics
7
Database Queries
7
Different statements
159.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.43 ms (83.46%) |
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 465246 482884 494682 506544 511047 525771 528341 533729 534864 539099 541986 542475 542487 543559 546814 547073 551221 552587 553610 554209 556869 560493 565382 573989 575615 589771 592159 595086 599763 606090 606212 611687 618189 618600 625750 627191 627851 628669 629774 632224 632679 633052 633664 635720 647126 650037 650226 654187 666978 677916 681234 684055 689266 690441 691227 691231 692436 692824 693541 696049 696053 696058 696642 696664 696675 696687 696698 696716 701708 702347 704355 707562 707973 708671 709512 713951 714040 716582 717052 717224 718593 719899 719905 720470 722993 724303 727448 732919 733511 736498 739337 739339 741580 746481 746840 747535 750345 751217 751240 751242 751419 754635 755863 757606 758064 758949 760856 761069 761160 762061 775815 811853 814096 817620 820442 821477 821555 823155 828125 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (9.56%) |
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 707562 546814 554209 632679 592159 739337 727448 751240 762061 732919 553610 746481 677916 599763 739339 525771 708671 511047 533729 528341 547073 719905 556869 713951 542487 606090 758064 757606 611687 618189 506544 539099 820442 821477 811853 746840 750345 543559 565382 482884 575615 666978 684055 696053 696058 696698 709512 696716 722993 696675 701708 702347 707973 716582 720470 606212 589771 633664 625750 618600 627191 629774 736498 741580 733511 751217 754635 751419 761160 633052 696664 696687 718593 541986 681234 691231 693541 647126 690441 691227 692436 717052 632224 747535 761069 534864 573989 696642 717224 650037 635720 751242 758949 769831 627851 775815 628669 719899 828125 814096 817620 823155 760856 465246 595086 724303 494682 821555 654187 704355 755863 542475 552587 551221 560493 650226 689266 692824 696049 714040 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.14%) |
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 465246 482884 494682 506544 511047 525771 528341 533729 534864 539099 541986 542475 542487 543559 546814 547073 551221 552587 553610 554209 556869 560493 565382 573989 575615 589771 592159 595086 599763 606090 606212 611687 618189 618600 625750 627191 627851 628669 629774 632224 632679 633052 633664 635720 647126 650037 650226 654187 666978 677916 681234 684055 689266 690441 691227 691231 692436 692824 693541 696049 696053 696058 696642 696664 696675 696687 696698 696716 701708 702347 704355 707562 707973 708671 709512 713951 714040 716582 717052 717224 718593 719899 719905 720470 722993 724303 727448 732919 733511 736498 739337 739339 741580 746481 746840 747535 750345 751217 751240 751242 751419 754635 755863 757606 758064 758949 760856 761069 761160 762061 775815 811853 814096 817620 820442 821477 821555 823155 828125 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock public"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.04%) |
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.