Query Metrics
7
Database Queries
7
Different statements
187.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.84 ms (86.20%) |
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 393921 398198 421967 423930 426117 427292 433066 434350 434364 446796 450044 450901 451162 462495 469489 474891 484065 484915 494328 494530 496063 496556 496642 504571 508221 509507 510004 518147 518210 519362 529347 531118 536914 538977 542124 542484 543932 544110 549243 549485 550179 551646 554178 554399 555005 555040 557720 559396 559736 559787 560046 561425 563165 565642 569300 575848 577091 579405 580366 580500 582382 583093 583180 583206 584230 589703 590264 591161 592121 592852 593060 593823 595605 599934 601176 607963 608827 614720 614768 617107 620585 626439 628692 629500 631880 633175 637085 642060 644056 645858 647313 660013 666856 681498 718864 724305 726315 726894 739155 739496 742313 749978 752147 752663 757421 769465 778618 782581 783211 785059 787284 794651 800766 802291 806952 807842 807918 811690 819506 824870 ] |
||||||||||||||||||||||||||||||
|
16.00 ms (8.52%) |
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 782581 800766 783211 787284 739155 752147 752663 757421 607963 519362 660013 496642 433066 628692 531118 724305 614720 509507 496556 451162 450044 518147 824870 494328 542124 560046 577091 579405 583180 543932 544110 549485 554178 565642 551646 580366 583206 718864 666856 555005 559396 575848 580500 583093 590264 592852 608827 593823 626439 592121 631880 593060 595605 620585 802291 806952 807842 726894 769465 742313 739496 749978 629500 778618 807918 474891 423930 494530 819506 462495 542484 549243 557720 550179 584230 681498 554399 561425 582382 589703 591161 617107 637085 785059 794651 811690 726315 614768 644056 496063 645858 450901 484065 569300 426117 529347 393921 434364 469489 446796 518210 508221 563165 555040 647313 559787 599934 601176 642060 633175 427292 484915 421967 510004 559736 398198 434350 504571 536914 538977 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.54%) |
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 393921 398198 421967 423930 426117 427292 433066 434350 434364 446796 450044 450901 451162 462495 469489 474891 484065 484915 494328 494530 496063 496556 496642 504571 508221 509507 510004 518147 518210 519362 529347 531118 536914 538977 542124 542484 543932 544110 549243 549485 550179 551646 554178 554399 555005 555040 557720 559396 559736 559787 560046 561425 563165 565642 569300 575848 577091 579405 580366 580500 582382 583093 583180 583206 584230 589703 590264 591161 592121 592852 593060 593823 595605 599934 601176 607963 608827 614720 614768 617107 620585 626439 628692 629500 631880 633175 637085 642060 644056 645858 647313 660013 666856 681498 718864 724305 726315 726894 739155 739496 742313 749978 752147 752663 757421 769465 778618 782581 783211 785059 787284 794651 800766 802291 806952 807842 807918 811690 819506 824870 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк my pussy"
]
|
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.