Query Metrics
7
Database Queries
7
Different statements
225.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.35 ms (86.32%) |
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 275824 279404 382840 383497 384319 384836 397670 398073 398308 398701 401861 405690 412071 412866 418069 418520 420330 424548 425586 426124 432351 434125 442296 444371 445790 452421 453284 457814 469140 469772 475769 477227 487442 490223 495617 498454 515441 519672 521024 521349 522173 524796 528596 530293 532444 533555 533717 535331 538015 540257 541413 547734 547758 547775 547777 547779 547793 547927 552915 558082 558919 590295 593127 598373 607102 608603 615537 622663 631274 641946 654194 660315 662125 663352 678551 680741 700268 710144 739820 751627 754522 755490 755892 765830 772165 773026 777717 781022 781825 782553 783341 783375 783398 785460 785899 787160 790547 790664 790730 791033 803581 803760 804116 805129 806435 806690 807579 807591 807956 808332 808342 811313 811321 812333 813942 815973 816195 820968 822442 823016 ] |
||||||||||||||||||||||||||||||
|
19.79 ms (8.79%) |
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 790547 275824 384836 412866 397670 533555 530293 538015 660315 678551 710144 552915 785460 384319 787160 816195 815973 540257 804116 405690 515441 522173 533717 541413 598373 608603 805129 781825 811313 772165 751627 765830 791033 803581 457814 477227 424548 442296 521024 813942 453284 558082 662125 700268 590295 783375 783398 755892 382840 398308 426124 398701 547775 607102 593127 807579 811321 803760 808332 755490 783341 785899 790664 806690 807591 808342 754522 739820 641946 781022 782553 401861 279404 383497 398073 412071 425586 432351 535331 434125 490223 519672 532444 547777 547779 547793 547927 547734 547758 806435 452421 469140 469772 418520 418069 420330 445790 475769 444371 495617 528596 498454 524796 487442 558919 654194 773026 790730 622663 521349 680741 822442 820968 823016 663352 615537 631274 777717 807956 812333 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
2.62 ms (1.16%) |
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 275824 279404 382840 383497 384319 384836 397670 398073 398308 398701 401861 405690 412071 412866 418069 418520 420330 424548 425586 426124 432351 434125 442296 444371 445790 452421 453284 457814 469140 469772 475769 477227 487442 490223 495617 498454 515441 519672 521024 521349 522173 524796 528596 530293 532444 533555 533717 535331 538015 540257 541413 547734 547758 547775 547777 547779 547793 547927 552915 558082 558919 590295 593127 598373 607102 608603 615537 622663 631274 641946 654194 660315 662125 663352 678551 680741 700268 710144 739820 751627 754522 755490 755892 765830 772165 773026 777717 781022 781825 782553 783341 783375 783398 785460 785899 787160 790547 790664 790730 791033 803581 803760 804116 805129 806435 806690 807579 807591 807956 808332 808342 811313 811321 812333 813942 815973 816195 820968 822442 823016 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty girls masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.