Query Metrics
7
Database Queries
7
Different statements
170.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.85 ms (85.78%) |
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 20617 312919 343227 382022 386335 386698 388570 413612 419777 430455 430574 433594 434209 441965 447132 450639 455227 460974 467934 474953 476052 477043 479162 483189 485348 485886 491290 491463 495063 496999 499359 505891 508522 512867 514149 521223 521231 522177 524712 529548 531574 532536 532693 533977 534221 535076 537118 538891 538940 540274 541597 542343 543441 543849 545649 546177 546784 546807 546825 547848 551055 557198 568478 569701 569736 569778 593463 600824 600964 603707 605512 605583 624195 626533 628600 655840 660608 676157 680611 685979 687989 688666 696097 697465 710316 711269 713126 720705 722481 722510 722523 722544 733230 760696 760793 770228 772077 784713 785944 794907 795354 796199 800329 800759 801286 803836 806121 808774 809846 810675 813784 815023 817048 817063 817169 817887 818371 819708 823330 827079 ] |
||||||||||||||||||||||||||||||
|
14.33 ms (8.43%) |
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 533977 538891 540274 521223 521231 522177 531574 532536 537118 532693 534221 538940 543441 546177 546784 546807 546825 568478 541597 551055 542343 547848 557198 569736 655840 680611 685979 710316 713126 697465 711269 660608 676157 687989 696097 722510 722523 722544 569701 605512 628600 600964 603707 605583 593463 600824 626533 809846 784713 796199 801286 808774 733230 760696 772077 785944 794907 803836 806121 760793 770228 720705 722481 795354 800329 800759 810675 433594 20617 343227 386335 430574 388570 460974 479162 450639 476052 499359 485348 485886 447132 543849 624195 505891 491290 495063 535076 496999 529548 545649 569778 688666 455227 467934 477043 419777 474953 483189 508522 512867 514149 491463 524712 386698 312919 382022 430455 441965 434209 413612 817169 817887 819708 823330 813784 815023 817048 817063 818371 827079 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.79%) |
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 20617 312919 343227 382022 386335 386698 388570 413612 419777 430455 430574 433594 434209 441965 447132 450639 455227 460974 467934 474953 476052 477043 479162 483189 485348 485886 491290 491463 495063 496999 499359 505891 508522 512867 514149 521223 521231 522177 524712 529548 531574 532536 532693 533977 534221 535076 537118 538891 538940 540274 541597 542343 543441 543849 545649 546177 546784 546807 546825 547848 551055 557198 568478 569701 569736 569778 593463 600824 600964 603707 605512 605583 624195 626533 628600 655840 660608 676157 680611 685979 687989 688666 696097 697465 710316 711269 713126 720705 722481 722510 722523 722544 733230 760696 760793 770228 772077 784713 785944 794907 795354 796199 800329 800759 801286 803836 806121 808774 809846 810675 813784 815023 817048 817063 817169 817887 818371 819708 823330 827079 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage milf"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм milf"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм milf"
]
|
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.