Query Metrics
7
Database Queries
7
Different statements
169.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.07 ms (83.46%) |
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 31134 53698 131517 145053 187759 271496 327085 350574 383341 388555 395878 396364 396629 396922 397889 398872 399320 399422 400977 403384 404391 411203 411593 413254 414870 420306 425008 429211 432884 442442 448403 448987 449100 450147 452287 454193 455928 457600 458293 460003 463781 465595 466384 468500 468927 470979 471981 472279 472606 474499 474849 475681 476877 483792 490520 490595 490646 491858 492328 502751 506836 507427 510520 512419 523058 523573 524813 526733 529351 533289 558315 559408 561725 574398 577692 578177 583651 591536 593634 597044 601449 602562 612211 618662 628558 630254 663353 665519 670220 674741 682404 686088 691358 691578 696587 697298 709871 719143 725153 726903 729798 733549 770867 780661 783417 793535 808480 810011 810014 810383 814376 819310 824224 824531 824765 824833 825064 825170 826436 827921 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (10.24%) |
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 561725 663353 665519 697298 691358 593634 628558 612211 808480 810383 726903 729798 709871 719143 460003 490646 472279 490520 510520 824833 452287 601449 630254 388555 400977 483792 526733 574398 602562 780661 271496 450147 457600 474849 458293 463781 507427 468500 471981 442442 429211 506836 523058 466384 558315 577692 583651 591536 420306 524813 395878 399320 327085 398872 404391 411593 396364 383341 474499 414870 824224 824765 783417 411203 449100 53698 399422 465595 597044 455928 403384 827921 187759 670220 396629 432884 523573 454193 470979 397889 448403 502751 529351 425008 814376 725153 825170 696587 618662 826436 131517 819310 825064 448987 492328 686088 674741 810014 512419 793535 490595 770867 810011 145053 824531 472606 350574 396922 413254 476877 475681 491858 578177 682404 691578 733549 468927 533289 31134 559408 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.66%) |
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 31134 53698 131517 145053 187759 271496 327085 350574 383341 388555 395878 396364 396629 396922 397889 398872 399320 399422 400977 403384 404391 411203 411593 413254 414870 420306 425008 429211 432884 442442 448403 448987 449100 450147 452287 454193 455928 457600 458293 460003 463781 465595 466384 468500 468927 470979 471981 472279 472606 474499 474849 475681 476877 483792 490520 490595 490646 491858 492328 502751 506836 507427 510520 512419 523058 523573 524813 526733 529351 533289 558315 559408 561725 574398 577692 578177 583651 591536 593634 597044 601449 602562 612211 618662 628558 630254 663353 665519 670220 674741 682404 686088 691358 691578 696587 697298 709871 719143 725153 726903 729798 733549 770867 780661 783417 793535 808480 810011 810014 810383 814376 819310 824224 824531 824765 824833 825064 825170 826436 827921 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits hairy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.00%) |
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.