Query Metrics
7
Database Queries
7
Different statements
156.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.07 ms (78.69%) |
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 1095 10006 11937 185861 366017 382777 385185 385475 387883 390242 395693 402982 407130 407157 413617 416914 418372 418442 429317 434281 434759 436756 437946 439285 440776 453541 454743 456500 459624 462650 468062 479815 483921 489288 490839 491371 497496 500565 504281 507258 507404 510444 518913 520179 520363 520901 521972 523299 524143 526378 530826 532487 538091 545491 548628 550395 551236 551241 561431 561734 562254 562507 566948 573261 573408 577724 580000 580143 582019 586460 587307 587338 588486 589735 590066 590120 592298 593955 594018 598970 602530 603013 611563 615451 616588 617454 617489 617512 639413 641534 660300 662209 686334 687097 687299 688203 692998 710647 713023 732148 740268 747648 752058 754878 757667 762363 762784 762855 763978 770391 775127 775148 782376 782388 785718 786711 787911 798703 806683 ] |
||||||||||||||||||||||||||||||
|
21.81 ms (13.95%) |
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 710647 732148 11937 448762 562254 692998 418442 462650 526378 479815 545491 551236 590120 611563 641534 775148 786711 806683 439285 385185 402982 520179 580000 561431 687097 615451 589735 586460 603013 782376 490839 510444 592298 594018 763978 757667 762784 617512 602530 548628 561734 587307 418372 1095 407130 518913 551241 687299 573408 740268 770391 752058 407157 413617 390242 416914 520901 185861 434759 530826 566948 590066 617489 775127 366017 395693 434281 459624 507404 521972 523299 491371 387883 437946 453541 456500 538091 497496 580143 713023 662209 587338 598970 787911 782388 754878 762855 785718 385475 483921 504281 520363 686334 688203 616588 593955 639413 798703 762363 617454 440776 468062 489288 507258 532487 588486 524143 10006 429317 436756 550395 577724 660300 747648 454743 382777 500565 573261 582019 562507 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.23%) |
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 1095 10006 11937 185861 366017 382777 385185 385475 387883 390242 395693 402982 407130 407157 413617 416914 418372 418442 429317 434281 434759 436756 437946 439285 440776 453541 454743 456500 459624 462650 468062 479815 483921 489288 490839 491371 497496 500565 504281 507258 507404 510444 518913 520179 520363 520901 521972 523299 524143 526378 530826 532487 538091 545491 548628 550395 551236 551241 561431 561734 562254 562507 566948 573261 573408 577724 580000 580143 582019 586460 587307 587338 588486 589735 590066 590120 592298 593955 594018 598970 602530 603013 611563 615451 616588 617454 617489 617512 639413 641534 660300 662209 686334 687097 687299 688203 692998 710647 713023 732148 740268 747648 752058 754878 757667 762363 762784 762855 763978 770391 775127 775148 782376 782388 785718 786711 787911 798703 806683 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"college girls"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"college девушк"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"college девушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
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.