Query Metrics
7
Database Queries
7
Different statements
171.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.17 ms (85.69%) |
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 6710 27593 30454 39030 75979 263299 305626 352045 362588 382777 383737 384033 384880 385347 386060 386846 389496 389728 397679 400423 400435 400443 400471 403210 404117 404415 409901 413208 415862 416870 418641 418647 421249 422227 424984 429216 429592 435727 446456 448697 450485 453668 454045 454750 456280 456398 456802 456858 457803 457806 457828 458601 460173 460459 460856 462363 463298 464315 464317 467296 468475 470732 470855 476266 476951 482080 485457 487621 500689 502062 509396 515120 515215 516891 518285 519270 526775 536894 545519 547959 549765 557272 561725 563169 563216 564086 565863 567605 568327 576020 584244 592501 596915 599586 606277 612751 617435 621418 623209 635228 641439 665180 682510 684574 697296 730261 732486 741980 742035 745012 751245 770980 785003 790966 800070 806045 811814 812137 821026 827975 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (8.94%) |
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 545519 563216 567605 612751 596915 463298 482080 435727 526775 389728 409901 429216 827975 460173 454045 468475 561725 564086 684574 665180 682510 697296 606277 635228 592501 621418 785003 800070 742035 806045 811814 730261 741980 770980 745012 732486 617435 623209 790966 812137 389496 422227 404117 456280 460856 457803 457806 476266 397679 450485 457828 500689 487621 568327 599586 75979 385347 27593 641439 751245 386846 386060 383737 384033 382777 384880 263299 305626 352045 362588 30454 39030 6710 400435 400443 400471 400423 403210 404415 418647 421249 418641 429592 415862 416870 424984 413208 821026 446456 453668 456858 458601 470732 448697 454750 456398 456802 462363 476951 464315 464317 467296 470855 509396 515215 518285 519270 502062 515120 536894 516891 460459 485457 547959 549765 557272 565863 584244 576020 563169 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.49%) |
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 6710 27593 30454 39030 75979 263299 305626 352045 362588 382777 383737 384033 384880 385347 386060 386846 389496 389728 397679 400423 400435 400443 400471 403210 404117 404415 409901 413208 415862 416870 418641 418647 421249 422227 424984 429216 429592 435727 446456 448697 450485 453668 454045 454750 456280 456398 456802 456858 457803 457806 457828 458601 460173 460459 460856 462363 463298 464315 464317 467296 468475 470732 470855 476266 476951 482080 485457 487621 500689 502062 509396 515120 515215 516891 518285 519270 526775 536894 545519 547959 549765 557272 561725 563169 563216 564086 565863 567605 568327 576020 584244 592501 596915 599586 606277 612751 617435 621418 623209 635228 641439 665180 682510 684574 697296 730261 732486 741980 742035 745012 751245 770980 785003 790966 800070 806045 811814 812137 821026 827975 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man with pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин pussy"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин pussy"
]
|
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.