Query Metrics
7
Database Queries
7
Different statements
432.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
409.36 ms (94.64%) |
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 11969 99632 162721 385440 423478 436948 449558 453693 454888 455348 457701 458004 460440 462585 469173 481947 484729 485426 504155 515774 517814 527535 530081 530203 532034 532373 533723 535457 540512 554921 555175 555562 556648 559596 561566 566676 569187 569420 574445 579737 596981 601721 603119 603204 603345 604877 606853 609977 626803 639176 644637 645052 645962 647447 649902 652747 653087 662039 664504 664595 666670 669192 669196 675545 692780 693535 694149 696337 699304 701733 706995 707589 710424 714319 714322 714336 714346 714357 717595 717740 719021 720841 732169 795144 795963 797312 801442 803036 803081 803091 803289 805130 807088 815460 815966 816641 818857 818907 819152 819162 819243 819277 819381 819463 823538 824046 824403 824544 825213 825381 825597 826048 826166 826204 826610 826713 826996 827219 828868 ] |
||||||||||||||||||||||||||||||
|
13.80 ms (3.19%) |
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 795144 801442 803289 805130 807088 385440 566676 449558 515774 527535 504155 535457 569420 797312 601721 453693 458004 469173 462585 436948 457701 481947 454888 455348 517814 540512 649902 669192 714319 664595 692780 710424 714336 714346 714357 664504 714322 644637 803091 732169 795963 803036 803081 99632 162721 11969 423478 819277 824403 826048 826166 826610 826713 818907 819463 825381 826996 827219 815460 816641 818857 819381 824046 824544 826204 815966 819152 819162 819243 823538 825213 825597 828868 485426 532373 533723 530081 530203 532034 460440 484729 555562 561566 569187 554921 556648 559596 574445 579737 647447 653087 666670 675545 694149 696337 699304 701733 706995 688681 707589 717595 717740 645052 645962 652747 662039 669196 693535 719021 720841 555175 596981 626803 603119 603345 606853 604877 609977 639176 603204 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.68%) |
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 11969 99632 162721 385440 423478 436948 449558 453693 454888 455348 457701 458004 460440 462585 469173 481947 484729 485426 504155 515774 517814 527535 530081 530203 532034 532373 533723 535457 540512 554921 555175 555562 556648 559596 561566 566676 569187 569420 574445 579737 596981 601721 603119 603204 603345 604877 606853 609977 626803 639176 644637 645052 645962 647447 649902 652747 653087 662039 664504 664595 666670 669192 669196 675545 692780 693535 694149 696337 699304 701733 706995 707589 710424 714319 714322 714336 714346 714357 717595 717740 719021 720841 732169 795144 795963 797312 801442 803036 803081 803091 803289 805130 807088 815460 815966 816641 818857 818907 819152 819162 819243 819277 819381 819463 823538 824046 824403 824544 825213 825381 825597 826048 826166 826204 826610 826713 826996 827219 828868 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf длинные"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf and long"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf длинные"
]
|
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.