Query Metrics
7
Database Queries
7
Different statements
198.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.82 ms (85.05%) |
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 40927 81734 88549 315244 395780 397879 403319 406176 410686 416470 416597 419282 423663 424001 432929 441070 443920 448773 454282 457217 459718 466416 467952 469636 470470 475646 477038 480251 483705 483777 489676 502269 514434 514994 519214 522264 522935 524094 530372 530423 534257 536604 541322 542422 547772 555075 555089 556483 557685 558190 566784 567508 568449 580182 580188 580189 580193 580194 583714 584843 597111 598540 599102 606677 616085 619286 622352 631358 637654 638674 638744 640052 649008 650476 674077 682739 686371 697610 703619 712580 715584 720145 723660 739131 739145 739558 739827 739946 740841 745328 745359 747155 752613 752643 752700 753023 753198 754456 760238 760563 768692 772213 773040 780356 785982 788939 790192 792715 793683 795731 796692 805033 806788 806828 807568 807570 809660 812058 817173 822298 ] |
||||||||||||||||||||||||||||||
|
18.63 ms (9.39%) |
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 715584 682739 780356 785982 788939 793683 760238 739827 477038 480251 640052 773040 740841 556483 40927 583714 638674 410686 650476 752700 483777 598540 584843 88549 475646 441070 524094 542422 580182 580194 555089 566784 805033 753023 514994 580193 703619 720145 712580 555075 606677 597111 637654 631358 807568 795731 745328 752643 739946 739558 747155 768692 752613 792715 806788 812058 459718 443920 315244 423663 483705 467952 470470 558190 619286 424001 403319 454282 519214 489676 514434 522264 81734 457217 466416 599102 419282 567508 649008 697610 807570 790192 796692 809660 772213 754456 745359 760563 753198 806828 674077 622352 416597 638744 739131 739145 547772 616085 395780 397879 406176 416470 432929 723660 822298 817173 448773 469636 530423 502269 522935 536604 530372 534257 557685 580189 541322 580188 568449 686371 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.82%) |
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 40927 81734 88549 315244 395780 397879 403319 406176 410686 416470 416597 419282 423663 424001 432929 441070 443920 448773 454282 457217 459718 466416 467952 469636 470470 475646 477038 480251 483705 483777 489676 502269 514434 514994 519214 522264 522935 524094 530372 530423 534257 536604 541322 542422 547772 555075 555089 556483 557685 558190 566784 567508 568449 580182 580188 580189 580193 580194 583714 584843 597111 598540 599102 606677 616085 619286 622352 631358 637654 638674 638744 640052 649008 650476 674077 682739 686371 697610 703619 712580 715584 720145 723660 739131 739145 739558 739827 739946 740841 745328 745359 747155 752613 752643 752700 753023 753198 754456 760238 760563 768692 772213 773040 780356 785982 788939 790192 792715 793683 795731 796692 805033 806788 806828 807568 807570 809660 812058 817173 822298 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm dildo"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм дилд"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм дилд"
]
|
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.