Query Metrics
7
Database Queries
7
Different statements
172.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.97 ms (83.43%) |
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 233386 389093 392446 399857 402723 415230 420432 438095 439323 446363 447308 447348 447465 448554 452425 461503 462763 470076 470483 470522 480331 484692 484857 487206 496143 502500 502559 502657 503617 508505 509904 510635 513566 513680 527599 533736 544041 546705 550236 558324 558846 566667 568357 574062 574585 576134 576291 576292 579616 585094 588898 595316 596604 596643 597282 597507 598439 598604 598739 598751 600073 618808 621074 621087 651934 651944 657361 662436 674177 674216 675342 679134 691450 694612 695319 695333 695464 703945 705310 709994 720762 721367 722850 728428 730595 739012 743380 743706 746070 753446 754146 762187 764879 765507 766867 768346 768852 769742 769747 769750 769760 769805 769863 770582 772730 775561 778243 786048 789782 797842 799045 800321 801271 812351 814508 816755 818025 ] |
||||||||||||||||||||||||||||||
|
18.92 ms (10.96%) |
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 558846 574585 579616 621087 461503 447465 513680 233386 389093 574062 446363 470483 585094 679134 595316 597507 754040 754146 769750 765507 762187 762229 452425 502559 503617 509904 576291 568357 447348 558324 544041 546705 447308 420432 510635 674216 695319 722850 618808 800321 812351 753446 770582 772730 730595 746070 764879 768346 769742 766867 769760 739012 768852 769805 703945 720762 799045 439323 743380 438095 502657 513566 814508 508505 657361 597282 787390 402723 598439 818025 651934 675342 691450 651944 694612 588898 775561 789782 801271 728428 769747 769863 721367 462763 392446 484857 600073 596643 399857 415230 487206 566667 527599 470522 550236 576292 596604 470076 480331 448554 496143 502500 743706 598739 598604 484692 816755 533736 576134 662436 674177 695333 695464 705310 709994 598751 621074 778243 786048 797842 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.82%) |
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 233386 389093 392446 399857 402723 415230 420432 438095 439323 446363 447308 447348 447465 448554 452425 461503 462763 470076 470483 470522 480331 484692 484857 487206 496143 502500 502559 502657 503617 508505 509904 510635 513566 513680 527599 533736 544041 546705 550236 558324 558846 566667 568357 574062 574585 576134 576291 576292 579616 585094 588898 595316 596604 596643 597282 597507 598439 598604 598739 598751 600073 618808 621074 621087 651934 651944 657361 662436 674177 674216 675342 679134 691450 694612 695319 695333 695464 703945 705310 709994 720762 721367 722850 728428 730595 739012 743380 743706 746070 753446 754146 762187 764879 765507 766867 768346 768852 769742 769747 769750 769760 769805 769863 770582 772730 775561 778243 786048 789782 797842 799045 800321 801271 812351 814508 816755 818025 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead russian teen"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая русск teen"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая русск teen"
]
|
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.