Query Metrics
7
Database Queries
7
Different statements
433.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.71 ms (47.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"please sex"
]
|
||||||||||||||||||||||||||||||
|
202.69 ms (46.71%) |
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 396524 400138 409615 414008 421696 423495 426606 426810 432685 435134 437218 439382 446393 448849 452770 453025 453202 454036 455467 457391 458681 458915 461255 463385 463503 465976 466706 467575 472525 472692 475208 475939 478555 479941 485065 491629 492495 496470 496616 499782 501208 504740 505150 506027 506408 510610 514877 516259 516818 523151 524251 525197 525392 528572 530458 530631 532000 535425 535478 536918 541869 542787 546902 547421 547865 548071 552258 554219 554552 558562 562377 563082 571086 571126 578434 581497 584259 588131 592481 592661 604101 609214 610012 615707 616062 620473 623972 626839 629681 642677 644689 645850 653764 676680 680440 705540 721180 734154 737276 741656 743375 744939 759891 760980 761022 761208 761481 761496 765322 765580 783205 787499 796143 796150 801258 802720 809872 810852 814501 816260 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (3.52%) |
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 629681 796150 759891 761022 761481 741656 765322 737276 760980 761496 620473 458915 452770 525392 705540 743375 802720 409615 516818 578434 645850 491629 535425 532000 554219 552258 558562 676680 547421 457391 396524 499782 506408 454036 510610 535478 530631 581497 653764 734154 453025 423495 525197 505150 472525 496470 523151 514877 546902 541869 680440 592481 615707 809872 783205 479941 524251 421696 485065 466706 461255 496616 504740 563082 571126 542787 571086 554552 562377 592661 609214 623972 810852 787499 446393 437218 528572 400138 465976 721180 644689 816260 467575 642677 439382 814501 455467 530458 492495 584259 547865 588131 616062 626839 610012 796143 761208 765580 472692 448849 463503 426606 506027 744939 478555 426810 414008 475939 516259 536918 801258 475208 432685 501208 453202 548071 604101 435134 458681 463385 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (0.76%) |
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 396524 400138 409615 414008 421696 423495 426606 426810 432685 435134 437218 439382 446393 448849 452770 453025 453202 454036 455467 457391 458681 458915 461255 463385 463503 465976 466706 467575 472525 472692 475208 475939 478555 479941 485065 491629 492495 496470 496616 499782 501208 504740 505150 506027 506408 510610 514877 516259 516818 523151 524251 525197 525392 528572 530458 530631 532000 535425 535478 536918 541869 542787 546902 547421 547865 548071 552258 554219 554552 558562 562377 563082 571086 571126 578434 581497 584259 588131 592481 592661 604101 609214 610012 615707 616062 620473 623972 626839 629681 642677 644689 645850 653764 676680 680440 705540 721180 734154 737276 741656 743375 744939 759891 760980 761022 761208 761481 761496 765322 765580 783205 787499 796143 796150 801258 802720 809872 810852 814501 816260 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"please секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"please секс"
]
|
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.