Query Metrics
7
Database Queries
7
Different statements
157.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.85 ms (83.30%) |
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 41888 80821 88486 104551 105845 185377 341596 384325 385245 385908 390593 392465 393087 397307 400097 407359 408626 409150 415658 416295 420363 429818 430057 431139 432115 444698 445024 445814 454203 457154 462347 470083 473112 475343 475896 480513 488200 507013 507123 529372 540457 542300 554809 555783 559612 560092 562992 565647 571724 576448 586468 605828 606768 612476 618030 622888 638266 653211 653523 660342 664237 664815 665433 666662 667846 675964 678981 681304 683604 689758 693388 693457 696310 705262 708505 710848 714795 718520 720388 721422 721461 721741 728094 733085 733100 734702 737169 745765 750316 760550 764864 765147 772914 773438 773928 774591 775555 775980 789556 790021 790748 791555 792578 801093 803328 804943 805298 805456 805992 806167 807593 810147 810156 810349 811488 811629 814297 819404 822522 827825 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (9.64%) |
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 708505 721422 664815 666662 675964 689758 721741 554809 560092 612476 618030 605828 801093 803328 805298 811629 774591 775555 805992 810147 811488 733100 734702 745765 750316 760550 764864 773928 791555 792578 805456 807593 810156 810349 728094 733085 772914 773438 737169 765147 606768 638266 705262 714795 775980 790021 790748 806167 80821 105845 407359 416295 454203 88486 457154 462347 392465 397307 408626 475343 431139 475896 822522 341596 415658 819404 507123 804943 789556 104551 432115 430057 445814 507013 571724 653523 681304 586468 622888 444698 385908 384325 385245 185377 393087 41888 390593 400097 409150 420363 445024 429818 814297 827825 480513 488200 540457 529372 470083 473112 565647 559612 562992 576448 542300 555783 665433 678981 721461 653211 664237 693388 696310 710848 718520 660342 667846 683604 693457 720388 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.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 41888 80821 88486 104551 105845 185377 341596 384325 385245 385908 390593 392465 393087 397307 400097 407359 408626 409150 415658 416295 420363 429818 430057 431139 432115 444698 445024 445814 454203 457154 462347 470083 473112 475343 475896 480513 488200 507013 507123 529372 540457 542300 554809 555783 559612 560092 562992 565647 571724 576448 586468 605828 606768 612476 618030 622888 638266 653211 653523 660342 664237 664815 665433 666662 667846 675964 678981 681304 683604 689758 693388 693457 696310 705262 708505 710848 714795 718520 720388 721422 721461 721741 728094 733085 733100 734702 737169 745765 750316 760550 764864 765147 772914 773438 773928 774591 775555 775980 789556 790021 790748 791555 792578 801093 803328 804943 805298 805456 805992 806167 807593 810147 810156 810349 811488 811629 814297 819404 822522 827825 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy blonde"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy беловолосая"
]
|
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.