Query Metrics
7
Database Queries
7
Different statements
160.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.32 ms (82.81%) |
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 131602 397420 409274 410356 414104 415878 420774 420816 429594 436684 438207 447553 450920 452548 460338 465918 466601 466903 477691 494385 499059 500772 504173 509439 510170 511127 514034 515060 522295 529713 532939 535319 538395 541969 544001 545905 549502 555599 559377 560345 560679 563419 577284 579726 585680 587292 587313 587987 594131 597111 597691 598540 604412 607142 612457 618329 624164 625227 629243 629596 642158 651731 658939 659057 668628 678761 682397 690630 692718 700906 706446 712184 717300 719431 719461 729327 740336 741699 744047 744983 745128 751438 751546 751609 752614 752617 752619 752647 754184 754403 754843 765684 766943 766945 772755 778498 780357 781255 784662 786261 787716 790399 791024 791886 796509 797918 802898 803880 803915 805046 806010 806577 806937 808335 809811 812399 812542 813817 814363 814403 ] |
||||||||||||||||||||||||||||||
|
18.72 ms (11.63%) |
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 772755 651731 629596 754184 791024 805046 612457 741699 529713 420816 466601 410356 813817 690630 812399 436684 577284 420774 438207 579726 466903 597691 803915 585680 751609 509439 784662 781255 642158 729327 766945 791886 814363 700906 744983 803880 560679 625227 429594 541969 477691 587987 624164 514034 790399 752619 744047 587292 131602 560345 450920 499059 740336 587313 752614 814403 629243 465918 754843 682397 751438 752647 598540 504173 658939 797918 754403 717300 532939 778498 806577 752617 511127 559377 751546 545905 544001 787716 494385 522295 597111 719431 510170 563419 397420 692718 809811 659057 786261 766943 745128 765684 515060 500772 538395 409274 712184 414104 594131 806937 802898 678761 549502 618329 780357 808335 806010 604412 460338 719461 796509 447553 535319 555599 668628 452548 415878 706446 607142 812542 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom dildo fuck"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.22%) |
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 131602 397420 409274 410356 414104 415878 420774 420816 429594 436684 438207 447553 450920 452548 460338 465918 466601 466903 477691 494385 499059 500772 504173 509439 510170 511127 514034 515060 522295 529713 532939 535319 538395 541969 544001 545905 549502 555599 559377 560345 560679 563419 577284 579726 585680 587292 587313 587987 594131 597111 597691 598540 604412 607142 612457 618329 624164 625227 629243 629596 642158 651731 658939 659057 668628 678761 682397 690630 692718 700906 706446 712184 717300 719431 719461 729327 740336 741699 744047 744983 745128 751438 751546 751609 752614 752617 752619 752647 754184 754403 754843 765684 766943 766945 772755 778498 780357 781255 784662 786261 787716 790399 791024 791886 796509 797918 802898 803880 803915 805046 806010 806577 806937 808335 809811 812399 812542 813817 814363 814403 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.97%) |
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.