Query Metrics
7
Database Queries
7
Different statements
174.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.98 ms (84.26%) |
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 384807 391359 392903 395931 396278 404762 405288 405300 417858 422970 428664 430787 441644 442254 442810 444083 447497 447713 447971 451483 455171 455462 455605 457176 460647 464260 465013 465906 465912 467196 468522 469550 471956 472916 473493 474104 479322 482828 482975 483333 485130 487806 488379 488825 489470 491351 491989 493847 493914 498076 501505 501637 502586 504638 506345 506937 507590 508595 511325 512188 513889 515629 515631 515935 516503 517143 519416 519457 520936 521154 521168 522735 522928 525964 526877 528524 528849 536699 545685 546715 549680 553657 556563 560373 560746 561283 563874 566322 567825 569524 569541 577086 578457 583240 585392 585476 591172 594554 600793 600798 600819 600859 602933 603249 614689 615838 623847 626847 664223 665319 666983 682618 696308 707312 750121 759987 802117 808527 813573 814741 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (9.73%) |
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 392903 623847 395931 430787 603249 682618 802117 488825 491351 519416 501637 487806 600819 391359 396278 485130 455605 528849 577086 600859 465906 473493 464260 508595 515631 482975 520936 489470 521168 528524 506937 546715 569524 707312 600793 614689 759987 465912 404762 515629 507590 502586 813573 469550 447497 536699 521154 468522 561283 563874 600798 591172 615838 626847 808527 428664 441644 451483 405288 460647 474104 417858 455462 526877 483333 493847 501505 512188 384807 444083 814741 467196 471956 516503 511325 556563 560746 569541 578457 664223 696308 665319 545685 583240 602933 447713 447971 465013 519457 522735 493914 522928 488379 491989 525964 479322 504638 513889 472916 560373 566322 567825 553657 585392 585476 442254 455171 422970 506345 498076 442810 457176 517143 549680 666983 594554 750121 482828 515935 405300 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.85%) |
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 384807 391359 392903 395931 396278 404762 405288 405300 417858 422970 428664 430787 441644 442254 442810 444083 447497 447713 447971 451483 455171 455462 455605 457176 460647 464260 465013 465906 465912 467196 468522 469550 471956 472916 473493 474104 479322 482828 482975 483333 485130 487806 488379 488825 489470 491351 491989 493847 493914 498076 501505 501637 502586 504638 506345 506937 507590 508595 511325 512188 513889 515629 515631 515935 516503 517143 519416 519457 520936 521154 521168 522735 522928 525964 526877 528524 528849 536699 545685 546715 549680 553657 556563 560373 560746 561283 563874 566322 567825 569524 569541 577086 578457 583240 585392 585476 591172 594554 600793 600798 600819 600859 602933 603249 614689 615838 623847 626847 664223 665319 666983 682618 696308 707312 750121 759987 802117 808527 813573 814741 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс boss"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex with boss"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс boss"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
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.