Query Metrics
7
Database Queries
7
Different statements
234.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.48 ms (89.95%) |
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 7157 184943 185011 185123 204992 382396 383005 385096 386331 389356 389518 390190 390258 390304 391064 399627 401489 404737 406435 407549 409305 415934 419115 437437 446791 447488 454044 454974 456184 456579 463867 464195 464474 465886 481652 487346 489410 490070 493031 493814 501750 502006 503994 506795 507171 510033 510041 518767 518948 520417 521918 523971 531416 531725 538343 538675 543791 551340 551405 551409 551432 551741 558383 560101 562881 568363 569827 572013 575118 583633 585254 598301 599327 608595 610226 643436 643535 651930 651932 652206 653497 662333 663050 663957 671703 677030 689591 696102 703506 707346 712462 714471 721200 723077 726511 727717 732379 744469 744601 744631 747347 748663 750782 753784 781022 784702 797499 800069 800296 802737 805961 808650 810031 814806 815691 818725 825210 826902 828466 828714 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (6.13%) |
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 723077 714471 797499 732379 781022 800069 385096 386331 456184 507171 531725 390258 456579 551741 562881 726511 399627 401489 406435 454974 481652 506795 510041 503994 828466 663050 464195 184943 7157 389518 599327 608595 404737 464474 818725 677030 643436 390190 185011 583633 651930 663957 703506 712462 652206 653497 551405 800296 805961 784702 748663 744469 744631 810031 419115 826902 707346 721200 747347 825210 815691 828714 753784 531416 407549 502006 493031 572013 560101 671703 689591 585254 802737 447488 391064 185123 389356 415934 501750 538343 493814 521918 523971 814806 454044 465886 558383 543791 551409 696102 610226 808650 750782 744601 390304 437437 446791 538675 518767 510033 520417 489410 382396 518948 463867 487346 490070 662333 651932 643535 568363 569827 598301 727717 383005 409305 204992 551432 575118 551340 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.12%) |
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 7157 184943 185011 185123 204992 382396 383005 385096 386331 389356 389518 390190 390258 390304 391064 399627 401489 404737 406435 407549 409305 415934 419115 437437 446791 447488 454044 454974 456184 456579 463867 464195 464474 465886 481652 487346 489410 490070 493031 493814 501750 502006 503994 506795 507171 510033 510041 518767 518948 520417 521918 523971 531416 531725 538343 538675 543791 551340 551405 551409 551432 551741 558383 560101 562881 568363 569827 572013 575118 583633 585254 598301 599327 608595 610226 643436 643535 651930 651932 652206 653497 662333 663050 663957 671703 677030 689591 696102 703506 707346 712462 714471 721200 723077 726511 727717 732379 744469 744601 744631 747347 748663 750782 753784 781022 784702 797499 800069 800296 802737 805961 808650 810031 814806 815691 818725 825210 826902 828466 828714 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.54%) |
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.