Query Metrics
7
Database Queries
7
Different statements
208.54 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.91 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.50 ms |
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 481257 639139 513002 408194 561492 604980 478785 505748 771023 403463 419112 453456 474441 419106 509156 390096 404777 419160 463490 493600 540282 540361 584320 779610 763720 749260 429952 381838 511399 428547 515275 583576 579537 671585 681098 697174 717873 718513 719388 608815 610103 587767 603328 619832 603177 590735 591627 642346 798319 799653 812565 760443 784345 770402 742848 701761 454029 489390 601088 385483 382747 382542 402625 421501 421776 505804 532781 535261 559089 547538 564711 605634 599657 621964 775276 805630 775235 812894 806850 618276 469263 437218 389474 455811 11320 400156 401959 426268 502857 494322 425640 387218 792614 390923 430433 399639 474656 526720 717793 407305 390820 444406 409061 421166 426481 447109 492716 519844 534298 556747 580855 469569 488137 385376 493795 572731 544768 671626 660724 646669 ] |
||||||||||||||||||||||||||||||
| 4 | 3.29 ms |
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 11320 381838 382542 382747 385376 385483 387218 389474 390096 390820 390923 399639 400156 401959 402625 403463 404777 407305 408194 409061 419106 419112 419160 421166 421501 421776 425640 426268 426481 428547 429952 430433 437218 444406 447109 453456 454029 455811 463490 469263 469569 474441 474656 478785 481257 488137 489390 492716 493600 493795 494322 502857 505748 505804 509156 511399 513002 515275 519844 526720 532781 534298 535261 540282 540361 544768 547538 556747 559089 561492 564711 572731 579537 580855 583576 584320 587767 590735 591627 599657 601088 603177 603328 604980 605634 608815 610103 618276 619832 621964 639139 642346 646669 660724 671585 671626 681098 697174 701761 717793 717873 718513 719388 742848 749260 760443 763720 770402 771023 775235 775276 779610 784345 792614 798319 799653 805630 806850 812565 812894 ] |
||||||||||||||||||||||||||||||
| 5 | 177.53 ms |
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 11320 381838 382542 382747 385376 385483 387218 389474 390096 390820 390923 399639 400156 401959 402625 403463 404777 407305 408194 409061 419106 419112 419160 421166 421501 421776 425640 426268 426481 428547 429952 430433 437218 444406 447109 453456 454029 455811 463490 469263 469569 474441 474656 478785 481257 488137 489390 492716 493600 493795 494322 502857 505748 505804 509156 511399 513002 515275 519844 526720 532781 534298 535261 540282 540361 544768 547538 556747 559089 561492 564711 572731 579537 580855 583576 584320 587767 590735 591627 599657 601088 603177 603328 604980 605634 608815 610103 618276 619832 621964 639139 642346 646669 660724 671585 671626 681098 697174 701761 717793 717873 718513 719388 742848 749260 760443 763720 770402 771023 775235 775276 779610 784345 792614 798319 799653 805630 806850 812565 812894 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.78 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs мастурбац"
]
|
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.