Query Metrics
7
Database Queries
7
Different statements
152.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.98 ms (79.56%) |
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 73413 149261 184943 185038 185109 185401 185412 185563 205147 205205 239495 270386 282864 322773 357806 357845 357886 381769 382202 382650 382745 382807 383553 383660 383912 384986 386697 389135 390219 390241 390535 390804 391036 393080 393848 395554 401361 402607 404032 406191 406425 408043 409630 409867 410026 420341 446969 448945 454942 460134 460707 467011 469820 494392 500689 507129 510049 516032 526826 539750 580644 583110 583213 584200 593481 604497 605875 608071 610142 610181 622039 624285 625036 628346 636032 641663 643443 664795 666324 700805 702063 708768 726716 727454 728067 738927 741631 744467 744468 753784 759782 765482 770007 770159 772942 776766 782408 782420 784270 785707 792680 793489 793591 797700 799522 799598 799626 800324 802686 803160 803595 810789 811662 815691 816818 818725 825204 825210 827860 828714 ] |
||||||||||||||||||||||||||||||
|
19.63 ms (12.91%) |
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 799626 776766 785707 770159 797700 802686 185412 393080 406425 625036 185109 446969 393848 516032 382202 390219 383912 708768 239495 382807 381769 583213 610181 793489 744468 744467 726716 322773 539750 628346 765482 401361 410026 469820 185563 409867 409630 825204 827860 666324 664795 738927 383553 149261 382650 799598 810789 800324 811662 772942 784270 205205 395554 580644 700805 636032 799522 510049 386697 73413 803160 759782 583110 420341 390241 391036 402607 608071 782408 270386 610142 494392 818725 357845 357886 390535 404032 408043 816818 184943 185038 406191 604497 605875 622039 643443 782420 741631 727454 641663 460707 792680 770007 383660 357806 389135 507129 584200 825210 815691 828714 753784 702063 185401 390804 624285 593481 803595 728067 793591 384986 467011 500689 282864 448945 526826 205147 454942 460134 382745 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.28%) |
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 73413 149261 184943 185038 185109 185401 185412 185563 205147 205205 239495 270386 282864 322773 357806 357845 357886 381769 382202 382650 382745 382807 383553 383660 383912 384986 386697 389135 390219 390241 390535 390804 391036 393080 393848 395554 401361 402607 404032 406191 406425 408043 409630 409867 410026 420341 446969 448945 454942 460134 460707 467011 469820 494392 500689 507129 510049 516032 526826 539750 580644 583110 583213 584200 593481 604497 605875 608071 610142 610181 622039 624285 625036 628346 636032 641663 643443 664795 666324 700805 702063 708768 726716 727454 728067 738927 741631 744467 744468 753784 759782 765482 770007 770159 772942 776766 782408 782420 784270 785707 792680 793489 793591 797700 799522 799598 799626 800324 802686 803160 803595 810789 811662 815691 816818 818725 825204 825210 827860 828714 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs massage"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs массаж"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs массаж"
]
|
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.