Query Metrics
7
Database Queries
7
Different statements
163.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.29 ms (88.03%) |
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 129748 407681 427361 435743 461139 465289 488385 489011 489266 489327 490638 492968 499751 500700 501408 504009 504018 506711 507214 514945 521598 523294 524233 525187 526327 528280 529467 529927 530193 534974 538492 539349 540396 540719 541015 541127 541536 542244 543931 544619 545023 545738 548373 548421 549572 555482 555700 557836 558320 562971 568021 571953 574950 577568 577663 578181 578521 579576 579873 580652 581654 582401 584110 584361 585873 588416 591561 591945 593389 595182 595224 598349 598362 599422 601038 605454 605598 606276 609042 609998 611418 616661 618208 619358 625217 626545 627326 628141 628630 628901 630718 644201 645132 645706 649056 654465 662584 662826 671936 674041 678593 681797 684504 684555 686079 706693 721230 725227 733946 743952 759694 761305 763996 770965 773928 779216 785299 790319 793657 805341 ] |
||||||||||||||||||||||||||||||
|
11.19 ms (6.83%) |
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 580652 595224 504009 555482 628901 605454 645706 684504 544619 558320 574950 628630 562971 492968 545023 585873 785299 555700 662584 678593 684555 706693 611418 618208 779216 793657 805341 725227 733946 761305 763996 759694 770965 407681 541536 542244 630718 129748 489266 523294 584110 548373 568021 681797 625217 488385 499751 540396 530193 529467 686079 601038 773928 490638 541015 609042 598362 595182 605598 627326 514945 529927 616661 524233 581654 582401 649056 721230 790319 557836 578521 671936 743952 579576 427361 465289 674041 489327 528280 662826 507214 598349 521598 628141 501408 654465 591945 500700 489011 534974 571953 619358 545738 435743 591561 525187 539349 504018 538492 577663 584361 577568 579873 609998 644201 593389 626545 543931 506711 549572 588416 526327 645132 578181 599422 540719 548421 606276 461139 541127 ] |
||||||||||||||||||||||||||||||
|
2.44 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 129748 407681 427361 435743 461139 465289 488385 489011 489266 489327 490638 492968 499751 500700 501408 504009 504018 506711 507214 514945 521598 523294 524233 525187 526327 528280 529467 529927 530193 534974 538492 539349 540396 540719 541015 541127 541536 542244 543931 544619 545023 545738 548373 548421 549572 555482 555700 557836 558320 562971 568021 571953 574950 577568 577663 578181 578521 579576 579873 580652 581654 582401 584110 584361 585873 588416 591561 591945 593389 595182 595224 598349 598362 599422 601038 605454 605598 606276 609042 609998 611418 616661 618208 619358 625217 626545 627326 628141 628630 628901 630718 644201 645132 645706 649056 654465 662584 662826 671936 674041 678593 681797 684504 684555 686079 706693 721230 725227 733946 743952 759694 761305 763996 770965 773928 779216 785299 790319 793657 805341 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"спермы в киске"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.