Query Metrics
7
Database Queries
7
Different statements
364.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.88 ms (56.99%) |
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 386083 399876 420659 422519 430084 438374 439634 439789 445680 447486 447523 447549 453030 454094 454258 454581 455577 456960 461820 462545 463222 463950 465993 467146 469404 471919 472773 475194 476248 477734 478625 481307 482444 486748 491904 496298 496408 498643 501154 502649 508783 510503 510610 510683 512049 512425 513546 516245 516902 517292 517453 519695 519841 520736 522451 522937 522991 523373 524568 525529 526906 527591 528076 528342 532955 534922 535738 536282 536395 536466 536668 538454 542507 543310 544230 545860 546393 547835 549870 550613 552395 554995 555867 557086 558308 561070 561677 564923 565949 566523 567517 568460 569193 572869 576069 578449 579812 580377 580576 586537 586728 587817 592065 595988 598041 598685 600453 601643 602300 604503 605857 617346 618731 620032 621493 626891 631503 670491 690124 763611 ] |
||||||||||||||||||||||||||||||
|
134.36 ms (36.84%) |
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 386083 399876 420659 422519 430084 438374 439634 439789 445680 447486 447523 447549 453030 454094 454258 454581 455577 456960 461820 462545 463222 463950 465993 467146 469404 471919 472773 475194 476248 477734 478625 481307 482444 486748 491904 496298 496408 498643 501154 502649 508783 510503 510610 510683 512049 512425 513546 516245 516902 517292 517453 519695 519841 520736 522451 522937 522991 523373 524568 525529 526906 527591 528076 528342 532955 534922 535738 536282 536395 536466 536668 538454 542507 543310 544230 545860 546393 547835 549870 550613 552395 554995 555867 557086 558308 561070 561677 564923 565949 566523 567517 568460 569193 572869 576069 578449 579812 580377 580576 586537 586728 587817 592065 595988 598041 598685 600453 601643 602300 604503 605857 617346 618731 620032 621493 626891 631503 670491 690124 763611 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (4.29%) |
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 523373 536282 496298 536395 486748 546393 552395 568460 576069 579812 544230 569193 580576 595988 618731 586728 621493 467146 386083 477734 498643 763611 520736 550613 476248 447549 522937 587817 502649 536668 535738 549870 572869 620032 438374 522991 532955 399876 528076 439634 447523 447486 519841 536466 598685 512049 517453 528342 561070 566523 522451 491904 462545 430084 482444 463222 478625 455577 456960 453030 469404 510610 496408 538454 513546 527591 534922 510683 543310 554995 542507 558308 547835 561677 545860 555867 565949 567517 578449 586537 598041 626891 592065 605857 631503 601643 602300 481307 463950 471919 472773 454094 454581 445680 512425 524568 510503 517292 508783 516245 690124 475194 564923 670491 422519 439789 461820 519695 580377 557086 604503 617346 454258 465993 420659 526906 600453 525529 516902 501154 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"косичк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"косичк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pigtails blowjob"
]
|
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.