Query Metrics
7
Database Queries
7
Different statements
190.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.58 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.07 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"душ секс мама"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.41 ms |
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 396534 814851 482299 455325 484611 569537 618329 808335 805700 816563 570818 727823 411347 500980 451464 496928 390169 423318 445107 721498 582887 541359 555656 386172 443095 814428 534209 794102 507136 656104 712707 639788 421989 745517 591636 305931 396259 814804 762274 411335 815529 517446 505826 486334 631607 481793 391036 462751 462574 563142 491934 518854 506518 462461 577354 560380 647162 193895 633092 582503 471414 391517 449859 573304 776189 764028 773420 806164 633176 720868 574442 744094 758386 770065 718338 454401 818135 763081 523847 188242 486539 476252 604488 779069 438478 510425 3444 146508 591803 794628 793563 23104 467109 384553 543448 444740 437583 465791 505818 719929 703900 490117 766738 482097 443757 460294 792507 566858 760713 203645 531977 636053 586791 791981 773438 514114 514980 389264 513525 397708 ] |
||||||||||||||||||||||||||||||
| 4 | 2.87 ms |
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 3444 23104 146508 188242 193895 203645 305931 384553 386172 389264 390169 391036 391517 396259 396534 397708 411335 411347 421989 423318 437583 438478 443095 443757 444740 445107 449859 451464 454401 455325 460294 462461 462574 462751 465791 467109 471414 476252 481793 482097 482299 484611 486334 486539 490117 491934 496928 500980 505818 505826 506518 507136 510425 513525 514114 514980 517446 518854 523847 531977 534209 541359 543448 560380 563142 566858 569537 570818 573304 574442 577354 582503 582887 586791 591636 591803 604488 618329 631607 633092 633176 636053 639788 647162 656104 703900 712707 718338 719929 720868 721498 727823 744094 745517 758386 760713 762274 763081 764028 766738 770065 773420 773438 776189 779069 791981 792507 793563 794102 794628 805700 806164 808335 814428 814804 814851 815529 816563 818135 ] |
||||||||||||||||||||||||||||||
| 5 | 160.78 ms |
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 3444 23104 146508 188242 193895 203645 305931 384553 386172 389264 390169 391036 391517 396259 396534 397708 411335 411347 421989 423318 437583 438478 443095 443757 444740 445107 449859 451464 454401 455325 460294 462461 462574 462751 465791 467109 471414 476252 481793 482097 482299 484611 486334 486539 490117 491934 496928 500980 505818 505826 506518 507136 510425 513525 514114 514980 517446 518854 523847 531977 534209 541359 543448 560380 563142 566858 569537 570818 573304 574442 577354 582503 582887 586791 591636 591803 604488 618329 631607 633092 633176 636053 639788 647162 656104 703900 712707 718338 719929 720868 721498 727823 744094 745517 758386 760713 762274 763081 764028 766738 770065 773420 773438 776189 779069 791981 792507 793563 794102 794628 805700 806164 808335 814428 814804 814851 815529 816563 818135 ] |
||||||||||||||||||||||||||||||
| 6 | 1.82 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван секс мам женщин"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.49 ms |
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.