Query Metrics
7
Database Queries
7
Different statements
161.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.02 ms (85.72%) |
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 13450 31091 38857 68869 181544 187824 191237 201839 202846 240689 338809 381818 387581 389602 389715 392097 421569 423539 423842 425112 433792 436538 440992 441806 444695 455553 469459 470436 473059 479893 483434 492905 505135 507638 510819 514092 515053 515621 523746 525999 526831 534017 534434 534481 535616 553684 554492 560048 560234 560331 561738 563330 565312 574768 585550 585866 586189 588600 600023 600824 601295 601487 602197 606702 607607 610697 611086 613304 619810 624756 637469 641940 657788 666107 670988 675060 675702 675871 678896 680334 689191 695719 716078 716114 716165 716256 722322 726166 727761 731016 734322 736382 743891 743946 746494 752799 760211 760262 761517 765959 768873 773924 776807 776816 781251 781875 785877 786999 788848 791020 797275 798740 802041 803479 808491 810782 824450 828451 828804 828819 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (7.78%) |
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 731016 716114 560331 689191 722322 716078 561738 619810 776807 802041 808491 765959 752799 734322 746494 611086 716165 68869 38857 828451 381818 505135 588600 515621 13450 791020 553684 607607 797275 525999 421569 469459 523746 455553 423539 601295 624756 743946 473059 433792 560048 444695 602197 31091 637469 798740 727761 675060 526831 828819 510819 716256 680334 585866 776816 803479 760262 781251 201839 560234 736382 387581 585550 613304 338809 768873 514092 534017 565312 202846 389602 695719 657788 563330 600023 181544 392097 824450 574768 675702 240689 389715 191237 187824 470436 492905 534434 678896 601487 810782 743891 760211 781875 785877 726166 761517 773924 788848 423842 441806 425112 483434 479893 534481 507638 436538 440992 610697 515053 666107 828804 535616 586189 554492 670988 675871 606702 600824 641940 786999 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.00%) |
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 13450 31091 38857 68869 181544 187824 191237 201839 202846 240689 338809 381818 387581 389602 389715 392097 421569 423539 423842 425112 433792 436538 440992 441806 444695 455553 469459 470436 473059 479893 483434 492905 505135 507638 510819 514092 515053 515621 523746 525999 526831 534017 534434 534481 535616 553684 554492 560048 560234 560331 561738 563330 565312 574768 585550 585866 586189 588600 600023 600824 601295 601487 602197 606702 607607 610697 611086 613304 619810 624756 637469 641940 657788 666107 670988 675060 675702 675871 678896 680334 689191 695719 716078 716114 716165 716256 722322 726166 727761 731016 734322 736382 743891 743946 746494 752799 760211 760262 761517 765959 768873 773924 776807 776816 781251 781875 785877 786999 788848 791020 797275 798740 802041 803479 808491 810782 824450 828451 828804 828819 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass stockings"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.85%) |
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.