Query Metrics
7
Database Queries
7
Different statements
190.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.95 ms (85.58%) |
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 250215 384285 384306 387884 394053 396640 398676 401996 411544 411631 414130 415890 426438 426936 427341 429231 435374 436478 436687 436693 440698 444341 444707 446856 447146 447435 447524 449371 449678 457850 458792 462490 463139 463674 465548 467001 472399 473186 481430 489370 489606 489630 490079 491857 496199 496454 501732 501746 501805 506485 510610 513768 513769 514673 515740 519486 520497 522001 523507 524185 531647 537425 540543 542507 551147 552073 552129 552132 552134 552229 552296 554213 556945 558958 559578 563325 563854 563871 563878 565069 565674 567016 569299 571381 571497 581976 582493 584257 586449 586549 590837 591155 592314 596412 602212 605644 608878 615318 628910 635336 641886 659412 659439 671334 671685 672671 676539 677020 681505 683380 683588 685982 688340 717760 719937 724366 741935 744511 792309 812155 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (9.08%) |
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 444707 552229 717760 792309 556945 472399 605644 741935 812155 473186 491857 552132 590837 719937 449371 501746 563325 615318 724366 394053 515740 672671 436478 490079 513769 524185 591155 567016 552134 429231 436693 496454 565674 641886 628910 602212 463139 411544 683380 571497 523507 608878 571381 250215 522001 506485 552129 436687 520497 401996 411631 565069 554213 744511 435374 481430 415890 440698 514673 683588 688340 584257 449678 463674 426936 496199 551147 458792 531647 426438 384306 659439 563854 569299 681505 581976 596412 586549 462490 396640 447524 635336 387884 465548 398676 513768 457850 671685 592314 444341 537425 552073 676539 671334 384285 489370 501805 446856 467001 685982 559578 489606 489630 510610 542507 586449 414130 427341 659412 677020 582493 563871 552296 501732 519486 563878 447146 540543 558958 447435 ] |
||||||||||||||||||||||||||||||
|
3.01 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 250215 384285 384306 387884 394053 396640 398676 401996 411544 411631 414130 415890 426438 426936 427341 429231 435374 436478 436687 436693 440698 444341 444707 446856 447146 447435 447524 449371 449678 457850 458792 462490 463139 463674 465548 467001 472399 473186 481430 489370 489606 489630 490079 491857 496199 496454 501732 501746 501805 506485 510610 513768 513769 514673 515740 519486 520497 522001 523507 524185 531647 537425 540543 542507 551147 552073 552129 552132 552134 552229 552296 554213 556945 558958 559578 563325 563854 563871 563878 565069 565674 567016 569299 571381 571497 581976 582493 584257 586449 586549 590837 591155 592314 596412 602212 605644 608878 615318 628910 635336 641886 659412 659439 671334 671685 672671 676539 677020 681505 683380 683588 685982 688340 717760 719937 724366 741935 744511 792309 812155 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс virgin вагин"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс virgin вагин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex virgin vagina"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
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.