Query Metrics
7
Database Queries
7
Different statements
202.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.52 ms (87.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 411811 411845 411846 432766 445726 447516 450840 451989 453150 454241 456721 457645 459128 460205 460479 460600 463834 464124 464608 464612 465641 466209 466840 466954 467047 468282 471678 471786 472152 474835 476283 477957 480390 480397 480406 482319 482780 482795 486179 486406 486478 486883 487708 488619 489272 497007 497421 497891 499805 501230 504029 506772 506787 512518 516021 516886 519184 523418 524227 525236 526254 527183 527779 530769 536230 536291 540484 541599 542209 556806 565270 568189 569162 571133 589551 591867 591902 596075 596156 599851 599882 600083 600444 604100 607507 611530 619652 620310 623335 629962 630053 634528 638346 642075 649131 650312 665114 666591 670349 673767 681666 688672 700851 714256 714743 717720 717780 718974 720117 723461 725520 729835 732243 734486 736412 743040 758191 759960 784249 801396 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (8.48%) |
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 542209 670349 649131 688672 591902 759960 460205 504029 569162 650312 665114 673767 718974 607507 600083 600444 623335 736412 743040 734486 634528 714256 720117 784249 411811 464612 556806 591867 465641 599882 729835 450840 717720 611530 758191 471678 604100 432766 447516 471786 497421 486883 411846 454241 489272 516886 486478 482795 526254 457645 466954 474835 460600 482780 488619 497891 536291 512518 523418 527779 541599 565270 571133 568189 666591 714743 629962 599851 732243 477957 463834 466840 451989 453150 480397 486406 501230 527183 460479 486179 411845 464608 540484 466209 525236 487708 480390 524227 700851 589551 506787 468282 456721 467047 472152 476283 506772 464124 596075 630053 482319 459128 480406 499805 516021 530769 536230 681666 723461 596156 638346 619652 642075 801396 725520 620310 717780 445726 497007 519184 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.27%) |
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 411811 411845 411846 432766 445726 447516 450840 451989 453150 454241 456721 457645 459128 460205 460479 460600 463834 464124 464608 464612 465641 466209 466840 466954 467047 468282 471678 471786 472152 474835 476283 477957 480390 480397 480406 482319 482780 482795 486179 486406 486478 486883 487708 488619 489272 497007 497421 497891 499805 501230 504029 506772 506787 512518 516021 516886 519184 523418 524227 525236 526254 527183 527779 530769 536230 536291 540484 541599 542209 556806 565270 568189 569162 571133 589551 591867 591902 596075 596156 599851 599882 600083 600444 604100 607507 611530 619652 620310 623335 629962 630053 634528 638346 642075 649131 650312 665114 666591 670349 673767 681666 688672 700851 714256 714743 717720 717780 718974 720117 723461 725520 729835 732243 734486 736412 743040 758191 759960 784249 801396 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature кастинг жоп"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature casting ass"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature кастинг жоп"
]
|
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.