Query Metrics
7
Database Queries
7
Different statements
162.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.20 ms (84.07%) |
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 412091 412603 413029 419632 424174 428537 432717 433956 436868 437174 449676 452277 452736 454371 455012 456732 456734 456849 457311 457505 457523 458192 458680 459036 459256 459329 461186 462655 463404 465691 466548 467289 468349 468373 468375 468984 470579 470916 472008 472075 473296 477774 478830 480855 482193 482200 482857 483182 483277 484159 484352 484753 485255 487019 487371 487710 488433 491584 492169 494553 494818 495458 496357 496422 496687 497077 497493 499210 499877 500639 501524 503011 503500 503547 503757 503977 504044 505436 505850 507779 507833 509006 509052 511625 513405 513457 513931 515586 517584 517607 518882 518926 518952 520398 520790 521770 522021 524835 525775 526416 528332 530112 530166 531426 533527 533690 535402 537262 538100 538864 543257 543384 567544 571753 601198 639669 656117 745325 745959 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (9.50%) |
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 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 601198 745959 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 656117 639669 419632 449676 456732 462655 473296 480855 457523 468984 470916 477774 436868 456734 472008 472075 487710 503500 518926 482857 483277 494818 497077 497493 503547 525775 530166 503011 505850 509052 515586 520398 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.73%) |
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 412091 412603 413029 419632 424174 428537 432717 433956 436868 437174 449676 452277 452736 454371 455012 456732 456734 456849 457311 457505 457523 458192 458680 459036 459256 459329 461186 462655 463404 465691 466548 467289 468349 468373 468375 468984 470579 470916 472008 472075 473296 477774 478830 480855 482193 482200 482857 483182 483277 484159 484352 484753 485255 487019 487371 487710 488433 491584 492169 494553 494818 495458 496357 496422 496687 497077 497493 499210 499877 500639 501524 503011 503500 503547 503757 503977 504044 505436 505850 507779 507833 509006 509052 511625 513405 513457 513931 515586 517584 517607 518882 518926 518952 520398 520790 521770 522021 524835 525775 526416 528332 530112 530166 531426 533527 533690 535402 537262 538100 538864 543257 543384 567544 571753 601198 639669 656117 745325 745959 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife white"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен white"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.