Query Metrics
7
Database Queries
7
Different statements
184.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.62 ms (84.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 389770 403099 404345 472763 500173 547972 548046 548665 548773 549334 550408 550453 550628 550727 550739 551182 551198 551980 552387 552677 552685 552874 553469 558131 559020 559869 560469 560610 561707 561734 562220 562321 564051 564067 564608 566224 566923 567188 568564 570010 570232 570259 570274 570311 570620 571558 571579 572378 572383 572450 573090 573712 573718 573791 574507 574865 574899 575085 575776 576410 578384 578409 584061 585804 585990 589784 589796 597078 597583 597811 598033 598086 600981 603727 604101 604760 621451 621662 623009 623542 631167 637520 654178 654732 655116 656962 657096 657366 657443 657573 657925 658346 658400 659113 659122 659836 666611 667747 668842 671141 671325 672368 673551 675462 679057 692050 698101 702939 723392 725640 730713 740325 753904 754505 761459 771772 780485 792763 803180 827161 ] |
||||||||||||||||||||||||||||||
|
17.81 ms (9.65%) |
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 698101 570274 552874 575776 550453 559020 573712 575085 550408 561707 570010 573791 597078 404345 552677 572378 659113 675462 679057 566923 604760 550727 692050 761459 671325 573090 548773 560610 637520 568564 597583 657925 659836 550739 631167 621451 803180 621662 561734 547972 623009 603727 562220 567188 570620 553469 548665 702939 725640 566224 578384 571558 574507 667747 574865 597811 549334 576410 572450 668842 672368 792763 560469 598086 780485 585990 827161 572383 657096 657443 657573 658346 658400 671141 673551 656962 657366 659122 666611 654732 655116 723392 740325 753904 771772 730713 552387 472763 389770 562321 570232 654178 570259 548046 623542 551198 551182 552685 564051 584061 573718 571579 589796 600981 598033 403099 574899 754505 585804 570311 604101 500173 550628 564608 564067 589784 551980 578409 558131 559869 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.52%) |
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 389770 403099 404345 472763 500173 547972 548046 548665 548773 549334 550408 550453 550628 550727 550739 551182 551198 551980 552387 552677 552685 552874 553469 558131 559020 559869 560469 560610 561707 561734 562220 562321 564051 564067 564608 566224 566923 567188 568564 570010 570232 570259 570274 570311 570620 571558 571579 572378 572383 572450 573090 573712 573718 573791 574507 574865 574899 575085 575776 576410 578384 578409 584061 585804 585990 589784 589796 597078 597583 597811 598033 598086 600981 603727 604101 604760 621451 621662 623009 623542 631167 637520 654178 654732 655116 656962 657096 657366 657443 657573 657925 658346 658400 659113 659122 659836 666611 667747 668842 671141 671325 672368 673551 675462 679057 692050 698101 702939 723392 725640 730713 740325 753904 754505 761459 771772 780485 792763 803180 827161 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small girl blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.