Query Metrics
7
Database Queries
7
Different statements
153.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.86 ms (84.33%) |
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 411255 414042 414119 414138 418594 418720 418817 419452 420515 420816 426399 429608 429905 430267 437867 438052 439249 441049 444921 447315 450287 452885 453213 455608 457622 458007 469223 469327 469737 471148 472266 476321 477506 478991 479936 480119 485472 487008 493258 495507 495566 498114 499365 505891 506228 507766 508891 514621 516601 519354 525729 526531 526536 527180 527442 528407 529154 531594 532531 534169 536393 541418 541839 553208 553726 554235 554526 555657 556202 558132 558160 561919 563108 564643 567071 567780 567798 568264 570393 577888 578718 579519 580223 581873 583134 585338 589685 590102 591394 593292 594262 595016 596857 597645 597750 601806 604153 604865 605266 605742 615428 615918 621759 624834 626066 628617 632169 637245 643542 644276 684666 684681 704218 741764 770397 770405 773257 792088 804104 814434 ] |
||||||||||||||||||||||||||||||
|
15.50 ms (10.06%) |
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 563108 578718 704218 684666 568264 597645 621759 637245 605266 438052 453213 472266 493258 479936 597750 447315 441049 553208 558132 596857 499365 814434 450287 457622 469737 476321 478991 528407 534169 485472 487008 558160 589685 615428 626066 628617 770405 773257 741764 429905 418720 519354 507766 498114 471148 444921 429608 525729 508891 601806 458007 414119 480119 553726 570393 556202 567071 583134 643542 585338 792088 418817 439249 452885 495507 506228 514621 564643 580223 644276 632169 541839 420816 418594 455608 469327 590102 594262 605742 804104 469223 516601 527180 529154 577888 526536 419452 430267 437867 531594 579519 595016 770397 414138 414042 532531 604153 536393 567798 541418 604865 420515 527442 495566 581873 411255 477506 554235 561919 555657 684681 593292 567780 624834 615918 426399 505891 591394 526531 554526 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.58%) |
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 411255 414042 414119 414138 418594 418720 418817 419452 420515 420816 426399 429608 429905 430267 437867 438052 439249 441049 444921 447315 450287 452885 453213 455608 457622 458007 469223 469327 469737 471148 472266 476321 477506 478991 479936 480119 485472 487008 493258 495507 495566 498114 499365 505891 506228 507766 508891 514621 516601 519354 525729 526531 526536 527180 527442 528407 529154 531594 532531 534169 536393 541418 541839 553208 553726 554235 554526 555657 556202 558132 558160 561919 563108 564643 567071 567780 567798 568264 570393 577888 578718 579519 580223 581873 583134 585338 589685 590102 591394 593292 594262 595016 596857 597645 597750 601806 604153 604865 605266 605742 615428 615918 621759 624834 626066 628617 632169 637245 643542 644276 684666 684681 704218 741764 770397 770405 773257 792088 804104 814434 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot solo ass"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot соло жоп"
]
|
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.