Query Metrics
7
Database Queries
7
Different statements
149.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.93 ms (83.15%) |
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 386072 400137 420253 430048 430834 431376 441956 443677 445238 449358 450582 456731 460331 464278 465117 467549 472437 472913 474791 475852 476833 478911 484495 485170 485366 488715 492369 495358 496101 508022 518062 519087 519931 522200 524067 525964 527641 533261 535321 536331 542493 543243 556018 560209 565038 566221 568457 568463 568503 569457 569550 569770 569871 570851 570857 580821 587202 589747 590190 590211 591413 592417 592675 597665 598433 599122 600334 601514 604435 605213 605617 605637 605892 606392 606608 610283 621979 634528 635138 637042 645254 661977 671551 672506 676862 681153 686035 690623 699599 715693 720577 726439 727384 736401 740113 743066 744915 757071 764418 774097 777359 784943 786831 795515 798586 805589 805595 805607 811085 813537 814145 814656 814785 814813 815431 816060 817344 818391 820872 828455 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (9.96%) |
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 637042 816060 690623 798586 634528 784943 386072 464278 488715 476833 715693 597665 598433 610283 786831 805607 460331 536331 522200 542493 430834 431376 443677 814785 485170 569770 492369 478911 449358 527641 485366 818391 814813 820872 686035 671551 676862 681153 569871 570851 590211 621979 590190 777359 813537 736401 757071 811085 744915 740113 635138 828455 727384 568457 600334 605617 605213 568503 556018 569457 592417 601514 589747 699599 672506 720577 645254 605892 743066 604435 450582 815431 814145 814656 817344 533261 570857 599122 805589 795515 472913 467549 535321 805595 726439 456731 445238 484495 518062 764418 774097 566221 661977 568463 592675 606608 605637 474791 475852 400137 472437 525964 565038 560209 591413 524067 420253 465117 569550 543243 580821 587202 606392 441956 508022 495358 496101 430048 519087 519931 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.90%) |
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 386072 400137 420253 430048 430834 431376 441956 443677 445238 449358 450582 456731 460331 464278 465117 467549 472437 472913 474791 475852 476833 478911 484495 485170 485366 488715 492369 495358 496101 508022 518062 519087 519931 522200 524067 525964 527641 533261 535321 536331 542493 543243 556018 560209 565038 566221 568457 568463 568503 569457 569550 569770 569871 570851 570857 580821 587202 589747 590190 590211 591413 592417 592675 597665 598433 599122 600334 601514 604435 605213 605617 605637 605892 606392 606608 610283 621979 634528 635138 637042 645254 661977 671551 672506 676862 681153 686035 690623 699599 715693 720577 726439 727384 736401 740113 743066 744915 757071 764418 774097 777359 784943 786831 795515 798586 805589 805595 805607 811085 813537 814145 814656 814785 814813 815431 816060 817344 818391 820872 828455 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая член mom"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small dick mom"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая член mom"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
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.