Query Metrics
7
Database Queries
7
Different statements
179.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.69 ms (87.28%) |
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 69797 145343 154442 172662 237537 335993 382430 383576 385021 391977 392005 392508 399006 401048 474246 493272 497813 513570 513979 514215 531742 531876 534554 536091 536131 536167 536423 536465 537750 538063 540593 540924 540942 541043 541064 546171 550807 550923 550943 553789 554257 556874 556902 560570 564249 575378 575636 576439 576552 580062 582522 584048 586375 586409 592655 615357 618228 618238 618297 625784 634734 634741 642134 643191 643235 648696 651114 658788 661890 663218 666888 666905 671056 672913 672937 679577 697236 707577 710545 712097 712801 713157 714709 722385 722387 725755 734276 734417 734839 735135 735153 735743 740624 744412 748648 748659 753217 756505 766398 767462 785404 788193 792681 794322 794323 796768 796849 796878 797284 797285 800279 800764 802347 803483 808952 819861 827894 827927 827962 ] |
||||||||||||||||||||||||||||||
|
13.19 ms (7.35%) |
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 145343 172662 493272 514215 513979 383576 392508 335993 531742 536131 540593 536423 536465 575636 576439 556874 575378 541043 541064 712097 722387 648696 712801 666905 672913 672937 618238 642134 643191 618228 586375 615357 592655 796878 734417 734839 744412 808952 735743 756505 767462 735153 748648 740624 748659 766398 735135 753217 634741 697236 707577 785404 792681 800764 392005 391977 401048 237537 382430 679577 385021 154442 69797 399006 819861 827894 827927 827962 474246 536167 537750 497813 531876 534554 538063 513570 536091 550923 560570 540924 540942 553789 582522 550807 550943 556902 576552 661890 663218 666888 710545 651114 713157 658788 671056 714709 722385 546171 554257 564249 580062 584048 618297 625784 634734 586409 643235 794322 796768 797284 803483 794323 797285 800279 802347 734276 757736 788193 796849 725755 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.50%) |
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 69797 145343 154442 172662 237537 335993 382430 383576 385021 391977 392005 392508 399006 401048 474246 493272 497813 513570 513979 514215 531742 531876 534554 536091 536131 536167 536423 536465 537750 538063 540593 540924 540942 541043 541064 546171 550807 550923 550943 553789 554257 556874 556902 560570 564249 575378 575636 576439 576552 580062 582522 584048 586375 586409 592655 615357 618228 618238 618297 625784 634734 634741 642134 643191 643235 648696 651114 658788 661890 663218 666888 666905 671056 672913 672937 679577 697236 707577 710545 712097 712801 713157 714709 722385 722387 725755 734276 734417 734839 735135 735153 735743 740624 744412 748648 748659 753217 756505 766398 767462 785404 788193 792681 794322 794323 796768 796849 796878 797284 797285 800279 800764 802347 803483 808952 819861 827894 827927 827962 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme vagina"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор вагин"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.80%) |
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.