Query Metrics
7
Database Queries
7
Different statements
265.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
243.98 ms (91.77%) |
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 398264 410264 410741 416668 448366 453952 460770 465803 466098 466237 472158 474994 476090 479758 479759 496082 496869 497420 498548 509588 514892 517990 521291 522970 523199 529357 533265 540831 540931 540975 541629 549073 568442 568531 575046 575635 581250 584265 585264 588561 590108 590815 590845 593581 594359 595540 597891 600848 601479 604655 606979 608438 610834 616598 616665 619171 620894 622479 625245 625405 627772 629170 631063 634036 636885 640384 641172 642534 645484 646123 648538 649039 651565 651996 653686 655239 655252 655504 656285 657224 658163 660317 660326 662015 662794 664585 668084 668098 669553 679515 680233 686129 686255 686924 688474 693618 693691 694347 695888 696293 698879 712051 716711 717241 718358 724339 725351 730332 730380 731347 738320 740726 741187 744891 747621 773699 783129 789633 800563 825961 ] |
||||||||||||||||||||||||||||||
|
11.38 ms (4.28%) |
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 453952 460770 472158 497420 514892 509588 517990 474994 541629 568442 568531 695888 619171 800563 730380 741187 448366 410264 466237 479759 398264 410741 465803 416668 476090 479758 466098 498548 522970 496082 496869 521291 540975 680233 575635 604655 594359 593581 693618 725351 740726 738320 744891 724339 717241 783129 789633 731347 529357 523199 540931 668084 668098 686255 718358 646123 651565 656285 660317 600848 625245 610834 627772 595540 688474 825961 540831 533265 581250 549073 575046 584265 649039 655504 662015 669553 693691 712051 651996 655239 655252 657224 662794 686129 686924 694347 698879 716711 645484 648538 653686 658163 660326 664585 679515 696293 585264 588561 601479 606979 629170 640384 642534 597891 616665 620894 622479 625405 634036 590108 590845 608438 636885 641172 590815 616598 631063 747621 730332 773699 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.92%) |
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 398264 410264 410741 416668 448366 453952 460770 465803 466098 466237 472158 474994 476090 479758 479759 496082 496869 497420 498548 509588 514892 517990 521291 522970 523199 529357 533265 540831 540931 540975 541629 549073 568442 568531 575046 575635 581250 584265 585264 588561 590108 590815 590845 593581 594359 595540 597891 600848 601479 604655 606979 608438 610834 616598 616665 619171 620894 622479 625245 625405 627772 629170 631063 634036 636885 640384 641172 642534 645484 646123 648538 649039 651565 651996 653686 655239 655252 655504 656285 657224 658163 660317 660326 662015 662794 664585 668084 668098 669553 679515 680233 686129 686255 686924 688474 693618 693691 694347 695888 696293 698879 712051 716711 717241 718358 724339 725351 730332 730380 731347 738320 740726 741187 744891 747621 773699 783129 789633 800563 825961 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen cock"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen cock"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen cock"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.70%) |
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.