Query Metrics
7
Database Queries
7
Different statements
170.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.00 ms (83.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 88664 182036 182895 209216 357457 394648 398123 402648 410242 413404 414048 414064 415857 417430 428773 429044 429566 434314 434318 434330 434345 437708 440639 444540 448079 449014 449017 449022 449023 452807 452898 454688 456699 457650 457812 457815 458772 467058 469092 472257 475417 475419 476668 478519 478523 479723 479727 482293 486243 486244 486768 486783 495211 496842 499922 499927 502772 509978 515253 515259 521559 522148 522156 522173 522182 522579 526165 538669 549538 554907 566545 569720 571039 623267 623284 633463 634109 634180 660419 662856 681804 697839 720593 728268 730075 730102 731794 734844 734868 738499 738501 741157 744227 745111 752550 755936 756752 760471 762303 766294 770258 773308 776059 777921 785267 786023 796266 796681 796687 804159 804939 806393 806543 806687 806861 807562 807581 808644 808994 819361 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (10.09%) |
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 755936 730102 738499 720593 796266 457812 209216 479723 479727 458772 434314 449022 623284 182895 394648 398123 444540 486244 452807 486768 807562 478519 486783 402648 429566 428773 429044 502772 734844 731794 804939 773308 623267 796687 770258 807581 182036 566545 569720 806543 738501 806687 744227 88664 448079 449014 522156 515253 633463 634180 808644 730075 808994 752550 776059 554907 414064 741157 806861 413404 522148 662856 785267 414048 449023 482293 415857 357457 819361 456699 449017 457815 486243 760471 766294 478523 410242 495211 515259 734868 475417 521559 475419 434330 440639 571039 660419 467058 417430 469092 526165 476668 434345 454688 457650 452898 522579 756752 434318 509978 538669 472257 762303 697839 728268 499927 549538 634109 806393 786023 745111 777921 796681 804159 437708 496842 522173 522182 499922 681804 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.03%) |
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 88664 182036 182895 209216 357457 394648 398123 402648 410242 413404 414048 414064 415857 417430 428773 429044 429566 434314 434318 434330 434345 437708 440639 444540 448079 449014 449017 449022 449023 452807 452898 454688 456699 457650 457812 457815 458772 467058 469092 472257 475417 475419 476668 478519 478523 479723 479727 482293 486243 486244 486768 486783 495211 496842 499922 499927 502772 509978 515253 515259 521559 522148 522156 522173 522182 522579 526165 538669 549538 554907 566545 569720 571039 623267 623284 633463 634109 634180 660419 662856 681804 697839 720593 728268 730075 730102 731794 734844 734868 738499 738501 741157 744227 745111 752550 755936 756752 760471 762303 766294 770258 773308 776059 777921 785267 786023 796266 796681 796687 804159 804939 806393 806543 806687 806861 807562 807581 808644 808994 819361 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оттрахана секс машино…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.88%) |
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.