Query Metrics
7
Database Queries
7
Different statements
154.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.85 ms (83.94%) |
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 391923 391959 391994 392025 398979 418521 418714 419619 427100 429860 429879 429886 434325 435355 435874 455373 456045 459472 461944 464053 465841 466402 466405 466630 467876 467905 467923 470024 470143 474214 474323 479148 488887 489087 493961 494598 496506 499836 501476 502497 505326 506092 509430 513528 517881 519309 519753 525355 525468 525884 527258 528544 533156 533719 537237 543640 544527 544874 550125 560692 560828 571360 571707 577433 578169 578323 579510 592573 592985 596792 599239 599354 601566 602215 609071 609623 632683 632849 641807 661539 678716 680791 680801 680806 680809 685758 686494 686549 711749 714468 714476 714487 730795 732165 735958 740384 742336 745335 754656 766349 768805 783352 788753 793011 793023 800657 802241 803404 803479 806730 806986 807884 813963 824530 824733 824837 825560 825771 826706 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (9.84%) |
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 571707 714487 685758 560828 641807 599239 596792 732165 609623 459472 466405 398979 525355 527258 601566 544527 579510 435874 506092 513528 543640 577433 429860 429886 435355 479148 592573 826706 537237 544874 686494 680801 686549 788753 800657 802241 803479 742336 735958 745335 560692 578169 391994 466630 429879 466402 502497 505326 494598 550125 533719 632849 602215 519753 678716 714476 592985 599354 796642 509430 525468 470143 474323 470024 813963 824530 824733 680806 680809 661539 632683 803404 754656 730795 766349 711749 807884 391923 467923 391959 467876 496506 456045 418714 461944 489087 517881 519309 493961 525884 474214 501476 825560 825771 824837 571360 680791 806986 783352 740384 768805 793011 793023 806730 392025 465841 533156 609071 418521 419619 467905 434325 455373 464053 427100 499836 528544 714468 578323 488887 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.69%) |
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 391923 391959 391994 392025 398979 418521 418714 419619 427100 429860 429879 429886 434325 435355 435874 455373 456045 459472 461944 464053 465841 466402 466405 466630 467876 467905 467923 470024 470143 474214 474323 479148 488887 489087 493961 494598 496506 499836 501476 502497 505326 506092 509430 513528 517881 519309 519753 525355 525468 525884 527258 528544 533156 533719 537237 543640 544527 544874 550125 560692 560828 571360 571707 577433 578169 578323 579510 592573 592985 596792 599239 599354 601566 602215 609071 609623 632683 632849 641807 661539 678716 680791 680801 680806 680809 685758 686494 686549 711749 714468 714476 714487 730795 732165 735958 740384 742336 745335 754656 766349 768805 783352 788753 793011 793023 800657 802241 803404 803479 806730 806986 807884 813963 824530 824733 824837 825560 825771 826706 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hairy solo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск волосатая соло"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.02%) |
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.