Query Metrics
7
Database Queries
7
Different statements
171.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.67 ms (86.79%) |
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 118298 389775 390159 422324 429961 440045 440068 440076 440739 441068 441106 441107 441108 441952 443152 449144 457698 459200 459201 471687 481169 481903 487270 487422 487429 488753 505382 511923 512078 512357 514234 514863 514868 515965 517690 519312 519374 520767 524799 530481 531869 534552 534578 536463 537861 538990 547465 547501 547849 550816 550949 551987 554820 554857 555000 555415 563943 568268 568529 573193 573206 573207 575369 576438 579457 580190 580207 583698 584048 584367 592926 596428 602283 602832 616168 625250 627514 639023 639381 643187 643191 651963 656886 656895 658784 661036 662061 665972 666988 668677 669007 669030 671002 672850 684706 705466 709559 715790 725121 729800 735124 744427 750641 752597 752631 753217 757883 765822 788181 788580 790136 791772 792736 792747 796887 800930 801625 801628 812332 819861 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (7.98%) |
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 440045 441108 488753 449144 538990 554857 554820 555415 568529 579457 672850 602832 796887 812332 725121 752597 765822 459200 750641 429961 788580 551987 517690 819861 584048 709559 639381 643187 651963 790136 744427 440076 471687 658784 662061 665972 639023 791772 512357 487270 514868 519374 573207 669030 625250 715790 441952 389775 735124 583698 505382 514863 441068 440068 515965 575369 666988 668677 602283 800930 801628 481169 580207 592926 519312 520767 596428 661036 118298 537861 547849 511923 757883 584367 643191 550949 441106 457698 481903 671002 656895 705466 729800 792736 801625 440739 512078 563943 555000 669007 550816 390159 573206 580190 788181 530481 487422 524799 616168 627514 792747 752631 753217 441107 422324 443152 487429 459201 536463 534552 534578 514234 531869 547465 547501 568268 573193 576438 656886 684706 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.79%) |
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 118298 389775 390159 422324 429961 440045 440068 440076 440739 441068 441106 441107 441108 441952 443152 449144 457698 459200 459201 471687 481169 481903 487270 487422 487429 488753 505382 511923 512078 512357 514234 514863 514868 515965 517690 519312 519374 520767 524799 530481 531869 534552 534578 536463 537861 538990 547465 547501 547849 550816 550949 551987 554820 554857 555000 555415 563943 568268 568529 573193 573206 573207 575369 576438 579457 580190 580207 583698 584048 584367 592926 596428 602283 602832 616168 625250 627514 639023 639381 643187 643191 651963 656886 656895 658784 661036 662061 665972 666988 668677 669007 669030 671002 672850 684706 705466 709559 715790 725121 729800 735124 744427 750641 752597 752631 753217 757883 765822 788181 788580 790136 791772 792736 792747 796887 800930 801625 801628 812332 819861 ] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade fisting wife"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.