Query Metrics
7
Database Queries
7
Different statements
170.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.84 ms (85.56%) |
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 398656 418158 424528 431664 434877 437515 437560 450370 452417 465933 471925 481635 482573 482636 485021 487543 490665 494645 495644 498156 500323 502193 512722 515300 522462 536060 545686 548885 559240 560579 564887 565510 566290 587049 587125 589149 589636 590415 590921 594453 594607 599388 603453 603968 604179 606035 608606 617692 619509 620027 620649 621498 622826 623481 636477 640476 645735 646980 651852 654638 660692 662557 668776 671492 675071 676389 682943 690265 700513 700727 702521 711327 714489 727541 727715 728187 728958 732837 736274 736284 743492 750319 753058 753223 756947 757519 760305 760930 767186 767469 778684 779918 780297 782769 784357 786880 786920 788213 790035 791725 793221 793246 794492 794745 795009 797494 799957 800044 802319 810326 818977 819331 819674 819838 820011 820014 824145 825175 825202 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.30%) |
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 490665 565510 587049 587125 700727 622826 799957 794745 398656 434877 545686 660692 620649 621498 590415 793221 780297 465933 623481 481635 646980 594607 452417 560579 594453 599388 619509 675071 437560 482573 471925 485021 450370 536060 495644 515300 559240 566290 651852 654638 676389 682943 702521 711327 645735 668776 671492 690265 714489 603453 606035 590921 603968 608606 636477 589149 589636 604179 620027 760305 753058 728187 727541 617692 640476 502193 498156 500323 482636 487543 512722 522462 662557 431664 437515 418158 424528 494645 825202 825175 818977 820011 820014 824145 819331 819674 819838 548885 564887 778684 782769 788213 790035 793246 794492 795009 797494 800044 775594 779918 727715 736274 767186 784357 786880 786920 791725 802319 810326 728958 732837 743492 753223 756947 757519 760930 750319 767469 736284 700513 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.60%) |
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 398656 418158 424528 431664 434877 437515 437560 450370 452417 465933 471925 481635 482573 482636 485021 487543 490665 494645 495644 498156 500323 502193 512722 515300 522462 536060 545686 548885 559240 560579 564887 565510 566290 587049 587125 589149 589636 590415 590921 594453 594607 599388 603453 603968 604179 606035 608606 617692 619509 620027 620649 621498 622826 623481 636477 640476 645735 646980 651852 654638 660692 662557 668776 671492 675071 676389 682943 690265 700513 700727 702521 711327 714489 727541 727715 728187 728958 732837 736274 736284 743492 750319 753058 753223 756947 757519 760305 760930 767186 767469 778684 779918 780297 782769 784357 786880 786920 788213 790035 791725 793221 793246 794492 794745 795009 797494 799957 800044 802319 810326 818977 819331 819674 819838 820011 820014 824145 825175 825202 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade lick"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск лиза"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
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.