Query Metrics
7
Database Queries
7
Different statements
390.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.56 ms (54.49%) |
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 61597 181252 379619 381884 382326 382878 382942 385780 386876 390012 393483 397557 398247 401541 401856 402007 403411 407322 407409 411721 411883 413984 417081 417757 424011 424847 432490 436732 438118 444376 445669 446012 446316 447847 448698 449082 449389 450030 450773 453232 459359 459622 459863 459899 459917 460425 461923 462075 462907 464254 464457 464529 465460 465484 466224 466999 467682 467818 470258 470691 472178 472924 476397 478347 478656 479178 480513 483592 484777 485327 486136 487176 491124 493087 493972 495732 498616 502061 504005 505578 509346 510305 514854 516074 522547 524844 528500 530112 533731 548039 565302 565865 577725 599674 601074 615390 636463 661954 665199 665303 665436 680279 693419 700825 713247 717837 725244 728937 746713 748362 759714 759762 761815 768375 770176 770563 777932 782460 810112 812385 ] |
||||||||||||||||||||||||||||||
|
151.44 ms (38.82%) |
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 61597 181252 379619 381884 382326 382878 382942 385780 386876 390012 393483 397557 398247 401541 401856 402007 403411 407322 407409 411721 411883 413984 417081 417757 424011 424847 432490 436732 438118 444376 445669 446012 446316 447847 448698 449082 449389 450030 450773 453232 459359 459622 459863 459899 459917 460425 461923 462075 462907 464254 464457 464529 465460 465484 466224 466999 467682 467818 470258 470691 472178 472924 476397 478347 478656 479178 480513 483592 484777 485327 486136 487176 491124 493087 493972 495732 498616 502061 504005 505578 509346 510305 514854 516074 522547 524844 528500 530112 533731 548039 565302 565865 577725 599674 601074 615390 636463 661954 665199 665303 665436 680279 693419 700825 713247 717837 725244 728937 746713 748362 759714 759762 761815 768375 770176 770563 777932 782460 810112 812385 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (4.72%) |
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 446316 450773 465460 466224 480513 530112 510305 498616 528500 493087 577725 548039 665303 680279 693419 713247 700825 565302 615390 810112 777932 812385 746713 748362 725244 761815 402007 411721 436732 460425 397557 407409 432490 459899 476397 486136 491124 505578 509346 484777 487176 522547 181252 61597 403411 417081 445669 459359 478656 450030 472924 446012 449082 449389 453232 464254 533731 601074 599674 782460 768375 770563 759714 759762 770176 728937 438118 459622 470258 417757 459917 462075 464529 493972 524844 495732 407322 393483 470691 385780 382878 382942 379619 381884 382326 390012 386876 398247 401856 401541 411883 413984 424011 444376 424847 447847 448698 465484 479178 478347 459863 461923 467818 472178 502061 504005 514854 516074 462907 464457 466999 467682 483592 485327 665199 665436 717837 661954 565865 636463 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс толстые женщины"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс толстая"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс толстая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.45%) |
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.