Query Metrics
7
Database Queries
7
Different statements
213.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.53 ms (89.38%) |
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 206202 359918 373852 383266 383531 386596 389124 390024 390533 391027 395446 396708 400932 402546 410934 410935 413833 416319 417367 418724 420559 421520 426386 431675 443662 448552 448982 448993 454365 456430 460297 474642 475799 475933 476259 478548 478555 478779 478784 481145 482936 484411 492273 497590 503213 506195 508445 509425 516307 521823 522851 531237 531777 536394 537673 541252 541875 543821 544833 545602 546668 550305 558124 583670 598686 605003 606540 609568 614344 620130 632034 633454 633804 634213 637033 637087 638561 641965 642715 644689 645263 648836 660963 665681 665926 670820 671677 676024 678942 678943 682521 684048 684543 684547 684560 690859 696212 696352 696951 699554 707889 710832 714530 719391 720301 720823 720871 720882 721180 722809 756405 760957 766626 805023 813873 814069 814888 814975 817033 817448 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (6.55%) |
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 402546 817448 448993 660963 671677 684048 690859 558124 605003 642715 389124 391027 814888 536394 478548 478784 497590 416319 482936 417367 413833 400932 481145 478555 503213 541875 756405 766626 383266 390024 478779 521823 454365 460297 418724 544833 648836 359918 676024 696212 420559 390533 516307 474642 492273 583670 410935 410934 614344 431675 620130 508445 506195 598686 448552 682521 699554 373852 545602 606540 541252 421520 206202 670820 710832 396708 443662 531777 543821 641965 395446 475933 426386 813873 456430 475799 448982 484411 509425 684543 720882 645263 678942 721180 722809 684547 609568 632034 644689 634213 760957 696951 386596 522851 383531 814975 817033 814069 531237 537673 476259 550305 665681 684560 696352 714530 665926 678943 719391 720301 720823 707889 720871 546668 633454 637033 633804 638561 637087 805023 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.42%) |
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 206202 359918 373852 383266 383531 386596 389124 390024 390533 391027 395446 396708 400932 402546 410934 410935 413833 416319 417367 418724 420559 421520 426386 431675 443662 448552 448982 448993 454365 456430 460297 474642 475799 475933 476259 478548 478555 478779 478784 481145 482936 484411 492273 497590 503213 506195 508445 509425 516307 521823 522851 531237 531777 536394 537673 541252 541875 543821 544833 545602 546668 550305 558124 583670 598686 605003 606540 609568 614344 620130 632034 633454 633804 634213 637033 637087 638561 641965 642715 644689 645263 648836 660963 665681 665926 670820 671677 676024 678942 678943 682521 684048 684543 684547 684560 690859 696212 696352 696951 699554 707889 710832 714530 719391 720301 720823 720871 720882 721180 722809 756405 760957 766626 805023 813873 814069 814888 814975 817033 817448 ] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen мжм секс втро анал"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen mmf anal"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen мжм секс втро анал"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.62%) |
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.