Query Metrics
7
Database Queries
7
Different statements
167.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.27 ms (84.19%) |
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 383599 383737 391150 410851 422144 430675 431793 435221 435802 445029 451247 452757 452825 456664 456667 457092 459163 460084 461944 465727 467563 469878 473489 476171 478991 500843 500941 505665 511407 511636 515275 515330 515878 517222 521692 522462 523058 523175 523196 523373 525800 527098 527306 528430 529370 529709 531804 537091 537848 539593 540583 544401 545375 545882 545965 546016 546358 547611 547745 547784 548167 548170 548537 548859 549367 550703 550761 551612 551969 552697 553283 555002 555785 559377 559700 559836 563595 565110 566585 568481 568569 571203 571789 571846 571940 572260 573400 575276 576514 577553 577726 577775 578484 578493 579964 579987 581254 581659 581969 582573 582872 582955 590398 590960 595801 599485 602793 605589 612398 645939 651668 660373 661903 663852 669276 674240 677147 681027 687337 732220 ] |
||||||||||||||||||||||||||||||
|
17.38 ms (10.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 445029 452825 435802 457092 511636 523175 528430 529709 511407 612398 602793 732220 383599 476171 452757 478991 529370 545882 545965 578484 559377 645939 551612 590398 595801 599485 590960 605589 469878 461944 430675 383737 391150 422144 431793 435221 410851 456667 465727 467563 473489 451247 456664 460084 459163 523373 537091 537848 539593 500941 505665 517222 525800 527098 540583 500843 521692 522462 523196 527306 515275 515330 515878 523058 531804 544401 545375 566585 571846 571940 573400 576514 578493 582573 582955 546016 546358 547611 547745 548170 548859 551969 553283 559700 559836 563595 565110 575276 577553 577726 579987 581254 581659 548537 549367 555002 555785 568481 571789 581969 582872 661903 674240 681027 663852 669276 677147 687337 651668 660373 547784 548167 550703 550761 552697 568569 571203 572260 577775 579964 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.44%) |
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 383599 383737 391150 410851 422144 430675 431793 435221 435802 445029 451247 452757 452825 456664 456667 457092 459163 460084 461944 465727 467563 469878 473489 476171 478991 500843 500941 505665 511407 511636 515275 515330 515878 517222 521692 522462 523058 523175 523196 523373 525800 527098 527306 528430 529370 529709 531804 537091 537848 539593 540583 544401 545375 545882 545965 546016 546358 547611 547745 547784 548167 548170 548537 548859 549367 550703 550761 551612 551969 552697 553283 555002 555785 559377 559700 559836 563595 565110 566585 568481 568569 571203 571789 571846 571940 572260 573400 575276 576514 577553 577726 577775 578484 578493 579964 579987 581254 581659 581969 582573 582872 582955 590398 590960 595801 599485 602793 605589 612398 645939 651668 660373 661903 663852 669276 674240 677147 681027 687337 732220 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation finger"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац палец"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.81%) |
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.