Query Metrics
7
Database Queries
7
Different statements
190.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.92 ms (84.38%) |
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 396927 412688 418158 419445 419455 423802 423814 426127 427497 428249 429705 435734 437259 439348 439378 443317 444839 457022 457054 457577 458866 469569 470061 471041 473636 475420 477149 478785 478987 479364 482145 485297 487548 489797 499309 499568 500749 501381 503487 503758 505218 505591 509573 510166 514407 515448 517447 518552 518822 520578 522040 524307 525471 526544 526563 527707 528097 528144 535543 542090 550834 552371 554756 559172 559216 560034 563363 564482 564988 567272 568752 572268 574708 576739 577891 579608 583200 587179 589817 589832 595630 596864 600428 600436 601174 601185 604190 604980 605108 605706 606438 606912 607070 611025 612675 614612 614773 615835 617045 618579 632090 633934 637172 643488 662782 670853 674474 725527 726701 739759 748046 753751 777733 801229 801560 802905 803163 806271 810009 822272 ] |
||||||||||||||||||||||||||||||
|
19.43 ms (10.19%) |
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 419445 563363 662782 611025 606438 412688 439378 428249 477149 515448 525471 527707 437259 470061 526563 528097 576739 614612 589817 600428 444839 505218 524307 822272 482145 503758 552371 670853 606912 618579 726701 605706 777733 803163 426127 503487 489797 457022 457054 473636 559216 564988 572268 595630 617045 748046 801560 419455 418158 435734 499309 522040 487548 471041 478987 479364 520578 499568 526544 535543 568752 583200 577891 579608 564482 674474 587179 589832 601174 601185 612675 633934 802905 806271 725527 739759 605108 810009 429705 423802 478785 510166 501381 509573 514407 517447 518822 528144 475420 560034 567272 439348 505591 554756 607070 427497 458866 469569 518552 457577 615835 596864 637172 485297 500749 396927 443317 423814 542090 559172 574708 550834 600436 632090 643488 604980 604190 801229 753751 614773 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.51%) |
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 396927 412688 418158 419445 419455 423802 423814 426127 427497 428249 429705 435734 437259 439348 439378 443317 444839 457022 457054 457577 458866 469569 470061 471041 473636 475420 477149 478785 478987 479364 482145 485297 487548 489797 499309 499568 500749 501381 503487 503758 505218 505591 509573 510166 514407 515448 517447 518552 518822 520578 522040 524307 525471 526544 526563 527707 528097 528144 535543 542090 550834 552371 554756 559172 559216 560034 563363 564482 564988 567272 568752 572268 574708 576739 577891 579608 583200 587179 589817 589832 595630 596864 600428 600436 601174 601185 604190 604980 605108 605706 606438 606912 607070 611025 612675 614612 614773 615835 617045 618579 632090 633934 637172 643488 662782 670853 674474 725527 726701 739759 748046 753751 777733 801229 801560 802905 803163 806271 810009 822272 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbate girl"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"masturbate девушк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"masturbate девушк"
]
|
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.