Query Metrics
7
Database Queries
7
Different statements
164.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.83 ms (86.11%) |
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 6679 11175 21594 29429 55266 82281 91532 95864 96843 123955 151564 191356 193390 382438 382853 383491 384779 386408 386460 387186 388220 388891 392178 394528 395740 396018 396234 396542 396566 396936 404240 404615 410872 411943 414690 423567 433212 443685 454127 456445 460684 461503 471584 473981 487383 487582 490227 491272 496117 503831 521993 532268 533523 543124 543232 544528 545586 555152 558786 562763 562888 573394 584710 586886 597852 600843 609573 610007 610786 613872 617340 625400 628416 628707 631185 633051 636545 644259 645913 649112 650843 653567 659259 668174 669410 670820 672469 676465 680691 684914 694641 699621 704044 710832 720372 724528 734306 742186 742604 746421 758603 758972 770820 778903 779853 790961 792627 795133 797849 798768 798797 799579 805518 807518 810685 817518 818221 820032 823205 827881 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (8.71%) |
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 650843 669410 680691 684914 704044 670820 694641 710832 562888 584710 610007 613872 631185 628416 625400 644259 597852 628707 807518 810685 792627 724528 758972 633051 636545 699621 797849 382438 386460 404240 423567 95864 96843 383491 395740 396234 460684 191356 443685 473981 404615 456445 491272 490227 496117 521993 487582 386408 123955 21594 29429 396936 817518 543232 790961 758603 770820 798797 411943 433212 487383 503831 573394 544528 558786 672469 545586 610786 600843 461503 471584 382853 396542 396566 823205 820032 827881 533523 532268 555152 543124 645913 676465 649112 668174 659259 720372 617340 778903 798768 779853 795133 799579 805518 734306 742186 746421 742604 609573 151564 387186 384779 653567 562763 586886 91532 193390 394528 392178 55266 6679 11175 82281 388891 388220 396018 414690 410872 818221 454127 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.55%) |
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 6679 11175 21594 29429 55266 82281 91532 95864 96843 123955 151564 191356 193390 382438 382853 383491 384779 386408 386460 387186 388220 388891 392178 394528 395740 396018 396234 396542 396566 396936 404240 404615 410872 411943 414690 423567 433212 443685 454127 456445 460684 461503 471584 473981 487383 487582 490227 491272 496117 503831 521993 532268 533523 543124 543232 544528 545586 555152 558786 562763 562888 573394 584710 586886 597852 600843 609573 610007 610786 613872 617340 625400 628416 628707 631185 633051 636545 644259 645913 649112 650843 653567 659259 668174 669410 670820 672469 676465 680691 684914 694641 699621 704044 710832 720372 724528 734306 742186 742604 746421 758603 758972 770820 778903 779853 790961 792627 795133 797849 798768 798797 799579 805518 807518 810685 817518 818221 820032 823205 827881 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex xxx 2022"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс xxx"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.15 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс xxx"
]
|
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.