Query Metrics
7
Database Queries
7
Different statements
177.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.51 ms (85.97%) |
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 31604 80900 82252 95990 147400 148793 191470 381764 381941 383362 383394 383926 384507 386366 386697 391340 393087 395145 396365 396571 397648 397807 398518 398613 399247 399273 399356 401379 401517 402350 404237 406191 409066 416931 443965 447795 453134 456991 463845 467105 467601 472575 479703 479708 493806 498485 529254 533306 538158 538440 545433 554525 556826 566054 575446 582445 601039 604498 609840 609993 613625 634216 634645 635356 636539 637754 641075 641548 643964 644375 663367 663438 673624 682076 682248 687532 689642 690884 697262 698027 705629 709309 715553 717313 717509 722549 723751 734794 744607 747729 754170 757458 761385 761563 770904 774243 774601 775607 775662 776599 783276 792572 792816 795522 800016 802688 803449 803669 805302 807774 808056 810233 811867 820662 822153 823401 824464 825241 827875 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (8.77%) |
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 717509 399356 404237 147400 825241 538440 698027 802688 770904 467105 811867 397648 399273 401379 582445 637754 386366 406191 409066 472575 463845 493806 479703 554525 774243 705629 381941 396365 148793 792572 467601 795522 800016 810233 697262 383394 824464 538158 663438 682248 663367 682076 717313 545433 609993 643964 604498 613625 644375 601039 634645 776599 807774 774601 723751 744607 761385 792816 709309 715553 805302 383362 393087 395145 398518 416931 822153 820662 823401 827875 529254 540323 556826 566054 689642 673624 634216 641075 775607 783276 803449 803669 747729 754170 757458 761563 609840 641548 722549 808056 479708 575446 383926 381764 95990 687532 635356 191470 384507 399247 386697 498485 80900 82252 31604 391340 397807 402350 401517 447795 456991 690884 636539 775662 734794 396571 398613 443965 453134 533306 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.74%) |
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 31604 80900 82252 95990 147400 148793 191470 381764 381941 383362 383394 383926 384507 386366 386697 391340 393087 395145 396365 396571 397648 397807 398518 398613 399247 399273 399356 401379 401517 402350 404237 406191 409066 416931 443965 447795 453134 456991 463845 467105 467601 472575 479703 479708 493806 498485 529254 533306 538158 538440 545433 554525 556826 566054 575446 582445 601039 604498 609840 609993 613625 634216 634645 635356 636539 637754 641075 641548 643964 644375 663367 663438 673624 682076 682248 687532 689642 690884 697262 698027 705629 709309 715553 717313 717509 722549 723751 734794 744607 747729 754170 757458 761385 761563 770904 774243 774601 775607 775662 776599 783276 792572 792816 795522 800016 802688 803449 803669 805302 807774 808056 810233 811867 820662 822153 823401 824464 825241 827875 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial tits"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.