Query Metrics
7
Database Queries
7
Different statements
176.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.75 ms (83.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 95982 348158 387321 388325 388726 390841 391592 399759 399926 404306 407018 415803 423318 424791 425578 426521 427437 429287 437658 441020 442520 443456 443533 450399 450808 451669 451804 453781 454401 454636 456281 463627 465191 470505 471065 471899 473572 473939 474269 476252 477463 479899 487161 487260 495769 496887 498594 499566 500180 504163 504416 505161 505446 507003 509215 510170 511298 512199 512990 513301 513824 513948 514939 516013 517452 518003 521168 523959 524219 527066 528030 528164 530737 532012 533011 533703 537631 540051 540929 544095 545330 548732 549322 549422 549826 549830 552093 557058 557571 561488 565361 566449 574196 576686 577733 586899 592392 602841 604195 604370 605442 623193 632289 642677 649975 653890 662143 671233 671753 678387 682107 699516 702286 752058 779271 792616 803424 805602 806784 814939 ] |
||||||||||||||||||||||||||||||
|
19.24 ms (10.89%) |
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 805602 806784 524219 512199 537631 566449 549322 517452 510170 623193 509215 463627 574196 450399 513948 632289 441020 548732 521168 425578 507003 604195 523959 779271 456281 540929 399926 388325 407018 487161 514939 471899 557058 649975 540051 545330 451669 577733 552093 427437 512990 498594 423318 474269 495769 479899 565361 505161 465191 699516 391592 348158 443456 549422 453781 471065 530737 533703 702286 528030 404306 442520 527066 95982 476252 473572 532012 561488 576686 557571 528164 516013 511298 653890 450808 454636 443533 477463 605442 426521 504163 399759 504416 513301 642677 424791 487260 388726 662143 671753 592392 792616 473939 415803 803424 671233 752058 505446 518003 451804 437658 604370 496887 549826 586899 470505 499566 533011 513824 549830 390841 814939 682107 678387 602841 544095 429287 387321 454401 500180 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.52%) |
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 95982 348158 387321 388325 388726 390841 391592 399759 399926 404306 407018 415803 423318 424791 425578 426521 427437 429287 437658 441020 442520 443456 443533 450399 450808 451669 451804 453781 454401 454636 456281 463627 465191 470505 471065 471899 473572 473939 474269 476252 477463 479899 487161 487260 495769 496887 498594 499566 500180 504163 504416 505161 505446 507003 509215 510170 511298 512199 512990 513301 513824 513948 514939 516013 517452 518003 521168 523959 524219 527066 528030 528164 530737 532012 533011 533703 537631 540051 540929 544095 545330 548732 549322 549422 549826 549830 552093 557058 557571 561488 565361 566449 574196 576686 577733 586899 592392 602841 604195 604370 605442 623193 632289 642677 649975 653890 662143 671233 671753 678387 682107 699516 702286 752058 779271 792616 803424 805602 806784 814939 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс ван"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.97%) |
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.