Query Metrics
7
Database Queries
7
Different statements
202.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.56 ms (86.08%) |
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 390650 391921 398972 401613 401642 419549 420304 423869 423968 434709 438430 438488 443579 443626 443627 443629 443632 445638 445838 453194 454171 454393 454561 455121 456022 456979 459446 459469 459959 462604 463898 463982 464258 466346 466886 468157 468337 469420 470410 470431 475431 485947 495278 502835 507751 517682 520227 526747 527919 528036 530098 530127 530430 530860 532634 532635 539329 543970 545414 552275 554488 557406 558252 562426 567083 568228 574649 576487 578525 582440 582747 583287 584010 584039 584045 595253 605565 617390 620119 640350 650082 658453 658477 658854 664368 664587 698123 706029 707518 715567 724878 726078 732782 733503 742608 749016 757543 758154 771642 772062 781843 781889 781923 781925 784964 794199 796797 797341 801527 801570 804271 804368 806301 811727 812055 813808 813818 819353 824067 827290 ] |
||||||||||||||||||||||||||||||
|
19.09 ms (9.42%) |
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 749016 781843 781923 726078 724878 742608 757543 401642 423869 423968 420304 650082 595253 658854 794199 813818 419549 530098 552275 582747 664587 664368 584039 617390 605565 438488 454393 456022 470431 475431 453194 468337 507751 517682 530860 558252 576487 545414 698123 715567 781889 801527 801570 806301 812055 811727 796797 462604 466346 391921 526747 390650 401613 485947 530430 578525 658453 459469 463982 445638 434709 443627 438430 443626 827290 824067 813808 455121 468157 464258 520227 532635 532634 539329 502835 528036 530127 554488 557406 562426 567083 574649 543970 582440 583287 706029 658477 707518 568228 584010 584045 620119 640350 784964 797341 732782 733503 772062 758154 771642 781925 443632 456979 459959 398972 454561 470410 527919 495278 804271 804368 443579 443629 819353 454171 469420 459446 463898 466886 445838 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.36%) |
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 390650 391921 398972 401613 401642 419549 420304 423869 423968 434709 438430 438488 443579 443626 443627 443629 443632 445638 445838 453194 454171 454393 454561 455121 456022 456979 459446 459469 459959 462604 463898 463982 464258 466346 466886 468157 468337 469420 470410 470431 475431 485947 495278 502835 507751 517682 520227 526747 527919 528036 530098 530127 530430 530860 532634 532635 539329 543970 545414 552275 554488 557406 558252 562426 567083 568228 574649 576487 578525 582440 582747 583287 584010 584039 584045 595253 605565 617390 620119 640350 650082 658453 658477 658854 664368 664587 698123 706029 707518 715567 724878 726078 732782 733503 742608 749016 757543 758154 771642 772062 781843 781889 781923 781925 784964 794199 796797 797341 801527 801570 804271 804368 806301 811727 812055 813808 813818 819353 824067 827290 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw amateur"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw любительск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw любительск"
]
|
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.