Query Metrics
7
Database Queries
7
Different statements
191.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.43 ms (84.08%) |
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 392814 395463 398237 400690 400715 400723 400985 404125 408776 417429 421390 427449 443370 443373 453603 454861 455629 459811 462288 463093 464303 469844 469898 470733 471566 475918 485489 495159 504770 507009 507772 509077 510586 510936 514787 516159 524023 530347 538525 541250 542942 548401 548670 560579 562114 566886 571150 579234 579488 581206 583210 595470 595654 604425 609712 610174 617121 617848 621593 627171 644708 652667 658224 662436 675424 694260 700945 704975 710001 714357 714477 714851 716124 716392 716396 717810 718399 720821 722080 723931 733181 736980 737910 738623 740084 741114 745386 746178 753993 754967 759634 760214 765763 765904 765907 766644 771874 775630 776138 784925 787616 789874 790342 791257 793436 795092 798171 798992 800227 801644 810533 811174 816764 817482 817553 819212 825029 826672 ] |
||||||||||||||||||||||||||||||
|
19.72 ms (10.27%) |
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 610174 617121 617848 733181 800227 471566 791257 400985 579234 427449 507009 510586 571150 595470 621593 716396 801644 453603 469898 524023 504770 694260 717810 718399 652667 789874 795092 723931 760214 766644 798992 765904 395463 404125 417429 443373 454861 462288 817553 790342 400690 475918 470733 464303 400715 826672 819212 485489 530347 495159 548401 579488 662436 714477 658224 714357 714851 716392 548670 604425 644708 776138 793436 810533 736980 737910 740084 784925 754967 759634 738623 745386 765763 771874 741114 753993 765907 627171 716124 722080 798171 400723 469844 541250 704975 421390 516159 538525 560579 787616 824295 826047 811174 398237 392814 408776 455629 510936 825029 746178 443370 817482 816764 459811 463093 507772 509077 514787 542942 562114 566886 581206 583210 675424 710001 700945 720821 609712 595654 775630 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.45%) |
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 392814 395463 398237 400690 400715 400723 400985 404125 408776 417429 421390 427449 443370 443373 453603 454861 455629 459811 462288 463093 464303 469844 469898 470733 471566 475918 485489 495159 504770 507009 507772 509077 510586 510936 514787 516159 524023 530347 538525 541250 542942 548401 548670 560579 562114 566886 571150 579234 579488 581206 583210 595470 595654 604425 609712 610174 617121 617848 621593 627171 644708 652667 658224 662436 675424 694260 700945 704975 710001 714357 714477 714851 716124 716392 716396 717810 718399 720821 722080 723931 733181 736980 737910 738623 740084 741114 745386 746178 753993 754967 759634 760214 765763 765904 765907 766644 771874 775630 776138 784925 787616 789874 790342 791257 793436 795092 798171 798992 800227 801644 810533 811174 816764 817482 817553 819212 825029 826672 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young webcam amateur"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young вебкамер любительск"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young вебкамер любительск"
]
|
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.