Query Metrics
7
Database Queries
7
Different statements
124.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.51 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs masturbate"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.06 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 507895 499568 535543 544062 559216 583200 558323 577891 564482 659981 662782 572268 614612 589817 587179 589832 604980 612675 801229 801560 745397 753751 725527 810009 473673 477619 478785 422197 515448 509573 514407 526019 527707 487548 494204 457577 505736 519503 541118 543340 554756 567509 583990 707701 666823 551872 597645 615835 602578 609774 607070 746774 759724 609982 632083 449710 469569 420008 515736 502579 444921 455608 515663 525428 529776 555972 577582 681539 590345 613708 604198 439445 470207 475379 520203 420654 560385 644150 593129 697000 453394 455719 520201 486888 623108 422171 518227 516741 604298 ] |
||||||||||||||||||||||||||||||
| 4 | 2.69 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 422197 439445 444921 449710 453394 455608 455719 457577 469569 470207 473673 475379 477619 478785 486888 487548 494204 499568 502579 505736 507895 509573 514407 515448 515663 515736 516741 518227 519503 520201 520203 525428 526019 527707 529776 535543 541118 543340 544062 551872 554756 555972 558323 559216 560385 564482 567509 572268 577582 577891 583200 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 810009 ] |
||||||||||||||||||||||||||||||
| 5 | 101.69 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 422197 439445 444921 449710 453394 455608 455719 457577 469569 470207 473673 475379 477619 478785 486888 487548 494204 499568 502579 505736 507895 509573 514407 515448 515663 515736 516741 518227 519503 520201 520203 525428 526019 527707 529776 535543 541118 543340 544062 551872 554756 555972 558323 559216 560385 564482 567509 572268 577582 577891 583200 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 810009 ] |
||||||||||||||||||||||||||||||
| 6 | 1.51 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs masturbate"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.29 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.