Query Metrics
7
Database Queries
7
Different statements
226.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.45 ms (85.95%) |
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 402724 411227 419860 421566 422515 425878 429810 431133 432131 438424 439529 439777 442830 443323 443550 444588 445047 447810 448034 448046 448798 449320 450836 451572 451804 453329 454658 456418 456690 458718 460969 462504 463783 465933 469530 470222 471626 472125 474827 477867 478066 480719 481173 482270 484461 485708 487087 490896 490933 490996 494516 496086 497332 500180 500375 500430 501426 504139 505398 506081 509454 510843 514149 514746 514820 516683 516763 516770 516776 516989 518917 519903 520573 521173 521206 521581 521909 522460 523317 524029 525339 529343 531425 532357 532753 532762 533949 534334 534376 535025 537247 540071 540338 540562 542059 542568 550093 560198 560209 560664 561110 562776 563223 564205 565149 567109 567848 577356 579391 595769 600312 600382 622975 638991 644025 644973 650992 714119 720387 799936 ] |
||||||||||||||||||||||||||||||
|
21.73 ms (9.61%) |
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 560198 542059 565149 714119 720387 600382 595769 465933 463783 470222 429810 448046 431133 449320 460969 481173 516683 516770 497332 514149 514746 484461 487087 501426 490896 504139 411227 422515 445047 644973 454658 462504 533949 500180 510843 516989 518917 521206 496086 509454 516776 521173 525339 469530 550093 579391 560664 560209 564205 638991 448798 439777 448034 451804 419860 402724 443550 451572 490996 522460 485708 500375 506081 490933 494516 458718 478066 532753 534334 537247 540562 540338 516763 529343 519903 540071 567848 650992 600312 644025 425878 439529 438424 524029 500430 505398 477867 534376 442830 471626 480719 514820 535025 531425 532762 563223 562776 561110 567109 622975 799936 432131 482270 450836 456690 444588 421566 453329 474827 521581 521909 520573 523317 456418 443323 447810 472125 532357 577356 542568 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.31%) |
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 402724 411227 419860 421566 422515 425878 429810 431133 432131 438424 439529 439777 442830 443323 443550 444588 445047 447810 448034 448046 448798 449320 450836 451572 451804 453329 454658 456418 456690 458718 460969 462504 463783 465933 469530 470222 471626 472125 474827 477867 478066 480719 481173 482270 484461 485708 487087 490896 490933 490996 494516 496086 497332 500180 500375 500430 501426 504139 505398 506081 509454 510843 514149 514746 514820 516683 516763 516770 516776 516989 518917 519903 520573 521173 521206 521581 521909 522460 523317 524029 525339 529343 531425 532357 532753 532762 533949 534334 534376 535025 537247 540071 540338 540562 542059 542568 550093 560198 560209 560664 561110 562776 563223 564205 565149 567109 567848 577356 579391 595769 600312 600382 622975 638991 644025 644973 650992 714119 720387 799936 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting domina"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.71%) |
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.