Query Metrics
7
Database Queries
7
Different statements
176.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.78 ms (84.72%) |
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 397111 420201 446111 451945 454362 457165 460697 462055 467310 467844 468610 480006 487019 491654 491664 503802 508777 509400 511707 511711 512247 512828 513284 515178 518520 519925 522565 522593 524694 524704 527859 529173 533522 533736 538576 538800 549584 550091 554365 556307 560478 562770 569523 571957 574874 574916 575066 575084 575097 575203 575454 575458 575486 575503 575748 575807 576028 576054 576063 576079 576100 576370 576371 576372 576406 576412 576646 577130 578173 579792 583984 584222 587929 588786 592314 594779 595869 596622 597593 597793 598821 599361 601994 605456 606816 607204 609568 610728 618561 624255 626154 626534 635225 637098 641120 644657 644959 649602 649830 653854 654552 655071 655358 655639 656058 657057 657287 657296 658082 659615 660963 661974 662143 698821 705875 705907 708476 720393 742449 788881 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (8.59%) |
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 503802 491664 599361 487019 518520 509400 538576 533736 538800 575084 575454 576406 574874 576028 576054 584222 655639 657057 653854 655071 708476 598821 595869 626534 597593 641120 624255 446111 480006 454362 524704 508777 519925 513284 524694 457165 549584 574916 576412 420201 468610 522593 529173 575066 575486 575503 575097 575203 576063 576370 578173 554365 575807 576371 576646 577130 656058 659615 649602 705875 560478 587929 601994 626154 594779 588786 610728 788881 637098 644657 705907 397111 511711 527859 491654 511707 512828 522565 657287 657296 655358 605456 596622 618561 451945 654552 658082 644959 512247 515178 533522 571957 575458 576100 569523 576372 583984 575748 649830 660963 661974 662143 698821 720393 550091 556307 562770 576079 579792 592314 635225 609568 606816 607204 597793 742449 462055 467844 467310 460697 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (2.24%) |
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 397111 420201 446111 451945 454362 457165 460697 462055 467310 467844 468610 480006 487019 491654 491664 503802 508777 509400 511707 511711 512247 512828 513284 515178 518520 519925 522565 522593 524694 524704 527859 529173 533522 533736 538576 538800 549584 550091 554365 556307 560478 562770 569523 571957 574874 574916 575066 575084 575097 575203 575454 575458 575486 575503 575748 575807 576028 576054 576063 576079 576100 576370 576371 576372 576406 576412 576646 577130 578173 579792 583984 584222 587929 588786 592314 594779 595869 596622 597593 597793 598821 599361 601994 605456 606816 607204 609568 610728 618561 624255 626154 626534 635225 637098 641120 644657 644959 649602 649830 653854 654552 655071 655358 655639 656058 657057 657287 657296 658082 659615 660963 661974 662143 698821 705875 705907 708476 720393 742449 788881 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд teen"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold teen"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.93%) |
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.