Query Metrics
7
Database Queries
7
Different statements
165.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.99 ms (86.03%) |
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 23524 378309 379330 384355 385095 385392 385705 387445 396578 407523 413633 429089 472225 519825 530140 530815 531915 536544 540887 543686 544690 545096 545790 548499 548513 553494 554882 566021 568959 587876 590727 604079 609570 622201 625818 627125 628152 630364 630877 643406 649542 650012 658005 659565 665352 666450 668389 668849 669433 672449 677738 681163 688483 690314 697324 703163 705011 705882 710260 713657 717408 718265 719150 719205 719240 719726 721024 724207 726594 727633 727958 728208 728761 729113 729244 731669 731880 732670 733374 739862 741118 742876 745164 746277 746315 746996 748337 751130 753957 754848 755419 756054 763771 771109 771538 788203 793409 793410 793714 798632 805308 808359 811045 815332 815874 816154 816475 816527 817663 817765 818157 818511 819168 819636 819797 820930 825120 826100 827963 ] |
||||||||||||||||||||||||||||||
|
12.76 ms (7.73%) |
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 732670 746996 703163 798632 23524 384355 819168 553494 545790 587876 379330 387445 697324 622201 748337 727633 724207 519825 590727 717408 378309 818511 815332 816154 817765 827963 530140 472225 548499 659565 668389 604079 625818 788203 793409 751130 755419 756054 385392 396578 819636 540887 815874 816527 825120 531915 543686 548513 554882 568959 544690 705011 668849 677738 721024 650012 658005 669433 681163 566021 628152 630364 609570 630877 643406 793410 793714 805308 728761 731669 746315 771109 811045 746277 754848 728208 733374 745164 729244 739862 763771 705882 816475 649542 710260 808359 742876 719150 824992 718265 688483 719205 719240 666450 713657 385705 385095 817663 530815 536544 545096 719726 665352 672449 690314 627125 729113 741118 753957 771538 727958 731880 407523 413633 429089 726594 826100 818157 819797 820930 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.54%) |
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 23524 378309 379330 384355 385095 385392 385705 387445 396578 407523 413633 429089 472225 519825 530140 530815 531915 536544 540887 543686 544690 545096 545790 548499 548513 553494 554882 566021 568959 587876 590727 604079 609570 622201 625818 627125 628152 630364 630877 643406 649542 650012 658005 659565 665352 666450 668389 668849 669433 672449 677738 681163 688483 690314 697324 703163 705011 705882 710260 713657 717408 718265 719150 719205 719240 719726 721024 724207 726594 727633 727958 728208 728761 729113 729244 731669 731880 732670 733374 739862 741118 742876 745164 746277 746315 746996 748337 751130 753957 754848 755419 756054 763771 771109 771538 788203 793409 793410 793714 798632 805308 808359 811045 815332 815874 816154 816475 816527 817663 817765 818157 818511 819168 819636 819797 820930 825120 826100 827963 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck cock"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cock"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cock"
]
|
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.