Query Metrics
7
Database Queries
7
Different statements
180.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.99 ms (82.87%) |
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 7166 7389 43250 81734 117388 188189 373406 385838 386043 386083 386395 388647 388756 391717 394162 394620 394639 395625 396091 400834 401069 402441 402718 404931 409728 413446 418774 418866 421363 421877 421890 422298 428469 432731 433232 434428 435177 440927 441093 441527 441578 441925 442503 443919 445642 446055 447469 448303 448862 453678 454367 457329 457599 458167 463361 463849 463885 464578 464797 465803 468124 468177 473134 474267 474818 480934 482827 485424 486841 488596 492229 493773 499867 502440 506612 506616 508437 508887 516107 521576 521835 525577 525688 525970 527416 529909 533803 547658 550436 575566 588934 590632 591197 592412 593774 597572 597819 598685 604016 604316 620044 623716 624030 624165 626249 639722 653544 654322 656209 712264 720128 736534 739995 740103 754097 768854 780135 791862 800321 805254 ] |
||||||||||||||||||||||||||||||
|
19.89 ms (10.99%) |
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 499867 454367 421890 81734 492229 591197 626249 386395 441527 458167 712264 800321 386043 442503 394620 385838 401069 463361 394162 388756 388647 400834 441093 413446 457329 525970 464578 473134 474267 575566 593774 805254 754097 391717 468124 117388 463885 7389 418866 435177 409728 441925 448303 453678 480934 485424 508887 521835 428469 404931 434428 441578 656209 780135 739995 768854 736534 720128 791862 639722 590632 597572 521576 506612 508437 394639 395625 433232 443919 445642 446055 447469 448862 493773 740103 373406 402441 432731 463849 386083 421877 464797 418774 457599 465803 402718 440927 468177 516107 486841 502440 482827 525577 529909 533803 7166 653544 654322 604016 620044 474818 506616 592412 623716 588934 598685 421363 547658 597819 624030 604316 624165 527416 488596 525688 550436 188189 43250 396091 422298 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.77%) |
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 7166 7389 43250 81734 117388 188189 373406 385838 386043 386083 386395 388647 388756 391717 394162 394620 394639 395625 396091 400834 401069 402441 402718 404931 409728 413446 418774 418866 421363 421877 421890 422298 428469 432731 433232 434428 435177 440927 441093 441527 441578 441925 442503 443919 445642 446055 447469 448303 448862 453678 454367 457329 457599 458167 463361 463849 463885 464578 464797 465803 468124 468177 473134 474267 474818 480934 482827 485424 486841 488596 492229 493773 499867 502440 506612 506616 508437 508887 516107 521576 521835 525577 525688 525970 527416 529909 533803 547658 550436 575566 588934 590632 591197 592412 593774 597572 597819 598685 604016 604316 620044 623716 624030 624165 626249 639722 653544 654322 656209 712264 720128 736534 739995 740103 754097 768854 780135 791862 800321 805254 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод анал"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bitch anal"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
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.