Query Metrics
7
Database Queries
7
Different statements
562.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.97 ms (37.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фейсситтинг жен"
]
|
||||||||||||||||||||||||||||||
|
207.20 ms (36.81%) |
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 407171 407562 414932 415858 436845 440581 455872 460426 466337 474394 475343 480091 482585 484398 484886 502103 512749 513953 518383 522317 530867 533508 545945 546953 553722 555743 559989 560264 560321 565686 570991 572703 574978 594411 598204 601470 606035 606382 608606 612603 613688 613874 615100 615380 618744 619271 644421 657246 657781 662894 664237 667944 668776 676345 676825 677862 687150 693234 698251 703318 704180 706721 707974 710096 714193 715774 721954 724033 724242 725048 726479 726557 727502 728203 729180 731397 733276 734400 739899 743937 743955 744151 744880 745775 748325 748489 750628 757201 758010 759693 761668 762777 764189 765558 766944 772914 774156 779120 780300 780310 783840 784072 786122 786924 790828 792203 792215 792216 795385 796448 799896 800149 801164 801608 802870 803935 805780 812298 827152 827370 ] |
||||||||||||||||||||||||||||||
|
121.89 ms (21.66%) |
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 407171 407562 414932 415858 436845 440581 455872 460426 466337 474394 475343 480091 482585 484398 484886 502103 512749 513953 518383 522317 530867 533508 545945 546953 553722 555743 559989 560264 560321 565686 570991 572703 574978 594411 598204 601470 606035 606382 608606 612603 613688 613874 615100 615380 618744 619271 644421 657246 657781 662894 664237 667944 668776 676345 676825 677862 687150 693234 698251 703318 704180 706721 707974 710096 714193 715774 721954 724033 724242 725048 726479 726557 727502 728203 729180 731397 733276 734400 739899 743937 743955 744151 744880 745775 748325 748489 750628 757201 758010 759693 761668 762777 764189 765558 766944 772914 774156 779120 780300 780310 783840 784072 786122 786924 790828 792203 792215 792216 795385 796448 799896 800149 801164 801608 802870 803935 805780 812298 827152 827370 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (2.78%) |
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 668776 693234 698251 704180 657781 667944 703318 560321 572703 606035 608606 594411 613874 784072 801164 805780 779120 792203 799896 800149 725048 743955 750628 757201 766944 783840 786924 796448 802870 803935 731397 759693 772914 724033 724242 726479 726557 727502 728203 734400 748489 774156 729180 743937 744151 762777 765558 733276 758010 764189 601470 613688 615380 715774 721954 780310 792216 801608 407171 436845 475343 484886 574978 714193 748325 512749 559989 598204 474394 440581 522317 484398 513953 407562 455872 615100 644421 618744 744880 745775 739899 546953 502103 676825 706721 710096 687150 619271 812298 761668 415858 466337 414932 827152 827370 460426 480091 518383 530867 533508 482585 545945 553722 555743 565686 570991 676345 657246 664237 677862 707974 662894 560264 612603 606382 780300 790828 792215 795385 786122 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting wife"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.