Query Metrics
7
Database Queries
7
Different statements
198.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.89 ms (83.42%) |
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 398965 412532 420799 422180 423958 424089 424624 428932 428955 429881 434008 435874 439300 439333 439345 440736 447467 451502 455475 456509 458160 458634 459121 460476 464264 474575 477411 479346 484107 488277 488915 489131 490619 495432 495498 496889 499661 503501 508803 511470 511576 513017 514483 523745 523872 526505 528654 545001 546986 552337 555137 560325 563359 565014 566561 572231 574076 579189 580874 588899 593148 597810 598433 598469 598526 598692 598950 604118 614601 615700 626212 626609 627839 659192 671560 674208 679652 685509 686585 689970 689973 691450 692531 695096 697157 700965 701904 702145 719421 725448 729339 732787 733437 735850 735959 740986 741824 746135 752913 754487 763974 764100 764776 769380 770600 784916 784920 785255 788039 790928 804306 806109 807604 808540 809260 812038 813558 813741 827691 827968 ] |
||||||||||||||||||||||||||||||
|
22.86 ms (11.50%) |
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 813741 788039 489131 546986 428932 477411 598469 807604 754487 574076 495432 508803 827691 764776 784920 528654 626609 615700 566561 604118 563359 490619 729339 447467 495498 812038 474575 439300 458160 424624 514483 686585 626212 598692 598950 808540 741824 764100 763974 398965 440736 523872 523745 420799 719421 503501 735959 572231 659192 679652 700965 701904 746135 785255 458634 691450 455475 460476 424089 813558 695096 614601 752913 484107 488915 671560 806109 435874 423958 552337 804306 439345 412532 692531 598433 725448 732787 740986 733437 579189 827968 689970 689973 702145 790928 784916 451502 456509 496889 580874 597810 439333 526505 560325 479346 627839 598526 809260 769380 428955 434008 459121 499661 429881 422180 770600 464264 588899 555137 511470 511576 565014 674208 593148 735850 513017 488277 685509 697157 545001 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.48%) |
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 398965 412532 420799 422180 423958 424089 424624 428932 428955 429881 434008 435874 439300 439333 439345 440736 447467 451502 455475 456509 458160 458634 459121 460476 464264 474575 477411 479346 484107 488277 488915 489131 490619 495432 495498 496889 499661 503501 508803 511470 511576 513017 514483 523745 523872 526505 528654 545001 546986 552337 555137 560325 563359 565014 566561 572231 574076 579189 580874 588899 593148 597810 598433 598469 598526 598692 598950 604118 614601 615700 626212 626609 627839 659192 671560 674208 679652 685509 686585 689970 689973 691450 692531 695096 697157 700965 701904 702145 719421 725448 729339 732787 733437 735850 735959 740986 741824 746135 752913 754487 763974 764100 764776 769380 770600 784916 784920 785255 788039 790928 804306 806109 807604 808540 809260 812038 813558 813741 827691 827968 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск девушк masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.64 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.