Query Metrics
7
Database Queries
7
Different statements
395.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.73 ms (52.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal dildo beautiful"
]
|
||||||||||||||||||||||||||||||
|
160.62 ms (40.63%) |
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 17093 96524 202032 392333 396640 401904 406171 416192 419933 426592 427232 430709 433507 436703 437518 437925 438464 439218 446238 448057 448575 448851 450410 452014 452809 458921 463815 466404 470064 471813 475414 476676 481142 482632 484278 487815 488537 491644 495558 495559 495793 496585 508133 509981 514845 515358 515747 520785 522307 527568 531123 532963 533049 536248 536388 536645 537195 537236 537943 540348 545488 561970 565263 566863 569359 572777 579523 582540 587085 600021 600337 601512 605333 612399 620901 621252 628334 632289 632628 633813 634546 634565 634780 636315 637442 639254 641956 642775 644327 644913 646824 647972 649514 649566 651634 666867 667748 672686 676023 677432 700257 700996 713876 719001 722264 722692 743383 748690 751452 751582 758216 758615 766825 782633 784054 787515 791012 795690 808988 826672 ] |
||||||||||||||||||||||||||||||
|
19.14 ms (4.84%) |
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 646824 566863 634565 639254 766825 758615 601512 791012 520785 488537 515747 677432 636315 446238 463815 419933 481142 515358 532963 651634 676023 582540 628334 637442 612399 600337 641956 452809 649566 633813 758216 448851 202032 826672 448057 572777 722264 700257 722692 672686 569359 587085 620901 644327 782633 795690 808988 748690 787515 751452 605333 632289 514845 536645 561970 579523 470064 96524 396640 401904 496585 536388 509981 527568 437518 437925 565263 713876 743383 751582 17093 471813 439218 537943 484278 642775 436703 426592 487815 491644 452014 537236 531123 545488 600021 634780 466404 475414 508133 522307 450410 430709 495558 495793 634546 621252 495559 784054 406171 482632 427232 476676 644913 536248 647972 649514 667748 632628 416192 448575 392333 438464 433507 458921 537195 533049 540348 700996 719001 666867 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (0.85%) |
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 17093 96524 202032 392333 396640 401904 406171 416192 419933 426592 427232 430709 433507 436703 437518 437925 438464 439218 446238 448057 448575 448851 450410 452014 452809 458921 463815 466404 470064 471813 475414 476676 481142 482632 484278 487815 488537 491644 495558 495559 495793 496585 508133 509981 514845 515358 515747 520785 522307 527568 531123 532963 533049 536248 536388 536645 537195 537236 537943 540348 545488 561970 565263 566863 569359 572777 579523 582540 587085 600021 600337 601512 605333 612399 620901 621252 628334 632289 632628 633813 634546 634565 634780 636315 637442 639254 641956 642775 644327 644913 646824 647972 649514 649566 651634 666867 667748 672686 676023 677432 700257 700996 713876 719001 722264 722692 743383 748690 751452 751582 758216 758615 766825 782633 784054 787515 791012 795690 808988 826672 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дилд красивая"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дилд красивая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
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.