Query Metrics
7
Database Queries
7
Different statements
221.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.29 ms (88.56%) |
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 214988 382649 384461 395715 406134 412122 419950 420050 420106 422844 422997 423022 423023 423412 428479 429583 433229 433279 434759 435629 435646 435715 443322 443617 446258 447797 448640 453009 453331 456634 458327 458384 458429 459233 459316 459832 469114 469542 469576 475443 477404 478955 485578 486759 486885 492805 494402 497467 499034 499035 510622 512181 512207 517302 522123 523540 525644 527101 529182 534776 535434 535626 539899 551941 552919 554298 554416 558361 558578 561888 565213 568869 580296 583397 583667 586639 590944 592734 597263 601081 604702 632605 637115 638276 642841 644363 649384 650825 650835 653247 653415 654451 662071 665909 672031 672264 692296 701872 712177 712719 721368 730906 734675 735602 736744 737105 738245 740536 747237 748681 754204 755341 758462 759548 761580 762296 762382 813507 819390 823229 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (7.42%) |
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 762296 735602 755341 762382 754204 644363 433229 406134 423023 428479 422997 443617 492805 478955 499035 525644 499034 527101 529182 592734 423022 395715 423412 382649 412122 429583 535626 522123 459233 214988 420050 485578 823229 568869 672031 650835 758462 734675 701872 738245 539899 583397 604702 512207 447797 551941 552919 554416 554298 586639 435646 458327 558578 565213 653415 712177 649384 653247 642841 590944 580296 597263 672264 665909 420106 453009 558361 434759 459832 712719 637115 632605 561888 486759 419950 435629 456634 459316 477404 453331 458384 458429 448640 510622 512181 535434 523540 534776 517302 469542 446258 475443 443322 422844 433279 384461 819390 497467 435715 692296 736744 469576 486885 494402 469114 583667 650825 662071 654451 721368 638276 601081 813507 730906 737105 747237 761580 748681 740536 759548 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.22%) |
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 214988 382649 384461 395715 406134 412122 419950 420050 420106 422844 422997 423022 423023 423412 428479 429583 433229 433279 434759 435629 435646 435715 443322 443617 446258 447797 448640 453009 453331 456634 458327 458384 458429 459233 459316 459832 469114 469542 469576 475443 477404 478955 485578 486759 486885 492805 494402 497467 499034 499035 510622 512181 512207 517302 522123 523540 525644 527101 529182 534776 535434 535626 539899 551941 552919 554298 554416 558361 558578 561888 565213 568869 580296 583397 583667 586639 590944 592734 597263 601081 604702 632605 637115 638276 642841 644363 649384 650825 650835 653247 653415 654451 662071 665909 672031 672264 692296 701872 712177 712719 721368 730906 734675 735602 736744 737105 738245 740536 747237 748681 754204 755341 758462 759548 761580 762296 762382 813507 819390 823229 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick asian"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.57%) |
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.