Query Metrics
7
Database Queries
7
Different statements
152.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.61 ms (81.92%) |
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 282038 387047 390303 416444 416873 418339 420621 420718 423600 426777 427942 432805 434472 436848 437146 437808 438877 439428 440156 441229 442475 443946 446698 447124 449095 449393 450287 450383 451691 453032 460568 462019 462392 463185 463677 463681 463775 464290 465043 469727 472160 472187 472466 473999 474021 474720 475995 479481 483286 483323 483453 483513 485803 486418 486628 486672 487060 487155 487605 488185 488623 489655 489656 490795 491676 492649 494888 495613 496302 496579 497249 497334 497671 498206 504385 507667 510016 515294 515370 516903 517879 517881 518089 518200 518350 518821 520143 521375 521932 524060 524831 525221 525532 525587 526219 526842 527040 527077 528785 534662 535707 543774 561360 561851 561891 564984 569685 571785 585161 586484 595888 595907 598695 609874 610626 643456 710771 724192 791061 811672 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (12.21%) |
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 487155 282038 811672 518350 525221 561851 472466 437808 524831 518821 586484 518200 420621 416444 442475 451691 464290 472160 710771 460568 474021 479481 474720 724192 486418 526842 438877 510016 518089 528785 485803 490795 517881 521932 483323 463677 447124 496579 465043 791061 416873 420718 390303 450383 462019 488185 515294 486628 494888 423600 610626 561891 449393 463681 525532 527077 569685 595888 521375 426777 483286 525587 498206 520143 526219 439428 516903 497249 534662 487605 507667 527040 387047 453032 487060 462392 437146 463185 434472 441229 469727 432805 440156 489656 495613 418339 497671 497334 483453 564984 446698 436848 504385 517879 571785 483513 449095 535707 427942 496302 598695 473999 488623 475995 561360 643456 443946 472187 489655 492649 609874 486672 491676 515370 524060 450287 463775 543774 585161 595907 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.72%) |
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 282038 387047 390303 416444 416873 418339 420621 420718 423600 426777 427942 432805 434472 436848 437146 437808 438877 439428 440156 441229 442475 443946 446698 447124 449095 449393 450287 450383 451691 453032 460568 462019 462392 463185 463677 463681 463775 464290 465043 469727 472160 472187 472466 473999 474021 474720 475995 479481 483286 483323 483453 483513 485803 486418 486628 486672 487060 487155 487605 488185 488623 489655 489656 490795 491676 492649 494888 495613 496302 496579 497249 497334 497671 498206 504385 507667 510016 515294 515370 516903 517879 517881 518089 518200 518350 518821 520143 521375 521932 524060 524831 525221 525532 525587 526219 526842 527040 527077 528785 534662 535707 543774 561360 561851 561891 564984 569685 571785 585161 586484 595888 595907 598695 609874 610626 643456 710771 724192 791061 811672 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful tits"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.91%) |
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.