Query Metrics
7
Database Queries
7
Different statements
231.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.00 ms (89.92%) |
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 541655 543636 546421 549442 550539 552109 552378 552620 553136 553550 557348 558717 559811 560003 560808 562215 567969 568263 568500 569221 575223 576536 576603 579056 579658 580743 583855 584072 584620 584922 585806 585927 586567 588427 590718 592800 593241 593830 594381 596135 596170 596177 596634 597056 597725 597828 598022 598251 598681 599470 601371 602173 605132 607217 607386 609585 612680 614008 616949 622454 623725 625014 628785 632287 633036 636191 637697 639148 639421 640489 642103 643727 645745 646286 648765 650270 651198 652958 653304 653571 657508 659477 660266 660320 661522 661540 661898 662803 666101 668125 670316 670779 671534 671819 673910 674295 676483 677059 678346 678555 678570 679073 679146 680014 684449 691451 691778 692721 692744 692913 698161 700267 701489 704246 706630 708716 709046 713024 713767 722944 ] |
||||||||||||||||||||||||||||||
|
12.45 ms (5.38%) |
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 559811 560003 568263 568500 583855 584620 541655 543636 549442 550539 552109 552378 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 692744 692913 701489 708716 648765 650270 651198 657508 660266 666101 671819 674295 676483 678570 680014 713024 546421 552620 557348 558717 567969 575223 576536 579056 580743 584072 584922 585806 592800 593241 597725 601371 612680 622454 639148 642103 586567 594381 596634 598681 605132 614008 616949 623725 625014 633036 639421 643727 588427 596135 596170 596177 599470 602173 628785 632287 636191 637697 585927 590718 593830 597056 597828 598022 598251 607217 607386 609585 640489 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.35%) |
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 541655 543636 546421 549442 550539 552109 552378 552620 553136 553550 557348 558717 559811 560003 560808 562215 567969 568263 568500 569221 575223 576536 576603 579056 579658 580743 583855 584072 584620 584922 585806 585927 586567 588427 590718 592800 593241 593830 594381 596135 596170 596177 596634 597056 597725 597828 598022 598251 598681 599470 601371 602173 605132 607217 607386 609585 612680 614008 616949 622454 623725 625014 628785 632287 633036 636191 637697 639148 639421 640489 642103 643727 645745 646286 648765 650270 651198 652958 653304 653571 657508 659477 660266 660320 661522 661540 661898 662803 666101 668125 670316 670779 671534 671819 673910 674295 676483 677059 678346 678555 678570 679073 679146 680014 684449 691451 691778 692721 692744 692913 698161 700267 701489 704246 706630 708716 709046 713024 713767 722944 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая соло"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny girl solo"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая соло"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.75%) |
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.