Query Metrics
7
Database Queries
7
Different statements
140.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.07 ms (84.45%) |
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 389733 392620 397393 400988 413084 414369 417172 418259 422174 423427 435409 437686 437988 438009 438725 442081 442957 445114 446455 447329 447891 449280 449281 449300 449318 450437 450955 451028 451386 454141 454324 455479 456202 457842 458703 459471 461989 462592 462649 463072 464190 464253 465345 465373 465412 466553 470031 470364 471340 476628 479811 482566 482603 483902 484569 485008 489285 490394 490959 492156 496056 496603 497643 498404 500511 509564 512952 513260 513685 514210 519993 520597 520748 522711 523691 525893 527872 542049 548085 553002 563838 564899 567681 571508 571697 572675 573286 597689 599055 616733 619509 683428 698914 709337 726710 727543 727757 735501 742953 784258 787649 788523 791841 793546 793808 797220 802349 808044 810330 810586 814127 817517 817799 817808 819012 819018 819507 823157 823258 824243 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (9.42%) |
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 479811 808044 461989 462592 435409 520748 525893 519993 417172 500511 727543 553002 413084 455479 512952 742953 476628 397393 810330 735501 490394 564899 726710 445114 513260 520597 496603 563838 527872 458703 400988 513685 392620 389733 438009 442957 422174 482566 449280 483902 449300 450955 451028 462649 482603 450437 489285 490959 573286 571697 548085 572675 616733 464190 418259 470364 447329 449318 464253 466553 485008 514210 496056 522711 824243 823258 787649 709337 442081 454324 447891 438725 463072 437988 446455 437686 784258 793808 793546 802349 810586 791841 597689 797220 451386 814127 819018 817799 465345 456202 457842 449281 683428 459471 471340 542049 423427 465412 571508 599055 465373 470031 817517 817808 819012 823157 819507 727757 788523 698914 454141 492156 484569 414369 498404 567681 619509 509564 497643 523691 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.80%) |
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 389733 392620 397393 400988 413084 414369 417172 418259 422174 423427 435409 437686 437988 438009 438725 442081 442957 445114 446455 447329 447891 449280 449281 449300 449318 450437 450955 451028 451386 454141 454324 455479 456202 457842 458703 459471 461989 462592 462649 463072 464190 464253 465345 465373 465412 466553 470031 470364 471340 476628 479811 482566 482603 483902 484569 485008 489285 490394 490959 492156 496056 496603 497643 498404 500511 509564 512952 513260 513685 514210 519993 520597 520748 522711 523691 525893 527872 542049 548085 553002 563838 564899 567681 571508 571697 572675 573286 597689 599055 616733 619509 683428 698914 709337 726710 727543 727757 735501 742953 784258 787649 788523 791841 793546 793808 797220 802349 808044 810330 810586 814127 817517 817799 817808 819012 819018 819507 823157 823258 824243 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни жен"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.