Query Metrics
7
Database Queries
7
Different statements
372.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.00 ms (56.67%) |
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 185435 387218 388805 393700 394698 395502 397427 398502 416215 417435 426335 427088 427935 429208 436461 440613 443162 443567 443981 447567 447903 450013 451637 451749 455644 457026 467376 470481 471427 472830 473886 473958 474604 475188 477200 478484 480043 480385 480425 482816 484230 492259 492656 493148 495101 495158 496910 498233 501645 503524 503636 503944 506299 512276 513662 514467 514799 519252 520304 522132 524965 525449 526475 526513 527436 527565 528458 528644 529272 534194 537409 545699 548238 561368 561425 563180 569549 570414 571599 574295 575476 575711 576018 576199 579372 584103 584809 585447 585984 586451 591336 592418 593161 594827 595567 595690 597030 598567 599664 600186 601064 611918 612252 621977 622737 624804 625400 628477 640937 652213 654388 656713 657282 661250 663947 667139 668747 675808 730475 765941 ] |
||||||||||||||||||||||||||||||
|
139.43 ms (37.45%) |
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 185435 387218 388805 393700 394698 395502 397427 398502 416215 417435 426335 427088 427935 429208 436461 440613 443162 443567 443981 447567 447903 450013 451637 451749 455644 457026 467376 470481 471427 472830 473886 473958 474604 475188 477200 478484 480043 480385 480425 482816 484230 492259 492656 493148 495101 495158 496910 498233 501645 503524 503636 503944 506299 512276 513662 514467 514799 519252 520304 522132 524965 525449 526475 526513 527436 527565 528458 528644 529272 534194 537409 545699 548238 561368 561425 563180 569549 570414 571599 574295 575476 575711 576018 576199 579372 584103 584809 585447 585984 586451 591336 592418 593161 594827 595567 595690 597030 598567 599664 600186 601064 611918 612252 621977 622737 624804 625400 628477 640937 652213 654388 656713 657282 661250 663947 667139 668747 675808 730475 765941 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (3.87%) |
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 482816 480043 640937 765941 730475 398502 495101 393700 416215 561425 599664 457026 625400 477200 563180 471427 537409 569549 571599 656713 512276 495158 661250 474604 514467 387218 451637 622737 427935 394698 526513 522132 527565 492259 585447 594827 503944 473958 450013 561368 579372 503636 496910 663947 470481 575476 585984 185435 388805 545699 657282 475188 395502 493148 570414 429208 584103 472830 525449 654388 675808 595690 621977 467376 443162 451749 524965 576199 548238 574295 584809 667139 597030 628477 480425 440613 514799 519252 484230 478484 592418 534194 611918 443567 498233 526475 601064 436461 397427 513662 529272 443981 417435 447903 480385 501645 527436 575711 652213 668747 598567 600186 593161 591336 595567 624804 586451 612252 427088 455644 426335 473886 528644 503524 520304 492656 506299 528458 576018 447567 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pigtails blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"косичк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"косичк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.46%) |
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.