Query Metrics
7
Database Queries
7
Different statements
413.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.87 ms (51.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ shower"
]
|
||||||||||||||||||||||||||||||
|
173.87 ms (42.06%) |
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 24034 24158 24218 34391 191075 383282 385933 386217 388116 388591 397176 404483 412681 417099 417511 425529 427498 443862 444991 452482 453469 455738 456281 457005 458382 458713 463637 467663 473504 478753 488100 488359 490210 496324 496928 504352 511808 514321 517372 517599 521746 523450 523959 525469 526515 529430 532444 533630 538731 540088 546142 548081 554844 555989 558849 564172 566012 570873 571182 573209 577664 579726 587935 588494 590930 603407 604121 604881 607926 610271 614428 619606 620089 626560 629646 631607 636736 645842 648545 650128 658266 659015 663547 663971 673791 677975 702615 706666 710465 719895 736581 737650 745744 759113 765860 774730 775494 781931 781934 788563 790204 795258 797153 806140 806160 806359 807219 808041 810025 813253 813729 817304 820372 821326 823778 824350 827630 827712 827730 828592 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (3.74%) |
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 521746 467663 663547 631607 775494 806140 806160 765860 813253 463637 496928 523450 648545 817304 737650 790204 603407 529430 24158 610271 191075 453469 588494 452482 577664 570873 620089 607926 417099 457005 412681 425529 659015 546142 781934 736581 383282 781931 797153 828592 24218 388116 385933 386217 663971 24034 532444 587935 807219 388591 458382 455738 443862 478753 514321 504352 526515 490210 511808 590930 566012 573209 774730 533630 827630 827730 813729 824350 538731 496324 540088 719895 548081 604121 604881 636736 788563 795258 810025 759113 706666 404483 473504 558849 564172 579726 614428 488100 456281 444991 458713 525469 555989 417511 823778 645842 808041 488359 517372 571182 821326 650128 677975 629646 34391 745744 397176 554844 658266 626560 827712 710465 619606 427498 673791 517599 523959 820372 702615 806359 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (0.89%) |
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 24034 24158 24218 34391 191075 383282 385933 386217 388116 388591 397176 404483 412681 417099 417511 425529 427498 443862 444991 452482 453469 455738 456281 457005 458382 458713 463637 467663 473504 478753 488100 488359 490210 496324 496928 504352 511808 514321 517372 517599 521746 523450 523959 525469 526515 529430 532444 533630 538731 540088 546142 548081 554844 555989 558849 564172 566012 570873 571182 573209 577664 579726 587935 588494 590930 603407 604121 604881 607926 610271 614428 619606 620089 626560 629646 631607 636736 645842 648545 650128 658266 659015 663547 663971 673791 677975 702615 706666 710465 719895 736581 737650 745744 759113 765860 774730 775494 781931 781934 788563 790204 795258 797153 806140 806160 806359 807219 808041 810025 813253 813729 817304 820372 821326 823778 824350 827630 827712 827730 828592 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ shower"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits shower"
]
|
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.