Query Metrics
7
Database Queries
7
Different statements
141.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.65 ms (83.22%) |
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 161823 384201 395319 400226 401027 402425 403833 415040 417311 418869 420082 421942 423433 424969 425947 426962 427855 432389 432404 432477 432479 432507 432519 432706 433792 433815 435931 443073 446952 450025 451254 451530 453872 455995 456578 459298 461710 461912 462823 463448 464915 465361 465906 467953 469349 469716 475309 476568 477205 481263 481392 485139 488529 489381 489760 490005 490522 490883 491138 494180 495002 505996 506494 507771 508641 509634 510219 513060 514151 516490 517978 522647 522953 522993 524447 527362 529516 531080 538794 542113 542386 546781 552889 554064 554577 560837 560996 562601 565000 577330 577644 578578 580425 581855 585344 586400 588987 590145 598218 600704 608007 610838 612821 613379 620059 628696 636355 650359 661531 675427 688962 700059 739301 757878 770600 773924 782565 784976 788060 798962 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (10.22%) |
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 636355 432389 455995 463448 477205 506494 494180 469716 585344 425947 578578 505996 577644 516490 608007 161823 421942 522953 527362 491138 628696 590145 586400 490005 401027 451530 490883 475309 577330 453872 426962 464915 488529 490522 459298 465906 538794 456578 395319 403833 417311 435931 418869 443073 446952 469349 462823 467953 562601 546781 552889 600704 481263 433815 461912 420082 424969 427855 432519 476568 415040 465361 481392 509634 485139 489760 402425 542386 432477 423433 700059 782565 739301 798962 531080 384201 581855 432706 522993 513060 542113 580425 588987 620059 529516 450025 507771 514151 524447 495002 560837 554577 565000 675427 433792 432404 432479 598218 613379 451254 461710 510219 517978 489381 757878 661531 688962 650359 773924 432507 522647 508641 400226 560996 554064 612821 610838 784976 788060 770600 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.65%) |
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 161823 384201 395319 400226 401027 402425 403833 415040 417311 418869 420082 421942 423433 424969 425947 426962 427855 432389 432404 432477 432479 432507 432519 432706 433792 433815 435931 443073 446952 450025 451254 451530 453872 455995 456578 459298 461710 461912 462823 463448 464915 465361 465906 467953 469349 469716 475309 476568 477205 481263 481392 485139 488529 489381 489760 490005 490522 490883 491138 494180 495002 505996 506494 507771 508641 509634 510219 513060 514151 516490 517978 522647 522953 522993 524447 527362 529516 531080 538794 542113 542386 546781 552889 554064 554577 560837 560996 562601 565000 577330 577644 578578 580425 581855 585344 586400 588987 590145 598218 600704 608007 610838 612821 613379 620059 628696 636355 650359 661531 675427 688962 700059 739301 757878 770600 773924 782565 784976 788060 798962 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперма в труси"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (1.00%) |
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.