Query Metrics
7
Database Queries
7
Different statements
161.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.69 ms (80.13%) |
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 385919 391144 396967 397316 403050 408652 409045 416151 418436 419600 421436 421618 422401 424264 429135 433954 437517 438730 446879 447321 450692 453945 455419 456209 459801 465120 466784 470422 474580 477038 477262 479221 481328 485585 485855 486084 489744 491588 494662 496428 501622 502230 503919 503943 510002 516218 520066 546552 549075 549098 549216 559474 563886 569262 576216 577452 580383 583313 588749 592261 592946 594111 608243 615647 618129 618544 618834 619852 623361 627778 630050 640149 647357 652126 652519 677726 696556 701267 705791 708762 709880 716529 717623 724084 724898 726249 727633 731695 740399 746335 748386 751801 753155 755426 755584 760923 761076 761995 762721 762986 763303 764342 764947 774339 776161 776988 778091 780571 780932 786986 793586 796873 799818 800625 802829 813075 813241 814963 819585 821798 ] |
||||||||||||||||||||||||||||||
|
22.76 ms (14.06%) |
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 470422 763303 780932 424264 453945 563886 799818 491588 456209 760923 391144 409045 486084 433954 408652 516218 746335 481328 503943 485585 496428 503919 774339 385919 813075 559474 716529 594111 748386 403050 477038 576216 580383 615647 802829 619852 419600 592946 761995 709880 819585 520066 677726 701267 796873 751801 764947 724084 474580 450692 588749 717623 429135 459801 447321 489744 510002 623361 618834 778091 727633 813241 465120 485855 421436 446879 501622 546552 438730 549075 569262 592261 640149 726249 761076 780571 762721 477262 418436 396967 494662 708762 549098 800625 731695 762986 753155 814963 397316 647357 652126 455419 549216 577452 776988 422401 466784 502230 479221 696556 608243 630050 764342 416151 618544 421618 821798 627778 776161 786986 724898 793586 755426 437517 583313 740399 705791 652519 618129 755584 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.43%) |
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 385919 391144 396967 397316 403050 408652 409045 416151 418436 419600 421436 421618 422401 424264 429135 433954 437517 438730 446879 447321 450692 453945 455419 456209 459801 465120 466784 470422 474580 477038 477262 479221 481328 485585 485855 486084 489744 491588 494662 496428 501622 502230 503919 503943 510002 516218 520066 546552 549075 549098 549216 559474 563886 569262 576216 577452 580383 583313 588749 592261 592946 594111 608243 615647 618129 618544 618834 619852 623361 627778 630050 640149 647357 652126 652519 677726 696556 701267 705791 708762 709880 716529 717623 724084 724898 726249 727633 731695 740399 746335 748386 751801 753155 755426 755584 760923 761076 761995 762721 762986 763303 764342 764947 774339 776161 776988 778091 780571 780932 786986 793586 796873 799818 800625 802829 813075 813241 814963 819585 821798 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little dick fuck"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little член секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little член секс"
]
|
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.