Query Metrics
7
Database Queries
7
Different statements
361.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.92 ms (58.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"year old девушк"
]
|
||||||||||||||||||||||||||||||
|
125.72 ms (34.76%) |
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 4429 387652 391677 396339 399874 400263 418347 418654 422027 425656 429188 429221 429226 429237 429244 429357 445909 455917 456627 458609 461625 468116 475541 489144 490698 495171 495599 509600 510100 523735 525495 525658 529056 529090 537472 545167 547731 550408 556562 557445 560408 560510 560971 560984 564139 564619 564802 569443 570762 571765 571777 572261 574198 577719 577831 577865 583274 586689 586918 590478 591393 593964 594115 594784 597276 603468 607335 610504 614820 614843 622565 625134 628824 628828 631470 634221 643396 647762 648670 651885 654048 657547 673229 673877 686210 689442 708655 713494 715575 722330 723373 725098 725141 731768 732775 740597 741958 743455 745804 748416 749294 752605 754205 755854 758540 758560 765094 771948 772053 777646 785369 788672 788720 789028 793575 800583 804436 807464 810728 812844 ] |
||||||||||||||||||||||||||||||
|
17.88 ms (4.94%) |
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 647762 648670 590478 614820 586918 628824 771948 772053 713494 785369 807464 445909 574198 673229 686210 607335 625134 594784 614843 622565 628828 788672 800583 804436 812844 793575 810728 741958 749294 725098 475541 418347 570762 643396 560408 396339 564619 571765 571777 654048 657547 545167 586689 748416 418654 569443 557445 560971 564802 577831 651885 723373 789028 731768 755854 758560 732775 743455 754205 740597 708655 429188 455917 429226 429237 529090 495599 4429 425656 429244 429221 429357 458609 489144 523735 525658 509600 537472 547731 560510 577719 550408 564139 572261 722330 689442 560984 593964 594115 597276 610504 634221 591393 777646 788720 725141 758540 765094 745804 752605 603468 631470 715575 387652 400263 461625 391677 468116 490698 495171 510100 399874 456627 422027 525495 529056 583274 556562 577865 673877 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.77%) |
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 4429 387652 391677 396339 399874 400263 418347 418654 422027 425656 429188 429221 429226 429237 429244 429357 445909 455917 456627 458609 461625 468116 475541 489144 490698 495171 495599 509600 510100 523735 525495 525658 529056 529090 537472 545167 547731 550408 556562 557445 560408 560510 560971 560984 564139 564619 564802 569443 570762 571765 571777 572261 574198 577719 577831 577865 583274 586689 586918 590478 591393 593964 594115 594784 597276 603468 607335 610504 614820 614843 622565 625134 628824 628828 631470 634221 643396 647762 648670 651885 654048 657547 673229 673877 686210 689442 708655 713494 715575 722330 723373 725098 725141 731768 732775 740597 741958 743455 745804 748416 749294 752605 754205 755854 758540 758560 765094 771948 772053 777646 785369 788672 788720 789028 793575 800583 804436 807464 810728 812844 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"year old girl"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"year old девушк"
]
|
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.