Query Metrics
7
Database Queries
7
Different statements
406.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.75 ms (52.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член секс"
]
|
||||||||||||||||||||||||||||||
|
169.52 ms (41.66%) |
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 6941 14806 86313 120264 161342 187595 281801 295200 359089 382120 382591 383747 383926 383950 385829 387192 389239 390388 390407 390738 393218 395175 395753 396541 396672 396673 396702 396843 398368 399439 399516 399990 402726 404811 406690 407270 407725 408196 411001 411467 412507 413302 419112 419242 426457 435372 436427 443543 447418 447628 448818 452306 452314 458486 461835 461836 462822 468798 471769 473775 477561 484285 493275 494086 499379 499818 502035 508513 509726 511988 514699 518774 520574 525112 526789 527252 528726 531435 532069 538054 540119 540695 541089 542612 542838 543351 543916 571001 579296 584176 587725 601374 614990 622403 630861 632394 639571 651425 664702 674102 693025 714415 719856 720359 730902 740447 744965 745723 756057 756080 761553 764950 767291 780523 786748 792569 805304 806343 809256 819856 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (3.79%) |
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 395753 543916 383950 399516 396702 462822 527252 525112 786748 402726 413302 502035 693025 630861 542838 484285 396672 404811 443543 756080 458486 509726 461835 542612 740447 406690 540119 720359 714415 674102 651425 359089 390407 408196 452306 447628 511988 541089 571001 601374 730902 761553 187595 6941 398368 382120 393218 419112 538054 396541 419242 161342 281801 468798 584176 792569 499818 383926 14806 622403 614990 809256 390738 528726 543351 461836 745723 412507 295200 540695 719856 806343 632394 86313 435372 382591 399439 411001 587725 395175 411467 639571 494086 532069 436427 493275 579296 819856 780523 477561 767291 756057 514699 499379 764950 518774 520574 664702 385829 471769 744965 387192 399990 407725 805304 396843 389239 390388 426457 508513 447418 120264 473775 531435 407270 448818 396673 452314 383747 526789 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.72%) |
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 6941 14806 86313 120264 161342 187595 281801 295200 359089 382120 382591 383747 383926 383950 385829 387192 389239 390388 390407 390738 393218 395175 395753 396541 396672 396673 396702 396843 398368 399439 399516 399990 402726 404811 406690 407270 407725 408196 411001 411467 412507 413302 419112 419242 426457 435372 436427 443543 447418 447628 448818 452306 452314 458486 461835 461836 462822 468798 471769 473775 477561 484285 493275 494086 499379 499818 502035 508513 509726 511988 514699 518774 520574 525112 526789 527252 528726 531435 532069 538054 540119 540695 541089 542612 542838 543351 543916 571001 579296 584176 587725 601374 614990 622403 630861 632394 639571 651425 664702 674102 693025 714415 719856 720359 730902 740447 744965 745723 756057 756080 761553 764950 767291 780523 786748 792569 805304 806343 809256 819856 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick sex"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.37%) |
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.