Query Metrics
7
Database Queries
7
Different statements
437.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.99 ms (94.60%) |
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 367962 386751 391296 395662 412330 415878 415977 416029 418697 420774 423971 426994 432679 432692 432708 432727 432735 432736 439071 439078 443309 443475 445401 451121 453234 454533 454535 454537 455640 458383 459970 460167 461372 462198 462930 468969 469591 470411 471082 471445 471648 471666 473005 473129 473317 475885 476292 478949 481846 485966 492454 493164 494649 497773 499350 500341 500982 502717 508164 508257 509427 511186 514254 516940 517397 517513 524864 526744 527144 528671 529356 530270 531303 534557 539282 543129 545905 546981 549707 554372 555131 555281 555328 555420 555592 555964 558261 563036 564188 565734 570940 571708 580242 590410 618847 619828 643380 657777 664972 695386 701569 707556 716550 726753 742318 749242 751546 751609 759014 763876 785856 787488 794248 801795 802256 803424 804434 809811 812542 819511 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (3.21%) |
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 494649 432679 443309 443475 415977 454533 455640 458383 453234 471082 511186 526744 524864 528671 460167 555281 570940 571708 545905 543129 546981 554372 555131 695386 657777 549707 555328 555964 563036 564188 565734 619828 643380 787488 812542 803424 809811 742318 751609 759014 763876 794248 801795 804434 423971 395662 454537 473005 473317 502717 509427 500341 462930 476292 493164 412330 420774 432708 432727 432735 432736 439071 415878 819511 454535 461372 470411 481846 485966 514254 530270 517513 529356 531303 534557 469591 471666 555592 580242 707556 716550 701569 664972 618847 590410 785856 802256 726753 749242 751546 478949 468969 391296 367962 473129 475885 508164 499350 517397 426994 386751 418697 439078 416029 432692 445401 471445 451121 462198 492454 500982 516940 527144 539282 497773 508257 459970 471648 555420 558261 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (0.71%) |
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 367962 386751 391296 395662 412330 415878 415977 416029 418697 420774 423971 426994 432679 432692 432708 432727 432735 432736 439071 439078 443309 443475 445401 451121 453234 454533 454535 454537 455640 458383 459970 460167 461372 462198 462930 468969 469591 470411 471082 471445 471648 471666 473005 473129 473317 475885 476292 478949 481846 485966 492454 493164 494649 497773 499350 500341 500982 502717 508164 508257 509427 511186 514254 516940 517397 517513 524864 526744 527144 528671 529356 530270 531303 534557 539282 543129 545905 546981 549707 554372 555131 555281 555328 555420 555592 555964 558261 563036 564188 565734 570940 571708 580242 590410 618847 619828 643380 657777 664972 695386 701569 707556 716550 726753 742318 749242 751546 751609 759014 763876 785856 787488 794248 801795 802256 803424 804434 809811 812542 819511 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature shower вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature shower webcam"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature shower вебкамер"
]
|
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.