Query Metrics
7
Database Queries
7
Different statements
183.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.87 ms (84.94%) |
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 3575 4252 20431 29108 66747 82252 145353 145660 186151 307352 318892 361413 381782 381939 382141 383829 384576 384958 385933 387319 389202 389708 396519 398580 411755 411958 415257 416144 419063 420048 431541 447040 457635 459855 473492 478356 502998 518093 523146 525819 527065 536167 541086 542480 544482 547052 550149 557450 564142 566206 566997 567383 568133 568291 571537 572764 586566 591020 596830 598628 599549 601870 607432 612293 623488 626104 630909 631134 649560 654432 655515 663427 663526 664288 665110 665461 667644 667901 672377 677691 680657 697481 700039 702178 708469 715412 718256 721282 724727 726650 726663 730111 731428 732247 737177 739734 744346 746044 746311 752112 753570 754624 764693 770161 775101 776730 786249 788382 791034 791961 792786 797456 797761 799996 802634 805541 808688 813772 814319 825448 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (8.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 564142 776730 361413 536167 752112 385933 663427 447040 473492 431541 672377 384958 389708 715412 478356 419063 459855 547052 680657 665461 667901 571537 599549 623488 626104 630909 754624 791961 808688 730111 744346 612293 396519 20431 702178 457635 29108 523146 384576 387319 550149 591020 382141 502998 567383 307352 655515 145660 598628 825448 718256 726650 544482 721282 654432 663526 724727 753570 66747 82252 572764 145353 186151 732247 383829 788382 411755 665110 607432 596830 381782 4252 813772 566997 420048 415257 318892 802634 797761 775101 700039 542480 731428 667644 664288 791034 805541 518093 416144 398580 708469 797456 527065 746311 739734 746044 697481 381939 568291 568133 799996 792786 631134 786249 411958 814319 649560 677691 601870 726663 737177 389202 525819 586566 770161 541086 3575 557450 764693 566206 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.60%) |
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 3575 4252 20431 29108 66747 82252 145353 145660 186151 307352 318892 361413 381782 381939 382141 383829 384576 384958 385933 387319 389202 389708 396519 398580 411755 411958 415257 416144 419063 420048 431541 447040 457635 459855 473492 478356 502998 518093 523146 525819 527065 536167 541086 542480 544482 547052 550149 557450 564142 566206 566997 567383 568133 568291 571537 572764 586566 591020 596830 598628 599549 601870 607432 612293 623488 626104 630909 631134 649560 654432 655515 663427 663526 664288 665110 665461 667644 667901 672377 677691 680657 697481 700039 702178 708469 715412 718256 721282 724727 726650 726663 730111 731428 732247 737177 739734 744346 746044 746311 752112 753570 754624 764693 770161 775101 776730 786249 788382 791034 791961 792786 797456 797761 799996 802634 805541 808688 813772 814319 825448 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette big tits"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
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.