Query Metrics
7
Database Queries
7
Different statements
187.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.97 ms (89.36%) |
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 116701 386266 536068 539290 544807 548042 563240 566447 567933 573915 577510 578909 579075 579570 579752 584207 585622 589298 591705 594552 594558 594573 594581 595502 599090 602542 603368 605632 606785 606853 609507 609512 610124 615171 615404 616649 616672 619261 624100 624647 627273 629143 632930 634331 635018 635850 638493 638796 642381 642538 643213 643267 644743 645504 647067 648053 648905 649032 650970 652315 653080 653117 653368 654006 654253 654272 656559 656856 657491 660442 661609 665631 671892 676741 677192 679282 679590 686726 691538 694417 695581 695585 700240 702371 703824 708742 709487 711112 714834 715638 730181 735003 736062 740772 750860 752057 762898 764755 765957 774032 778084 790103 795223 795680 796000 817599 818401 819818 820138 820193 823718 823741 824485 824494 824819 826271 826731 827034 828165 828549 ] |
||||||||||||||||||||||||||||||
|
10.49 ms (5.58%) |
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 647067 648053 656559 661609 676741 679282 695581 695585 702371 715638 649032 650970 652315 653117 656856 657491 665631 677192 679590 703824 711112 645504 653080 654272 700240 548042 563240 578909 579752 584207 603368 616672 585622 599090 609507 615404 619261 638796 644743 591705 616649 624100 635018 642538 643213 589298 595502 610124 615171 627273 638493 642381 643267 795223 796000 740772 774032 790103 730181 765957 735003 736062 752057 764755 762898 602542 624647 629143 634331 579570 594573 577510 653368 708742 660442 691538 654006 694417 594581 605632 594558 606785 606853 609512 594552 632930 635850 709487 386266 819818 116701 820138 826271 820193 567933 671892 686726 750860 566447 778084 795680 823718 823741 824485 826731 827034 817599 818401 824494 824819 828165 828549 536068 539290 579075 544807 573915 714834 648905 654253 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.47%) |
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 116701 386266 536068 539290 544807 548042 563240 566447 567933 573915 577510 578909 579075 579570 579752 584207 585622 589298 591705 594552 594558 594573 594581 595502 599090 602542 603368 605632 606785 606853 609507 609512 610124 615171 615404 616649 616672 619261 624100 624647 627273 629143 632930 634331 635018 635850 638493 638796 642381 642538 643213 643267 644743 645504 647067 648053 648905 649032 650970 652315 653080 653117 653368 654006 654253 654272 656559 656856 657491 660442 661609 665631 671892 676741 677192 679282 679590 686726 691538 694417 695581 695585 700240 702371 703824 708742 709487 711112 714834 715638 730181 735003 736062 740772 750860 752057 762898 764755 765957 774032 778084 790103 795223 795680 796000 817599 818401 819818 820138 820193 823718 823741 824485 824494 824819 826271 826731 827034 828165 828549 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dogging amateur wife"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dogging любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dogging любительск жен"
]
|
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.