Query Metrics
7
Database Queries
7
Different statements
177.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.78 ms (86.05%) |
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 382585 385436 386719 387851 388280 388696 391567 393483 396143 400096 401757 408679 413092 414673 415320 420700 422488 426444 427925 429934 432414 432494 433758 436644 437856 445028 445275 447493 447501 447515 447539 451599 463819 470341 486308 486437 491504 495559 496032 497558 500698 501809 510550 510631 512645 518942 526583 526774 527800 543534 549777 552192 552193 552694 567574 569097 595412 595441 595480 595493 595501 596592 596610 596625 597040 597808 597966 597992 598041 598147 598457 598492 598496 598616 598737 598744 600070 615059 617651 648546 652192 652554 655674 655716 657594 659529 659766 666561 666562 670174 673455 675028 683297 687375 692445 704021 704613 715338 717459 717722 736841 740222 753472 753599 760514 760961 762262 762275 765109 767309 775895 778875 781358 789308 800003 811483 812346 814462 820203 825829 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (8.17%) |
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 675028 687375 704021 652554 655674 657594 659529 670174 673455 615059 789308 762275 781358 765109 767309 736841 753472 753599 760961 778875 717459 811483 617651 717722 432414 386719 387851 437856 447493 396143 429934 595493 598457 598616 596610 388696 427925 385436 470341 447501 512645 518942 595501 597966 420700 597040 422488 595412 595441 447515 463819 447539 415320 426444 445275 526583 659766 598041 598147 569097 408679 414673 495559 496032 510550 526774 510631 814462 598737 648546 715338 666561 652192 666562 567574 393483 401757 491504 382585 388280 497558 552193 655716 704613 552192 596625 400096 391567 413092 436644 501809 527800 600070 433758 445028 486308 500698 552694 825829 820203 543534 740222 549777 683297 432494 451599 486437 692445 597808 598496 598744 596592 597992 598492 595480 812346 775895 800003 762262 760514 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian tits teen"
]
|
||||||||||||||||||||||||||||||
|
2.31 ms (1.30%) |
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 382585 385436 386719 387851 388280 388696 391567 393483 396143 400096 401757 408679 413092 414673 415320 420700 422488 426444 427925 429934 432414 432494 433758 436644 437856 445028 445275 447493 447501 447515 447539 451599 463819 470341 486308 486437 491504 495559 496032 497558 500698 501809 510550 510631 512645 518942 526583 526774 527800 543534 549777 552192 552193 552694 567574 569097 595412 595441 595480 595493 595501 596592 596610 596625 597040 597808 597966 597992 598041 598147 598457 598492 598496 598616 598737 598744 600070 615059 617651 648546 652192 652554 655674 655716 657594 659529 659766 666561 666562 670174 673455 675028 683297 687375 692445 704021 704613 715338 717459 717722 736841 740222 753472 753599 760514 760961 762262 762275 765109 767309 775895 778875 781358 789308 800003 811483 812346 814462 820203 825829 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск сиськ teen"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск сиськ teen"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
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.