Query Metrics
7
Database Queries
7
Different statements
159.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.03 ms (85.02%) |
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 382434 386866 390728 390945 406688 411350 411708 411781 411973 418059 450104 451488 457991 460618 464521 466015 466238 466278 469509 471405 471421 472628 474810 474843 476279 476343 476352 479053 483108 484393 484437 484443 484578 485755 485916 487315 490193 490406 502724 517013 518849 525528 526526 532706 536456 537484 539789 546687 549846 552286 554321 555077 557137 558013 565134 579613 591133 601869 604494 618780 665254 665264 665302 665406 665471 665853 666111 666993 667207 667319 667607 667772 668881 668901 672410 696415 702179 707476 710531 712215 720290 720599 721693 724702 725135 726576 726861 728237 728340 730094 732258 735484 736408 738000 738070 739686 739948 742433 742970 744804 746168 746619 746636 748219 748337 752949 760738 760976 761012 770120 770866 774331 794629 801319 807539 808152 816784 820309 824265 826246 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (9.07%) |
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 728340 746619 760738 532706 390945 667607 557137 738000 739686 820309 824265 702179 720290 665406 666111 760976 746168 732258 665853 668901 665302 665471 726576 748219 411973 721693 667207 591133 794629 770866 411708 725135 712215 457991 451488 418059 816784 826246 518849 483108 554321 696415 558013 565134 801319 807539 484393 479053 552286 549846 579613 466238 464521 485916 526526 536456 476343 411350 466015 487315 517013 382434 748337 525528 726861 770120 466278 484437 471405 406688 736408 460618 618780 472628 476352 484578 386866 474843 601869 724702 728237 735484 742433 761012 710531 720599 390728 490193 502724 411781 474810 471421 707476 746636 485755 490406 484443 672410 730094 539789 476279 666993 774331 744804 742970 604494 450104 665264 469509 546687 555077 667772 739948 738070 537484 665254 667319 808152 752949 668881 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.83%) |
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 382434 386866 390728 390945 406688 411350 411708 411781 411973 418059 450104 451488 457991 460618 464521 466015 466238 466278 469509 471405 471421 472628 474810 474843 476279 476343 476352 479053 483108 484393 484437 484443 484578 485755 485916 487315 490193 490406 502724 517013 518849 525528 526526 532706 536456 537484 539789 546687 549846 552286 554321 555077 557137 558013 565134 579613 591133 601869 604494 618780 665254 665264 665302 665406 665471 665853 666111 666993 667207 667319 667607 667772 668881 668901 672410 696415 702179 707476 710531 712215 720290 720599 721693 724702 725135 726576 726861 728237 728340 730094 732258 735484 736408 738000 738070 739686 739948 742433 742970 744804 746168 746619 746636 748219 748337 752949 760738 760976 761012 770120 770866 774331 794629 801319 807539 808152 816784 820309 824265 826246 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock mature"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock mature"
]
|
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.