Query Metrics
7
Database Queries
7
Different statements
393.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.43 ms (53.46%) |
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 391762 398009 400620 420405 421762 449222 449800 458127 465486 489258 493402 500067 509163 516488 536145 538619 540805 541559 546893 562984 567655 574157 575627 588531 596533 599464 607253 616509 616569 624592 639681 644276 650728 651977 656631 662889 675494 675613 677191 687463 689040 696104 696113 698735 699519 699543 700689 704138 704840 706895 714383 714953 715407 719113 726313 728373 734268 734620 735900 736727 738514 738911 740166 741318 746536 747982 750129 751213 755172 756972 757914 759008 759874 760278 761546 763832 763922 769201 771894 773682 776216 777109 778079 778604 779889 781136 783379 785684 786089 786101 787040 787280 787282 787769 788918 790298 791247 791411 794109 794439 794715 794724 795236 795669 796022 796051 796117 796199 797174 797473 801051 802520 808774 808856 809985 810114 813537 824972 ] |
||||||||||||||||||||||||||||||
|
164.04 ms (41.67%) |
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 391762 398009 400620 420405 421762 449222 449800 458127 465486 489258 493402 500067 509163 516488 536145 538619 540805 541559 546893 562984 567655 574157 575627 588531 596533 599464 607253 616509 616569 624592 639681 644276 650728 651977 656631 662889 675494 675613 677191 687463 689040 696104 696113 698735 699519 699543 700689 704138 704840 706895 714383 714953 715407 719113 726313 728373 734268 734620 735900 736727 738514 738911 740166 741318 746536 747982 750129 751213 755172 756972 757914 759008 759874 760278 761546 763832 763922 769201 771894 773682 776216 777109 778079 778604 779889 781136 783379 785684 786089 786101 787040 787280 787282 787769 788918 790298 791247 791411 794109 794439 794715 794724 795236 795669 796022 796051 796117 796199 797174 797473 801051 802520 808774 808856 809985 810114 813537 824972 ] |
||||||||||||||||||||||||||||||
|
12.16 ms (3.09%) |
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 795236 808856 726313 746536 771894 735900 747982 755172 763832 773682 777182 787769 489258 493402 400620 420405 449800 536145 567655 575627 574157 541559 651977 677191 715407 689040 696113 704138 714383 719113 675613 704840 596533 639681 599464 624592 776216 777109 778604 785684 790298 794715 802520 778079 779889 786089 794109 796051 786101 791411 797473 809985 810114 734268 756972 728373 738911 750129 759008 769201 741318 761546 700689 787040 794724 796117 398009 540805 465486 449222 500067 516488 644276 391762 421762 824972 458127 509163 538619 546893 562984 656631 699519 650728 687463 696104 698735 662889 675494 699543 706895 714953 607253 616509 588531 616569 781136 787280 791247 796022 797174 788918 794439 796199 801051 808774 813537 734988 760278 783379 787282 795669 734620 738514 736727 757914 763922 751213 759874 740166 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in creampie"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum creampie"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum creampie"
]
|
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.