Query Metrics
7
Database Queries
7
Different statements
147.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.98 ms (83.32%) |
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 346054 365056 382578 415313 415988 416752 428224 429961 432939 439023 439038 441113 441233 444524 447159 449068 452547 459201 460070 465497 479549 480457 483704 487422 487519 497686 506516 508909 508938 512072 512935 514258 514876 519312 519316 519698 519765 529795 529799 530481 530942 531869 531880 534557 534576 534585 536140 536453 537861 538925 547463 547472 547483 547486 547496 547853 548443 550816 554851 554858 559355 568264 571846 572654 576545 576916 581006 581781 583665 586914 595483 599906 600087 600348 605155 610061 614328 628096 633887 634071 642035 648593 648869 658789 660373 660405 660411 660412 660419 661915 666016 669012 669056 669071 671018 671045 672950 680423 686106 705466 713142 717535 719651 723930 725629 727325 742353 744991 745136 770260 770265 782842 786911 788181 788907 791012 800282 805642 817221 827721 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (10.51%) |
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 530481 571846 633887 583665 487422 744991 346054 519765 547496 581781 595483 610061 782842 429961 432939 460070 459201 537861 531869 415988 480457 536453 382578 415313 536140 547472 547853 548443 547463 572654 605155 534576 534585 538925 719651 705466 727325 805642 441233 447159 497686 519312 547486 554851 547483 660405 660412 669056 680423 661915 666016 770265 514876 416752 506516 508909 519698 669012 576916 519316 508938 550816 568264 628096 648593 439038 428224 444524 441113 465497 449068 452547 512072 529795 512935 529799 530942 514258 531880 534557 581006 559355 669071 648869 660419 713142 717535 658789 660373 660411 671018 671045 672950 686106 576545 586914 599906 600348 634071 642035 614328 600087 723930 770260 725629 745136 786911 788907 791012 479549 439023 483704 487519 817221 742353 554858 788181 800282 365056 827721 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.70%) |
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 346054 365056 382578 415313 415988 416752 428224 429961 432939 439023 439038 441113 441233 444524 447159 449068 452547 459201 460070 465497 479549 480457 483704 487422 487519 497686 506516 508909 508938 512072 512935 514258 514876 519312 519316 519698 519765 529795 529799 530481 530942 531869 531880 534557 534576 534585 536140 536453 537861 538925 547463 547472 547483 547486 547496 547853 548443 550816 554851 554858 559355 568264 571846 572654 576545 576916 581006 581781 583665 586914 595483 599906 600087 600348 605155 610061 614328 628096 633887 634071 642035 648593 648869 658789 660373 660405 660411 660412 660419 661915 666016 669012 669056 669071 671018 671045 672950 680423 686106 705466 713142 717535 719651 723930 725629 727325 742353 744991 745136 770260 770265 782842 786911 788181 788907 791012 800282 805642 817221 827721 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ðÂðÁð¢Ðüð║ð©ð╣ Ðäð©ÐüÐéð©ð¢ð│ ð░ð¢ð░ð╗ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск фистинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.