Query Metrics
7
Database Queries
7
Different statements
192.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.30 ms (85.27%) |
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 7615 389563 389726 395702 398027 399522 407424 407783 408313 408411 408412 411787 414068 417899 422982 426268 427199 447400 447982 451089 458592 459581 459919 460120 460600 461487 461547 462361 462370 463243 463246 463621 464944 466165 468044 472276 473415 475198 478235 478542 483549 484410 487380 494151 500299 500462 500463 500464 500493 500498 500503 500508 506783 508572 511336 512955 513274 515841 516562 516813 518052 519306 520037 520433 521459 522481 525781 527630 528647 529245 529343 529548 532005 537508 548651 550839 551044 551059 553274 557437 560760 561415 564099 580797 581221 581761 584565 586529 593833 596228 601339 602001 603004 612439 616328 620264 622710 630576 636732 672414 674384 675019 676179 684560 709215 720840 723352 737922 752158 752644 752820 754224 758268 760957 780517 783992 792648 800030 809476 820529 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (8.95%) |
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 407783 518052 447982 500462 557437 584565 758268 7615 462361 529245 462370 551044 672414 752820 399522 506783 463246 560760 426268 487380 408411 820529 676179 548651 580797 586529 709215 422982 461487 581761 550839 630576 737922 783992 463621 478235 527630 500498 537508 636732 800030 754224 389726 461547 513274 522481 473415 752644 451089 407424 760957 395702 398027 684560 720840 780517 809476 528647 792648 551059 414068 417899 525781 408313 500464 512955 472276 460600 500508 561415 601339 516562 521459 459581 463243 389563 519306 508572 515841 532005 596228 723352 494151 460120 593833 520433 616328 483549 458592 529548 475198 612439 620264 466165 408412 427199 500493 459919 564099 602001 622710 603004 500463 464944 581221 674384 500299 516813 478542 675019 752158 511336 553274 484410 500503 468044 520037 411787 529343 447400 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.93%) |
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 7615 389563 389726 395702 398027 399522 407424 407783 408313 408411 408412 411787 414068 417899 422982 426268 427199 447400 447982 451089 458592 459581 459919 460120 460600 461487 461547 462361 462370 463243 463246 463621 464944 466165 468044 472276 473415 475198 478235 478542 483549 484410 487380 494151 500299 500462 500463 500464 500493 500498 500503 500508 506783 508572 511336 512955 513274 515841 516562 516813 518052 519306 520037 520433 521459 522481 525781 527630 528647 529245 529343 529548 532005 537508 548651 550839 551044 551059 553274 557437 560760 561415 564099 580797 581221 581761 584565 586529 593833 596228 601339 602001 603004 612439 616328 620264 622710 630576 636732 672414 674384 675019 676179 684560 709215 720840 723352 737922 752158 752644 752820 754224 758268 760957 780517 783992 792648 800030 809476 820529 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fantasy sex"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fantasy секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fantasy секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
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.