Query Metrics
7
Database Queries
7
Different statements
139.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.72 ms (85.16%) |
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 66540 69842 69883 259942 386339 388897 391880 396916 398369 401119 405832 417554 419175 433072 444808 455525 457321 488565 490482 492592 495517 503029 505917 508974 509963 514013 514022 517414 523021 532137 535790 540606 541034 543153 548692 549202 550358 554122 554875 555936 556704 558358 562412 562966 563962 565471 566701 567619 572222 572242 576768 580031 584574 586614 603967 608695 609827 614893 615590 618147 618206 618489 620309 629740 631125 632783 634599 646359 657787 674266 679578 682618 689020 690281 696127 702926 703762 703828 709574 714359 718224 718400 718533 718626 719215 719284 723156 724810 730717 730754 733040 735841 736154 738560 744517 745336 746930 747684 755605 768300 769194 773845 776191 777122 779783 780202 781007 783217 784056 786206 787269 788015 789362 793049 793338 793932 794401 795894 801622 801672 ] |
||||||||||||||||||||||||||||||
|
10.56 ms (7.57%) |
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 508974 608695 788015 793049 632783 548692 586614 609827 444808 492592 768300 503029 69883 777122 457321 433072 558358 562966 620309 784056 69842 517414 419175 505917 490482 514013 514022 618206 776191 783217 540606 549202 543153 567619 576768 696127 703828 714359 718400 580031 618147 629740 614893 618489 634599 795894 780202 786206 789362 794401 801672 733040 724810 744517 747684 769194 730754 735841 746930 755605 773845 745336 631125 781007 787269 793932 398369 388897 690281 603967 386339 509963 535790 719215 779783 793338 730717 738560 532137 615590 565471 66540 736154 801622 455525 555936 562412 682618 556704 401119 572242 523021 391880 259942 396916 405832 417554 488565 495517 584574 554122 554875 563962 541034 550358 679578 689020 718224 657787 674266 709574 718533 719284 646359 702926 703762 718626 723156 566701 572222 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.88%) |
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 66540 69842 69883 259942 386339 388897 391880 396916 398369 401119 405832 417554 419175 433072 444808 455525 457321 488565 490482 492592 495517 503029 505917 508974 509963 514013 514022 517414 523021 532137 535790 540606 541034 543153 548692 549202 550358 554122 554875 555936 556704 558358 562412 562966 563962 565471 566701 567619 572222 572242 576768 580031 584574 586614 603967 608695 609827 614893 615590 618147 618206 618489 620309 629740 631125 632783 634599 646359 657787 674266 679578 682618 689020 690281 696127 702926 703762 703828 709574 714359 718224 718400 718533 718626 719215 719284 723156 724810 730717 730754 733040 735841 736154 738560 744517 745336 746930 747684 755605 768300 769194 773845 776191 777122 779783 780202 781007 783217 784056 786206 787269 788015 789362 793049 793338 793932 794401 795894 801622 801672 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончил в тот"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.12%) |
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.