Query Metrics
7
Database Queries
7
Different statements
154.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.05 ms (79.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 387559 417177 419258 423802 424769 427263 428452 428712 429708 431597 437518 439931 443368 445874 445997 446584 450585 450759 450896 451050 453111 453883 454136 460154 461136 461611 462392 463183 463448 463828 467560 469780 470613 470664 472547 473923 474031 478251 480403 484277 486827 486890 488782 492474 493278 493293 495813 500033 500238 502584 503383 503838 504017 506909 507763 507909 508616 508906 510092 512138 513701 514141 520706 522098 522219 522556 523175 524260 524267 524331 524596 524654 527619 529511 532380 552351 554248 554551 562637 578036 582639 584159 584502 589133 593900 598178 598765 599421 599730 599766 600014 601677 605862 605988 608613 613780 614600 626436 651632 659401 662190 684681 723227 725098 732033 750799 755564 756289 765599 772318 776941 784771 784916 788158 790409 792412 801181 803163 812807 818283 ] |
||||||||||||||||||||||||||||||
|
22.64 ms (14.69%) |
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 601677 429708 613780 626436 450585 460154 504017 461611 424769 470664 508616 520706 522219 524260 600014 605862 480403 463448 484277 387559 463828 473923 605988 417177 659401 801181 812807 765599 725098 756289 784916 792412 439931 502584 503383 522556 750799 818283 723227 532380 582639 684681 492474 493278 450759 453111 527619 512138 493293 552351 554248 598178 788158 772318 784771 803163 431597 454136 428452 522098 478251 428712 419258 453883 589133 755564 500033 506909 524654 524267 651632 608613 443368 495813 423802 445874 599421 599766 599730 503838 510092 427263 462392 474031 524596 578036 584502 662190 598765 593900 776941 790409 445997 472547 451050 463183 450896 461136 469780 470613 500238 529511 486827 446584 584159 437518 488782 524331 508906 554551 507909 507763 467560 523175 486890 562637 513701 732033 514141 614600 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass pov masturbation"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.40%) |
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 387559 417177 419258 423802 424769 427263 428452 428712 429708 431597 437518 439931 443368 445874 445997 446584 450585 450759 450896 451050 453111 453883 454136 460154 461136 461611 462392 463183 463448 463828 467560 469780 470613 470664 472547 473923 474031 478251 480403 484277 486827 486890 488782 492474 493278 493293 495813 500033 500238 502584 503383 503838 504017 506909 507763 507909 508616 508906 510092 512138 513701 514141 520706 522098 522219 522556 523175 524260 524267 524331 524596 524654 527619 529511 532380 552351 554248 554551 562637 578036 582639 584159 584502 589133 593900 598178 598765 599421 599730 599766 600014 601677 605862 605988 608613 613780 614600 626436 651632 659401 662190 684681 723227 725098 732033 750799 755564 756289 765599 772318 776941 784771 784916 788158 790409 792412 801181 803163 812807 818283 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп пов мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.82%) |
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.