Query Metrics
7
Database Queries
7
Different statements
208.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.26 ms (85.91%) |
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 379600 383565 389098 395933 417854 418958 419018 419093 422205 422413 428428 431675 434611 439620 442063 443594 444303 445035 445542 446288 448380 449501 450844 451664 451815 454650 454834 455002 456612 458416 460177 463922 464232 464482 465811 467194 467373 468574 468821 470173 471075 471370 471819 471849 472765 473506 473574 477788 479334 481286 481321 484630 485782 487318 489487 490015 491665 500725 502702 504302 504312 505034 508682 512640 514295 516913 517367 517572 517668 519062 519548 519929 521845 521902 522230 523952 526818 529284 534025 536655 542939 545659 546942 552757 559524 559791 560063 562886 563003 563196 565995 567214 567761 574462 574858 582222 582801 590537 625594 640403 643379 644664 652258 664831 665240 678971 684259 704579 712961 721563 742811 785945 796202 798680 803461 807352 813226 814853 823857 824347 ] |
||||||||||||||||||||||||||||||
|
18.95 ms (9.08%) |
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 491665 562886 526818 542939 785945 742811 446288 523952 439620 431675 419093 464482 521845 684259 704579 471849 481286 521902 434611 477788 456612 522230 444303 536655 458416 450844 454834 529284 807352 395933 470173 479334 463922 419018 505034 489487 443594 465811 517572 473574 490015 471819 484630 824347 823857 454650 582222 652258 813226 640403 417854 442063 451815 467194 379600 460177 590537 796202 512640 519929 485782 560063 422413 519548 546942 445035 481321 516913 500725 468821 559791 563196 552757 582801 625594 798680 803461 471075 389098 468574 487318 567761 448380 422205 565995 428428 814853 455002 563003 664831 721563 567214 643379 644664 712961 504312 467373 451664 449501 502702 545659 559524 418958 445542 473506 519062 517367 508682 517668 574462 665240 504302 514295 383565 534025 464232 472765 471370 574858 678971 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.20%) |
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 379600 383565 389098 395933 417854 418958 419018 419093 422205 422413 428428 431675 434611 439620 442063 443594 444303 445035 445542 446288 448380 449501 450844 451664 451815 454650 454834 455002 456612 458416 460177 463922 464232 464482 465811 467194 467373 468574 468821 470173 471075 471370 471819 471849 472765 473506 473574 477788 479334 481286 481321 484630 485782 487318 489487 490015 491665 500725 502702 504302 504312 505034 508682 512640 514295 516913 517367 517572 517668 519062 519548 519929 521845 521902 522230 523952 526818 529284 534025 536655 542939 545659 546942 552757 559524 559791 560063 562886 563003 563196 565995 567214 567761 574462 574858 582222 582801 590537 625594 640403 643379 644664 652258 664831 665240 678971 684259 704579 712961 721563 742811 785945 796202 798680 803461 807352 813226 814853 823857 824347 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping boy blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ парен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.