Query Metrics
7
Database Queries
7
Different statements
154.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.34 ms (81.65%) |
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 182895 183036 209216 383500 383571 392422 394648 398123 401642 402648 409909 414119 416656 417430 418135 421971 424606 428308 428773 429044 429566 429601 430369 430372 432963 434104 434327 434330 434332 434345 434350 435343 435395 435407 437791 440639 440641 443250 444540 450262 452576 452729 452807 453204 453997 455914 457812 457814 458676 458772 460382 460384 466360 468163 468244 468255 468813 468818 469046 469086 469125 469139 469162 469176 469734 471686 473873 475319 475425 476051 476198 476670 476710 478519 479723 479727 480357 481961 486244 486768 486783 493838 494492 498200 499923 502770 502772 502774 502780 503427 509776 509984 509996 510001 511277 516028 517034 518892 523063 531185 545677 564040 564170 569728 570115 571043 574192 588846 593053 596402 623277 630470 651700 704334 717620 720160 727935 782825 807562 807568 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (11.50%) |
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 452729 469162 460382 476198 476710 499923 531185 469086 545677 571043 651700 704334 569728 593053 623277 630470 596402 782825 807568 383500 401642 468163 457814 432963 469139 480357 437791 458676 468244 469734 498200 517034 502780 510001 383571 209216 182895 183036 394648 392422 398123 402648 416656 418135 435395 444540 434104 428308 429566 429601 453997 457812 466360 476670 479723 486244 452576 469176 450262 452807 475425 502770 502774 503427 509776 509996 469046 486768 564040 570115 574192 717620 720160 564170 588846 807562 727935 434332 453204 460384 468255 468813 469125 421971 440641 471686 476051 479727 428773 458772 468818 473873 475319 429044 430372 434327 478519 481961 502772 523063 511277 493838 509984 486783 516028 518892 494492 414119 417430 430369 435343 424606 434345 443250 409909 434330 434350 435407 440639 455914 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.01%) |
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 182895 183036 209216 383500 383571 392422 394648 398123 401642 402648 409909 414119 416656 417430 418135 421971 424606 428308 428773 429044 429566 429601 430369 430372 432963 434104 434327 434330 434332 434345 434350 435343 435395 435407 437791 440639 440641 443250 444540 450262 452576 452729 452807 453204 453997 455914 457812 457814 458676 458772 460382 460384 466360 468163 468244 468255 468813 468818 469046 469086 469125 469139 469162 469176 469734 471686 473873 475319 475425 476051 476198 476670 476710 478519 479723 479727 480357 481961 486244 486768 486783 493838 494492 498200 499923 502770 502772 502774 502780 503427 509776 509984 509996 510001 511277 516028 517034 518892 523063 531185 545677 564040 564170 569728 570115 571043 574192 588846 593053 596402 623277 630470 651700 704334 717620 720160 727935 782825 807562 807568 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
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.