Query Metrics
7
Database Queries
7
Different statements
173.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.02 ms (84.88%) |
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 384239 389745 395676 401985 410712 413722 428040 428933 435443 443883 444935 445530 446260 447125 450165 451267 455772 455859 456519 456634 456736 457422 458437 460807 460815 461368 461673 462133 463728 463867 467683 469352 470359 470550 471978 472506 473388 479893 481313 481914 482734 483436 484553 486350 486474 488074 488212 488736 489098 489134 489323 489431 490098 490196 492003 492557 492805 495670 498239 500202 500441 501705 501708 501774 502060 503299 503490 503730 505236 507013 507095 510114 513195 514020 515919 516023 516624 516709 517078 517079 517579 518446 518501 519622 520154 520930 521862 521912 522526 522528 523255 523529 523960 524199 524298 524592 524757 524782 525020 525169 525947 527070 527123 527463 528178 528784 531214 531656 532630 534707 539945 543618 551219 551245 551650 575192 584771 651609 675071 675657 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (9.68%) |
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 520154 521912 524298 524592 524757 524782 528784 534707 483436 488212 492003 492557 495670 498239 500441 501774 503490 505236 510114 515919 517078 517079 517579 518446 521862 522526 523529 523960 524199 525020 525169 528178 513195 384239 395676 389745 401985 410712 413722 444935 428040 428933 443883 435443 482734 456519 456634 457422 458437 460807 460815 467683 470359 473388 479893 484553 488736 490098 492805 445530 446260 447125 455859 461368 462133 463728 463867 470550 481914 486474 489323 450165 451267 455772 456736 461673 469352 471978 481313 489134 489431 490196 516023 516709 525947 500202 507013 516624 518501 520930 522528 527463 501705 501708 502060 503299 503730 507095 514020 531214 532630 519622 523255 527070 527123 531656 539945 472506 486350 488074 489098 551219 551650 584771 543618 575192 651609 675071 675657 551245 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.58%) |
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 384239 389745 395676 401985 410712 413722 428040 428933 435443 443883 444935 445530 446260 447125 450165 451267 455772 455859 456519 456634 456736 457422 458437 460807 460815 461368 461673 462133 463728 463867 467683 469352 470359 470550 471978 472506 473388 479893 481313 481914 482734 483436 484553 486350 486474 488074 488212 488736 489098 489134 489323 489431 490098 490196 492003 492557 492805 495670 498239 500202 500441 501705 501708 501774 502060 503299 503490 503730 505236 507013 507095 510114 513195 514020 515919 516023 516624 516709 517078 517079 517579 518446 518501 519622 520154 520930 521862 521912 522526 522528 523255 523529 523960 524199 524298 524592 524757 524782 525020 525169 525947 527070 527123 527463 528178 528784 531214 531656 532630 534707 539945 543618 551219 551245 551650 575192 584771 651609 675071 675657 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy white"
]
|
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.