Query Metrics
7
Database Queries
7
Different statements
784.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
421.45 ms (53.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск черноволосая"
]
|
||||||||||||||||||||||||||||||
|
209.79 ms (26.74%) |
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 86241 125809 382693 385224 390012 391898 395809 396379 401374 403603 405687 407409 421637 421831 424024 424048 428035 429867 429950 435471 438540 438858 439659 443420 445092 447234 449316 449764 453960 455071 455194 455642 456589 457060 457109 458038 458333 461836 463235 467922 469308 470630 473933 474954 475853 478728 480662 481624 483528 485043 488037 488520 488961 490199 492986 493042 493937 495104 495929 498432 498847 500585 501679 507638 509586 511873 512402 514060 515264 521531 521629 521803 524690 526802 529470 546660 549596 553118 553354 554983 556537 557940 561291 567682 580206 584456 584690 588508 589813 591478 593197 593781 594045 594983 599115 599454 600439 602758 616545 618249 618345 621270 623230 637965 662449 664595 668815 671875 672317 686977 694044 696075 697166 708062 752913 823853 824718 826332 ] |
||||||||||||||||||||||||||||||
|
129.98 ms (16.57%) |
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 86241 125809 382693 385224 390012 391898 395809 396379 401374 403603 405687 407409 421637 421831 424024 424048 428035 429867 429950 435471 438540 438858 439659 443420 445092 447234 449316 449764 453960 455071 455194 455642 456589 457060 457109 458038 458333 461836 463235 467922 469308 470630 473933 474954 475853 478728 480662 481624 483528 485043 488037 488520 488961 490199 492986 493042 493937 495104 495929 498432 498847 500585 501679 507638 509586 511873 512402 514060 515264 521531 521629 521803 524690 526802 529470 546660 549596 553118 553354 554983 556537 557940 561291 567682 580206 584456 584690 588508 589813 591478 593197 593781 594045 594983 599115 599454 600439 602758 616545 618249 618345 621270 623230 637965 662449 664595 668815 671875 672317 686977 694044 696075 697166 708062 752913 823853 824718 826332 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (2.19%) |
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 396379 438540 447234 449316 455071 455642 467922 86241 445092 385224 401374 407409 424024 457060 458038 511873 495104 529470 488520 488961 429950 557940 521629 458333 553354 567682 580206 588508 623230 599115 752913 424048 469308 483528 493042 826332 382693 602758 594045 439659 823853 668815 618345 457109 480662 526802 492986 824784 825375 824718 478728 481624 495929 512402 493937 584456 546660 553118 708062 664595 686977 694044 697166 662449 672317 696075 556537 591478 616545 599454 593197 594983 600439 637965 589813 593781 618249 521531 490199 498847 488037 500585 514060 521803 671875 428035 435471 443420 449764 584690 561291 621270 438858 421831 429867 524690 507638 125809 391898 395809 390012 403603 405687 421637 453960 456589 455194 461836 463235 470630 473933 475853 498432 501679 509586 515264 474954 485043 549596 554983 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"домашнее брюнетки отÑ%…"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.24%) |
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.