Query Metrics
7
Database Queries
7
Different statements
292.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.84 ms (91.58%) |
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 233143 382585 391662 392037 392937 396757 403419 427437 428382 437658 441910 443706 444344 453615 455830 457420 460697 462001 465386 465875 476776 476882 484144 487656 490210 492708 493174 493997 495664 495741 498257 504652 505068 505446 506278 506463 509701 511250 512275 517599 518003 521480 521894 522779 523838 542118 552093 552679 555017 560392 561454 564320 577733 592230 595306 599040 605923 612457 612873 621447 628213 652878 654006 656784 657393 659277 661289 668074 673185 682958 689099 692171 707164 712283 713931 721489 722997 728682 730052 736933 737049 741401 742466 745509 745513 747368 751106 754126 758416 763128 763571 764260 767081 768466 772836 772987 777228 779316 779572 785085 785776 786576 788009 788715 789118 789148 789249 801266 802215 809347 816178 816185 818031 818135 820228 821593 821807 821819 823366 825319 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (4.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 682958 668074 692171 786576 779572 751106 768466 490210 505446 518003 396757 403419 652878 605923 612873 788009 745509 742466 754126 785776 441910 555017 560392 592230 476776 465875 523838 487656 521894 444344 437658 465386 392037 512275 564320 443706 505068 453615 476882 511250 498257 821807 816185 818135 821593 659277 654006 707164 595306 789118 789249 772987 764260 767081 730052 612457 233143 506278 484144 552679 428382 460697 522779 504652 506463 661289 747368 457420 495664 391662 392937 818031 820228 821819 825319 823366 542118 657393 689099 656784 673185 621447 628213 788715 777228 779316 802215 736933 737049 772836 741401 745513 758416 728682 722997 785085 789148 801266 713931 721489 809347 763128 763571 577733 552093 599040 427437 455830 517599 492708 493174 493997 495741 816178 712283 462001 509701 521480 382585 561454 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (0.94%) |
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 233143 382585 391662 392037 392937 396757 403419 427437 428382 437658 441910 443706 444344 453615 455830 457420 460697 462001 465386 465875 476776 476882 484144 487656 490210 492708 493174 493997 495664 495741 498257 504652 505068 505446 506278 506463 509701 511250 512275 517599 518003 521480 521894 522779 523838 542118 552093 552679 555017 560392 561454 564320 577733 592230 595306 599040 605923 612457 612873 621447 628213 652878 654006 656784 657393 659277 661289 668074 673185 682958 689099 692171 707164 712283 713931 721489 722997 728682 730052 736933 737049 741401 742466 745509 745513 747368 751106 754126 758416 763128 763571 764260 767081 768466 772836 772987 777228 779316 779572 785085 785776 786576 788009 788715 789118 789148 789249 801266 802215 809347 816178 816185 818031 818135 820228 821593 821807 821819 823366 825319 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian bathroom sex"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск ван секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск ван секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.56%) |
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.