Query Metrics
7
Database Queries
7
Different statements
173.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.09 ms (84.13%) |
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 226082 392002 399088 417721 417722 417723 417725 417730 417739 417745 420013 421586 422501 422853 424529 424534 424739 424753 424755 429232 440700 445702 446698 449792 453306 455011 455445 455825 456261 456267 456298 462285 468985 470480 480611 481421 482675 484545 487842 488131 488286 496869 498083 498924 499184 499778 500225 504365 504599 505857 506538 506551 506552 506556 511047 512877 512935 514718 519883 520741 523943 523951 524536 525638 527896 528689 528714 538905 540143 547735 550024 550826 551177 551450 551451 553001 553632 559236 559998 560901 565355 565363 565372 566576 567133 567585 571221 578153 582514 585086 589015 589561 589806 594875 595029 595842 599758 599761 599883 600302 601910 602561 605443 615605 619478 659460 662556 680572 681546 721012 738641 751971 758899 761490 778297 778894 795832 802568 806228 809493 ] |
||||||||||||||||||||||||||||||
|
18.18 ms (10.47%) |
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 594875 758899 802568 420013 421586 424739 505857 487842 424755 424529 417721 484545 520741 553632 547735 560901 809493 761490 795832 455445 468985 422501 553001 551451 392002 424753 424534 445702 456261 500225 538905 550024 578153 680572 589806 595842 778894 751971 456298 226082 453306 523943 528689 582514 571221 601910 417723 417730 449792 470480 550826 738641 446698 456267 417722 417745 519883 496869 417725 482675 480611 511047 506538 512877 599758 523951 498083 504599 524536 422853 429232 514718 565372 481421 585086 455825 506552 512935 567133 721012 681546 615605 602561 778297 527896 499184 399088 506556 567585 662556 559998 566576 605443 462285 488131 498924 559236 551177 551450 599761 488286 417739 540143 506551 525638 659460 589561 600302 440700 504365 589015 565363 455011 565355 499778 528714 599883 595029 619478 806228 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.77%) |
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 226082 392002 399088 417721 417722 417723 417725 417730 417739 417745 420013 421586 422501 422853 424529 424534 424739 424753 424755 429232 440700 445702 446698 449792 453306 455011 455445 455825 456261 456267 456298 462285 468985 470480 480611 481421 482675 484545 487842 488131 488286 496869 498083 498924 499184 499778 500225 504365 504599 505857 506538 506551 506552 506556 511047 512877 512935 514718 519883 520741 523943 523951 524536 525638 527896 528689 528714 538905 540143 547735 550024 550826 551177 551450 551451 553001 553632 559236 559998 560901 565355 565363 565372 566576 567133 567585 571221 578153 582514 585086 589015 589561 589806 594875 595029 595842 599758 599761 599883 600302 601910 602561 605443 615605 619478 659460 662556 680572 681546 721012 738641 751971 758899 761490 778297 778894 795832 802568 806228 809493 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"street girl"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"street девушк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"street девушк"
]
|
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.