Query Metrics
7
Database Queries
7
Different statements
158.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.34 ms (86.41%) |
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 21956 119798 208504 311884 382101 383704 387180 404532 422103 423983 425843 429800 438450 443502 451730 461239 466654 488788 490847 501055 512649 514922 517665 519758 521795 522006 523304 531019 531885 533768 533914 535034 535187 535710 539965 542905 544896 548155 550030 552462 553587 553876 556184 558483 558631 564027 574189 598240 599954 601439 601811 603377 609725 614222 615965 616140 617496 624698 630211 636708 645354 647383 648433 648453 652952 671534 679230 683270 690013 692001 693940 696304 699900 700246 700860 706384 706847 713327 715988 719647 721003 721390 722305 724972 735876 737055 739245 751592 755484 758370 759817 760472 762598 771726 774824 775657 776137 778396 779177 780851 781481 782521 783309 783672 784369 785039 785042 786200 786779 787477 796043 798591 799162 806753 809954 812628 814195 819164 823348 824951 ] |
||||||||||||||||||||||||||||||
|
11.21 ms (7.05%) |
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 624698 706847 796043 311884 531885 700860 609725 598240 759817 531019 786200 533768 751592 774824 671534 696304 806753 785042 517665 535034 553876 548155 715988 556184 601439 784369 780851 809954 648433 776137 783672 735876 699900 382101 814195 574189 739245 779177 512649 645354 558631 722305 692001 786779 521795 533914 539965 700246 617496 755484 775657 799162 721003 601811 636708 798591 21956 387180 383704 208504 823348 603377 615965 630211 812628 781481 758370 771726 721390 690013 713327 553587 760472 616140 544896 706384 550030 490847 438450 514922 542905 719647 737055 787477 519758 679230 614222 782521 466654 404532 119798 522006 819164 824951 501055 461239 564027 762598 724972 778396 422103 599954 535187 535710 652952 785039 783309 423983 451730 558483 488788 683270 647383 429800 425843 443502 523304 552462 693940 648453 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.92%) |
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 21956 119798 208504 311884 382101 383704 387180 404532 422103 423983 425843 429800 438450 443502 451730 461239 466654 488788 490847 501055 512649 514922 517665 519758 521795 522006 523304 531019 531885 533768 533914 535034 535187 535710 539965 542905 544896 548155 550030 552462 553587 553876 556184 558483 558631 564027 574189 598240 599954 601439 601811 603377 609725 614222 615965 616140 617496 624698 630211 636708 645354 647383 648433 648453 652952 671534 679230 683270 690013 692001 693940 696304 699900 700246 700860 706384 706847 713327 715988 719647 721003 721390 722305 724972 735876 737055 739245 751592 755484 758370 759817 760472 762598 771726 774824 775657 776137 778396 779177 780851 781481 782521 783309 783672 784369 785039 785042 786200 786779 787477 796043 798591 799162 806753 809954 812628 814195 819164 823348 824951 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dance girls"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"танец девушк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"танец девушк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.