Query Metrics
7
Database Queries
7
Different statements
164.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.62 ms (84.44%) |
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 539328 540099 540103 540134 540574 541750 541783 541795 542431 542459 542724 543660 546218 546291 547412 547415 547445 549018 549034 550864 552608 553697 554572 554696 555205 555210 555761 558631 559295 561039 565260 572262 574001 574926 576482 576506 576562 577028 578718 579675 583301 586127 592833 595491 597227 597841 598193 599242 600778 605262 618144 622115 623343 628381 628592 629666 630572 632256 633523 633773 636644 637122 637438 639638 640046 641604 643706 643737 644663 647726 649348 649356 651144 651158 659472 664477 664492 668678 670448 671977 672685 675010 675503 676066 676111 677671 677784 678003 679280 679317 679757 679774 679863 680127 680138 680149 683262 689547 693504 702164 707971 709874 725392 733842 734038 734827 743993 744010 744551 744810 752622 757230 757257 786525 787858 788640 789678 790102 811873 814160 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (8.67%) |
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 630572 790102 640046 552608 632256 679774 558631 651144 679757 680138 693504 744551 540134 541783 543660 554696 542431 583301 554572 649356 670448 641604 599242 622115 623343 636644 639638 643706 743993 757230 811873 757257 789678 540103 547412 547445 549018 553697 576562 576482 542459 546291 547415 555205 555210 555761 561039 649348 651158 664477 668678 675503 546218 574926 600778 629666 592833 752622 744810 788640 539328 541750 576506 549034 579675 707971 586127 605262 595491 628592 744010 643737 559295 672685 676111 680149 677671 679317 597841 633523 675010 677784 540099 541795 577028 664492 647726 659472 671977 678003 679280 689547 572262 574001 644663 618144 734827 787858 578718 709874 679863 786525 702164 565260 597227 814160 542724 550864 680127 676066 683262 628381 637122 637438 598193 725392 733842 734038 633773 540574 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.02%) |
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 539328 540099 540103 540134 540574 541750 541783 541795 542431 542459 542724 543660 546218 546291 547412 547415 547445 549018 549034 550864 552608 553697 554572 554696 555205 555210 555761 558631 559295 561039 565260 572262 574001 574926 576482 576506 576562 577028 578718 579675 583301 586127 592833 595491 597227 597841 598193 599242 600778 605262 618144 622115 623343 628381 628592 629666 630572 632256 633523 633773 636644 637122 637438 639638 640046 641604 643706 643737 644663 647726 649348 649356 651144 651158 659472 664477 664492 668678 670448 671977 672685 675010 675503 676066 676111 677671 677784 678003 679280 679317 679757 679774 679863 680127 680138 680149 683262 689547 693504 702164 707971 709874 725392 733842 734038 734827 743993 744010 744551 744810 752622 757230 757257 786525 787858 788640 789678 790102 811873 814160 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг девушк"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss girl"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.