Query Metrics
7
Database Queries
7
Different statements
388.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
361.82 ms (93.25%) |
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 96800 123994 161427 229483 394006 394116 400880 403389 407025 407567 414302 414319 428218 428463 432410 433854 437233 444814 451220 453191 456368 456405 458466 459525 460712 461133 469632 471731 472960 480898 481073 488080 492227 495409 499868 509710 512272 513092 513282 523559 524368 524404 528390 528394 533740 534811 536210 538255 540991 541052 548671 549144 552514 554174 556219 560481 567914 572744 579569 583449 586248 587974 588835 595433 602326 604799 606934 607080 622274 622416 630445 636489 648982 650236 651650 661969 670530 675713 681014 681182 691462 696986 698123 698228 708306 718640 732635 734146 736368 736489 747094 747646 748221 748624 755101 755375 756247 756978 770393 772385 775918 776174 784441 785186 786150 791093 791194 796449 797151 799975 804207 805459 808321 808730 811746 814137 819619 820841 822257 825781 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (4.14%) |
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 403389 407567 480898 414319 469632 513282 825781 471731 453191 459525 523559 524404 460712 488080 554174 548671 541052 675713 698123 718640 648982 681014 698228 681182 579569 604799 622274 622416 588835 595433 775918 776174 797151 811746 734146 736368 748221 755101 784441 785186 732635 755375 747094 748624 770393 696986 437233 394006 433854 472960 495409 587974 791194 804207 123994 161427 229483 394116 96800 400880 428218 819619 814137 820841 822257 458466 499868 528394 536210 528390 533740 534811 538255 513092 481073 540991 572744 556219 560481 567914 583449 552514 650236 661969 670530 708306 651650 691462 549144 607080 630445 636489 586248 606934 808730 796449 805459 756978 772385 791093 808321 736489 756247 747646 602326 786150 799975 407025 428463 432410 414302 456405 444814 456368 451220 492227 509710 512272 524368 461133 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (0.75%) |
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 96800 123994 161427 229483 394006 394116 400880 403389 407025 407567 414302 414319 428218 428463 432410 433854 437233 444814 451220 453191 456368 456405 458466 459525 460712 461133 469632 471731 472960 480898 481073 488080 492227 495409 499868 509710 512272 513092 513282 523559 524368 524404 528390 528394 533740 534811 536210 538255 540991 541052 548671 549144 552514 554174 556219 560481 567914 572744 579569 583449 586248 587974 588835 595433 602326 604799 606934 607080 622274 622416 630445 636489 648982 650236 651650 661969 670530 675713 681014 681182 691462 696986 698123 698228 708306 718640 732635 734146 736368 736489 747094 747646 748221 748624 755101 755375 756247 756978 770393 772385 775918 776174 784441 785186 786150 791093 791194 796449 797151 799975 804207 805459 808321 808730 811746 814137 819619 820841 822257 825781 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"get fucked"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"get fucked"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"get fucked"
]
|
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.