Query Metrics
7
Database Queries
7
Different statements
143.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.90 ms (82.32%) |
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 413446 429362 430526 431516 432970 436095 438417 444231 444806 445828 448576 452805 452937 452977 455207 457217 457292 459649 466369 466551 467583 470394 471125 473005 474349 474872 477354 480073 482147 482632 486776 487407 488713 489305 491626 495559 500622 504872 506059 508200 509552 509998 516320 520834 529092 532940 539286 542794 543429 561748 566432 583502 584103 606405 610822 625660 632333 637041 649198 652915 653142 657244 663547 670227 670820 674467 680691 686214 690749 694958 695096 713454 715544 716124 717523 719841 720139 720198 720833 720882 720883 724264 724304 726896 728493 730497 732003 732257 733246 744328 750477 750792 751452 751589 765807 766129 773553 775834 775866 783112 784038 784054 790034 793376 793471 795396 795807 797080 797461 798135 804697 804700 804765 806395 806587 809520 809523 814360 816094 817444 ] |
||||||||||||||||||||||||||||||
|
16.51 ms (11.53%) |
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 719841 670227 720198 784038 775834 793471 452977 816094 783112 444806 695096 690749 726896 561748 459649 766129 804697 806587 784054 798135 566432 670820 444231 516320 817444 716124 470394 430526 720833 732257 713454 724304 657244 797080 625660 466551 466369 413446 431516 694958 606405 804700 773553 750477 680691 814360 720882 653142 436095 489305 797461 473005 715544 809523 765807 732003 508200 529092 491626 649198 583502 733246 751452 720139 474349 500622 674467 728493 438417 504872 477354 455207 584103 750792 487407 509552 457217 480073 806395 744328 637041 793376 751589 720883 429362 663547 795807 730497 482147 506059 543429 775866 632333 717523 804765 488713 448576 520834 686214 445828 542794 652915 474872 452805 532940 724264 795396 452937 790034 432970 467583 471125 457292 495559 610822 809520 482632 486776 509998 539286 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.74%) |
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 413446 429362 430526 431516 432970 436095 438417 444231 444806 445828 448576 452805 452937 452977 455207 457217 457292 459649 466369 466551 467583 470394 471125 473005 474349 474872 477354 480073 482147 482632 486776 487407 488713 489305 491626 495559 500622 504872 506059 508200 509552 509998 516320 520834 529092 532940 539286 542794 543429 561748 566432 583502 584103 606405 610822 625660 632333 637041 649198 652915 653142 657244 663547 670227 670820 674467 680691 686214 690749 694958 695096 713454 715544 716124 717523 719841 720139 720198 720833 720882 720883 724264 724304 726896 728493 730497 732003 732257 733246 744328 750477 750792 751452 751589 765807 766129 773553 775834 775866 783112 784038 784054 790034 793376 793471 795396 795807 797080 797461 798135 804697 804700 804765 806395 806587 809520 809523 814360 816094 817444 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double blowjob webcam"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double минет оральн секс вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double минет оральн секс вебкамер"
]
|
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.