Query Metrics
7
Database Queries
7
Different statements
358.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.10 ms (61.93%) |
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 382662 78620 78637 53437 32874 14477 7108 1061 388392 388673 388951 389193 387295 387529 396710 401519 415872 824568 819743 822630 824331 827849 827854 828157 827855 827873 827896 472885 477461 459325 473514 483573 517719 519182 529701 530397 534831 529732 531557 531614 532708 534855 540497 538566 540412 546274 547361 577493 582057 583305 556130 558777 559494 571015 581252 581974 540929 557604 564247 566583 575954 646240 648609 652691 654205 660023 664532 678241 696237 696983 651227 653753 653807 664151 685280 696134 698959 708052 719817 654293 662136 682235 690737 693153 704179 720395 544793 583540 584944 592261 603621 605587 606864 606878 610005 626571 629510 630668 633999 635484 641543 591591 597870 600930 604566 632928 633042 633238 638033 639328 639967 596484 601930 604452 604705 624355 626792 636369 637765 585543 ] |
||||||||||||||||||||||||||||||
|
125.09 ms (34.88%) |
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 1061 7108 14477 32874 53437 78620 78637 382662 387295 387529 388392 388673 388951 389193 396710 401519 415872 459325 472885 473514 477461 483573 517719 519182 529701 529732 530397 531557 531614 532708 534831 534855 538566 540412 540497 540929 544793 546274 547361 556130 557604 558777 559494 564247 566583 571015 575954 577493 581252 581974 582057 583305 583540 584944 585543 591591 592261 596484 597870 600930 601930 603621 604452 604566 604705 605587 606864 606878 610005 624355 626571 626792 629510 630668 632928 633042 633238 633999 635484 636369 637765 638033 639328 639967 641543 646240 648609 651227 652691 653753 653807 654205 654293 660023 662136 664151 664532 678241 682235 685280 690737 693153 696134 696237 696983 698959 704179 708052 719817 720395 819743 822630 824331 824568 827849 827854 827855 827873 827896 828157 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (1.02%) |
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 1061 7108 14477 32874 53437 78620 78637 382662 387295 387529 388392 388673 388951 389193 396710 401519 415872 459325 472885 473514 477461 483573 517719 519182 529701 529732 530397 531557 531614 532708 534831 534855 538566 540412 540497 540929 544793 546274 547361 556130 557604 558777 559494 564247 566583 571015 575954 577493 581252 581974 582057 583305 583540 584944 585543 591591 592261 596484 597870 600930 601930 603621 604452 604566 604705 605587 606864 606878 610005 624355 626571 626792 629510 630668 632928 633042 633238 633999 635484 636369 637765 638033 639328 639967 641543 646240 648609 651227 652691 653753 653807 654205 654293 660023 662136 664151 664532 678241 682235 685280 690737 693153 696134 696237 696983 698959 704179 708052 719817 720395 819743 822630 824331 824568 827849 827854 827855 827873 827896 828157 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial doggy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов рак"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.