Query Metrics
7
Database Queries
7
Different statements
192.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.81 ms (84.64%) |
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 397995 414327 415703 417722 419123 422688 422853 422863 423205 429763 430446 433097 443094 446267 446706 447242 447412 447438 448847 454585 454809 461462 471631 471690 472248 472325 472499 473083 474000 474695 475716 476283 476752 478108 478473 478536 478966 479816 480299 483553 486885 488379 488477 489243 490956 491268 492064 492576 493122 494622 495895 497332 497368 501283 503419 504061 510393 511273 512973 515678 517229 517725 520740 522913 523654 523992 524253 524389 525109 525669 526103 528699 532976 533463 536340 537894 537919 543445 545416 545610 558135 566262 568720 574459 574986 579359 579620 584168 591680 591792 595192 595494 598828 600074 600599 603705 606508 612222 613179 615599 615826 621663 628364 628365 628366 628420 630053 635900 637022 639793 642044 642359 648868 649908 651136 663496 676026 676107 676641 708447 ] |
||||||||||||||||||||||||||||||
|
19.40 ms (10.09%) |
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 574986 491268 488379 515678 566262 422853 532976 511273 443094 478536 558135 472248 415703 628364 545416 579620 430446 510393 543445 642359 447242 454585 517725 524253 429763 630053 447438 461462 476283 471690 595192 615599 397995 473083 488477 525109 574459 651136 600599 523992 497332 504061 492576 603705 417722 489243 497368 512973 600074 479816 628365 639793 598828 637022 414327 422688 524389 483553 533463 536340 472499 676107 628420 447412 480299 471631 528699 621663 446706 474695 612222 422863 495895 448847 520740 525669 584168 537894 478473 537919 478966 628366 522913 663496 648868 708447 476752 501283 486885 545610 606508 615826 490956 494622 649908 591792 579359 595494 475716 446267 454809 478108 635900 419123 517229 676026 676641 472325 503419 474000 423205 523654 433097 591680 493122 492064 642044 568720 526103 613179 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.51%) |
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 397995 414327 415703 417722 419123 422688 422853 422863 423205 429763 430446 433097 443094 446267 446706 447242 447412 447438 448847 454585 454809 461462 471631 471690 472248 472325 472499 473083 474000 474695 475716 476283 476752 478108 478473 478536 478966 479816 480299 483553 486885 488379 488477 489243 490956 491268 492064 492576 493122 494622 495895 497332 497368 501283 503419 504061 510393 511273 512973 515678 517229 517725 520740 522913 523654 523992 524253 524389 525109 525669 526103 528699 532976 533463 536340 537894 537919 543445 545416 545610 558135 566262 568720 574459 574986 579359 579620 584168 591680 591792 595192 595494 598828 600074 600599 603705 606508 612222 613179 615599 615826 621663 628364 628365 628366 628420 630053 635900 637022 639793 642044 642359 648868 649908 651136 663496 676026 676107 676641 708447 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex casting"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.