Query Metrics
7
Database Queries
7
Different statements
204.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.93 ms (86.03%) |
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 143302 383925 390497 415627 421471 421734 421769 423750 428463 428801 428910 430999 434838 440759 444429 446252 449031 452355 452708 456934 456948 457127 457820 458488 459654 461800 464207 464710 465580 468984 471493 479415 479955 482712 484033 489425 492183 492946 494000 495087 495453 496370 496947 500184 501579 501728 510988 511485 512760 513466 513584 515598 515828 518450 518621 519855 519981 520929 520933 521220 525583 525882 527713 527934 529449 534300 535384 541809 554947 563320 564963 565794 567713 571322 572205 577876 585749 586728 594638 606892 613024 614487 615984 620402 623836 626392 628864 648262 657505 661571 666055 669233 698728 714322 718750 724853 728458 736137 736866 737184 737588 738442 742871 744368 746270 757825 758674 761850 766872 770462 774182 780267 785920 788533 790501 798229 815320 816905 823275 ] |
||||||||||||||||||||||||||||||
|
17.75 ms (8.68%) |
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 798229 731666 738442 737184 737588 744368 746270 770462 780267 785920 788533 428463 428910 456934 479415 452355 457820 468984 430999 515598 495087 518450 512760 383925 816905 415627 465580 492946 464710 520933 535384 494000 563320 572205 577876 657505 666055 714322 565794 585749 620402 628864 736866 757825 758674 698728 458488 471493 434838 511485 525583 500184 661571 501728 390497 669233 724853 718750 143302 423750 541809 527713 452708 534300 615984 614487 606892 774182 421471 518621 489425 501579 421734 428801 815320 823275 446252 456948 529449 586728 790501 761850 766872 623836 449031 457127 461800 479955 525882 513466 510988 520929 496370 496947 515828 521220 440759 482712 464207 492183 495453 519981 567713 554947 648262 564963 571322 626392 594638 613024 742871 728458 736137 421769 444429 459654 513584 484033 519855 527934 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.53%) |
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 143302 383925 390497 415627 421471 421734 421769 423750 428463 428801 428910 430999 434838 440759 444429 446252 449031 452355 452708 456934 456948 457127 457820 458488 459654 461800 464207 464710 465580 468984 471493 479415 479955 482712 484033 489425 492183 492946 494000 495087 495453 496370 496947 500184 501579 501728 510988 511485 512760 513466 513584 515598 515828 518450 518621 519855 519981 520929 520933 521220 525583 525882 527713 527934 529449 534300 535384 541809 554947 563320 564963 565794 567713 571322 572205 577876 585749 586728 594638 606892 613024 614487 615984 620402 623836 626392 628864 648262 657505 661571 666055 669233 698728 714322 718750 724853 728458 736137 736866 737184 737588 738442 742871 744368 746270 757825 758674 761850 766872 770462 774182 780267 785920 788533 790501 798229 815320 816905 823275 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex work"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс work"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс work"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.