Query Metrics
7
Database Queries
7
Different statements
172.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.36 ms (85.54%) |
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 388189 388845 391603 405725 408085 416839 417756 418159 419421 424376 427262 431755 435679 438042 448313 450646 451605 452705 454269 455839 457834 459069 461005 463070 463740 465180 466670 469618 470096 470848 472332 473305 474094 476468 479294 484246 484841 486639 487239 487488 487500 487757 487845 487929 490748 491281 495484 495868 496123 497180 500114 503792 506898 508436 508645 510088 512821 513695 514942 521122 521920 522677 522856 523983 525321 525350 525950 526352 527021 527533 527578 527601 527665 527897 528141 541558 545365 546592 549511 554560 557397 560162 562364 564242 565828 569169 585063 586939 591149 591830 596131 601543 606595 606636 613465 613663 614381 614392 615426 615997 620240 638459 649905 656533 661287 664630 678260 691219 691598 693166 705768 709052 720712 726067 731345 732930 737995 745999 789846 821352 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (8.93%) |
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 522856 419421 448313 527897 554560 549511 560162 678260 720712 693166 664630 691219 709052 546592 557397 564242 586939 591830 638459 596131 613465 614392 613663 620240 606595 614381 615426 731345 745999 726067 737995 705768 527578 484841 523983 821352 503792 508436 514942 500114 541558 562364 591149 601543 527601 470848 435679 452705 491281 473305 486639 527665 497180 528141 466670 474094 691598 649905 545365 606636 789846 416839 521920 487500 490748 391603 388189 418159 417756 585063 463070 487239 470096 522677 527533 495868 527021 525321 525950 526352 495484 508645 525350 487757 569169 565828 656533 661287 615997 732930 454269 459069 463740 455839 457834 431755 450646 451605 465180 479294 405725 438042 461005 487845 487929 506898 484246 510088 512821 513695 487488 496123 521122 427262 476468 472332 388845 408085 424376 469618 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.83%) |
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 388189 388845 391603 405725 408085 416839 417756 418159 419421 424376 427262 431755 435679 438042 448313 450646 451605 452705 454269 455839 457834 459069 461005 463070 463740 465180 466670 469618 470096 470848 472332 473305 474094 476468 479294 484246 484841 486639 487239 487488 487500 487757 487845 487929 490748 491281 495484 495868 496123 497180 500114 503792 506898 508436 508645 510088 512821 513695 514942 521122 521920 522677 522856 523983 525321 525350 525950 526352 527021 527533 527578 527601 527665 527897 528141 541558 545365 546592 549511 554560 557397 560162 562364 564242 565828 569169 585063 586939 591149 591830 596131 601543 606595 606636 613465 613663 614381 614392 615426 615997 620240 638459 649905 656533 661287 664630 678260 691219 691598 693166 705768 709052 720712 726067 731345 732930 737995 745999 789846 821352 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock outdoor"
]
|
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.