Query Metrics
7
Database Queries
7
Different statements
146.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.46 ms (84.90%) |
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 425341 432548 434008 438033 438091 438911 448765 450565 453520 455291 456121 456270 456433 461317 461779 462086 470589 470827 474931 478405 481318 483994 486027 492583 508255 511698 526011 527675 527894 528826 529423 536043 544947 545760 552352 552830 563555 564068 565636 566240 567370 590450 590555 593148 598182 598210 601945 603782 609679 612488 613812 616783 619538 620255 647108 657783 664451 668281 670010 675896 682831 685805 693841 699908 699950 700884 703926 710998 712353 717767 725286 727064 732154 737987 747877 751007 752137 754243 757120 757680 758338 763159 764776 765007 765100 770641 773865 777507 778496 778743 778983 779583 779748 781041 781100 781285 781575 782840 783817 791897 793123 799857 799858 802342 805141 809333 810733 812863 816178 817992 818104 818678 819871 819880 819953 820075 821799 825518 825556 ] |
||||||||||||||||||||||||||||||
|
12.35 ms (8.43%) |
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 620255 675896 693841 619538 805141 782840 752137 601945 819871 816178 819880 825556 818104 818678 819953 817992 820075 825518 544947 567370 566240 657783 703926 668281 685805 710998 712353 647108 664451 670010 682831 699950 700884 565636 590450 590555 598210 612488 616783 598182 777507 778743 781041 810733 779583 779748 781575 783817 799857 809333 737987 764776 765007 770641 773865 781285 793123 802342 757120 751007 754243 757680 763159 725286 747877 758338 603782 609679 613812 699908 778496 778983 781100 791897 456121 462086 470827 453520 456270 461317 461779 470589 478405 450565 527894 508255 511698 526011 593148 527675 552830 727064 432548 481318 434008 425341 438091 528826 529423 448765 438033 486027 545760 563555 552352 492583 821799 828561 536043 564068 717767 765100 732154 799858 812863 438911 455291 456433 474931 483994 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.43%) |
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 425341 432548 434008 438033 438091 438911 448765 450565 453520 455291 456121 456270 456433 461317 461779 462086 470589 470827 474931 478405 481318 483994 486027 492583 508255 511698 526011 527675 527894 528826 529423 536043 544947 545760 552352 552830 563555 564068 565636 566240 567370 590450 590555 593148 598182 598210 601945 603782 609679 612488 613812 616783 619538 620255 647108 657783 664451 668281 670010 675896 682831 685805 693841 699908 699950 700884 703926 710998 712353 717767 725286 727064 732154 737987 747877 751007 752137 754243 757120 757680 758338 763159 764776 765007 765100 770641 773865 777507 778496 778743 778983 779583 779748 781041 781100 781285 781575 782840 783817 791897 793123 799857 799858 802342 805141 809333 810733 812863 816178 817992 818104 818678 819871 819880 819953 820075 821799 825518 825556 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian handjob pov"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.91%) |
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.