Query Metrics
7
Database Queries
7
Different statements
207.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.86 ms (88.32%) |
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 381951 386913 397886 401820 404762 417457 419535 420487 421327 429292 429570 442647 443674 450649 451455 451509 452642 463698 466394 466653 467550 467873 468462 470306 470487 470936 471600 474076 474496 474582 477961 477966 477970 477994 478074 478487 480760 482782 484705 484718 486492 488365 490897 496097 500415 501611 501622 502001 502843 503837 503992 507263 509206 511023 512717 515676 516801 520889 521596 522200 522624 541642 543609 544504 547570 547890 548016 548517 548907 551063 554321 555017 555020 555114 555131 557742 558297 559233 562190 563203 565039 567097 569919 572605 574755 578492 583468 592450 596286 599867 600019 600171 600348 603364 607707 610857 620215 661977 665932 689621 710549 714159 715370 719940 725334 725375 729886 741094 744915 769217 769223 780540 785970 800085 802856 808707 815121 815545 817163 826469 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (6.87%) |
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 599867 600171 607707 600019 503837 507263 548016 452642 555114 477966 484705 501611 512717 541642 470306 815545 815121 478074 443674 463698 474496 478487 555131 420487 467550 509206 386913 496097 421327 482782 715370 725334 729886 442647 620215 554321 592450 471600 466653 744915 450649 470936 417457 451455 826469 817163 477970 689621 780540 800085 802856 725375 710549 719940 785970 543609 714159 741094 501622 474076 480760 555020 547890 569919 397886 404762 477961 419535 488365 502843 503992 484718 490897 665932 583468 548907 551063 557742 578492 600348 559233 522200 470487 474582 486492 467873 468462 466394 502001 520889 516801 429292 603364 808707 562190 477994 521596 661977 511023 572605 548517 565039 547570 567097 596286 429570 769223 769217 381951 451509 522624 500415 515676 544504 555017 558297 563203 574755 610857 401820 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.31%) |
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 381951 386913 397886 401820 404762 417457 419535 420487 421327 429292 429570 442647 443674 450649 451455 451509 452642 463698 466394 466653 467550 467873 468462 470306 470487 470936 471600 474076 474496 474582 477961 477966 477970 477994 478074 478487 480760 482782 484705 484718 486492 488365 490897 496097 500415 501611 501622 502001 502843 503837 503992 507263 509206 511023 512717 515676 516801 520889 521596 522200 522624 541642 543609 544504 547570 547890 548016 548517 548907 551063 554321 555017 555020 555114 555131 557742 558297 559233 562190 563203 565039 567097 569919 572605 574755 578492 583468 592450 596286 599867 600019 600171 600348 603364 607707 610857 620215 661977 665932 689621 710549 714159 715370 719940 725334 725375 729886 741094 744915 769217 769223 780540 785970 800085 802856 808707 815121 815545 817163 826469 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелые маленькая груд…"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"зрелая женщин маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
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.