Query Metrics
7
Database Queries
7
Different statements
170.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.73 ms (81.95%) |
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 107606 185353 310758 373897 381775 381871 396781 401084 401100 401944 413258 413544 415151 417701 418270 418530 418597 420331 423615 424312 425121 426153 427992 428238 428742 429223 433137 444841 445837 447494 447537 447538 453081 456069 466455 468166 469528 470511 471779 474590 474601 476143 476176 479759 480135 480306 482075 482081 484819 485031 485160 486077 487370 487708 490863 491457 491569 491941 493399 494386 496725 498536 501649 501831 508876 512770 514386 515867 516848 517106 517580 519555 519565 519573 521899 531194 534060 534218 536256 536861 537934 559951 560642 561632 561829 561834 563647 570462 570537 575723 576314 578478 586546 586601 594164 596649 607093 607900 619552 628090 633746 655084 667026 669717 673767 680146 717832 722478 741249 753480 769325 769793 779706 788119 788901 788911 789308 795163 800545 801284 ] |
||||||||||||||||||||||||||||||
|
19.48 ms (11.42%) |
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 185353 401084 381871 561829 586601 468166 418530 536861 491457 800545 741249 433137 515867 424312 536256 655084 788901 417701 491569 753480 619552 418597 788911 788119 415151 447494 576314 469528 476176 485160 560642 480135 413258 373897 673767 680146 107606 607900 769325 779706 396781 667026 570537 426153 429223 482081 474601 401944 521899 516848 519573 484819 501831 517106 501649 471779 559951 413544 486077 447537 487708 512770 519565 485031 517580 722478 563647 607093 474590 479759 418270 466455 490863 491941 519555 493399 534218 578478 514386 633746 420331 487370 428238 425121 476143 456069 498536 596649 480306 427992 447538 717832 669717 769793 401100 789308 801284 531194 628090 423615 310758 428742 445837 575723 561632 570462 594164 586546 795163 444841 453081 381775 482075 508876 494386 534060 496725 470511 537934 561834 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.02%) |
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 107606 185353 310758 373897 381775 381871 396781 401084 401100 401944 413258 413544 415151 417701 418270 418530 418597 420331 423615 424312 425121 426153 427992 428238 428742 429223 433137 444841 445837 447494 447537 447538 453081 456069 466455 468166 469528 470511 471779 474590 474601 476143 476176 479759 480135 480306 482075 482081 484819 485031 485160 486077 487370 487708 490863 491457 491569 491941 493399 494386 496725 498536 501649 501831 508876 512770 514386 515867 516848 517106 517580 519555 519565 519573 521899 531194 534060 534218 536256 536861 537934 559951 560642 561632 561829 561834 563647 570462 570537 575723 576314 578478 586546 586601 594164 596649 607093 607900 619552 628090 633746 655084 667026 669717 673767 680146 717832 722478 741249 753480 769325 769793 779706 788119 788901 788911 789308 795163 800545 801284 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал сиськ красивая"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð░ð╗ Ðüð©ÐüÐîð║ð© ð║ÐÇð░Ðüð░ð▓ð©ÐåðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.94%) |
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.