Query Metrics
7
Database Queries
7
Different statements
232.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.39 ms (88.73%) |
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 36832 68560 95986 119788 178441 278442 346210 382266 382450 383347 386747 386954 388006 391858 392672 393399 393508 397265 399514 399595 400167 401095 401213 402536 405716 407320 413110 414785 417822 417874 418069 419176 420403 429179 436391 439112 442280 448119 452400 454314 458034 459363 459938 461580 461615 462805 462961 464190 465545 465961 466314 466863 467616 468813 470518 472773 474295 474393 479439 480947 481668 483197 483306 485657 487010 488452 490365 491623 492906 493813 495547 496687 500987 505737 505902 508994 510001 510521 511884 511923 521440 524515 524541 524606 525808 527490 541541 542658 543173 543529 546022 547878 549865 551637 555017 557869 558117 565543 568626 568631 570044 573713 574877 574885 574890 575083 575202 575208 582346 582583 584535 588208 589304 597017 601392 602337 602618 611465 677356 787504 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (6.40%) |
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 483306 500987 483197 488452 508994 510001 386747 399514 405716 419176 417822 461615 485657 493813 474393 462961 491623 505737 496687 466863 570044 573713 574885 575083 584535 558117 568631 575202 541541 542658 549865 568626 582346 588208 601392 787504 602337 382266 383347 420403 464190 465545 468813 480947 36832 68560 278442 397265 392672 402536 462805 178441 346210 388006 391858 454314 458034 414785 459938 505902 510521 524541 511884 521440 524515 492906 487010 495547 511923 527490 95986 119788 393508 386954 399595 436391 442280 417874 448119 452400 479439 459363 467616 524606 525808 465961 466314 474295 490365 551637 575208 582583 543173 555017 574877 574890 543529 546022 547878 565543 677356 557869 589304 602618 597017 611465 382450 393399 413110 470518 400167 401095 401213 407320 429179 472773 481668 439112 418069 461580 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (1.79%) |
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 36832 68560 95986 119788 178441 278442 346210 382266 382450 383347 386747 386954 388006 391858 392672 393399 393508 397265 399514 399595 400167 401095 401213 402536 405716 407320 413110 414785 417822 417874 418069 419176 420403 429179 436391 439112 442280 448119 452400 454314 458034 459363 459938 461580 461615 462805 462961 464190 465545 465961 466314 466863 467616 468813 470518 472773 474295 474393 479439 480947 481668 483197 483306 485657 487010 488452 490365 491623 492906 493813 495547 496687 500987 505737 505902 508994 510001 510521 511884 511923 521440 524515 524541 524606 525808 527490 541541 542658 543173 543529 546022 547878 549865 551637 555017 557869 558117 565543 568626 568631 570044 573713 574877 574885 574890 575083 575202 575208 582346 582583 584535 588208 589304 597017 601392 602337 602618 611465 677356 787504 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кайф"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кайф"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"под кайфо"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
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.