Query Metrics
7
Database Queries
7
Different statements
592.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.71 ms (36.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy face"
]
|
||||||||||||||||||||||||||||||
|
213.93 ms (36.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy face"
]
|
||||||||||||||||||||||||||||||
|
142.47 ms (24.05%) |
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 354333 384065 385547 389236 390857 398444 418254 426467 426793 441798 457806 482615 487621 516981 521693 540183 548301 577558 595964 610797 629971 639986 670816 679499 680611 688880 689187 700900 703721 709383 713964 715741 722118 726325 726723 727505 727549 727550 728176 728178 728196 728203 729230 729278 734344 734358 734366 736755 740487 742830 742838 743965 744154 744158 744782 747489 747566 747822 748536 750377 752896 752942 757262 761279 761288 767479 767515 768896 774156 775596 775601 777133 780310 780372 780377 782764 782774 788217 788596 792197 792204 793763 794459 794462 794464 794481 795016 795035 795104 795885 800056 800082 800137 800182 800252 801167 801608 801616 802336 803256 804413 812316 812424 812429 813161 813172 813313 819143 819748 820198 823255 824954 824957 825159 825947 826489 826595 826619 826880 827286 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (2.13%) |
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 734344 819143 802336 728176 734366 780372 792204 354333 390857 824954 826619 820198 819748 540183 715741 722118 639986 775596 782764 727550 747489 750377 728178 729278 736755 729230 742830 795885 813313 680611 777133 794481 795104 803256 744158 782774 792197 426793 426467 767515 788596 728203 774156 747822 727549 768896 780310 801608 804413 823255 824957 826489 826595 825159 825947 827286 516981 521693 577558 709383 689187 610797 595964 780377 793763 800082 800182 795035 800056 761288 752896 742838 748536 757262 761279 794464 384065 389236 812429 398444 679499 788217 801167 813161 767479 728196 747566 813172 441798 418254 457806 487621 385547 826880 482615 548301 703721 713964 670816 688880 700900 629971 794462 800252 801616 812424 775601 800137 743965 794459 795016 812316 734358 726325 740487 752942 726723 727505 744154 744782 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (0.54%) |
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 354333 384065 385547 389236 390857 398444 418254 426467 426793 441798 457806 482615 487621 516981 521693 540183 548301 577558 595964 610797 629971 639986 670816 679499 680611 688880 689187 700900 703721 709383 713964 715741 722118 726325 726723 727505 727549 727550 728176 728178 728196 728203 729230 729278 734344 734358 734366 736755 740487 742830 742838 743965 744154 744158 744782 747489 747566 747822 748536 750377 752896 752942 757262 761279 761288 767479 767515 768896 774156 775596 775601 777133 780310 780372 780377 782764 782774 788217 788596 792197 792204 793763 794459 794462 794464 794481 795016 795035 795104 795885 800056 800082 800137 800182 800252 801167 801608 801616 802336 803256 804413 812316 812424 812429 813161 813172 813313 819143 819748 820198 823255 824954 824957 825159 825947 826489 826595 826619 826880 827286 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy in face"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.26%) |
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.