Query Metrics
7
Database Queries
7
Different statements
206.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.90 ms (84.38%) |
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 382233 384140 396282 397886 398858 406764 413235 417174 420847 422032 422933 426979 427971 429366 430441 435047 438631 446759 447534 450321 450563 450573 451462 454886 455047 455082 461437 466379 478462 482937 483527 483867 492963 493116 496395 500222 504787 509796 513689 515275 516409 523157 524809 529096 532900 532976 532978 533005 534389 547741 547799 554442 556593 559293 564170 568115 571809 575630 578234 579693 583209 589324 596244 596470 604999 610120 610680 615318 615910 626960 642462 651926 659344 669026 692750 696435 703486 709786 714725 715289 716536 717174 721560 722369 722522 722785 724361 725390 733227 738563 739769 740910 743610 751435 753806 755101 757020 757416 758070 763738 774124 778385 780231 784519 787002 787073 789638 796877 799693 803594 805134 805136 805149 806640 807360 812322 813241 813418 820768 823030 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (7.26%) |
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 516409 396282 547741 651926 610680 738563 753806 813418 615910 382233 406764 438631 534389 596244 780231 784519 774124 778385 466379 554442 532978 787073 716536 417174 743610 455082 446759 722369 575630 589324 500222 669026 805136 755101 757020 758070 763738 787002 812322 450321 823030 492963 692750 722522 722785 725390 733227 813241 430441 578234 721560 659344 724361 532976 703486 493116 482937 450573 483867 820768 455047 384140 454886 610120 422032 615318 556593 398858 547799 642462 740910 739769 427971 568115 751435 796877 450563 805134 807360 757416 596470 799693 483527 579693 524809 509796 709786 564170 789638 803594 806640 435047 429366 714725 583209 478462 461437 559293 523157 451462 504787 426979 413235 496395 515275 696435 604999 447534 422933 715289 529096 805149 626960 717174 420847 532900 533005 397886 513689 571809 ] |
||||||||||||||||||||||||||||||
|
5.85 ms (2.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ pink"
]
|
||||||||||||||||||||||||||||||
|
4.51 ms (2.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ pink"
]
|
||||||||||||||||||||||||||||||
|
3.25 ms (1.58%) |
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 382233 384140 396282 397886 398858 406764 413235 417174 420847 422032 422933 426979 427971 429366 430441 435047 438631 446759 447534 450321 450563 450573 451462 454886 455047 455082 461437 466379 478462 482937 483527 483867 492963 493116 496395 500222 504787 509796 513689 515275 516409 523157 524809 529096 532900 532976 532978 533005 534389 547741 547799 554442 556593 559293 564170 568115 571809 575630 578234 579693 583209 589324 596244 596470 604999 610120 610680 615318 615910 626960 642462 651926 659344 669026 692750 696435 703486 709786 714725 715289 716536 717174 721560 722369 722522 722785 724361 725390 733227 738563 739769 740910 743610 751435 753806 755101 757020 757416 758070 763738 774124 778385 780231 784519 787002 787073 789638 796877 799693 803594 805134 805136 805149 806640 807360 812322 813241 813418 820768 823030 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits pink"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
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.