Query Metrics
7
Database Queries
7
Different statements
186.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.12 ms (83.34%) |
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 413429 421138 421734 423455 423876 426069 426093 427913 435716 435800 441758 442555 442995 443002 443004 443010 443027 443055 444888 448647 451634 452370 452423 452562 452704 452709 452725 454867 455577 455598 456071 456583 457045 461231 461811 463496 463725 465796 467755 471475 475420 477232 478131 478139 480326 485297 488026 488348 493276 497179 498056 501916 502630 503702 503735 503743 503754 504623 504948 505263 509522 512551 515809 519595 520059 520082 520570 521332 521679 522578 525241 525565 526940 528270 529255 530111 544441 551598 551604 552264 552609 553399 558618 562731 564165 569308 573267 578342 585011 591295 593421 594590 594594 594607 594619 594638 595226 598636 598667 598931 610082 616699 618008 619728 622264 622405 624962 631717 652756 659379 668471 700299 728557 749437 751128 753993 787033 795385 809179 ] |
||||||||||||||||||||||||||||||
|
18.70 ms (10.05%) |
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 443002 529255 465796 795385 521332 616699 463725 501916 502630 809179 504948 509522 622264 787033 749437 552609 594638 610082 505263 441758 421734 452704 421138 521679 442995 443055 728557 668471 461811 452725 578342 423455 452370 700299 659379 591295 593421 478131 504623 448647 753993 493276 594619 594607 443004 456583 751128 467755 423876 558618 455598 426069 522578 594594 452423 456071 413429 443027 631717 463496 598931 569308 461231 551604 451634 452709 477232 526940 585011 478139 652756 454867 573267 515809 443010 598667 530111 455577 774682 519595 525565 503743 520082 485297 544441 551598 426093 520059 452562 435716 471475 624962 598636 444888 475420 442555 503735 512551 497179 503702 528270 488348 553399 622405 498056 503754 525241 488026 562731 457045 427913 595226 552264 520570 435800 618008 594590 619728 564165 480326 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.93 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 413429 421138 421734 423455 423876 426069 426093 427913 435716 435800 441758 442555 442995 443002 443004 443010 443027 443055 444888 448647 451634 452370 452423 452562 452704 452709 452725 454867 455577 455598 456071 456583 457045 461231 461811 463496 463725 465796 467755 471475 475420 477232 478131 478139 480326 485297 488026 488348 493276 497179 498056 501916 502630 503702 503735 503743 503754 504623 504948 505263 509522 512551 515809 519595 520059 520082 520570 521332 521679 522578 525241 525565 526940 528270 529255 530111 544441 551598 551604 552264 552609 553399 558618 562731 564165 569308 573267 578342 585011 591295 593421 594590 594594 594607 594619 594638 595226 598636 598667 598931 610082 616699 618008 619728 622264 622405 624962 631717 652756 659379 668471 700299 728557 749437 751128 753993 787033 795385 809179 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sensual blowjob homemade"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sensual минет оральн секс домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sensual минет оральн секс домашн любительск"
]
|
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.