Query Metrics
7
Database Queries
7
Different statements
128.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.76 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs masturbate"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.03 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 659981 589817 587179 745397 526019 541465 423814 457054 478987 544062 558323 564482 614612 589832 612675 801229 801560 753751 725527 477619 509573 514407 494204 437259 559216 662782 572268 604980 478785 515448 527707 487548 609774 505736 519503 707701 502579 543340 567509 583990 666823 609982 632083 469569 420008 457577 541118 554756 551872 597645 615835 607070 746774 759724 602578 449710 515736 475379 520203 525428 529776 439445 470207 577582 681539 590345 444921 455608 555972 613708 604198 515663 697000 455719 520201 420654 560385 593129 644150 453394 486888 422171 518227 623108 516741 604298 ] |
||||||||||||||||||||||||||||||
| 4 | 2.57 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 420008 420654 422171 423814 437259 439445 444921 449710 453394 455608 455719 457054 457577 469569 470207 475379 477619 478785 478987 486888 487548 494204 502579 505736 509573 514407 515448 515663 515736 516741 518227 519503 520201 520203 525428 526019 527707 529776 541118 541465 543340 544062 551872 554756 555972 558323 559216 560385 564482 567509 572268 577582 583990 587179 589817 589832 590345 593129 597645 602578 604198 604298 604980 607070 609774 612675 613708 614612 615835 623108 632083 644150 659981 662782 666823 681539 697000 707701 725527 745397 746774 753751 759724 801229 801560 ] |
||||||||||||||||||||||||||||||
| 5 | 102.44 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 420008 420654 422171 423814 437259 439445 444921 449710 453394 455608 455719 457054 457577 469569 470207 475379 477619 478785 478987 486888 487548 494204 502579 505736 509573 514407 515448 515663 515736 516741 518227 519503 520201 520203 525428 526019 527707 529776 541118 541465 543340 544062 551872 554756 555972 558323 559216 560385 564482 567509 572268 577582 583990 587179 589817 589832 590345 593129 597645 602578 604198 604298 604980 607070 609774 612675 613708 614612 615835 623108 632083 644150 659981 662782 666823 681539 697000 707701 725527 745397 746774 753751 759724 801229 801560 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs masturbate"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs masturbate"
]
|
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.