Query Metrics
7
Database Queries
7
Different statements
185.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.96 ms (87.73%) |
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 546193 547441 551401 554712 555208 559491 563284 566423 570683 581366 586016 588219 590233 590525 591044 593521 598308 616018 618257 619590 626803 628611 628751 631490 632501 636585 638999 639381 641516 641522 642004 643146 644205 644227 645328 646290 650526 655919 661036 665082 665802 666201 666602 672919 678776 679173 680795 682612 683084 691558 692826 692838 693495 696591 698249 698256 699304 705078 705210 706013 706407 706537 707633 712784 713215 713416 713453 713500 714190 715965 717275 719451 719960 721587 722284 734346 740911 744173 744215 746877 747245 755095 758753 773916 775543 775565 776445 777097 778655 779223 779241 780605 781496 783350 783357 783973 784397 784988 785881 792671 793068 793196 793795 794215 794639 794765 796314 796922 797568 798593 800641 801621 801797 803478 803507 804856 805784 807110 813114 813305 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (6.74%) |
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 678776 680795 692826 696591 699304 706407 707633 713215 713453 715965 719960 645328 646290 650526 655919 661036 666201 682612 692838 705078 706013 706537 713416 722284 665082 665802 666602 672919 679173 683084 691558 693495 698249 698256 705210 712784 713500 714190 717275 719451 721587 546193 547441 551401 554712 555208 559491 563284 566423 570683 581366 588219 590233 593521 616018 626803 628751 642004 643146 618257 636585 639381 644227 590525 591044 598308 619590 628611 632501 586016 631490 638999 641516 641522 644205 776445 777097 778655 779223 779241 780605 785881 793196 793795 800641 801797 803478 804856 807110 813305 775543 775565 781496 792671 794215 794639 796922 797568 798593 803507 813114 734346 740911 744173 744215 746877 747245 755095 758753 773916 783350 783357 783973 784397 784988 793068 794765 796314 801621 805784 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.47%) |
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 546193 547441 551401 554712 555208 559491 563284 566423 570683 581366 586016 588219 590233 590525 591044 593521 598308 616018 618257 619590 626803 628611 628751 631490 632501 636585 638999 639381 641516 641522 642004 643146 644205 644227 645328 646290 650526 655919 661036 665082 665802 666201 666602 672919 678776 679173 680795 682612 683084 691558 692826 692838 693495 696591 698249 698256 699304 705078 705210 706013 706407 706537 707633 712784 713215 713416 713453 713500 714190 715965 717275 719451 719960 721587 722284 734346 740911 744173 744215 746877 747245 755095 758753 773916 775543 775565 776445 777097 778655 779223 779241 780605 781496 783350 783357 783973 784397 784988 785881 792671 793068 793196 793795 794215 794639 794765 796314 796922 797568 798593 800641 801621 801797 803478 803507 804856 805784 807110 813114 813305 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass gape"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.97%) |
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.