Query Metrics
7
Database Queries
7
Different statements
193.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.04 ms (85.82%) |
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 381767 383118 386786 393868 395249 398053 401213 401816 417265 429583 431484 435727 448859 452530 466395 473019 479277 483551 492573 493298 500271 508485 512190 520244 523326 524178 525091 529447 532252 532255 536987 543355 546493 547099 549087 552919 553812 556423 558373 558377 559162 561882 562406 571089 573213 575308 575344 578156 578293 581209 583444 583666 586002 588221 591795 592052 594282 596714 596919 601200 603445 605421 608625 609847 611314 612339 615627 617921 619439 622629 634312 635590 635659 640922 642426 642486 643472 643808 645644 649168 651512 652380 658224 673144 680538 693612 698853 714578 715574 719600 721522 731497 732395 733911 734400 735623 743897 744058 748685 749532 754179 757158 758732 759537 762980 771830 776208 784464 785210 786461 791307 793919 795691 795708 807755 810242 818351 821096 821655 821745 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (8.25%) |
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 791307 546493 578293 561882 401213 508485 754179 673144 810242 731497 435727 793919 795708 795691 715574 609847 393868 785210 578156 381767 575344 611314 784464 721522 733911 549087 757158 386786 635659 643472 622629 749532 573213 429583 473019 575308 652380 547099 642486 608625 643808 492573 417265 658224 748685 401816 562406 734400 452530 383118 591795 524178 821096 818351 605421 732395 735623 588221 395249 448859 500271 398053 649168 523326 821655 512190 553812 645644 680538 635590 552919 466395 601200 651512 640922 642426 743897 759537 807755 771830 559162 431484 558377 532252 586002 634312 581209 762980 744058 821745 479277 698853 592052 594282 596919 615627 758732 617921 483551 536987 525091 543355 693612 612339 776208 558373 719600 583666 596714 493298 583444 571089 603445 786461 714578 619439 520244 532255 529447 556423 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.01%) |
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 381767 383118 386786 393868 395249 398053 401213 401816 417265 429583 431484 435727 448859 452530 466395 473019 479277 483551 492573 493298 500271 508485 512190 520244 523326 524178 525091 529447 532252 532255 536987 543355 546493 547099 549087 552919 553812 556423 558373 558377 559162 561882 562406 571089 573213 575308 575344 578156 578293 581209 583444 583666 586002 588221 591795 592052 594282 596714 596919 601200 603445 605421 608625 609847 611314 612339 615627 617921 619439 622629 634312 635590 635659 640922 642426 642486 643472 643808 645644 649168 651512 652380 658224 673144 680538 693612 698853 714578 715574 719600 721522 731497 732395 733911 734400 735623 743897 744058 748685 749532 754179 757158 758732 759537 762980 771830 776208 784464 785210 786461 791307 793919 795691 795708 807755 810242 818351 821096 821655 821745 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight pussy asian"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight pussy азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight 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.