Query Metrics
7
Database Queries
7
Different statements
194.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.92 ms (87.98%) |
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 149429 230821 351473 387467 387868 389060 389789 391820 397904 399475 399518 402341 417836 418563 418564 418569 420327 420834 423901 423907 426485 427050 427487 428682 429311 429492 431512 437705 440737 441197 442027 443852 452062 453853 453865 456185 456188 456201 456280 457713 459030 461475 462261 466337 466761 471966 472298 474203 474923 474985 477420 478103 482590 483306 484159 485046 486488 487176 490118 490158 492668 494543 494574 494578 495173 495188 495856 500182 502726 504262 504767 507150 507171 507846 511186 516743 516751 523136 526492 528681 534370 534486 540151 541900 545871 546653 547056 547126 548752 550477 551534 555646 557973 559090 559609 568283 569431 569815 570687 668467 671312 673572 693714 696486 700770 702375 730829 741559 748920 752530 773466 789232 790088 805628 818762 825093 828056 828087 828336 828632 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (7.09%) |
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 149429 490118 502726 426485 428682 526492 569431 456185 828056 570687 541900 546653 741559 773466 484159 534370 474203 471966 504262 507171 495188 507846 389060 442027 482590 504767 490158 423907 495856 789232 568283 389789 429311 555646 752530 702375 387868 391820 427050 494574 420327 495173 456280 440737 507150 528681 453853 472298 399475 461475 456201 540151 417836 441197 466761 423901 420834 483306 548752 557973 418563 429492 500182 671312 673572 748920 459030 462261 516751 492668 494578 487176 818762 825093 828087 828336 387467 790088 474923 427487 402341 474985 478103 547056 545871 696486 730829 230821 418569 457713 494543 551534 534486 437705 550477 700770 668467 523136 486488 351473 559609 456188 431512 443852 559090 453865 477420 397904 466337 516743 485046 828632 569815 547126 693714 805628 399518 418564 452062 511186 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.59%) |
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 149429 230821 351473 387467 387868 389060 389789 391820 397904 399475 399518 402341 417836 418563 418564 418569 420327 420834 423901 423907 426485 427050 427487 428682 429311 429492 431512 437705 440737 441197 442027 443852 452062 453853 453865 456185 456188 456201 456280 457713 459030 461475 462261 466337 466761 471966 472298 474203 474923 474985 477420 478103 482590 483306 484159 485046 486488 487176 490118 490158 492668 494543 494574 494578 495173 495188 495856 500182 502726 504262 504767 507150 507171 507846 511186 516743 516751 523136 526492 528681 534370 534486 540151 541900 545871 546653 547056 547126 548752 550477 551534 555646 557973 559090 559609 568283 569431 569815 570687 668467 671312 673572 693714 696486 700770 702375 730829 741559 748920 752530 773466 789232 790088 805628 818762 825093 828056 828087 828336 828632 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden sex"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт секс"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.