Query Metrics
7
Database Queries
7
Different statements
230.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.07 ms (88.28%) |
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 423848 426629 426698 429954 430433 437960 439559 439795 443191 445320 445421 446762 451535 452617 453623 455125 456857 460289 462949 464530 464532 465348 465354 465380 466241 466331 470280 470617 470774 471997 472510 472588 473939 474113 475918 476264 477131 479050 479087 480707 480910 483376 483385 484152 487763 488692 489187 490474 492050 492343 492701 493402 493546 494231 496940 499183 502868 502973 509430 509853 510456 513527 518622 519299 519333 519702 520745 521481 525984 527168 527842 528452 534076 540727 553480 553637 571509 578828 581471 593596 595547 597482 599082 599536 603468 603933 607026 609235 619903 624006 649523 691330 692042 694115 695691 697892 731124 731229 735332 736289 738347 738367 739531 741712 742382 749909 754081 758222 758236 758244 764019 766503 771822 778607 787488 792275 796747 805149 809749 810386 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (7.17%) |
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 426698 446762 571509 758222 739531 464530 488692 493546 534076 691330 578828 754081 619903 581471 607026 487763 456857 470617 477131 496940 519702 525984 509853 609235 455125 519333 472588 553480 453623 439795 437960 492701 470774 466241 464532 520745 695691 597482 624006 787488 792275 731124 736289 796747 766503 731229 742382 758244 738347 749909 603468 810386 443191 472510 513527 484152 502973 599082 490474 521481 527842 518622 471997 502868 480707 483385 771822 475918 465348 473939 470280 474113 479050 519299 527168 510456 465354 492050 445320 499183 649523 423848 426629 540727 553637 697892 692042 694115 599536 595547 778607 805149 809749 735332 738367 758236 764019 741712 445421 451535 476264 429954 452617 603933 466331 492343 480910 483376 430433 509430 489187 465380 479087 494231 439559 462949 528452 593596 460289 493402 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.22%) |
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 423848 426629 426698 429954 430433 437960 439559 439795 443191 445320 445421 446762 451535 452617 453623 455125 456857 460289 462949 464530 464532 465348 465354 465380 466241 466331 470280 470617 470774 471997 472510 472588 473939 474113 475918 476264 477131 479050 479087 480707 480910 483376 483385 484152 487763 488692 489187 490474 492050 492343 492701 493402 493546 494231 496940 499183 502868 502973 509430 509853 510456 513527 518622 519299 519333 519702 520745 521481 525984 527168 527842 528452 534076 540727 553480 553637 571509 578828 581471 593596 595547 597482 599082 599536 603468 603933 607026 609235 619903 624006 649523 691330 692042 694115 695691 697892 731124 731229 735332 736289 738347 738367 739531 741712 742382 749909 754081 758222 758236 758244 764019 766503 771822 778607 787488 792275 796747 805149 809749 810386 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife compilation"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен подборк"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.68%) |
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.