Query Metrics
7
Database Queries
7
Different statements
436.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.23 ms (49.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
193.19 ms (44.22%) |
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 263039 382108 402507 404422 408241 410851 418372 418946 420061 425921 426826 427132 429278 436742 437484 438878 443914 446543 447220 452341 452899 452903 456024 460227 468024 471939 477244 477249 479854 489312 493220 493909 496301 500957 501313 503486 515435 515959 525209 529792 533707 535298 536496 541567 545451 545460 554166 555998 556755 557679 575357 585154 586339 587030 588332 588932 591487 595028 596240 604062 604865 608380 609930 622663 625753 630280 653505 653555 664471 664972 666590 669000 680592 682347 683062 696499 700259 705427 708013 730485 731404 734126 739413 740803 741119 752785 763720 770541 772617 774227 779868 780242 782821 785663 786660 786726 787524 787528 789042 793671 793941 794680 795406 795774 796071 800884 801236 806933 809009 812495 812690 813918 814446 814455 814802 815152 815969 826465 826475 826766 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (3.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 814802 682347 785663 529792 680592 774227 503486 541567 515435 587030 588932 452341 452899 669000 545460 263039 683062 588332 780242 705427 382108 591487 795774 447220 515959 493909 826766 708013 700259 786660 608380 622663 525209 786726 793941 501313 471939 696499 666590 812690 468024 814446 787528 794680 418946 489312 596240 437484 436742 477244 452903 779868 604062 408241 427132 404422 815152 609930 425921 402507 630280 557679 585154 731404 545451 479854 586339 555998 418372 477249 787524 740803 536496 460227 426826 595028 625753 604865 826475 575357 653505 806933 752785 739413 770541 420061 556755 535298 456024 763720 443914 653555 796071 741119 730485 734126 446543 493220 664972 826465 554166 429278 814455 664471 789042 782821 793671 812495 772617 500957 496301 800884 813918 801236 533707 795406 410851 438878 815969 809009 ] |
||||||||||||||||||||||||||||||
|
3.88 ms (0.89%) |
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 263039 382108 402507 404422 408241 410851 418372 418946 420061 425921 426826 427132 429278 436742 437484 438878 443914 446543 447220 452341 452899 452903 456024 460227 468024 471939 477244 477249 479854 489312 493220 493909 496301 500957 501313 503486 515435 515959 525209 529792 533707 535298 536496 541567 545451 545460 554166 555998 556755 557679 575357 585154 586339 587030 588332 588932 591487 595028 596240 604062 604865 608380 609930 622663 625753 630280 653505 653555 664471 664972 666590 669000 680592 682347 683062 696499 700259 705427 708013 730485 731404 734126 739413 740803 741119 752785 763720 770541 772617 774227 779868 780242 782821 785663 786660 786726 787524 787528 789042 793671 793941 794680 795406 795774 796071 800884 801236 806933 809009 812495 812690 813918 814446 814455 814802 815152 815969 826465 826475 826766 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits squirt"
]
|
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.