Query Metrics
7
Database Queries
7
Different statements
182.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.99 ms (87.30%) |
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 382301 383098 392978 412632 417272 419058 419271 426560 427143 427513 429291 429508 430567 433679 441798 441952 446783 448059 451670 457593 464348 473935 477764 482566 490267 491357 494734 496336 497806 504060 510841 512792 513120 513982 521219 521230 522413 522617 523071 523726 524268 525396 527196 528150 528770 528936 530747 531533 533841 536375 536460 536470 540039 540084 540474 543849 546202 546829 547321 550952 556319 557452 559192 559668 567349 573193 607819 611730 613825 616787 621433 623656 629388 631301 631503 641938 642260 653396 662009 668512 701234 702149 705711 706569 717367 738487 738818 739860 741548 744904 745007 748479 754162 758261 758992 759243 759785 762140 764034 766830 781646 781663 782017 782203 782252 784504 785491 786472 791394 802842 804859 807516 810715 814640 814704 815150 816091 817753 819421 826180 ] |
||||||||||||||||||||||||||||||
|
13.81 ms (7.58%) |
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 464348 383098 392978 382301 427513 427143 433679 417272 429508 429291 817753 819421 826180 815150 814640 448059 451670 477764 490267 510841 512792 528150 530747 504060 513120 522617 523071 540039 524268 531533 533841 540084 540474 494734 522413 546829 547321 556319 559192 567349 653396 701234 702149 705711 668512 717367 557452 559668 611730 623656 641938 642260 621433 782203 786472 810715 738487 754162 781663 784504 802842 759243 744904 745007 738818 762140 764034 748479 758261 758992 607819 629388 631301 706569 781646 782017 782252 785491 791394 804859 419058 441798 457593 473935 412632 446783 528936 496336 527196 491357 497806 543849 441952 536460 513982 536375 536470 550952 573193 662009 546202 807516 741548 766830 739860 613825 523726 616787 525396 528770 521219 521230 631503 759785 430567 426560 419271 816091 814704 482566 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.50%) |
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 382301 383098 392978 412632 417272 419058 419271 426560 427143 427513 429291 429508 430567 433679 441798 441952 446783 448059 451670 457593 464348 473935 477764 482566 490267 491357 494734 496336 497806 504060 510841 512792 513120 513982 521219 521230 522413 522617 523071 523726 524268 525396 527196 528150 528770 528936 530747 531533 533841 536375 536460 536470 540039 540084 540474 543849 546202 546829 547321 550952 556319 557452 559192 559668 567349 573193 607819 611730 613825 616787 621433 623656 629388 631301 631503 641938 642260 653396 662009 668512 701234 702149 705711 706569 717367 738487 738818 739860 741548 744904 745007 748479 754162 758261 758992 759243 759785 762140 764034 766830 781646 781663 782017 782203 782252 784504 785491 786472 791394 802842 804859 807516 810715 814640 814704 815150 816091 817753 819421 826180 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass bondage"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.78%) |
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.