Query Metrics
7
Database Queries
7
Different statements
187.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.69 ms (86.02%) |
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 97688 315072 382971 388233 389863 396635 401924 402626 405174 413044 414069 415554 415988 431540 445431 446217 447426 463747 478437 479277 490785 495066 495155 496339 500680 507258 508912 511256 511378 512180 512211 512219 516437 516812 521230 523560 525091 525178 525367 528307 530497 532253 535623 540176 541854 543872 550772 552006 552913 554423 554789 557812 559783 559897 559910 561806 565475 568501 576858 577064 578293 580166 583347 584008 591836 593023 597823 601071 601081 605418 611013 614597 623521 623564 623599 623614 630091 630280 630521 630533 636883 639783 641452 643028 648061 656626 666968 667755 671839 676603 715574 719765 720407 720687 729857 733910 735602 736706 737105 737125 737162 742477 742480 750533 750940 760210 761572 765714 768090 771040 776911 786461 789831 790217 793657 799871 809163 826182 827918 827971 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (9.21%) |
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 593023 729857 760210 382971 388233 630091 516812 490785 786461 559910 719765 389863 827971 511378 583347 568501 611013 577064 636883 799871 793657 768090 554789 431540 543872 525178 623564 414069 826182 827918 445431 525091 559783 601071 761572 415988 676603 525367 720407 715574 737125 500680 550772 671839 630533 605418 720687 648061 641452 809163 737162 735602 742480 508912 554423 597823 630521 557812 97688 479277 478437 580166 584008 656626 736706 765714 528307 496339 512180 521230 540176 552913 601081 737105 733910 463747 666968 750940 413044 639783 742477 790217 315072 535623 591836 507258 623599 614597 776911 630280 523560 565475 559897 623614 643028 623521 402626 495066 530497 405174 512211 750533 495155 447426 541854 667755 771040 512219 561806 415554 446217 516437 532253 511256 576858 578293 789831 552006 396635 401924 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.42%) |
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 97688 315072 382971 388233 389863 396635 401924 402626 405174 413044 414069 415554 415988 431540 445431 446217 447426 463747 478437 479277 490785 495066 495155 496339 500680 507258 508912 511256 511378 512180 512211 512219 516437 516812 521230 523560 525091 525178 525367 528307 530497 532253 535623 540176 541854 543872 550772 552006 552913 554423 554789 557812 559783 559897 559910 561806 565475 568501 576858 577064 578293 580166 583347 584008 591836 593023 597823 601071 601081 605418 611013 614597 623521 623564 623599 623614 630091 630280 630521 630533 636883 639783 641452 643028 648061 656626 666968 667755 671839 676603 715574 719765 720407 720687 729857 733910 735602 736706 737105 737125 737162 742477 742480 750533 750940 760210 761572 765714 768090 771040 776911 786461 789831 790217 793657 799871 809163 826182 827918 827971 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian extreme"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.