Query Metrics
7
Database Queries
7
Different statements
188.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.86 ms (86.71%) |
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 21323 38028 50258 228779 281095 384492 396374 398448 410073 411944 412015 412717 413488 414295 416038 416293 422210 424742 425588 427561 427794 444126 445359 446016 446948 447243 448678 451013 451687 452391 453461 454444 456322 457379 457950 458716 459858 463824 463896 464977 465945 466457 476297 484904 485173 486809 487602 497773 498358 504609 518449 528921 528925 535898 542724 544503 547026 547035 548590 552970 554325 560180 567083 567525 567628 569259 569420 575576 577562 580886 583176 602260 611236 625709 629339 649347 661031 665192 666808 667199 671328 676208 676388 681081 695867 705677 707483 707529 709790 710001 715115 716131 732921 742445 752332 752840 757909 758248 771971 787980 792265 792534 792563 795051 797642 799233 800976 801112 802783 811071 813619 814498 814988 818393 818399 819500 819627 824494 826320 828549 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (7.96%) |
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 800976 787980 792265 802783 792563 797642 801112 811071 732921 757909 758248 752840 625709 629339 715115 412717 396374 484904 425588 445359 454444 464977 542724 567525 422210 457950 518449 818393 611236 398448 742445 228779 818399 824494 828549 38028 414295 813619 485173 487602 552970 716131 649347 575576 792534 752332 50258 281095 819500 819627 826320 795051 427561 456322 463824 486809 497773 560180 799233 771971 602260 427794 416038 446948 528921 498358 528925 384492 21323 444126 410073 413488 412015 416293 424742 411944 814498 814988 452391 457379 466457 447243 453461 458716 446016 448678 451013 451687 459858 476297 504609 535898 463896 465945 548590 567083 569259 583176 544503 547026 547035 577562 580886 554325 567628 569420 666808 671328 676388 681081 705677 707483 707529 709790 661031 665192 667199 676208 695867 710001 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.83%) |
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 21323 38028 50258 228779 281095 384492 396374 398448 410073 411944 412015 412717 413488 414295 416038 416293 422210 424742 425588 427561 427794 444126 445359 446016 446948 447243 448678 451013 451687 452391 453461 454444 456322 457379 457950 458716 459858 463824 463896 464977 465945 466457 476297 484904 485173 486809 487602 497773 498358 504609 518449 528921 528925 535898 542724 544503 547026 547035 548590 552970 554325 560180 567083 567525 567628 569259 569420 575576 577562 580886 583176 602260 611236 625709 629339 649347 661031 665192 666808 667199 671328 676208 676388 681081 695867 705677 707483 707529 709790 710001 715115 716131 732921 742445 752332 752840 757909 758248 771971 787980 792265 792534 792563 795051 797642 799233 800976 801112 802783 811071 813619 814498 814988 818393 818399 819500 819627 824494 826320 828549 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs ass"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs жоп"
]
|
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.