Query Metrics
7
Database Queries
7
Different statements
159.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.22 ms (86.86%) |
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 396278 404762 404904 405288 405300 406237 417858 422970 425977 428664 441644 442254 442810 444083 447497 447971 451483 453021 455171 455462 455605 456408 457176 460647 464260 465013 465906 465912 467196 468522 469550 470179 471956 472149 472916 473493 474104 479322 482828 482975 483333 485130 488379 489470 491989 493847 493914 498076 501505 502586 504638 506345 506937 507590 508595 511325 512188 513889 514687 515137 515631 515935 517143 519457 520936 521154 521168 522735 522928 522997 523291 525964 526877 528524 528849 534862 536699 545685 545909 546715 549680 553657 556563 560373 560746 561283 563874 566322 567825 569524 569541 576002 577086 578457 583240 585392 588340 588644 591172 592320 594554 600793 600798 600859 600883 602933 606467 614689 615838 664223 665319 666983 696308 707312 750121 759987 808527 813573 814741 ] |
||||||||||||||||||||||||||||||
|
12.09 ms (7.60%) |
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 396278 485130 455605 528849 577086 600859 465906 473493 464260 508595 515631 482975 520936 489470 521168 528524 506937 534862 546715 569524 707312 600793 614689 759987 406237 465912 404762 507590 502586 813573 469550 447497 522997 536699 521154 468522 561283 563874 600798 591172 615838 808527 428664 441644 451483 405288 460647 474104 417858 455462 526877 483333 493847 514687 501505 512188 384807 444083 814741 467196 471956 511325 556563 560746 569541 578457 664223 696308 665319 545685 583240 602933 447971 465013 519457 522735 493914 522928 488379 491989 525964 479322 504638 513889 472916 560373 566322 567825 553657 585392 442254 455171 422970 506345 498076 442810 457176 517143 549680 666983 594554 750121 482828 515935 405300 404904 588644 453021 545909 606467 470179 515137 523291 576002 592320 600883 588340 425977 456408 472149 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.57%) |
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 396278 404762 404904 405288 405300 406237 417858 422970 425977 428664 441644 442254 442810 444083 447497 447971 451483 453021 455171 455462 455605 456408 457176 460647 464260 465013 465906 465912 467196 468522 469550 470179 471956 472149 472916 473493 474104 479322 482828 482975 483333 485130 488379 489470 491989 493847 493914 498076 501505 502586 504638 506345 506937 507590 508595 511325 512188 513889 514687 515137 515631 515935 517143 519457 520936 521154 521168 522735 522928 522997 523291 525964 526877 528524 528849 534862 536699 545685 545909 546715 549680 553657 556563 560373 560746 561283 563874 566322 567825 569524 569541 576002 577086 578457 583240 585392 588340 588644 591172 592320 594554 600793 600798 600859 600883 602933 606467 614689 615838 664223 665319 666983 696308 707312 750121 759987 808527 813573 814741 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boss sex"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boss секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boss секс"
]
|
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.