Query Metrics
7
Database Queries
7
Different statements
359.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.73 ms (58.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nigger"
]
|
||||||||||||||||||||||||||||||
|
123.47 ms (34.32%) |
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 14323 14369 14382 32637 75852 95864 97383 97694 161823 191382 238809 260940 381734 382928 383118 385742 386535 386935 387534 387682 388713 390111 390180 390508 390723 390820 395496 396372 396538 396577 398230 399058 399253 399351 399367 400943 401625 402092 402876 404217 404317 407648 411581 411768 413235 414364 414850 416153 416236 417258 417441 417880 419621 419765 420231 425694 425863 425903 425962 428334 428373 428420 429741 430732 440687 443662 445017 445741 446152 446555 446864 451265 451977 452206 453235 453531 458378 459344 460071 460799 461554 462829 463894 464018 465575 468387 468473 468694 469579 470425 470848 472337 482812 483251 483734 484503 486562 490729 491662 492839 494253 508775 508857 519819 522140 522359 523900 526405 559986 565372 565439 566235 570242 573814 575748 576360 577108 589048 593167 595337 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (4.94%) |
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 14323 14369 381734 382928 385742 386535 390180 396538 399253 399367 401625 420231 425694 425863 425962 446864 461554 465575 472337 407648 416236 428420 430732 446555 464018 468473 470425 486562 490729 491662 508857 523900 484503 522359 577108 589048 411581 383118 238809 161823 191382 97694 32637 97383 388713 386935 387534 390820 390508 387682 396372 398230 399058 399351 402876 404217 416153 440687 445017 414364 414850 417258 419765 425903 428334 428373 429741 411768 417441 417880 443662 453235 468387 468694 470848 483251 445741 451265 458378 463894 482812 492839 451977 452206 453531 459344 522140 508775 519819 494253 526405 460071 460799 469579 483734 559986 566235 576360 570242 575748 565372 565439 573814 595337 593167 14382 75852 390723 395496 400943 419621 446152 462829 95864 260940 390111 396577 402092 404317 413235 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (0.98%) |
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 14323 14369 14382 32637 75852 95864 97383 97694 161823 191382 238809 260940 381734 382928 383118 385742 386535 386935 387534 387682 388713 390111 390180 390508 390723 390820 395496 396372 396538 396577 398230 399058 399253 399351 399367 400943 401625 402092 402876 404217 404317 407648 411581 411768 413235 414364 414850 416153 416236 417258 417441 417880 419621 419765 420231 425694 425863 425903 425962 428334 428373 428420 429741 430732 440687 443662 445017 445741 446152 446555 446864 451265 451977 452206 453235 453531 458378 459344 460071 460799 461554 462829 463894 464018 465575 468387 468473 468694 469579 470425 470848 472337 482812 483251 483734 484503 486562 490729 491662 492839 494253 508775 508857 519819 522140 522359 523900 526405 559986 565372 565439 566235 570242 573814 575748 576360 577108 589048 593167 595337 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.40%) |
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.