Query Metrics
7
Database Queries
7
Different statements
155.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.04 ms (81.86%) |
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 21576 396194 397065 397200 397248 397965 415053 418402 418772 419445 420266 421138 424809 426482 428571 429429 434017 434345 434455 436203 436859 438935 439899 443024 447685 448511 449260 449744 449792 449901 450707 453913 453933 456623 456952 461549 462597 467599 471721 474228 474741 474972 475778 478208 478212 479482 481251 483504 484859 486221 487239 488716 489584 491192 491501 491661 492979 494942 495761 498853 499005 503183 503789 504290 504329 504381 506154 506714 509441 509558 510015 510138 510635 510729 511048 511224 511685 511758 511812 512236 512267 512323 512953 513255 516731 520901 521896 521996 522798 523299 523708 523709 524244 527807 528328 529566 532254 536176 537475 537498 538402 540307 545455 601678 603897 604526 606750 627811 638233 644021 698018 715077 718658 720491 735555 742214 747161 757544 791445 812151 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (11.28%) |
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 812151 747161 791445 757544 742214 735555 601678 603897 604526 606750 627811 638233 644021 698018 715077 718658 720491 397248 421138 436203 449260 453933 474228 474741 475778 479482 418402 453913 462597 474972 481251 396194 397200 439899 461549 478212 21576 397065 397965 420266 434017 415053 424809 438935 449744 449901 478208 510635 510729 511224 512323 520901 521896 523708 491501 491661 494942 498853 506154 509441 510138 512236 522798 523299 483504 488716 489584 504290 504329 504381 506714 510015 511048 511685 511758 512267 512953 524244 538402 484859 486221 491192 509558 513255 521996 523709 527807 511812 426482 418772 434455 419445 429429 434345 443024 428571 436859 447685 448511 449792 450707 456623 471721 487239 492979 456952 503789 532254 536176 499005 503183 529566 537498 540307 495761 516731 528328 537475 467599 545455 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.97%) |
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 21576 396194 397065 397200 397248 397965 415053 418402 418772 419445 420266 421138 424809 426482 428571 429429 434017 434345 434455 436203 436859 438935 439899 443024 447685 448511 449260 449744 449792 449901 450707 453913 453933 456623 456952 461549 462597 467599 471721 474228 474741 474972 475778 478208 478212 479482 481251 483504 484859 486221 487239 488716 489584 491192 491501 491661 492979 494942 495761 498853 499005 503183 503789 504290 504329 504381 506154 506714 509441 509558 510015 510138 510635 510729 511048 511224 511685 511758 511812 512236 512267 512323 512953 513255 516731 520901 521896 521996 522798 523299 523708 523709 524244 527807 528328 529566 532254 536176 537475 537498 538402 540307 545455 601678 603897 604526 606750 627811 638233 644021 698018 715077 718658 720491 735555 742214 747161 757544 791445 812151 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking skinny"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking худые"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking худые"
]
|
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.