Query Metrics
7
Database Queries
7
Different statements
156.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.09 ms (80.44%) |
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 1061 101894 226082 364606 385446 389110 397819 401367 402026 413456 414001 415430 422142 425744 426551 429040 434040 434566 437801 443366 445072 447252 447301 448619 450844 453110 454639 457067 457311 458217 458267 459776 460098 460624 460713 460722 461251 461374 461472 461537 461808 467147 467361 468679 468783 469297 469760 470167 470861 474069 474385 475750 475871 479962 481218 482274 482806 483528 483825 485337 485479 489107 489141 490033 491588 493118 494658 495852 497197 497806 499368 499749 501969 502568 502967 504203 505381 508803 509581 510955 512619 512647 512760 513119 516360 516904 517375 518963 521806 523076 523593 525523 525616 526049 526595 533691 534589 539356 540658 543153 551251 552135 554125 555077 566723 572934 573989 575052 588897 597150 599102 608106 614893 617030 660352 666901 709777 719302 730754 803057 ] |
||||||||||||||||||||||||||||||
|
21.61 ms (13.79%) |
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 443366 402026 447252 483825 512619 534589 508803 608106 599102 479962 426551 489107 497197 572934 437801 719302 414001 573989 413456 485337 460722 461251 512760 539356 666901 555077 481218 482806 469297 482274 483528 505381 434566 401367 493118 509581 540658 533691 575052 597150 385446 101894 429040 434040 489141 448619 450844 461374 467361 491588 457067 457311 485479 490033 518963 513119 523076 494658 504203 517375 474069 554125 551251 415430 458267 460098 460624 458217 461537 474385 226082 468679 468783 461808 475871 512647 516360 525616 502568 499749 501969 525523 516904 588897 475750 470167 425744 397819 470861 454639 459776 803057 461472 364606 469760 497806 543153 660352 709777 614893 730754 510955 526049 521806 1061 552135 447301 389110 502967 566723 617030 422142 445072 460713 526595 467147 523593 453110 495852 499368 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.36%) |
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 1061 101894 226082 364606 385446 389110 397819 401367 402026 413456 414001 415430 422142 425744 426551 429040 434040 434566 437801 443366 445072 447252 447301 448619 450844 453110 454639 457067 457311 458217 458267 459776 460098 460624 460713 460722 461251 461374 461472 461537 461808 467147 467361 468679 468783 469297 469760 470167 470861 474069 474385 475750 475871 479962 481218 482274 482806 483528 483825 485337 485479 489107 489141 490033 491588 493118 494658 495852 497197 497806 499368 499749 501969 502568 502967 504203 505381 508803 509581 510955 512619 512647 512760 513119 516360 516904 517375 518963 521806 523076 523593 525523 525616 526049 526595 533691 534589 539356 540658 543153 551251 552135 554125 555077 566723 572934 573989 575052 588897 597150 599102 608106 614893 617030 660352 666901 709777 719302 730754 803057 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой хуй в рот"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член в рот"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.