Query Metrics
7
Database Queries
7
Different statements
155.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.64 ms (82.51%) |
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 391009 396378 400265 412220 412265 415806 418135 418817 425244 426298 435579 438452 442236 444299 445138 459574 459602 460166 461400 462056 463435 466470 466503 469502 473786 474891 476666 479328 480232 481997 491505 492407 492465 494665 497399 497777 502994 504428 507010 508845 509188 509258 515550 519678 521171 527448 530649 532111 532225 532587 533211 537165 537322 537324 537354 539323 539634 539644 540660 542330 542433 544342 547570 548489 549448 550163 552731 553964 555971 556325 559994 564170 568233 568310 568807 574358 575972 579271 582153 583374 584312 590456 590713 592852 595981 598335 602298 602332 603980 606095 613224 630270 636566 644436 672701 692979 701221 715402 721112 739820 745301 755490 760681 760687 763740 765818 765836 773724 774994 783321 783343 785899 790664 791033 791059 798411 801786 803635 808542 812869 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (10.63%) |
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 466503 509188 552731 548489 564170 636566 463435 476666 497399 497777 559994 462056 461400 426298 473786 469502 537324 530649 532111 533211 539323 532587 550163 582153 544342 574358 584312 672701 701221 549448 644436 812869 755490 785899 790664 765818 763740 745301 739820 773724 602298 791059 801786 481997 435579 415806 507010 519678 479328 539634 715402 556325 492465 466470 508845 540660 542330 692979 613224 630270 595981 783321 783343 803635 808542 765836 791033 412220 494665 491505 568807 391009 444299 575972 579271 583374 553964 603980 418817 492407 555971 396378 438452 418135 425244 442236 480232 537322 539644 509258 532225 537165 515550 527448 537354 502994 542433 568233 568310 547570 592852 598335 602332 606095 590713 590456 774994 798411 760687 760681 721112 474891 459602 400265 459574 412265 445138 460166 504428 521171 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.96%) |
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 391009 396378 400265 412220 412265 415806 418135 418817 425244 426298 435579 438452 442236 444299 445138 459574 459602 460166 461400 462056 463435 466470 466503 469502 473786 474891 476666 479328 480232 481997 491505 492407 492465 494665 497399 497777 502994 504428 507010 508845 509188 509258 515550 519678 521171 527448 530649 532111 532225 532587 533211 537165 537322 537324 537354 539323 539634 539644 540660 542330 542433 544342 547570 548489 549448 550163 552731 553964 555971 556325 559994 564170 568233 568310 568807 574358 575972 579271 582153 583374 584312 590456 590713 592852 595981 598335 602298 602332 603980 606095 613224 630270 636566 644436 672701 692979 701221 715402 721112 739820 745301 755490 760681 760687 763740 765818 765836 773724 774994 783321 783343 785899 790664 791033 791059 798411 801786 803635 808542 812869 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful wife"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая жен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
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.