Query Metrics
7
Database Queries
7
Different statements
202.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.95 ms (86.58%) |
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 20429 79082 161342 330478 341596 391596 392325 395450 401540 409861 419804 424333 425866 429799 431741 435399 446394 452289 456710 457584 460364 460736 462955 464168 470596 470692 471406 474975 477439 477549 484407 485488 486706 488483 488585 490785 495260 496303 500156 501028 504047 505129 505243 508019 509222 509842 509862 510641 513771 515891 516714 516991 519367 519563 520894 523591 524853 526385 528867 536618 536865 537173 538514 541774 545763 550823 556839 559178 562028 564367 565905 566228 566415 566688 566812 567725 568305 571664 571670 571823 572320 575716 578435 578512 580518 586912 587185 590515 590535 598680 598897 601339 607705 610766 611571 612265 613836 614408 619082 622953 626311 632551 633491 637094 639786 645706 651907 667985 675104 678569 679072 680020 682252 691196 698821 706658 707844 733886 780406 801519 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (8.58%) |
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 566688 419804 578435 598897 801519 79082 568305 580518 571670 622953 516991 667985 706658 330478 536865 501028 559178 528867 632551 446394 675104 601339 578512 679072 619082 610766 550823 611571 682252 474975 567725 524853 566228 651907 586912 780406 508019 513771 541774 429799 477549 500156 464168 391596 537173 452289 462955 680020 519563 691196 571664 564367 707844 566812 612265 536618 519367 733886 471406 425866 614408 457584 509222 566415 565905 607705 477439 424333 435399 545763 515891 562028 556839 504047 639786 486706 470596 488483 598680 488585 496303 538514 613836 505243 571823 626311 460736 392325 495260 509842 575716 161342 590515 523591 456710 520894 509862 470692 516714 20429 633491 587185 637094 485488 395450 341596 645706 678569 590535 409861 484407 505129 401540 431741 460364 510641 490785 526385 572320 698821 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.19%) |
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 20429 79082 161342 330478 341596 391596 392325 395450 401540 409861 419804 424333 425866 429799 431741 435399 446394 452289 456710 457584 460364 460736 462955 464168 470596 470692 471406 474975 477439 477549 484407 485488 486706 488483 488585 490785 495260 496303 500156 501028 504047 505129 505243 508019 509222 509842 509862 510641 513771 515891 516714 516991 519367 519563 520894 523591 524853 526385 528867 536618 536865 537173 538514 541774 545763 550823 556839 559178 562028 564367 565905 566228 566415 566688 566812 567725 568305 571664 571670 571823 572320 575716 578435 578512 580518 586912 587185 590515 590535 598680 598897 601339 607705 610766 611571 612265 613836 614408 619082 622953 626311 632551 633491 637094 639786 645706 651907 667985 675104 678569 679072 680020 682252 691196 698821 706658 707844 733886 780406 801519 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"два члена в письке"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два член в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 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.