Query Metrics
7
Database Queries
7
Different statements
205.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.45 ms (86.80%) |
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 382377 382585 383225 383359 391662 392552 406569 415894 420450 422406 423482 454794 479189 497611 501909 504553 511235 515751 520004 522732 526947 530350 533572 541359 544231 544234 544955 545017 547352 548678 549278 549415 550739 552203 552373 553665 554711 554844 555017 558421 559020 559978 560900 562209 563830 567782 567960 570244 570873 571112 571917 572151 572391 572521 572551 573225 574025 575868 577409 579235 580747 584539 585660 596860 598973 603040 606800 607010 615171 621967 631396 642789 650126 650760 652553 654490 654574 654610 658409 662480 668733 674461 674909 675464 694607 712184 714104 722368 722543 724791 737140 738219 739871 742181 744261 750988 753630 764731 765985 768025 770325 779498 789285 790712 793583 795108 795109 798409 800587 801049 807391 808892 815327 815682 817495 819423 820896 827363 827989 828520 ] |
||||||||||||||||||||||||||||||
|
17.64 ms (8.58%) |
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 819423 571112 383359 828520 563830 615171 572151 392552 391662 383225 550739 573225 650760 658409 738219 742181 744261 739871 606800 815682 817495 530350 544955 574025 712184 668733 674461 642789 789285 572551 768025 423482 479189 497611 553665 555017 554711 598973 808892 454794 504553 522732 570244 584539 577409 580747 552373 559978 567782 570873 603040 815327 827363 820896 827989 533572 575868 560900 544231 652553 675464 779498 790712 795108 801049 765985 795109 750988 753630 764731 770325 722368 798409 549415 585660 526947 501909 511235 520004 579235 547352 650126 654574 654490 674909 596860 621967 607010 631396 793583 724791 800587 807391 420450 554844 406569 422406 382377 415894 382585 515751 559020 572521 541359 548678 572391 562209 567960 545017 737140 544234 558421 571917 549278 552203 694607 714104 722543 654610 662480 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.17%) |
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 382377 382585 383225 383359 391662 392552 406569 415894 420450 422406 423482 454794 479189 497611 501909 504553 511235 515751 520004 522732 526947 530350 533572 541359 544231 544234 544955 545017 547352 548678 549278 549415 550739 552203 552373 553665 554711 554844 555017 558421 559020 559978 560900 562209 563830 567782 567960 570244 570873 571112 571917 572151 572391 572521 572551 573225 574025 575868 577409 579235 580747 584539 585660 596860 598973 603040 606800 607010 615171 621967 631396 642789 650126 650760 652553 654490 654574 654610 658409 662480 668733 674461 674909 675464 694607 712184 714104 722368 722543 724791 737140 738219 739871 742181 744261 750988 753630 764731 765985 768025 770325 779498 789285 790712 793583 795108 795109 798409 800587 801049 807391 808892 815327 815682 817495 819423 820896 827363 827989 828520 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits shower"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ shower"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая сиськ shower"
]
|
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.