Query Metrics
7
Database Queries
7
Different statements
161.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.13 ms (80.98%) |
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 382232 393284 401935 417069 417756 418005 429232 440745 440877 443548 445038 446139 447097 448177 450648 451629 455641 456857 457070 457321 462292 466382 466676 472019 472552 473851 475604 476564 477156 478711 482490 483992 486494 490440 491010 491372 491600 497653 506514 506551 506552 506557 507172 509784 516996 523707 523934 523940 524598 524648 525062 525963 526759 526974 527665 532377 534568 534571 534862 535008 537274 537306 542321 551949 552646 557744 559324 559370 562035 562043 563334 564445 567130 567161 570271 571221 575257 577637 577953 580642 580648 581001 582514 582722 583770 584061 587164 587431 592093 594167 594505 595330 598745 599777 599791 603019 604943 613415 619132 644764 649830 649845 649857 659297 662391 667232 680400 692581 731437 734383 758268 765794 773582 782301 788046 793901 803837 811955 811964 828071 ] |
||||||||||||||||||||||||||||||
|
21.17 ms (13.08%) |
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 598745 734383 393284 559370 599777 526759 446139 524648 527665 582514 575257 567161 567130 603019 577637 537306 537274 525062 583770 599791 562043 692581 551949 571221 581001 758268 782301 584061 793901 478711 440877 680400 649845 592093 594167 491010 542321 466382 451629 649857 472552 475604 506552 417756 577953 773582 523940 440745 482490 457321 563334 580648 445038 466676 447097 523934 587164 448177 552646 497653 455641 456857 604943 418005 417069 765794 382232 570271 401935 662391 476564 472019 534862 491600 507172 595330 619132 486494 828071 649830 535008 491372 483992 559324 667232 564445 582722 506551 613415 450648 811964 811955 534571 525963 587431 803837 788046 473851 429232 516996 534568 462292 594505 523707 659297 490440 562035 557744 443548 731437 580642 509784 506557 644764 532377 477156 506514 526974 524598 457070 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.79%) |
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 382232 393284 401935 417069 417756 418005 429232 440745 440877 443548 445038 446139 447097 448177 450648 451629 455641 456857 457070 457321 462292 466382 466676 472019 472552 473851 475604 476564 477156 478711 482490 483992 486494 490440 491010 491372 491600 497653 506514 506551 506552 506557 507172 509784 516996 523707 523934 523940 524598 524648 525062 525963 526759 526974 527665 532377 534568 534571 534862 535008 537274 537306 542321 551949 552646 557744 559324 559370 562035 562043 563334 564445 567130 567161 570271 571221 575257 577637 577953 580642 580648 581001 582514 582722 583770 584061 587164 587431 592093 594167 594505 595330 598745 599777 599791 603019 604943 613415 619132 644764 649830 649845 649857 659297 662391 667232 680400 692581 731437 734383 758268 765794 773582 782301 788046 793901 803837 811955 811964 828071 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public hard fuck"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на hard улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на hard улиц секс"
]
|
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.