Query Metrics
8
Database Queries
8
Different statements
1099.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
624.89 ms (56.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секс"
]
|
||||||||||||||||||||||||||||||
|
236.26 ms (21.49%) |
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 66768 233889 271638 365880 382134 382184 383338 384581 384752 387377 389117 390653 390898 391380 391576 392563 392729 393102 398535 401204 402897 403321 403322 406593 407686 407761 408245 409310 411349 411409 411727 411773 411918 419146 428138 439488 439574 440868 448996 454222 465376 466114 466189 467541 471411 472608 472675 474095 474810 474843 478362 479034 479090 479091 479129 480921 482386 484560 484638 484656 484763 485755 486341 490187 492292 502001 510889 511541 513194 515917 521121 524778 526701 526703 544504 558295 563189 563226 563227 563436 567344 569149 575177 582583 589752 591877 601869 614514 619531 629847 663982 664290 667196 667291 668888 693325 696316 712332 719898 724233 729209 730094 732373 743803 744994 746632 748234 758118 776339 781743 781930 781995 808049 808558 816771 818996 820298 823800 824456 825114 ] |
||||||||||||||||||||||||||||||
|
213.97 ms (19.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секс"
]
|
||||||||||||||||||||||||||||||
|
15.32 ms (1.39%) |
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 484656 808049 730094 823800 729209 746632 271638 401204 407761 419146 824456 563436 667196 663982 563227 589752 591877 776339 724233 743803 744994 403321 478362 479090 390898 402897 403322 521121 484560 510889 474095 466189 439574 486341 384581 411727 411773 474843 664290 667291 668888 696316 712332 601869 781743 808558 781930 233889 492292 384752 383338 392729 382184 382134 390653 406593 407686 408245 409310 816771 825114 472608 484763 490187 474810 526701 526703 582583 544504 558295 563226 569149 575177 719898 693325 563189 567344 614514 781995 748234 758118 732373 619531 629847 391576 393102 466114 479034 482386 411918 467541 365880 387377 391380 411409 439488 448996 479129 480921 389117 392563 411349 428138 440868 454222 465376 472675 479091 502001 513194 484638 485755 515917 524778 511541 471411 66768 398535 818996 820298 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.26%) |
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 66768 233889 271638 365880 382134 382184 383338 384581 384752 387377 389117 390653 390898 391380 391576 392563 392729 393102 398535 401204 402897 403321 403322 406593 407686 407761 408245 409310 411349 411409 411727 411773 411918 419146 428138 439488 439574 440868 448996 454222 465376 466114 466189 467541 471411 472608 472675 474095 474810 474843 478362 479034 479090 479091 479129 480921 482386 484560 484638 484656 484763 485755 486341 490187 492292 502001 510889 511541 513194 515917 521121 524778 526701 526703 544504 558295 563189 563226 563227 563436 567344 569149 575177 582583 589752 591877 601869 614514 619531 629847 663982 664290 667196 667291 668888 693325 696316 712332 719898 724233 729209 730094 732373 743803 744994 746632 748234 758118 776339 781743 781930 781995 808049 808558 816771 818996 820298 823800 824456 825114 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature fuck"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.18%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01“µJ#OpË‹B§(1\x05\vm"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.