Query Metrics
7
Database Queries
7
Different statements
162.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.63 ms (82.81%) |
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 282858 382051 387651 388177 389587 395278 395975 397535 398261 400382 410264 410776 413685 413695 414201 415235 417725 418035 424564 428870 430796 433216 445711 447690 448366 448520 450951 453355 453793 453794 453952 454534 454628 455585 458299 460769 462804 463948 468069 468085 474994 478908 510545 514995 516004 526259 529275 536264 536674 537669 537987 542042 543548 558031 558846 560656 561624 568169 573777 574889 575109 575204 592381 595467 595477 597536 604391 619171 626255 627740 630018 630234 659394 661263 665916 691992 709837 718719 721445 724193 725132 725151 727824 727827 728745 728755 731485 732000 732001 735951 735957 742144 742837 743232 743706 746075 746157 746979 747147 747576 748407 749343 749990 753262 753307 753333 753339 753360 753395 753411 753418 753854 753908 754182 755968 757915 760919 785772 793893 811164 ] |
||||||||||||||||||||||||||||||
|
18.63 ms (11.46%) |
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 595467 793893 785772 746157 747576 753307 753908 725132 725151 727827 735957 742144 746979 753411 753854 754182 746075 748407 755968 760919 724193 728745 728755 732000 735951 742837 747147 753262 753333 753339 753395 753418 757915 727824 731485 743232 749343 749990 753360 709837 718719 400382 410776 395278 389587 575109 542042 395975 382051 388177 398261 413695 417725 428870 430796 413685 414201 433216 424564 448520 450951 453794 463948 468069 453355 453793 453952 455585 458299 454534 454628 468085 536264 526259 537987 510545 516004 529275 536674 514995 537669 474994 478908 543548 561624 568169 574889 558031 558846 573777 575204 659394 661263 691992 665916 721445 560656 595477 597536 604391 619171 592381 627740 630234 811164 732001 743706 626255 630018 387651 415235 445711 447690 448366 460769 462804 282858 397535 410264 418035 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.70%) |
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 282858 382051 387651 388177 389587 395278 395975 397535 398261 400382 410264 410776 413685 413695 414201 415235 417725 418035 424564 428870 430796 433216 445711 447690 448366 448520 450951 453355 453793 453794 453952 454534 454628 455585 458299 460769 462804 463948 468069 468085 474994 478908 510545 514995 516004 526259 529275 536264 536674 537669 537987 542042 543548 558031 558846 560656 561624 568169 573777 574889 575109 575204 592381 595467 595477 597536 604391 619171 626255 627740 630018 630234 659394 661263 665916 691992 709837 718719 721445 724193 725132 725151 727824 727827 728745 728755 731485 732000 732001 735951 735957 742144 742837 743232 743706 746075 746157 746979 747147 747576 748407 749343 749990 753262 753307 753333 753339 753360 753395 753411 753418 753854 753908 754182 755968 757915 760919 785772 793893 811164 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen dick"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen член"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen член"
]
|
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.