Query Metrics
7
Database Queries
7
Different statements
172.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.32 ms (86.80%) |
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 69956 388883 412619 428373 433072 436526 458781 476391 479183 482052 485995 494257 494518 495117 496465 498892 502298 504048 507114 507442 507645 508207 508210 508322 510223 510878 514064 522437 524820 524824 528238 528497 528515 529503 529664 532417 534180 538795 540347 540805 541521 544310 549516 552536 554152 555036 555194 555223 555661 555725 555777 556669 557831 562492 562645 563274 566025 571047 571817 573506 574380 574415 574626 576210 576575 577627 579420 581146 581209 584170 585124 585193 587967 588415 589412 590459 593101 595051 595224 595378 595666 597217 598085 599487 602505 602511 607044 609577 610974 612301 613907 616947 617968 622701 628526 630080 633185 637313 639164 643991 650282 653688 660346 666669 667469 676664 682409 686965 689798 697182 707175 708050 727326 762223 783839 784911 789544 805733 813192 ] |
||||||||||||||||||||||||||||||
|
12.39 ms (7.20%) |
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 412619 436526 485995 482052 479183 494257 507645 508207 508210 528515 529503 534180 495117 496465 498892 502298 510223 514064 524820 524824 538795 494518 504048 507114 510878 528238 529664 532417 507442 528497 540347 554152 555725 571817 581146 584170 544310 549516 552536 555661 562492 562645 574415 579420 581209 541521 555223 555777 574626 576575 577627 650282 653688 666669 676664 660346 667469 682409 686965 689798 697182 707175 708050 555036 555194 556669 557831 563274 566025 571047 573506 574380 576210 595051 598085 617968 629530 633185 637313 585193 588415 589412 590459 595666 597217 599487 602505 609577 628526 595378 602511 610974 616947 622701 587967 593101 595224 607044 612301 613907 643991 784911 789544 762223 805733 727326 630080 639164 783839 813192 388883 69956 476391 508322 522437 428373 433072 585124 540805 458781 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.78%) |
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 69956 388883 412619 428373 433072 436526 458781 476391 479183 482052 485995 494257 494518 495117 496465 498892 502298 504048 507114 507442 507645 508207 508210 508322 510223 510878 514064 522437 524820 524824 528238 528497 528515 529503 529664 532417 534180 538795 540347 540805 541521 544310 549516 552536 554152 555036 555194 555223 555661 555725 555777 556669 557831 562492 562645 563274 566025 571047 571817 573506 574380 574415 574626 576210 576575 577627 579420 581146 581209 584170 585124 585193 587967 588415 589412 590459 593101 595051 595224 595378 595666 597217 598085 599487 602505 602511 607044 609577 610974 612301 613907 616947 617968 622701 628526 630080 633185 637313 639164 643991 650282 653688 660346 666669 667469 676664 682409 686965 689798 697182 707175 708050 727326 762223 783839 784911 789544 805733 813192 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"конч"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
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.