Query Metrics
7
Database Queries
7
Different statements
152.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.90 ms (83.99%) |
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 159305 188266 386987 387149 390447 395465 398561 408978 413004 424248 425149 426550 428051 439758 442634 448696 450181 452254 452856 453135 456036 458449 459643 460338 460438 460533 460762 462085 462095 462105 462183 464534 464965 465317 465385 466147 466341 466790 467055 469614 470762 472555 472700 475897 476164 476341 477718 478339 478790 479084 479128 482951 484375 485751 485764 485937 485939 485942 485950 487364 490394 495238 498290 498457 499712 514902 515086 516653 518844 518862 519386 520094 520660 527947 529380 534579 536481 537824 538064 538530 538912 539593 543924 545964 545968 547536 549223 549776 551886 552062 552063 554839 558173 561439 575677 582799 590289 592883 593070 594933 597867 610002 615907 618052 618776 622503 628693 629837 644175 668701 710505 735906 739557 742385 744359 776212 784475 790986 808166 808168 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (9.81%) |
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 395465 466790 776212 710505 485950 593070 618052 582799 622503 452856 450181 552062 561439 398561 469614 482951 519386 478339 466147 529380 462183 558173 744359 735906 442634 428051 538912 462095 425149 460533 552063 575677 479084 808168 742385 520094 188266 424248 539593 538064 516653 499712 485751 520660 413004 628693 594933 629837 465385 476164 458449 668701 808166 466341 485942 456036 459643 462105 498290 390447 472700 545964 547536 549223 479128 485764 387149 490394 498457 537824 460762 472555 460438 408978 478790 534579 549776 554839 452254 476341 159305 739557 644175 551886 610002 464534 453135 477718 485939 485937 790986 592883 464965 545968 527947 518862 386987 487364 518844 439758 426550 618776 615907 475897 462085 467055 484375 536481 597867 495238 470762 514902 515086 590289 460338 448696 465317 543924 784475 538530 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.83%) |
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 159305 188266 386987 387149 390447 395465 398561 408978 413004 424248 425149 426550 428051 439758 442634 448696 450181 452254 452856 453135 456036 458449 459643 460338 460438 460533 460762 462085 462095 462105 462183 464534 464965 465317 465385 466147 466341 466790 467055 469614 470762 472555 472700 475897 476164 476341 477718 478339 478790 479084 479128 482951 484375 485751 485764 485937 485939 485942 485950 487364 490394 495238 498290 498457 499712 514902 515086 516653 518844 518862 519386 520094 520660 527947 529380 534579 536481 537824 538064 538530 538912 539593 543924 545964 545968 547536 549223 549776 551886 552062 552063 554839 558173 561439 575677 582799 590289 592883 593070 594933 597867 610002 615907 618052 618776 622503 628693 629837 644175 668701 710505 735906 739557 742385 744359 776212 784475 790986 808166 808168 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüðÁð║Ðü Ðü ð▒ð░ð▒ð║ð░ð╝ð© ð┤ð¥ð╝ð░Ðêð¢ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс бабушк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс бабушк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.94%) |
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.