Query Metrics
7
Database Queries
7
Different statements
159.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.27 ms (84.30%) |
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 49688 70636 118201 189022 301977 325743 382701 383436 384049 389965 390263 390583 391054 397390 401508 401522 403871 410872 417386 417930 418730 421544 423475 424068 425281 425654 427291 428216 429545 432699 437471 441669 445755 448080 449677 450607 451043 458815 461393 463561 464531 464699 465045 466257 467590 469825 469899 469901 470062 472994 474251 479431 480935 483207 485507 486200 488426 490750 497414 500249 504000 504090 506224 506339 508314 510785 513133 513218 517065 518795 521510 521654 522742 524984 526342 526385 527831 528800 535112 537436 544080 545216 552371 559963 561266 569623 585295 586431 600499 607647 629462 633884 641402 645106 656841 662583 666429 668057 680321 683461 688745 699435 722935 733786 737995 753788 757049 769555 778632 779425 780878 781079 784809 786119 787994 793292 797361 802038 803207 812121 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (10.89%) |
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 506339 490750 470062 458815 118201 465045 469825 488426 504090 688745 683461 633884 733786 793292 469901 486200 464699 526385 527831 401508 401522 403871 418730 526342 524984 472994 787994 797361 445755 384049 49688 448080 508314 510785 778632 390263 301977 428216 421544 410872 451043 469899 497414 521654 544080 569623 629462 607647 779425 441669 513133 382701 769555 802038 383436 666429 390583 425654 517065 528800 485507 521510 449677 780878 586431 480935 722935 662583 325743 389965 391054 423475 417930 427291 450607 479431 483207 535112 506224 522742 537436 464531 561266 552371 668057 680321 781079 786119 737995 417386 461393 189022 466257 424068 500249 753788 545216 70636 803207 429545 585295 641402 432699 437471 467590 463561 504000 518795 513218 784809 397390 425281 474251 645106 812121 559963 656841 600499 757049 699435 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.42%) |
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 49688 70636 118201 189022 301977 325743 382701 383436 384049 389965 390263 390583 391054 397390 401508 401522 403871 410872 417386 417930 418730 421544 423475 424068 425281 425654 427291 428216 429545 432699 437471 441669 445755 448080 449677 450607 451043 458815 461393 463561 464531 464699 465045 466257 467590 469825 469899 469901 470062 472994 474251 479431 480935 483207 485507 486200 488426 490750 497414 500249 504000 504090 506224 506339 508314 510785 513133 513218 517065 518795 521510 521654 522742 524984 526342 526385 527831 528800 535112 537436 544080 545216 552371 559963 561266 569623 585295 586431 600499 607647 629462 633884 641402 645106 656841 662583 666429 668057 680321 683461 688745 699435 722935 733786 737995 753788 757049 769555 778632 779425 780878 781079 784809 786119 787994 793292 797361 802038 803207 812121 ] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена с подружкой и муж"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен подружк жен"
]
|
||||||||||||||||||||||||||||||
|
1.10 ms (0.69%) |
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.