Query Metrics
7
Database Queries
7
Different statements
157.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.70 ms (84.74%) |
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 340567 435539 455087 456563 459170 460280 465144 468348 469096 472746 484183 496454 514922 536465 544054 546291 546549 547371 547402 547415 547422 548174 548855 554447 555191 555202 555205 555210 555271 555298 555447 555761 557098 557826 559334 559399 559411 563280 563283 563685 564249 574073 575014 575250 576439 576605 577026 577266 581974 582522 583355 583410 584194 586459 591785 593082 594052 607099 609246 614254 615045 619210 625744 628019 628673 649296 651114 651629 651651 653031 658788 661680 666888 666905 668678 670019 672913 683467 685063 698255 704232 705013 712102 713141 713325 717443 719924 720655 727527 727534 728292 738390 739400 744143 744191 745121 747415 752595 754770 760054 761361 768792 769917 773817 773940 775460 775572 778897 783382 784326 785582 791783 793925 797218 799759 801197 803362 803364 807006 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (8.90%) |
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 582522 546291 547415 547422 554447 555202 555205 555210 555761 559411 577266 584194 649296 651629 653031 666888 668678 705013 651114 713141 658788 670019 685063 712102 546549 548174 548855 555271 557826 563280 564249 614254 615045 628673 594052 628019 609246 619210 625744 775572 775460 778897 783382 793925 801197 803362 803364 807006 739400 744191 760054 768792 797218 727534 728292 738390 727527 761361 769917 717443 719924 340567 484183 514922 661680 591785 773817 773940 720655 784326 460280 827931 698255 576605 744143 747415 713325 651651 754770 745121 791783 704232 607099 593082 799759 785582 752595 544054 555447 555298 557098 559399 581974 555191 574073 575250 586459 435539 468348 456563 455087 496454 469096 583355 472746 465144 459170 536465 559334 576439 577026 583410 547371 547402 575014 563283 563685 683467 666905 672913 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.72%) |
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 340567 435539 455087 456563 459170 460280 465144 468348 469096 472746 484183 496454 514922 536465 544054 546291 546549 547371 547402 547415 547422 548174 548855 554447 555191 555202 555205 555210 555271 555298 555447 555761 557098 557826 559334 559399 559411 563280 563283 563685 564249 574073 575014 575250 576439 576605 577026 577266 581974 582522 583355 583410 584194 586459 591785 593082 594052 607099 609246 614254 615045 619210 625744 628019 628673 649296 651114 651629 651651 653031 658788 661680 666888 666905 668678 670019 672913 683467 685063 698255 704232 705013 712102 713141 713325 717443 719924 720655 727527 727534 728292 738390 739400 744143 744191 745121 747415 752595 754770 760054 761361 768792 769917 773817 773940 775460 775572 778897 783382 784326 785582 791783 793925 797218 799759 801197 803362 803364 807006 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape vagina"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.01%) |
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.