Query Metrics
7
Database Queries
7
Different statements
202.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.38 ms (86.81%) |
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 382355 384524 385809 388219 391986 396526 400753 405507 407423 411227 416165 419483 420120 423633 425490 427983 443651 443661 445738 448810 449869 452282 453473 453929 457294 458986 460079 460099 461059 462610 465649 468637 471780 473010 476901 478032 478672 482775 484811 494345 498830 500669 510109 512613 516633 517725 521367 522284 522785 522883 525663 527053 529403 530019 530381 530796 531189 531202 531405 532441 532629 532737 532804 533063 534166 534381 536562 537203 540400 543808 548577 551916 553296 556533 558447 562508 562892 562894 564776 565149 574459 576698 576721 576723 579369 599908 599932 599957 600293 604902 606499 610060 614742 615747 619401 620165 620726 621962 630915 632692 632927 635490 637741 647932 647954 648867 649188 650476 666589 668688 675515 716882 720115 752661 805487 808077 810822 810832 811040 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (8.39%) |
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 525663 449869 494345 400753 405507 423633 462610 468637 482775 476901 457294 460079 531189 532804 534166 529403 532441 532629 530019 534381 527053 478032 579369 548577 553296 565149 574459 576698 576721 562892 564776 648867 720115 649188 556533 600293 606499 619401 614742 632927 599908 615747 630915 810822 752661 811040 635490 808077 396526 407423 382355 461059 471780 391986 419483 453473 512613 517725 484811 513476 522284 500669 647932 604902 448810 562894 576723 425490 384524 411227 443661 427983 416165 445738 452282 453929 460099 521367 522785 530381 536562 532737 540400 498830 531405 533063 551916 543808 558447 647954 650476 666589 668688 675515 716882 562508 599932 610060 620726 621962 599957 637741 620165 810832 805487 632692 385809 458986 465649 443651 473010 510109 516633 522883 478672 388219 420120 530796 531202 537203 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.39%) |
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 382355 384524 385809 388219 391986 396526 400753 405507 407423 411227 416165 419483 420120 423633 425490 427983 443651 443661 445738 448810 449869 452282 453473 453929 457294 458986 460079 460099 461059 462610 465649 468637 471780 473010 476901 478032 478672 482775 484811 494345 498830 500669 510109 512613 516633 517725 521367 522284 522785 522883 525663 527053 529403 530019 530381 530796 531189 531202 531405 532441 532629 532737 532804 533063 534166 534381 536562 537203 540400 543808 548577 551916 553296 556533 558447 562508 562892 562894 564776 565149 574459 576698 576721 576723 579369 599908 599932 599957 600293 604902 606499 610060 614742 615747 619401 620165 620726 621962 630915 632692 632927 635490 637741 647932 647954 648867 649188 650476 666589 668688 675515 716882 720115 752661 805487 808077 810822 810832 811040 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black and mature"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black mature"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black mature"
]
|
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.