Query Metrics
7
Database Queries
7
Different statements
374.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.06 ms (56.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"зрелые жены влагалищÐ…"
]
|
||||||||||||||||||||||||||||||
|
136.47 ms (36.41%) |
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 70852 78307 81022 111260 157194 382810 384457 389842 398527 409934 410683 411738 415287 418054 440399 442775 444073 446386 452659 457912 457993 457998 466883 468497 470639 470722 470768 471696 472675 474784 475769 476164 477881 478215 481259 484681 485418 486214 490598 492333 493486 493587 493740 501258 503836 504025 509192 513480 513624 513632 517272 517816 518762 518949 519361 526887 531546 534683 535454 536170 544120 549033 549243 549568 550575 554235 554997 555017 555028 555042 555063 555119 557577 561097 561526 563246 563939 566777 571399 571843 573742 585296 588155 593605 606185 615516 662087 680312 692701 714613 714620 718524 724252 726003 727789 727857 730347 733085 733265 737015 738359 748812 756551 756666 758355 761018 761323 761696 762301 767203 775202 780659 785876 788856 797206 797392 815835 817733 824035 824364 ] |
||||||||||||||||||||||||||||||
|
18.47 ms (4.93%) |
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 485418 492333 554997 472675 475769 517272 756666 470722 503836 509192 452659 493587 554235 571843 549568 157194 457998 444073 478215 535454 486214 518949 534683 517816 457993 555028 714613 733265 718524 484681 549243 824035 824364 457912 526887 566777 550575 481259 513632 70852 384457 446386 561526 501258 398527 470639 797206 442775 733085 573742 470768 724252 513480 111260 440399 466883 714620 785876 761323 727789 410683 468497 389842 78307 555063 561097 81022 536170 531546 692701 738359 588155 680312 767203 762301 571399 415287 815835 817733 471696 493740 518762 504025 493486 555042 662087 549033 606185 585296 593605 775202 727857 761696 788856 761018 748812 756551 758355 726003 730347 737015 615516 780659 797392 513624 519361 474784 411738 409934 418054 476164 563939 555119 477881 382810 563246 544120 490598 555017 557577 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (1.14%) |
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 70852 78307 81022 111260 157194 382810 384457 389842 398527 409934 410683 411738 415287 418054 440399 442775 444073 446386 452659 457912 457993 457998 466883 468497 470639 470722 470768 471696 472675 474784 475769 476164 477881 478215 481259 484681 485418 486214 490598 492333 493486 493587 493740 501258 503836 504025 509192 513480 513624 513632 517272 517816 518762 518949 519361 526887 531546 534683 535454 536170 544120 549033 549243 549568 550575 554235 554997 555017 555028 555042 555063 555119 557577 561097 561526 563246 563939 566777 571399 571843 573742 585296 588155 593605 606185 615516 662087 680312 692701 714613 714620 718524 724252 726003 727789 727857 730347 733085 733265 737015 738359 748812 756551 756666 758355 761018 761323 761696 762301 767203 775202 780659 785876 788856 797206 797392 815835 817733 824035 824364 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин жен вагин"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.38%) |
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.