Query Metrics
7
Database Queries
7
Different statements
227.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.86 ms (88.71%) |
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 3381 106162 119987 384976 388858 396681 401120 401269 403197 410783 411257 417428 418690 426693 433990 435454 442631 446111 447115 447538 447686 447912 456234 457171 458918 459508 461443 461738 462108 463331 465868 466236 468581 470379 471990 478482 480017 486189 488502 502295 502424 514430 516737 517154 519778 542092 543548 545415 546970 549092 549864 550198 552390 556841 560638 561846 561880 564272 564401 567335 568509 569070 570708 572307 572968 590813 591240 592374 592518 595418 598056 598508 598612 600320 607315 608765 631167 637428 647043 647938 671656 677343 677355 679051 696228 701850 713364 720450 721366 722542 728336 730070 740710 740920 748661 752184 753472 753480 755178 758871 765109 766858 767323 775978 778875 778938 787323 788540 789308 791175 793677 796719 799953 800601 801284 804373 810045 819211 820558 820792 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (7.31%) |
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 486189 418690 447538 766858 753480 549092 568509 679051 720450 721366 722542 677343 713364 545415 598508 592518 788540 730070 755178 569070 775978 106162 517154 388858 396681 401269 401120 465868 458918 470379 447115 514430 542092 552390 572307 410783 468581 466236 480017 417428 435454 459508 478482 516737 384976 546970 556841 561880 564272 567335 561846 564401 647938 671656 677355 696228 560638 572968 598612 607315 591240 595418 598056 740710 631167 549864 592374 740920 748661 701850 793677 796719 446111 647043 550198 590813 728336 403197 442631 433990 457171 471990 543548 426693 447686 502424 488502 820792 820558 789308 800601 801284 787323 791175 799953 758871 810045 765109 753472 752184 767323 778875 778938 570708 600320 608765 804373 819211 637428 456234 461738 463331 3381 119987 461443 462108 411257 502295 519778 447912 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.29%) |
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 3381 106162 119987 384976 388858 396681 401120 401269 403197 410783 411257 417428 418690 426693 433990 435454 442631 446111 447115 447538 447686 447912 456234 457171 458918 459508 461443 461738 462108 463331 465868 466236 468581 470379 471990 478482 480017 486189 488502 502295 502424 514430 516737 517154 519778 542092 543548 545415 546970 549092 549864 550198 552390 556841 560638 561846 561880 564272 564401 567335 568509 569070 570708 572307 572968 590813 591240 592374 592518 595418 598056 598508 598612 600320 607315 608765 631167 637428 647043 647938 671656 677343 677355 679051 696228 701850 713364 720450 721366 722542 728336 730070 740710 740920 748661 752184 753472 753480 755178 758871 765109 766858 767323 775978 778875 778938 787323 788540 789308 791175 793677 796719 799953 800601 801284 804373 810045 819211 820558 820792 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits anal"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ анал"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.52%) |
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.