Query Metrics
7
Database Queries
7
Different statements
151.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.16 ms (82.62%) |
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 388962 391984 391992 391994 416599 418126 418144 421838 428924 429861 429885 430365 432363 434309 435398 435547 435592 439029 439078 439130 439156 439274 439317 444194 444917 445103 446562 446641 446709 448587 452574 454504 454517 455132 456226 456238 460384 462840 463687 464264 466455 467696 469615 470022 470458 471107 477246 482751 483691 487428 489615 495470 498294 499383 499836 504781 506105 507951 509964 513568 513654 517810 519368 519699 519700 520904 521677 522260 522288 523355 526567 542701 542706 544401 547492 548150 548157 554949 556445 569359 571194 571235 571726 581058 583085 595483 599478 602782 605725 605828 620647 627049 652249 661424 674177 674204 677240 685506 691808 696871 700257 705809 714562 718775 722384 742286 742320 745100 745104 745672 751563 751609 755878 757566 761608 782321 782515 782854 790459 791930 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (10.64%) |
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 444917 477246 605828 782321 745672 696871 718775 439156 446562 498294 507951 571726 454517 519700 571194 542701 674177 674204 677240 652249 685506 691808 700257 705809 569359 581058 602782 620647 790459 782854 742286 742320 782515 751563 757566 745100 755878 745104 751609 761608 714562 791930 391994 460384 463687 464264 520904 605725 454504 526567 599478 388962 513568 523355 482751 544401 542706 548157 547492 722384 554949 556445 627049 391984 416599 446641 421838 439130 466455 471107 456238 439274 487428 521677 499836 571235 428924 435398 455132 522260 499383 504781 548150 583085 432363 429885 429861 435592 439029 444194 470022 489615 495470 522288 506105 519699 439078 661424 439317 434309 452574 456226 467696 391992 446709 418126 430365 445103 448587 469615 519368 509964 483691 513654 517810 595483 462840 470458 418144 435547 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.98%) |
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 388962 391984 391992 391994 416599 418126 418144 421838 428924 429861 429885 430365 432363 434309 435398 435547 435592 439029 439078 439130 439156 439274 439317 444194 444917 445103 446562 446641 446709 448587 452574 454504 454517 455132 456226 456238 460384 462840 463687 464264 466455 467696 469615 470022 470458 471107 477246 482751 483691 487428 489615 495470 498294 499383 499836 504781 506105 507951 509964 513568 513654 517810 519368 519699 519700 520904 521677 522260 522288 523355 526567 542701 542706 544401 547492 548150 548157 554949 556445 569359 571194 571235 571726 581058 583085 595483 599478 602782 605725 605828 620647 627049 652249 661424 674177 674204 677240 685506 691808 696871 700257 705809 714562 718775 722384 742286 742320 745100 745104 745672 751563 751609 755878 757566 761608 782321 782515 782854 790459 791930 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.