Query Metrics
7
Database Queries
7
Different statements
174.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.57 ms (78.89%) |
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 118226 381903 391756 396130 401189 401768 403973 414292 414601 415964 416537 416718 416738 419891 424581 427539 428179 428223 428255 429859 435539 439056 440016 440032 440041 440052 441093 441124 441131 444281 446797 451775 452637 456240 459203 459659 460209 471696 473450 474265 478510 486767 487416 488713 492181 493749 497480 502457 505137 505800 507956 508882 508916 509422 510807 512941 515053 515435 519722 527920 530310 531789 534119 534540 534555 534566 534567 535438 541278 541322 541755 543897 544140 547236 547466 547481 547494 547854 556338 556876 556884 561021 561038 571166 573197 574951 576493 592576 597163 605725 605745 618276 619102 624925 630564 641997 656186 656921 660362 660399 665957 669067 671044 680785 695870 710709 715790 738814 742353 745125 752626 761176 782790 788181 797197 800282 806437 817221 827326 827721 ] |
||||||||||||||||||||||||||||||
|
26.69 ms (15.30%) |
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 428179 597163 509422 715790 512941 441131 671044 695870 497480 541755 576493 817221 742353 401189 680785 486767 515435 605745 605725 534540 543897 547854 656921 435539 416718 534566 531789 782790 806437 745125 618276 788181 800282 473450 535438 571166 544140 547236 797197 761176 419891 452637 460209 547466 556876 515053 738814 440041 429859 414292 440016 541278 547481 556338 547494 561038 573197 660399 752626 827326 541322 391756 381903 441124 471696 493749 415964 530310 556884 641997 502457 510807 428223 478510 527920 669067 451775 403973 459659 396130 656186 660362 592576 534555 444281 446797 665957 561021 456240 710709 508916 574951 508882 827721 488713 441093 416738 427539 428255 439056 519722 505137 630564 424581 505800 507956 474265 534119 401768 624925 118226 416537 414601 487416 534567 459203 619102 440032 440052 492181 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.59%) |
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 118226 381903 391756 396130 401189 401768 403973 414292 414601 415964 416537 416718 416738 419891 424581 427539 428179 428223 428255 429859 435539 439056 440016 440032 440041 440052 441093 441124 441131 444281 446797 451775 452637 456240 459203 459659 460209 471696 473450 474265 478510 486767 487416 488713 492181 493749 497480 502457 505137 505800 507956 508882 508916 509422 510807 512941 515053 515435 519722 527920 530310 531789 534119 534540 534555 534566 534567 535438 541278 541322 541755 543897 544140 547236 547466 547481 547494 547854 556338 556876 556884 561021 561038 571166 573197 574951 576493 592576 597163 605725 605745 618276 619102 624925 630564 641997 656186 656921 660362 660399 665957 669067 671044 680785 695870 710709 715790 738814 742353 745125 752626 761176 782790 788181 797197 800282 806437 817221 827326 827721 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fisting amateur"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг любительск"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
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.