Query Metrics
7
Database Queries
7
Different statements
219.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.20 ms (89.88%) |
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 383582 411220 420167 462654 463509 487198 488368 488886 495410 495585 498231 499361 506068 508227 511952 513162 516016 532367 533101 535395 537352 539789 547385 552810 553482 554916 558691 568987 578792 586255 586268 586285 592618 592987 595386 604706 609589 609967 611532 613625 617614 618545 618858 625107 625724 632754 635893 638574 641334 641539 644051 644138 650294 662117 673608 678205 678704 682532 694420 697869 702274 704942 707876 709013 710356 712609 715036 716572 716790 720343 724120 727970 729738 733521 734952 737882 739604 739782 740731 742046 743048 743831 746270 750098 753050 757754 757909 763442 765640 766056 766469 770071 771260 772157 772522 774256 785212 789145 791124 794436 794954 795636 796354 797496 797516 797882 800946 801327 802005 803963 807778 808636 810086 814115 817243 820540 823238 824541 826028 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (6.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 740731 784830 794954 796354 810086 750098 707876 595386 820540 554916 709013 632754 697869 533101 710356 694420 625107 791124 766056 771260 772522 513162 753050 814115 516016 662117 592987 635893 785212 737882 383582 495410 535395 586268 808636 650294 743048 774256 789145 797882 801327 770071 715036 678205 682532 617614 618545 613625 727970 537352 641539 539789 508227 488368 824541 704942 609589 729738 803963 743831 763442 739604 702274 487198 498231 586285 739782 511952 552810 641334 797516 802005 807778 495585 532367 797496 795636 733521 826028 800946 765640 644051 553482 463509 586255 611532 794436 411220 568987 638574 724120 817243 609967 644138 772157 757754 499361 558691 712609 420167 462654 547385 488886 823238 578792 742046 757909 506068 673608 678704 716790 720343 618858 592618 604706 625724 766469 734952 746270 716572 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.20%) |
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 383582 411220 420167 462654 463509 487198 488368 488886 495410 495585 498231 499361 506068 508227 511952 513162 516016 532367 533101 535395 537352 539789 547385 552810 553482 554916 558691 568987 578792 586255 586268 586285 592618 592987 595386 604706 609589 609967 611532 613625 617614 618545 618858 625107 625724 632754 635893 638574 641334 641539 644051 644138 650294 662117 673608 678205 678704 682532 694420 697869 702274 704942 707876 709013 710356 712609 715036 716572 716790 720343 724120 727970 729738 733521 734952 737882 739604 739782 740731 742046 743048 743831 746270 750098 753050 757754 757909 763442 765640 766056 766469 770071 771260 772157 772522 774256 785212 789145 791124 794436 794954 795636 796354 797496 797516 797882 800946 801327 802005 803963 807778 808636 810086 814115 817243 820540 823238 824541 826028 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"neighbor big tits"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"neighbor большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"neighbor большие сиськ"
]
|
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.