Query Metrics
7
Database Queries
7
Different statements
196.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.62 ms (84.99%) |
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 386099 425562 433939 437558 438454 439322 439909 444230 448069 448561 453656 453714 455864 457765 458344 461785 462708 462728 463185 466034 468070 471327 473470 476915 482040 483424 485236 485294 485417 485980 487112 493382 498163 498468 498474 501267 505750 506812 506982 509764 510331 511924 513788 514608 516603 517969 518805 519494 521877 522494 522953 524174 524833 525193 525785 526147 527391 527909 527945 534300 545914 547903 549772 551228 552136 554419 554621 556845 557669 559030 563363 568726 569629 576041 577680 581478 581712 585818 586605 587817 593626 595138 596160 608235 609185 630044 630424 650028 653794 668650 686082 689002 699604 700718 722227 723945 723955 724045 724440 724456 727004 727692 727891 736137 737451 743431 743463 744563 746497 753205 753765 766763 789534 790710 806640 812795 822365 822825 ] |
||||||||||||||||||||||||||||||
|
18.34 ms (9.36%) |
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 743463 746497 697943 462728 510331 485294 563363 556845 453656 455864 468070 471327 527391 525785 516603 557669 581478 551228 559030 686082 577680 458344 466034 482040 505750 501267 511924 526147 444230 433939 822825 457765 461785 498163 514608 547903 552136 716936 722227 668650 689002 700718 609185 585818 595138 723955 724045 727891 724456 727004 743431 744563 723945 737451 699604 790710 806640 425562 476915 485417 513788 524174 448069 522494 549772 789534 766763 736137 453714 462708 545914 485236 650028 437558 439322 568726 586605 506812 527945 498468 527909 448561 554621 581712 653794 576041 596160 587817 812795 724440 522953 524833 483424 509764 518805 493382 517969 519494 506982 521877 822365 525193 498474 534300 487112 554419 569629 593626 608235 630044 630424 753205 753765 727692 386099 438454 463185 473470 439909 485980 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.77%) |
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 386099 425562 433939 437558 438454 439322 439909 444230 448069 448561 453656 453714 455864 457765 458344 461785 462708 462728 463185 466034 468070 471327 473470 476915 482040 483424 485236 485294 485417 485980 487112 493382 498163 498468 498474 501267 505750 506812 506982 509764 510331 511924 513788 514608 516603 517969 518805 519494 521877 522494 522953 524174 524833 525193 525785 526147 527391 527909 527945 534300 545914 547903 549772 551228 552136 554419 554621 556845 557669 559030 563363 568726 569629 576041 577680 581478 581712 585818 586605 587817 593626 595138 596160 608235 609185 630044 630424 650028 653794 668650 686082 689002 699604 700718 722227 723945 723955 724045 724440 724456 727004 727692 727891 736137 737451 743431 743463 744563 746497 753205 753765 766763 789534 790710 806640 812795 822365 822825 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 pussy home"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 pussy home"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 pussy home"
]
|
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.