Query Metrics
7
Database Queries
7
Different statements
160.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.99 ms (81.50%) |
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 6953 76172 117073 210072 256949 321814 382117 382726 386421 393472 414692 419109 424333 425913 425954 427994 453107 453461 459900 460631 460705 466257 472727 477883 480515 481287 485723 491526 509063 514946 523285 526111 526115 529384 531901 534780 537692 550330 576018 576390 587161 590955 592395 599676 600472 604556 606766 607371 620857 626292 634162 635306 641115 648218 650193 651199 653261 655832 656317 665790 672975 678574 679080 679124 679126 679127 679128 689701 690797 690824 690841 690870 691496 691510 692263 693059 694010 694072 694212 694469 694487 695246 695613 695628 695924 695948 697263 697369 697806 697978 698407 698557 699751 718784 719807 722199 725566 729894 731837 733882 759325 760214 781885 800517 805777 809325 813357 814752 814758 814853 815525 815530 815589 815619 816270 816363 816388 816427 816466 820766 ] |
||||||||||||||||||||||||||||||
|
20.00 ms (12.45%) |
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 692263 694469 695924 719807 382117 256949 814853 531901 529384 534780 695613 650193 809325 760214 480515 509063 695628 653261 678574 679126 695948 689701 697978 117073 393472 382726 425913 321814 6953 424333 815525 815619 816270 816388 816427 816363 820766 453461 477883 526115 679127 679128 690870 699751 718784 651199 697369 698557 695246 697263 600472 599676 729894 731837 210072 425954 414692 427994 814752 814758 815589 816466 460631 576390 679080 690841 694487 655832 672975 694212 722199 576018 592395 620857 805777 604556 626292 641115 459900 460705 491526 523285 76172 419109 815530 472727 453107 485723 537692 514946 679124 690797 691510 648218 656317 691496 694010 694072 698407 665790 635306 587161 590955 607371 781885 800517 813357 733882 725566 759325 606766 634162 697806 481287 466257 526111 386421 550330 690824 693059 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.96%) |
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 6953 76172 117073 210072 256949 321814 382117 382726 386421 393472 414692 419109 424333 425913 425954 427994 453107 453461 459900 460631 460705 466257 472727 477883 480515 481287 485723 491526 509063 514946 523285 526111 526115 529384 531901 534780 537692 550330 576018 576390 587161 590955 592395 599676 600472 604556 606766 607371 620857 626292 634162 635306 641115 648218 650193 651199 653261 655832 656317 665790 672975 678574 679080 679124 679126 679127 679128 689701 690797 690824 690841 690870 691496 691510 692263 693059 694010 694072 694212 694469 694487 695246 695613 695628 695924 695948 697263 697369 697806 697978 698407 698557 699751 718784 719807 722199 725566 729894 731837 733882 759325 760214 781885 800517 805777 809325 813357 814752 814758 814853 815525 815530 815589 815619 816270 816363 816388 816427 816466 820766 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс scene"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2023 sex scene"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс scene"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.87%) |
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.