Query Metrics
7
Database Queries
7
Different statements
171.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.06 ms (81.78%) |
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 174791 351650 386153 386336 386743 388506 388542 390671 391294 391995 392477 394029 397078 397084 397827 398881 399032 401732 409577 413007 413963 418918 421639 422292 423550 428911 433866 434007 434688 435298 438567 440807 441249 441327 441479 441507 441576 441917 441965 443051 446072 446419 446525 448393 450370 450684 452845 453141 453172 453612 453674 454015 454030 454557 456850 456890 456995 457090 459405 461199 462018 462218 462964 465450 465724 467977 469067 469251 470007 476437 483373 485425 487609 492426 492668 494597 494895 497838 498123 499842 500281 500880 504082 504767 506672 507158 507439 508791 509608 516166 518154 519393 522438 523904 529519 530283 530557 530937 533072 533074 534366 536967 537614 538794 540758 540809 545876 546768 548039 605704 622823 633917 641334 653778 658146 679618 693962 729217 766728 814546 ] |
||||||||||||||||||||||||||||||
|
21.90 ms (12.79%) |
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 548039 658146 679618 693962 633917 605704 729217 391294 388542 441249 450684 470007 487609 494597 498123 483373 492668 485425 453612 519393 516166 536967 508791 518154 540758 546768 545876 653778 641334 440807 476437 391995 522438 448393 622823 766728 386153 386743 386336 174791 394029 392477 351650 388506 390671 397084 397078 397827 399032 398881 401732 418918 434688 438567 441479 441917 422292 433866 434007 441965 423550 441327 409577 413007 421639 435298 443051 413963 428911 441507 441576 540809 814546 446525 461199 467977 469251 492426 446419 453141 453172 453674 454030 454557 457090 459405 462964 446072 450370 452845 454015 456850 456890 456995 462018 462218 500880 504767 507158 523904 530557 537614 497838 499842 504082 533072 538794 506672 507439 529519 530937 534366 494895 500281 509608 530283 533074 465450 465724 469067 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.64%) |
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 174791 351650 386153 386336 386743 388506 388542 390671 391294 391995 392477 394029 397078 397084 397827 398881 399032 401732 409577 413007 413963 418918 421639 422292 423550 428911 433866 434007 434688 435298 438567 440807 441249 441327 441479 441507 441576 441917 441965 443051 446072 446419 446525 448393 450370 450684 452845 453141 453172 453612 453674 454015 454030 454557 456850 456890 456995 457090 459405 461199 462018 462218 462964 465450 465724 467977 469067 469251 470007 476437 483373 485425 487609 492426 492668 494597 494895 497838 498123 499842 500281 500880 504082 504767 506672 507158 507439 508791 509608 516166 518154 519393 522438 523904 529519 530283 530557 530937 533072 533074 534366 536967 537614 538794 540758 540809 545876 546768 548039 605704 622823 633917 641334 653778 658146 679618 693962 729217 766728 814546 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"снима порн жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"снимаю порно с женой"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.84%) |
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.