Query Metrics
7
Database Queries
7
Different statements
206.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.18 ms (86.89%) |
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 419096 419312 420462 423846 427843 428497 433920 435724 435806 436765 444939 446510 447722 449466 449475 449545 449556 449998 450013 450715 450829 452184 452299 452754 454452 455978 457559 457901 459942 459966 460809 461034 461193 462281 463053 463471 465708 467970 469780 470767 476623 476841 478213 478238 480162 480334 480508 480697 481167 483786 487636 492462 495002 495356 496747 496750 497748 498550 505298 505526 507287 508226 509594 516537 517337 519536 520040 521041 522037 522782 525985 527595 533200 537814 539445 565027 566205 567525 572266 573165 577458 581232 582563 584482 585936 587876 591958 594219 594460 595244 602072 603786 605683 605702 617106 626245 637965 638727 641387 642162 664223 707617 709300 714300 722931 731609 740577 740787 745605 759690 772035 777003 784976 784981 796248 799052 806823 809876 812842 814272 ] |
||||||||||||||||||||||||||||||
|
16.46 ms (7.98%) |
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 480334 709300 714300 435724 480508 436765 419312 814272 452754 487636 449545 496750 602072 784976 784981 812842 423846 462281 480697 444939 459942 459966 603786 740787 731609 740577 806823 463053 519536 521041 509594 772035 591958 605683 594219 617106 577458 454452 642162 585936 777003 463471 450715 467970 495356 587876 707617 435806 419096 427843 498550 483786 497748 594460 799052 626245 637965 641387 461034 449466 505298 508226 572266 573165 565027 595244 449998 455978 461193 469780 420462 452184 584482 470767 476623 480162 745605 759690 495002 796248 517337 664223 449475 505526 537814 539445 449556 582563 507287 516537 605702 452299 481167 433920 522037 525985 527595 450829 478213 457901 450013 465708 522782 496747 460809 476841 478238 520040 809876 428497 446510 492462 533200 566205 638727 722931 447722 457559 581232 567525 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.53%) |
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 419096 419312 420462 423846 427843 428497 433920 435724 435806 436765 444939 446510 447722 449466 449475 449545 449556 449998 450013 450715 450829 452184 452299 452754 454452 455978 457559 457901 459942 459966 460809 461034 461193 462281 463053 463471 465708 467970 469780 470767 476623 476841 478213 478238 480162 480334 480508 480697 481167 483786 487636 492462 495002 495356 496747 496750 497748 498550 505298 505526 507287 508226 509594 516537 517337 519536 520040 521041 522037 522782 525985 527595 533200 537814 539445 565027 566205 567525 572266 573165 577458 581232 582563 584482 585936 587876 591958 594219 594460 595244 602072 603786 605683 605702 617106 626245 637965 638727 641387 642162 664223 707617 709300 714300 722931 731609 740577 740787 745605 759690 772035 777003 784976 784981 796248 799052 806823 809876 812842 814272 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов любительск cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov amateur cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов любительск cowgirl"
]
|
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.