Query Metrics
7
Database Queries
7
Different statements
143.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.05 ms (82.54%) |
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 385292 405809 417940 418368 447790 450630 451861 454000 458914 465608 466104 468012 473848 474264 476375 476774 478471 481364 482918 486303 487172 488217 489283 489417 490198 490227 490250 494276 504895 509746 513129 513491 521798 522011 522057 522441 524027 525022 525597 526353 526751 529567 534461 536924 537400 544381 546741 548046 551752 554646 556489 562029 563747 564596 567053 567192 567350 569000 580449 583592 584090 584929 593729 597477 602944 615029 617145 619724 619972 636958 638967 639235 644059 645943 649861 650823 661977 668710 670745 674550 676486 676507 676529 677055 677130 677136 679632 682639 689166 693629 702284 710614 715680 719260 720387 727605 729402 731921 736319 740493 741282 750289 750498 761666 772061 778128 780015 805341 813929 823656 824387 825574 825781 826184 828414 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (11.13%) |
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 602944 615029 466104 490227 513129 478471 526751 562029 597477 385292 522057 489417 476375 513491 447790 548046 474264 522011 525022 639235 465608 454000 650823 522441 584090 554646 468012 486303 458914 481364 567350 450630 494276 569000 544381 504895 593729 490198 670745 521798 526353 488217 564596 546741 584929 638967 529567 567053 556489 536924 719260 823656 813929 617145 676529 676507 727605 772061 534461 702284 677136 689166 761666 750498 405809 476774 679632 825781 674550 805341 780015 677055 715680 482918 677130 619972 418368 826184 487172 710614 729402 736319 509746 740493 490250 583592 417940 828156 563747 525597 551752 661977 524027 682639 676486 580449 644059 567192 693629 741282 537400 636958 473848 825574 731921 828414 828624 668710 489283 825504 824605 824205 645943 451861 720387 619724 750289 778128 824387 649861 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.66%) |
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 385292 405809 417940 418368 447790 450630 451861 454000 458914 465608 466104 468012 473848 474264 476375 476774 478471 481364 482918 486303 487172 488217 489283 489417 490198 490227 490250 494276 504895 509746 513129 513491 521798 522011 522057 522441 524027 525022 525597 526353 526751 529567 534461 536924 537400 544381 546741 548046 551752 554646 556489 562029 563747 564596 567053 567192 567350 569000 580449 583592 584090 584929 593729 597477 602944 615029 617145 619724 619972 636958 638967 639235 644059 645943 649861 650823 661977 668710 670745 674550 676486 676507 676529 677055 677130 677136 679632 682639 689166 693629 702284 710614 715680 719260 720387 727605 729402 731921 736319 740493 741282 750289 750498 761666 772061 778128 780015 805341 813929 823656 824387 825574 825781 826184 828414 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl fucked"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк fucked"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк fucked"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (1.00%) |
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.