Query Metrics
7
Database Queries
7
Different statements
157.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.97 ms (82.46%) |
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 546421 552620 553136 553550 557348 558717 560808 562215 567969 569221 576536 576603 579056 579658 580743 584072 584922 585806 585927 586567 588427 590718 593241 593830 594381 596135 596170 596177 596634 597056 597725 597828 598022 598251 598681 599470 601371 605132 607217 607386 609585 612680 614008 616949 622454 623725 625014 628785 632287 633036 636191 637697 639148 639421 640489 640899 642103 645745 646286 648765 650270 652958 653304 653571 657508 659477 660266 660320 661522 661540 661898 662803 666101 668125 670316 670779 671534 671819 673910 676483 677059 678346 678555 678570 679073 679146 680014 684449 691451 691778 692721 692913 698161 700267 701489 704246 706630 708716 709046 713024 713767 722944 774588 777126 777164 782466 782867 783283 786264 786274 791147 793033 793135 798225 803189 806673 807072 807570 810517 812039 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (11.13%) |
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 553136 553550 560808 562215 569221 576603 579658 645745 653304 653571 661540 670316 670779 671534 673910 677059 678346 678555 679146 691778 698161 700267 704246 706630 709046 713767 722944 646286 652958 659477 660320 661522 661898 662803 668125 679073 684449 691451 692721 692913 701489 708716 648765 650270 657508 660266 666101 671819 676483 678570 680014 713024 546421 552620 557348 558717 567969 576536 579056 580743 584072 584922 585806 593241 597725 601371 612680 622454 639148 642103 586567 594381 596634 598681 605132 614008 616949 623725 625014 633036 639421 588427 596135 596170 596177 599470 628785 632287 636191 637697 585927 590718 593830 597056 597828 598022 598251 607217 607386 609585 640489 640899 777126 782867 786264 786274 793033 803189 807570 810517 812039 774588 777164 782466 783283 791147 793135 798225 806673 807072 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teens solo"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.38%) |
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 546421 552620 553136 553550 557348 558717 560808 562215 567969 569221 576536 576603 579056 579658 580743 584072 584922 585806 585927 586567 588427 590718 593241 593830 594381 596135 596170 596177 596634 597056 597725 597828 598022 598251 598681 599470 601371 605132 607217 607386 609585 612680 614008 616949 622454 623725 625014 628785 632287 633036 636191 637697 639148 639421 640489 640899 642103 645745 646286 648765 650270 652958 653304 653571 657508 659477 660266 660320 661522 661540 661898 662803 666101 668125 670316 670779 671534 671819 673910 676483 677059 678346 678555 678570 679073 679146 680014 684449 691451 691778 692721 692913 698161 700267 701489 704246 706630 708716 709046 713024 713767 722944 774588 777126 777164 782466 782867 783283 786264 786274 791147 793033 793135 798225 803189 806673 807072 807570 810517 812039 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teens соло"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teens соло"
]
|
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.