Query Metrics
7
Database Queries
7
Different statements
166.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.03 ms (78.29%) |
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 388690 390831 425118 428382 428387 428408 436030 436037 445426 447571 450948 451548 451560 451562 451570 451582 451583 455611 457795 460806 461554 463693 472341 478057 483560 487150 489998 490843 490868 491378 491385 491387 491662 493963 497550 497554 497557 497568 508852 508857 508874 512329 512830 513015 521928 521943 521966 521970 523291 523292 523300 523316 523951 525957 525962 525966 533743 533833 544393 554366 559986 560446 560599 560622 565349 565377 565391 565395 565414 565426 565436 565462 570197 570673 571855 571857 572389 572397 572437 572455 573026 573081 573776 573814 574480 574512 574855 575104 575121 575217 575510 575524 575748 575762 575792 575804 576053 576360 578376 592385 595764 596160 596991 597113 597119 598014 598470 598498 630227 632851 636275 641756 645010 661281 677362 704233 718675 766546 808075 825789 ] |
||||||||||||||||||||||||||||||
|
25.62 ms (15.43%) |
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 560599 570673 572397 573081 575121 575510 544393 565395 565436 570197 573026 677362 554366 560622 571855 571857 572437 572455 574480 574855 575524 598014 598470 592385 597113 636275 641756 766546 808075 630227 704233 447571 451583 428408 450948 451548 451570 455611 436030 460806 461554 463693 451582 521943 491387 491662 497568 508852 508857 508874 523292 523951 490843 491385 513015 523300 523316 525962 497557 425118 487150 445426 825789 489998 661281 595764 472341 428387 523291 598498 632851 645010 533743 533833 565349 565391 572389 575762 575804 559986 573776 576360 578376 560446 565462 574512 575104 575748 575792 565377 565414 565426 573814 575217 576053 596160 596991 718675 388690 451560 451562 436037 457795 390831 428382 478057 512329 521966 483560 490868 521928 521970 525957 525966 491378 497550 512830 497554 597119 493963 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.81%) |
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 388690 390831 425118 428382 428387 428408 436030 436037 445426 447571 450948 451548 451560 451562 451570 451582 451583 455611 457795 460806 461554 463693 472341 478057 483560 487150 489998 490843 490868 491378 491385 491387 491662 493963 497550 497554 497557 497568 508852 508857 508874 512329 512830 513015 521928 521943 521966 521970 523291 523292 523300 523316 523951 525957 525962 525966 533743 533833 544393 554366 559986 560446 560599 560622 565349 565377 565391 565395 565414 565426 565436 565462 570197 570673 571855 571857 572389 572397 572437 572455 573026 573081 573776 573814 574480 574512 574855 575104 575121 575217 575510 575524 575748 575762 575792 575804 576053 576360 578376 592385 595764 596160 596991 597113 597119 598014 598470 598498 630227 632851 636275 641756 645010 661281 677362 704233 718675 766546 808075 825789 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian and bbc"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск bbc"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск bbc"
]
|
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.