Query Metrics
7
Database Queries
7
Different statements
236.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.27 ms (89.19%) |
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 392952 417471 434767 449541 459629 465720 480889 481216 485723 487934 489305 493779 495572 497752 499536 500959 503504 507092 509167 514041 514304 517083 520115 520274 520301 521940 522300 522721 526959 532318 534341 537452 539473 540587 543080 543171 543764 544047 545189 545211 546054 546335 546552 546905 547813 554403 556199 557772 559015 559621 561300 561580 561864 562974 563274 563301 565784 566948 567646 567947 570838 570975 571338 571727 574975 576134 576654 577514 578108 578551 578569 579223 579443 580126 580662 582031 585719 587118 587523 588024 588381 588679 588941 590673 590937 591185 592429 592686 594442 596409 596416 599710 600747 601300 602457 602714 604924 606514 608415 614381 616551 619762 619865 622453 624659 629580 636230 638894 651876 662449 663740 668622 670088 672343 684122 684447 690928 716364 730758 788837 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (6.65%) |
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 547813 670088 668622 561300 570975 578108 590937 592686 601300 608415 596409 663740 520301 565784 588024 588679 590673 499536 522300 434767 534341 546054 480889 509167 522721 526959 545211 546552 571338 582031 546335 561580 579443 672343 624659 730758 449541 514041 417471 559015 544047 716364 571727 587523 592429 636230 578551 465720 514304 517083 539473 537452 495572 567947 576654 577514 545189 580662 557772 570838 599710 602714 614381 616551 788837 459629 651876 690928 585719 591185 619762 596416 563274 489305 500959 520115 520274 503504 507092 532318 543171 546905 559621 562974 566948 574975 576134 580126 554403 556199 561864 579223 662449 684122 588381 588941 594442 602457 604924 587118 600747 638894 606514 619865 622453 497752 629580 684447 392952 487934 481216 493779 485723 540587 521940 563301 567646 578569 543080 543764 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.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 392952 417471 434767 449541 459629 465720 480889 481216 485723 487934 489305 493779 495572 497752 499536 500959 503504 507092 509167 514041 514304 517083 520115 520274 520301 521940 522300 522721 526959 532318 534341 537452 539473 540587 543080 543171 543764 544047 545189 545211 546054 546335 546552 546905 547813 554403 556199 557772 559015 559621 561300 561580 561864 562974 563274 563301 565784 566948 567646 567947 570838 570975 571338 571727 574975 576134 576654 577514 578108 578551 578569 579223 579443 580126 580662 582031 585719 587118 587523 588024 588381 588679 588941 590673 590937 591185 592429 592686 594442 596409 596416 599710 600747 601300 602457 602714 604924 606514 608415 614381 616551 619762 619865 622453 624659 629580 636230 638894 651876 662449 663740 668622 670088 672343 684122 684447 690928 716364 730758 788837 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm in ass"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм жоп"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.70%) |
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.