Query Metrics
7
Database Queries
7
Different statements
149.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.77 ms (82.21%) |
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 150487 391966 391992 391994 400728 400832 400993 411350 421878 421913 423964 423972 424060 426920 428797 429879 432418 433048 433419 433458 434885 439711 439761 439763 442933 443191 443292 443950 444913 445112 446443 448663 453403 454567 456045 460754 462074 462085 462104 462307 463152 464545 466069 466491 467855 467914 470296 474799 476628 476629 477167 477704 477709 478380 479038 479107 481317 483379 483385 486811 487753 488532 488559 493191 496063 496873 497205 497206 498428 503175 503395 503498 509436 509615 511096 514301 516270 516712 518827 522331 523840 524612 525884 526737 527706 528197 542508 545535 548036 552783 558886 559543 560875 561758 567098 578858 672835 713758 714831 722085 731018 731205 731229 740632 746144 749891 781925 788343 794830 796747 796829 824163 824485 825356 825395 826376 827034 827098 827583 828033 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (10.93%) |
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 462104 467855 477167 559543 567098 578858 794830 796747 731018 731205 731229 746144 781925 391994 432418 433048 443191 481317 426920 434885 428797 429879 433419 433458 464545 522331 503175 503395 511096 488532 150487 466069 391966 470296 443292 462085 400993 454567 524612 514301 525884 528197 487753 411350 722085 558886 462074 462307 442933 421878 439761 523840 518827 424060 479038 496873 503498 561758 542508 548036 400832 444913 446443 467914 474799 477709 479107 445112 456045 460754 466491 391992 421913 439763 448663 453403 439711 516712 483379 488559 493191 496063 497205 497206 509615 824485 826376 827034 827098 825356 825395 828033 788343 560875 796829 400728 476629 423964 509436 526737 483385 527706 545535 740632 713758 423972 477704 486811 672835 714831 749891 552783 476628 463152 478380 498428 516270 443950 824163 827583 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.99%) |
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 150487 391966 391992 391994 400728 400832 400993 411350 421878 421913 423964 423972 424060 426920 428797 429879 432418 433048 433419 433458 434885 439711 439761 439763 442933 443191 443292 443950 444913 445112 446443 448663 453403 454567 456045 460754 462074 462085 462104 462307 463152 464545 466069 466491 467855 467914 470296 474799 476628 476629 477167 477704 477709 478380 479038 479107 481317 483379 483385 486811 487753 488532 488559 493191 496063 496873 497205 497206 498428 503175 503395 503498 509436 509615 511096 514301 516270 516712 518827 522331 523840 524612 525884 526737 527706 528197 542508 545535 548036 552783 558886 559543 560875 561758 567098 578858 672835 713758 714831 722085 731018 731205 731229 740632 746144 749891 781925 788343 794830 796747 796829 824163 824485 825356 825395 826376 827034 827098 827583 828033 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен полная"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская жена полная"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.12%) |
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.