Query Metrics
7
Database Queries
7
Different statements
201.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.27 ms (88.83%) |
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 390538 436948 438779 438787 451033 454137 455510 455950 458328 460897 461693 462129 462539 462937 462984 466555 470560 475599 476487 476521 481840 484101 484855 484857 484859 484860 484862 487607 488729 488730 491374 495425 495442 495600 497563 497582 497585 497871 497876 498455 498776 504302 506718 509491 509495 511708 512286 512760 513752 515507 515651 516424 520480 521877 521974 522781 523313 523315 523702 526604 534078 534080 536433 541835 543971 544519 545899 547621 548740 553258 555663 558658 559738 560423 562259 562265 562288 562359 571780 574506 574534 574858 577739 578367 586532 591393 602792 605251 605296 609214 615707 622111 623831 650277 659258 659276 659315 661247 661665 682869 691935 705116 706457 713925 715395 728123 728706 731325 742214 748542 757974 764017 764190 784286 785382 788299 791759 799776 807337 818057 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (6.58%) |
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 498455 705116 799776 602792 484855 541835 659276 466555 512760 562359 547621 509491 818057 764190 462129 484857 497585 571780 788299 534080 548740 785382 491374 511708 390538 454137 497871 691935 586532 545899 605251 791759 534078 574506 742214 543971 506718 521974 497563 523313 578367 661247 622111 748542 484101 659258 659315 562288 731325 484860 495600 488729 497582 523315 650277 623831 436948 504302 515507 523702 455950 553258 605296 438787 458328 512286 562259 574858 713925 715395 462937 484862 498776 462539 521877 455510 555663 560423 476487 460897 497876 513752 484859 574534 509495 562265 615707 475599 451033 476521 526604 495425 516424 487607 577739 784286 728706 495442 481840 544519 559738 591393 807337 764017 438779 470560 515651 609214 461693 682869 757974 728123 462984 536433 488730 661665 522781 558658 706457 520480 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.27%) |
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 390538 436948 438779 438787 451033 454137 455510 455950 458328 460897 461693 462129 462539 462937 462984 466555 470560 475599 476487 476521 481840 484101 484855 484857 484859 484860 484862 487607 488729 488730 491374 495425 495442 495600 497563 497582 497585 497871 497876 498455 498776 504302 506718 509491 509495 511708 512286 512760 513752 515507 515651 516424 520480 521877 521974 522781 523313 523315 523702 526604 534078 534080 536433 541835 543971 544519 545899 547621 548740 553258 555663 558658 559738 560423 562259 562265 562288 562359 571780 574506 574534 574858 577739 578367 586532 591393 602792 605251 605296 609214 615707 622111 623831 650277 659258 659276 659315 661247 661665 682869 691935 705116 706457 713925 715395 728123 728706 731325 742214 748542 757974 764017 764190 784286 785382 788299 791759 799776 807337 818057 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sex party"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс party"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.18 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск секс party"
]
|
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.