Query Metrics
7
Database Queries
7
Different statements
157.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.00 ms (82.10%) |
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 428209 442280 446090 459530 463823 473094 473771 479265 480187 480891 483522 486197 493993 494938 499514 500597 500878 507172 509108 510797 511047 513110 513816 513910 515959 520389 520820 521410 521709 522292 524601 525048 525591 528584 529767 530456 534600 536426 539532 540377 543129 546033 546665 548846 551563 551803 552603 552854 554466 554530 558883 559828 559937 560080 560508 561212 561306 563930 565341 565909 567216 567816 567888 567997 568092 569146 570143 570152 572012 572195 572528 573402 575665 577916 577961 580418 580471 580866 581254 582708 584021 584101 584112 586594 587191 589730 589968 591858 592067 592989 595488 597969 598146 598249 600671 602490 603445 603669 604663 606664 606860 606889 607705 611484 612478 612917 617828 618673 619399 619732 623922 624897 626376 626553 626887 633872 636643 646669 655246 666603 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.56%) |
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 499514 521709 546033 567816 568092 570143 543129 577916 591858 604663 602490 633872 606889 428209 483522 539532 479265 480891 486197 552854 572528 546665 520389 561212 612478 619732 612917 534600 551803 595488 598249 473094 551563 572012 626376 584112 507172 584021 592067 626887 536426 570152 565909 581254 442280 459530 559937 510797 529767 509108 520820 567888 575665 580471 584101 666603 554466 567216 617828 446090 589730 521410 480187 493993 548846 559828 587191 592989 597969 565341 513110 552603 580866 598146 603669 618673 554530 586594 473771 511047 655246 582708 619399 540377 500597 580418 626553 463823 513816 525048 560508 573402 500878 513910 524601 525591 528584 558883 561306 646669 572195 607705 623922 515959 530456 560080 567997 563930 606860 624897 600671 636643 522292 494938 569146 606664 589968 611484 603445 577961 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.99%) |
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 428209 442280 446090 459530 463823 473094 473771 479265 480187 480891 483522 486197 493993 494938 499514 500597 500878 507172 509108 510797 511047 513110 513816 513910 515959 520389 520820 521410 521709 522292 524601 525048 525591 528584 529767 530456 534600 536426 539532 540377 543129 546033 546665 548846 551563 551803 552603 552854 554466 554530 558883 559828 559937 560080 560508 561212 561306 563930 565341 565909 567216 567816 567888 567997 568092 569146 570143 570152 572012 572195 572528 573402 575665 577916 577961 580418 580471 580866 581254 582708 584021 584101 584112 586594 587191 589730 589968 591858 592067 592989 595488 597969 598146 598249 600671 602490 603445 603669 604663 606664 606860 606889 607705 611484 612478 612917 617828 618673 619399 619732 623922 624897 626376 626553 626887 633872 636643 646669 655246 666603 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рук жоп"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рука жопе"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
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.