Query Metrics
7
Database Queries
7
Different statements
172.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.16 ms (85.41%) |
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 407835 418269 426006 426875 444349 450583 459258 460003 460951 486613 487790 488277 490638 495822 496462 510901 512200 521615 525728 526590 527459 527624 529774 534657 536062 537480 540196 544899 546241 549295 552848 554307 554791 555982 556057 556085 557060 557635 560071 573369 580097 584065 585261 587108 587941 588419 588427 589668 591781 591832 591836 591869 595690 596522 601777 602318 605387 609554 609908 614059 619230 620957 628562 630129 630465 634371 643201 643447 643737 660032 666072 666684 666709 666711 681491 687620 692720 693767 694193 696125 697654 699082 700468 705999 706029 706041 706380 710331 714372 714703 720459 726448 730783 732951 736943 739783 742822 744183 746039 750626 780730 785340 793638 799367 801764 802251 802278 804793 805398 806035 806064 806741 810008 817789 818351 819244 821023 823181 823713 824857 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.51%) |
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 736943 460951 554307 537480 496462 706041 605387 630129 687620 806064 817789 819244 824857 557060 694193 706380 714372 589668 643447 587108 588427 591869 780730 744183 742822 487790 546241 591832 802251 802278 460003 818351 821023 823713 549295 692720 714703 666072 666684 696125 588419 591781 785340 730783 726448 746039 602318 643737 699082 710331 488277 706029 720459 556085 585261 614059 609554 801764 705999 534657 418269 450583 486613 459258 580097 700468 619230 554791 495822 512200 527459 544899 693767 591836 609908 587941 620957 630465 628562 806035 426875 552848 527624 426006 536062 555982 573369 595690 596522 407835 525728 556057 557635 666709 584065 601777 643201 490638 823181 510901 540196 526590 521615 529774 560071 681491 697654 660032 666711 799367 805398 810008 750626 804793 732951 739783 634371 793638 806741 444349 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.04%) |
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 407835 418269 426006 426875 444349 450583 459258 460003 460951 486613 487790 488277 490638 495822 496462 510901 512200 521615 525728 526590 527459 527624 529774 534657 536062 537480 540196 544899 546241 549295 552848 554307 554791 555982 556057 556085 557060 557635 560071 573369 580097 584065 585261 587108 587941 588419 588427 589668 591781 591832 591836 591869 595690 596522 601777 602318 605387 609554 609908 614059 619230 620957 628562 630129 630465 634371 643201 643447 643737 660032 666072 666684 666709 666711 681491 687620 692720 693767 694193 696125 697654 699082 700468 705999 706029 706041 706380 710331 714372 714703 720459 726448 730783 732951 736943 739783 742822 744183 746039 750626 780730 785340 793638 799367 801764 802251 802278 804793 805398 806035 806064 806741 810008 817789 818351 819244 821023 823181 823713 824857 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy wet pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая мокрые pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая мокрые pussy"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.