Query Metrics
7
Database Queries
7
Different statements
246.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.68 ms (90.21%) |
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 184735 188447 382172 385031 398871 406074 418689 421445 426245 427771 433373 439006 439011 440909 441770 441897 442135 445105 452864 456701 457060 458019 458322 459066 459210 459325 459621 461050 461901 465784 469130 470888 471506 472894 477415 479178 479362 481247 481678 483075 484174 486008 486808 491124 492643 493808 494452 498616 498880 501031 502592 508877 513054 515369 521634 521902 524950 525308 525695 529236 529448 538265 545635 547967 548039 548601 549595 549648 552052 555015 557402 560103 561240 561372 563299 563762 564559 565062 565333 565706 570241 570528 570833 573300 598216 618504 619310 641109 645736 650859 652353 652501 659459 662925 665101 665255 665351 667278 667546 667829 668796 669456 692188 692319 705020 707933 708254 710418 716076 737557 759908 762285 771147 781609 785195 791812 792816 796543 797382 810863 ] |
||||||||||||||||||||||||||||||
|
13.07 ms (5.30%) |
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 427771 426245 459210 461050 477415 459325 486808 481678 547967 560103 561372 645736 692319 708254 652353 652501 659459 662925 668796 549595 573300 618504 781609 762285 737557 771147 459066 479362 398871 440909 433373 445105 459621 521634 502592 525308 513054 184735 382172 441770 418689 442135 439011 486008 498616 564559 548039 549648 665351 667278 705020 563762 619310 797382 796543 188447 406074 457060 461901 465784 481247 525695 491124 508877 810863 385031 458322 570833 692188 785195 498880 570241 557402 548601 565062 710418 716076 665255 669456 707933 561240 641109 759908 469130 521902 479178 470888 483075 484174 515369 565706 552052 555015 667546 665101 667829 598216 791812 792816 452864 456701 524950 529448 494452 538265 492643 529236 421445 441897 439006 458019 472894 493808 501031 471506 545635 570528 563299 565333 650859 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (1.82%) |
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 184735 188447 382172 385031 398871 406074 418689 421445 426245 427771 433373 439006 439011 440909 441770 441897 442135 445105 452864 456701 457060 458019 458322 459066 459210 459325 459621 461050 461901 465784 469130 470888 471506 472894 477415 479178 479362 481247 481678 483075 484174 486008 486808 491124 492643 493808 494452 498616 498880 501031 502592 508877 513054 515369 521634 521902 524950 525308 525695 529236 529448 538265 545635 547967 548039 548601 549595 549648 552052 555015 557402 560103 561240 561372 563299 563762 564559 565062 565333 565706 570241 570528 570833 573300 598216 618504 619310 641109 645736 650859 652353 652501 659459 662925 665101 665255 665351 667278 667546 667829 668796 669456 692188 692319 705020 707933 708254 710418 716076 737557 759908 762285 771147 781609 785195 791812 792816 796543 797382 810863 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс сзади"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс сзад"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.57%) |
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.