Query Metrics
7
Database Queries
7
Different statements
184.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.03 ms (85.45%) |
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 197345 375092 383281 384298 389014 393442 393524 394768 394931 398354 399223 399332 403555 409317 410402 412539 414601 415093 418869 420382 421513 424534 425430 427179 429319 429609 431566 432524 433441 439431 440087 440646 441601 441864 442372 442802 443038 444386 444848 444974 446138 446210 447641 448274 451671 452425 453991 453993 454121 454569 456060 456085 456209 457296 457600 457808 457962 457967 458057 458082 458609 458927 459379 460070 460598 461667 463536 464502 464710 466892 469093 469703 469862 470995 472566 472577 473649 474567 474711 474763 474836 474871 475797 478261 482001 482594 483010 483994 484231 485646 486137 486310 486949 488561 489327 490692 491597 496750 497044 497466 498051 499476 499497 499932 502010 503758 505353 506460 510045 513658 517468 520060 521402 521413 522502 526972 528683 534493 538034 814841 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (8.92%) |
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 414601 415093 452425 460598 482001 499932 526972 488561 499497 513658 521402 486310 489327 497044 497466 522502 383281 384298 197345 393442 393524 394768 394931 375092 389014 398354 399332 399223 403555 410402 425430 427179 440646 442802 421513 431566 432524 433441 439431 440087 442372 444974 441864 443038 409317 444848 412539 418869 420382 424534 429319 429609 441601 444386 814841 482594 446138 451671 453991 456060 456085 457296 457600 464502 470995 472566 472577 474836 474871 475797 483010 483994 484231 486949 491597 446210 447641 453993 454121 454569 457808 457967 458057 458609 458927 460070 464710 469862 473649 474567 474763 478261 485646 448274 456209 457962 458082 459379 466892 469093 490692 510045 521413 498051 506460 528683 534493 538034 503758 505353 517468 520060 496750 499476 502010 461667 463536 469703 474711 486137 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.31%) |
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 197345 375092 383281 384298 389014 393442 393524 394768 394931 398354 399223 399332 403555 409317 410402 412539 414601 415093 418869 420382 421513 424534 425430 427179 429319 429609 431566 432524 433441 439431 440087 440646 441601 441864 442372 442802 443038 444386 444848 444974 446138 446210 447641 448274 451671 452425 453991 453993 454121 454569 456060 456085 456209 457296 457600 457808 457962 457967 458057 458082 458609 458927 459379 460070 460598 461667 463536 464502 464710 466892 469093 469703 469862 470995 472566 472577 473649 474567 474711 474763 474836 474871 475797 478261 482001 482594 483010 483994 484231 485646 486137 486310 486949 488561 489327 490692 491597 496750 497044 497466 498051 499476 499497 499932 502010 503758 505353 506460 510045 513658 517468 520060 521402 521413 522502 526972 528683 534493 538034 814841 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"прос"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"она просит ещё"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.