Query Metrics
7
Database Queries
7
Different statements
325.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
306.56 ms (94.26%) |
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 197574 311393 370332 385386 410428 435388 436462 461161 466333 470117 471486 499020 512592 517966 519330 525149 527819 532642 536245 540728 545029 548820 551622 553663 555077 557574 560263 561534 563252 571320 571993 573506 580990 589648 590537 591229 596559 601897 603752 617030 626328 637507 640905 649768 659350 659353 659381 660276 661921 662074 662776 664455 674603 675193 682943 695432 696395 696764 702629 702636 704955 705050 707786 710041 710822 713753 715964 717949 717977 718438 719109 719302 720083 723429 724887 726143 728756 731062 731160 731697 734465 740997 742768 743775 754253 755048 755918 756661 762994 763173 763733 765084 765100 766041 766361 767669 769443 770509 778748 779008 779973 780388 782969 785056 785422 786080 787308 787559 789483 789726 789859 790558 790701 790839 793653 793739 795575 796214 803685 806574 ] |
||||||||||||||||||||||||||||||
|
10.02 ms (3.08%) |
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 661921 705050 710822 720083 571993 765100 754253 743775 702629 806574 461161 410428 553663 718438 590537 591229 640905 499020 766041 197574 435388 470117 536245 512592 540728 517966 532642 551622 545029 560263 563252 675193 682943 717977 659353 664455 695432 696395 696764 715964 719302 660276 662074 707786 710041 717949 557574 589648 637507 601897 603752 779008 779973 780388 782969 789726 790701 793653 793739 785422 786080 787308 789483 789859 790839 803685 734465 755048 762994 769443 770509 785056 790558 795575 796214 763173 731062 742768 766361 767669 724887 726143 728756 731160 731697 740997 755918 756661 765084 702636 713753 723429 778748 385386 519330 561534 659350 466333 548820 662776 596559 617030 311393 370332 659381 573506 719109 674603 704955 525149 580990 571320 626328 471486 555077 649768 787559 763733 436462 527819 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.75%) |
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 197574 311393 370332 385386 410428 435388 436462 461161 466333 470117 471486 499020 512592 517966 519330 525149 527819 532642 536245 540728 545029 548820 551622 553663 555077 557574 560263 561534 563252 571320 571993 573506 580990 589648 590537 591229 596559 601897 603752 617030 626328 637507 640905 649768 659350 659353 659381 660276 661921 662074 662776 664455 674603 675193 682943 695432 696395 696764 702629 702636 704955 705050 707786 710041 710822 713753 715964 717949 717977 718438 719109 719302 720083 723429 724887 726143 728756 731062 731160 731697 734465 740997 742768 743775 754253 755048 755918 756661 762994 763173 763733 765084 765100 766041 766361 767669 769443 770509 778748 779008 779973 780388 782969 785056 785422 786080 787308 787559 789483 789726 789859 790558 790701 790839 793653 793739 795575 796214 803685 806574 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.45%) |
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.