Query Metrics
7
Database Queries
7
Different statements
185.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.20 ms (87.60%) |
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 340242 382101 383704 384823 387180 404532 423983 438450 451730 461239 466654 488788 490847 501055 506628 512649 517665 519758 521795 522006 531013 531033 531034 531885 533137 533768 533914 535034 535187 535710 539965 542905 544896 548155 550030 553322 553587 553876 556027 556184 558631 564027 574189 598240 601439 601811 603377 609725 614222 615906 615965 616140 616246 617496 624698 630211 636708 648433 648507 652952 671534 679230 683270 690013 692001 692774 696304 699900 700246 700860 706384 706847 713327 715988 719647 721003 721390 722305 724972 735876 737055 739245 751592 755484 758370 759817 760373 760472 762598 771726 774824 775657 776137 778396 779177 781481 782521 783309 783672 784369 785039 785042 786200 786779 787477 795392 796043 798591 803405 806753 809954 812628 814195 819164 823348 824951 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (6.96%) |
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 692774 803405 553322 384823 531013 506628 616246 340242 615906 795392 760373 556027 533137 648507 624698 706847 796043 311884 531885 700860 609725 598240 759817 786200 533768 751592 774824 531033 671534 696304 806753 785042 517665 535034 553876 548155 715988 556184 601439 784369 809954 648433 776137 783672 735876 699900 382101 814195 574189 739245 779177 512649 558631 722305 692001 786779 521795 533914 539965 700246 617496 755484 775657 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 542905 719647 737055 787477 519758 679230 614222 782521 466654 404532 119798 522006 819164 824951 501055 461239 564027 762598 724972 778396 531034 535187 535710 652952 785039 783309 423983 451730 488788 683270 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.11%) |
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 340242 382101 383704 384823 387180 404532 423983 438450 451730 461239 466654 488788 490847 501055 506628 512649 517665 519758 521795 522006 531013 531033 531034 531885 533137 533768 533914 535034 535187 535710 539965 542905 544896 548155 550030 553322 553587 553876 556027 556184 558631 564027 574189 598240 601439 601811 603377 609725 614222 615906 615965 616140 616246 617496 624698 630211 636708 648433 648507 652952 671534 679230 683270 690013 692001 692774 696304 699900 700246 700860 706384 706847 713327 715988 719647 721003 721390 722305 724972 735876 737055 739245 751592 755484 758370 759817 760373 760472 762598 771726 774824 775657 776137 778396 779177 781481 782521 783309 783672 784369 785039 785042 786200 786779 787477 795392 796043 798591 803405 806753 809954 812628 814195 819164 823348 824951 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls dance"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк танец"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.72%) |
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.