Query Metrics
7
Database Queries
7
Different statements
155.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.28 ms (83.35%) |
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 370332 385313 400940 410940 421035 432762 446160 447919 450385 451734 456087 463873 463919 466161 466987 472877 494391 494692 532798 548771 550079 550238 551417 552131 552423 558601 560105 560411 562286 564251 565054 565245 565277 565404 566789 568086 568355 568369 570494 571643 573083 574784 575085 575106 575202 575510 576305 576307 576351 591819 591955 594430 595873 596625 597005 597078 597488 597502 597550 597553 597799 597956 597984 597992 598039 598611 598679 598812 600147 600583 601545 604309 608015 625699 625960 632626 637077 640537 642781 652979 654824 655068 656359 657316 657458 657642 659262 659324 664976 666417 674688 678552 680182 688369 695264 701309 711422 714458 714460 720439 722494 722542 722629 723428 743111 743341 743391 747574 748658 753435 753800 753911 760942 793677 807391 807541 809541 812288 819211 819677 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (10.47%) |
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 550079 551417 550238 552423 447919 597488 552131 570494 565054 575085 575202 560411 576305 562286 597078 591819 385313 819211 711422 657316 807391 793677 558601 400940 573083 548771 674688 654824 701309 564251 565404 625960 597992 748658 753435 601545 472877 451734 722494 722542 568355 576307 598812 597984 807541 571643 596625 656359 560105 659262 655068 664976 652979 657458 657642 678552 714460 723428 568086 600147 591955 600583 598611 604309 625699 743111 640537 714458 809541 456087 666417 568369 576351 637077 565277 450385 597005 494391 688369 595873 575510 597956 632626 598039 608015 466987 446160 463873 466161 410940 463919 494692 720439 680182 421035 532798 575106 574784 597799 598679 597502 642781 743341 370332 566789 565245 597550 432762 819677 722629 695264 659324 597553 594430 743391 753800 812288 747574 753911 760942 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.69%) |
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 370332 385313 400940 410940 421035 432762 446160 447919 450385 451734 456087 463873 463919 466161 466987 472877 494391 494692 532798 548771 550079 550238 551417 552131 552423 558601 560105 560411 562286 564251 565054 565245 565277 565404 566789 568086 568355 568369 570494 571643 573083 574784 575085 575106 575202 575510 576305 576307 576351 591819 591955 594430 595873 596625 597005 597078 597488 597502 597550 597553 597799 597956 597984 597992 598039 598611 598679 598812 600147 600583 601545 604309 608015 625699 625960 632626 637077 640537 642781 652979 654824 655068 656359 657316 657458 657642 659262 659324 664976 666417 674688 678552 680182 688369 695264 701309 711422 714458 714460 720439 722494 722542 722629 723428 743111 743341 743391 747574 748658 753435 753800 753911 760942 793677 807391 807541 809541 812288 819211 819677 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small dick"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая член"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая член"
]
|
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.