Query Metrics
7
Database Queries
7
Different statements
145.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.62 ms (83.63%) |
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 541750 541788 541790 541795 541798 542454 542720 542724 544244 547416 547441 549034 549037 550201 550786 550864 552608 554572 554683 554686 554707 555315 555967 559295 559423 563591 564281 570159 575253 576506 577026 577028 579675 581557 585802 595699 597841 598193 599242 599911 599934 614201 618422 620911 622115 623343 627951 628381 629646 630572 631879 632256 633523 633773 636644 637122 637438 639638 640046 641604 642103 643013 643689 643706 649356 649442 651144 655531 664492 668518 670448 670450 671986 672685 672759 676066 676111 677671 678776 679317 679757 680127 680138 680149 683262 693504 709444 710786 716600 718782 719435 724731 725392 725539 727510 733381 733842 734038 734706 740835 743993 746102 746646 757230 757257 763741 789616 789678 790102 795951 795990 796075 800226 810075 810083 811873 823943 827278 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.48%) |
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 550786 554572 649356 670448 671986 678776 649442 672759 655531 670450 710786 716600 547441 554686 575253 585802 630572 641604 642103 599242 614201 622115 629646 631879 620911 623343 627951 636644 639638 643689 643706 795990 789616 790102 796075 800226 733381 743993 757230 810083 811873 724731 727510 734706 757257 725539 746646 740835 746102 618422 640046 789678 795951 810075 542724 552608 555967 559295 550201 550864 570159 651144 672685 676111 680149 677671 679317 679757 680127 680138 693504 668518 676066 683262 563591 599911 599934 628381 595699 637122 637438 597841 598193 633523 725392 733842 763741 734038 632256 633773 643013 718782 823943 827278 539328 540099 541750 541790 541798 542720 549037 554707 564281 576506 577026 541788 542454 544244 547416 549034 581557 541795 554683 555315 559423 577028 579675 664492 709444 719435 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.18%) |
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 541750 541788 541790 541795 541798 542454 542720 542724 544244 547416 547441 549034 549037 550201 550786 550864 552608 554572 554683 554686 554707 555315 555967 559295 559423 563591 564281 570159 575253 576506 577026 577028 579675 581557 585802 595699 597841 598193 599242 599911 599934 614201 618422 620911 622115 623343 627951 628381 629646 630572 631879 632256 633523 633773 636644 637122 637438 639638 640046 641604 642103 643013 643689 643706 649356 649442 651144 655531 664492 668518 670448 670450 671986 672685 672759 676066 676111 677671 678776 679317 679757 680127 680138 680149 683262 693504 709444 710786 716600 718782 719435 724731 725392 725539 727510 733381 733842 734038 734706 740835 743993 746102 746646 757230 757257 763741 789616 789678 790102 795951 795990 796075 800226 810075 810083 811873 823943 827278 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss and"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.00%) |
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.