Query Metrics
7
Database Queries
7
Different statements
419.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.27 ms (50.16%) |
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 118098 118237 154516 260962 382818 388341 391983 392100 401189 414292 415978 416537 421513 423652 424593 428257 429859 432936 440016 440032 440052 444281 446797 456240 457478 462580 468680 471696 473448 474265 498018 505597 506321 508888 508895 510532 510818 512943 515053 523614 532658 533375 534540 534555 535620 536233 536377 536471 536684 540504 543897 544140 547236 547467 547472 547473 547481 547485 547494 547853 547854 556338 556887 559372 561021 561038 561273 576493 576494 583936 584183 586557 590281 592576 618303 630423 632636 632657 633748 634026 634076 634738 636309 636982 637034 637503 639752 639784 641685 642018 643100 646884 647895 649579 656186 660362 660399 660410 666850 666871 666876 666898 669026 669045 669390 677125 679016 680200 696216 713184 740800 742353 797197 797280 800571 800706 801610 805144 818475 825514 ] |
||||||||||||||||||||||||||||||
|
177.34 ms (42.30%) |
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 118098 118237 154516 260962 382818 388341 391983 392100 401189 414292 415978 416537 421513 423652 424593 428257 429859 432936 440016 440032 440052 444281 446797 456240 457478 462580 468680 471696 473448 474265 498018 505597 506321 508888 508895 510532 510818 512943 515053 523614 532658 533375 534540 534555 535620 536233 536377 536471 536684 540504 543897 544140 547236 547467 547472 547473 547481 547485 547494 547853 547854 556338 556887 559372 561021 561038 561273 576493 576494 583936 584183 586557 590281 592576 618303 630423 632636 632657 633748 634026 634076 634738 636309 636982 637034 637503 639752 639784 641685 642018 643100 646884 647895 649579 656186 660362 660399 660410 666850 666871 666876 666898 669026 669045 669390 677125 679016 680200 696216 713184 740800 742353 797197 797280 800571 800706 801610 805144 818475 825514 ] |
||||||||||||||||||||||||||||||
|
24.57 ms (5.86%) |
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 423652 825514 544140 547236 576493 713184 666898 636982 586557 118098 510818 536471 535620 696216 649579 414292 440016 515053 561273 660399 801610 498018 532658 805144 669045 800706 637503 392100 416537 424593 506321 656186 669026 669390 382818 512943 536684 677125 468680 388341 462580 508888 556887 576494 584183 634026 634076 797197 474265 523614 505597 818475 154516 473448 534555 547472 547853 742353 391983 666876 260962 641685 118237 401189 471696 457478 534540 543897 547854 660362 592576 630423 618303 800571 797280 740800 679016 632636 633748 428257 547467 547473 547485 660410 590281 429859 510532 559372 666871 646884 540504 647895 680200 642018 637034 639752 421513 536377 634738 415978 533375 536233 583936 639784 632657 636309 444281 440032 440052 446797 508895 547481 556338 547494 561038 561021 643100 456240 666850 432936 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex and fisting"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.