Query Metrics
7
Database Queries
7
Different statements
153.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.00 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.31 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex one cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.73 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 768988 511310 634851 724147 593678 314133 72607 447478 407007 415091 684554 598896 775862 724243 750462 758299 817855 581281 651856 705549 610183 625682 807465 815394 575735 642521 728332 398224 573778 577583 628194 818229 521004 558709 543164 703212 771328 459107 473710 444712 516303 487465 567494 799143 815714 540638 493244 551239 556559 684096 599418 620319 732631 789711 493299 516804 390717 814787 474443 556028 550610 666487 772219 611700 423835 514303 525197 814835 575302 568853 693941 583860 630576 773856 463228 464194 451223 580449 635178 602553 487440 486190 497291 525437 584103 511505 525327 762221 533606 417632 445284 814396 559617 386882 502115 488347 551164 721201 619151 455016 464024 467383 438272 814553 554225 683529 613921 792005 249637 524007 511736 506825 495622 191048 537434 486883 576697 552637 566975 549733 ] |
||||||||||||||||||||||||||||||
| 4 | 2.96 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 72607 191048 249637 314133 386882 390717 398224 407007 415091 417632 423835 438272 444712 445284 447478 451223 455016 459107 463228 464024 464194 467383 473710 474443 486190 486883 487440 487465 488347 493244 493299 495622 497291 502115 506825 511310 511505 511736 514303 516303 516804 521004 524007 525197 525327 525437 533606 537434 540638 543164 549733 550610 551164 551239 552637 554225 556028 556559 558709 559617 566975 567494 568853 573778 575302 575735 576697 577583 580449 581281 583860 584103 593678 598896 599418 602553 610183 611700 613921 619151 620319 625682 628194 630576 634851 635178 642521 651856 666487 683529 684096 684554 693941 703212 705549 721201 724147 724243 728332 732631 750462 758299 762221 768988 771328 772219 773856 775862 789711 792005 799143 807465 814396 814553 814787 814835 815394 815714 817855 818229 ] |
||||||||||||||||||||||||||||||
| 5 | 123.23 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 72607 191048 249637 314133 386882 390717 398224 407007 415091 417632 423835 438272 444712 445284 447478 451223 455016 459107 463228 464024 464194 467383 473710 474443 486190 486883 487440 487465 488347 493244 493299 495622 497291 502115 506825 511310 511505 511736 514303 516303 516804 521004 524007 525197 525327 525437 533606 537434 540638 543164 549733 550610 551164 551239 552637 554225 556028 556559 558709 559617 566975 567494 568853 573778 575302 575735 576697 577583 580449 581281 583860 584103 593678 598896 599418 602553 610183 611700 613921 619151 620319 625682 628194 630576 634851 635178 642521 651856 666487 683529 684096 684554 693941 703212 705549 721201 724147 724243 728332 732631 750462 758299 762221 768988 771328 772219 773856 775862 789711 792005 799143 807465 814396 814553 814787 814835 815394 815714 817855 818229 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс one cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.98 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс one cock"
]
|
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.