Query Metrics
7
Database Queries
7
Different statements
147.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.45 ms (80.52%) |
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 33562 382881 383249 388873 397832 412091 412603 413029 419632 424174 428537 432717 433956 434883 436868 437174 449676 452277 452736 454371 455012 456732 456734 456849 457311 457505 457523 458192 458661 458680 459036 459256 459329 461186 462655 463404 465691 466548 466873 467289 468349 468373 468375 468984 470579 470916 472008 473296 477565 477774 478830 480275 480855 482193 482200 483182 483258 483262 484159 484352 484753 485255 487019 487371 488433 490648 491584 492169 494553 495111 495458 496357 496422 496687 499210 499877 500639 501524 503757 503977 504044 504114 505436 507779 507833 508808 509006 511625 513405 513457 513493 513931 517584 517607 518164 518630 518642 518882 518952 520790 521770 522021 524835 526416 528332 530112 531426 533527 533690 535402 537262 538100 538864 543257 543384 567544 571753 639669 708876 745325 ] |
||||||||||||||||||||||||||||||
|
18.53 ms (12.60%) |
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 458661 477565 483258 480275 495111 513493 518642 708876 383249 508808 518164 483262 490648 504114 518630 382881 466873 388873 397832 434883 413029 452736 456849 459329 484159 457505 484352 504044 513457 530112 494553 500639 503977 507779 511625 518952 535402 499210 538100 538864 503757 509006 518882 533527 482200 567544 571753 745325 454371 433956 412091 495458 528332 487371 543257 492169 452277 483182 496422 499877 467289 424174 501524 496357 513931 522021 33562 428537 412603 432717 437174 458192 458680 459256 470579 455012 465691 488433 457311 459036 466548 468349 468373 478830 484753 485255 487019 491584 505436 517584 520790 537262 533690 507833 526416 496687 513405 517607 521770 524835 531426 461186 463404 468375 482193 543384 639669 419632 449676 456732 462655 473296 480855 457523 468984 470916 477774 436868 456734 472008 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.91%) |
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 33562 382881 383249 388873 397832 412091 412603 413029 419632 424174 428537 432717 433956 434883 436868 437174 449676 452277 452736 454371 455012 456732 456734 456849 457311 457505 457523 458192 458661 458680 459036 459256 459329 461186 462655 463404 465691 466548 466873 467289 468349 468373 468375 468984 470579 470916 472008 473296 477565 477774 478830 480275 480855 482193 482200 483182 483258 483262 484159 484352 484753 485255 487019 487371 488433 490648 491584 492169 494553 495111 495458 496357 496422 496687 499210 499877 500639 501524 503757 503977 504044 504114 505436 507779 507833 508808 509006 511625 513405 513457 513493 513931 517584 517607 518164 518630 518642 518882 518952 520790 521770 522021 524835 526416 528332 530112 531426 533527 533690 535402 537262 538100 538864 543257 543384 567544 571753 639669 708876 745325 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white wife with"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white жен"
]
|
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.