Query Metrics
7
Database Queries
7
Different statements
180.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.33 ms (86.15%) |
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 381952 392554 423799 435647 436485 438010 446646 459874 460507 460581 460835 460856 461392 465921 466365 471599 472016 473290 476992 477605 479037 484115 490178 491089 492086 498247 506432 514608 521991 535406 540312 546573 547302 547903 549577 549661 553156 556187 558638 558998 560757 563299 564844 567411 567430 569433 576229 586203 588916 591201 595470 600773 606896 610421 613732 614424 615359 617376 623234 623735 625018 625456 636451 639825 640776 643361 643936 645626 660821 664495 668622 668650 670620 672896 674486 679306 681731 685547 690154 693675 698077 702512 703977 705642 712198 712869 717490 718768 724532 724861 726282 730934 740225 741082 756848 760309 761806 765859 765915 766239 768243 770595 775400 776753 777007 781519 785794 788901 789276 797794 798403 801227 802766 802827 803446 810028 811546 811963 813660 821771 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (8.25%) |
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 765915 785794 381952 821771 446646 460856 465921 461392 558998 617376 459874 724532 471599 476992 535406 712869 549577 660821 693675 670620 672896 674486 560757 586203 636451 615359 705642 477605 564844 569433 563299 473290 423799 498247 801227 770595 781519 789276 726282 765859 540312 547302 567430 643361 776753 797794 760309 766239 640776 506432 492086 547903 556187 685547 690154 613732 591201 521991 679306 625018 802766 623234 788901 802827 803446 811546 472016 479037 664495 466365 681731 558638 588916 810028 724861 730934 756848 435647 698077 514608 553156 668650 703977 712198 668622 600773 623735 606896 567411 491089 813660 610421 643936 775400 798403 768243 614424 639825 740225 460581 392554 436485 438010 460507 811963 484115 460835 546573 777007 741082 761806 718768 645626 595470 490178 549661 702512 717490 576229 625456 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.51%) |
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 381952 392554 423799 435647 436485 438010 446646 459874 460507 460581 460835 460856 461392 465921 466365 471599 472016 473290 476992 477605 479037 484115 490178 491089 492086 498247 506432 514608 521991 535406 540312 546573 547302 547903 549577 549661 553156 556187 558638 558998 560757 563299 564844 567411 567430 569433 576229 586203 588916 591201 595470 600773 606896 610421 613732 614424 615359 617376 623234 623735 625018 625456 636451 639825 640776 643361 643936 645626 660821 664495 668622 668650 670620 672896 674486 679306 681731 685547 690154 693675 698077 702512 703977 705642 712198 712869 717490 718768 724532 724861 726282 730934 740225 741082 756848 760309 761806 765859 765915 766239 768243 770595 775400 776753 777007 781519 785794 788901 789276 797794 798403 801227 802766 802827 803446 810028 811546 811963 813660 821771 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home amateurs sex"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
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.