Query Metrics
7
Database Queries
7
Different statements
208.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.71 ms (87.58%) |
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 79765 118086 124361 124494 183506 191407 196316 318315 334376 388365 391756 395258 395460 396378 397873 400516 403150 405020 409878 409932 412101 421148 426248 440758 440759 440819 444320 445599 447799 454370 455340 458927 458929 464149 469172 472608 472909 472939 477471 486442 493543 495838 508270 518454 518906 519099 520747 525646 525769 537927 541084 543484 544274 551229 560154 565484 582314 589357 589601 590673 591667 593987 596116 598133 602052 604077 613465 619397 619469 619470 619484 621246 626291 632308 632607 633119 638437 642835 643121 645581 649194 665586 675053 675062 675095 675136 675645 675686 675687 675689 675690 675691 707609 708422 708437 715368 726455 728101 732248 736692 741282 741896 742507 744337 759768 760827 773608 773998 774995 785179 798325 801382 802053 802129 804532 812768 815029 817422 818426 819571 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (7.46%) |
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 454370 649194 626291 619469 604077 707609 802129 124361 643121 590673 798325 741282 744337 183506 318315 395460 79765 409878 464149 469172 537927 675689 582314 759768 403150 458927 560154 675062 596116 812768 741896 455340 191407 495838 391756 665586 802053 728101 742507 400516 518906 124494 440819 817422 493543 508270 525646 519099 544274 565484 675690 708422 593987 602052 589357 613465 621246 591667 773998 760827 445599 396378 412101 426248 440758 675686 715368 589601 642835 801382 804532 732248 726455 633119 774995 444320 518454 736692 785179 447799 118086 405020 397873 409932 819571 477471 395258 543484 675095 619397 619470 773608 196316 815029 472939 458929 619484 334376 388365 632607 486442 472608 551229 708437 645581 675687 632308 598133 472909 440759 421148 818426 520747 525769 541084 675136 675645 675053 675691 638437 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.24%) |
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 79765 118086 124361 124494 183506 191407 196316 318315 334376 388365 391756 395258 395460 396378 397873 400516 403150 405020 409878 409932 412101 421148 426248 440758 440759 440819 444320 445599 447799 454370 455340 458927 458929 464149 469172 472608 472909 472939 477471 486442 493543 495838 508270 518454 518906 519099 520747 525646 525769 537927 541084 543484 544274 551229 560154 565484 582314 589357 589601 590673 591667 593987 596116 598133 602052 604077 613465 619397 619469 619470 619484 621246 626291 632308 632607 633119 638437 642835 643121 645581 649194 665586 675053 675062 675095 675136 675645 675686 675687 675689 675690 675691 707609 708422 708437 715368 726455 728101 732248 736692 741282 741896 742507 744337 759768 760827 773608 773998 774995 785179 798325 801382 802053 802129 804532 812768 815029 817422 818426 819571 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex french"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс french"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс french"
]
|
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.