Query Metrics
7
Database Queries
7
Different statements
167.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.06 ms (80.61%) |
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 30783 384524 384542 385784 390024 390098 390413 401321 404829 411227 411477 411807 415097 419751 420305 423633 423981 427897 429764 430168 430535 435497 438638 441237 442979 445345 446331 447124 447855 448692 449868 454925 458916 459085 461059 461747 464451 465012 466616 466968 468213 472914 472951 473216 474852 475698 477358 478033 479472 480636 481602 483118 484811 486403 491204 492126 495014 496302 496318 496527 499174 500669 502562 503828 504876 506496 506667 508856 509543 511777 512613 513290 515843 516021 517204 517330 518181 518405 518733 520730 522284 522903 523091 524440 525303 526073 527750 528035 528815 528921 532441 533063 533799 534166 537833 548580 555807 565102 565277 576698 576721 577377 584212 591582 595764 596436 603724 604595 631908 632927 675144 675431 675660 675696 729911 755030 810822 810832 825039 ] |
||||||||||||||||||||||||||||||
|
21.46 ms (12.81%) |
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 385784 30783 825039 548580 631908 446331 459085 404829 504876 415097 486403 518181 584212 604595 411807 442979 499174 430535 441237 411477 472914 438638 472951 492126 430168 465012 448692 461747 474852 555807 675660 591582 513290 496302 528035 491204 390098 503828 518405 528815 506667 468213 675144 755030 475698 518733 502562 523091 509543 496318 423981 528921 515843 401321 390024 537833 810822 729911 517330 466968 595764 458916 447124 522903 435497 576698 481602 478033 526073 449868 483118 596436 632927 384542 461059 525303 516021 500669 427897 447855 576721 675431 484811 513476 524440 511777 527750 464451 675696 577377 466616 522284 423633 454925 534166 532441 533799 496527 520730 480636 420305 477358 508856 565277 479472 390413 512613 495014 384524 603724 810832 506496 517204 419751 429764 533063 473216 565102 445345 411227 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.04%) |
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 30783 384524 384542 385784 390024 390098 390413 401321 404829 411227 411477 411807 415097 419751 420305 423633 423981 427897 429764 430168 430535 435497 438638 441237 442979 445345 446331 447124 447855 448692 449868 454925 458916 459085 461059 461747 464451 465012 466616 466968 468213 472914 472951 473216 474852 475698 477358 478033 479472 480636 481602 483118 484811 486403 491204 492126 495014 496302 496318 496527 499174 500669 502562 503828 504876 506496 506667 508856 509543 511777 512613 513290 515843 516021 517204 517330 518181 518405 518733 520730 522284 522903 523091 524440 525303 526073 527750 528035 528815 528921 532441 533063 533799 534166 537833 548580 555807 565102 565277 576698 576721 577377 584212 591582 595764 596436 603724 604595 631908 632927 675144 675431 675660 675696 729911 755030 810822 810832 825039 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white fuck black"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white секс black"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white секс black"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.